Best Answers

Hello, its me again.So I’m playing with changing excel documents in Form 2024.1 and its going superb, except from the fact that when Form writes out my changed excel it adds an @ in front of some of the formulas. So for example the formula that gets read in as:=XLOOKUP(blabla)Gets written out as:=@XLOOKUP(blabla)Which then makes the whole outcome excel document breaks.I have ran this with caching and see that at last cache before writing then the formulas are intact, so this must happen in the writer or that the excel gets written out in some manner that my excel setup *misunderstands* it?As always, all comments are welcomed (as long as you not a person just looking to score some points by copy/pasting what AI said the problem was).-Hlynur

Hello yet again.This time I am experimenting with a complex Microsoft Excel document, its basically a calculation file that contains quite a lot of sheets, macros, references and formulas. Idea is that instead of sharing the excel document with the people that need to use it that I would just host it on our Flow, people would then have an option to fill out some published parameters in a flow app and then get a single excel sheet returned with their results (cutting out all the underlying datasheets and formulas and macros etc).Or to sum it up: I have a complex excel with formulas, read that excel in FME, change values in cells in FME, write out an excel from FME that would then recalibrate/recalculate based on those changed values.So I have figured out how to single out cells in the excel table where (basically using counter, and tester for that single number, link to attribute manager where the new value can be inserted to replace the old one, back to a FeatureMerger to put the new v

Is there a resource/database somewhere that has a list of what FME release each version of a transformer was initially released/updated in? You can get it pretty easily for transformers on the Hub, but not for inbuilt transformers.I’ve had a dig through the various Python APIs and I haven’t come across anything (doesn’t mean something doesn’t exist mind you!).Each version of FME does come with the previous versions of the transformer, otherwise this would break the backwards compatibility of the software.

I have an excel file with 100 records (100 rows) with 5 columns. I have a process that will filter one record to update one column field called ‘Last Update’ in that particular record row. So The column ‘Last Update’ for that 1 record should be updated and the rest of the 99 records will remain the same. Keep in mind that the one record being updated, only one column is to be updated which is the Last Update column and the rest of the columns fields will remain the same.  How can I configure the FeatureWriter?I currently have the following set in the FeatureWriter Parameters and in the configuration but this does nothing. The excel sheet  looks the same as before with all 100 records the same and the one record that Im looking to update does not have the Last Update column updated.  If I do an Insert, it updates that one record column ‘Last Update’ but the rest of the 99 records are deleted, which I don’t want. So the Insert is not working for my purpose.Thank you. 

I believe there is the possibility to configure user parameters in a way that they take a local path for in/output and when they are going to be published the provided alternative for the FME Flow resources path is used.I cannot find my bookmark on how to do this and did not come to anything useful when searching the net.Does somebody have a tutorial on how to configure the user parameter that it uses the local resources when run in FME Form and the FME Flow resources when run in Flow?

Hi I’m currently trying to acces the documentation of the API I'm making using data virtualization. The Swagger documentation page loads, but it seems to fail to get the correct server on which I have made the API. Due to this I can’t test any of the API calls. This is the link to the swagger documentation: https://fme-acc.nordend.eu/fmeserver/swagger-ui/?api=2fd53796-610d-4fb6-8a92-5c05335568e7#/default/getCollectionsThis is the error that chrome runs into when loading the web page.  Does somebody now what the issue could be? I have no reverse proxy on the server so I don’t think it is the same as what is described here: https://support.safe.com/hc/en-us/articles/37949819750541-Known-Issue-Data-Virtualization-API-docs-don-t-load-with-IIS-Reverse-Proxy Thank you in advance for your time, and if anything is unclear I can always explain more.

This morning I tried to import data using a WFS concerning a Dutch data source. I got into a weird error:Used WFS: service.pdok.nl/kadaster/kadastralekaart/wfs/v5_0?request=GetCapabilities&service=WFSDoes this look familiar to someone?

Hello. Fairly new to FME, so might be a bit over my head.I’m trying to create a validation workflow that compares 50+ files against 3 main ones. They all have the same structure, except the geography field name that is to be used for the comparison.The 50+ files are all named with a similar structure > final_DOMAIN_GEOG_Distance or final_DOMAIN_GEOG_Driving. Pretty much the files are divided by domain and 3 geographies.The 3 main files are a compilation of all domains and GEOG. My thought process was to have 2 csv readers (1 for distance and 1 for driving) and a few parameters that would read the user choice for domain and geography and read the csv accordingly. I have two issues:the parameters for file path seem to work but the csv schema remains the same (eg, it’s reading the original reader before adding the parameters), so it doesn’t update the field name with the geography, when it’s different form the original one is it possible to create parameters that can be used in the tra

Hi ExpertsNeed your support and Guidance.I was having p scanned PDF and exported a page of the map which was of 1984 and I need to extract the Points with location details with size of each point size so that i can differentiate them based on that.Main challenge is how to georefence it and I have vector file for the province and Extent and 30 M grid i was able to secure that but How can i proceed to georeference and get the details.Kindly Guide and support.I have attached the Image file with GDB of it https://drive.google.com/file/d/1SZXkbyDlMxL_cE0FPsiHKuuECl7k6HrW/view?usp=sharingThanks

When I go to publish my workflow from form to flow I get this error: However when I go to run it on flow, I get an error saying that it doesn’t exist: 58 2025-9-23 12:18:08 | ArcGISFeatureServiceReader: Connection 'connectionname' does not exist. Check connection parameter and connection definitions in FME options and try again59 2025-9-23 12:18:08 | Python Exception <NamedConnectionNotFound>: FMEException: 1: ArcGISFeatureServiceReader: Connection 'connectionname' does not exist. Check connection parameter and connection definitions in FME options and try again60 2025-9-23 12:18:08 | An error has occurred. Check the logfile above for details61 2025-9-23 12:18:08 | The below feature caused the translation to be terminated77 2025-9-23 12:18:08 | FeatureReader_2_<Rejected> (TeeFactory): FeatureReader_2_<Rejected>: Termination Message: 'FeatureReader_2 output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' &gt

Hello FME brains trust. I have a situation where I need to run a regular update that takes a supplied point and looks up a corresponding lot and plan (cadastre) and add it as an attribute to the point. I am currently using the Point on Area overlay transformer, which works, but the updates are only one or two points, and our parcels layer has over 3 million features, which takes quite a bit of time to read and run.I am hoping that there might be an alternative that basically runs a spatial query on the server side and only brings in the intersecting parcels or any other options that might help me streamline this process.

Hi Everyone, I have a java-based custom transformer built with the FME plugin SDK.  I created an HTML help file for my custom transformer, and I would like to link it to the transformer, so it can be displayed in FME Form when I right-click on the transformer and click help.  Where does the HTML file need to be placed, and where/how do tell the transformer about the help file?  Do I need to add something to the .fmw or the .java file, or both?  If so, do you have examples or documentation on what code needs to be added? Thank you for your time!

Hello,I would like to decimate my point cloud to keep one point every meter for example.I tried PointCloudSpatialThinner but i suggest it extrapolates the coordinates to fit the best to the original cloud point.The problem I have is I can’t change z-coordinates. Optimally I’d like to decimate my point cloud only on the x and y coordinates.Does someone have a solution ?Best regards,Gurvan

Hi, I am getting this error:An error occurred while attempting to insert a row into the table ‘ABC’ using a cursor. The error number from ArcObjects is: '-2147217323'. The error message from ArcObjects is: {The cursor has been invalidated by an edit operation.} I am experiencing an issue when trying to insert features into a feature class stored in an enterprise geodatabase. Specifically, I am both reading from and writing to the same dataset. I haven't encountered this problem before, but it began after I set the Feature Operations to "Upsert" while updating existing records and inserting new records that are not yet present in the database. I suspect that performing inserts and updates simultaneously may be causing a disruption with the cursor. I also attempted to use the Feature holder, but I received the same error. This disruption is affecting the automated process. Does anyone know what might be causing this error or how to fix it? I would greatly appreciate any assistance!Thank

I am having some difficulty normalizing reverse geocodes for comparison from one Geocoding Service to another (in this case OpenStreetMap).  The _address that is returned can pretty easily split up into a list or separate attributes with most services as they are consistent. However, OSM’s _address has extra information and parsing it to be consistent with anything else has been a challenge.  See below where instead of having an AddressNumber, a null, or a 0, I get Falmouth Public Schools & Moonlight Meadery in the 1st position.  For that matter, I sometimes get supplementary place names such as Seaport & South Boston when expecting a Town in a particular separation/position.  So it throws off looking in any specific list due to the inconsistent placement.Some are normal, but many either don’t contain the expected info, or add info that is unnecessary for my needs.What I want to make into attributes: AddressNumber  Street  Town  State  ZipCodeOpenStreetMap gives me this in a te

Hi, I am looking into renewing my FME certification in the coming months. It is the first time I will do it proctored. Does anyone have negative experiences with Talview where you couldn’t use FME Form, FME Flow as described here: https://www.reddit.com/r/fme/comments/1dl0647/has_anyone_completed_fme_certified_professional/I understand you are supposed to be able to use the applications and help documentation during the exam. Thanks,Annette 

I would like to add the following folder, named "moi”, to my top level resource folders, and add it to the list in the picture below. I couldnt find that much information about it online, and i tried something, but it didnt work. I located the folder in the FME Flow program files, and added the folder, but that didnt work. It doesnt show up in the top level resources list, Does anyone know if it is possible to do this? And how?  Thanks in advance!  

Hi everyone,I’m running into an issue when using the FeatureReader transformer.When I read a table through the FeatureReader, the attributes are not exposed  However, if I read the same table directly using a normal FME reader (through SDE or GDB), all the attributes are properly exposed.Is there a setting I’m missing with the FeatureReader that prevents the attributes from being available? Or is this expected behavior when using it compared to a standard reader?Thanks in advance for any advice!

Hello my fellow FME’ers,Probably I'm missing something or I stumbled upon a bug, but I can't get something to work like I expect. Maybe someone can point out what I'm missing. Workspace snippetMy data is going trough a Matcher to find features that belong to the same object. I then sort them on _match_id and an attribute called lighted.  Result of Sorter_4As a result I have something above. If lighted is null it will be the first feature.In the AttributeManager I use Adjacent Features to look 1 feature further and have the following condition statement for a new attribute called _filter. The second one is another attempt to get the same result, but that also doesn't work. Conditional statement Alternative conditional statement I triedI expect the two <null> values in the screenshot above to get the value ‘yes’, but it doesn't. What am I missing here?

I would like to add the following folder, named "moi”, to my top level resource folders, and add it to the list in the picture below. I couldnt find that much information about it online, and i tried something, but it didnt work. I located the folder in the FME Flow program files, and added the folder, but that didnt work. It doesnt show up in the top level resources list, Does anyone know if it is possible to do this? And how?  Thanks in advance!  

I’m working through the Create a Manual Endpoint in Data Virtualization – FME Support Center however when it comes to the Make a Request from the Documentation section and clicking the ‘try it out’ button in the Swagger page, I get the following 401 response:Is this related to the time which the error lists as 15:48 GMT, however we’re on BST in the UK at the moment so it’s actually 16:48?  If so, how can I resolve it? Otherwise is it a simple authentication issue? - the tutorial says “the EnvionData API is authenticated by default” so I’m a little confused by this.

The Documentation for the @DateTimeFormat Function clearly states that parsing ISO 8601 format is supported:“Formats FME or ISO date, time, and datetime strings into a custom format [...] Arguments: <datetime> [...] Date, time, or datetime string in Standard FME Date/Time Format or ISO 8601 date and time format.”, so using PT1H as datetime Argument should be valid.But the Parsing of ISO 8601 date and time format fails:AttributeManager: Failed to parse 'PT1H' as a datetime value. For FME datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm . For ISO datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm#ISO-8601-Duration-FormatFailed to evaluate expression '@DateTimeFormat(PT1H,%H)'. Result is set to null FME Form 2025.1.2.0 (20250829 - Build 25630)

Hi,I’m having trouble with AmazonBedrockConnector and I believe it’s an error with how the transformer has been authored.The issue is that the transformer processes and outputs the square of the number of input records. If I input 13 records, it will process 169 (to AWS Bedrock!), and then output them. If I input 313 records, it will attempt to process and return 97,969 records (I’ve found this out the hard way).By embedding the transformer and then editing it, I was able to view the flow of information from a source workspace. The issue seems to be in the calling and validation of AWS Inference Profiles, in that they are checked to be active, and then joined back to the original input records (obviously to allow error checking and rejection). As downloaded, the transformer looks like this:Note that the 13 input records are joined back against each other to create 169 records that are ulimately sent to the Bedrock API. I can see no valid reason to keep all of the original records out o

After a week+ of trial and error I wonder. Have anyone managed to create an FBX-file with FME that contains terrainmodel + ortophoto draped on top. That can be opened WITH materials/texture directly in Navisworks? I have tried all settings - but can not make it work. The files open correctly in FME Data Inspector, Autodesk FBX Reviewe, 3dsmax, Lumion and even Infraworks. And also the export from Infraworks to Navisworks work OK! However I cant seem to be able to open the FBX-file directly in Navisworks - it only shows the terrain with no texture/material. Even when it shows the texture in the "materials" pane. Material is added on a Mesh-group and displays nicely before writing and as mentioned in the other software above.Some stuff I have tried:- All settings on the FBX-writer- Manually changing the scaleuints on the ASCII- file from 1 to 100 to scale to meters instead of default cm. It seems that there is some scaling issues between geometry / material or bug related to mat

Hello, I just upgraded to FME Form 2025.1.2 and am having a problem with the Google Sheets Reader. The Reader previously worked in FME 2024.x, but I am now getting a very ambiguous error whenever I try to read a sheet into a workspace. I literally just upgraded this morning after initially opening the workspace in Form 2024 and successfully running it, so I know nothing has changed on my computer or anything otherwise. Any ideas what I am doing wrong?