FME Form

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!

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

Hey, I have a question about the HTTP Caller. Is there a way to have the workspace it is in still continue even if one of the records fails to upload? The reason I ask is because there are some interesting errors I have ran into when uploading records to Cityworks, where something fails and then I have to re-run the entire workspace, after first deleting all of the inspections/work orders that were created. The error involves an encoded string not being compatible with FME. I would just like a way to run the entire workspace for all features and not have it cancel out on a failure. Any tips?

Hi, I had a script that was running perfectly in FME 2024.1. I upgraded to 2025.0, encountered some issues, and my script stopped working. I then reverted to the previous version, 2024.1. However, my script still doesn't work. When I run it in PyCharm using Python 3.10, it runs perfectly, but in FME I get the following error: Message Type: fme::internal::_v0::py::Exception Python Exception <SyntaxError>: invalid syntax (functions.py, line 68) In the FME options, I have the same paths set as before: PYTHONHOME: C:\Users\XXXX\AppData\Local\Programs\Python\Python310 Interpreter: "C:\Users\xxxx\AppData\Local\Programs\Python\Python310\python310.dll" What could be the issue? Could you please help me? Thank´s

With the CKANConnector able to list Datasets and Resources without any issue, so I know CKAN Connection is good. If I try to add and update a resource I receive the “upload error HTTP 400: "Bad request - JSON Error: Invalid request. Please use POST method for your request” I’m pulling the Dataset and Resource for the update resource from the dropdown. Acts like a permission issue but I’m connecting as an Admin on the openGov side.

This is starting to annoy me - in 2024.2, whenever I create a bookmark around something, FME automatically zooms to it. Is this a setting that can be turned off?

Does anyone have a solution to this?

Huge thanks to ​@mark2atsafe for granting me a shiny FME Star badge! It really gave me the push to finally share some of the custom tools I’ve built, starting with this one: the TimeSeriesGenerator. The idea came up when I needed to build a time‑series dataset to plot user activity over time. My end goal was to generate an HTML report showing how users interacted with an application. I was starting from a log file of user requests, but if no one made a request during a given period, I’d have gaps in my data and nothing to show in the report. This issue is a common one. Even FME Flow with his analytics page doesn’t handle time period with no data. This FME Flow is idling most of the time, but the Analytics page doesn’t report that. That’s where the TimeSeriesGenerator comes in ! It creates a continuous series of timestamps between a start date and an end date, at a specified interval in seconds. You can then join your actual log data to those timestamps and be sure you’ll see a value (e

I'm working with an electrical network with feeders and branches. I'd like to add the coordinates of the intersection points with the feeders as attributes in the branches. I managed to do this in the first segment using the Intersector and SpatialFilter transformers, but I had trouble adding them to the downstream segments.I have a common field for each branch that can be obtained using networkTopology.So, my question is how to create conditional queries to add the coordinate values ​​of the intersection points with the downstream branches (see attached diagram). Thanks in advance.

Hi, I'm trying to access the property sets within the Extended data from dwg file, the property sets are attached to block reference objects, quite similar to the case of this post. Attached below are two snapshots from how the property sets look like in Autocad and FME workbench featuring the two attributes that I was trying to expose with no success can someone guide me through the detailed workflow, please? I'm using FME workbench 2024.2 Thanks,

I have a DXF-file consisting of lines and surfaces. Is there any standard method on how I can convert such files in IFC?

Hi everyone, quick question: how can I remove the rows from my Excel file where the ID number is duplicated, so that only one record per ID is kept?

Hello I am trying to figure out if it is possible to read Levels from a .dgn files, and rename them according to a Table given to the script. I work at a public contracting authority where we receive “As-Built” .dgn documentation from our consultants, structured according to industry standards regarding level naming, and it would be a huge help if we could rename them to a human readable name which our maintenance employees can understand. I guess I’ve found a way to “read” levels in Microstation files, but I cannot seem to find something that can write Levels. Is that possible with FME? Any help would be appreciated. Cheers Ioannis