Automation

Basically, I have a workbench that produces a CSV that I want to use in other workbenches and get a result. But There doesn't seem to be a trigger that works for me in this idea. Here is how the automation would look: How can I trigger an automation from the result of the first workbench?How can I transfer the resulting dataset into the automation after the trigger? Thank you,Kevin

Hello,I am using rest api url = f'{SERVER_URL}/fmerest/v3/transformations/transact/{REPOSITORY}/{WORKSPACE}?longPoll=true' but does not get back resultDatasetDownloadUrl in result class. What went wrong? Regards Gerhard

Hi there, I'm having some trouble getting an email trigger to work inside an Automation, which is accessing a Shared Mailbox.  I am able to authenticate using my email address/password combination via the same IMAP server details, so can rule out the connection between FME Server and the mail server. When accessing a shared mailbox, what are the correct credentials to use in an IMAP trigger?  Typically that mailbox will be shared to users, and not have it's own dedicated password. That makes me think that one of the FME Server System Services is the account which is authenticating with the mailbox, and to use the email account with no password populated inside of the trigger. Is this the case? And which system service would be authenticating with the mailbox? When following this action, I get an error saying 'Invalid Credentials'. Am I right in thinking that one of the system services is acting as the authenticated user to the shared mailbox? Any help would be much appr

Does anyone has a good example for this script? I copied the script from here and filled out some of the parameters. Not a coder. Hope someone can help me out https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Workbench/Startup_and_Shutdown_Python_Scripts.htm import smtplibfrom email.MIMEMultipart import MIMEMultipartfrom email.MIMEBase import MIMEBasefrom email.MIMEText import MIMETextfrom email.Utils import COMMASPACE, formatdatefrom email import Encodersimport osimport fme# FME variables.status = fme.statuserrorMsg = fme.failureMessagelogFile = fme.logFileName # E-mail message values.subject = "FME Translation FAILURE"to = "receiver@domain.com"sender = "Your FME script <sender@domain.com>"text = "FME translation failed with error message: " + errorMsg + "\r\n\r\nSee attached logfile for details." # Credentials.AUTHREQUIRED = 0username = "smtp.user@domain.com"password = "smtppassword"smtpServer = "smtp.server.com" # Create and return a message with a logfile a

Hello,I'm trying to rebuild FME server automatically. I take back up of the server (.fsconfig file) and use this when ever I try to recreate the server automatically using python script. But, I found that the fsconfig does not store the number dynamic engines which were configured previously. So, whenever I recreate server the dynamic engine has default value 0. Is there any way to change this number automatically without manually changing this figure ? Thanks

Hi altruist, I am looking for an solution.I have a road name list in three different feature type (two in shape files, one in excel). I have brought them together after editing schema to get a unique list of names. Now I want an automated way to validate a new name whether this is a new name or existing in the list. Can anyone kindly tell the ways of working around? Thanks in advance.  attached image: my workspace so far

I have survey records being written to a database using a work bench. Along the way there is a transformer that checks for null values, if they exist currently the records are wrote to a .csv file to be checked. I would like to send an email to the surveyor so they can edit and resend their records for writing to the database. Currently I have a HTML Report Generator set up for a table of records that have null values. I had tried to use the Attribute File Writer to isolate the surveyor name and then use the html content in the email body. This doesn't seem to work and was hoping someone has a workflow. Basically the Emailer 'To' is conditional based on the survey record submitted and then I would like the email to contain the survey record with null value. Thanks in advance!,Kathy

We have a large number of JPG images that cover the same area (flown with a drone in a criss-cross pattern). We need to split the set of images into smaller, workable groups. The idea is to, if possible, create an area of 2 rows by 2 columns that cover the same area where the images were taken. If an image falls within one of the four quadrants, it should be moved to a specific folder that representsthat quadrant. That way we can correctly subdivide the set of images into four, more manageable blocks. The 2DGridAccumulator seems to be able to setup a grid, but is there now a way to compare each image to each cell of such a generated grid and then move that image to a folder as explained above? As the drone flew in a criss-cross pattern, the date modified for each file cannot be used to determine in what block it should be placed (ie by just using Windows File Explorer to categorise the images). Apologies if there is a straight forward solution for this which I could not find.

