Transformers

Has anyone resolved the workspace log Warning for coordinate system when working with Snowflake Spatial Reader? Coordinate system of reader identified by keyword `SNOWFLAKE_SPATIAL_1' has changed from `LL-WGS84' to `' If you set the coordinate system on the Snowflake Spatial reader to LL-WGS84 the warning changes to. NOT changing coordinate system of reader identified by keyword `SNOWFLAKE_SPATIAL_1' from `LL-WGS84' to `' -- mapping file setting of `LL-WGS84' overrides coordinate system `' read from file. If you set the coordinate system on the Snowflake Spatial reader to EPSG:4326 the warning changes to. NOT changing coordinate system of reader identified by keyword `SNOWFLAKE_SPATIAL_1' from `EPSG:4326' to `LL-WGS84' -- mapping file setting of `EPSG:4326' overrides coordinate system `LL-WGS84' read from file. Ultimately the Warning has no impact on the workbench or translation, the data is definitely LL-WGS84 and a CoordinateSystemE

I have a road network (lines) that i need to convert into points for labeling reasons.I have managed to do this using DistanceMarker but I want to be able to save the orientation angle of the line as an attribute in each point. So that when i use the points for labels, I can tilt them correspondingly. Since the lines are rarely straight, I want the orientation in the specific point.Any advice for how to apporach this?

Hi all and Safe.I just revisited some INSPIRE docs, that specifies the projections used for data here.In Denmark we often use UTM 32N, but there are two basically identical EPSG-definitions: 25832 and 3044. We normally use the former, while INSPIRE only uses the latter.The only difference is that 25832 is given as Easting,Northing, while 3044 is given as Northing,Easting.I tried a simple reprojection workspace, entering a 25832 point, reprojecting it to 3044, and extracting its WKT. And it was still Easting,Northing !Doesn’t FME handle such coordinate value swaps when reprojecting, or is my setup flawed ?Cheers.

Working with FME Form 2023.2.2.Comparing features using a ChangeDetector transformer I see a weird behaviour. It does not always happen though but can’t see a pattern.I see features correctly output though Updated and Inserted ports but all of them have value ‘INSERT’ in fme_db_operation attribute. Has anyone experienced something like this? 

I have a list and with ListSearcher i found that element with id {_list_index} needs to be removed completely from the list. How can i achieve this.

I am trying to intersect 3D Polylines and Solid Cubes to determine which cubes are touching the polylines.So far I tried Clipper, intersector, SpatialRelator and SurfaceOnSurfaceOverlay. All the features are ending in the rejected port as invalid geometry.What is the right way to accomplish this task?

Hi all,I’m exploring a workaround to split a polygon based on a 70/30 area ratio:70% area → Type A 30% area → Type BSome visual explanation is included below.The geometry of the split doesn’t need to follow a specific direction — any orientation is fine as long as the 70/30 ratio is maintained.Has anyone come across a method or workaround to achieve this?Thanks! 😊

I have a problem. First my FME: It is partly in Dutch, but it doesn't matter here. It is about spatial data with some features. There are two feature readers: the first one to select features which fall within a pre-defined contour, the second to select features. The attribute manager to add some attributes. The featurewriter to write the data in gdb format. In the FeatureReader you can see attributes for “pand_v” and for “scheiding_v”. The attributes of “scheiding_v” are standard, hence the same for other features, except for “pand_v”. The difference is that in “pand_v” BGTPlusType is replaced by “identificatieBAGPND”. The features are of several geometric types: lines, polygons and points.In the output of FeatureWriter all the attributes as given in the AttributeManager are shown. I'd like to see that for “pand_v” no BGTPlusType is given (there is no value here) and that for all other features no “identificatieBAGPND” is shown. And that some other attributes like fme_…, attribute{}…,

Hi everyone!I have some "from-to" path features (FROMTO.shp) that I need to use to calculate the shortest path across a network (NW.shp).However, it doesn't seem to work for all 4 features (just one), does anyone know why?I've attached the files for reference.Thanks in advance!

In FME 2025.0, it was mentioned that the IFC API Reader was updated to support reading IfcOpeningElement. However, in the latest version, 2025.0.3, the IfcOpeningElement feature still cannot be read. No matter what reader parameter options I adjust, it does not work.I have tried checking or unchecking the "Advanced - Subtract Opening Geometry" option in the reader settings, but that didn’t solve the issue. I have also tested several IFC versions, including IFC 2x3, IFC4, and IFC4x3_ADD2, but the IfcOpeningElement is missing in all of them.Is there something I might have missed? 

I have a road centerline dataset and RIF network data (one file per year) that includes from_dfo, to_dfo, and ria_rte_id. There are no common fields between the datasets.I’ve already done a manual match for 2022, where I assigned the starting and ending dfo values (from_dfo, to_dfo) from the RIF layer to each centerline segment — not the in-between segments, just the overall start and end for the full centerline geometry.Now, I’d like to automate this for other years (e.g., 2021–2017, 2024). My requirements are:Only extract the overall start and end DFO values for each centerline segment.One centerline may span multiple RIF segments, so I want the minimum from_dfo and maximum to_dfo from intersecting RIF features.There are no shared IDs, so I assume the match must be based on spatial overlap.Is there an efficient way to do this in FME, using spatial join and aggregation (min/max)? Any recommended transformers or workspace suggestion?Thanks in advance!herewith I have attached the screen

Hi everyone, I have a parent workspace that looks like a series of FMEJobSubmitter transformers:Each FMEServerJobSubmitter set up at below:Submit Jobs: In SequenceWait for the Jobs to Complete: Yes When I call this parent workspace from the Web Interface, something weird is happening. First job gets submitted straight away and it becomes Completed after a second. Then the second one will only appear in Running jobs after about 45 seconds. It is not in the Queued and one of the engines is not doing anything.The same case is happening for the rest of the workspaces - they will only appear in Running after about 45 seconds once the previous one gets Completed.It is worth mentioning that we installed our FME server as distributed components (3-tier). If it is installed as Express, it is working fine. Any help, please? PS We are using the latest build (20596)

Would be great if Regex Editor and AI assist was added into AttributeTrimmer rather than having to use the Regex functions in text editor, which are clunkier. In fact, it could go in any and all string transformers where you are trying to identify, use or replace a substring. 

Hi Community!I'm working with two sets of polylines, but not all of them match perfectly.I'd like to identify, using FME, the polylines that do not align (Non-Overlapping).Is it correct to use the SpatialFilter transformer for this type of comparison?If so, how should it be properly configured?I've attached the data I'm working with:the red polylines (RtesType1.shp), which do not match, are located in the area highlighted by the black circle.The polylines I'm comparing them with are the ones in cyan (RC.shp).Thanks in advance for your help! 😊 

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

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

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 “

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!