FME Form

Hi all.I need to identify (and convert) multisurface /curve polygons in a GDB.The GDBs contain one feature class with many polygons: some of these records are multipart polygons. The data I am working with comes from uncontrolled sources using different GIS programs, so the GDBs are put through a workbench to identify obvious spurious geometries like self-intersections (this works well). However, I am having a recurring problem where the downstream processes in other systems are failing due to multisurface /curve polygons.I have tried exposing the fme_type and geometry, but they are always “fme_areas”. However, if I run GDAL ogrinfo tool identifies lots of Multisurfaces, some are also CURVEPOLYGONs. For example, GDB today with 8 records had 64 multisurfaces.Any anyone help point me in the right direction for how I might Id these issues in FME, or incorporate the GDAL tool somehow?Note: I cannot share example data due to its sensitive nature.

What is the process for ensuring that a custom coordinate system defined using the recipe from ​@daveatsafe below is reliably used by all members of a team using FME Desktop and also Server?(better yet: implement Update all available Coordinate Systems with EPSG Codes so it’s not necessary) 

I have many parquet files stored in an s3 bucket; when I use the s3 connector to download the parquet file, I am able to read it successfully, but passing the s3 uri (“s3://”) raises an error:PARQUET reader: PARQUET reader: Failed to open file 's3:\my-bucket-s3-test\fme-test\test.parquet' for reading.  Please ensure that the file exists and you have sufficient privileges to read itFailed to obtain any schemas from reader 'PARQUET' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationWhen I try to pass the url:PARQUET reader: PARQUET reader: Failed to open file 'HTTPS:\s3.us-west-2.amazonaws.com\my-bucket-s3-test\fme-test\test.parquet' for reading.  Please ensure that the file exists and you have sufficient privileges to read it When I use the feature reader, r

Hello everyone,A colleague is trying to read a CSV file in FME 2024.2, but the file appears to be generated by Linux-based software. As a result, FME interprets the entire file as a single block of text instead of recognizing each line as a new row. Does anyone know how to ensure FME correctly identifies each line break in this file?  

I used the FeatureReader to read all feature classes in a file geodatabase and dynamically update the same feature classes in a different geodatabase. Some of the feature classes use attribute domains with code values different than the descriptions. This causes failures in the update. For example, a feature class has an attribute Country defined as integer, and its domain Description is country names (text). Behaving like ArcGIS, the FeatureReader reads the Description text values and write to the destination feature class, which has the same Country defined as integer. The data type mismatch between the FeatureReader output and the destination caused the update to fail. As it is very typical in ArcGIS for a domain to have different code and descriptions values and therefore I would think FME should have been able to handle this gracefully, but I don’t see a workaround option with the FeatureReader. I am at FME Form 2022.2.2. I hope I don’t have to use those Customers or Hub GDB Do

I’m looking to read in a load of word documents that contain tables of information. I’d like to extract all the text from those tables so that I can then search the text for specific information. I’ve tried using the Microsoft Word Reader and the MSWordStyler but I’m only seeing the paragraph text come through to the attributes. Any ideas how to extract the table text?  

I have a RUN_DATE field in a File Geodatabase Feature Class Attribute Table. In this field is the current date (today’s date). I want to use a Tester after the DateTimeConverter Transformer to select only the values in the RUN_DATE field that are today’s date. I have tried this and get no passes, all failed. Is there a specific date format that needs to be used for the @DateTimeNow() function?Here are the parameters in the Tester (that is immediately after the DateTimeConverter Transformer:  Here are the parameters in the DateTimeConverter Transformer:   Here are the values in the attribute table (after the DateTimeConverter Transformer has been r

How to get to the bottom of this error message?An error occurred while attempting to create an Esri Spatial Reference from an OGC Definition for the feature feature class 'wildlife_key_areas'. The error number from ArcObjects is: '-2147024809'. The error message from ArcObjects is: {The specified WKID (factory code) or WKT (definition string) is not a Projected Coordinate System.}GEODATABASE_SDE writer: An error has occurred. Check the logfile above for detailsThe Feature Information inspector on the incoming data stream says the item has a coordinate system and is happy to display it. The OGC WKT from that dialog is:PROJCS["NAD83 / Yukon Albers", GEOGCS["NAD83", DATUM["North_American_Datum_1983", SPHEROID["GRS 1980",6378137,298.257222101, AUTHORITY["EPSG","7019"]], AUTHORITY["EPSG","6269"]], PRIMEM["Greenwi

I am trying to both add and update Equipment to CityWorks using the HTTPCaller - it seems to work fine except for custom fields.  They do not seem to add or update with the equipment record. I am passing in the “Data” query string parameter with the following json data:{"EquipmentUid":"@Value(EQUIPMENTUID)","Description": "@Value(DESCRIPTION)","Manufacturer": "@Value(MAKE)","Model": "@Value(MODEL)","ForCheckout": "@Value(FORCHECKOUT)","RateType": "@Value(RATETYPE)","UnitCost": "@Value(HOURLY_RATE)", "CustomFields":     {      "FieldName": "DIVISION CATEGORY",      "FieldValue": "@Value(DEPT_ID_DESC)"    } } This does not work but is what I could gather from the internet as correct (for the custom fields)

Hello,I have encountered some issues with a workspace that I have not seen addressed previously in the forum. The issue concerns exporting to an SQL server database where the file format is interpreted as GeometryCollection when it is essentially only MultiPolygon at most.This is what my workflow has looked like. I have a workspace that retrieves line segments from an SQL server, which are then combined and the attributes processed. These lines are generalized and buffered to form areas. I then use Dissolver to merge overlapping areas with a Group By function based on a common ID (the field INSATSNR in my screenshot). However, there are several areas with the same ID that are located in different geographical locations and do not overlap. Therefore, I use an Aggregator with a Group By function on the same ID. This ensures that areas with the same ID are collected in one field in the attribute table—exactly as I want it.However, when I want to expor

Hello,We are trying to set up a SharePoint web connection to use in FME at my workplace. Together with competent IT staff, we have been trying on our own for over six months without success. I thought I would ask here before we consider the next step! We have followed the following guides without success:How to Create a SharePointOnlineConnector Multitenant Web Connection – FME Support CenterHow to Create a SharePointOnlineConnector Web Connection with Application Permissions – FME Support Center The problem occurs when using the tran

Here is my code: import mathimport fmeobjectsFEET_PER_M = 3.28084TURN_THRESH_DEG = 5.0  # minimum angle to count as a turndef haversine_m(lat1, lon1, lat2, lon2):    """Great-circle distance in meters."""    R = 6371000.0    phi1, phi2 = math.radians(lat1), math.radians(lat2)    dphi = math.radians(lat2 - lat1)    dl = math.radians(lon2 - lon1)    a = math.sin(dphi/2)**2 + math.cos(phi1)*math.cos(phi2)*math.sin(dl/2)**2    c = 2 * math.atan2(math.sqrt(a), math.sqrt(1-a))    return R * cdef bearing_deg(lat1, lon1, lat2, lon2):    """Bearing from (lat1, lon1) to (lat2, lon2) in degrees 0-360."""    phi1, phi2 = math.radians(lat1), math.radians(lat2)    dl = math.radians(lon2 - lon1)    y = math.sin(dl) * math.cos(phi2)    x = math.cos(phi1) * math.sin(phi2) - math.sin(phi1) * math.cos(phi2) * math.cos(dl)    brng = math.degrees(math.atan2(y, x))    re

Hello, its me again.So I’m playing with changing excel documents in Form 2024.1 and its going superb, except from the fact that when Form writes out my changed excel it adds an @ in front of some of the formulas. So for example the formula that gets read in as:=XLOOKUP(blabla)Gets written out as:=@XLOOKUP(blabla)Which then makes the whole outcome excel document breaks.I have ran this with caching and see that at last cache before writing then the formulas are intact, so this must happen in the writer or that the excel gets written out in some manner that my excel setup *misunderstands* it?As always, all comments are welcomed (as long as you not a person just looking to score some points by copy/pasting what AI said the problem was).-Hlynur

Hello yet again.This time I am experimenting with a complex Microsoft Excel document, its basically a calculation file that contains quite a lot of sheets, macros, references and formulas. Idea is that instead of sharing the excel document with the people that need to use it that I would just host it on our Flow, people would then have an option to fill out some published parameters in a flow app and then get a single excel sheet returned with their results (cutting out all the underlying datasheets and formulas and macros etc).Or to sum it up: I have a complex excel with formulas, read that excel in FME, change values in cells in FME, write out an excel from FME that would then recalibrate/recalculate based on those changed values.So I have figured out how to single out cells in the excel table where (basically using counter, and tester for that single number, link to attribute manager where the new value can be inserted to replace the old one, back to a Featur

Is there a resource/database somewhere that has a list of what FME release each version of a transformer was initially released/updated in? You can get it pretty easily for transformers on the Hub, but not for inbuilt transformers.I’ve had a dig through the various Python APIs and I haven’t come across anything (doesn’t mean something doesn’t exist mind you!).Each version of FME does come with the previous versions of the transformer, otherwise this would break the backwards compatibility of the software.

I am trying to write some CAD data to an ArcGIS Enterprise Feature Service.I noticed there has been an update in the latest version but unfortunately we are using 2025.0 at present and wanted to see if there is a work-around to an issue related to true-curves. I am getting the following error message: ArcGISFeatureServiceWriter: Feature type 'Levels' has 'Use True Curves' enabled, but the feature service does not support true curvesPython Exception <FormatException>: FMEException: 1: ARCGISFEATURESERVICE: Feature type 'Levels' has 'Use True Curves' enabled, but the feature service does not support true curvesSAFE.ESRI-AGOL.ARCGISFEATURESERVICE writer: An error has occurred. Check the logfile above for details The writer has ‘Use True Curves’ set to ‘No’ but I still get the error message. 

Hi all,I am currently using ArcPro 3.5 DI tool that uses,FME(R) 2025.0.0.0 (20250228 - Build 25208 - WIN64)Some of my FME scripts are failing when reading an excel file if it as a python start up script that imports arcpy specifically. If i remove arcpy, the excel reader works fine.Is this a bug with the FME build that came with our ArcPro 3.5 or is it consistent with a stand-alone FME install?Some of the warnings are:----------------------------------------------------------The Startup Python Script changed the current FME process locale from 'English_New Zealand.utf8' to 'English_New Zealand.1252' and FME has restored it back to 'English_New Zealand.utf8'. It is undefined behavior to change locale and doing so may cause unexpected errors. For more information, visit http://fme.ly/PythonLocaleError-----------------------------------------------------------Excel Reader: Could not read cell at row '0', column '1' for sheet

I have an excel file with 100 records (100 rows) with 5 columns. I have a process that will filter one record to update one column field called ‘Last Update’ in that particular record row. So The column ‘Last Update’ for that 1 record should be updated and the rest of the 99 records will remain the same. Keep in mind that the one record being updated, only one column is to be updated which is the Last Update column and the rest of the columns fields will remain the same.  How can I configure the FeatureWriter?I currently have the following set in the FeatureWriter Parameters and in the configuration but this does nothing. The excel sheet  looks the same as before with all 100 records the same and the one record that Im looking to update does not have the Last Update column updated. 

I believe there is the possibility to configure user parameters in a way that they take a local path for in/output and when they are going to be published the provided alternative for the FME Flow resources path is used.I cannot find my bookmark on how to do this and did not come to anything useful when searching the net.Does somebody have a tutorial on how to configure the user parameter that it uses the local resources when run in FME Form and the FME Flow resources when run in Flow?

Hi all,I’ve successfully solved one issue of enumerating points along the lines (to define flow direction) using this post - Line to connect in order. | Community. Is it possible to enumerate segments of the line the same way using enumeration of points?

Hi all.I’ve encountered a strange issue, when I made a small workspace to help me encode and decode strings on the fly.Apparently you can’t a TextEncoder and a TextDecoder in the same workspace at the same time !??What kind of dark magic is yielding this error ?I even made each of the two transformer into separate custom transformers, but the error was the same.In 2025.2 beta

I think we can all agree that FME is pretty unique, special and powerful in it’s no code approach to data movement, integration and automation.I’m sure many of us have heard of, or even used similar (FOSS) platforms to FME, such as Node-RED (https://nodered.org/) or IFTTT (https://ifttt.com/) ‘The algorithm’ recently pushed n8n towards me - https://n8n.io/,  These platforms are more focused towards the API/Event integration side of things, rather than the entire data stack that FME excels at. Of course, with the right workspace, FME can do everything these tools can (and more)!I don’t particularly see t

This morning I tried to import data using a WFS concerning a Dutch data source. I got into a weird error:Used WFS: service.pdok.nl/kadaster/kadastralekaart/wfs/v5_0?request=GetCapabilities&service=WFSDoes this look familiar to someone?

Edit: I think I found the issue. In the 2025 documentation (https://docs.safe.com/fme/html/FME-Flow/WebUI/Version-Control.htm) this note has been added “FME Flow currently supports only GitHub as a Git repository.”. Since my repository is on Azure it no longer works. I will leave this here, because I'm probably not the only one that will run into this issue.----original post:After update from 2024.2.1 to 2025.1.2 Version control is not working anymore.The issue is sort of the same I had last time:  Only this time when I press Push to Remote I get the message “The remote ref update was rejected. Check your repository permissions or configuration and try again.”.

Hi there,We have a plethora of web connections in FME Flow from various people publishing workspaces.  now that we can use FME Flow as the web connection repo, I would like to tidy these up and ensure a better naming convention/structure.What would be the best way to do this?I think we have to:download every workspace, open them and audit the connections, build a table to show where all the connections are used, create new ones that adhere to our standards, update all workspaces and republish to Flow, ensure any workspace apps have permissions on the new connections delete old connectionsDoes this sound right? Thanks,marc