FME Form

Hi, I am getting this error:An error occurred while attempting to insert a row into the table ‘ABC’ using a cursor. The error number from ArcObjects is: '-2147217323'. The error message from ArcObjects is: {The cursor has been invalidated by an edit operation.} I am experiencing an issue when trying to insert features into a feature class stored in an enterprise geodatabase. Specifically, I am both reading from and writing to the same dataset. I haven't encountered this problem before, but it began after I set the Feature Operations to "Upsert" while updating existing records and inserting new records that are not yet present in the database. I suspect that performing inserts and updates simultaneously may be causing a disruption with the cursor. I also attempted to use the Feature holder, but I received the same error. This disruption is affecting the automated process. Does anyone know what might be causing this error or how to fix it? I would greatly appreciate any assistance!Thank

I am having some difficulty normalizing reverse geocodes for comparison from one Geocoding Service to another (in this case OpenStreetMap).  The _address that is returned can pretty easily split up into a list or separate attributes with most services as they are consistent. However, OSM’s _address has extra information and parsing it to be consistent with anything else has been a challenge.  See below where instead of having an AddressNumber, a null, or a 0, I get Falmouth Public Schools & Moonlight Meadery in the 1st position.  For that matter, I sometimes get supplementary place names such as Seaport & South Boston when expecting a Town in a particular separation/position.  So it throws off looking in any specific list due to the inconsistent placement.Some are normal, but many either don’t contain the expected info, or add info that is unnecessary for my needs.What I want to make into attributes: AddressNumber  Street  Town  State  ZipCodeOpenStreetMap gives me this in a te

Hey everyone, I'm writing some data into a Snowflake database and getting a geometry validation error on the Snowflake side: SnowflakeSQLException: Geography validation failed.When I run it thru the FME GeometryValidator - it passes.If I run it thru the SQLExecutor and call ST_ISVALID it returns false so in theory, I could call the SQLExecutor for every record however with a million records, this really isn't feasible. I thought about grouping the inserts by 1000 and if it fails, run those 1000 thru the SQLExecutor however I couldn't figure out how to have the FeatureWriter continue if it fails on a group.Does anyone have any ideas on how to get these records to continue. I really just want FME to remove any bad geometries and log which one's failed. Thanks!

Hi,As Safe people do some fun projects with AI like https://hub.safe.com/publishers/safe-sandbox/templates/agentic-ai-spatial-schema-mapping-template-gemini, would it be possible to do one preparing one or multile schema mapping file(s) instead of mapping all data through AI? You could just send a sample to Gemini/OpenAI (you name it), with the associated schema and restructure the output into something accepted by SchemaMapper. This would be better for performance, safety and the planet 😊. Quite many transformers could be adapted to digest an input like schemamapper so that they can be configured by AI agents in a nicer way. Thanks! 

Hi, I am looking into renewing my FME certification in the coming months. It is the first time I will do it proctored. Does anyone have negative experiences with Talview where you couldn’t use FME Form, FME Flow as described here: https://www.reddit.com/r/fme/comments/1dl0647/has_anyone_completed_fme_certified_professional/I understand you are supposed to be able to use the applications and help documentation during the exam. Thanks,Annette 

Goodmorning! I want to write a dataset with the postgis writer to GeoServer, but the result gives errors.  Process: A reader of municipal boundaries, and a reader with fire hydrants, the fire hydrants gets clipped on the boundaries layer, and then i want to write it to Geoserver. The postGIS writer says its succesfull, but when i inspect the layer in QGIS, there is no data, and i get the error: there is no item in geometry_colums. What have i done wrong in the postGIS writer? Can anyone help me?  Thanks in advance! 

Hi everyone,I’m running into an issue when using the FeatureReader transformer.When I read a table through the FeatureReader, the attributes are not exposed  However, if I read the same table directly using a normal FME reader (through SDE or GDB), all the attributes are properly exposed.Is there a setting I’m missing with the FeatureReader that prevents the attributes from being available? Or is this expected behavior when using it compared to a standard reader?Thanks in advance for any advice!

Hi, I am looking for a way to add attachements (pictures, pdfs ect) to a point layer published to Esri Enterprise using FME Flow. Does anyone managed to accomplish that?

Hi FME Community,I'm currently working on a BIM/GIS integration project where I need to regularly update Revit files into a 3D GIS platform. The initial setup is already in place: I've created the 3D environment and published some Revit files to Portal for ArcGIS using ArcGIS Pro.Here’s the current workflow:Load the Revit file into ArcGIS Pro within a 3D scene. Share the scene to Portal. This results in three published items: a scene-hosted layer, a feature-hosted layer, and a web scene.Since the engineering team updates the Revit files weekly, I’m exploring ways to automate this process using FME Form and Flow. So far, I’ve considered two options:Option 1:Use PythonCaller to replace the Revit file in ArcGIS Pro and re-share the web scene to Portal. This would overwrite the existing scene-hosted layer, feature-hosted layer, and web scene. No additional GIS data would be generated.Option 2:Convert the Revit files to a geodatabase format (possibly using multipatch geometry?). Push the up

