FME Form

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”. 

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! 

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

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:  

Hi thereI’d like to convert the whole OS MasterMap Topography layer for our district in to individual 1km DWG tiles which are to be accessed in a variety of CAD packages.I have had some success in converting a Geopackage of the above layer, through a MultiClipper to create the individual grid squares and finally written as a DWGs with the output ‘fanned out’ by each 1km grid reference number.When one of the resulting files was opened in CAD, the geometry was present, but none of the attributes. However, I will try the UK OS MasterMap Topography Layer (GML) Reader, once my GML download is available from the OS Data Hub site.Would anyone who has had some experience with this type of conversion kindly forward me some tips or advice on how best to achieve populating a DWG, or series of DWG exports with the attributes from the file which is being converted, please?Many thanks :)

Hi.This is either a no-brainer that I haven’t figured out, or not doable, I think. But it’s a simple task.I need to count the items in a JSON array, but I need to do it in a looping custom transformer, so it needs to be non-blocking.In a custom transformer, I use a HttpCaller to get a JSON response, which includes an array of items. I may have to issue more http calls within the custom transformer, so it contains a loop back to its input.JSONFragmenter can easily find the array items, but as features, not in a list format, so I need to use a blocking transformer like Aggregator to count them. This is no-go.So either I need to extract the JSON array items into a list, and use ListElementCounter to find the length, or count the JSON array items in a different non-blocking way.Does anyone have a solution for either of these tasks ?Cheers.

Apologies if this has already been asked - seems like it should already have been reported.FME Form 2025.0.1FeatureWriter Version 0Writing to Esri Geodatabase on MSSQL Server 2019When using either Create if Needed, or Drop and Create table handling, the geodatabase_sde writer appears to ignore the table qualifier set on the feature type. The table gets successfully created, visible in SSMS - but under the default user database schema eg: domain\john.smith.FeatureClass1 However the flow then fails because at some stage it does take into account the table qualifier and is looking for a table called sde.FeatureClass1

Hi,has anyone had any success creating User Parameters for the SharePointOnlineConnector Site, Document Library and Path values?I’m using FME 2025.2.2 (latest version) and SharePointOnlineConnector version safe.microsoft-sharepoint  [1.13.1] (latest version)I would like to embed a SharePointOnlineConnector in a custom transformer but I don’t want to hard-code the Site, Document Library and Path values. However, when I create User Parameters to expose these as custom transformer parameters I am not able to actually select values for them. I have also tried creating User Parameters for these values as input parameters for a SharePointOnlineConnector in the main workspace but run into the same issue.This is how my SharePointOnlineConnector is configured (I have used all default values when creating the User Parameters):

I’d like to maintain my database documentation in an Excel spreadsheet like this:Attribute Name FME Data Type LandID int32 Acres real32 Name varchar(128)  And then I’d like to import that into an AttributeCreator. When I try importing, the attribute names come through, but FME Form sets all the data types to varchar(200) instead of what I specified in the field ‘FME Data Type’ and imported in the import dialog.How can I fix this or set up my spreadsheet differently?

Hi all,I am attempting to create an FME script that looks at the FWI information provided as a WMS by NRCAN to perform some risk analysis based on the WFI cell values. When I load the WMS into ArcGIS Pro and examine a cell, I can see a discrete WFI value: (It is hard to tell from the picture, but this display is showing up when I click to examine a single cell. As I click around in the polygon, the WFI value changes.)When I load the data into FME, I cannot seem to get that FWI value to be exposed. When I click a cell in the investigator, this is what is returned: