FME Form

Hi I am using the OpenAIChatGPTConnecter in FME Form and entered all relevant details but receiving this error- Could not resolve hostname Obviously something network related, any further ideas? I cannot ping to the endpoint from command prompt.

I’m trying to follow the FME Form course from a MAC and one of the very first exercises is using a Esri Geodatabase (File Geodb Open API) writer. Unfortunately I’m getting this error on the platform. Is there any workaround for this?

Hello Team,I have an Excel template with a single worksheet that includes predefined colours, formatting, etc.In version 2025.0, I’m trying to write my results into this template, but I want to output multiple worksheets within the same workbook using the same template. I’ve tried several approaches (both dynamic and manual), but they either fail or behave unexpectedly.What I’m seeing is that only the first worksheet shows the designed template but no results, while the subsequent worksheets contain the results but lose the template formatting. Even when I set Remove Template Sheet if Unchanged to Yes, the first worksheet (the template sheet) is still present with no results filled in.Does anyone know whether this is achievable in version 2025.0? If so, how should it be configured in the Excel Writer?Kind regardsThanks!

Hello All Please any idea / guess how i could maintain the intensity in output and decimate E57 point cloud file. Below is my current workflow. This is my first time working with E57 filetype.  

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

I have an HTTP caller using a GET Request, to access an API site using a Web Connection for authentication. I am trying to find a way for it to return (either within the JSON response body or otherwise) the access token which is generated when the process runsI have Accept and Content Type as my headers. I have tried: Storing the cookies doing grant_type = client_credentials in the Query String Parameters.  Creating a list for the Headers (no token content within that)In the setting for my web connection, I have this:But I am not returning anything called ‘access_token’ in the response body. To be clear, my process works as intended, but due to new constraints we need to store the access token that is generated every time to store it to use downstream

I have a workbench that takes data from Oracle, merges it with a few other tables, runs it through a schema scanner and then tries to output to a file geodatabase.The file geodatabase has the merged table created but it only contains the schema definition not the data. The output from the schema scanner shows the points in the graphics display. These are the transformers that scan and output Here is the Feature Writer  The summary is showing the feature count   There is some disconnect between the schema scanner and my output and was hoping someone might be able to see what I am doing wrong. The workbench is attached. Any assistance would be greatly appreciated.  

I am not sure why I am struggling with this one… I have tried quite a few options.  What I would like to do is:Pull Alignment file from an XML (this has the starting value as an attribute, end value can be calculated by start value + line length) Set Start and End Measures Kick out an m-enabled polyline that is geometrically calibratedI have the workbench set up to pull this in, using a geometry coercer to make sure it is a line, then I have been trying the measure generator and measure setters to get these values to stick with no luck.    

HiI am encountering a critical issue when using the ArcGIS Online Feature Service Writer (within a FeatureWriter transformer) in a dynamic workspace.When a specific column contains data that AGOL deems "invalid HTML" (e.g., strings containing <, >, or specific URL parameters), the translation fails with a Fatal Error. Instead of rejecting only the problematic feature or failing just that specific layer, the entire FME Engine stops, preventing the rest of the workspace from processing other layers. I have a custom Transformer that read, process and write individual layer. this custom transformer has a group by set to unique layer id.Current Configuration:Writer: ESRI Feature Service Writer (Dynamic).Transformer: FeatureWriterError Message: ArcGIS Online Feature Service Writer: 'column_name' has invalid HTML content.What I Need Help With:Error Handling: How can I configure the FeatureWriter or the AGOL ESRI Feature Service writer to "ignore" or "skip" features with invalid HTML con

