Automation

On our FME Server (version 2019.0.2) we have many Automations running; and many Automations include a schedule.I would like to get the time and day when the Automation is running. I can't find this in the API, is there any other way I could extract this information?

I have an automation setup that monitors a directory for XML files on create and modify. Once the automation is triggered it passes the file to a workbench I published. The work bench automation reads the XML file and the ArcGIS SDE feature class and performs a feature merger to see if the unique key already exists(if the key doesn't exist the xml record gets inserted to an ArcGIS SDE Feature Class. If the key does exist the record gets updated through a change detector.) I ran into a problem where the FME Server job must have been triggered twice where the second job was created 7 seconds after the first. The first time on create trigger the record was inserted properly but on the second modify trigger when the work bench runs it created a duplicate record instead of updating the existing. I suspect this happened because the first job ran but didn't finish before the second job began. Is there a workflow I can follow in preventing this from ha

Thanks to @danminneyatsaf​ for answering my previous question about the SQS Trigger in Automation and certificate failures. I was able to solve because SQS has a Queue URL in the parameters for the trigger and register the SQS certificate as a trusted certificate on FME Server.  With S3 when I try to connect I get the following error again. The "Bucket to Watch" is the bucket name. I've tried going to the bucket url and using the certificate from there and still have the problem. Any ideas which address the S3 trigger is going to? 

Has anyone been able to automate the upload of data to Mapbox? I would really like help with this process if you have successfully completed this. Thanks in advance

Hi, I am new using FME for cartography and I am not sure how can I create those elements in a raster map (north, graticule of coordinates, scale bar), I am currently using Mapnik rasterizer transformer to represent my raster and vector layers, and some labels, but I can't see how can I go from that to a complete map with all its elements. Thanks in advance!

I have an automation that has 3 workspaces.I run this every 5 minutes. the first workspace takes approx 2.5 mins to run. the second and third only a second or two each. The first and second jobs always show up in completed. only sometimes does the final job get created. But it does get created and run successfully sometimes. I understand that if the second job fails the 3rd one would likely not get created. I do have a few fails on job #2 but it still does not correlate the number of #3 jobs missing. how can I troubleshoot this?

hello,I remember that it is possible to start the automation when new source files are coming in a folder from file system, or by email, but this time I'll need to run the script just after the input file is modified.Example:I have an xls file with locations. When I add new lines with coordinates and save the file, the script will automatically transform the data based on new data coming from this xls file. Any ideas will be much appreciated. Cheers,nicu

Hi,I have a script that does an area calculation using arcpy, the two calculated areas are output in the log, I need each one of them to be output as an attribute, how to do this? I'm new to python at FME.  log: The output, it doesn't help me at all.  Thank you for your help  

Hey community!I need some coach, anytime I run any script, FME ask me what is the input file.Can I remove this option? (Attached image).Tnkx a lot to everybody!

Looking for more information on FME Server 2018 and Fault Tolerance.

I would like to start using python with FME. I have some scripts that I need to run several times, passing parameters, could someone show me examples and how to pass parameters in attributes in FME? thanks

Like the title says I want to take the csv file and store it in one of my resource folders but nothing ever gets written because the CSV contents show up as the body not the attachment.

I'm trying to use Automations to process two different workspaces at different times using related data. Specifically, the first workspace should begin at 9 pm, process a number of input files, and write enriched data to a different set of files in a shared folder. The second workspace should begin at midnight, and process the files created by the first workspace. I'm using a writer set to "FME Automations" to create a list of files from the first workspace that can be processed by the second workspace within the same Automation. That part works fine, but I don't want the second workspace to start before midnight. Should I be able to accomplish this within a single Automation?

Has anyone encountered a situation whereby a FeatureReader in one workspace tries to read an XLSX file that is (still open) in a FeatureWriter in a different workspace? What would be the expected behavior? Asking because I've set up an Automation with two (time) overlapping workspaces, in which the second workspace will attempt to read files created by the first workspace.

This might be a bit of a simple question but I'm looking for a way to run an FME Server Automation as a singular event, one time, similar to right-click > Run on a Windows Scheduled Task. I'm running the Automation once per week using a Schedule Trigger, but if that Automation fails, I want to be able to manually run it again without impacting the existing schedule. I could duplicate the Automation and set the Schedule as Run Immediately but that would mean changing the Schedule settings each time. Not the end of the world, but I feel like there should be an easy way to run it just one time. I was looking at FME Server's Scheduler as well but it doesn't appear that you can setup an Automation and Trigger it one time, it seems like single workspace only. I'm running FME Server 2019.1.3.1.Any thoughts?Thanks!

Need connected line attribute 'object id' in new created field of same shapefile attribute table. In Flow of direction with connected line feature attribute id in previous line feature - new created field.Check image snapshot and example excel snapshot for the same attached below for more better understanding.  Please provide help or problem solution for this situation.

I want to route data attached to an email from within an automation that is triggered by receiving an IMAP email. I’m willing and think I would find it preferable to simply dump the email watcher’s event JSON into a file in a directory and then use another automation to watch that directory for new email event JSON files and process from there. However, the FileCopy writer fails copying from the path parsed from the event JSON (FME Server has permissions to the folder.) Here’s the workflow:Take as input the email watcher’s event JSONParse the event JSON for the email attachment folderCopy the files in the email attachment folder to another folder.Eventually I will route attachments to different folders based on from address and subject, but I can’t get the copy to work right now. The copy fails, I think, because the FileCopy writer can’t understand the FME Server shared resource macro parameter $(FME_

MapFormatter custom transformer was created so that you can create a map at any size, scale and orientation. Map Sizes:A0, A1, A2, A3, A4, A5, A6, A7, A8, Junior Legal, Letter, Legal, Tabloid (Ledger), ANSI A, ANSI B, ANSI C, ANSI D and ANSI E. Map Orientation:Landscape and Portrait Manually entering other sizes could be an option in the future. I have uploaded the 'MapFormatter' transformer onto the FMEHUB for you to review and provide feedback. This has been tested and at this stage, I am confident that everything works as expected, however will do more quality testing. Below is an exam

Why do I get this error?     2021-9-14 16:52:33 | File Copy Writer: Feature contains an invalid source dataset '$(FME_SHAREDRESOURCE_DATA)EmailAttachments\\20210323145356-FME_Server_Email_Watcher-External_-_LOE_Field_Ticket-ad0dc73d-6839-4747-8e4a-e6160c913495'. No file operations will be performed for this feature.  The specified folder exists. I am unable to put a slash between $(FME_SHAREDRESOURCE_DATA) and EmailAttachments in the automation configuration best I can tell. I have tried using the StringReplacer in the called workspace to put a in a slash and that didn't work. I have attached the workbench, pic of automation, log files for automation and called workspace.

Hi All, am trying to work out how to build some logic into an automation on FME SERVER. Here is my workflow: Workspace reads Arcgis feature service every day. If it reads a record with "Attribute A' = "HIGH" (test filter) then email bob the workspace outputs (csv of "HIGH' Records) , if "AttributeA" = "LOW" email Mary the workspace outputs (csv of 'LOW' records). I'm unsure where I'm meant to build this logic. Is it in the workspace or automation? The automation action (run workspace) only has 'Action Succeeded' or 'Action Failed'. Am I meant to be passing a notification from the workspace to the automation??. I have read all I can find on this but must be missing something. Thanks Steve.

Can SQLExecutor be used to get around having to read in all the data from a database table into FME and then running a feature joiner?Consider the example below we need to read in the entire table of 2Million plus records to extract data we are interested in.What I think should be possible but I'm not sure how to implement it is to create a temp table and use that as a subselect or joined table to get the data using a SQL query

Im trying out the new Dynamic workspaces in automations. Running the workspaces works great! The problem i'm running into is as followed: The dynamic workspaces are writing out files to a folder. Depending on how often the dynamic workspace will run, several files can be created.Ones the workspaces are done, i want to start another workspace that takes all the files in that new output folder and send them by email. The workspace that sends these files out should only run once! But, since dynamic workspaces run several times both output ports will yield x amount of output features, triggering the last workspace multiple times. I thought of using a merge action but when you try to connect that to the output port of a dynamic workspace an error occurs: "Cannot connect content router ports to merge". (this also happens trying to connect it to the automation writer output port which has the attributes i need). Is t

I too ran into the issue raised by @jurgen​  in https://community.safe.com/s/question/0D54Q000084ATxeSAG/how-can-i-merge-an-automation-flow-when-using-dynamic-workspaces - that my workspace that uses an automation writer, can't be funnelled into a merge-action. In the response, @daraghatsafe​ said that an enhancement request is on the way - but I needed to solve the issue before then.  This connection isn't possible right now Problem: We need some way of knowing that all the workspaces had run successfully, before we'd run the final step. In my case, I didn&#

I'm trying to attach a file to the Email External Action in an Automation that always has a different filename (date/time) but is in the same location, and is the only file in the folder. I've added this folder as a resource and tried to use a * wildcard but it fails to send the email. If I give the exact filename, the email sends successfully with the attachment. Also, I can do this successfully using the Emailer transformer in a Workspace and feeding it the exact name via a Text File Reader, but I'd rather use the External Action in Automations if possible. Any thoughts?Thanks! 

Embarrassed to be asking this but in an FME Server Automation how do I get just the raw the "Content" from the trigger FME Server Topic Notified. We have the various keys but none of them seem to correspond directly to the Content of the notification. Please don't tell me Content has to be Json keys! 😅  In the workspace the FME Server Notifier has a Content parameter so