Automation

Does anyone have any hints and tips for testing automations in fme server 2019?ExamplesI have a scheduled automation and want to test whether an email gets sent correctly reporting on job success or failure, do i have to manually change the schedule to 5 minutes in the future to do this or is there another way?I want to check whether an email that is constructed using user-keys returns the correct output, do I have to artificially construct workspaces that fail to check the fail part of the automation?I'm thinking that creating a dummy workspace with a parameter that will control a pass or fail result is and building the automation with this initially might be the way to go but wonder if I'm missing something?

I have an Oracle SQL database containing about 200 tables, with tables containing anywhere from 5 to 700000 records. I want to figure out which one of those tables contain records we actually modified over the past two years, preferably without having to query all 200 tables for a record containing a last_modified date after January 1st 2023. Would there be a quick way to just return the table names for every table containing a record that contains one or more records matching the criteria?

Hello everyone,I was trying to create a webhook based on my colleague's workspace, which I want to invoke using an HTTP Send action in an automation. My colleague used group boxes in his script to neatly organize the user parameters.The strange thing is that when I try to create a webhook from his workspace, the user parameters are not available. However, if I make a copy of his workspace, remove the group boxes, upload it to FME Flow, and then create a webhook based on that version, the user parameters do appear in the webhook URL.I also tried manually copying the parameters my webhook url to my colleague’s webhook URL to test if it would work, but I received an error. This error does not seem to appear when in the workspaces the user parameters are not grouped within group boxes.Has anyone experienced this behavior before? Does anyone know if this is a bug—where user parameters placed inside group boxes are not recognized in a webhook?2025-7-8 15:31:18 | Error connecting to Oracle da

Hi All - I have done this multiple types with different data formats/inputs (e.g., Excel, CSV, Shapefiles) with no issue. However, I can’t seem to be able to allow end-users to select a fgdb from their drive and use as an input for the script (very simple script which converts Feature Class to other formats). The Workbench works perfectly fine via setting up a User Parameter which is linked to the ESRI File Geodatabase FeatureReader. I could even add another User Parameter to allow users to select specific Feature Classes for the script which is handy too but not necessary (linked to Feature Types to Read).However, once this is published in Flow then the interface doesn’t allow for the end-user to “Upload Files” like other Self-Serve Apps I have created. You only have the option to “Browse Resources” which doesn’t let you browse your computer to select the relevant File Geodatabase. Note that I have tweaked with the User Parameter “Item to Select” choice and chosen either ‘Folder’ or ‘

Hello, I’m new to working with Flow automations and still fairly beginner level with FME. I appreciate any guidance you can provide.The WorkspaceI am working with ArcGIS Online and Field Maps. We have teams in the field everyday collecting data. At the end of the day I run a workspace that tidies up their tracklogs and calculates how many km they covered and hours spent.I’m using 2024.2 build 24783 for both Form and Flow.What I want to achieveHaving this data in the feature service isn’t enough. I also want an email summarising this information.How can I do this with Flow Automations?What I’ve triedWith the Email action I see options to send basic information like attaching the log, how much time it took to run, what time it ran, but I want more detailed information to show in the email. The information is an FME Feature Attribute created in the workspace pictured below.One colleague said it wasn’t possible in Flow and is better to do in Form using the Emailer transformer. Is that corr

Hi,I’ve developed a workbench that scans a selected folder and generates an Excel document listing its contents. I’d like to publish it to FME Flow, allowing users to input a folder path from the same PC where the workspace is executed. However, the app is currently failing. Is this setup possible?

Hi all! First post here, so I’m excited to get some feedback!For context, I do a report on our organization’s EV chargers every month. In this report, I need to calculate the average time of day people are charging, the average charge time (duration), and the total duration.Currently, I am unable to get the average duration and the total duration.Here’s my processConvert the time to FME format using a DateTimeConverter Sum and average the times using a SatisticsCaclulator I attempt to convert the summary back into H:MM...But then I am met with the below error: Where am I going wrong?

