FME Form

Hello to all,3 months ago, kailin told me that the 2024 version did not allow writing zones. I would like to know if it is the case now. If not, what is the planned schedule because for the moment we are blocked for the enrichment of our models Best regards Bruno

Hi, I have the following problem: a specific fmw file cannot be opened in the FME workspace. Clicking on it in the list in the FME Workbench tab “Start” gave no response at all. Hoving the mouse on the file in the list showed a popup with the contents of the file. Dragging and dropping the fmw file to the empty workspace did not work. Other files can be opened without issue. How can I restore the fmw file? I have FME Workbench 2024.0.

I am trying to concatenate 6-7 fields to create single field with spaces in-between different field values to create a address like string, no commas needed. Can I do it in text editor? Field1 Field2 Field3 original: 123 ABC Street Filed Combined Target: 123 ABC Street

Hi, I am getting this error: An error occurred while attempting to insert a row into the table ‘ABC’ using a cursor. The error number from ArcObjects is: '-2147217323'. The error message from ArcObjects is: {The cursor has been invalidated by an edit operation.} I am experiencing an issue when trying to insert features into a feature class stored in an enterprise geodatabase. Specifically, I am both reading from and writing to the same dataset. I haven't encountered this problem before, but it began after I set the Feature Operations to "Upsert" while updating existing records and inserting new records that are not yet present in the database. I suspect that performing inserts and updates simultaneously may be causing a disruption with the cursor. I also attempted to use the Feature holder, but I received the same error. This disruption is affecting the automated process. Does anyone know what might be causing this error or how to fix it? I would greatly appreciate any assistance! Than

Hi all, I am very much an FME rookie, so I’m hoping someone may have some insight as I’m at a loss. I’ve received a .JSON dataset of point locations with a number of attributes. It is not in a form of GeoJSON that I recognize, and so basic Esri/GIS toolsets won’t help with conversion. I’d like to use FME Form Workbench to help me clean up the data and ultimately convert it to Shapefile or Esri File Geodatabase Feature Class. Below is the format of the .json that I’m working with: [ { "id": 1, "address_number": "1234", "street_name": "IMAGINARY", "street_type": "WAY", "unit_number": "", "country": "CAN", "province": "BC", "region": "CVRD", "locality": "Mill Bay", "postal_code": "V8H 1B8", "pid": "", "administration": "", "building_name": null, "code": "Residential", "comments": null, "geom": { "type": "Point", "coordinates": [ -123, 48.6 ] }, "created_at": "2024-03-27T17:00:00-07:00", "updated_at": "2025-04-15T11:47:55.371078-07:00", "full_address": "1234 Imaginary Way" }, So since it’s

I just returned to work from the Peak Of Data and AI in Seattle and am trying new things. In existing workspaces, I have added two creators to my workspace where I am adding a DateTimeStamp >DateTimeConverter - then writing to a new tab (Information) in my excel worksheetthe Second creator I am utilizing a FilePathExtractor and writing to the same new tab in excel. Essentially I am creating metadata to make my job easier to rerun projects year after year. The question I have is : is there an easier way to extract the File Path of where I have the .fmw saved without needing to navigate to it within the FilePathExtractor? My ultimate goal is to create a custom transformer that I can share with co-workers that can help them add the date created and the fmw’s file path to their excel writers.

Hello everyone I’m very new FME but I have been using chatGPT to guide me through to achieve the outcomes of my goals so my apologies if I have done something or missed something very simple. What I am trying to achieve in the graph I have attached is to convert 2D mapping data which is in EPSG 27700 into a 3D Object in EPSG 3978 so that it will align with mapping data in Unreal engine from the Cesium plug-in. As you can see from the graph I am adding height data from a point cloud then reprojecting to 4326 and then to 4978 (I don’t think the double reprojection does anything but chatGPT said to give it a go), after this I then shift the map based on a georeferenced point that I have centred my Unreal project around. Most of this all works perfectly fine and expected (this is a great piece of software!) but the result has the reprojected map not perfectly flat on ground and facing the wrong direction. This makes me think I am missing something obvious or simple. I really appreciate any

Hello, I am aiming to customise the FME Flow map interface by integrating a bespoke ArcGIS Online (AGOL) web map. The objective is to allow users to delineate an Area of Interest (AOI) and subsequently export relevant data directly from the application. The intended FME Flow map should utilise a basic AGOL web map that includes basic features layers (e.g. polygon) which are intended to assist users in understanding the extends of the dataset. I attempted to modify the basemap URL (Map Configuration) by embedding the public AGOL web map URL; however, this approach was unsuccessful. Would you happen to have any guidance or suggestions on how to properly embed an AGOL web map into the FME Flow ‘Draw an Area of Interest’ interface? Thanks :)

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.

