FME Form

My requirement is to calculate the distance in meters from points to nearest road in FME, end output should be one new field should be added in point layer with distance to each points. i have tried to do this with NeighborFinder transformer but i am not getting my desired output. i don’t where i am doing mistake. can any one help me.

Colleagues, I'm looking for a way to sort two text columns in Excel based on a custom classification. I have a dataset with several columns, including X, Y, ID Link, GIS Portal Link, Major Company, and Sub Company. My goal is to sort the "Major Company" and "Sub Company" columns according to my own predefined order.Here's what I attempted:I used the AttributeMapper transformer to assign classification values, followed by a Sorter to sort both columns. However, it seems that FME ignored the initial sorting by "Major Company" and only applied the sort to the "Sub Company" column.What I want is: To first sort the "Major Company" column based on my custom classification. Then, within each "Major Company" group, sort the "Sub Company" column based on another classification. It’s important that the row structure remains intact—meaning if a "Sub Company" row is moved, all its related data (X, Y, ID Link, GIS Portal Link) must move with it. However, I worry that "freezing" or locking the

What is the best way to extract the path_modified_date, path_created_date, and path_accessed_date for files in a folder (these are shapefiles and zip file)? I ran the Directory and File Pathnames Reader, and it shows these attributes as missing. Is there a transformer I need to use after this Reader to extract this information?  

I have this line (the green one): And I want to calculate the shortest path from the start of the line to its end across the network (the violet one).How can I do it?What is it the right way to do it? How can I set the parameters of the “ShortestPathFinder”?attached files!Tnks 

We have been using FME 2021.2 ( build 21789) and recently upgraded our SQL database to 2019. We started seeing timeout errors when the FME writer tries to connect to the SQL Server and keeps saying 2023-10-16 15:04:58|  2.2| 0.0|INFORM|Microsoft SQL Server Non-Spatial Writer: Trying to connect using Microsoft OLE DB Driver for SQL Server...We use windows scheduled task manager to run our jobs and this is causing some of the jobs block other FME jobs. Any ideas on what may be the issue.  Thanks,AD