I would like to use gdalinfo to read the metadata/header for a folder of rasterfiles to get the extent and of each file. Ggalinfo can read this without loading the raster itself. This greatly speeds up the process.Can we use the gdal implementation of FME to do this and if so how? The goal is to also have this working on FME Flow.Example of gdalinfo output:gdalinfo "C:\path\to\file\1.img"Driver: HFA/Erdas Imagine Images (.img)Files: C:\path\to\file\1.imgSize is 200, 130Origin = (209000.000000000000000,529000.000000000000000)Pixel Size = (100.000000000000000,-100.000000000000000)Metadata:  DataType=GenericCorner Coordinates:Upper Left  (  209000.000,  529000.000)Lower Left  (  209000.000,  516000.000)Upper Right (  229000.000,  529000.000)Lower Right (  229000.000,  516000.000)Center      (  219000.000,  522500.000)Band 1 Block=64x64 Type=Float32, ColorInterp=Undefined  Description = Layer_1  Min=-54.770 Max=-21.170  Minimum=-54.770, Maximum=-21.170, Mean=-40.290, StdDev=6.935  NoData V

 Hi,I am using the Matcher transformer to find pairs of features with the same attribute value.Now I want to create a new attribute rel_obj that stores the ObjectID of the other feature in the matched pair as in the image. What is the best way to implement this in FME?Thanks 

Hi, I have many LAS tiles with gps_time component. Gps time values are in standard GPS Time : ex 363439432.1942503 I would like to display the minimum and maximum times in DD/MM/YYYY HH:MM:SS format. I can use the PointCloudStatisticsCalculator to get the minimum and maximum values, but I can't work out how to convert 363439432.1942503 to the required format. Any idea? Thanks u ! 

Hi everyone,I am working in FME and would like to orient the flow direction of a gas network.Data: main supply lines service lines connected to gas connections Destination  points – representing the gas service connection locations Objective:My goal is to ensure that all Service lines are oriented towards the Gas Service connection points.If a line is digitized in the opposite direction, it should be automatically reversed.Additionally, some lines connected to Service Connection points   are split into multiple segments. I need all connected segments to have a consistent direction towards the same Service Connection points .What I tried: I used the NetworkFlowOrientor transformer I applied a Anchoredsnapper beforehand to ensure that each Service connections point lies exactly on the endpoint of the corresponding Service  lines Problem: The NetworkFlowOrientor returns no output Questions: What is the correct workflow to ensure that all Service  line segments are consistently orien

Hi, I want to import the WFS service from Digitaal Vlaanderen, specifically the address registry, but my FME only imports a maximum of 10,000 features.I had found that it was possible via paging, but apparently that is no longer supported, or at least I can’t find it. It should then be done via loops, but I’m stuck. I found that it should be possible using an HTTP caller and JSON fragmenter, but I’m already stuck with my HTTP caller. Could someone help me set this up correctly? The URL is https://geo.api.vlaanderen.be/Adressenregister/wfs?REQUEST=GetCapabilities&SERVICE=WFS      

I have attempted to use the NeighborFinder transformer to achieve a one-to-many join; however, it is not producing the expected results.In my case, the base dataset contains values such as 30,511 and 55,867, and my expectation is to match all records where the base value is greater than 30,511.Since NeighborFinder does not seem suitable for this requirement, could you please suggest an alternative transformer or approach to achieve this condition-based matching?Thank you. 

Hi FME gurus. I am trying to extract values from a list to populate columns with the associated values in the fields.  In my list (called _columns) I have a caption field which has the name of the column I want to create and the date value I want to populate into the field so the example I have in the screenshot I want to look like this: Application ID Last Inspection Next Inspn Due 648343 2025-06-23 2026-06-16 15456.. 2025…. 2026….  The list exploding only brings out the name of the original column ‘caption’ but I am looking to use the values in the list itself to build the attributes and populate the values. There are records with more than 2 elements in the list and I still will need to figure out how to expose the attributes (schema scanner?) once it is done but this is the first step. Any suggestions would be amazing, Thank you.Michael.

Moving this to FME Form Q/A.  

Good day,I have a table with a couple of records.I would like to keep one record per category and this record should be the record which has the less attributes with a null (missing) value (I highlighted them in green on the screenshot.). How can I automatically calculate which record per category I should keep? 

Within the new ArcGIS Feature Service reader (part of the Esri ArcGIS Connector Package) if you choose a source type of Enterprise it’s not possible to connect to a feature service that is shared across an entire organisation and not in a group.This can be done if you use a Source Type of Standalone Server (but it’s not obvious).It would be nice to have and Item Source of Organisation which would allow connection without specifying a Group 