Hi everyone, I have struck a roadblock in the creation of a particular FME Workbench that I now require help with. I appreciate your time in advance. I have multiple csv files that contains a table of data that I would like to process into a single csv file table. Lines 1-26 of these files contains general informationLine 27 contains headers for a table belowLine 28 onwards contains the data for the table. In Line 2 Row 2 there is a “cell” (B2) which contains text which I would like to add into a new column in the table repeatedly. I have done and been able to do the following:- Used 2 x CSV Readers- 1st CSV Reader data is transformed down to just cell B1 and B2, with B1 text being replaced with a header name 'Sensor_ID' and B2 simply being the original data in B2 eg. SN_ABC123- 2nd CSV Reader data is transformed to Line 27 onwards (i.e. just showing the table), plus a few other modifications using AttributeRenamer, AttributeRemover etc.- Tried using both FeatureMerger and FeatureJoine

Hi, I need to filter some ArcGIS Online Portal Readers based on a unique ID that exists also in another reader (file geodatabase). Example Reader 1: ArcGIS Portal features w/ UID Reader 2: File Geodatabase features w/ UID Reader 1 should only load features that have a UID that match Reader 2. The UID fields are the same format. Is this possible? Please let me know if can provide further details. I am a beginner/intermediate FME user focused on GIS. Thank you!

Hi, I’am using FME Workbench 2022 with ArcGIS desktop 10.8.1 and ArcGIS Pro 3 on the same machine. When I try to load a feature class only compatible with ArcGIS Pro (containing arcade expression), FME continues to use ArcGIS Desktop 10.8.1 librairies despite the transation / Esri ArcGIS Compatibility set to Auto or ArcGIS Pro.

In FME Form 2023.2, we used a dynamic JSON writer setup that wrote a separate file per input SQL file. Each input could have a different schema, and the setup dynamically handled this just fine using: fme_feature_type set from fme_basename (filename sans .sql) JSON writer with Schema from Schema Feature This worked perfectly — each JSON file had its full dynamic schema. After upgrading to FME 2025.0, only the first JSON file is written with its full schema. All subsequent files contain only the subset of fields shared with the first file. Unique fields in later inputs are silently dropped. Example: A.sql has fields: ID, APR_KG B.sql has fields: ID, MAY_KG Result in 2025.0: A.json: includes ID, APR_KG B.json: includes only ID — MAY_KG is missing Nothing changed in the workspace. This appears to be a regression in how dynamic schemas are handled across multiple feature types or files in newer versions. Can Safe confirm whether this change is intentional?

Hello FME community, I would like to identify all locations that are within a 300m-perimeter around a polygon, taking into account barriers (large roads, rivers etc.). In ArcGIS there is a tool called “Distance Accumulation” that does just this, but I don’t want to depend on it. Thanks!

Hello everyone, This might be a simple question, but for some reason I can't figure out how to remove rows with only Null Values (Of course I can useTestFiler or Tester, but would be cumbersome work, since I have a lot of columns and I don't want to go into that rabbit hole) These rows with Null values came into existence, since I read in an excel file with two worksheets with two different schemas. So the column names in worksheet 1, is different compared to the column names in worksheet 2. Therefore all the values from worksheet 2 have null values. I actually don't need worksheet 2, so I was thinking there might be 2 solutions. 1) don't read in worksheet 2 or 2) remove the null values For both of them I don't know the answer.....dramatic sound effects.. So if someone knows the answer, that would be very nice.

I have an excel file where i have 2 limits stated under single column and I want to split them as per table B where the Type = C Limit Type $30,000 per claim / $50,000 aggregate N $50,000 per claim / $70,000 aggregate C Table B Limit Type Per claim Limit Aggregate Limit $50,000 per claim / $70,000 aggregate C $50,000 $70,000

Why does FME Flow (or FME Desktop) store files in the My Documents folder?Why not use AppData\Roaming or AppData\Local?

Is there a way to read data from a PowerBI semantic model in FME Form?

I feel like I’ve seen this done before, but can’t put my finger on how to do it….. A warning, I’m working with 2020.2 so cast your mind back a few years….. Essentially I have a workspace that is taking data from MSSQL and writing it out to SQLite. In theory this is just a straight Reader to Writer. However, the SQLite file is being created fresh each time the process runs and it’s creating any number of tables based on relationships within the MSSQL database - these relationships need to be maintained. Therefore, the schema in the SQLite table is being created with an SQLExecutor and CREATE TABLE statements. Currently, I’m reading the schema from MSSQL and manually mapping each attributes data type from the MSSQL definition to SQLite using an AttributeValueMapper. Now it wouldn’t take too much effort to make this list exhaustive, but there is surely a better way. I initially thought of using a schema attribute and let FME do the MSSQL→ FME→ SQLite mapping with a dynamic writer, and tha

