FME Form

I’m reading Survey123 results into FME where one question allows multiple selections. The answers come through as a comma-delimited string (e.g. Need_PD,Need_TMA,Frozen).I want to validate the responses against a known list of allowed values (CSV/XLSX), so that: each selected value is validated individually any invalid or new value (even if it hasn’t appeared yet) is flagged I don’t need to handle every possible combination of selections I understand that Tester “Cached Values” only shows existing data values and that Survey123/ArcGIS domains aren’t directly usable here.What is the recommended transformer pattern to: split the multi-select field so I can edit testers for looking for certain selected options and not others

This is really strange—I’ve never seen this behavior before.After saving and closing my workbench, all other FMW files in the same folder disappeared automatically.At first, I thought I was imagining things, but other users have reported similar issues before. [Post link]Version: 2024.2.1 (Build 24801)OS: Windows 11 24H2 (26100.2894)The only change I can recall is that I recently uninstalled all old FME versions, but that shouldn’t somehow trigger file deletion, right?

I have a list of points which I want to connect to lines. But one line should contain only points with a specific value in a field. At the end I want to have multiple lines in one feature class. How can I do that?

I think the answer is No, but I hope someone can tell me that I am wrong.I want a user to be able to select any existing database or webconnection for a custom transformers. Is there a parameter that allows me to do that?Why I don’t think it is possible:Existing parameters require you to select a database format first webservices python doesn’t offer the capability to get a connection without knowing its name 

Hi all,I’m currently working with several Revit files hosted on ACC, and I have put together a workflow that can read a specific ACC folder and identify a federated model. The process successfully reads and downloads the host file; however, I have been unable to download the associated linked files.Is there a way to use the AutodeskDocsConnector to access and retrieve the linked files as well?Thanks :)

I’m not sure if this is a bug in FME or if it’s expected behavior. We work in versioned, replica file geodatabases. The issue that has presented is that when our data was being checked back into the Enterprise database, the change records in our replica were being applied to features outside of the AOI of replica. In other words, somewhere in our FME processes it was not managing the OBJECTIDs in the INSERT/UPDATES/DELETES tables correctly. We believe we have tracked it down to the ‘Fast Deletes’ parameter of the FileGDB Writer. From my research it looks as though this truncates the tables, and re-inserts the features that weren’t deleted. I’m also reading that this may cause issues because it bypasses the A/D change tables. This tracks with the errors we are seeing.Is there any validity to that? If so, I’d like to suggest that the Fast Deletes parameter be defaulted to ‘No’ instead of ‘Yes’.

I have a source SDE Geodatabase reader and destination File Geodatabase writer, both with the exact same attributed relationship classe schemas. The File Geodatabase being written to is blank (I’m using a template) and I don’t need to re-establish any relationships, I want to write the records exactly as they appear in the SDE Geodatabase, to the File Geodatabase. I’ve read in feature types using Ignore relationships, making them type geodb_table, and the destination feature types are also geodb_table (though obviously both are in fact attributed relationship classes).FME (2024.1.1.1) seems to want to recognize the writer feature types as relationship classes, no matter how I define them. I don’t want to have to establish the whole geodb_rel_origin_oid and geodb_rel_destination_oid values since I know what they should be already from the source (and there is no common attribute between the two source relationship class tables anyways). Is there a way to forc

Hi, a client is using nb_NO (Norsk Bokmål) Locale on a Windows Server machine and the produced FFS filename is incorrect. They are using FME Form 2024.2.3.0.I have tested same om my machine Windows 11, FME Form 2025.1.1.0 - build 25615. I want to produce a filename “t2_æøå”.FFS (where æ, ø and å are Norwegian alphabet letters)using en_US Locale the produced file is t2_æøå.FFS using nb_NO Locale the produced filename is t2_æøå. FFSI repeated the test wiriting to Esri Shapefiles - and both Locale will give the result t2_æøå.shp. Seems like the FFS writer have an issue with Locale. Might be a known issue  but I was not able to find it. Thanks 

Hi,We see that AI is gradually being integrated directly into ArcGIS workflows — and increasingly into other GIS platforms as well. I’m therefore curious about the status and direction regarding AI within FME.Are we likely to see developments such as: Natural language interaction with FME (describing what you want to achieve rather than manually navigating specific transformers) Built-in dataset analysis with automatic detection of inconsistencies and suggested corrections AI-assisted workspace generation based on existing patterns and usage — for example, proposing or automatically building new workbenches based on previously created workflows when you need it More generally: How does SAFE see the role of AI evolving within FME? When can we expect more visible AI-driven functionality in FME Form and Flow? Are there upcoming releases, beta programs, or

