FME Form

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 public roadmap information related to this? FME is deeply integrated into our infrastructure and data management workflows, and

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><value>value5</value></field><field ><name>text6</name><value>value6</value></field><field ><name>text7</name><value>value7</value></field><field ><na

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 ?If I click the dialog Help button, it leads me to a page, that clearly shows REGEXP.Cheers.

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 ?Cheers

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…. Is this possible in FME Form?  Thanks,

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 StringReplacer? I’ve tried AttributeValueMapper and added in all my possible changes (line by line), but I couldn’t get that to actually change the values in the output. So, I’m hoping I can do it in one command within one StringReplacer. Thanks,

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 load the dummy data onto the sheet, but it doesn’t go into the table.  And actually my table disappeared from the sheet.It would be great if there were some tutorials out the

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 :) 

Dear community,I am currently working on FME Workbench 2025.0. My project take into entry areas in 3D that represent buildings roofs. It then spreads the data into two datasets: roofs and building using the latest ground footprint. In order to do that, I am using the 'Dissolver' Transformer with the Group Processing option on. My issue is that some of the edges inside the building are remaining because they do no fit on the Z axis (see screenshots below). Dissolver operation: purple edges are classified as ‘Remanents’ after the operation, red one remain.Result of Dissolver : on a 2D perspective, internal edges are remaining.For better context: the result of the Dissolver from another perspective in 3D.I tried to flatten the surfaces before proceeding to disolving the objects (these objects corresponding to 'Building' will be flattened at some point of the workbench anyway), but still the same edges are remaining. Thank you for your help.

Hello,My team has developed a workspace for data collection of publicly available GIS-data. The workspace uses HTTP-callers to download the data from different URL:s, and then the data is clipped from a predefined area of interest. The schemas and the features area separated and the rejoined later in the workspace. The output is written to an ESRI Geodatabase. Everything is working fine using FME Flow 2023.2.2.0 - Build 23781, but when I tried upgrading to FME 2025, I get an error:“Esri Geodatabase Writer: Feature Type Definition 'd_y_n' was requested, but not defined. Please visit https://www.safe.com/support”Does anyone have any insights into this issue?Thanks in advance /Ville

Hello!I am trying to make sure that we have compatibility across all our different platforms. Our organization has recently upgraded to ArcGIS Pro 3.6. I was taking a look at the compatibility matrix and noticed that for ArcGIS Pro 3.6 is says the minimum FME version to have is 2025.2. Does this mean that FME Form and Flow 2025.1 cannot be used with ArcGIS Pro 3.6?Any help is greatly appreciated!

Hi , I am working a lot of the DWG files and I had somebody did the work. So when I  received the DWG files and review them.  I have ArcGIS Pro and I looked at them and I was not sure about the  coordinate system there… so I pulled the file in FME Data Inspector and found them that they are not in the right place I am in Colorado…Question first is : What does the red symbol mean here ?Black square with blue point is where the DWG is. The record information shows the coordinate system is Unknown.

Hi all, I’m fairly new to FME learning a lot but still get stuck at the odd point.II’m using attribute manager to set 2 attribute values to later be used in httpcaller. here I am setting the values and trying to use the values in the below url.  this is going through to the url without the actual value. I have tried both the ${myvalue} and @value() methods but both simply put what i’ve written below into the actual url but not actually the values.  I used the logger to view the above values and they are definitely showing as 100 and 1 but I can’t get them to show up in the below url. Can anyone direct me to what I’m doing wrong here?   

I have an excel file that has changing header position at every ingestion. The header is randomly stated into any row position and before the header data is populated until row 4 (not always stable). I have been using these configuration where the Field Names Row is set to 1 and Cell Range is blank by default. However when the different file is ingested, these values automatically changes to 1 and 2:as attached in the screenshot.  I tried changing the attribute definition to manual, however it terminates the translation when the feature type changes. What is the best approach to this issue given that the names in the header remains always stable? 

This seems pretty basic so it’s probably a configuration that I’m missing, but I’m using FME Form v2025.1.1.0 and I have a half dozen Loggers set up to capture features that are repaired or failed in GeometryValidators that precede them.  When I run the workbench I have ‘Enable Record Counting’ set so I can see the counts going to the Loggers, but none of the messages I would expect are getting written to either the Translation Log window in FME Form nor to the log file on disk.  I’ve set the Navigator > Workspace Parameters > Log and Troubleshoot > Max Features to Log to -1 to log everything, and I’ve confirmed that the ‘Severity Level’ in each Logger is ‘Information’.  I’ve tried all 3 settings for ‘Feature Logging’ of ‘Log Only’, ‘Log and Record’ and ‘Message Only’ in various combinations of the Loggers and I’ve confirmed that the ‘Max Messages to Log’ for each Logger is larger than the number of features being routed to them. The expression in each Logger is pretty simple,