Automation

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_SHAREDRESOURCE_DATA) in the path for the email attachment folder. I’ve attached a wor

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 example where the transformer was used to create a map with Aspect: MapMap Orientation: LandscapeMap Scale: 1:2000Map Size: A3WorkspaceLidar was used to create the AspectScaleBar custom transformer was used to create the scale barTransformers top left created the AspectTransformers top right created the text for the mapTransformers bottom left added the north arrow and the legend.Transformers botto

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 there any way to only trigger a workspace once after all the Dy

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't want to update the "I've imported all the data up to and including this date"-field, until all the imports were done.  Idea: What we need, is to build a state store, where we can keep track of the completed workspaces for one specific run of one specific automation. We could build this in f.ex. any database, but then we run into issues with having to create schemas/tables for each automation. Instead

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

Dear FME community,I have a question concerning the FME workbench. I have a pretty complex workspace where I need two different inputs, which have to be compared with each other. Both inputs require several hundred files. Now it is important that input a starts with file 1 (not with any other file) and input b also starts with the first file. Both inputs have to select one file after another in the correct order. The files are named after a certain scheme so that corresponding have the same naming parts. Manually I could just select the files, but since there are hundreds of processes, I would prefer a batch method. I tried a workspace runner, but this only can handle one input. Is there any process that can handle this? I would appreciate any hint concerning this matter.Thank you so much in advance.

Hi, I am using FME Server 2020. I have a workspace that is available in a server app. I would like to trigger an automation when that workspace is runned from the server app form. How can I achieve that? Thank you!

This is actually a 2 part question:Is there a way to get a more verbose log from automations that don't have a workspace?If I can view the logs from the menu on the automation page, aren't the logs stored in a file somewhere on the server? So I can retrieve them in a file format? Thanks!

Hey all, I'm playing around with fme server and the automations. I've got an interesting usecase. There is a SFTP that im wachting with fme server for creation events. I see as and output you get the filepath en filename. Now i want to grab that file within a workspace. I tried with the FTP caller. Is it possible to use the output keys to set up the URL in the ftp caller if so how so? Cheers

I have an automation setup in FME Server 2021.1 that polls an inbox and parses the pdf email attachment. I'm receiving a failure from the reader attempting to parse the pdf with a filename that contains a certain character –. It is reading the character as "??".  I tried to identify this online and it shows it as U+2013 : EN DASH. I can see this is a formatting issue, but what can I do to fix this if I have no control over the filename that will be sent to the inbox? FilenameInvoice #2071 - 5559 REDACTED TR D #1256 – Proration.pdf FME Server Error2021-7-22 09:20:33 | PDF2D reader: PDF Reader: Failed to open document 'C:\ProgramData\Safe Software\FME Server\resources\system\temp\emailattachments\20210720120551-REDACTED_Invoicing-REDACTED_-_Fixed_Bid-8d4ca970-18b5-4f8b-84b3-c10893d5e69e\Invoice #2071 - 5559 REDACTED TR D #1256 ?? Proration.pdf' because it does not exist or because the reader does not have permission to access the file 

Hi - Wondering if this is possible? Having a global rule that can send an email if a workbench fails as opposed to having to consider this each time within an automation. Thanks

We have upgraded from FME 2014 to 2020 and we want to take advantage of the new available features.The problem here is that I thought automations would make everything easier and could replace things like using shutdown python scripts to do whatever when the workspace fails or end as expected but I don't see automations can help us when our trigger would be just the execution of an FME Server app.Any ideas?

AllI have set up a scheduled task to be run via the windows task scheduler and NOT on FME Server. If I run the work bench everything is fine, as it is when i run the workbench via the .bat file. However, when I try to get Task Scheduler to run the .bat file it says it has completed, however checks show it has not. When looking at the log file i see these lines2021-07-19 13:28:29|   0.3|  0.0|INFORM|Opening the Esri Geodatabase reader2021-07-19 13:28:32|   1.3|  1.0|INFORM|The ArcObjects license 'Advanced' is being selected from the ESRILicenseInfo ArcObjects call2021-07-19 13:28:32|   1.3|  0.0|INFORM|The Esri Product license used by this machine does not include licenses for the 'Advanced' licensing level2021-07-19 13:28:32|   1.3|  0.0|ERROR |Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility setting. This 64-bit version of FME requires 64-bit Background Geoprocessing, ArcGIS Pro or ArcGIS Server. Refer to this this article http://fme.ly/qua fo

17/08/2020 12:09  10.9  0.8  ERROR   Python Exception <ModuleNotFoundError>: No module named 'fmepy_emailer'17/08/2020 12:09  10.9  0  FATAL   PythonFactory failed to load python symbol `fmepy_emailer.Emailer'17/08/2020 12:09  10.9  0  FATAL   Factory proxy not initialized17/08/2020 12:09  10.9  0  FATAL   Emailer_CALLER (PythonFactory): PythonFactory failed to process feature17/08/2020 12:09  10.9  0  ERROR   Emailer_CALLER (PythonFactory): A fatal error has occurred. Check the logfile above for details17/08/2020 12:09  10.9  0  ERROR   A fatal error has occurred. Check the logfile above for details17/08/2020 12:09  10.9  0  ERROR   StringReplacer (StringReplacerFactory): 17/08/2020 12:09  10.9  0  ERROR   A fatal error has occurred. Check the logfile above for details17/08/2020 12:09  10.9  0  FATAL   HTMLReportGenerator (PythonFactory): PythonFactory failed to close properly17/08/2020 12:09  10.9  0  ERROR   HTMLReportGenerator (PythonFactory): A fatal error has oc

Is there any way to send a single, aggregated email listing all failed workspaces if multiple workspaces in an FME Server Automation fail?For example, if I have 3 workspaces running in parallel and 2 of the 3 fail, I'd like a single email telling me which 2 failed.It looks like this might be possible with the new Split-Merge block in FME 2021 but, unfortunately, I'm on FME Server 2020.

I am wanting to trigger a very simple automation using a webhook. There is no need to pass any parameters - I just need the automation to run two workspaces. When I set up the webhook, copy the webhook url, and then start the automation, the webhook fails to run if I call it.  What puzzles me is that configuring a webhook using the automations (as opposed to creating a webhook for a specific workspace) doesn't add a token that I can manage under User Settings >> Manage Tokens. I found this token management to be essential to ensuring that the webhook had the correct permissions to run successfully. Please advise on what I am missing or doing incorrectly. Note that I am using FME Server 2020.0 (Win64) Thanks

I have sample data where dual carriageway road is present in one layer and in another layer I have point layer, I need to find out of point which falls inside dual carriageway road, as shown in image red circle. If point is outside the dual carriageway road then no issues but it should not be in 2 lines, sample data is attached.If anyone can help with workbench then it would be really nice and time saver for me, thanks in advance 😀 .