a file like the following.I am reading it using a Text Reader dataset in XML format.I would like to use XML Fragment / XML Flattener to extract the Name attribute and its value, but I always get no result from the XML Fragment.I am not sure what the reason is. Could someone please help me?Thanks in advance.FME 2021<processXMLRequest  ><field ><name>text1</name><value>value1</value></field><field ><name>text2</name><value>value2</value></field><field ><name>text3</name><value>value3</value></field><field ><name>text4</name><value>value4</value></field><field ><name>text5</name><valu

Hi.I’m looking into whether I can use InlineQuerier for a Workbench validation of data using a list of criterias.One of the things I need to do is use RegEx, and is thus trying to use the REGEXP construct mentioned in the documentation. However, this is the error I’m getting:InlineQuerier_2 (InlineQueryFactory): Error preparing database query: no such function: REGEXP Unable to execute statementThe full query is here:SELECT * FROM "Data" WHERENOT(("tvaersnitsform" IS NULL OR "tvaersnitsform" REGEXP '^(other: )[0-9a-zA-ZæøåÆØÅ]{2,}$' OR "tvaersnitsform" IN (SELECT "key" FROM "LOOKUP.Tvaersnitsformtype")))If I remove the REGEXP part of the criteria, it works just fine.Has anyone used InlineQuerier much, and have some insights into what might be wrong here ?Is it just a subset of SQLite’s SQL language being available in InlineQuerier ?

Recently our network has been segmented which causes an issue with sending mail (emailer transformer) with FME Form from server X using an smtp mailserver which is in another part of the network. A firewall has been added in between these two. The firewall blocks mails being sent because fme form (20241202 - Build 24801 - WIN64)) supposedly uses an outdated version of OpenSMTP giving this issue: CVE Record: CVE-2020-7247Does anyone recognize this? It seems to be an old issue dating back to 2020. I would expect this to be solved in a 2024 version. I can't find anything in the documentation. Help would be appreciated since I know very little about firewall, mailservers etc. 

Hi.I have built a workspace for data generation that runs for several hours. To log the process input for documentation purposes, I write them to an FFS file, that is about 765 Mb. It includes both spatial and non-spatial data.I now try to open it in Workbench (2025.2.1), but it fails with this error message:No geometry mapping entry found for 'varchar(200)' in metafile 'C:\Program Files\FME 2025\metafile\FFS.fmf'. Please visit http://www.safe.com/supportHowever, the curious/funny thing is, that I can open the file in the Data Inspector program without any errors:What can be done to remedy this ? Are there any work-arounds for this error ?

Hi,I am currently working on an assignment in FME and have run into some difficulties regarding how to structure the workflow to meet all the required criteria.In particular, I am unsure how to best combine the distance requirements. For example, how to approach buffering and overlay operations to ensure the area is within the correct distance from both the sandy beach and a major road, while also being sufficiently far from buildings. I am also uncertain about the most logical order of steps to avoid creating an unnecessarily complex workflow.I would really appreciate any advice on how to approach the structure of this task in FME in a clear and efficient way. I am mainly looking to better understand if there is any other transformers who would make the workflow more efficient?Thank you in advance for your help.Best Regards Anton

I am using the Precisely MapInfo Extended TAB Writer to generate a MapInfo table that is over 2GB (total) in file size. I estimate it should be between 3GB and 4GB in size.I am indexing five attribute columns in the table.And the process of indexing the attribute columns is extremely slow.When I do not index any columns, it takes about 20 minutes to Write the tableWith indexing the columns, it can run for twelve hours before I halt the process in frustration to check my process.Does anyone have any experience of this? Is the Precisely MapInfo Extended TAB Writer just bad at generating indexes?

I’m working on trying to automate some of my company’s reporting, like the one partially shown in this screenshot. So far, I am able to get pretty much most of this information through to the Attribute Pivoter, but I am pretty new to getting this information properly into a Google Sheet. I have the Customer side (left side) and Company side (right side) going through separate channels because they’re from different layers...and I’m starting to wonder if it’s even possible to populate this information in this way from Attribute Pivoter or if I should just switch to separate tabs within the Google Sheet. Second screenshot is what the attribute pivoter summary results look like for the right hand side which is essentially what I want...just not broken down the way I want. 

Hi everyone,In FME 2023, does anyone know the correct way to create a 3D vector starting from a list of 3D coordinates referring to two different moments in time?In the past, it was possible to connect two Vertex Creator transformers to generate a 3D vector by linking two 3D points. However, it seems that this is no longer possible in the same way.Any suggestions or alternative solutions?

