FME Form

Has anyone had success with using the updated 2025.2 Excel writer to write data to a table in Excel?  I see that this idea was implemented with 2025.2:  Excel Writer: Explicit Table Support | CommunityHowever, the instructions for the writer don’t go into a lot of detail on how to have the writer create a new table on a sheet and load it with the incoming data.I personally tried to follow some of the older demo’s that walk throughs for writing to a named range.  Those walkthroughs require you to create a template xlsx file with the named range already created.  So for my 2025.2 test, I create a new template.xlsx file, then created a table named tData on Sheet1.  The table is blank.  After that I created some dummy data in FME and tried to write it to a new excel file using the template.  The output excel file does load the dummy data onto the sheet, but it doesn’t go into the table.  And actually my table disappeared from the sheet.It would be great if there were some tutorials out the

I’m working in an FME Form workbench reading in CSV files that reflect database updates and then using them to update a central XLSX file. However, when the CSV reader is pulling in a column with values of either ‘TRUE’ or ‘FALSE’, it is automatically converting them to ‘true’ or ‘false’.Has anyone ever noticed this with a CSV reader?Unfortunately the domain I am describing with this data has capitalized values, so reporting the codes as lower case somewhat defeats the purpose. I know the parameter for Case Sensitive Field Names would resolve the issue if i were seeing this in the attribute names but unfortunately i haven’t been able to find a similar parameter for the data itself.Is this just an inherent setting to the CSV reader format?

Hi All,I am currently working an automation process to convert XYZ files into LAS format for use in ArcGIS. I have successfully generated the point cloud and exported it to LAS; however, the classification information is not being retained.The custom classifications are based on codes contained in the original XYZ files as text, and these values are stored in a table, an example of which is shown below:  How can I convert the XYZ files to LAS while preserving the Feature attribute as the classification?Attached fmwt fileThanks :) 

Dear community,I am currently working on FME Workbench 2025.0. My project take into entry areas in 3D that represent buildings roofs. It then spreads the data into two datasets: roofs and building using the latest ground footprint. In order to do that, I am using the 'Dissolver' Transformer with the Group Processing option on. My issue is that some of the edges inside the building are remaining because they do no fit on the Z axis (see screenshots below). Dissolver operation: purple edges are classified as ‘Remanents’ after the operation, red one remain.Result of Dissolver : on a 2D perspective, internal edges are remaining.For better context: the result of the Dissolver from another perspective in 3D.I tried to flatten the surfaces before proceeding to disolving the objects (these objects corresponding to 'Building' will be flattened at some point of the workbench anyway), but still the same edges are remaining. Thank you for your help.

Hello,My team has developed a workspace for data collection of publicly available GIS-data. The workspace uses HTTP-callers to download the data from different URL:s, and then the data is clipped from a predefined area of interest. The schemas and the features area separated and the rejoined later in the workspace. The output is written to an ESRI Geodatabase. Everything is working fine using FME Flow 2023.2.2.0 - Build 23781, but when I tried upgrading to FME 2025, I get an error:“Esri Geodatabase Writer: Feature Type Definition 'd_y_n' was requested, but not defined. Please visit https://www.safe.com/support”Does anyone have any insights into this issue?Thanks in advance /Ville

Hello!I am trying to make sure that we have compatibility across all our different platforms. Our organization has recently upgraded to ArcGIS Pro 3.6. I was taking a look at the compatibility matrix and noticed that for ArcGIS Pro 3.6 is says the minimum FME version to have is 2025.2. Does this mean that FME Form and Flow 2025.1 cannot be used with ArcGIS Pro 3.6?Any help is greatly appreciated!

Hi , I am working a lot of the DWG files and I had somebody did the work. So when I  received the DWG files and review them.  I have ArcGIS Pro and I looked at them and I was not sure about the  coordinate system there… so I pulled the file in FME Data Inspector and found them that they are not in the right place I am in Colorado…Question first is : What does the red symbol mean here ?Black square with blue point is where the DWG is. The record information shows the coordinate system is Unknown.

Hi all, I’m fairly new to FME learning a lot but still get stuck at the odd point.II’m using attribute manager to set 2 attribute values to later be used in httpcaller. here I am setting the values and trying to use the values in the below url.  this is going through to the url without the actual value. I have tried both the ${myvalue} and @value() methods but both simply put what i’ve written below into the actual url but not actually the values.  I used the logger to view the above values and they are definitely showing as 100 and 1 but I can’t get them to show up in the below url. Can anyone direct me to what I’m doing wrong here?   

I have an excel file that has changing header position at every ingestion. The header is randomly stated into any row position and before the header data is populated until row 4 (not always stable). I have been using these configuration where the Field Names Row is set to 1 and Cell Range is blank by default. However when the different file is ingested, these values automatically changes to 1 and 2:as attached in the screenshot.  I tried changing the attribute definition to manual, however it terminates the translation when the feature type changes. What is the best approach to this issue given that the names in the header remains always stable? 