When using ArcGIS Feature Service (reader, writer, featurereader, featurewriter) I am only able to reference items using Folder and then featureservice name + itemid (in paranthesis after the name). Is it possible to directly refer to a service using only itemid?(for my case the data is hosted on my institution’s AGOL)

I’m creating a workspace that reads 7-8 tables from a file geodatabase and then writes them into tables in a SQL database.  One of the tables is sometimes present and sometimes missing (that is expected).  I need to create a workflow where when the table is present we write the data into the SQL table and when it is not present we just truncate that same table in the SQL database.  I currently have a gdb reader connected to a tester that passes when fme_feature_type Like MSAG_To_RCL_Synchronization. This works when the table is there but when it’s missing the reader just closes and gives the message “The table name 'MSAG_To_RCL_Synchronization' could not be found in the Geodatabase as either a feature class or a table” and closes before any input gets to the tester. Any ideas on how to conditionally test if a table exist or not and then either write the data or truncate a SQL table. 

It seems I have no place to force FME to include the code_verifier parameter in the request body to obtain a token (see requirements below). Any ideas of how to work around this in FME? The postman equivalent is selecting the grant type as "Authorization Code (with PKCE)". I can use the same challenge and verifier more than once, just need to include it in the body rather than a querystring.  Per the platform's API docs: Parameters sent in Request Body, Form-URL Encoded. (cannot use JSON or querystring)code=<code received in callback url>client_id=<Application OAuth Client ID>client_secret=<Application OAuth Client Secret>grant_type=authorization_coderedirect_uri=<User redirect URL (from step 4)>code_verifier=<User Generated Code Verifier>  

Hi all.I just experimented with a small workflow, that scans a folder for files, and attempts to read those files using the generic format.I tried with CSV and DGN, and both worked well.I then tried with Geopackage, and then it blew up.First because FME’s guess using the extension was wrong, so I had to parametricize the format used.Then it blew up with an internal error message (“Too many recursive macro substitutions”):2026-03-03 15:14:24| 2.6| 0.0|WARN |UniversalReader -- readSchema resulted in 0 schema features being returned2026-03-03 15:14:24| 2.6| 0.0|ERROR |Too many recursive macro substitutions -- line currently is: `SOURCE_READER GENERIC REAL_FORMAT "$(REAL_FORMAT)" EXPOSED_ATTRS "$($(FORMAT_SHORT_NAME)_EXPOSE_FORMAT_ATTRS)"'2026-03-03 15:14:24| 2.6| 0.0|ERROR |class stk::ex::UString<0> __cdecl tabrdr::ClassicTableReader::macroSubstitute(const class stk::ex::UString<0> &,int)(C:\code\fme\foundation\framework\engine\tabrdr\tabrd

As the title suggests, I’m having an issue when running FME (2022.2) from the command line. I’m clipping several LAZ files with a polygon grid, and FME automatically puts the output files in one folder per LAZ file. I’m technically fine with this behavior as I was going to fan it out anyway, but the extension is included in the folder name (e.g. FILENAME_1.laz), which the following processing step in my pipeline cannot handle.  The problem only occurs when run in the command line. Is there any setting anywhere so that I can get rid of the file extension in the folder names? 

I have the exact same issue as is described here: That topic is closed, so I'm starting a new one over here. I got the error “Check the geometry of such feature is valid and is not too small for the resolution”, while updating a feature. I use FME Form and Flow 2025.1.2 and ArcGIS Pro 3.3.1 with ArcGIS Enterprise 11.3.At first I also thought the issue only occurred in FME Flow, not in FME Form. But now I'm checking the issue again and it is also in Form.In my case I use the ChangeDetector to check if the feature exists and if so if it is changed. If it existed and is changed, I'm also using the Update Mode in a FeatureWriter. I tested with not updating the spatial column, but that didn't make any difference. I still got the error. And I am positive the geometry didn't even change: setting the ChangeDetector to only check geometry sends the feature to the Unchanged port.I don't really understand the solution in the other topic, but it seems I have to delete some data. But that sort of d