FME Form

Hi there,Input data:list with numerous entries, sorted, with changing name excerpt: name from to 947606 2041.020 2045.574 947606 2045.574 2055.574 947606 2055.574 2065.574 947606 2065.574 2079.880 947606 2079.880 2083.168 947606 2083.168 2089.880 947606 2089.880 2099.880 list with ‘exceptions’ excerpt: name from to 947606 108.459 108.7

Hello,I would like to perform queries on a branched electrical network composed of sections interconnected according to the current direction. However, the "TopologyBuilder" and "NetworkTopologyCalculator" transformers facilitate this task, but have limitations regarding the manipulation of downstream sections.  For example, I have the entity "i" and I want to collect and query the values ​​of the entity "i+1" (by analogy with the "for" loop in Python), then "i+2", etc.Do I have to use Python development, or are there other, simpler solutions?Thank you in advance for your valuable assistance.

I’m connecting a Sharepoint dataset to a portal dataset, with the intention of creating geospatial data in portal, each record having an object-id along with geometry. The Sharepoint record would be manually linked via this object-id, and then FME would sync changes of related columns.My question is which transform (there are so many!) makes the most sense, and how can I limit the updates to only those records that have a matching object-id?In my writer, the upsert action exposes a match column config, but the update action doesn’t. I feel like I’m missing something, as an update statement still needs something to match on.

I’ve reached the workflow stage, but I can’t proceed further. I’m trying to extract multiple tables from a PDF file. I’ve been following https://support.safe.com/hc/en-us/articles/25407564475277-Extracting-Text-and-Tabular-Data-from-PDF#h_01HW3Z9Z37Q33NQQ7R0XBGEVB0, but the structure of my PDF is quite different.I only want to extract the tables—nothing else. In my case, the table has titles on the right and content on the left. I used the StringSearcher to extract the titles, since they are easier to identify (usually one word).The challenge now is that I can’t extract or separate the content, as it’s made up of long sentences that are mixed with the titles. I'm looking for a solution to: Sep

I’m hoping to use a DTM service provided by the Environment Agency to extract the height for locations I have (points or polygons I haven’t decided yet).  They provide WMS, WCS, WMTS, OGI API: LIDAR Composite Digital Terrain Model (DTM) - 1mI believe it’s the WMTS I want, it has the elevation data layer within it. https://environment.data.gov.uk/spatialdata/lidar-composite-digital-terrain-model-dtm-1m/wmts?request=GetCapabilities&service=WMTS&version=2.0.1My plan was to use a WMTS reader, and the PointOnRasterValueExtractor to get the heights for the points I suppl

Hi, I am trying to run a custom python code that uses QGIS library in PythonCreator. However when I run the code I get this error:Python Exception <ImportError>: DLL load failed while importing _core: The specified procedure could not be found.I tried everything, I followed the documentation/manual how to setup custom python interpreter, I tried to setup dependencies and environment variables but none of that worked. Can someone tell me what am I doing wrong? Thanks!

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. 

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.

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 Sett

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

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/

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 a

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