General

So I have a collection of excel files that I wish to write out to a single excel file. Wehn consolidating I need a seperate sheet for each excel file read, but want to use a template to style each sheet in the same way. When I do this the first sheet written is formatted correctly, but all subsequent sheets written do not have the sheet style of the first (it's just raw output). I've attached the writer parameters and properties, is there anything I should change to get this to work or is this just not an option? Oops sorry forgot to mention this is in FME Flow 2023.1.1.1 (actually it's the Data Interoperability Extension for ArcGIS, working on getting a proper licence!) in Windows 10 x64 edition.

The documentation is absolutely correct: "When Workbench opens, it displays a Start tab. The information is generated from a live web page, so this tab will always display the most up-to-date FME news, downloads, and resources". But here it is: I have come to dislike the "Start tab" with passion (gusto?). When I open Workbench, I always want to start a new workspace and get on with my project or task. And every time, I also have to either close the extra tab, or choose to create new workspace before I can do so. It didn't bother me the first few houndred times. Only when I fist noticed this little "additional click" with the mouse, did it start to bug me. As I couldn't locate the solution myself, I turn to my FME-colleagues out there for help; please preserve my sanity. Illustration of the main three ways I don't want to start my work added below. It is just one of those little things that start getting at you. Like the special hum from the r

Hi, I have a pointcloud where I want to count the unique number of values in a component. In this case I want to find the number of unique GPS time values in a point cloud (The point cloud is made from individual epochs of a lidar scanner, but there are time gaps so I cant use the max/min values) Basically is there something like the hub transformer AttributeValueCounter (which doesn't work on components). I do not know how to use python so I can't work out how to edit their method to work on components rather than attributes I can kind of do it by using the PointCloudSplitter and counting the files, but this is really slow Thanks

We have been using FME 2021.2 ( build 21789) and recently upgraded our SQL database to 2019. We started seeing timeout errors when the FME writer tries to connect to the SQL Server and keeps saying 2023-10-16 15:04:58|  2.2| 0.0|INFORM|Microsoft SQL Server Non-Spatial Writer: Trying to connect using Microsoft OLE DB Driver for SQL Server...We use windows scheduled task manager to run our jobs and this is causing some of the jobs block other FME jobs. Any ideas on what may be the issue.  Thanks,AD

After the update to version 2025.0.2, the writer is very very slow.  Am i the only one who noticed it?

fme form 2025.0.3 ，can not open it

Just looking to see if anyone has had similar issues? I'm using FME 2023.1.1 and I've been having some strange issues with Log file paths. I has a workspace run on a separate machine with a workspace runner and the job filed to submit because it couldn't find the log path. The log path was pointing to the original location on my machine. I took a look at the fmw in a text viewer and saw the path defined in full.  I reopened the workspace, moved a transformer and re-saved it. This fixed reset the log path back to "$(FME_MF_DIR)<workspace_name.log". This has happened at least twice now and I'm not able to reproduce it. Just wondering if anyone has run into the same issue at all.

Today I'm breaking my rule of never manually (or automatically) editing a workspace file, in order to dynamically update a choice-type user parameter.Question of the WeekThis question was asked by @philippeb who needs to send a list of names to a survey choice field. Q) Our employees fill a weekly survey about their health and their kids going to summer camp activities.The survey [fields] change in time, depending on the kids that subscribed. The subscribed kids are exported into an Excel file every week.  I thought to read the file with FME and push the kids into the survey every week. That way the list of kids in the survey could change without our help. And the kid (or his parent) could select his name to fill the survey.The issue is that we don't know any survey platform able to change automatically from a script. Do you know if any kind of platform could change when FME pushes new values into it?A) I know of a platform that could be used to provide a weekly survey: FME Server! Aft

I have a workspace that works without issues in FME 2024.2.1. We are planning to upgrade to FME 2025, but I am facing issues. When riunning the workspace in FME 2025, it seems to work fine, but after a while I get lots of a recurring message like this one:2025-06-02 11:38:25| 119.2|  0.2|ERROR |FFS reader: Failed to open file 'D:\FMETemp\wbrun_1748852462857_30000\fmetmp_0\FMETable_1748853274266_18156\FTShim_1019.fts' for reading.  Please ensure that the file exists and you have sufficient privileges to read itThese messages DO NOT appear when running the workspace in FME Form/Flow 2024.2.1I have tried FME Form/Flow 2025.0.2 and FME Form 2025.1 (beta) and all of these fails.I have set my FME_TMP environment variable to D:\FMETempDoes anyone have an idea?

While looking through a folder of workspaces with a text editor, I noticed that one workspace fmw file was not in the usual XML-like format. It was instead a JSON file with a leading header line:# application/x-fme-json-workspaceThe last build/saved metadata states "FME(R) 2020.0.2.1 (20200511 - Build 20238 - WIN64)" - however when I create a new workspace with this version, it is saved in the XML format. I tried a variety of FME Desktop versions from 2019 to the most recent 2022, none save to JSON, but all are able to open the JSON fmw. This question is in part simply out of curiosity, and also because I have made a small Python script that iterates over a folder to gather some metadata that the WorkspaceReader does not publish (luckily the attributes I'm looking for are in the same "path" in both formats).

Hello everyone,This is the FME news for 12th January, 2022. FME2021.2.2 UpdateAlthough 2022 is very close, we still release updates to 2021. In this case version 2021.2.2 was updated yesterday:  Except... a number of keen-eyed users noticed that the installed FME was still flagged as 2021.2.1. So what happened? Well, that's on us. We uploaded build 21805 when we meant to upload 21806. Sorry. We'll upload 21806 shortly. If you did install 21805 then you're one build short. What's missing in the extra build? Well, let's look at what's new in general. So 2021.2.2 is minor fixes (not new functionality) and there were fixes for: SchemaScanner transformerGeoJSON Writer (when writing Mapbox Styler properties)Log4j updates (see this page for the latest info)Cesium format (on a Japanese Windows machine) also a fix for version numbersHTTPCaller (GUI fixes)Garmin (improve reaction to incorrect GPSBabel version) Only the last item was part of 21806, so if you can live witho

I have always tried to use the databaseupdater but have always had issues with it.Why if i have a unique column with GFID values and i want to match that it gives the error.Microsoft SQL Server Non-Spatial Writer: Failed to write a feature of type `dbo.COGO_23' to the database. Provider error `(-2147217900) The data types text and text are incompatible in the equal to operator.'. SQL Command `UPDATE [dbo].[COGO_23] SET [GFID]=?, BLAHBLAHBLAHWHERE [GFID]=?'this is a flat mssql table with no geometry. 

Curious if the new version of Form, 2023.2.1.0 will support ESRI's new Date (only) or Time (only) formats? They are not appearing for me when connecting AGOL, but they appear when I connect to a FILEGEODATABASE.

Hey FME Lizard!In the HTTPCaller the Multipart Upload window is only showing two rows. Would be great to see more lines!So difficult to see the line I want when I have twenty. I have to click the narrows too many times...Thanks :)

Hello ,Is it possible to control the position of Upper left x and Upper left  y in a PDF formatter by setting their values in an attribute beforehand, so that the PDF formatter reads and uses them directly?I don’t want to keep adjusting the x and y positions directly inside the PDF page formatter every time I find that the output is not properly aligned. Do you have any tricks or suggestions to help me arrange my PDF layout more quickly?It takes a long time to design the PDF layout . Thanks in advance .

If we run SQLExecutor in FME workspaces in FME server 2022.2.2, then we can't connect to the Snowflake datasource. We have this problem in multiple workspaces that run on FME server and for multiple Snowflake databases/schemas. It raises this error:2023-6-29 15:14:13 | Performing query against SNOWFLAKE_NONSPATIAL dataset `snowflake_datalake_acc'2023-6-29 15:14:13 | No SNOWFLAKE_NONSPATIAL dataset name was specified (couldn't find a value for `R_1_DATASET' or `SNOWFLAKE_NONSPATIAL_DATASET')It has strange behaviour. When we load the same workspace, same input database/schema/role, same output database/schema/role, and different data table it can connect for some data tables, but it does not connect for other data tables. Is there a way to solve this? We got this problem when we switched to a new role in FME server for authorization to databases/schemas/tables in Snowflake. We already checked the database connection configuration in FME server multiple times and it is correct since it wo

I am going to read Data from ProjectWise. FME could read Folder trees (as attached picture) but accessing to folders is not possible. (my user name and passsword are correct)(Also I have the Bentley CONNECTION Client installed and logged in.)The IT guys said that they useAPI version 2.8.Is there any solution to solve this issue?Thanks in advanced  

Auto attaching transformer to a link is a great feature. But while moving multiple transformers some of them they attach to links without such intension. If not noticed it create a lot of problems.

I'm struggling to figure out a way for an initiating Feature to trigger 2 separate WorkspaceRunners simultaneously. In this case, Workspace 1 and Workspace 2 are completely independent of each other, and it doesn't matter to them if the other Workspace Fails or Succeeds. However, Workspace 3 DOES need to conditionally only run if Workspace 1 and Workspace 2 both succeed, and Workspace 1 and 2 must only report "Success" if they run with no errors. I hopefully set it up this way below only half expecting success, although it ended up that this still only ran the WorkspaceRunners in Sequence and didn't work, since WorkspaceRunner #2 waited until WorkspaceRunner #1 completed before pulling in the Initiator Feature. Note: Workspace 1 and 2 are completely different FMWs and completely different Parameter lists. 

Hello,In some cases, JSONFormatter writes a decimal point number with the full precision of floating point numbers.Example:Source{ "number" : 1.954, "string" : "1.954" }Formatted by JSONFormetter (FME 2021.2.2){  "number" : 1.9540000000000002,  "string" : "1.954"} I think this document is desired in many cases.{  "number" : 1.954,  "string" : "1.954"} Is there any way to prevent adding the excess decimal places?

Can anyone please explain why with only 1 feature being read, more than 1 can fail? Any help would be highly appreciated!Many thanks!!

Hi FME'ers,Here are the answers and results to yesterday's quiz:Answers1) Which of these transformers has a Stiffness parameter?DisplacerHullAccumulatorSpikeRemoverRubberSheeterEggBeaterThe answer is the Displacer transformer. This transformer is useful for moving features apart that are too close to each other (usually for cartographic purposes). The stiffness parameter controls how much a feature can be deformed in moving it.  Give yourself 3 imaginary bonus points (ibp) if you knew the answer already, 2 ibp if you figured it out from what the transformers do, and 1 ibp if you typed stiffness into Quick Add and pressed tab (great tactic).You get no ibp if you went through each transformer to check!2) The FME Mobile App that connects to FME Server is called...FME Server ExpressFME Data ExpressFME Mobile ExpressFME Workbench ExpressFME Vande Bharat ExpressIt's the FME Data Express. It's intended to allow mobile access to Server, with some data collection capabilities to

The FeatureWriter has an option to set the Table Qualifier. This makes it possible to use one writer for multiple database schemas.Unfortunately the FeatureReader is missing something similar which leeds to a lot of spaghetti. It would be a nice improvement if you can set in the FeatureReader the Table Qualifier (based on an attribute value). 

Hello together, I'm a bit confused. I have a workbench where I merge attributes from 3 data sources. The result should being saved in an FFS file. But the workbench throws an error at the end which is completely meaningless to me. This is the end of the log file:Translation was SUCCESSFUL with 25 warning(s) (919246 feature(s) output)FME Session Duration: 35 minutes 27.1 seconds. (CPU: 1867.5s user, 275.9s system)END - ProcessID: 25060, peak process memory usage: 17993084 kB, current process memory usage: 307928 kBTranslation was SUCCESSFULError running translation.On the one way the translation seems to be successful, in the other way there is an error running the translation. One strange thing is that there are two instead one FFS file being created by the writer of the workbench: Output.ffs (with 39 FTS files) and Output_1.ffs (with 9 FTS files), although I defined just the Output.ffs in the writer. In spite of the error I tried to load the Output.ffs into the Data Inspector. I also 

When publishing any workspace to FME server, with files that need to be uploaded, i get the following error. Publish failed - FME Server encountered an error and reported the following message.The resource name must not contain any of the following characters: \\ / : * ? " < > | & = ' + % # non have my files have these characters Its happening with any new workbence, and it doesn't seem to matter what the reader is. even simple workbence, with a reader straight to a writer fails to upload.  Wondered if anybody has encountered this.Using FME Server/desktop 2020.2