Transformers

Hello everybody, I'm trying to replicate the functionality of the Aggregate tool in ArcGIS Pro within FME, specifically for raster data. I want to aggregate using the Sum method, meaning I want the output cell value to be the total of the input cell values. I also want to apply a cell factor of 10, which means the resolution will be reduced by combining 10x10 cells into one. In other words, I want to decrease the resolution and calculate the sum of every 10x10 block of cells. I’ve tried using a combination of the RasterResampler and RasterCellValueCalculator, but the results don’t seem to match what I expect. Thanks, Philip

FME Workflow Hi, I would like some help with PythonCaller. I have a workflow where I read in feature classes from an Esri file geodatabase, combining the features into a single attribute to make it dynamic. I filter out annotation, resolve domains and rename original domain fields, map empty and missing features to Null, then use AttributeFilter to split by FME Feature Type. My next desired steps are to identify, for each FME Feature Type, which attributes are nulls, and remove those attributes, then connect all splits to a Writer to write out to shapefiles grouped by FME Feature Type. I am trying to use PythonCaller to remove the null attributes. It stores the attribute names in a list, and stores in a dictionary called alnum_tracker attribute names and whether they contain data (where they are saved as True), before comparing the list of attributes to the dictionary, deleting any that are not matches. I’ve tested it and it is grabbing the correct attributes to delete and keep. The Py

Hello, I have a workbench with the following elements : 1 Excel writer based on a template file, and with option “Overwrite Existing File” set to Yes (mandatory to use a template). 8 Feature types writing to 8 different sheets of the same Excel file. As I’ve seen in other posts, this configuration should work. However, when I run the workbench, only one sheet is filled in the final excel file. If I run the writer Feature Types one by one, they do write their own sheet and remove the others. Can someone tell me what is wrong in this configuration ? I use FME Desktop 2021.2.

Hello, does anyone know how to configure the Clipper function to split planes with 3D lines, which these planes intersect? The one input is a set of 3D planes and a another input is set of 3D lines.

Hi All, I have successfully developed an automation process that customises and exports a table to Excel format. The final transformer in the workflow is a FeatureWriter, which generates the Excel file. I am now looking to convert this Excel output into a PDF format. However, my attempts using the available FME PDF transformers have not been successful. Could anyone advise on how to achieve this using FME? I have read that SystemCaller or a PythonCaller script might be viable options. Thanks :)

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 no success, so have seeked alternative workarounds to achieve this. One of the solutions I am looking at is to run ‘Mammoth .docx to HTML converter’ via SystemCaller to extract to word document into html. My issue is that, although the command runs fine when run directly in CMD, when run through the SystemCaller in FME it does not create the output file. from the log file I can see it finds the input .docx and extract the information it just doesn't write the output .html for me to read into FME with the AttributeFileReader. I have installed Python, Mammoth, and Node.js on my PC, below is the command used in SystemCaller; "mammoth "@Value(Input File Path)" "@Value(Output File Path)" Any help with this would be appreciated. Many Thanks Mike

Hi, I’ve read through other row to column posts but can’t seem to get it to work.Pretty simply I want the name values to become column headings and their value below them. I feel like this should be an easy one but just can't get it to work.

I'm joining two features in a featurejoiner in Form (2024.2.1). In AttributeManager one is a uint8, the other is varchar(200). Both contain value '2’. In Form these featues are joined with the joiner set to Automatic mode. When the workspace is published to Flow (also 2024.2.1) suddenly they are not joined anymore. I would expect the Automatic mode to work the same way in Form as in Flow. Especially since we run the same version in both environments I can't find any registered bugs on this issue. Has anyone else encountered this?

Hey All I have a process with the general workflow of create an SQLite database (FeatureWriter) and then run schema/index/relationship queries against it using an SQLExecutor. Initially, this was built in 2020.2 and works well (see example attached). However from ~2023.2 onwards, this logic no longer works. I get the following error when running in version newer than 2023 (including the latest 2025 releases) SQLite Reader: Failed to read a feature from the database. SQLite3 Engine error: 'attempt to write a readonly database' Looking at the database, it’s not read only, I can read/write to it with other programs. I’ve also tried it when FME is running as administrator and writing out to different folder locations. I can replace the SQLExecutor with a PythonCaller and it works fine. It also works fine when the SQL is included in the writer to run after writing. In some instances, I can using the run after writing approach, but in others I do need to do standalone calls to the db to mani

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

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!

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!

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

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?

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.2 Every 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 work

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.