Hi everyone,Brand new to FME (ArcGIS Interoperability) - like 6 hours into it.  I have a process in ArcGIS Pro that I’m trying to replicate in FME.  It starts with a one to many spatial join where I also keep all target features.   I have parcel data (Target) that I want to join to address points.  Multple address points can sit on a single parcel (think apartments and duplexes), also 1 address point can be snapped to multple parcels (think of a property owner that also owns the adjoining lot. I am trying to create a layer : that will duplicate the parcel for every time an address intersects with it - 5 apartments on one parcel will produce 5 stacked parcels If an address is snapped on the edge of two parcels, both output parcels will inherit the attributes of the address point If a parcel has no address, it will still be included in the output.This is very simple in ArcPro with a one to many spatial join set to keep all target features  But I’ve been struggling for hours trying to get

Hello everyone,I have a column with output that changes depending on different input.Ideally, I would like to populate a published parameter (Choice) based on the output of that column, so then a user can click on a value of that choice list on FME Server in let's say a workspace app.Does anyone know how to dynamically fill in a choice list based on the output of a column?  

Hi community, does anyone know how to find these points using NeighborFinder/VertexCreator and then create a line with LineBuilder? My goal is to find the shortest route between the "common" points of these two road networks (existing vs planned).

Hello together (and thanks for your help)I’m testing my 2022.2 workbenches in 2024.2Every single workbench generates an error when having a testfilter in it:Cannot have multiple factories with the same name.  Multiple factories were assigned the name 'BufferRuler_4_TestFilter'The testfilter itself is not filled anymore.Like that it looks in 2022.2: This is 2024.2: Any suggestion anyone? Thanks in advance, Hannes

Can FME create folders in an on-prem Sharepoint Library? I’m successfully connecting to the library using the Sharepoint List type (Reader and Writer), and looking at written data I can see an existing folder, but I can’t use the writer to create folders.

Hello,I am currently working with some database PostGIS rasters and wanted to import some into FME 2024.1, using a filter to only select 2 out of 11030.To do so, I tried both a SQL Executor and a FeatureReader (as both enables PostGIS raster reading).The SQL Executor filters the rasters correctly but doesn’t create the geometry and returns an error in the log file.The FeatureReader loads the 11030 rasters without filtering, suggesting a problem with the “WHERE clause”.I tried the same thing using FME 2023.1 and the SQL Executor is working under this version. I am wondering if there is a bug in the FME 2024.1 version.The problem was the same for the Feature Reader.A colleague said that the Feature Reader outputs everything as well in previous versions of FME (2022.2 and 2021.1).Do you know when the FME 2024.1 bug will be corrected?We are linking our work with ArcPro and we know we will have to use FME 2024.I am enclosing a share folder with the different logs (as txt) and the 2 workbenc

I’ve tried multiple times to read gml file with feature reader or import that into the workspace using reader. I tried with multiple settings but failed.The gml file structure seems ok as it is loaded into old QGIS without any problems. Any advises or tips how to handle such files are welcome.

Hello everyone,For my use case, I would like to retrieve information from a SharePoint site of which I am an owner.Specifically, I’m trying to find out who the members of the site are and their mail-adresses. Do any of you have an idea of how I could approach this?I looked into the SharePointOnlineConnector, but it seems I can't retrieve site metadata using it. I might be missing something. 

Error:I have a workflow using a generic reader and it give me below warning:2022-03-10 22:07:41| 135.3| 0.3|WARN |Detected 2600000 unique Attribute Names strings in the translation. Several unique names may result from operations like list attribute creation or feature type fanout. Reducing the number of unique names may improve translation performance and reduce memory usageany idea what the reason is? 

After the update to version 2025.0.2, the writer is very very slow.  Am i the only one who noticed it?

fme form 2025.0.3 ，can not open it

HelloI have to change the value of a deployment parameter. Is there a way to find out, in which other workspaces this deployment parameters is being used?Thanks, Vera

Hi all,I’m running a workflow that reads a licensed FGDB layer, it’s setup within a custom transformer to take advantage of parallel processing.The problem is I’m getting the following error when the PC spins up 16 instances.025-06-03 22:38:47| 0.3| 0.0|INFORM|2> Opening the Esri Geodatabase reader2025-06-03 22:39:48| 0.4| 0.1|INFORM|2> The ArcObjects license 'Advanced' is being selected from the ESRILicenseInfo ArcObjects call2025-06-03 22:39:48| 0.4| 0.0|INFORM|2> The Esri Product license used by this machine does not include licenses for the 'Advanced' licensing level2025-06-03 22:40:48| 0.5| 0.1|INFORM|2> The ArcObjects license 'Advanced' is being selected from the ESRILicenseInfo ArcObjects call2025-06-03 22:40:48| 0.5| 0.0|INFORM|2> The Esri Product license used by this machine does not include licenses for the 'Advanced' licensing level2025-06-03 22:40:48| 0.5| 0.0|ERROR |2> Unable to perform any licensing related tasks. Please che

Just looking to see if anyone has had similar issues? I'm using FME 2023.1.1 and I've been having some strange issues with Log file paths. I has a workspace run on a separate machine with a workspace runner and the job filed to submit because it couldn't find the log path. The log path was pointing to the original location on my machine. I took a look at the fmw in a text viewer and saw the path defined in full.  I reopened the workspace, moved a transformer and re-saved it. This fixed reset the log path back to "$(FME_MF_DIR)<workspace_name.log". This has happened at least twice now and I'm not able to reproduce it. Just wondering if anyone has run into the same issue at all.

Once I have upgraded my ArcGIS Pro from version 3.4 to 3.5.0, I am suddenly unable to connect to a GDB file using the ESRI Geodatabae (File Geodb) reader, as I could before upgrading (when reinstalling ArcGIS Pro 3.4, all works again). I am currently using FME Form (version 2025.0.3) (Update: Apologies - the title reads Flow, but it should be Form! - I am unable to change the title with an edit though)., which connects as expected when I have ArcGIS Pro 3.4 installed. In FME the following output is given when trying to connect with the said reader:"Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility workspace parameter, found in Navigator -> Workspace Parameters -> Translation. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more details "In the gallery, the said reader or writer is not greyed out. I have tried al

Why do I get this error message upon opening the FME generated excel file? Based on the observation, the records are corrupted in some instances with missing values in the features. I have attached the screenshot for the reference.  

I have a workbench that can take in various formats, at present vector and web services, and publishes these items to ArcGIS Enterprise Portal.I would like to extend the functionality to enable the users to also upload raster imagery i.e geotiff, jpg, etc.I am using a HTTP caller to use the ArcGIS API additem call to add the file to portal and then using the API publish to publish the image, but it never works.I can do it via ArcGIS Pro and end up with a ‘Map Image Layer’. But I can’t figure out the correct process starting with a zipped file containing the image and ending up with an item in ArcGIS Portal that can be used a map service.Any advice would be greatly appreciated.  

Hey all,After upgrading from the 2024 to 2025 version, I noticed my workbench break. After doing some investigating I noticed that the PointOnAreaOverlayer transformer handles attributes differently.On the 2024 version the attributes of joined datasets would come through as ‘exposed’ attributes.In the 2025 version, these attributes were pushed into the unexposed attributes:Is this by design? Why the change?The properties of the transformer are exactly the same between the two versions. It isn’t the end of the world as I can use the attribute exposer to make it work. I was just also wondering is it normal that workbenches may break after major release changes? As this has now occurred after each last 2 major changes.

Hello,I'm working on an electrical network with substations and feeders.I want to assign a number to each feeder using NetworkTopologyCalculator, grouped by substation name. What I get What I want to achieveMany thanks in advance

Dear All,We need to convert TAB files that contain annotations similar to the following into a SQL Server spatial table with point geometry and an attribute to represent the annotation I have created the following workbench but it does not update the “dimention” attribute with the annotation text available in the MapInfo TAB fileOutput