FME Form

Hi there,I am assessing a dataset for changes that took place since 2012. This data contains these two fields of interest:change_date reason_for_changechange_date contains multiple dates that a separated by a comma and reason_for_change contains strings of change types separated by a comma.An example of the data structure is Feature 1:change_date: 2016-10-20reason_for_change: New Feature 2:change_date: 2009-06-15, 2013-09-04, 2016-10-05reason_for_change: New, Attributes, Modified Feature 3:change_date: 2010-09-11, 2014-04-09reason_for_change: New, Attributes Is it possible within FME to pair each individual reason for change to a change date and then test if it matches the follow conditions of reason_for_change = New or Modified and change date greater than 2012-12-31?Using the three examples above, feature 1 and 2 should be highlig

I am in the process of moving my FME Desktop 2021 workspaces into FME Form 2025. I know I can open the FME 2021 workspaces in FME Form 2025. As I get farther along in this process, is there anything I need to be aware of? example, is it best to just rebuild my FME 2021 workspaces in FME Form 2025 instead of just opening and saving the FME 2021 workspaces in FME Form 2025?I have run a few FME 2021 workspaces in FME Form 2025 with no issues. But wanted to reach out to the FME community to see what their experience has been in bringing in older FME workspaces into new versions of FME.

Hi everyone,I’m struggling with a limitation in the Excel Reader and I’m hoping someone has a reliable workaround for a fully dynamic workflow.I have an automated FME Flow workspace where multiple users upload Excel files through an FME Flow App. These files contain yearly planning data for different teams. The challenge is that users will sometimes rename existing columns and sometimes add completely new columns to the Excel sheet.Even when I configure the Excel Reader with Dynamic Schema by using Single merged feature type, FME does not refresh the schema at runtime. It only updates the schema if I manually right click the reader in the Navigator pane and click Update reader. Simply running the workspace does not trigger a schema rescan.I have tested using CSV instead of Excel but the schema still remains locked to whatever was detected when the reader was first added. As a result, any renamed columns

Hello,I currently have some workbenches which access APIs and hence have secrets within them, which is fine when this is secured on FME Flow. I also want to set up version control, and have all of my workbenches uploaded to remote repo, GitHub. TLDR: How can I secure my API secrets on GitHub?So far I’ve looked into:encrypting my workbenches  https://support.safe.com/hc/en-us/articles/25407644298637-Password-Protection-for-FME-Workspaces this seems OK, but doesnt truly secure the api secrets, it does add a level of security but it could be better Storing my API keys as published parameters on FME Flow this may be hard to manage, especially when trying to run/debug/design any API workflows

Hello,I am using a Sharepoint List reader to expose all hidden fields and show all fields. This usually works for me but not for this specific list. This list is very large, has views and hidden fields.  The errors:1) 2025-04-17 09:48:51|   1.8|  0.0|ERROR |Microsoft SharePoint List Reader: Client-side error: '401 Client Error: Unauthorized for url: <…..>' returned from SharePoint. Error message was: '' 2) 2025-04-17 09:48:51|   1.8|  0.0|ERROR |Python Exception <FMEException>: FMEException: 929309: Microsoft SharePoint List Reader: Client-side error: '401 Client Error: Unauthorized for url: <.….> returned from SharePoint. Error message was: '' The query (url) generated by FME (which I’ve removed from the errors above), is 2300 characters long. When I click this URL it takes me to a blank page with the message:

Is there a way of Auto switching Parameter between Form vs Flow?ie Local while working on FME From (C:\FME_SHAREDRESOURCE_DATA) vs FME Flow($FME_SHARERESOURCE_DATA)Workspace Locally with FME Form is add “C:\FME_SHAREDRESOURCE_DATA” to the FME Flow Parameters to test and work on the solution. When I upload the Workspace to FME Flow I always need to remember to remove the local value for everything to work.  I forgotten a couple of time and wondering if Deployment Parameters is the solution?  

Hi - I’m trying to write small areas of map data from a Geodatabase as a DWG / DXF file.The spatial data is available when I open the exported file, but none of the attributes, only a single column called <no schema>:I’m wanting to include the following attributes: but I have tried countless variations of the available Writers:I just can’t get around the <no schema> issue.Is it actually possible to include attributes within a DWG / DXF Writer?If anyone can offer some step by

