Automation

It's been a while since I last used FME and now it's time to start working with automations  seriously. I need some help to get a quite simple one working though. I'm attempting to do the following: whenever an email from a certain email address and with a certain concept in the subject is received, the email subject and body must be checked and parsed to write a temporary json file that will be uploaded to a server via sftp overwriting the existing file. I already have: An email trigger with a Subject filter. A 'Sent from Address' filter action. A workspace action: AttributeManager and JSONTemplater transformers and a JSON writer get the important information from the subject and content of the email into a json file that is written to FME Server temp directory. An SFTP Directory external action: reads the json file from FME Server temp directory and writes it to a server.

I would like an email notification every time a completed workspacehad an error within the log. Is this possible and how do I set this up within our FME Server.

Can I read FFS file by python?

Hello, I created a dynamic workflow to load geopackages into as many tables of a PostGIS database From a SchemaScanner, I retrieve the source schemas then I build the names of the destination tables and I make some modifications to the data types. For example, boolean attributes are not recognized by FME because the values ​​are not conforming. So I would like to replace all non conforming values ​​of these attributes. In the schema part of the processing, I retrieved all the boolean attributes (in a list or a concatenated string). I would now like to use this as a parameter to define in the features part of the processing the attributes whose boolean values ​​must be corrected (StringReplacer for example). I could manually select these attributes but I would lose the interest of the dynamic workflow. I don't know how to do it automatically. Does anyone know how to do this?

I need to run rather extensive workspace to update database tables from an XML file. The update files can generated every day and are avaible for two months to past. When processing the worskpace I download these update XML and write them them. So far no problem.During the execution I need to check the continuity against a table in the database. So I would need to load up to 60 files read the header with date (1) and previous file information pass it to tester, process first file with all writes (2), write a row to database table with a header information about file processed (3) and take the next files to process from failed tester (4) and fetch them again to SQL executor.I'm not sure about the loop part as it seems there can´t be writers inside and I also miss attributes passed from feature reader. Not sure how to correctly arrange it. An idea is to pass it later to FME server and run every day, so no or just one file would be processed. But the workspace

I'm having an issue regarding the FME Automation triggering the automation when a new file is added to an FTP Directory and running a workspace that needs a parameter of a CAD File or Rivet File, but the Cad/Rivet Reader is showing an error which fails the workspace, I am using the file path in the FTP directory to read it as a parameter.

We have a simple automation that checks an S3 bucket every 30 seconds and triggers a workbench when a file is added to the bucket. It all seems to work fine, except I noticed today that although the automation was still running it was not triggering the workbench when new files were added to the bucket. Looking at the automation log I see...  Service Unavailable (Service: Amazon S3; Status Code: 503; Error Code: 503 Service Unavailable; Request ID: 4F1445BF8D4DF69F; S3 Extended Request ID: bNSlvkHBzAjPZYX7hSRdG86fwpdaYqp2WrrGNa0IpPm4Qk4XeLb9qRXDdUk5EkWY/NdK1PcNYahUZduRItZf4t9NeiHv1+A8juV+dCYgLfc=) It appears that there was an intermittent issue that caused the 503 error. When this happened the automation continued to run, but no longer worked correctly (new files were added to the S3 bucket, but the automation did not trigger the workbench). I added a notifier to the S3 Trigger in the automation so I can be notified of future failures, but w

Hello,  I have a FME Server Automation with a Manual Trigger. This FME Server Automation is triggered via the FME Server REST API in a HTTP Caller. I would like to know if it is possible to set the Output key values (Manual or otherwise) of the Manual Trigger via the body parameter of the HTTP Caller.And if it is possible, what kind of body should you send?  I did find out you can set these in FME Server when you trigger the Automation in the Web UI(Start Automation -> Trigger) when the Manual Trigger parameter of the automation "Prompt for JSON on Trigger" is checked. Then you can set the values for the (Manual) Output Keys. This however can't be used in my process.  Thanks in advance,

Is there any way of returning information about all the workspaces that have been actioned when running a Dynamic Workspace within an automation?

Hello!I have workspace which takes shp files and write it down to dwg.So far so good, FME 101.The autocad contains manholes blocks with attributes, And in crowded places, where there are many manholes, everything is a terrible mess:Is there a way to do a visual arrangement using FME?Where the table of attributes hides another table, or is on a sewer line, move it to another nearby place.I have quite a bit of experience with work intergate Cad & FME,And here I don't even know how to begin to address it.I would love ideas for those who have!Thanks!I am attaching an example file. 

How do you make an automation with two workspaces use only one engine?

I've attached some screenshots to show what it's doing.It will only reset the hour back to 12 it still honors the exact minute I specify. I did look over the known bugs for 2022.x but was unable to find any mention of this. FME Server 2022.1 Build 22618 - win64

I use a python script to set up project directories for specific tasks, The script also copies the workbenches and needed and uses some regex to adjust the paths in the fmw's. Sometimes the schema of the files changes, so I would like the readers to update feature types when opening FME without having to re-import them. I'd appreciate any shared experience and hopefully an example. Thanks!