This seems pretty basic so it’s probably a configuration that I’m missing, but I’m using FME Form v2025.1.1.0 and I have a half dozen Loggers set up to capture features that are repaired or failed in GeometryValidators that precede them.  When I run the workbench I have ‘Enable Record Counting’ set so I can see the counts going to the Loggers, but none of the messages I would expect are getting written to either the Translation Log window in FME Form nor to the log file on disk.  I’ve set the Navigator > Workspace Parameters > Log and Troubleshoot > Max Features to Log to -1 to log everything, and I’ve confirmed that the ‘Severity Level’ in each Logger is ‘Information’.  I’ve tried all 3 settings for ‘Feature Logging’ of ‘Log Only’, ‘Log and Record’ and ‘Message Only’ in various combinations of the Loggers and I’ve confirmed that the ‘Max Messages to Log’ for each Logger is larger than the number of features being routed to them. The expression in each Logger is pretty simple,

Hi,I have a dgn file created from OpenBuildings. Within OpenBuildings you can see attributes attached. However, they only seem to show in OpenBuildings not Microsation or FME (i.e they are not tags or xrecords). Therefore, the attribute data must not be stored as tags or xrecords. Does anyone know how attribute data is stored within OpenBuildings application and how fme can read them? Ta

Hello,I have an editable view in PostGIS (PostgreSQL) and I'm trying to write in it with FME.For that, I've:Added my view from a PostGIS reader (to have its structure - and confirm it exists)Duplicated this view in a new PostGIS writer (to keep its structure)Set the table handling as `Use existing`Connected a worflow to end in my viewBut when I run the workspace, I'm facing this error:POSTGIS Writer: Table 'xxx.yyy' does not exist. Please check the Table Name specified, or modify the Table Handling value under Format ParametersSo my question is: is it possible to write in an editable view?For the record, I can write in my view with another client (QGIS) with the same credentials.Thanks for any input.Rémi

Hi I am using projectwise wgs connector to upload a file into pw. I was wondering if their a way to uprev the version metadata attribute within pw. When the file is uploaded to pw.

I currently have the older Esri ArcGIS Online web connector and the new one configured. FME 2025.1.3.When I try to create a new background map, I only see the older web connection as an options for Esri AGOL maps. Is that expected?When I use it (and I’ve confirmed that I’m authenticated correctly by testing in a feature reader first) and try to browse to maps I get the following2026-02-09 16:14:37|      |     |ERROR |FME Objects Worker [28108] > Failed to read features using the 'ARCGISONLINE' reader Any tips? 

Hi there,In Esri ArcGIS Connector safe.esri-agol version 3.17.0 a number of changes were made to the way the Esri writer handles global IDs.  Some of these changes resulted in previously published workspaces no longer functioning after the package on Flow was updated.This is an admin nightmare, as unless we prevent all publishers from uploading packages, we cannot prevent them from deploying a new version of a package that may break existing workflows.I have two suggestions:Please put the latest changes of the package at the top of the description in the FME Form Dialog box. Currently the user has to click a link to go to the item in the Hub and then find the version in the History. Please clearly indicate any changes that are more than bug fixes, and that may impact previously published workspaces.Thanks,Marc

Because it would be nice if FME Flow could connect to Autodesk Construction Cloud without Re-authenticating every week we tried to implement Autodesk Secure Service Account in FME Flow.https://aps.autodesk.com/blog/introducing-secure-service-accounts-ssa-now-public-betaIt was pretty complex and requires the PyJWT library installed onto FME Flow. Also the current Autodesk Docs connector will not work with the new WebConnection so all calls need to be made with HTTPCallers:Folder contents: GET: https://developer.api.autodesk.com/data/v1/projects/@Value(project)/folders/@Value(folder)/contents File url in the result (GET): json["relationships"]["tip"]["links"]["related"]["href"] Last version storage url (GET): json["data"]["relationships"]["storage"]["meta"]["link"]["href"] You need rewrite this url because it must end with /signeds3download Download url (GET): json["url"]  The webconnection will store the credentials and hold the token:<?xml version="1.0" encoding="UTF-8" stan

Hi there,I am assessing a dataset for changes that took place since 2012. This data contains these two fields of interest:change_date reason_for_changechange_date contains multiple dates that a separated by a comma and reason_for_change contains strings of change types separated by a comma.An example of the data structure is Feature 1:change_date: 2016-10-20reason_for_change: New Feature 2:change_date: 2009-06-15, 2013-09-04, 2016-10-05reason_for_change: New, Attributes, Modified Feature 3:change_date: 2010-09-11, 2014-04-09reason_for_change: New, Attributes Is it possible within FME to pair each individual reason for change to a change date and then test if it matches the follow conditions of reason_for_change = New or Modified and change date greater than 2012-12-31?Using the three examples above, feature 1 and 2 should be highlighted as a change since feature 1 is new in 2016 and feature 2 had it’s geometry modified in 2016.So far I have used a Attribute Splitter on each field to sp

