FME Form

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, best practices, or examples would be really helpful. Thanks in advance!

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 https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Form/Workbench/Installing-Python-Packages.htm#ChangingtheDefaultInstallLocationAdvanced does not create a new folder python310 In FME Flow using PythonCaller and prompting for installed/used Python Version results into 3.13.11Did I miss any steps? How do I use Python 3.10 in FME properly?

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 workbench install. We are still

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 pyfme has been replaced by fmeobjects. So I made the changes like below: import fmeobjectsmyCSMan = fmeobjects.FMECoordSysManager()…#defineCoordSys only takes

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 the Date format in the parameters to FME Default however it seems this option only shows when you use ArcGIS Online as the source type. I am not getting that option when using Standalone Server.Is there an

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?

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.FeatureClass1An error occurred while attempting to create the table 'sde.FeatureClass1'. The error number from ArcObjects is: '-2147220655'. The error message from ArcObjects is: {DBMS table not found [{dbname}.sde.FeatureClass1]}The user has appropriate permissions on the sde schema(Note: It is an Esri requirement that the users default database schema name matches the username, so the de

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): This is how the parameters look when I try to run the workspace (or edit them in my custom transformer settings). Note that there’s no way of actually selecting values:tha

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:The only values I am getting (other than Row/Column) is the Pallette value, which just corresponds to the aggregated class value symbolization: I’ve played around with several of the Raster transformers but they have been unable to get this cell value exposed. Is there a different approach I should be taking to be able to read this FWI value on a cell-by-cell basis? Thank you for your time.​​​​​​​

Hi,Is anyone else having issues with Form not starting after the recent Windows update? A repair did not help, and even a fresh installation of version 2025.2.3 will not start.

Hello,I have a main FME workspace where I call multiple child workspaces using WorkbenchRunner.The issue is that even when one of the called workspaces is terminated, the WorkbenchRunner still reports the execution as successful.My goal is to stop the main workflow immediately if any problem occurs in one of the child workspaces, so that the next WorkbenchRunner does not execute. What is the correct way to ensure that: If a child workspace fails (error or termination), the main workspace stops immediately, And subsequent WorkbenchRunners do not run? Any recommended best practice for this scenario?Thank you.  

lets say I have a set of coordinates x1,y1 and x2,y2 how can i create a dwg with dimensions between these coordinates?if possible a step by step guide with the transformers/writers required for this.  

Does anyone know a good built-in or pre-created solution to read “Tabular JSON” that’s in a format of schema followed by values rather than key:value? See example below. I have ~40 schema values but only included 2. I’m looking for something dynamic rather than manually assigning column names in a specific order.{ "schema": { "title": "Data Export", "type": "array", "properties": { "id": { "title": "id", "type": "integer", "default": "", "minimum": -2147483648.0, "maximum": 2147483647.0 }, "code": { "title": "code", "type": "string", "default": "" } } }, "data": [ [ 1, "DEMO1234" ] ]} 

I have a SQL Server Database that has 156 tables. I need to extract the schema for each table and table names into a CSV. I know one way is to add all 156 tables to the workbench as separate Readers and then use FeatureReader (with Features to Read set to Schema Features). This could be a start, but it seems rather tedious.  Is there a better way? I want to write to a CSV that has the attributes in one column and the table names in another column.  Any thoughts on the best way to tackle this?