FME Form

Hello All! I am trying to geocode a series of addresses that are in a CSV using a geocoding service on Portal/ArcGIS Server (11.x). I have the web services connection authenticated and specified in the tool, and have tried the URL with and without the “findAddressCandidates” section - the results are still being rejected stating that the address hasn’t been supplied. I’ve also tried using a string concatenator to create the address string before connecting it to the Geocoder transformer & I’ve also tried to call out the address using its individual components using the text editor and calling out the specific fields in the format of “100 Street Name, City, State Zip”. I feel like there’s something obvious that I might be missing - I’m just not 100% sure what it may be. Thank you for the help in advance!

Hi, I use a DGNStyler to set the color of line features. Color is set by RGB Color (Color Type = RGB). In the resulting DGN, the color of the line is replaced by the best matching color from the color table. Result (Color 59): Desired Result (204,0,0): Is there a way to get the desired result? Jasper

Hi, I have hundreds of word documents that i am trying to extract the text from in order to run analysis on the content. I have tried just using the MS word reader to open a .docx file but with not success so have seeked alternative workarounds to achieve this. One of the common solutions I have come across is running a command for 7-Zip in the system caller to extract to word document into XML then load XML. My issue is that, although the command runs fine when run directly in CMD, when run through the system caller it requires a response regarding duplicate files. “Would you like to replace the existing file: Path: .\[Content_Types].xml Size: 3893 bytes (4 KiB) Modified: 1980-01-01 00:00:00with the file from archive: Path: [Content_Types].xml Size: 3893 bytes (4 KiB) Modified: 1980-01-01 00:00:00? (Y)es / (N)o / (A)lways / (S)kip all / A(u)to rename all / (Q)uit?“ As mentioned the command prompt works fine in CMD but not through system caller. The Command used is ““(7-zip.exe file pa

I’m using an Oracle non spatial reader in FME Desktop 2019.1.3.1 to read an Oracle view. Using Oracle client (i.e. SQL+), the total count of this view is 6,982,320, but the FME Oracle reader reads in over a million less, and the total count differs each time I run it. I’ve played around with some of the reader parameters - bulk read size, persistent connection, etc. - but each run is still different. Two examples below which read in two different total numbers and while they’re close, they’re way off the total count according to SQL. Any thoughts on this?

Hi Community,I'm working with FME 2023 and I need to snap these purple points to the closest locations along the yellow polyline. What's the best way to do this?How do I use the Snapper transformer properly in this case?Could you please share an example workspace?I've attached the relevant data—thanks in advance for your help!

Hello, FME Flow announces the deprecation of the JobWaiter transformer: 2024-9-2 10:59:42 | FMEFlowJobWaiter (ServerFactory): FMEFlowJobWaiter was deprecated in 2024.1.0. Its support lifetime is limited because the v3 FME Flow REST API will be removed in future FME releases. When the v3 API is removed, this transformer will stop working. Please update this workspace to use an HTTPCaller to call the relevant REST API directly instead. Question: Is there any ‘how-to’ with a sample workspace which REST call can be used to replace the JobWaiter functionalities? My sample scenario would be: You have 5 jobs running in parallel (wait to complete NO), JobWaiter polls every 20sec until all 5 job_ids are received and completed. all 5 jobs must have _status SUCCESS before Job #6 is called. I tried GET /transformations/jobs/id/{jobid}/result but it failed with 404. Any hint? thanks Klaus

Is it possible to generate a separate log file or configure the existing log file to display metadata for the reconciliation purposes. The field that I am looking to display is the feature count in input file, feature count in both output file, who executed the workspace with timestamp, the amount field totals in the input file and the amount field totals in the 2 output files ( I have a workspace where there is 1 input file and 2 output files) . Also I have noticed that FME overwrites to the same log file every time the workspace is executed, is it possible to create a unique log file at every run? Thank you for the support.

Can I please have some help, I have list of attributes as example: attribute{}.name = ID and attribute{}.native_data_type =long how can I use jsontempleter to have as output to json ID(long)? Thank you, M

Hello community, Just installed the 2025.1 beta of FME Form [FME(R) 2025.1.0.0 (20250612 - Build 25591 - WIN64)]. I'm experiencing a new behaviour compared to all the previous versions: when I open a workbench it automatically fills all caches in, without me running the workbench. Luckily, it stops at the writers and does nor run them. I could not find any information about this in the change log of the latest versions. Is this on purpose or a bug? Is there any way to stop it? I do want the caches, but I want to decide which ones are created. I get these notifications in the data preview while it is doing it and after it is done: Sorry if this is repeated, I couldn't find it here.

I have downloaded county road network compined the lines via road name I have 2 point datasets a (From and a To). they are intersections of the road network they share many fields but ive been using a count field as a joiner. when I am using feature joiner I keep the roads that the points are touching but i want to keep only the road inbetween the points. after point on area overlayer theyre broken up but the fields are duplicated. so i am unsure how to keep the “inner section”. Im sure its just something simple i am misunderstanding

I’m exporting LoD 3 models from FME to CityGML and the files blow up in size. FME writes every Appearance on each triangle and also makes a separate position list for each triangle, everything becomes separate XML elements, so the markup absolutely dominates the file. I think CityGML should be able to store things more compactly at the object level, but I don’t see a way to make FME do that automatically. Every triangle whould not need its own position list right? I have thome different thoughts on the matter: Can FME group or merge geometries/appearances to cut down the markup? Can ImplicitGeometry be used effectively without creating a complex monster workspace? Is CityJSON fundamentally a better route? (I’ve heard numbers around ≈ 1/6 of the file size.) Are there external tools that post-optimize a CityGML without losing semantics? Concrete tips, transformer setups, or example workspaces are very welcome.

I have a process in FME and I want to send an email with the Emailer transformer at the end. I've already written in the email body the data I want to appear in the email, but the problem is that I want to send it in plain text format and not in HTML. The Emailer transformer always wraps my text in HTML, even though I already changed it to FME's format; it seems that every time I exit the transformer to run the process, it doesn't save the text settings in the transformer. Does anyone know how to change this?

Hi FME Community We have a dynamic FME workbench which iterates through 89 datasets in an Oracle Database and inserts all records into datasets in a SQL Database. Some of the datasets are large (over 4 million records) and the whole process for truncate & load can take over 24 hours to run. We are looking for ways to improve the speed of this process. We are currently using a feature reader to get the Oracle features, then using a few transformers to clean up the data (i.e. in case there are multiple geometries), then using a feature writer to insert the records into the SQL database. How can we speed up and/or optimize this process? Is there a way to use a SQL Executor to improve the process?

Hi Community, I’ve developed a workflow that enables me to connect to an external SFTP server and download all contents from a specified folder. I followed the guidance provided in the following post: The workflow functions well for a single folder. However, the SFTP directory structure includes multiple nested subfolders. I now need to enhance the automation to recursively traverse these subfolders. Please see the structure example below. Additionally, the SFTP contains files in various formats. To handle this, I plan to use multiple StringSearcher transformers—one for each file type (e.g., .tiff, .asci, .las). My challenge is ensuring that FME iterates through all subfolders to identify and process the relevant files. Could anyone advise on how to configure FME to recursively search through subfolders and apply the appropriate filters? Many thanks in advance!

Dear FME Community, I should to optimize my job, and for that I need to make group processing with an optimization of objects numbers like that : And after, as you can see, make a parallelize of objets for not having only a linear treatment. Do you know how can I do this ? Thank you very much.

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 "Ma

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 thi

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?

Has anyone else had any issues with the SubstringExtractor in FME2025? I have a process that works in an older version (2021) but in the 2025 version I am seeing a different behavior. Wanting the last 7 characters in a string I used a Start Index of -7 and an End Index of -1. This worked in FME 2021. When opening the workspace in FME 2025, it initially works, but when I upgrade the transformer from V2 to V3, it then returns no value. I created a new blank workspace and added a brand new SubstringExtractor in 2025 and saw the same result. It seems to work selecting values from the start like Start 4 End 7, or Start 2 End -1. But having the start be negative seems to always return no value. The change listed for the V2-V3 upgrade was adding bulk mode support. Hoping I am just missing something/doing something wrong here. Version is 2025.0.1.0 Attached is a version of the workspace with the transformer not upgraded, that way you can see the before and after by just upgrading it on your en

Hello all, At a client I often fail to connect to their ESRI Portal, due to failing to verify SSL (see loggin below) on both FME Server and desktop. Proxy settings in FME don't change the behaviour (always uses proxy). The Chrome browser thinks the certificate is o.k. I can't disable ssl-verification in the Portal Reader, as suggested in the log, like it is possible to do in the HTTPCaller.. (see my idea for that). Inspired by this reported problem I exported the certificate from Chrome, and imported it in $FME_HOME\jre\lib\security\cacerts on desktop.. (analogue to these instructions for server, section .pfx certificate, as the problematic server has a .pfx certificate). This did not resolve the problem... Does anyone have any suggestions??? Kind regards, Martin ArcGIS Portal Feature Service Reader: Using proxy http://proxy.####.intern:8080/ ArcGIS Portal Feature Service Reader: Using authentication type 'NTLM'ArcGIS Portal Feature Service Reader: Logging into 'https://geoportaal.####

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