FME Form

Hello all!I have a question regarding accessing data in an Enterprise Geodatabase in a branch-versioned Feature Service scenario:Using FME’s Esri Geodatabase (ArcSDE Geodb) Reader, can I read branch-versioned feature classes directly from my Enterprise Geodatabase (SDE connection) now that I have published a branch-versioned Feature Service? If I point it to the “sde.DEFAULT” version, will it access the features correctly?I would like to perform some heavy geoprocessing tasks, and my Feature Service performance isn’t keeping up, so the Esri ArcGIS Connector is a no-go

Hi.I'm looking for a way to compute the average while excluding outliers. This average is based on 5 attribute values for each record. To expand, i am QCing pole counts within permits. Each permit is a record. There are a bit over 10k records. I have 5 attributes, with pole counts, each coming from a different source.Example:permit a, pole counts = 1, 4, 5, 28, 6permit b, pole counts = 2, 10, 14, 80, 12Manually, for permit a, i'd exclude 1 and 28 and my avg would be 5. For permit b, i'd exclude 2 and 80 and my avg would be 12. The final goal for this exercise is to pick the value closest to the average computed without outliers. Pls help. Thank you.

Hello I’m experiencing some issues using Dissolver. I want to take a polygon dataset which contains 160,455 independent polygons objects. Some of the polygons overlaps with other polygons. Some are not overlapped by others. I want to merge all of the polygons, whilst dissolving any overlaps, to create just one polygon object. Using Dissolver I am only able to merge polygons where they are overlapping, whilst input polygons that are not overlapped by other are remaining unmerged. This means that I’m getting 80,090 records in the output. But I don’t want that. I want just one polygon object as one record. This diagram illustrates (conceptually) what I have, what I’m getting with Dissolver, and what I require.How do I use Dissolver to do this? Or should I use a different transformer.

I am using the AI-assist within FME Workbench very often. last time was yesterday.unfortunately today i am having troubles to see my history and cannot start a new chat.i am getting an unknown error.even when i am logging out and logging in again. we also checked our firewall for any blocked sites and traffic.are there any issues? kind regards.Laurens

I have a workspace that works without issues in FME 2024.2.1. We are planning to upgrade to FME 2025, but I am facing issues. When riunning the workspace in FME 2025, it seems to work fine, but after a while I get lots of a recurring message like this one:2025-06-02 11:38:25| 119.2|  0.2|ERROR |FFS reader: Failed to open file 'D:\FMETemp\wbrun_1748852462857_30000\fmetmp_0\FMETable_1748853274266_18156\FTShim_1019.fts' for reading.  Please ensure that the file exists and you have sufficient privileges to read itThese messages DO NOT appear when running the workspace in FME Form/Flow 2024.2.1I have tried FME Form/Flow 2025.0.2 and FME Form 2025.1 (beta) and all of these fails.I have set my FME_TMP environment variable to D:\FMETempDoes anyone have an idea?

I’m using the Esri Reprojector transformer with a feature reader that reads feature classes from an ArcSDE connection. They all share the same coordinate system and I need to transform them. I can do this successfully using three separate transformers but seems a bit silly. I’m assuming there is a way that I only need to use one and feed the three feature classes through it? I’ve tried doing this and adding a FeatureTypeFilter transformer but this returns no values if I click ‘Update’.  

It seems that any file with a # in the filename won't download when using the SharePoint online connector transformer. I want to download using the _fullpath method.  Simply --> if the filename is FOO_1 it works. If it's FOO#1 it doesn't. The rejection code is SHAREPOINT_ERROR , the URL it's trying to DL is:SharepointOnlineConnector: Error making request to https://graph.microsoft.com/v1.0//sites/ac[HIDDEN]%20November%20#4.jpg: The resource could not be found.Is there any way to get around this? I have tried the URL ENCODER and STRING REPLACER transformers to try and manually encode the # symbol but it doesn't like this. Presumably because it's trying to encode it "again"

I’m having an FME workspace that has a custom transformer that is set to parallel running.when running the workspace from FME form there is no issue, everything runs smoothly.If I want to schedule this workspace (due to lack of FME flow) using Windows task scheduler the workspace terminates because none of the cild processes run succesfully.They all crash with the message ‘Access is denied’. This is the commandline for a child process:When not running in parallel, there is no issue.anyone an idea what can cause this issue? it’s really fustrating on how to solve this?

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

I believe there’s an issue with the tolerance values greater than 0.5 not being respected when using the NumericRasterizer transformer.With tolerances like 0 and 0.5, I can see a difference in output. However, a tolerance value of 1.0 has no change in the output. Output from NumericRasterizer with tolerance set to 0.0, with the input vector overlayed  Output from NumericRasterizer with tolerance set to 0.5, with the input vector overlayed 

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.