Is it possible to use multiple CRON triggers in the same Automation, also while "passing" values from one workspace block to another using values from an embedded Automations writer? Essentially I would like to set up a single Automation that triggers at a given time, completes a number of steps, and then "waits" for a second CRON trigger to continue with additional steps, and with the additional steps part of the routine using a value from an upstream block.

I have a workbench that is reading in FFS files as source. The files are located at a network location that required permissions from IT under our logins to access, \\\\serverloc\\folder\\source.ffs. Everything works as expected from Desktop. The issue is when we upload the workbench to FME Server. The error is Invalid Dataset '\\\\serverloc\\folder\\source.ffs'. Dataset must exist prior to reading. We have spoken with the admin of FME Server, who said they added a service account that is used for the FME Services to access that network location. We are getting the same error. What steps need to be taken to allow FME Server access to read from this location?

@david_r​ @Hans van der Maarel​ @safesoftware safesoftware​ 

I have created workspace apps and then used them to create my gallery app. If I then update the original workspace and re-publish it, do I need to recreate both the workspace apps and then the gallery app to get the updated workspace?

Hi, I'm trying to use the output of an Automations Writer (workspace 0) as input for the next workspace (1). For the two 'Text' User Parameters, I can use the drop down menu and choose the 'SFTP_Username' Attribute of the Automations Writer as the input for the next Workspace. However, for the 'Password' User Parameter, the is no drop down menu to choose the 'SFTP_Password' Attribute of the Automations Writer. I have tried inserting it as '{route.ConnectionParameters.SFTP_Password}' and this did not work. Any suggestions would be highly appreciated! Regards