Hello my fellow FME’ers,Probably I'm missing something or I stumbled upon a bug, but I can't get something to work like I expect. Maybe someone can point out what I'm missing. Workspace snippetMy data is going trough a Matcher to find features that belong to the same object. I then sort them on _match_id and an attribute called lighted.  Result of Sorter_4As a result I have something above. If lighted is null it will be the first feature.In the AttributeManager I use Adjacent Features to look 1 feature further and have the following condition statement for a new attribute called _filter. The second one is another attempt to get the same result, but that also doesn't work. Conditional statement Alternative conditional statement I triedI expect the two <null> values in the screenshot above to get the value ‘yes’, but it doesn't. What am I missing here?

FME Server 2022.2Build 22765 - win64I have an ArcGIS Portal Feature Service writer set up to update a single attribute. I am getting the following error ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: 'Unable to complete operation.'. Details: 'True curve update not allowed.'I have specified to not update the spatial column so I would expect this error would not occur. It would appear that FME is trying to send a geometry

Hello,I have been looking for ways to convert multi-point geometries to lines but havent been 100% successful so far. Given is a data set consisting of multi-point geometries identified by a unique key and various attributes.Its a straightforward matter when the sequence of points forms a linear shape:Deaggregate the multi-point geometries and feed the single points to a line builder which groups the lines by the unique key. However it is not so straightforward when the points form an arc.In these cases the line builder creates shapes resembling spider webs rather than arcs.I tried various ways to sort the points spatially (e.g. with the spatial sorter) to better set up the line builder but so far without much success.Can you think of other ways to deal with this kind of case? Kind regardsRicky 

Hi.I just had a job on our FME server 2022.2.2 go haywire.When reading from one or more database tables, it suddenly spews out a _lot_ of error messages, repeating the same two lines from line 319 to line 865997 (on page 1734):Microsoft SQL Server Spatial Reader: An internal error has occurred. Please visit http://www.safe.com/supportMicrosoft SQL Server Spatial Reader: Failed to parse datetime, attribute set as nullWhat gives ? Should I be concerned ?I've occasionally encountered huge log files before, but haven't had any idea why. Next time I'll see if it's the same issue.The job took several minutes (as opposed to normally a handful of seconds) to finish, which is not good.Cheers.

Hello! I’m working on building a scalable FME workspace that can update multiple databases using a configuration CSV file. The CSV includes: Database connections, Table names, Field names (used to map different attribute names across databases)Since each database may use different field names for the same data, I added a “Field Name” column to the CSV to facilitate attribute mapping.What I am trying to do is loop through each row in the CSV, and for each row: Read the database connection and table name, Use the field names from the CSV to map attributes dynamically, Join the data with another source using a Feature Merger. Perform updates based on the joined data.To do this, I’ve:Read the CSV into a list. Set up a counter and a list element extractor to go through one row at a time. Used a Tester to check each row and feed the correct connection and table name into a FeatureReader. After the FeatureReader, I merge it with another dataset and apply logic to update the database.The Roadb

Good morning, friends. I have the following FMW. I want to cut the different geopack entries so that the top one cuts the one immediately below, creating a sort of pyramid that corresponds to the building's heights. I don't know what I have wrong with the custom transformer.In this case, there are this number of heights; in others, there are more or less, meaning they vary.Thank you.

The Documentation for the @DateTimeFormat Function clearly states that parsing ISO 8601 format is supported:“Formats FME or ISO date, time, and datetime strings into a custom format [...] Arguments: <datetime> [...] Date, time, or datetime string in Standard FME Date/Time Format or ISO 8601 date and time format.”, so using PT1H as datetime Argument should be valid.But the Parsing of ISO 8601 date and time format fails:AttributeManager: Failed to parse 'PT1H' as a datetime value. For FME datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm . For ISO datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm#ISO-8601-Duration-FormatFailed to evaluate expression '@DateTimeFormat(PT1H,%H)'. Result is set to null FME Form 2025.1.2.0 (20250829 - Build 25630)

Hi,I’m having trouble with AmazonBedrockConnector and I believe it’s an error with how the transformer has been authored.The issue is that the transformer processes and outputs the square of the number of input records. If I input 13 records, it will process 169 (to AWS Bedrock!), and then output them. If I input 313 records, it will attempt to process and return 97,969 records (I’ve found this out the hard way).By embedding the transformer and then editing it, I was able to view the flow of information from a source workspace. The issue seems to be in the calling and validation of AWS Inference Profiles, in that they are checked to be active, and then joined back to the original input records (obviously to allow error checking and rejection). As downloaded, the transformer looks like this:Note that the 13 input records are joined back against each other to create 169 records that are ulimately sent to the Bedrock API. I can see no valid reason to keep all of the original records out o

