FME Form

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

While looking through a folder of workspaces with a text editor, I noticed that one workspace fmw file was not in the usual XML-like format. It was instead a JSON file with a leading header line:# application/x-fme-json-workspaceThe last build/saved metadata states "FME(R) 2020.0.2.1 (20200511 - Build 20238 - WIN64)" - however when I create a new workspace with this version, it is saved in the XML format. I tried a variety of FME Desktop versions from 2019 to the most recent 2022, none save to JSON, but all are able to open the JSON fmw. This question is in part simply out of curiosity, and also because I have made a small Python script that iterates over a folder to gather some metadata that the WorkspaceReader does not publish (luckily the attributes I'm looking for are in the same "path" in both formats).

Hello !I want to extract files wich have everytime a different expression but  there is some text who would be everytime in the file name :Example : [200072692_ZONE_URBA_20220412] “ZONE_URBA” will be the text present everytime in my extract file.I want the String Searcher to download the files which only contains “ZONE_URBA”The numbers in the example before and after “ZONE_URBA” will change everytime because they are the number of the EPCI (french administrative numbers)After calling ZIP file from HTTP with HTTPCaller, I use the ZipExtractor to extract the zip file.Then I use the StringSearcher but I don’t know how to configure the parameters to recover only the ZONE_URBA files … Anyone got an idea ? I think it’s not something impossible but i’m beginner.Sorry for my english, I promised I’ll improve !!Thanks a lot Here my work chain : 

I have a MapInfo table which I want to modify by inserting and/or deleting records.I would like to modify the MapInfo table in place.I think that I can use the Precisely MapInfo Extended TAB Writer Feature Type Parameters?https://docs.safe.com/fme/2022.1/html/FME_Desktop_Documentation/FME_ReadersWriters/mapinfo_extended/mapinfo_extended-ft-param-w.htmMy software is FME Desktop FME(R) 2022.1.3.0 (20220928 - Build 22630 - WIN64)But how do I build a workspace that performs this task?How do I build a Writer transformer that recognises an existing MapInfo table? 