Hi there, I know it is possible to use attributes from a workspace in a Flow automation by using the automation writer, however that seems to only work if you connect the output port of the automation writer to your next action in Flow. I need a way to use these values in a later event without connecting the port.Scenario:Webhook trigger → runs a workspace to create a report that is then stored in a resource folder, also outputs a few attributes that i want to use in the body of my email action. I then have a resource or network directory trigger that fires when a new file is added, this triggers an email to be sent. The issue:If i connect the automation writer port to the email action then i end up with two emails. One contains the attributes in the body but with no attachment. the other contains the attached file but is missing the attributes.Any help would be much appreciated,Cheers

I see there’s already an Idea for providing the option for versioning Automations in FME Flow but the Idea was created 5 years ago and there doesn’t seem to have been any traction on it.So, in the absence of any official support from Safe, what are people doing with regard to creating and saving versions of Automations?Currently, if I make a change to an Automation but then need to revert that change there’s no way of doing it once it’s been saved.The only workaround for this I can think of is to make a Project containing the Automation and then manually exporting the project (and saving it to a version control system) before making any changes to the Automation. The obvious problem with this is that it relies on:remembering to export a Project before making any Automation changes making sure the Project name is consistent (hard to do with multiple people editing)There does not seem to be any System Event that is triggered on Automation change and no API call available for downloading

Hello everyone,I have some experience with Workspace apps, but not as much with Automation apps. In my previous work with Workspace apps, I created an app that is based on user input on a map. When a user clicks on the Run button, the "Running..." button appears. Once the script finishes successfully, the user can download a ZIP file by clicking on the Datadownload URL.Now, I’m trying to build something similar using an Automation app, but I’ve found the process to be quite different.Based on the following post, I’ve set up the following: I have a manual trigger that includes a manual parameter called "Geometry" (GEOM). This GEOM parameter is then used in the subsequent Workspace. Similar to the Workspace app, I want to show a "Running..." button while the script is running, and once it finishes, makes a download URL available to the user. However, the only feedback to the user is the green "Automation Triggered." message.There’s no further feedback for the user, that the script is r

Hi guys we have a generic translator app built in workspace app. however we often has issue when there’s no output written (file generated for download) or translation failed. on the app it still display process completed but return no download link.  Im using downloading service on writter outputs but wondering if there’s a way to let it return a message or simplely inform user traslation failed / error occured / or no output was generated. thanks!

Hello,I have automation which triggers a workbench and has to send result file on email in the end.The resulted excel file has dynamic name with @DateTimeNow parameter.How to set that automation takes the correct file? If I add fixed name, it works fine but I don’t know how to make it for dynamic name. Could anyone help, please?

We have set up an automation to send data to a number of ArcGIS Portals,In each of the portals we have set up an application and in FME Flow Hosted we have set up corresponding web connections.The issue we are finding is that every day we need to re-authenticate the connections, other wise our automation fails to complete from start to end.Is there are way to ensure the web connections automatically authenticate or is there a way to run a process each day to refresh / re-authenticate? 

Is it possible to have a log out button/log out link in an Automation App?

Hello,I followed the FME Flow tutorial to trigger a workspace when an email is received using the SMTP protocol:https://support.safe.com/hc/en-us/articles/25407759987981-Run-a-Workspace-in-Response-to-Incoming-Email#FME-Flow-email-via-SMTP-protocolThe server is a Linux Debian server, and ports 25 and 7125 are open on the firewall.I tested it on port 7125, then on port 25, and finally on port 25 with redirection to port 7125, but it still doesn't work.The log files show no trace of emails arriving on FME Flow...I don't understand what's blocking it...

Hello everyone,I already looked at the following post, but this post is already 6 years old. Myself I don't have any experience with the the FMEServerJobSubmitter and I was wondering if there are other ways to pass the job-id from one workspace to another workspace in an automation.  I tried using the automation writer as a method to pass a job-id from one workspace to another workspace, but that doesn't seem to work, the job-id is empty in the second workspace.

