FME Form

I want to run a batch process to load a series of file-based datasets in a folder, do some simple transformations and export each to a database table.  The workspace in the image below is run by a workspace runner.  The complication is that each source has some standard columns and an unknown quantity of additional columns, which need to be loaded into the database as a new table.  If I configure the workspace with one source file, the schema config will not be correct for another file.  How can I set the schema definition to be dynamic?  I’ve been researching the subject but have not found the answer. 

I have a workspace that works without issues in FME 2024.2.1. We are planning to upgrade to FME 2025, but I am facing issues. When riunning the workspace in FME 2025, it seems to work fine, but after a while I get lots of a recurring message like this one:2025-06-02 11:38:25| 119.2|  0.2|ERROR |FFS reader: Failed to open file 'D:\FMETemp\wbrun_1748852462857_30000\fmetmp_0\FMETable_1748853274266_18156\FTShim_1019.fts' for reading.  Please ensure that the file exists and you have sufficient privileges to read itThese messages DO NOT appear when running the workspace in FME Form/Flow 2024.2.1I have tried FME Form/Flow 2025.0.2 and FME Form 2025.1 (beta) and all of these fails.I have set my FME_TMP environment variable to D:\FMETempDoes anyone have an idea?

when I am using AnchoredSnapper Reader Cad civil Writer : oracle spatial  Anchor : arcsCandidate : pointsSnapping Type : vertex Snapping it working fine Anchor : arcsCandidate : pointsSnapping Type : Segment SnappingTolerance zeroerror ORA-13347: the coordinates defining an arc are not distinct  same Snapping Distance in both  Why does this error occur when using Segment Snapping, The anchor is not supposed to move even with the Segment Snapping selected

Hi all,I’m trying to create clean cutouts (like donut shapes) from overlapping polygons in FME.For example, lets say I have four geometries A, B, C, and D, with each progressively larger and fully containing/overlapping the smaller ones. I want to subtract the inner shapes from the outer ones (e.g. D minus C, B, A; C minus B, A; etc.) so that only the ring-like areas remain.  I’ve previously used the AreaOnAreaOverlayer with overlap counts to determine hierarchy (e.g. a shape with 1 overlap is the largest, and one with 3 overlaps is the smallest, so I can then figure out what is what).However, this approach breaks when some of the smaller shapes are missing. I still need the output features to retain their original attributes (e.g. A, B, C, etc.), regardless of which shapes are present. For example, shape A might be missing, or both A and B  but you’d never have A and C without B. So I need a method that can still produce correct results even when some of the smaller shapes aren’t ther

I am building a workbench that has a GeoTiff Reader, and uses the RasterPropertyExtractor and CoordinateSystemExtractor transformers to report on various qualities of the input image. The bounds, the cell sizes, etc.I am hoping for a transformer that reports on the compression method of the input image. LZW or JPEG or something else?Something similar to CoordinateSystemExtractor but instead a CompressionExtractor

I have been trying to setup the GoogleGeminiConnector in my FME Workbench to able to prompt and use the Gemini 2.0 Flash model to get me the results.Since GoogleGeminiConnector is a FME Hub transformer, the documentation is not friendly for a first time user of Google Gemini.The GoogleGeminiConnector makes use of the Google Gemini Web Service available on the FME Hub, which again needs some configuration.There are several things to be configured from the Web Services in FME to Client ID/Secret, using the on the Google Console and other configurations, some within FME and some outside FME using the Google Console.Due to the documentation is bits and pieces, a FME user is required to jump between various help documents and web pages.It will be good if Safe can provide a single page workflow, that lists out the steps in the correct order to be followed to make the GoogleGeminiConnector to successfully work in FME Workbench.TxSRG

