Automation

I'm working with FME 2020.2.4I know how to check from within a workspace whether it is run from FME Destkop o from FME Server. I just check in a scripted parameter if FME_SHAREDRESOURCE_[whatever] exists in fme.macroValues. But, is there any way to check whether a workspace is run from a Workspace App or from an automation?In the Jobs tab in FME Server there's a Source Type column with value Automations, Workspace Apps or empty to indicate it. I want to get that same information in the workspace to include it in an email sent from the shutdown python script. 

I have a scheduled workspace that needs to truncate an sde table. The table is shared as aservice in AGS and portal. I see a customtransformer to start/stop the arcgisserver.  But if i'm not mistaken this would not remove any locks that are on the sde table. do i need to put this into an automation in order to make all this happen? since i don't see any specific transformers to accomplish this. is it going to have to be through the rest api or python? does anyone have a workflow and or script to do this?I assume i would need to...stop the AGS service (to keep someone from connecting while the rather lengthy trunc/load is happening) then remove the locks (I think i have only heard of doing this through the rest api). run the fme wkspc and truncate then load the new data.restart the service. 

Hi All, I have a strange one i think! Its a simple workspace which takes a Spatial SQL table of property boundaries and reprojects it before writing to a mapinfo tab file. Running the workspace on workbench (same server) gives the correct results, running it on fme server produces a tab file which is from what i can see 99% correct, but muddled up in places. Confirmed Server workspace and Workbench are identicalDeleted server workspace and published from workbench again - same resultsServer job log doesn't give any indications to any issues - features written are sameRestarting server does nothing (Express installation)workbench & server are same version 2022 Heres the weird bit!, if i inspect the tab file after running the workspace on fme server it seems to have swapped the attributes of about 13 spatial features around and muddled them about. Screenshots might give a better ide

I have an FFS file with attributes that show inside the FME inspector but I am unable to expose them. Please see the capture for more details. Thank you so much for the help.

How do I configure a scheduled automation to run hourly between 5am and 6pm, every day? Currently I have it running hourly continuously but I would like to free up the Engines outside of business hours. Is this possible? Thanks

We have thousands of workbench that need a round of audit to check whether the workbench contains certain transformers. Is there a way to programmatically check this without having to open the workbench themselves?

I was troubleshooting an FME Automation using CronTAB. 1) I adjusted the Schedule using CronTAB and an error message appearedPS: The message in black background covered the error message 2) Click on the "X" to close the error message and the following appeared3) I tried to rectify the error and started the Automation. Got this Screenshot shown in Step 2 is the bug.FME Server made me believe that the Automation stopped however it was still running in the background.  

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

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 FM

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 wh

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

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