FME Flow

Dear All, I am requesting your input on how to automate task on Teams using FME?  Excel tracker on TEAMSON TEAMS : I have day-to-day job task tracker in Excel format. ON MONDAY.COM: The team members go and update data (dates, complete / in progress status, this Monday.com data could be manually downloaded in excel file  ACTION / INPUT required : I would like to do fully automate process meaning: FME connect and pick /extract data from MONDAY.com  FME apply those transformer to obtain desired statistics (i have complete this part and could do this myself) FME goes back and APPEND the new statistics in Excel file stored on TEAMS. When the task is complete, am email goes to line manager and other stakeholder that the task is completed.  Highly obliged with you inputs many thanks /Vim

If an automation is triggered by a schedule, you can obtain the schedule properties via the Schedules list.  https://docs.safe.com/fme/html/FME_REST/apidoc/v3/index.html#!/schedules/list If an automation is triggered by a topic, how do you obtain the name(s) of the topic(s) that trigger that automation?If an automation posts to a topic, how do you obtain the name(s) of the topic(s) that automation posts to?

What is the process to access the database on the FME Server just so that we could have a trail of files that users ingested and the outputs that were generated? What are some of the best practices we can implement that can be helpful at the time of audit ?

I am creating an Automations proces and when assigning the parameters to an integer field  get the following message: Must be a whole number. Decimals are not supported.In the Automations first a csv is read for creating all sorts of parametersIn here there are no decimals.In the workspace tm_data has the Type int16In the Automations writer it is also defined as integer.But when assigning the parameters, I receive the error. This applies for all integers I use in this.This is a automations proces that I also build in Server 2021 and I didn't have this issue but in Flow 2024 I can't get any further because of this error.Is there something I do wrong or is this a bug?

Hi, I was wondering if anyone else has experienced this? Yesterday my site access for FME Flow worked fine and today it won’t work at all; I get 404 error.The only thing that seemed to occur between yesterday and today is a Windows Security update. Has anyone else experienced this? I have stopped/started all services; uninstalled the update and restarted the machine but nothing seems to work to get the site back up. I feel like rolling back to a backup is the only option.  Thanks!

I have a job running that takes 10 minutes and generates 19.000 rows in the log. The runtime is not the issue here, I'm just curious to out some numbers on time-spent.What’s the best way to find out where the time is spent?I suspect a few specific transformers, but since this is probably a common question I wonder what other people are doing.

Hi,I would like to ask if there is a way to share webconnections to group of users with partial permission (ie only access permission) not full permission. the issue with full permission that the shared users can be able to delete web connections I shared. I have to tried to take off their manager and create permission but still wont be able to let them do not remove the share connection.We are looking for a way can do partial permission setting up. Thank you very much. 😁 

Hello everyone, I encounter a similar problem to the following post from 4 years ago.I am able to write several output files (2 .dgn files) in FME Form. However when I publish the script to FME Flow and run  the script in the form of a workspace I only get one output result back.I already looked into the Data Download Service Properties when I publish the script to FME Flow and both writers are already included in the Writers in Download attribute. So I am not sure why I don't get both files in the zip file. The files don't have the same name. The weird thing is also that the dgn file I get back from FME Flow has the same name as the zip file, while in FME Form they get the name I have defined in the writers (Bomen.dgn and Kabels_Met_Buffers.dgn).Another finding is when I look into the translation log on FME Flow, it looks all features are written (23000 features). I know that 18000 features are in one file and 5000 features in the other file. So it looks like all feature are written, 

in a FME FORM i have made some user parameter, that takes in input; one of them have a conditional visibility based on whether another user parameter has an input of > 100. When i run the creator in FORM, and input a number abobe 100,  it works, but when i publish it to FLOW the conditional visibility doesn’t work.then, if I change the condition to “is 100” instead og “> 100” and republish, it works.is this a bug, or is there a work around?  

Hi -I could use a hand. We are working with FME Flow 2024.1.1 with work spaces being generated in FME Desktop 2024.1.1.The data download service is working fine, but we would like to be able to do one or two things:Is it possible to just download a .docx or xslx file without it being zipped? It is one other step that our end users don’t need. If not, is it possible to name the zip file according to report for the area we are working in, something like: BostonStreets_20250203.zip. An example of the output we are seeing, and would like to change, is attached. We can name the files within the zip file whatever we want, no problem.Any help or suggestions are appreciated!Thanks! 

Workspace I’m uploading from FME Form (2024.0.1.0) returns this error.  Failed to update definition of database type 'Microsoft SQL Server (JDBC)' - FME Flow encountered an error and reported the following message.Database type Microsoft SQL Server (JDBC) cannot be edited.Request to http://XXXXXXXXX/fmeapiv4/databasetypes/Microsoft SQL Server (JDBC) returned status code 422. Is a workspace that has SQL Executors pointing to a SQL Server database and outputs results to a XLSX file on my laptop.Any help would be appreciated. 

Hi FME community,I’ve recently been asked if FME Flow supports access via the Microsoft Entra application proxy. Has anyone configured this and can confirm it is supported?I believe it’s very similar to the setup explained in the documentation below, but I haven’t been able to find any documentation referencing the Microsoft Entra application proxy.https://support.safe.com/hc/en-us/articles/25407571916173-Use-a-Reverse-Proxy-with-FME-Serverhttps://support.safe.com/hc/en-us/articles/25407364847885-Using-IIS-and-ARR-as-a-Reverse-Proxy-in-FME-FlowThanks!

This job works fine in FME Workbench 2024.2. But in FME flow, when I try to run the workspace, it’s trying to create a folder instead of a .xml file. See screenshots

We have an FME Flow Hosted instance running and I need to connect to an MS SQL Server. I have seen from the Reader/Writer documentation that MS SQL is not supported from FME Flow Hosted.Does anyone have a suggestion how we could still connect to MS SQL?The question is very relevant to us, since we plan to migrate to an FME Flow that will also run from an Linux-instance, which seems to be the cause why it isn’t possible to connect to MS SQL. N.B. Our current FME version is 2024.0.3.

Hi AllCurrently we are facing some weird issueWe have a FME workspace which is running fine in FME Form (2024.2.3 - 64 bit), we have published to FME Flow (2024.2.3) and when we ran the workspace from FME Flow, it started throwing below Ora error (changed ServerName & UserName values to XXX to hide)-“ Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`ORACLE8I', serverName=`XXX', userName=`XXX', password=`***', dbname=`') “I have cross verified the below from my side on FME Flow (Windows Server) and I’m not sure what I’m missing, please suggest how can I overcome this issue in FME Flow.We are not connecting to Oracle using local naming (tnsnames.ora file) instead using LDAP TNSPING ServiceName - resulted correct response  Ensured both Oracle Client 32 bit and Oracle Client 64 bit paths are part of ‘Path’ environment variable under system variablesFME Flow windows services (Application, Core, Database, E

I have a 2023.2.1 workbench that reads in a JSON file using the TextLine reader, does some FME magic and the outputs the results for FME Server (Flow) to use.2023.2.1 workbench to process JSONThe reader parameters are set to read the whole file at onceThe workbench is published to FME Flow 2023.2.1 and is used in an Automation that gets an AWS SNS message with the JSON info in the message of the SNS. The SNS is received as expected but the message appears to be reading each line as a separate source and as such it never processes the file as expected.  Any advice as to what I am doing wrong in the process?

Hello, I am using FME Flow 2021. I have an Automation that uses Directory Watch. When a file is added to the “Directory to Watch,” the Automation should run. But it does not run when a new file is added. I can run it manually, and it works as expected. In my screen capture below, it seems I need to add something to “Events to Watch for” to trigger. What am I missing?  

Hi list.I have a local FME Flow development setup using 2024.2.3Originally all of its 4 services ran as Local System, but the workspaces need to access files on a file share on another server, and so I tried changing the services (except database) to Local Network Service without much success.Our production servers (2022) do run with an AD account, so I have som experience with this approach. I therefore changed the development Flow to run under my AD account.The interface seems to be working ok, but now whenever I try to run a workspace, it errs with “There was an error submitting the job”.Why is this different ? What am I missing here ?Any insight is appriciated.Cheers

Hi all, I am trying to modify a workbench and re-upload it to the server (2020.1 to 2020.1) and am getting back an error that: The following readers or writers are included in an enabled service, but are not present in the workspace: [SourceDataset_JSON]Request to xxx returned status code 422. This has only happened since we updated the server from 2020.0 to 2020.1. The workbench takes incoming JSON from a notification service using a topic and subscription and runs it through the workbench and dumps it into an Esri Portal FS.  This error is odd because there is only one reader and one writer in the service.  If anyone else has seen this problem please let me know. Thanks!-Adrian

Hello all, I have a FME flow web-app (image 1). I am attempting to get a message to the user in certain circumstances via HTML output (image 2), which displays a message via the browser to the user if certain conditions are met, via redirecting the web-app page, e.g. there is an issue with their edits (image 3)image 1image 2image 3, text printed through the browserThis works, sort of. but its not good enough for end users, as the page redirects, but is blank and is stuck in a perpetual loading state. Until the user hits the ‘stop refresh’ (X) on their browser, then the message (image 3) appears.My questions are:How can I make this work without the user having to hit the stop refresh button?Will that page redirect stop the rest of the FME process from running/committing changes? Is there a way to link this to a terminator? if I can terminate the process the perpetual refresh may also stop.   I have the services set up like this:Or, are there any alternative ways to get a message to the

This article covers setting up FME Form & Flow Emailer transformers, but doesn't cover the System Email setup in FME Flow.https://support.safe.com/hc/en-us/articles/25407404506253-How-to-Connect-to-Microsoft-Exchange-Online-using-OAuth-2-0-Microsoft-Modern-AuthenticationThat page has much fewer settings available than the transformers:The docs don’t mention how to use Client ID (UI notes this as Microsoft OAuth only)https://docs.safe.com/fme/html/FME-Flow/WebUI/System-Email.htm What are the steps needed to set up System Email with Microsoft OAuth?Do we need to register an SMTP Account & Password rather than use Client ID / Client Secret?

We have 3 different FME servers, how can we modify the FLOW UI so that you can easily distinguish one server from the other?

Greetings!I have a simple workbench that runs without issue on Form (v2025.0) that uses a CSV reader that lists File_name, file_url in which the url is a SFTP://hostname:22/path/filename.typ The CSV reader is linked to the FTPCaller.This process works fine on Form (desktop) and loads the files to the respective server and path.However, when the workbench is run from the server, is runs Successful-but does not load the files; in the log there is an error: FTPCaller (FTPFactory): FTP/FTPS/SFTP transfer error: Could not resolve hostname Any suggestions on why?

I am trying to read/write from ArcGIS Portal in FME Flow with a parameterized Web Connection, but am not able to select a connection in FME Flow. I used these steps to set everything up succesfully: https://support.safe.com/hc/en-us/articles/25407772142733-How-to-Create-an-ArcGIS-Enterprise-Portal-Web-Connection-OAuth-2-0 ✅ FME Form I created:a webservice named 'Esri ArcGIS Portal MyCompany’ several web connecions: ‘user1 Esri ArcGIS Portal MyCompany’, ‘user2 Esri ArcGIS Portal MyCompany’This works fine in FME Form and I can read from ArcGIS Portal. ✅ FME FlowI published these service, connections and workspace to FME Flow as described, and this runs fine as well. As long as the connection is hardcoded in the workspace. ❌ FME Flow with Portal Connection ParameterNow I want to create a parameter for this connection, so I can choose in FME Flow which connection to use, but that doesn't seem to work.When creating the parameter the only supported service is 'Esri ArcGIS Portal (Template)’,

Hi All,I have a question regarding the integration of FME Flow with the ArcGIS suite. I am currently developing a 3D viewer platform utilising ArcGIS technologies, such as the 3D viewer, to display LiDAR data in SLPK format. The platform operates smoothly; however, my client has requested the capability to download the data as LAS files based on an 'Area of Interest' (AOI) drawn by the user.I am considering embedding an FME Flow application within an ArcGIS Experience Builder that hosts both the 3D Viewer and the FME Flow application to facilitate the download of LAS files. Is this feasible? Any information or resources to assist in achieving this would be greatly appreciated.Additionally, is it possible to customise the FME Flow map to function as an ArcGIS Webmap (either 2D or 3D) to display the extent of the LiDAR data? My tests have only shown the default map with OpenStreetMap as the background, but I aim to provide users with the extent of the LiDAR data so they are aware of what