Hello, I'm trying to set up an automation that runs a workbench that has one parameter that needs to be passed through. I am running this automation from a manual trigger. I have configured a post request that can hit the trigger successfully, however, I am having trouble getting the param value from the request into my automated workbench. I have read all of the documentation and articles on keys that I could find, but as far as I can tell it's not really clear how these values are passed through.  I am currently trying to trigger through the server web UI. My manual trigger has a manual key named 'input_id', and I have mapped this to the workbench parmas on the tick branch, that shows 'manual.input_id'. However, when I trigger the workbench with valid JSON containing as below, it does run the workbench, but fails as the param is passed in as '{manual.input_id'} rather than feeding my JSON attribute value in.  {"input_id":"1234567890&quot

Hi There, I have a workbench that sends an email 24 hours after a certain event occurs. However, the email gets sent everytime the workbench runs and I do not want to spam people, so I only want to send ONE email every 24 hours --but I want to be able to run the workbench often (to check for new events and send out email reminders after 24 hours to those people). --How can I check to see if an email has ALREADY been sent out? That way I only send them ONE email per time period (24 hours in this case) even if the workbench runs many times per day? THANKS FOR ANY HELP HERE! Lewis

@safesoftware safesoftware​ @keziaatsafe​ 

We updated our test server to 2022, from 2021, yesterday. Since then i have been unable to save an automation with a action to run a workspace.I noted that an automation I had set up had lost its directory watch path after the update. I added the path a tried a saving but it seems to get stuck and just sits there with the spinning wheel going round. I left it last night when I left work and it was still spinning the wheel when I logged in this morning.I have tried recreating the automation and had no trouble saving until I tried to an action to run a workspace.I have tried republishing the work space, and using a different work spaceThe automation will save with just the directory watch trigger and a series of filter actions, but fails when I try to add a Run workspace action.So I'm stumped

I have an FME workspace on FME Server 2021 that writes a dwg file. The workspace has multiple parameters including 2 that are mandatory: FILENAME and EMAIL.  We want to send an email on success or failure and I have set this up via an automation. This automation will be triggered via the rest api. In the automation 2 of the parameters are passed from the trigger via 2 manual keys. When I manually trigger the automation with a json file and only supply one mandatory parameter (EMAIL) the workspace still continues assigning the output filename to be automation key manual.FILENAME. If run manually via Run workspace it fails. What is the best way to handle this? Should I just test that the parameters are valid via the workspace? Or is there anyway to test if the parameters have been supplied via the automation. Thanks, Annette    

Though both the schemamapper and a pythoncaller can accomplish to create, map and 'remove' attributes, the newly mapped attributes are hidden and the removed attributes are still exposed (with only missing values). When I write this to excel I get empty columns but the columns are still created. I don't want to use the hide attributes option in the pythoncaller; I want the attributes to be written and not written to be dependent on a list I read from another file.

We've recently upgraded to FMEServer 2019.1 and are attempting to use the FTP Modified automation step to watch a data suppliers server so that our workbench runs when they drop data.Now I know there are differences between FTPES/FTPS and SFTP (which our supplier uses). Should I be able to use the FPT Modified automation to directory watch their server if we normally connect over SFTP? I am currently unable to connect and getting failures for "SSL error occurred. Verify port number and security type are correct."I know the port and host IP's are correct, as are the username and password. Is it as simple as our supplier allowing FTPS/FTPES encryption or is there another potential issue?

I am trying to start a scheduled automation to run a refresh script daily, but it is just not working in FME. Trying to run:REFRESH MATERIALIZED VIEW CONCURRENTLY gis.map_filters_mvw WITH DATA; Thank you,Kevin

Hello. I have a workspace that runs locally, which takes two user inputs (stored as user parameters) - a start date (the first date of the PREVIOUS month) and end date (last date of the previous month). When the workspace is run it asks for each date from the user, and they would provide them as '01/03/2022', for example. The dates are then fed into an SQLExecutor and used to help query our database. The workspace is run each month.  I would like to run this process automatically on FME server, but to do this obviously a user can't manually specify dates. I therefore need a way for the bench to generate the start and end dates of the previous calendar month. The bench would always be run on or after the first day of the CURRENT month, but not always on the same day (so I can't just use today's date minus a day, for example). I'd prefer to do this in FME, but if it has to be done in the SQLExecutor query that would be fine as well.  Thanks in advance.Liam Riddy

I have a working Automation that is triggered by either a Schedule block or a Webhook block. It includes a number of "run workspace" actions in series, the first of which currently includes user parameters with values that are fixed in the Automation, one of which is a datetime parameter. I would like to pass a datetime value in the body of the webhook POST, but it appears the first workspace block does not show the "Use a value from upstream keys" for the datetime user parameter, presumably because it is not an ordinary string. Is there a way to accomplish this without changing the user parameter in the workspace to an ordinary string?

I have a directory watch on a network folder and I can successfully trigger the subscription by adding a file to that folder. I can see that the workspace is triggered as well. However, what I'm still trying to figure out is how to pass the path and file name of the zip file placed in it to the workspace. What would the input parameter need to be set as in the workspace? Currently I have it set to a published user parameter with no default value. In the subscription configuration, the "Source Zip File" parameter is set to "Get Value from Topic Message". However, that parameter evaluations to the path of the JSON file created with the topic is published to, not the zip file path. From the log:FME Configuration: Command line arguments are `fme' `Test\\LaTaxTableImportForDirectoryWatcherWBR\\LaTaxTableImportForDirectoryWatcherWBR.fmw' `--SourceZip' `$(FME_SHAREDRESOURCE_SYSTEM)temp/subscriptions/c2177f37ebd94805bd9717d51d228e46.json' `--FME_TOP

I am trying to setup a workspace automation but when i point it to the workspace i want to run it says there are "No Parameters Available" for me to establish. However, when i navigate to the Workspace itself (outside of an automation) I see all of the parameters. I recently upgraded to FME Server 2021.2 and am using Workbench 2021.2 as well. It is an existing Workspace that was authored in a previous release. I opened it in 2021.2 and published it. I copied the contents into an entirely new workspace and published that with the same issue. I authored a simple workspace (XLS->FFS) and the Parameters showed up as expected so I think it may be something to do with the Workspace. It is rather large and I dont want to have to redo the entire thing. Any help would be much appreciated.