Hi all,I seem to have an issue with writing to the Temp folder location (E:\\Temp, in this case). I will get an error like the following -Failed to write feature data to `E:\\temp\\wb-cache-NSPL_V3.2_ShortName-rUhMFp\\Main_FeatureJoiner_20 -1 24 fo 0 JOINED 0 6641bd2679d46e05f371fbb029766a8cafbc270f.ffsupdating' I've tried creating a new workspace from scratch, renaming it and I am able to copy files to that folder without any issue. I also ran FME Workbench with elevated privileges and as a different user, even with a different Temp location but no success with any of them. Has anyone here had anything like this occur? And if so, is there a known way to resolve it? I've deleted all Temp files and again, no change. All a bit odd out of nowhere!Thank you

I am having some issues converting a .NVD to .GDB to display in ArcGIS Pro. I can get the attributes all across but cannot view the geometry in FME Does anyone have any guidance on how to transform the geometry so it displays in a geodatabase in ArcGIS Pro?Thanks

Question:Is there a way to speedup the geocoding process or an alternative approach like a diifferent Geocoding service people got good results from?Background of question:I have a dataset of 21.000 adresses and want to geocode them using the Geocoder.Geocoding Service: OpenStreetMapMode: FowardTo run the first batch of 500 adresses took approx. 10 minute to run which is not that fast to be honest.  

I’m migrating to ArcGIS Pro and working on a workflow to convert geodb_pro_annotations to geodb_annotations so that I can edit/create annotations in ArcGIS Pro and downgrade them so that they can be used in ArcMap and read with a legacy tool (that currently has no ArcGIS Pro upgrade path).I seem to be having an issue writing some of the features to a new local FGDB where the FeatureWriter errors out with the following message:“An error occurred while attempting to create a feature using the feature class 'StreetName_Rural_Smaller_LEVEL_63'. The error number from ArcObjects is: '-2147220947'. The error message from ArcObjects is: {Cannot acquire a lock.}”The data is created/edited in an SDE and exported to a local FGDB for this downgrade. There are 25 annotation features containing 1 to 2,000,000 annotation records. This error seems to only occur on annotation features with more than 500,000 annotation records. The others are able to be written out to the FGDB with no issues.I’ve tried

I have a word template with me and I would like to use that template to create a new document along with the custom content dynamically. Cheers,Srikanth

Hi,I have a CSV file containing ObjectID and associated AttachmentNumber values.I want to group the ObjectIDs so that the total number of attachments in each group is as close to 1,000 as possible.How can I achieve this?

Hi, I use a FeatureReader for two purposes: to clip features with a polygon, and to select some desired geodatabase layers (of several geometry types: point, line and polygon).After the “succesful translation” the new geodatabase has been created. However, this database seems to be empty.What could be possible causes? Wrong Schema/Data Features of the FeatureReader? In the Reader I have:In the Writer I have:Connectiefile is the file where the polygon for the clipping purpose can be found. Other schema sources are not available.Any ideas?

Hi all,I have .shp data sets (100+) which I read with feature reader. The attributes’ values are saved as list ,attribute “ID” for shopA.shp has values as {0, 2, 4, 8} and another attribute “Desc_”: {cake, bread, drink}, my aim is to save them as json file so the json will look:{   "uuid" : "1b2299d1-b97a-48d9-9a99-9994491ebb34",   "path_directory_windows" : "O:\\M\\A\\B\\",   "members" : [      {         "base_name" : "shopA.shp",         "created" : "20240225",         “attributes” : [“ID”: “long”, “0, 2, 4, 8”, min = 0, max = 8, mean = 3.5, median = 3, mode = None,“Desc” : char(256), “cake, bread, drink”     ]      },      {   "uuid" : "322299d1-b94a-48d9-9a99-99944912bb34",   "path_directory_windows" : "O:\\M\\A\\C\\",   "members" : [      {         "base_name" : "shopB.shp",         "created" : "20240225",         “attributes” : [“ID”: “long”, “1, 2, 3, 4”, min = 1, max = 4, mean = 2.5, median = 2.5, mode = None,“Desc” : char(256), “cake, orange, apple”     ]      }, Thank you so

Hi,I’m having trouble retrieving only the number of attachments associated with each Object ID for a layer published to ArcGIS Enterprise.Currently, the only way I’ve found is by expanding the full list of attachments, but this process becomes very slow when dealing with a large number of attachments.Is there a more efficient method to get just the count of attachments per Object ID without having to load the full attachment details?Thanks in advance for any guidance.

​  TLDR: sys.path does not contain FME_MF_DIR, so I can’t directly import a local Python module. This contradicts FME’s documentation. What am I missing? Hi all,I’m having problems importing a local Python module located in the same directory as my FME workspace. Could you help me find out what the problem is or am I missing something?According to the PythonCaller documentation,FME will search both the standard Python module locations and the workspace location to find the module to be imported.However, when I try to import my module in <workspace directory>/feature_processor/__init__.py with the following code:from feature_processor import FeatureProcessorI get the following exception:Message Type: fme::internal::_v0::py::ExceptionPython Exception <ModuleNotFoundError>: No module named 'feature_processor'Error executing string `from feature_processor import FeatureProcessor'Factory proxy not initializedFeatureProcessor (PythonFactory): PythonFactory failed to process featu

I'm working with FME 2021 and have run into a challenge regarding dynamic GeoJSON handling.I use the HTTPCaller to retrieve GeoJSON from several hundred different services. Each service returns features with different attribute schemas. My goal is to dynamically expose all attributes and the geometry from each GeoJSON response and write them to various formats (e.g., GDB, Shapefile, etc.).I've tested workflows using JSONFragmenter and manually selected attributes, but this approach doesn't scale—it’s not feasible to manually configure the schema for hundreds of unique GeoJSON sources.Is there a robust and dynamic way in FME 2021 to automatically expose all properties (attributes) in each feature, regardless of schema, along with the geometry?Appreciate any guidance or best practices for handling this kind of dynamic schema in FME 2021.

I need to get from an Excel configuration file a parameter for the Buffer distance of a Bufferer transformer.What’s the best way to do this in order for the parameter to be accessible by the Bufferer transformer ?I have tried the VariableSetter and VariableRetriever transformers but what I don’t like about it is that I give the value to every feature that passes through VariableRetriever.Plus the VariableSetter/Retriever method doesn’t work well with cache.