As mentioned in another post, I'm currently upgrading a bunch of workbenches to run on FME Flow 2024, some of them many years old. Typically, for anupgrade, I will go through each workbench, upgrade all transformers, readers, and writers, then run it in test desktop (workbench) environment, then publish to and test in a test server (flow) environment. In, FME 2024 the Vertex Extractor gives me bogus results, even after upgrading all the constituent transformers in this custom transformer. It looks like X and Y, or Lat and Lon, are reversed. When I open the CoordinateConcatenator (arrow above), I see this: Default setting While I haven’t dug through the rest of the custom transformer, this - frankly - looks counter-intuitive. When I change that to “XYZ”, everything runs just fine and results are as expected. My tweak I have tried to compare my version (I’m assuming that upgrading all components makes it uptodate) to older versions to see whether upgrading might have introduced this prob

I’m using an Excel Writer in FME Workbench 2024.2. This is a workspace that will be run yearly and I have created an excel file to write to in the format that I need so that the end user gets the same output year after year. I would like to use FME to clear any existing data in the excel file from row 5 on down, but still keep the data and formatting that exists in the rows above. I tried Truncate Existing Sheet/Named Range: with my Start Row set to row 5, but cleared all of the existing data from the sheet and then wrote the new data starting at row 5. In the below images, you can see what the sheet looks like before the writer is run, the writer parameters, and what the sheet looks like after the writer is run. Is there a setting in the Writer Parameters that I need to change to ensure that the data and formatting in rows 1- 4 doesn’t get deleted? Or is there another way that I need to approach this? Any help would be greatly appreciated. Thanks! Sheet view before writer is run Write

I hope I got the title prepositions correct… I want to break apart lake data in order to generalize each category individually. The DonutHoleExtractor will “only” break apart “one level”. That is, independent-lakes and island-in-lakes-on-islands get sent one way and islands-in-independent-lakes and lakes-on-independent-islands get sent the other. Last option is to use an AreaOnAreaOverlayer or similar to sort everything correctly. But I would rather save that computing time since this is a huge dataset. Unfortunately the DonutHoleExtractor does not have an option for lists, or that would have been my chosen route, me thinks. Once generalized the geometries will be reassembled into donuts. Q: Is there a way to deduct the relations between different types of polygons within the donuts without doing a load of spatial analysis? I would expect there to be some sort of relation info within the geometry type itself? edit: Rephrased the question for clarity Pic for illustrative purposes

Hi Team, I was wondering if there was an ETA as to when a permanent solution for fixing FME Form (and Flow) will be available, as we're still experiencing issues with reprojecting data in GDA 2020. The work around at the moment that we have been given is; - Open up the following file in Notepad (open as administrator) :"C:\Program Files\FME\Reproject\CsmapTransformationExceptions\TransformationExceptions.db" - Find the Australia section and add the following line : GDA2020-7P|GDA2020|XFORM|FWD|NULL_FME - Save! Cheers

My company does SSL inspection/interception which is causing errors when trying to view background maps in FME Form. I have seen ways to fix this for the FME Flow (Server) side, but is there any way to change any configurations for FME Form to handle this? The CA certificate for our authority is in the Trusted Root Certification Authorities certificate store on machines so I’m not sure why it isn’t trusted if FME is using the machine’s certificate store for trust. Below is an example of error seeing from FME Flow 2025.0.1 (but have seen on previous versions as well). Stadia Maps Reader: Failed to load 'https://tiles.stadiamaps.com/tiles/alidade_smooth/5/19/14.png'. Error: 'HTTPSConnectionPool(host='tiles.stadiamaps.com', port=443): Max retries exceeded with url: /tiles/alidade_smooth/5/19/14.png (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: Missing Authority Key Identifier (_ssl.c:1018)')))'Python Exception <FMEException>:

Hi FME world, I have two tables in a database (ArcGIS SDE). They are effectively a 1:1 match, linked via a common ID. Table 1 features are always present in the flow (filtered prior) and I want to read in ONLY the features from table 2, where match with the Table 1 filtered features (because there are 1m+). I’ve tried options like aggregating the Table 1 features and concatenating the ID, passing into Table 2 feature reader with a where clause. However, there is a maximum limit of queries the database can do (somewhere between 10,000-15,000 - and often I will need to read in more than this. My next thought is to create a looping transformer where I sample the T1 features into groups of 10k, aggregate, pass to FeatureReader, reads in associated 10k T2 features, then loop back to read in the next 10k, until there are no more features to be read (using a NoFeaturesTester to exit the loop. I’m a bit stuck on how to actually implement this though. Any ideas/thoughts much appreciated! Or if