My workbench tries to read features from ArcGIS Online feature services, write them to a different database and, if successful, delete them from their ArcGIS Online feature service. I’ trying to use as few feature writers as possible, so I use attributes to descern feature services and their layers. Most feature services contain only one layer, but the name of the layer can be different from the name of the feature service.I can get the name of the layer from the format attribute “fme_feature_type” and use that for the “Layer Name” in the Feature Writer parameters: But in the “Writer” group (button: “Parameters...”) I also want to use an attribute for the parameter “Selected Feature Service”. 

I wanted to make all my attribute to camelCase, currently they are separated by underscore.I wanted to change my attribute name to camelCase, so using regular expression in BulkAttributeRenamer transformer to find text following underscore using regular expression replace: _([a-z])  However, i am not sure what String parameter i have to put to make the selected character Capital letter. I have tried \U\1 and also few other but its not working. Basically wanting to find String parameter value? 

Does anyone know if FME can be used to notify via email when one or more SSL certs are due to expire. I have a boatload of SSL certs whose expiration dates I keep track of using a spreadsheet. Just wondering if FME could make it easier? The OS I use is Windows Server 2022. 

Hi, I read xlsx files and want to write the name of the file in to an attribute. The writer I use is a feature writer to use the result in ARCGIS online. Thank you! 

I’m using the Gemini Connector (Transformer) in FME and facing an issue with initiator (upstream) attributes.My requirement is:The attributes coming into the Gemini Connector (initiator attributes) Need to be merged with the Gemini response/output, so that the final feature contains both the original attributes and the Gemini result Current behavior: The Gemini Connector output only contains response-related attributes Initiator attributes are not carried through or merged automatically Question: Is there a supported way to merge or carry initiator attributes along with the Gemini response? Is this a limitation of the Gemini Connector transformer? What is the recommended pattern (FeatureMerger, Joiner, correlation ID, etc.) to achieve this? Any guidance, b

Hi there,What I want:FME workspace using Python version 3.10 installing Python packages (namely mcap and rosbags) into 3.10 using PythonCaller in FME Form with Python 3.10My setup:FME 2025.2.2.0 (Build 25827) Windows 11 Enterprise, 64bit PATH pointing to C:\Program Files\FME2025\ FME Form: Workspace Parameters → Scripting → Python Compatibility: 3.10+ Utilities → FME Options → Translation → Preferred Python Interpreter: 3.10+ Paths and folders on Windows: C:\Users\<myname>\Documents\FME\Plugins\Python python313 fme.exe python --version in cmd results into 3.13Where I fail:I cannot install packages into Python 3.10 Referring to 

Hi everyone, forgive me if this is a basic question but I’m trying to understand best practices for our database setup. We have a GIS Edit database and GIS Production database. Both are Postgresql 12.22, Enterprise 11.3. We have a lot of jobs doing a basic ETL from Edit → ProdHavent had too many issues with these over the years with some occasional data type errors mostly. The problem is I have never been certain what combination of reader/writer I should be using. For some reason, we’ve had the best luck using an ArcSDE Geodb reader and a postgis writer. And when I say this, for example an error I’ve run into many times is that the objectid (Esri’s UID column) has duplicate values when running the job so it fails. So then we do something like adding a counter transformer in between and then writing that to the Production db table objectid column. I’d prefer not to have to add steps like this obviously.We’re in the process of preparing to upgrade our FME workben

Hican someone advise if there is a replacement for the PhotoCoordinateExtractor transformer?I’ve not used FME for about 15 months, but now have a new laptop with FME Form installed (rather than the old FME Desktop previously)I had a workspace set-up to load and extract exif imformation from images, then generate a point table, but when i run this in FME Form the PhotoCoordinateExtractor is rejected.I’ve looked in the transformers but can’t identify one that replicates what the PhotoCoordinateExtractor didThanks    

I recently tried to update an older workspace with a TestFilter that is used to branch data out using basic logic. After the update, the workspace failed in an odd fashion and after a bit of troubleshooting it turned out that one of the tested attributes, “fme_feature_type” in this case, was getting changed to nulls for many, but not all of the resulting rows. The change was from TestFilter Version 2 to Version 3. Has anyone else experienced anything similar? I’m running FME Form Build 25815. 