I thought I had a good idea to simplify our in-house processes by using FME Form startup python script to use subprocess.run to run external python files. That way we wouldn’t need to copy all the python code into the startup script and could easily make changes to it.Unfortunately, it doesn’t seem to work.subprocess.run FME Form runs the python script, but errors with “ModuleNotFoundError: No module named ‘boto3’. The python script itself works fine when run manually. It also works when copied into the FME startup section (in other words, boto3 runs successfully in both).But for some reason, running subprocess.run within FME Form will not find boto3 in the external python file (even though it works if the python code in is the startup script section of FME Form).I hope that description made sense. Is there a parameter for subprocess.run that I’m missing? Is there another way to run an external python file from FME startup?Software and Settings:FME Form version 2023.2.3.0 (20240313 - B

So I was testing the 2025.1 Beta and was curious to try the new DocumentPDFStyler after seeing it mentioned in Seattle a few weeks ago at The Peak of Data and AI 2025. This caught my eye and I cannot find anything about this new “Safeguard”. What is it and why are the run icons disabled and not the same as other transformers (ex: Run from this, run to this...)?  

Since version 2025, we've had warning messages in the log file when we start the Workbench via batch call. When we start the Workbench manually, we don't see these warning messages. How can we disable them? Is there an FME parameter for this?Example Reader-Warning (see red columns):2025-06-02 13:14:05| 5.0| 0.0|INFORM|Executing metadata query: 'SELECT f_table_name, f_geometry_column, coord_dimension, srid, type FROM geometry_columns WHERE f_table_schema = 'public' AND f_table_name = 'example_for_fme''2025-06-02 13:14:05| 5.0| 0.0|INFORM|spatialColName: -> 'geom'2025-06-02 13:14:05| 5.0| 0.0|INFORM|spatialColDim: -> '2'2025-06-02 13:14:05| 5.0| 0.0|INFORM|spatialColSRID: -> '2056'2025-06-02 13:14:05| 5.0| 0.0|INFORM|spatialColGeomType: -> 'POINT'2025-06-02 13:14:05| 5.0| 0.0|INFORM|spatialColType: -> 12025-06-02 13:14:05| 5.0| 0.0|INFORM|authority query:2025-06-02 13:14:05| 5.0| 0.0|INFORM|select auth_name, auth_srid, srtext from spatial_ref_sys where srid = '2056'2025-06

I am merging incoming attributes in Aggregator.  I concatenate the values from a field but I am getting duplicate values.  How do I create a cleaner attribute without duplicates?  

Hello, I have an AGOL Hosted Feature Layer that contains Fire Hydrants. There are 5,000 points.I want to update from a File Geodatabase with new Fire Hydrants. There are 5,004 points (meaning there are 4 new hydrants that do not exist in the Hosted Feature Layer).In the AGOL Feature Service Writer (highlighted in blue in the screenshot), to update this Hosted Feature Layer, would I use INSERT in Writer Mode? I want to upload only the 4 new Fire Hydrants to the Hosted Feature Layer from the Fire Geodatabase, thus preserving the existing records in the Hosted Feature Layer.  Would I use Truncate Yes or No?    

Hi community, does anyone know how I can convert a LAS file into an RCP point cloud file using FME?

Hello, I have a field consisting of two lines:Line 1: (empty space) String1 (empty space) String2 (empty space) String3 (empty space)Line 2 : (empty space) String5 (empty space) String6 (empty space) String7 (empty space) String8Both lines exist within the same field.My objective:If I choose to keep, for example, **String1** from Line 1 and **String5** from Line 2, then all other strings in their respective lines should be replaced with empty spaces.Alternatively, if I choose to keep **String3** from Line 1 and **String7** from Line 2, the rest of the strings in each line should become empty spaces.In short, I want the ability to retain specific strings from each line while replacing all others with empty spaces.example : Thanks in advance 

Hello,I have recently upgraded from fme flow 2024 to 2025.0.1. - (still using fme form 2024 for now)(EDIT: I have since aligned the versions between form and flow, and still getting the same error.)I have a workbench which uses the SharePoint online connector transformer   I am currently using python version 3.12+.I can run this workbench without any errors on fme form 2024, but when uploaded to fme flow 2025 I am getting the following issue:  Any tips on how to resolve this?Thanks. 

I created models in QGIS Desktop. These models repair geometries of lines and polygons. Now I want to reduce the working steps, so that the data gets directly repaired in FME. Does anyone has experience in that?

Can you help us complete this list of URLs used by FME? Some of our users work in environments with limited access to the internet and need to request access to specific URLs via a proxy . We are building a list of URLs used by FME and we are asking you for more input. Below are URLs we know FME may access in typical use. Are there other URLs you think we should add to the list? We will edit this list as answers come in.Of course, there is a multitude of web services you can connect to with FME using Web Connections and the HttpCaller transformer, and we don't want to add them all here. We are looking for URLs used by FME Workbench, standard FME readers and writers, and FME transformers. Please note: You can, of course, run FME without any internet access at all but you won't be able to use the FME Hub or access resources on the web.Workbench Startupwww.safe.com/ *fmestartup.safe.com/Help and docs:docs.safe.com/ FME Hubhub.safe.com:443**fmehubproductionopsworks-appstorage-c2mc0

I don’t know if this is a bug in build 25220, or if it’s the intended behavior. But it’s very different from past versions, and will likely cause issues in our workflows.When the ‘Merge Attributes’ option is unchecked, no Candidate attributes are carried forward in the Passed port as a shown in this screenshot. The Candidate attributes are only carried forward in the Failed port.If the ‘Merge Attributes’ is checked, the attributes are passed: However, the issue is that there is no configuration in the ‘Merge Attributes’ section that will only pass the original attributes from the Candidate. You are forced to either merge the Filter attributes, create a prefix on the Filter attributes (and likely have to remove in bulk post-SpatialFilter), or simply use the Filter attributes. No option will spatially filter the Candidates without altering the schema.I’ve found this behavior in many transformers that have the ‘Merge Attributes’ option, including SpatialFilter, SpatialRelator, PointOnArea

Hi,I am getting this annoying warning - it seems to be with dynamic writer - Using SQL Server 2017 / 10.9.1GEODATABASE_SDE Writer: Renamed user attribute 'Shape.STArea()' to 'Shape_STArea__' based on format constraints for invalid characters, length, and caseGEODATABASE_SDE Writer: Renamed user attribute 'Shape.STLength()' to 'Shape_STLength__' based on format constraints for invalid characters, length, and caseNormal writer works fine 

Hi community! Can someone tell me how I can add a basemap in FME in the Graphics Viewer?(Stamen Maps, MapBox, Microsoft bings maps..)TNKX EVERYBODY!

Hello, have bumped into the problem of generic reader not being able to read a GML and have read the literature on how to circumvent this by adding a separate reader as a resource to make the generic reader understand my GML’s. But I cannot get it to work the reader just runs and doesn't find data, no error or warning, Total Features Read 0.,So my GML is pretty straight forward as there is no problem getting FME to read it with a OGC GML reader without needing to set XSD schemas and so forth, just reads it in by default. I have tried various settings in a GML reader that have all worked and then copied that workflow when I add the reader as a resource without any luck.Have I overseen some step here or any ideas what I might be doing wrong? Send hilfen, Hlynur 

Hi,I have a raster file (attached), and I would like to convert it into a 3D representation, similar to the image below. How can I do that? Thank´s

I’m using an Excel Writer in FME Workbench 2024.2.  This is a workspace that will be run yearly and I have created an excel file to write to in the format that I need so that the end user gets the same output year after year.  I would like to use FME to clear any existing data in the excel file from row 5 on down, but still keep the data and formatting that exists in the rows above.  I tried Truncate Existing Sheet/Named Range: with my Start Row set to row 5, but cleared all of the existing data from the sheet and then wrote the new data starting at row 5.  In the below images, you can see what the sheet looks like before the writer is run, the writer parameters, and what the sheet looks like after the writer is run.  Is there a setting in the Writer Parameters that I need to change to ensure that the data and formatting in rows 1- 4 doesn’t get deleted?  Or is there another way that I need to approach this?  Any help would be greatly appreciated.  Thanks! Sheet view before writer is r

We upgraded our migration chain last week from FME 2025.0.1 to FME 2025.0.2 and our Excel writers started to mess up xlsx files. Some column names are renamed and hundreds of them added all with the same name: "Created by LibXL trial version 4.5.0. Please buy the LibXL full version for removing this message."Strange thing is that not all workbenches are messing xlsx files like in the screenshot. Some of them behave as before in FME 2025.0.1. I indeed find libxl.dll library in the plugins folder of FME installation and version is 4.5.0.0.During upgrade to FME 2025.0.2 all workbenches, transformers, readers and writes are upgraded. Recreating Excel writer in FME 2025.0.2 does not help.Can someone please give me a hint if its possible to overcome this issue in FME 2025.0.2?

I have a HTTPCaller to access an API from the Dutch road service Melvin. It returns an attribute with the json including geometry (response_body - here renamed to ‘gegevens’). I am quite new to JSON.In order to extract the features I use 2 JSONFragmenters: one for the attributes and one for the geometry. I've tried many other setups with JSONfragmenters,-flatteners,-extractors etc, but I can't seem to find an answer as to how to get geometry and attributes from a json nicely joined back together.Current setup below. First I extract the geometry from the attribute (gegevens) and then from the same attribute (as the resulting attribute gets changed, thus I created another with the same information named gegevens_basis) by the fragmenter for the attributes. However it multiplies the number of attributes (700+ to 500,000+). Another setup (also below) sent all geometry to rejected. I also tried to do it from the same attribute from a junction but then I cant join then as I cannot get the id

Hi,i have an problem with the Oracle Non-Spatial (and Spatial) Reader / Writer.FME seems to have an issue when the password contains a section sign (§).Other special characters don't seem to cause any problems - at least dollar signs ($) and slashes (/) work.As soon as a § is included, the login fails.Version: FME Form 2024.2.1.0 (Build 24801)I tried with Named-Connection and with Embedded Connection Parameters.Maybe it is a similar problem as this post:Error Message:Creating reader for format: Oracle Non-SpatialCreating reader for format: Oracle Non-SpatialEnvironment variable ORACLE_HOME is not set.Connecting to ORACLE database `ABC' with user name of `CARLO_TEST' and password of `***'Error connecting to Oracle database: message was `ORA-01017: Benutzername/Kennwort ungültig; Anmeldung abgelehnt'. (serverType=`ORACLE8i', serverName=`ABC', userName=`CARLO_TEST', password=`***', dbname=`')Failed to obtain any schemas from reader 'ORACLE_NONSPATIAL' from 1 datasets. This may be due to