I have a legacy Notification set up with Publications, Subscription and Topic. Trigger (publication) is an email that publishes to topic. A workspace subscribed this then "Get the Value from Topic Message". In order to work with O365/modern authentication in Server 2022, I'm having to re-do this as a new style automation. I have the email part figured out. But whether I have my next 'Action' (my workspace) parsing the incoming parameter "email.body" or the "Event as JSON", I cannot get this to work as before. The existing old-style solution expected input in this format:{"imap_publisher_content{0}": "  ","fns_type": "imap_publisher","imap_publisher_sent": "   ","imap_publisher_from": "   ","imap_publisher_subject": "   ","imap_publisher_content_type{0}": "TEXT/PLAIN; charset=ISO-8859-1","imap_publisher_received": "   ","imap_publisher_to": "   "}"Event As JSON" seems to f

Has anyone had to switch existing notifications/publications in FME Server from IMAP which is easily configured in the web UI to MAPI? Is there a way without having to roll your own using custom code? I don't see any such options in FME 2020, nor in 2022 that I'm currently spinning up. I'm being told I need to make that switch! Lucky me 😫 

Hey everyone, fairly new to FME here. I was wanting to see if there was a way to mass pull down all published layers from AGOL online into a workspace. I am wanting to automate our AGOL backups, but since we have over a hundred published layers, I was wanting to see if there was a far more efficient way of doing so than individually adding over a hundred readers.

Hello,I want a trigger in FME Cloud with an Emailer 24h/7. When I receive an email, I run a process. If I receive no email within an hour, do I still need to pay for that hour of instance running, even if I ran no process?Thank you.

In a single workbench, I have automated some processes. One of those generates a report in Excel format. I saved this file in the Shared resource folder on the FME server. The Excel attachment is sent out at the end of the translation. Since last week, the tool hasn't delivered emails to recipients because the emails are too large. When I run the tool on the desktop and save this attachment to my machine, it shows a few KBs, but on the server, it shows 10MB. I compared both outputs (one from the FME server and one from the desktop) and neither shows any differences. I would greatly appreciate any feedback and advice!

I've only just now noticed that the Tools repository appears to be hidden. I can still use Filter Message and Log Message actions in Automations (although I do get a warning when opening an older Automation). Can anybody confirm this?

I need to download files from a WebDAV source using FME. Is there any experience around in doing this directly in a Workbench (e.g. HTTPCaller)? Or will I need to integrate third party scripts (e.g. Pyhton)? What would be a feasible and efficient method?

HelloI just started using Automation in FME Server 2020 and plan to use it more by migrating my existing scheduled jobs.I have a workspace which runs a batch script. It uploads multiple files to an SFTP server using WinSCP.com commands withing the script.The workspace in question, in "Automations" is connected to 2 Email (External Action) 1 - Success then send an e-mail2 - Failed then send an e-mail with 2 attachments (WinSCP.txt & Error.txt)Number 2 is the problem. So I thought I'd use Global Keys for that purpose ({Global.Email_Attachment}{Global.Email_attachment1})Right now it's failing before when the 2 parameters are associated together I get an error in the log stating that the file can't be found.Is that possible and if so how do I include both Global Keys within the Email Attachment field? If not how do I proceed?

The current Automation External Action Email does not support multiple attachments and I know I can create one ZIP file, therefore I need to continue to use the existing Notifications (Classic).  My existing workflow is FMEServerEmailGenerator -> FMEServerNotifier ->What do I need to do in the Workbench to pass the "text_line_data" to the Automations External Action Topic?orIs there another method of sending an email with multiple attachments (not ZIP file)

I've been trying to move from the classic Notifications to FME Server Automations for sending emails. In the past I had a Subscription and a Topic set up which I used to notify for sending emails. Going forward, I want to use an Automation with a Trigger (based on my Topic) and an Email Action. The Trigger works fine and I've managed to map the JSON keys from my notification service to the relevant fields in the Email Action (some more documentation around this would have been helpful!). What is missing is sending multiple attachments at once in a single email. This worked fine through a Subscription by creating a list within my notification (email_attachment{}). How can this be achieved with an Email Action? The manual selection appears to allow only for single files, too. An additional note on this - I've noticed that (within the Email Action) sometimes the fields for attachment and email body are being cleared out when naviga

Hi everyone, I know how to read just 1 text file and use StringSearcher to extract string from the content. But how do I read "multiple" text files "automatically" and extract specific string from the content in each one of them? Thanks in advanceHoward

Heya, looking for concept assistance (or more). We want to use attributes submitted in a Survey123 in an email body. My understanding is that this is a nested array in the json payload and must be parsed in a workspace. Can someone help with what this would look like in the workspace... what is the reader and how does it connect to the webhook payload? Also, what is the writer and how is it put into the email body. Just wanted to get more clarity on this before I get further into it. Thanks.