FME Form

Hello everyone,I am a beginner when it comes to FME and loops. I have the following task: I have an attribute column with a value. (e.g. Person 1, age 18Person 2, age 35Person 3, age 41Person 4 , age 45The age column should now be increased by one value x times per specified loop run. The number of loop runs should be controlled using user parameters and variables.I am using FME 2022. Can anyone help me? I have found examples with loops, but as a beginner I don't understand them.Thank you very much for your support. I look forward to your reply.A.B.

When upgrading from one version of FME to the next, I can upgrade some upgradeable transformers, and I can also upgrade the readers and writers to the latest version. But what about the readers that are called by the FeatureReader (and writers by FeatureWriter)?We just upgraded from 2024.1 to 2025.1, and I upgraded the FeatureReader transformer reading a geodatabase. Does upgrading the transformer, upgrade the GDB reader functionality? Or does it automatically call the latest GDB reader? Or does it stick with the old?

I am trying to create a webservice to access Sharepoint. FME has been registered in Azure but when I try to set up the connection the conditional access policy blocks my connection.It looks like it has something to do with the way the http user client provides info to Azure. With the FME default http user agent you just get a blocking error, with the system default http user agent you get this: It looks like the http User agent does not provide the device ID (apparaat-id): Not available (niet beschikbaar). The conditional access policy demands a registrered device so it blocks this connection.I can make a Azure connection directly from Chrome or Edge in other apps. what is the way to a solution for this problem? 

I need to assign a z-value to 2d points snapped along a 3d line.My steps  anchoredsnapper to snap the 2d points to 3d lineChopper to extract the vertex of  3d line create vertex of 3d lineNeighborFinder to find the closed vetex (of 3d line) to my 2d points   but now the question is how can be sure that the nearest vertex belong to the lines where my points are snapped ?  In red a point without z value but if I increase the maximun distance of NeighborFinder the risk is to assign the wrong z value (I mean the z value of the other line) So at the end my goal is to assign the z value to the points starting from the line where these points are snapped  (sorry for bad explanation...) thx for support Francesco

As the question title states, I would like to use the SharePoint Online Connector to download files from SharePoint to my local computer's drive. I was able to set up the connector using a web service and it says "translation successful" when I run the SharePoint Online Connector on it's own but I'm not sure what readers and/or writers to add, or is there something wrong in the parameters? The files on SharePoint vary from .docx, .xlsx, and .pdf formats If someone has a basic template to show that would be great. Thanks!

I'm trying to write AGOL features and attachments coming from a feature service tied to a Survey123 survey into a SQL Server geodatabase. I've looked through most of the tutorials and questions about this, but in my use case I need to maintain Global ID's on both the features and the attachments. The feature GlobalID's are being used to name photos that get stored in S3, so I can't use the examples that use a counter to create a new relational ID. I have set the "Maintain Global ID's" parameter on the AGOL reader and have exposed the AGOL attachment attributes. The attachments have a Global ID and Parent Global ID, and I figured it would be simple enough to use both of those to create the relationship class in the GDB since that's what the AGOL service is doing. When I query the service, I can see a feature's Global ID and the attachment's Global ID and its Parent Global ID (the GID of the feature it's attached to).  Feature popup: Quer

EDIT - I have solved my own issue here! We had some network changes, and I needed the SAS from the top level of the storage account rather than the specific container. Problem solved. I’ve successfully connected to the Azure BLOb using 2025.1 Form using the AzureBlobStorage Connector:I can connect to the “Hosted” folder inside the container “shared-data”. I am connecting using SAS. However, I need to use Flow 2024.2 and so I need to open this same workbench in Form 2024.2…. and this is where the fun starts!The transformer is slightly different, when I try to configure the Container I don’t seem to have the option to add the “Shared-data”. I am a complete novice at connecting to Azure, so please do not worry about over-explaining anything, I need all the help I can get! Many thanks in advance for any words of wisdom.RegardsStu

Hi everyone,I’m working with the JSONUpdater transformer in FME and need to add a key called layerDefinition to my JSON. The goal is to have:"layerDefinition": {}as an actual empty object, not:"layerDefinition": "{}" // stringor"layerDefinition": nullHere’s what I tried:Value Type = Plain Text, Value = {} → Result is "{}" (string). Value Type = JSON/XQuery, Value = {} → Result is null. Value Type = JSON/XQuery, Value = json:object() or map {} → The key doesn’t appear at all in the output.My JSON path is correct (json["operationalLayers"][0]), and the update type is Insert into Object.Question:Is there a way in FME to insert an empty JSON object using JSONUpdater without resorting to a string or null? Or is the only workaround to use AttributeCreator + JSONFragmenter or JSONTemplater?Any advice or examples would be greatly appreciated!

HiIs it possible to connect fme to a Microsoft Fabric Lakehouse? And read data?I use fme 2022.2 

A caseA column code contains both unique and identical values ​​(e.g., A, A, B, C, C, C, D, E, E).A second column names contains different names.I want to group a column, but the names associated with it need to be merged.How can I easily solve this in FME? Thanks in advanced!

I have a column containing values ​​(contains 1 or more sorted names) that are both unique and duplicate. Now I want to assign a unique number to each value. This means that the values ​​that are the same should also have the same unique number. How can I handle this within FME? Thanks in advance!

I am trying to connect to a SFTP using the FTP caller. I have followed the instructions in https://support.safe.com/hc/en-us/articles/25407554321805-Using-a-Private-SSH-key-with-FTPCaller-to-Authenticate-an-SFTP-Connection-for-FME-Form-and-FME-Flow-on-Windows-Systems and I can connect to the server using other methods (winscp, filezilla) so the new key is working. In the log (with debug enabled) I get the following:SystemCaller: Executing 'start "" "C:\Program Files\PuTTY\pageant.exe" --encrypted C:\PPK\PrivateKey.ppk'FTPCaller (FTPFactory): Using the 'SChannel' TLS library for HTTPS/FTPS connectionsFTPCaller (FTPFactory): FTP info:   Trying ??.??.??.??:22...FTPCaller (FTPFactory): FTP info: Connected to ??.??.??.?? (??.??.??.??) port 22FTPCaller (FTPFactory): FTP info: Failure establishing ssh session: -5, Unable to exchange encryption keysFTPCaller (FTPFactory): FTP info: closing connection #0FTPCaller (FTPFactory): FTP/FTPS/SFTP transfer error: Failed initializationSystemCaller_2: E

Hi All, I have the following set up where / separate's attributes - where Value X and Y can exists multiple times within a month linked to the Item ID.Place / SubPlace / itemID / Year / Month / YYYYMMDD / ValueX / ValueY /  SUMXPlace / SUMXSubplace / SUMYPlace / SUMYSubplace /What i would like to do is after i have the sum per month per place and subplace, is to see the sum again of these sums on a quarterly basis - ie. Jan-Mar = Q1, April-June = Q2.So the final table would be something along the lines of this - to still allow filtering per place/subplace/quarterPlace / SubPlace / Quater / QSUMXPlace / QSUMXSubplace / QSUMYPlace / QSUMYSubplace /Any ideas or help would be greatly appreciated!/Emma  

I’m using FME 2024 without any issues related to fanout. However, after installing the 2025 version, I’m facing a problem where the fanout is not working as expected. This seems to be a software bug.I am using a Creator to write shapefiles with folder fanout. Based on an attribute value, the data should be written into separate folders. But currently, it is writing only to one folder ("Low"), while the other two folders ("Medium" and "High") remain empty. Attached test1 fmw file.The Shapefile Writer is skipping features and showing the following warning message:“Shapefile writer: Ignoring feature with unexpected feature type 'High_priority_data'... Last line repeated 19 times ...”In FME 2024, this workflow works perfectly and writes to all the folders as expected. I believe others may also be experiencing the same issue in the 2025 version.

Recently upgraded a dev environment to FME Flow 2025.1.1We have some workspaces that use FileCopyWriters to move files.These workspaces still run on FME 2025 but now throw out a warning message for each fileThe move request details the correct move, but then there is a failed to delete message that appears to be saying it can’t delete from the destination not the source. The files are in fact deleted from the source, so it’s actually all working as it should be and as it did previously with the exception of these warning messages. I note that the FileCopyWriter now has a delete option so wonder if this is related somehow. Can anyone confirm they see the same behaviour in 2025.1.1.  The same warning error messages is seen in FME Form 2025.1

We have FME Form/Workbench installed on some of our Azure Virtual Desktop (AVD) machines, and it works fine overall. There is this recurring issue where the Connection Storage access is lost between each session. This is disruptive, and not always apparent, which wastes time and effort troubleshooting. In 2025.1.2.0, navigating to Web Connections under FME Options shows this each time:And navigating to the Workspace Defaults section yields:My connection storage is a Shared Database, which I thought was part of the problem, but I have more recently learned that a colleague of mine is using the default Personal Database connection storage and is also having the same failure to decrypt data between AVD sessions.I’ve searched around the Community and the web some, and am familiar with Changes to Connection Storage in FME Form 2024 – FME Support Center and the list of known issues, but was unable to find anything related to this. Has anyone else run into recurring connection decryption fail

Okay, hear me out 😄In december we’ll be doing a webinar about Best Practices, but because it’s a bit of a tradition to make the last webinar of the year a fun one we’re going to call it the Worst (Best) Practices webinar. So we’re looking for workspaces that are complex, undocumented, badly designed with renamed transformers.Way back in the day the training materials included the Chamber of Workspace Horrors Powerpoint, that’s the kind of stuff I’m looking for.Feel free to reach out to me privately, anonimity is guaranteed 😃(Normally we do our webinars in Dutch, but depending on the response we can also do this one in English, so if you’re interested in that also please let us know!!!)

Hello fellow FME enthousiasts, We have been running into an issue when using the new Esri ArcGIS Feature Service [Writer] (from the new Esri ArcGIS Connector v3.13.2 package) to write to a Hosted Feature Layer on ArcGIS Online. The Hosted feature layer is created by Survey 123.Previously we used the old Esri ArcGIS Online (AGOL) Feature Service [Writer], since this won't be supported anymore in 2026 we started experimenting with the new one. When we try to update the hosted Feature layer with FME using the old one, all goes well, data gets written as expected and the geometry is visible.But when using the new one from the package we get a few warnings and no error's. The process tells us it's succesfull, we see the new records appearing in AGOL and the attributes seems to be as expected. The geometry is not visible either. When we try to zoom to a record nothing happens. When i open the layer in ArcGIS Pro nothing happens either when i try to zoom to layer/or zoom to selection. It's li

Hi, I’m working on a script which copies data from an Esri arcsde geodatabase to a postgis database. I need to know if the table in the arcsde geodatabase is versioned before I run the rest of the script, and I have a pythoncaller which runs something like this (simplified here):layername = "schema.layerName"connectionFile = "path_to_connection_file"arcpy.env.workspace = connectionFiledesc = arcpy.Describe(layername)isVer = desc.isversionedfeature.setAttribute("versioned",isVer) self.pyoutput(feature)Now, I don’t want to type in the path to the connection file manually, but rather obtain it by some function which can collect the data from the list of database connections I entered in the settings. Is this possible? I’ve looked into the FME Web Services API reference for such a function without any luck. Best regards,Jacques 👷🏼 

One of the greatest new features of the IFC4x3 schema is that we can write 2D lines to IFC, which was not supported in IFC2x3.Why does the new IFC writer support only 3D surfaces and solids and not 2D line geometries? 

It seems that in the iOS18 update Apple made changes to the HEIC file container that means the FME Feature Reader using HEIF (High Efficiency Image File Format) now fails to read the HEIC files.We are currently using FME 2022.2.Is there a later update that will support iOS18 images? Is there an alternative way to read in these images successfully? 

I’ve been trying to load some .nwds files, and they’re taking days to fully open. The files themselves aren’t very large—around 180 MB—but some of the geometry has extremely large coordinate offsets. For example, certain objects are located around X=10,000 and Y=10,000, while others are positioned near X=1,200,000 and Y=1,200,000. Could these large differences in coordinate magnitude be contributing to the slow load times?

Goodmorning! I want to write a dataset with the postgis writer to GeoServer, but the result gives errors.  Process: A reader of municipal boundaries, and a reader with fire hydrants, the fire hydrants gets clipped on the boundaries layer, and then i want to write it to Geoserver. The postGIS writer says its succesfull, but when i inspect the layer in QGIS, there is no data, and i get the error: there is no item in geometry_colums. What have i done wrong in the postGIS writer? Can anyone help me?  Thanks in advance! 

HiI draw some 3d lines from point cloud but sometimes I snapped the wrong point so now I need to check if all my vertex are correct. So in the picture I need to detect the vertex encircled in yellow any suggestion ? thx Francesco 

I'm trying to setup the children and parents list attribute for export to CityJSON. Therefore I thought to use the listbuilder, but I get a different result than it should be. This example is how it should be: And this one is my result. It looks like there is an extra layer in it.How can I solve this?