I am in the process of moving my FME Desktop 2021 workspaces into FME Form 2025. I know I can open the FME 2021 workspaces in FME Form 2025. As I get farther along in this process, is there anything I need to be aware of? example, is it best to just rebuild my FME 2021 workspaces in FME Form 2025 instead of just opening and saving the FME 2021 workspaces in FME Form 2025?I have run a few FME 2021 workspaces in FME Form 2025 with no issues. But wanted to reach out to the FME community to see what their experience has been in bringing in older FME workspaces into new versions of FME.

Hi everyone,I’m struggling with a limitation in the Excel Reader and I’m hoping someone has a reliable workaround for a fully dynamic workflow.I have an automated FME Flow workspace where multiple users upload Excel files through an FME Flow App. These files contain yearly planning data for different teams. The challenge is that users will sometimes rename existing columns and sometimes add completely new columns to the Excel sheet.Even when I configure the Excel Reader with Dynamic Schema by using Single merged feature type, FME does not refresh the schema at runtime. It only updates the schema if I manually right click the reader in the Navigator pane and click Update reader. Simply running the workspace does not trigger a schema rescan.I have tested using CSV instead of Excel but the schema still remains locked to whatever was detected when the reader was first added. As a result, any renamed columns or newly added columns are ignored unless I manually refresh the reader.Is this a k

Hello,I currently have some workbenches which access APIs and hence have secrets within them, which is fine when this is secured on FME Flow. I also want to set up version control, and have all of my workbenches uploaded to remote repo, GitHub. TLDR: How can I secure my API secrets on GitHub?So far I’ve looked into:encrypting my workbenches  https://support.safe.com/hc/en-us/articles/25407644298637-Password-Protection-for-FME-Workspaces this seems OK, but doesnt truly secure the api secrets, it does add a level of security but it could be better Storing my API keys as published parameters on FME Flow this may be hard to manage, especially when trying to run/debug/design any API workflows if a user/developer accidentally hits ‘save parameters’, then this method will likely be redundant can become messy and difficult to manage in general Would setting up the secret as a password parameter within the workbench encrypt it in the .fmw? Will a password protected workbench still work on F

Hello,I am using a Sharepoint List reader to expose all hidden fields and show all fields. This usually works for me but not for this specific list. This list is very large, has views and hidden fields.  The errors:1) 2025-04-17 09:48:51|   1.8|  0.0|ERROR |Microsoft SharePoint List Reader: Client-side error: '401 Client Error: Unauthorized for url: <…..>' returned from SharePoint. Error message was: '' 2) 2025-04-17 09:48:51|   1.8|  0.0|ERROR |Python Exception <FMEException>: FMEException: 929309: Microsoft SharePoint List Reader: Client-side error: '401 Client Error: Unauthorized for url: <.….> returned from SharePoint. Error message was: '' The query (url) generated by FME (which I’ve removed from the errors above), is 2300 characters long. When I click this URL it takes me to a blank page with the message:I have found this:https://learn.microsoft.com/en-us/dotnet/api/system.web.configuration.httpruntimesection.maxquerystringlength?view=netframework-4.8.1which I b

Is there a way of Auto switching Parameter between Form vs Flow?ie Local while working on FME From (C:\FME_SHAREDRESOURCE_DATA) vs FME Flow($FME_SHARERESOURCE_DATA)Workspace Locally with FME Form is add “C:\FME_SHAREDRESOURCE_DATA” to the FME Flow Parameters to test and work on the solution. When I upload the Workspace to FME Flow I always need to remember to remove the local value for everything to work.  I forgotten a couple of time and wondering if Deployment Parameters is the solution?  

Hi - I’m trying to write small areas of map data from a Geodatabase as a DWG / DXF file.The spatial data is available when I open the exported file, but none of the attributes, only a single column called <no schema>:I’m wanting to include the following attributes: but I have tried countless variations of the available Writers:I just can’t get around the <no schema> issue.Is it actually possible to include attributes within a DWG / DXF Writer?If anyone can offer some step by step guidance, I’d be most grateful.Cheers :)FME(R) 2023.1.1.0 (20230928 - Build 23631 - WIN64)

My workbench tries to read features from ArcGIS Online feature services, write them to a different database and, if successful, delete them from their ArcGIS Online feature service. I’ trying to use as few feature writers as possible, so I use attributes to descern feature services and their layers. Most feature services contain only one layer, but the name of the layer can be different from the name of the feature service.I can get the name of the layer from the format attribute “fme_feature_type” and use that for the “Layer Name” in the Feature Writer parameters: But in the “Writer” group (button: “Parameters...”) I also want to use an attribute for the parameter “Selected Feature Service”. Is it possible to get the name of the feature service from the reader?

I wanted to make all my attribute to camelCase, currently they are separated by underscore.I wanted to change my attribute name to camelCase, so using regular expression in BulkAttributeRenamer transformer to find text following underscore using regular expression replace: _([a-z])  However, i am not sure what String parameter i have to put to make the selected character Capital letter. I have tried \U\1 and also few other but its not working. Basically wanting to find String parameter value?