After a week+ of trial and error I wonder. Have anyone managed to create an FBX-file with FME that contains terrainmodel + ortophoto draped on top. That can be opened WITH materials/texture directly in Navisworks? I have tried all settings - but can not make it work. The files open correctly in FME Data Inspector, Autodesk FBX Reviewe, 3dsmax, Lumion and even Infraworks. And also the export from Infraworks to Navisworks work OK! However I cant seem to be able to open the FBX-file directly in Navisworks - it only shows the terrain with no texture/material. Even when it shows the texture in the "materials" pane. Material is added on a Mesh-group and displays nicely before writing and as mentioned in the other software above.Some stuff I have tried:- All settings on the FBX-writer- Manually changing the scaleuints on the ASCII- file from 1 to 100 to scale to meters instead of default cm. It seems that there is some scaling issues between geometry / material or bug related to mat

Hello, I just upgraded to FME Form 2025.1.2 and am having a problem with the Google Sheets Reader. The Reader previously worked in FME 2024.x, but I am now getting a very ambiguous error whenever I try to read a sheet into a workspace. I literally just upgraded this morning after initially opening the workspace in Form 2024 and successfully running it, so I know nothing has changed on my computer or anything otherwise. Any ideas what I am doing wrong? 

I’m trying to use conditionnal parameters in one of my FME workbenches, and I’m running into a problem where I can’t seem to be able to handle the the <Unused> value that results in trying to read a disabled parameter.Here I have a workbench with 2 parameters, one checkbox that determines whether to verify that values have been reported for the date where the flow is running, and a conditionnal field where one timestamp can be entered (as I normally use FME Flow’s “Event Timestamp” as input for this field).Within FME Form, if FME_LAUNCH_TIME is disabled, it will have the value “＜Unused＞” (it’s a text string, reported as such by PythonCaller and ParameterFetcher). This is… inconveinient because “＜Unused＞” (I can’t even type it in the community forums, the system thinks it’s an HTML tag) is not considered null/missing/empty/not-a-value by conditional operators, but it is also a reserved value, meaning you’re often forbidden from even writing it.I am literally unable to write that f

Hi everyone,on my local machine, I have installed multiple FME versions (2023.2.6, 2024.2.4 & 2025.0). In our company we work extensively with git and i use the Workbench Git integration from the command line. However, if I want to diff Workspaces that were modified with the newer versions (only tested for 2025.0) the command “git diff” launches FME 2023.2.6. This is not useful, because if there are e.g. Transformers that have a newer version, i guess one that is not supported in the older versions, the “Compare Workspace” Tool (2023.2.6 version) cannot display them.Is there a way to specify which version of FME should be used when executing the git diff command? Thanks for your helpCheers!

Hi,I wonder if someone could help me?I would like to merge pdf files in one folder (folder1.png)with pdf files in different folder (folder2.png) based on data in excel (merge.png). For an example, merge 1.pdf in folder1 with 421.pdf,422.pdf,423.pdf in folder2 like it says in the table. And 2.pdf in folder1 with 424.pdf, 425.pdf in folder2 and so on...Is that possible?Thank you, Jasna 

Just sharing information about a new feature I found."Enable Performance Profiling" would be introduced in FME 2025.2 Workbench. You will be able to log detailed performance profiling on workspace run easily whithout editing header.Have been waiting for 10+ years :-)Sharing: Detailed Profiling of Workspace Running Performance[Addition] The command is available since FME 2025.1. I have overlooked that... 

I have a fileGDB with many records, of which I only want to read a Selection.I know how to use the Search Envelope to select records in a bounding boxIs there also a way of Selecting records where an Attribute equals a value? (actually one of three values)Or is the only way with a Transformer after the Reader?Just trying to optimise

So I’ve been experimenting with using FME to build specific AI agents/agentic workflows.I’m using OpenAI’s API and leveraging function calling. It’s been quite fun and a really good learning experience. You can let the agent make decisions - if you give it tools to use then you can use looping transformers to let it use the various tools you give it, constantly updating it’s context. Looping transformers are a bit of a paint to work with and hopefully there could be something done in this space to make building these tools in FME easier. I’m still not sure what the best way to do this is or even if it makes any sense to use FME for this but I made some progress anyway:for example: should the tools be other CustomTransfomers for example or whole workspaces or maybe both. Should this be something somehow handled in Automations rather than a workspace? So many optionsSo far the agent isn’t interactive and I’m just putting all the context into the logfile, but in the end it would be real n