I want to publish feature services to arcgis enterprise portal not using ArcGIS Pro [Share ribbon] tools. Is FME an appropriate tool for this or is it better to use arcpy and the arcgis python API?The source feature classes are in SQL Server in Enterprise Geodatabase. The GDB is registered with Portal as a datastore. We do not want to copy the data to Portal (the resulting feature services should not be hosted).

I was extracting tables from a PDF file by following the steps in  https://support.safe.com/hc/en-us/articles/25407564475277-Extracting-Text-and-Tabular-Data-from-PDF#h_01HW3Z9Z37Q33NQQ7R0XBGEVB0. However, I encountered a challenge some words are misspelled or broken when extracted, even though they appear correctly in the PDF viewer. I suspect this is because the PDF was exported from a graphic design app such as Adobe Illustrator. I realized this when I copied text from the PDF and pasted it into a Word document the same issue occurred (correct me if I’m wrong) is there a transformer can help fix or reconstruct the text?  

We need a way to detect/test for Arcs in our Esri SDE database.   We manage a large road line segment.  The system that uses this data does not accept Arcs, just polylines. Previously, we edited our data in ArcMap, then run a nightly job to check our data in FME.  Using the PathSplitter, followed by the GeometryFilter we could then find any Arcs that had been introduced into our data. Now that we are editing our data within ArcGIS Pro, it seems that Arcs show up as an Arc within Pro, but in FME, the segments show up as Lines and are not flagged with the workflow, mentioned above, using PathSplitter and GeometryFilter. How can we filter/test to find the Arcs in our data?UsingFME 2024.1ArcPro 3.2.3ESRI SQL SDE 10.9.1Example Arc attached in FGDB.  Then the Feature is opened in ArcPro, and an edit session is started to ‘Edit Vertices’, we can see that there is a verity that controls the curve of the line. 

Hello, I want to replace the list of attributes of the ChangeDetector with a user parameter. The attributes of the original and revised features are not exposed. The user parameter is in Python: it's a string derived from another parameter (example: 'field1 field2 field3'). I don't get any error but I guess values are not considered.I have the same problem​ with other transformers based on the same attribute list type (AttributeExposer).It is an issue or a problem with the string? Thank you

Hello, I am having difficulties creating a spreadsheet with 2 sheets. In the screenshots included I have 2 Excel Writers. I have chosen Fanout Dataset since I want the file name to include a timestamp. The workspace runs successfully. But only a single sheet in the spreadsheet is written. Daily Totals is included as a sheet in the spreadsheet, and Running Total is not. What do I need to do in order to include both sheets: Daily Totals and Running Total (seen as two Writers in the screenshots below). When I do not choose Fanout Dataset, the two sheets are written to the spreadsheet, but the file name has no timestamp. When I use Fanout Dataset one sheet is written to the spreadsheet and the file name has the timestamp.  My workspace includes the DateTimeStamper Transformer that creates the _timestamp attribute..    

I need to transfer a PG table that has a geometry (line) field in below format, to another PG table on another database using FME. I know it’s already in the workable final format. If I just run queries as below and save results directly to the target database using DBeaver, it works fine.            geomfromewkt(comm_path_line_geo)::geometry as sp_geometry But somehow it’s not working on FME to transfer from one to the other. I tried SQLExecutor alone and also with GeometryReplacer.I tried queries inside SQLExecutor this way:select geomfromewkt(comm_path_line_geo)::geometry as geometry from my_table and this way:select comm_path_line_geo::text from my_table  and then to process with GeometryReplacer and also this way:select comm_path_line_geo as sp_geometry         with this, the FME transformer would convert automatically convert it to binary geometry format but it’s not usable at the end tool.  They all didn’t work. Can someone please help? I know this shouldn’t be that difficult be

Hi,I am facing the problem mentioned in the title, especially when I want to detect Self-Intersections in 2D. FME detects a lot more Self-Intersections while PostGIS is fine with the geometry.What are the reasons?As we want to build up a standard quality gate for our data, I need to be certain that both ways - either using PostGIS or FME - act in the same way. What is the configuration then for FME to match the behaviour of PostGIS’s ST_IsValid function?Thanks in advance! :-)