I have an automation which has a few workbenches which are SQLExectutors that gather parameters and write to automation writers.  There are then workbenches which consume these parameters and use them for processing..  In the automation setup I assign the parameters to the incoming attributes.  This process runs weekly.  It runs successfully but occasionally it starts failing, when I go into the automation it is failing because these parameters have reverted to their default values. I have to re-assign them back to attribute values.  How is this happening by itself? This process isn’t being touched by anyone else and will run successfully for months. This is in FME Flow 2023.2.1

We have 3 automations that run in parallel (with a slight time offset) and each is identical but runs workbench(1) workbench(2) and workbench(3)  so they can run without clashing.One of the parameters for these is a gdb connection file reference which is stored in Resources...Data. However to load this from a workbench we have either no value or a local file path in this parameter and this is edited in the automation to reference the resource file.Periodically one of these automations (not always the same one) will start to fail because when I look the parameter has reset to the default value. There seems to be no rhyme nor reason to this. The last one to fail was number 3 so today I’ve tried to recreate that automation from scratch. What i really need is a guaranteed fix for this so it doesn’t happen when we go to production. We are processing a large queue of data and in production need all 3 streams to be active.thanksRob

Hi, I'm still a beginner with FME and I have the following problem: I have an automation that is triggered via webhook. The caller expects a JSON response in a specific format. How can I achieve that? Normally, only the default 202 response is returned. 

Hello, my question is quite simple and probably idiotic but I haven’t found a clear solution to this anywhere, so here we go…I have a very simple Flow App where the user drags and drops a DWG file that then gets split up into separate layer entities and written to our SDE. So what I want, and again quite simple, is that that after running that App the user gets an email notifying him/her if the process succeeded.  Meaning the running of the Flow app is the trigger for the Flow automation that then sends out an email based on a attribute value from the Flow app (the user basically fills out their email in the Flow app that gets assigned to a attribute in that process).I cant for the life of me figure out how to use a ran Flow app as the trigger and the other things that comes after that is just bonus question material if anyone wants.How do I do this?-Hlynur 

Hi all, for a workspace-app in fme flow, i was asked whether ,and if, how it is possible to have only one upload field for all file types (.xlsx and .dwg), rather than having individual upload fields for each file type. To my knowledge, each reader in the workspace has its own upload-field in flow/the workspace-app and i can only select which are published and which are not.I tested the “Directory and File Pathnames” Reader and the “Generic” Reader, but the user should not have to select the folder, but each file individually (multiple files at once). This is needed for more user-friendliness.Hope that explaines the predicament :)Thank’s for your help!Cheers.

 I wanted to share a project I’ve been working on : a way to "watch" a PostgreSQL table using FME Flow Automation.Since I began working with FME Server/Flow, Automation has always stood out as one of its most powerful and easy-to-demonstrate features. The ability to trigger workspaces based on incoming emails or new files and automatically send notifications, consistently makes an impact during demos. But one question kept coming back:“Can I detect changes in a database table and trigger workspaces from that?” For a long time, my answer was: “Not really”, or at least, not in a clean or recommended way. I used to think the best option was for the database to notify FME Flow, not the other way around. For instance, in PostgreSQL, you could use a trigger on insert/update/delete and call an FME Flow webhook using something like the PL/Python or pgsql-http. That method is covered here:- 🔗 4 methods for tracking data changes in FME (blog post)- ▶️ Triggering FME with your Database (YouTube

So in one of the tutorial for creating AR, the screenshot of FME Flow has the Create AR App option in Flow Apps. But I opened my FME Flow 2025.02 version, it only appears these options without Create AR App:Is anyone having the same issue? Is there anything I did wrong? Thank you so much for the help.

Hi there,I have an FME Flow automation set up triggered by a survey123 submission. When i submit a survey from survey123 on my computer it works fine and runs the automation. When submitting from my mobile device however nothing comes through, the automation doesn’t run.Any help would be much appreciated, cheers.

Hi All, We have recently ran into an issue with using a SharePoint Multitenant web connection of FME Flow.  A connection/client id/client secret has been created in azure and used to creat the mutlitenant connection within FME form and then published up to flow.  This connection works the day of but when added to a schedule to run daily, it fails out the next time it runs.  When we go back in and authorize the connection again in flow, it seems to work.  Is there a particular setting in the connection or azure to keep this connection active? Thanks,