FME Form

Hello,I seem to be outputting multiple folders when I run my app through data stream or data download.Tried connecting all connections to one feature writer but it seems to be limiting me to one excel file if I do that so I did multiple feature writers for each excel file that I want.Tested running my app through data download and data stream and it outputs multiple folders - one folder per feature writer.Was wondering if I am able to simply download all excel files right away without putting them into a folder or just output them all into one folder.Screenshot below.Feature writers under Microsoft excel format. Basically 2 sheet type. 1 is based on a value and other is count sheet

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

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”.

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 JSONUpdate

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

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 decryp

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 t

Hello, I have a question regarding the DGN Reader/Writer about reading and writing external reference files.I am using the DGN Reader that contains a reference to another DGN file. In that referenced file there is a rectangle (an igds_shape element). In the DGN Reader parameters I enable the options "Read Elements From Reference Files" and "Keep Elements That Represent Reference Files".My goal is to move that rectangle to a different location and save it into a DGN file in such a way that:the rectangle appears at the new (correct) position - this part is not a problem; I already have a workbench for moving the geometry but it still keeps the link to the original referenced DGN file, and the referenced DGN file itself remains unchanged.In other words, I want to move the geometry in the main DGN while keeping the external reference link attached to it, so that any futur

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?

Hi, I have a report i make where from the data i get out the following (where / separate's attributes)Field / SubField / YYYYMMDD / ValueX / ValueYFor the last date of the Subfield, i would need a line where Value X and Value Y are zero - the end date is specific to the Subfield. Is there a way to get it to reach - for Subfield - find last date - create +1M from YYYYMMDD with X and Y equal to zeroI know how i would do it in a excel macro, but i dont know how to replicate this in FME /Emma