A space to discuss FME Form
Recently active
as I consider using fme to convert filegdb to geojson, facing problem in attribute length = 65536 for string, those attributes will truncate in geojson. how to fix it.Thank you very much
I have some strange behaviour that Im hoping Safe can confirm, I have built a very simple loop in 2026.2 using the new looping functionality, it runs fine every time. I then encapsulate that into a custom transformer, thats where the weirdness starts. Running with caching OFF everything behaves itself...I then turn caching ON and the loop on the canvas behaves as expected, but the custom transformer containing the SAME loop doesn’t…Inside the custom transformer…The Loop doesnt initiate, when caching is ON, I cant work out why?I have attached the workspace.
Dear allCould anyone of you and your experience give me some clues, ideas how recover XML-Driven XML that suddenly gone missing from reader/writer format?grateful/egm
FME Flow using a directory and pathname reader transformer. it has run in this folder before (different fme version) and not had this error.PATH Reader: Error reading path '\\Tx-mio-miso1\mi-shared2\SUR\MoDC_TXAS_NRGY\COUNT_FLEET_\ASBUILT\WORKING' with error message: 'The media is write protected.'Why does a reader transformer need write access?It doesn’t even get to the writer and fails
Hello,I recently noticed some unexpected behavior with the Feature Merger in FME 2026.2.1.I have a workspace where a Feature Merger combines data from three different streams. Under normal circumstances, everything works as expected. After successfully testing the workspace locally, I published it to FME Flow.Today I noticed that the workspace failed during execution. When I opened the workspace in FME Form and ran it with Feature Caching enabled, I was surprised to see that the Feature Merger did not merge features that clearly shared the same key values:What makes this even stranger is that if I right click the transformer and select "Run Selected Objects and Any Required Upstream Objects" a second time, the merge completes successfully without any changes to the workspace or source data.Has anyone experienced similar behavior with the Feature Merger in FME 2026.2.1? Could this be a caching issue, an optimization problem, or possibly a defect?Thanks in advance for any insights.
Hello, the initial base tables have non null values and my writer to AGOL is finishing with majority of the fields as null. The way it is set up is: Base Table > Attribute Manager/Keeper > Feature Joiner > Attribute Creator>Feature Joiner>Attribute Manager>Output Data Layer. In total, there are four non-spatial tables and one spatial geometry layer being used to create this layer. What is the best way to approach this? Thank you! I am using FME Workbench 2024.0.2.1
After the June 2026 ArcGIS Online update last week, the Esri ArcGIS Connector stopped working when attempting to download .csv admin reports. Prior to last week’s update, the connector would download these .csv files without issue. As of last Friday (6/26), FME returns the following:fme_rejection_message: 400 Client Error: Bad Request fme_rejection_code: INVALID_FILEwhen attempting to download .csv file. These errors persisted over the weekend and today. It fails both in FME Form and FME Flow. Versions I am using:FME Form: 2025.1.2.0 (Build 25630) FME Flow: 2025.1.2.0 (Build 25630) Esri ArcGIS Connector: 3.25.1Note: This exact error is returned for multiple types of .csv files generated within AGOL. I have dug into Chrome Developer’s tools to compare and confirm URLs and Payload being sent to the API and everything looks the same on both ends (Chrome and FME).Something might have changed with AGOL API’ backend. Is anyone else seeing these same issue? If so, how did you resolve it? Or,
Hi,With the new SQL Server Reader is it possible to simulate the older non spatial reader?I have 3 million records with line geometry. I only want to read the attribute information and not the geometry. I can’t spot how to do this in the 2025.2 Reader. Is it not possible or have I missed something simple?Thanks, Annette
Hi, When i try to connect open service: https://gis4.waimatedc.govt.nz/arcgis/rest/services/Public/RoadClosure_Waimate_Active_Planned/MapServer using "Esri ArcGIS Feature Service" reader, I get Python exception error. There is no authentication required as its open service. The fact that I can use HTTPCaller and get the data with query service tells me, this service doesnt require authentication. Am I missing something? I tried few other rest service from this council with no luck. Python Exception <HTTPError>: 403 Client Error: Forbidden for url: does this error means anything to do their IT system infrastructure? Any help would be appreciated? Cheers,
HelloWhen reading a Utility Network feature service on ArcGIS Enterprise from FeatureReader using the Esri ArcGIS Feature Service format, only 2000 rows are returned. No errors are shown in the translation log (scrubbed and attached, using package version 3.25.4). There are no AGS Log entries to indicate an issue on our side. This issue was not present with package versions 3.22.0 and 3.25.1 Environment: ArcGIS Enterprise: 11.3 FME Form: 2025.1.3.0 (20251001 - Build 25643 - WIN64) FeatureReader Version 16 Esri ArcGIS Connector Package: 3.25.3, 3.25.4
I have just migrated my FME Flow installation to 2026.1.1. I have ArcGIS Pro installed on the server. I am having a strange issue with workbenches failing due to licensing. I have multiple workbenches which use ESRI geodatabases and are scheduled to run repeatedly 24/7. At least one of them fails intermittently due to:Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility workspace parameter, found in Navigator -> Workspace Parameters -> Spatial. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more detailsThe compatibility parameter in the workbench is set to ArcGIS Server/ArcGIS Pro. It will run successfully 3 times, then fail twice. No pattern to the failures. How can a licensing issue be intermittent? I have multiple other workbenches using esri licenses that run successfully.Has anyone seen this before?
I current have a workspace reader that reads all of fmw files in a selected folder and use the WriterFeatureTypes to find all names writers in each fmw file being read.But when I run it, it produces errors and warning messages that aren't relevant to the writer (screenshot below).Since I only wish to know the names of the layers that the writers in each fmw file writes to, is there a way to avoid reading other information about the file such as the transformers to remove getting these errors/warnings and improve the runtime?
I have a workspace on FME Flow that ultimately creates records in a SQL Server non-spatial database using two SQLExecutor transformers with queries that came directly from the DBA. I didn’t write the queries and I only basically understand what they do because I’m not a SQL person, but they both are sandwiched between “BEGIN TRANSACTION → COMMIT” statements. Up until recently, the SQLExecutor transformers in question used hard-coded server/username etc and it all worked fine. However, during our most recent FME Flow software update (to 2024, but I don’t think Flow is the problem here as it is present in my Form testing as well) I was informed by our FME administrator that I could no longer use hard-coded server/username details, I had to switch to using an ESRI ArcSDE Geodb connection file to connect to this SQL Server database. This change worked just fine for other, more simple, Select and Insert sql queries, but these two mentioned above just stopped working. I confess I find
Dear FME colleagues, I am working on a workbench that needs to read an Excel file and keep (write out) only those attributes listed in a second Excel file. The workbench must be fully dynamic; this means that after publication and scheduling on FME Flow, the user only needs to maintain the second Excel file to generate the correct output. To do this, the user simply needs to indicate in that Excel file which attributes should be kept and which should be removed. I haven't quite managed to configure this yet!Can anyone point me in the right direction? I’ve tried using the SchemaMapper and AttributeManager, as suggested in other articles, but I haven't quite succeeded.Below are screenshots of both Excel files: the first shows a portion of the data (128 attributes in total), and the second image is an example of the attributes that need to be kept or removed.
I quickly became a big fan of the recently introduced in-canvas looping functionality in FME. Here is one workflow where loops make things particularly elegant: building geometry from list attributes without first exploding the list into separate features.In this example, each list element contains a coordinate pair such as [500,611]. Before the feature enters the loop, ListElementCounter records the number of elements. On each iteration, we use the iteration number to retrieve the corresponding pair, extract its X and Y values, and create a vertex.The expression used for the JSON Document parameter is:@Value(_list{@Evaluate(@Value(_iteration_num)-1)})We subtract 1 because FME list indexes start at zero, while the loop iteration number starts at one.Every generated vertex leaves the loop and goes to LineBuilder. At the same time, the feature goes to a Tester, which compares _iteration_num with _element_count. While the values are different, the Failed port sends the feature back for an
When we’re using FME Flow as our Connection Store. We’ve been noticing that some parameters of webservices start to disappear or change. Examples: Redirect URLs go blank, configuration of headers change, etc. We’ve been seeing this phenomenon in our AGOL web services and SharePoint List web services. Has anyone else seen this type of behavior?Here is our setup:FME Form/Flow: 2025.1.2 (Build 25630) FME Flow is a distributed deployment (1 core + 5 engine machines) Accessing FME Form (and the Connection Store) via Citrix/Azure Virtual DesktopTo resolve the issue: We either have to fill the in blanks/fix the issues or drop the web connection and web service completely and start from scratch.We’re just trying to understand what might be causing this.Thanks in advance!(I am sure this isn’t the correct Category, but nothing else fit as an option here.)
I've got a few challenges concerning styling of an excelsheet. It's not just an ordinary sheet with columns and rows, but it's a reporting template. The report contains several attributes in different fields and several images. The issues/challenges I'm currently facing:I would like images to fit itself into a named range or predefined rows and columns. See screenshot below. I created a predefined named range ‘overzichtskaart’ which covers cells $C$4:$E$16. But as far as I can see there is no option to let FME/Excel know that the image should stay in those cells. I created a workaround now which tells the image that it should align in xlsx_row_id 4 and xlsx_col_id2 with a height and with of 255 pixels. But this goes wrong as soon as the alignment of the attributes changes (for example multirow text in column B). Does anyone have a smart work-around to fit the image exactly in the desired cells? Named ranges are useful to make sure that the attribute-data ends up in the right cell, but
Hi everyone!Today I’d like to share a new approach to building reports in FME, along with an entire family of custom transformers I’ve created to support it. Why I built BRGI’m a long-time fan of the HTMLReportGenerator. It lets me craft reports quickly, and I love the versatility of HTML compared with, say, PDF. I even demo it in every Intro to FME course as a great example of “let FME handle the code.”But as much as I love it, I’ve always hit three pain points:1. Plain styling – it could really use a dash of CSS/Bootstrap.2. Hard-coded content types – adding a new chart or HTML element isn’t trivial.3. Cumbersome feature ordering – managing Sorters and AttributeCreators just to control layout can get messy.Earlier this year I had to build a highly procedural report with lots of HTMLLayouters, AttributeCreators, and Sorters, and the workspace quickly turned into spaghetti. That’s when I thought: I already improved SystemCaller with BetterSystemCaller… why not do the same for report ge
Hi,I tried this through the V4 REST API, but when I add a conditional statement to the Request URL, I’m seeing <not specified> in the Request Preview for the URL.I also noticed something in the Automating FME Flow App Customization article. They created a user parameter named SOURCE_FILE, but in the Request URL they use UPLOAD_FILE.Could you please clarify why these parameter names are different and how the conditional statement should be configured in the Request URL?Thanks!
Looking at the new Define Read Criteria By: Custom Query option in the FeatureReader in 2025.1I feel like there should be a warning against using Define Read Criteria with Esri Geodatabase format as it uses sql and bypasses specific SDE functionality.
I’m using FMW Reader to read and analyze FME workspaces, and I have a question about custom transformers.There is an attribute called Custom Parent Name. When this field exists, it shows me the connection to the custom transformer inside it. However, how can I determine whether that specific custom transformer is enabled or disabled in the main FME workspace?For example, suppose an FME workspace contains multiple instances of the same custom transformer, such as: LineDivider LineDivider_2 LineDivider_3 The Custom Parent Name attribute may contain only LineDivider, without the _2 or _3 suffix.In this case, how can I distinguish which specific instance of the custom transformer the connection belongs to?More specifically, how can I reliably identify: The exact instance of the custom transformer in the main workspace. Whether that specific instance is enabled or disabled. The relationship between the transformer instance and its Custom Parent Name, especially when multiple instanc
I'd like to read a DGN file, which contains a terrain model. In version 2025.1.2 it is being read as igds_polygon_collection. The fme_Geometry is “fme_undifined” and the fme_type is “fme_no_geom”.When using a Civil 3D file, it can read a surface model, which is the same principle as the terrain model in a DGN. The terrain model is created in OpenRoads.Or is another option available to read the terrain model directly from a DGN file without converting it to another fileformat or element type?
I want to calculate upstream and downstream distances along river polylines between barrier points. I’ve got as far as generating a topologically correct river network divided at barrier locations, river intersections and junctions complete with network_id. I’m stuck on the next steps! The main challenge is what to do upstream when a river branches out. Any help would be greatly appreciated! Process so far
I have a QGIS .model3 file that uses PostgreSQL tables as its inputs and writes to other PostgreSQL tables as its outputs. I am having trouble getting this model to run as part of an FME Workbench.What I have done so far:Copied the tool parameters from the QGIS graphical interface (Advanced > Copy as qgis_process command) Edited the command so that “--” only appears in front of the first parameter Added “” around each PostgreSQL parameter as they contain spaces and special characters and were causing Invalid parameter errors in Windows command prompt Thanks to these changes, running the tool with qgis_process in Windows command prompt no longer throws invalid parameter errorsThe tool fails silently through the SystemCaller transformer in FME.In Windows command prompt, the parameters now seem to be read properly but I am now getting “File could not be found” for PostgreSQL addresses.Still in command prompt, dialing psql first with my database credentials makes it say \PROGRA~1 is an
I have ArcGIS Pro Data Interoperability Extension. Within the last couple of days, it keeps stalling at the start screen “Checking License”. I know I have a license! And it works sometimes…without any trouble. If I Restart my PC, it opens fine, but if I try to run a reader (excel, csv), that is stalling as well. Even though these are small files, they just don’t come in. I’ve tried starting/stopping/pausing/purging, etc. The only thing I’ve been able to do to get the Extension to open again, is to do a cold boot of the laptop.Is there some other cache somewhere I need to clear out? (I’ve cleared the cache from within FME Form itself) several times, but then end up rebooting anyway. I’m relatively new to using FME, but these files are quite simple with only a couple thousand records. I tried to read both as .xlsx and .csv today. Could this be an issue with a log file filling up? Thanks for any tips/suggestions.