A space to discuss FME Form
Recently active
I have configured all parameters on manage web services for Dropbox. But I am having to reauthenticate every time I run the workspace. What should I be checking? I also need to schedule it on Server. I am not being able to authorize it on Server as well. Any feedback is highly appreciated.
About once or twice a year I have to dig out the SystemCaller, mostly just because I have to trigger a PowerShell command or script file. Without fail, I end up frustrated by the byzantine syntax (quotes galore) and limited way to capture output, finally succumbing to unnecessarily re-implementing the whole thing in Python.So my pick for the transformer that really needs some love and attention from the developers is the good-old SystemCaller :-)Do you also have a pet peeve Transformer that you think could be improved upon?
Below is a screenshot of my workspace that creates a new feature class (AttributeManager_6_Output). This feature class will be edited by end users in ArcGIS Pro. I need to bring that feature class back into the workspace and join it back to caputure those edits. My problem is that some of the attributes will be updated upstream as well. I need to capture those edits as well without overwriting the end user edits. How am I able to set the attribute conflict independently (some attributes from Left and some from Right) in the FeatureJoiner?
Hello Community,I wonder if anyone has recent experience with Bentley POD Reader. This reader requires installed and licensed Bentley Pointools, which has been deprecated for several years by now and can not be purchased anymore. Is there another way to read POD files with FME? Can Pointools be replaced with something else to enable POD Reader?Thank you
Ever since the merging of SQLServer spatial and SQL Server non-spatial Reader types, my SQLCreators and SQLExecutors generate a warning:Microsoft SQL Server Reader: Table `___FME_Custom_SQL_Statement___' does not include a spatial column. Geometry will not be read In Form this is easily ignored, but it really messes up my Jobs overview dashboard on Flow, because it results in quite a lot of listings with warnings that do not need checking. And I can’t seem to find a way to tell FME that yes, I know, there is no geometry coming through in this sql, don’t worry about it because I did not select it - on purpose (or because it does not exist).I really do not want to turn off all warnings generically, I am just searching for a way to stop this particular warning. Before the merge it was easy: just use the non-spatial type, and the warning would go away. But that is not an option anymore unfortunately...
Hi all,I’m encountering an issue with the InlineQuerier transformer in FME Form 2024.2.1 (pre-production environment) that seems to differ from previous behavior.(FME Form 2024.1.3 in developement environment)🔧 Workspace Setup:The InlineQuerier has two input ports:tubes (can sometimes receive no features)parametre_generique (always receives data)I’m using this request :❗ Problem:When no data arrives at the tube input port, the transformer throws the following errors:InlineQuerier_2 (InlineQueryFactory): Generating output 'tubes_statuts_inactifs' using query 'SELECT * FROM "tubes"WHERE ( UPPER("statut_administratif") NOT IN ( SELECT TRIM(UPPER(value)) FROM "parametre_generique", json_each( '["' || REPLACE("valeur_parametre_text", '|', '","') || '"]' ) WHERE code_parametre = 'STATUT_ADMINISTRATIF_RETENU_TUBES' ) OR UPPER("statut_operationnel") NOT IN ( SELECT TRIM(UPPER(value)) FROM "parametre_generiq
We have over 300 FME dataflows using multiple Oracle databases. We are trying to figure out how to list all the different tables and schemas used by all the dataflows together.
Hi Everyone,We are working on an integration between ArcGIS Utility Network and SAp using FME to connect with SAP via their Odata services and Integration Suite.We have successfully used Get calls from FME desktop to fetch a token and get information about an asset.When we switch using a POST call to create a new asset we get a response error of “HTTP/1.1 403 Forbidden” and response body “CSRF token validation failed”The calls we are using have been successful from postman through integration suite.I have attached the workbench containing the current settings and the latest log file.Any insight i why this would work for GET calls and not for POST calls
Hello everyone,I looked at thread DGN writer RGB color | Community and I am dealing with the same problem.Ideally I would like to get the RGB color (true values) instead of the colorindex from the color table.I read in the above thread that true color should be available from FME Form 2023 on, but I still get the index number from the color table. Iam using FME Form 2024.2.1 by the way.I do the following thingI have a dgn styler configurated as follows in the Writer I use a seedfile with RGB values for the layers Output is Am I doing somethign wrong or are true colors not yet available in FME 2024.2.1?
I want to convert OSM data downloaded in .osm.pbf format into OSM format, but I’m encountering the following issue:When converting from .osm.pbf to .osm in FME, the OSM XML data is incorrect: all polygons (areas) become lines, and many objects are missing. I tried using Osmium Docker for the conversion, and the OSM data remained intact.Is there a way to achieve the same result as Osmium within FME? Am I missing something?
Hello everyone,I ran into a connection problem when upgrading from FME Desktop 2021 (21812) to FME Form 2025 (25836) and wanted to share the details and the fix in case it helps others.In FME Desktop 2021, I was using version 3.14.5 of the JDBC driver for Snowflake, and we were initializing a complete connection string with a key pair:Advanced Connection Parameters Connection String with user, warehouse, db, schema, role, private_key_file, private_key_file_pwd.It worked fine for years. Now migrating to FME Form 2025, I encountered a weird behavior.For a workspace from the 2021 version opened with the 2025 version, the Snowflake connection doesn’t work. Upgrading the transformers and the readers doesn’t change anything. It is really the database connection not working in the options. I got this message:COM.safe.fme.jdbc.TranslationFailureException: java.lang.IllegalStateException: Unable to verify current schema and / or database But for some completely strange and mysterious reason, th
Hi,I have run into behaviour in FME Form that I don't understand. I want to read an OGC API (WFS3.0) point features from any of these collections ( https://api.pdok.nl/lv/bgt/ogc/v1/ ) within a bounding box that I create based on input features.I dynamically create a bounding box (my random example: 6.7337723637079705,53.153741409492596,6.742906946412802,53.15869110582926 ) in a workflow before the FeatureReader.When I add the featurereader without any collection query parameters and save it so it generates the output port. And then I open the parameters and set bbox to the attribute value from the bbox (and also ‘limit’ to 1000). These parameters are not applied and used. Only when I regenerate the output port it applies any HARDCODED values. I cannot feed any dynamic value from a user parameter/attribute.If this is intended behaviour in FME: why? It seems so unnatural to not be able to dynamically feed the query parameters.Hopefully someone can help me out!
I have got an inital line featureclass from which I make a new one with splitted the lines, based on a measure table (MeasureGenerator, FeatureMerger, Snipper). I want to make a fme tool that can update this featureclass based on an updated measure table. I want to conditional handle the attribute values of all changes in the new feature class. Measure:0-2000;2000-4000;4000-8000 (measure in meters)Becomes Measure:0-1000;1000-2000;2000-2500;2500-5000;5000-8000Makes combined:0-1000;1000-2000;2000-2500;2500-4000;4000-5000; 5000-8000In the record of 0-1000 should be the attributes (Start, End, etc) of ‘Measure’ and ‘Becomes Measure’ so I can check from which former feature the new feature will get the attributes. This will be based on the largest overlap in length. I have tried this with the LinOnLineOverlayer. Here the line output does not give the answer and the point output gives all the answers except for when the endpoint is the same (0-2000 and 1000-2000).How should I do this? Am I
The white rectangle is my polygon and the orange line is my line. I am trying to clip the polygon based on the length of the line.I was looking for an output like this. I have looked at this step and also this step but i am not getting a correct clip. Any ideas will be highly appreciated Thanks in advance,Keller.
I am using the “StringReplacer” transformer to replace commas with line breaks.My attribute value looks like this:ANGLE: von 115.65130615 auf 116,ident: von --- auf ON,ADRESSCODE: von 6 aufI tried replacing , with \n, but it does not create a new line.How can I correctly insert line breaks in FME?
Happy May Day!This works in 2024-2025 and breaks at 2026.1.I have several autocad format attributes selected (confusing methods to select see below). I go through many transformers and can see those same format attributes (1 for example autocad_entity_handle) all the way up to and including the attributemanagers (pictured). But looking in the attribute manager (This was an issue before upgrading the attributemanager transformer and is also an issue since I have upgraded the attribute managers). Many of the format attributes are gray. 1.What is the significance of this?Why if the autocad_entity_handle format attribute is enabled does it show as “not found” (red)?
Hello,I am trying to create a workflow reading a file from one path, rename to respect Autodesk Forma naming convention and upload to the Autodesk platform with a new name.However, I can only input the existing full path (so with the not yet adapted name) in the AutodeskDocsConnector.I don’t want to create a local intermediate copy, and wish to run this on Flow later, any idea ?Thank you !
Has anyone else encountered issues with the FeatureReader now returning fme_basename and fme_dataset information in 2025.2.1?In 2024, the FME attributes that were returned automatically are fme_feature_type, fme_geometry and fme_type. fme_basename and fme_dataset were only returned if they were set under Additional Attributes to Expose.In 2025, the Feature Reader returns both fme_basename and fme_dataset.This can cause issues where a workspace is merging data and it’s assumed the attributes coming from the Feature Reader don’t have these attributesJust to complicate matters further, a workspace written in 2024 but run on FME Flow 2025 follows the 2024 behaviour. If you download that same workspace and run it on FME Form 2025, the behaviour is different.
I am using the Esri ArcGIS Feature Service Writer to write to ArcGIS Enterprise (11.*). The writer is set to truncate the existing data and writing the data as such goes without any problem.However, when looking at the attribute table of the Feature Service Layer I can see that some of the timestamps are wrong.To write timestamps to the existing Feature Service Layer I am converting the timestamps to Unix epoch time and multiply by 1000 to get my milliseconds.Quick example: 2025110163722 → 1762011442000When writting data to the Feature Service Layer the attribute for the Unix epoch time is set to type ‘Date’. For the majority of the data the resulting timestamps in the Feature Service Layer is correct, but e.g. in case of the example above the epoch time is interpreted as:1762011442000 → 1/14/1762, 8:53 PM.I checked if there are leading or trailing white spaces… nothing the Unix timestamps in question are just like all the others where the interpretation goes well.I have to admit that
I have a parent workspace and that is calling a child workspace in FME Form using a WorkspaceRunner transformer. The child workspace references deployment parameters. When the child workspace is run from the WorkspaceRunner I receive the following error: ERROR : 2: Undefined macro `APP_API_URL' dereferenced in file. APP_API_URL is the name of a deployment parameter that I have permission granted. I tried creating a published parameter in the child workspace whose default value is the deployment parameter but I get the same result. Are deployment parameters not supported with WorkspaceRunner? FME(R) 2025.2.0.0 (20251120 - Build 25810 - WIN64)
Hi,I am having difficulties using the revit styler. I am feeding it 50 point features which get their own individual rotation value. But when I check the objects in revit, the rotation is slightly off. Sometimes by 20 degrees sometimes more. When i compare the correct angle in revit and compare it to the value i have in FME, I can see that they are correct but something is happening either when I use the revit styler or the writer that messes upp the rotation. I am rotating around the axis x= 0, y=0, Z=1. Any ideas why it is behaving like that? Am i missing some setting somewhere? Thanks for all advice!
Hello,I created an FME script in which I have 10 Readers and 10 Writers. I would like to run this script in a specific order. I don’t want FME to execute everything in parallel, but instead wait for Writer A to finish before reading Reader B… How is it possible to run things sequentially?Thank you for your help
I am really stuck on trying to cut some labels that overflow my frame when using the PDFPageFormatter. I have a bounding box which is used as the clipper extent for my data. It clips my lines, my points, but not my text labels. I guess that has to do with the fact that the anchor point is inside the frame, while the labels are too long and go over the clipping box, and don’t have real geometry. I have tried TextStroker - that does cut my labels, but they are not keeping the symbology I added + in a PDF, they are no longer selectable or searchable (I need them to be). I also tried buffering, but that will innevitably also discard labels that are supposed to be in the frame. In the PDFPageFormatter, I also set the “Clip Input Features” = Yes. I have had the same problem in FME 2025.2.3.0, FME 2026.1, and now in FME(R) 2026.2.0.0 20260401 - Build 26291. Updating did not help.Even if I tried to mask the overflowing labels by creating a thick white border around the map, the problem would r
Hi there,I have installed FME Flow 2026.1 in AWS has a High Availability WebUI/Core with distributed engines.The setup uses HTTPS on an internal url (corporate network)When I try to connect FME Form to Flow, I get the following error message Unable to retrieve public key from FlowUnable to establish secure communications with FlowDeployment parameter access failed (Connection Error) - Unable to connect to FME Flow. Has anybody seen this before? ThanksWhen I use the url in the browser on the same machine (tested on 2 different machines), i can log in using my admin user account
Hello ,n FME Workbench, I am trying to set up a workspace where multiple readers use a common main folder path.I created a user parameter for the main directory (root folder), and my goal is for each reader to use this main path while only specifying its own subfolder.However, when I add a new reader and configure its dataset path, it changes the same user parameter used by the other readers. As a result, all readers end up pointing to the same path, which is not what I want.How can I configure my workspace so that:One user parameter defines the main folder path, and Each reader can independently define its own subfolder without affecting the others?FME 2021 thanks in advance