Hi, I am having a problem with FME doing truncates/inserts to an ArcGIS Online hosted layer. Sometimes the number of records in AGOL is 1000 more than FME says it is writing. If I run FME again it is 2000 records too many, 3000 when run again. This is happening in Workbench and Server 2020.2 but does not happen all the time. Features per request in the writer is set to 1000. This has not been a problem writing to other formats and I have other FME services writing to other AGOL layers without issues. Thanks, David

Hello Forum, I need to run a polygon-in-polygon attribute update process. I would normally use the AreaOnAreaOverlayer transformer for this where I know that features from the first polygon dataset are all fully within any individual feature from the second polygon dataset. But I now have a dataset where any feature from polygon dataset 1 could be… a) fully within a given polygon from polygon dataset 2, b) straddling between two or more polygons from the other polygon dataset. This is what I need… If a feature from polygon dataset 1 is fully within a feature from polygon dataset 2 then populate a new attribute with the value of the feature from polygon dataset 2 If a feature from polygon dataset 1 is partially within two features from polygon dataset 2 then populate a new attribute with the values of the two features from polygon dataset 2. These diagrams explain it further….

Hello, I have a dataset containing an attribute PROP_TYPE. This contains any one of the following values: HOUSE_MNGD; FLAT; DUPLEX_SHRD; MAISONETTE; FLAT_TYPE2. I want to change these values within the FME Form workspace… HOUSE_MNGD change to House managedFLAT change to FlatDUPLEX_SHRD change to Duplex sharedMAISONETTE change to MaisonetteFLAT_TYPE2 change to Flat type 2 I know I can change a stated value within a StringReplacer. This works well, but it’s only on one of the possible values (e.g: Text To Replace = HOUSE_MNGD; Replacement Text =  House managed). How can I use the StringReplacer to specify all possible values within the PROP_TYPE attribute and replace them with the values I then specify? And do that in one

I'm trying to read a OGC geopackage which contains fields of the type 'datetime'.In FME 2025.1 (which uses version 16 of the FeatureReader) something unexpected happens: in case the number of seconds starts with a 0 (zero), this zero gets dropped after reading the data. See record 21 in the screenshots for an example:In FME 2025 the field ‘tijdstipRegistratieLV' misses a 0 after the '1009' (10 hour 9 minutes).In FME 2023 the readout is correct: 20101214100907 (2010 december 14th, 10 hour 09 minutes 07Is this a known issue/bug?

I have a simple job reads points from a spreadsheet and buffers my pipeline. I would like to set up the SpatialFilter to see which points on the spreadsheet are outside my buffer.  For some reason, all points go to the Failed port. I have exported the buffer that is created and verified they correct and most of the points fall within the buffers.  Any tips are appreciated! 

Has anyone had success with using the updated 2025.2 Excel writer to write data to a table in Excel?  I see that this idea was implemented with 2025.2:  Excel Writer: Explicit Table Support | CommunityHowever, the instructions for the writer don’t go into a lot of detail on how to have the writer create a new table on a sheet and load it with the incoming data.I personally tried to follow some of the older demo’s that walk throughs for writing to a named range.  Those walkthroughs require you to create a template xlsx file with the named range already created.  So for my 2025.2 test, I create a new template.xlsx file, then created a table named tData on Sheet1.  The table is blank.  After that I created some dummy data in FME and tried to write it to a new excel file using the template.  The output excel file does l

I’m working in an FME Form workbench reading in CSV files that reflect database updates and then using them to update a central XLSX file. However, when the CSV reader is pulling in a column with values of either ‘TRUE’ or ‘FALSE’, it is automatically converting them to ‘true’ or ‘false’.Has anyone ever noticed this with a CSV reader?Unfortunately the domain I am describing with this data has capitalized values, so reporting the codes as lower case somewhat defeats the purpose. I know the parameter for Case Sensitive Field Names would resolve the issue if i were seeing this in the attribute names but unfortunately i haven’t been able to find a similar parameter for the data itself.Is this just an inherent setting to the CSV reader format?

Hi All,I am currently working an automation process to convert XYZ files into LAS format for use in ArcGIS. I have successfully generated the point cloud and exported it to LAS; however, the classification information is not being retained.The custom classifications are based on codes contained in the original XYZ files as text, and these values are stored in a table, an example of which is shown below:  How can I convert the XYZ files to LAS while preserving the Feature attribute as the classification?Attached fmwt fileThanks :)