Hi, Can anyone help me read and write an XML file to SHPs? I've already managed to read it, but then I have to map everything myself, but I've found XSD schemas. I should use two, but I can't get it to work.According to Copilot, FME 2025.1 no longer supports XSD schemas, but they don't really offer me an alternative either. Nothing they suggest works or is correct.So I think I'm better off with your expertise than with AI :-)  

XML Parser error: 'unable to open primary document entity 'C:\FME_TEMP\wbrun_1770387492402_18548\fmetmp_13\1770389629687_17428_d\importedModel390.dae''An error has occurred. Check the logfile above for detailsThe below feature caused the translation to be terminatedglTFReader_FeatureReader_3_<Rejected> (TeeFactory): glTFReader_FeatureReader_3_<Rejected>: Termination Message: 'glTFReader_FeatureReader_3 output a <Rejected> feature.  To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation'' 

Hi all, I had build a workspace in FME dekstop using httpcaller to get data from an api and its working. When i publish this on the server, then i get the following errors. HTTPCaller (HTTPFactory): [1]: HTTP transfer error: SSL connect errorHTTPCaller (HTTPFactory): [1]: Please ensure that your network connection is properly set upHTTPCaller (HTTPFactory): [1]: No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been enteredI have already check on the server and i can reach the api by web. Does anyone what the issue is?kind regards,

I export a shape file, the prj file includes only this: PROJCS [ "MAGNA-SIRGAS / Origen-National" which is the name of my cs. What I have to do to have a correct prj file?

I dug out one of my old FME 2014 workbenches. It has this PythonCaller defining a local CRS. It had worked beautifully for years.import pyfme#define custom CRSmyCSMan = pyfme.FMECoordSysManager()fmeParams = {}fmeParams['CS_NAME'] = "local_polyconic_cs"fmeParams['DESC_NM'] = "Dynamic CS"fmeParams['DT_NAME'] = "WGS84"fmeParams['PROJ'] = "PLYCN"fmeParams['UNIT'] = "FOOT"fmeParams['X_OFF'] = 0.0fmeParams['Y_OFF'] = 0.0fmeParams['MAP_SCL'] = 1.0fmeParams['SCL_RED'] = 0.9996fmeParams['SOURCE'] = "HESS"fmeParams['QUAD'] = 1fmeParams['ZERO_X'] = 0.0001fmeParams['ZERO_Y'] = 0.0001surf_lat = float(feature.getAttribute('surf_lat'))surf_long = float(feature.getAttribute('surf_long'))        fmeParams['PARM1'] = str(surf_long)fmeParams['ORG_LAT'] = str(surf_lat)myfmeCS = myCSMan.defineCoordSys(fmeParams, "myfmeCS") Now I am at FME 2024 where

Hi all, I would like to trim the first 7 characters from all the columns in my dataset. I think this can be accomplished with the BulkAttributeRenamer. But I'm struggling with the String Parameter. Any ideas?

Hi there,I don’t know if I am doing something wrong but I am trying to use the new ESRI ArcGIS Feature Service connection to read a public layer from another organisations AGOL account. I have it working using Standalone Server as the source type. I can’t seem to get it working using the ArcGIS Online source type as I don’t have a login to their AGOL and I don’t need one as it’s public data. I can only login to our own AGOL account.Anyway I have this working - it’s reading the data but I am now coming across the whole reading dates as Epoc time again and my DateTImeConverter is spitting the dummy.I have updated the reader to v3.20.1 and I have checked out the article below:Esri ArcGIS Feature Service - Reads Dates as Epoch Milliseconds | CommunityIt is showing that you need to change

Hi,I have text from a source DWG that contains all the information needed to create an annotation class in a geodatabase (text size, rotation, color hex/RGB/fme, etc.). I’m able to create the annotation class in the GDB, but all the text comes in as black, even though the original text has different colors.What am I missing?

Whenever I try to open the AttributeRenamer transform properties, FME Form crashes. It doesnt matter if it is an existing workflow or if I start a new one woth nothing but only one AttributeRenamer. Any thoughts, anyone? The screenshot below if from FME Academy: But it also happens on an otherwise empty workflow: