Automation

I would like to create a Flow app where the user can upload an Excel file for further processing. But I need some help on how to validate it:How do I best make sure that the uploaded file really is an Excel file? How do I validate that the first row contains attribute names and that the first attribute follows a certain name standard (for instance, “Street_Name”)? How do I automatically create attributes for the remainder of the columns? (Some uploaded Excel files might only have “Street_Name”, but other may have columns like “Speed_Limit” or “One_Way” or whatever attribute the user want to keep in the processing.)  

Hi,I wonder if using FeatureWriter and Feature Reader together in a workspace affects how the fmw runs in FmeFlow?My fwm looks like that:When I run the fmw in Fme Form everything works fine. I get the correct fileB.xlsxDepending on the type of service used in FmeFlow, I get different results:Data Download – error: 'E:\FMEFlow_Temp\fmeengines\localhost_Engine1\TempFS_1757066224587_10608\dsR_2_0\FME_22532F00_1757066082752_10608_0'. Error message was 'Permission denied Job Submitter - The result file is correct and saved to the defined path in the Fme Form Data Streaming - Under Uploads there are two folders: FeatureWriter with the fileA.xlsx and XLSXW_1 with the correct result fileB.xlsxI have spoken with our IT department,

I’ve been working on a service which is to be triggered by a webhook. The process ends with an email to the initial requester with a link to the data where they can download it from. On of the things I want to include was/is a summary of the request to help the user figure out what it is they requested when they look at the email. But that requires me consuming and then giving back the user their own input. In testing I’ve found that it’s really easy to just inject key words into the request. There are certain key words that just get resolved directly meaning I couldn’t even try and sanitize the request. Is this a lost cause? Has anyone else battled with this?For example if the request was something like {    “parameter1”: “{event.id}”}Then {event.id} just gets resolved and if I’ve using “parameter1” in my email then it just gets set out as the event id. 

i’m not even sure how to title this - i have a workspace that looks like this: in general, the process is looking at input user parameters from an upstream workspace via FME server automation, the first step is the SQL executor to see if the current date is a holiday, if so, then that dates gets flagged as “Holiday Exception - YES” otherwise i want it to continue to process to the attribute creater that appends some numbers and makes some features from user parameters there is then a series of filters to route the email different places depending on time,day and holiday status, then ultimately they end up at one of the FME automation writers. the SQL exe looks at a table of holiday dates and then uses a tester to see if the current date matches a holiday: 

After enabling long file paths in all the proper locations there are still long file path restrictions on the FileCopy writer.  Am I missing something?  I ended up using a PythonCaller to get around this restriction, but thought I would bring up the issue so it can be updated or fixed.  Thanks

Dear Team,I have an Emailer transformer at the end of my FME workspace (FMW file) that is configured to send a completion notification to my Gmail account. However, I am encountering an error when it tries to send the email.I have already updated the Emailer transformer, Python, and other relevant components, but the issue persists. But from desktop it runs perfectly. only when i run from command prompt it gives error.("D:\Program Files\FME2024\fme.exe" D:\fvt2\1_spatial_tables_ver9.fmw )Could someone in the group please help me identify what might be causing the problem?Thank you in advance for your support.Best regards,Farook2025-04-29 05:17:31|1614.6|  0.5|STATS |DateTimeStamper (TeeFactory): Cloned 1 input feature(s) into 1 output feature(s)2025-04-29 05:17:31|1614.6|  0.0|STATS |CRCCalculator_2_Executor (ExecuteFunctionFactory): Executed FME Functions on 1 input feature(s) -- 1 feature(s) comple

I have set up an automation which is triggered from a webhook.depending on the content of the request it will process different datasets. These different datasets may, in some cases, require the use of a web connection. I thought I’d be able to control the access via the token, however, it seems that the user who triggered the automation is not the one running the workspace and therefore has no bearing over access to a given connection. Any ideas on how I can make it so the token controls the access?I was thinking about instead using a workspace before the automation to list the available connections for that user and then pass that along to the automation. 

Olá a todos! Estou procurando informações mais detalhadas sobre espaços de trabalho dinâmicos, mas não encontrei muita documentação detalhada. Estou procurando dicas e práticas recomendadas para criar fluxos de trabalho dinâmicos no FME. Tenho vários Shapefiles, cada um com atributos específicos. Todos eles passam por um processo padrão de limpeza de atributos e validação de geometria. Alguns também exigem processamento personalizado, além das etapas padrão. Estou pensando em começar com o SchemaMapper, já que temos uma planilha interna do Excel que controla o mapeamento de nomes de atributos — acredito que essa seja uma boa prática. Aqui estão minhas principais perguntas: Qual é a melhor maneira de processar um shapefile por vez, executá-lo no fluxo de trabalho padrão e, então, usar um testador para direcioná-lo a um processo específico, se necessário? É recomendável criar uma fila de processamento? Essa é uma pr

I am still facing this error. My Email Transformer is up to date, but the issue persists. When I run the workflow through FME Desktop (Form), it works fine. However, when I run it from the command prompt, the email is not sent and I receive the error log shown below. Could you please clarify why FME uses different Python environments for Desktop (Form) and fme.exe? This inconsistency is causing problems. 2025-08-21 06:23:59|1853.9|  0.0|INFORM|Successfully closed POSTGRES database reader2025-08-21 06:23:59|1853.9|  0.0|STATS |SQLExecutor_5 INITIATOR Splitter (TeeFactory): Cloned 1 input feature(s) into 2 output feature(s)2025-08-21 06:24:02|1854.3|  0.4|ERROR |Message Type: fme::internal::_v0::py::Exception2025-08-21 06:24:02|1854.3|  0.0|ERROR |Python Exception <ModuleNotFoundError>: No module named 'fmepy_emailer'2025-08-21 06:24:02|1854.3|  0.0|FATAL |PythonFactory failed to load python symbol `fmepy_emailer.Emailer'. An outdated FME pa

Due to the changing license model of SAFE, the license file now needs to be updated every year.In order to not forget that, I am trying to create an Automation that gets triggered by the License About To Expire trigger, but I am not sure when this trigger occurs. Is it one week before or one month?I can’t find anything in the documentation. System Events

Hello,I’ve recently turned on Version Control a few days ago and just got around to setting up a Remote Repository (GitHub), I’ve just ‘pushed to remote’ for the first time, and I’ve noticed there are only 3 items on my GitHub repo, while I have 100+ workbenches uploaded.I assume this has just uploaded items which have changed since I turned on Verion Control a few days ago. I was hoping enabling remote repo would push all of my workbenches to github. What is the best way to proceed? I want to get all of the items uploaded to my github repo, not just changes, so I have a backup of all of the items on Flow.Thanks.

Hi, It must be stunningly simple however we miss the clue, but we're trying to get FME Server to accept Single Sign-On logins. We connected to Active Directory, that seems to work nice since we can use a user and password from the domain and log in, that's a success. Mon-13-Nov-2017 04:20:33.924 PM  INFORM  RequestHandler-Thread  401831 : Accepted new client connection from /127.0.0.1 on port 7,071Mon-13-Nov-2017 04:20:33.926 PM  INFORM  RequestHandler-Thread  401933 : Successful login by user XX99999However, when we press the Use Windows Credentials the login is denied and fmeserver.log shows this error message:Mon-13-Nov-2017 04:23:22.734 PM  INFORM  RequestHandler-Thread  401831 : Accepted new client connection from /127.0.0.1 on port 7,071Mon-13-Nov-2017 04:23:22.770 PM  INFORM  RequestHandler-Thread  408043 : (Single Sign-On)  Enabled single sign-on authentication.Mon-13-Nov-2017 04:

I want a workspace to run on FME Flow at 11pm with a user initiating it at some point within the working day.Currently thinking of having the workspace run within an automation, which is scheduled to run daily at 11pm. User would enable the automation, workspace would run at 11pm and then trigger a second workspace which makes a http call to stop the automation. So the workspace is only run once and won’t run again until the process is repeated.Any ideas of a better way to do this?

I have an email in Outlook (Exchange) and hope that it is possible to read the emails with FME Desktop. Does anyone now how to do that?Regards,Morten Friis

I have been provided some .raml files, but unclear how I interrogate; can anyone advise? 

While trying to create a workspace app , I find ‘Service’ dropdown to be empty (pic2). However, I see ‘Job Submitter’ as service in the published workspace (pic1). May be I am missing something as we just started using FME products. Thanks for your review and input.

I am leaning how to do the engine management in FME Flow 2024 at the moment. I had setup 2 extra queues out of default queue, but I only create 1 active period for one of the queue. Then I found out all jobs within another queue were in “Queued” state. My questions are:Do I have to setup active period to cover all queues? When 1 queue was setup in active period, how does other queue(s) work? What the default behaviour in active period. When the jobs in “Queued” state, can I resume it to run rather than re-submit the job and delete the existing “Queued” job?Thanks,Henry from TfNSW 

HalloI am currently experiencing an issue where a running job becomes stuck and cannot be canceled via the FME Flow Web UI. Even after restarting FME Flow, the job remains in a "running" state. When restarting the FME Flow Application Server, Core, and Engine, the Automation restarts but gets stuck again.The following error message is displayed:2025-07-28 16:43:11 | AUTOMATIONS writer: FME Flow error: `FME Flow error: UNPROCESSABLE_REQUEST(Automations) Route "Param_Bundle" does not exist`I have already tried both options mentioned in this article:https://support.safe.com/hc/en-us/articles/29779782496141-Known-Issue-Job-Submitted-from-Automation-is-Stuck-Running-and-Cannot-be-CancelledUnfortunately, neither resolved the issue.Could

Hello to the community,I successfully set up an fme flow automation with a final action to send out an smtp email via our email server. The connection to this email server with the “SMTP Account” is valid and successfully tested and mails were sent. But the “SMTP Account” is not setup to receive emails at all.When i try to change the parameter “Email From” in the “email send” action to a different mail address than the used “SMTP Account”, our mail server denies to send out the email as a different user.This is for security reasons.But i want the email recipients to be able to just reply to an incoming email without changing the mail address. Further I don’t want to place a hint in every mail that it is not possible to simply reply to this mail without changing the address.Is there another way to change the smtp header parameter “replyto” for the email send action in fme flow?Thank you very much for any help and hintsbest regards

Hi,  What is the approach to pull the username information from the active directory ? Use case: My role on FME flow is admin and I publish the workspaces using the create workspace app. The workspace links are provided to end users (they don't have any user profile created on FME flow) and all they do is simply use the link to ingest the file and use the generated output. My ask is what is needed to integrate the AD to the FME flow and if the user profiles must be created on FME Flow in order to fetch the user information? I want to imprint the user name ( user who executes the job ) and display it on the reconciliation report?

Hello everyone,I have a short question. How can I share an automation app so that an user doesn't need to  authenticate. himself/herself? I am able to share workspace apps with users by disabling the Require Authentication button, but I can't find something like that for an automation app.I also looked at manage token and enabled some options with Automation, but still the autonmation app does require an user to authenticate himself/herself. 

I have a folder that contains various zipped shapefiles that I am trying to export to a geodatabase. This folder is updated regularly and the shapefiles are points, lines and polygons. How can I read in and then export them to the geodatabase without needing to worry about the geometry type? I have looked into generic readers and writers but I have not been able to figure how to get them to work.

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