• EN

Automation

Schedules, triggers, events, alerts, and notifications.

  • 717 Posts
  • 2,399 Replies

717 Posts

dor1411993
Contributor
dor1411993Contributor
asked in Automation

Connect 'Emailer' to Gmail account (web confections does not recognize my Gmail account)

Hi all!I have some odd issue,I set up my Gmail web connection like describe in here, test it, and everything's is good.But when I want to use this connection in Emailer, it doesn't give the option to choose this Gmail web connection, and it ask me to set up new and regular one, which fails with Google error 401: disabled_client.Can anyone help me?how can I force 'emailer' to take the right Gmail connection?Thanks!

1
david_r
Influencer
6 months ago
M
michielzoer
asked in Automation

Add my own attributes to Webhook JSON-response?

Hi, I'm looking for a way to add my own key:value pairs/object to the Webhook JSON-response. The default webhook JSON response is:{"serviceResponse": {   "jobID": 294,   "statusInfo": {      "mode": "sync",      "status": "success"   }}}Woud like to add something like:{"serviceResponse": {   "jobID": 294,   "statusInfo": {      "mode": "sync",      "status": "success"   }   "productData" : {      "productVariant" : "type1" // = $(productVariant)   }}} Not sure if it is possible at all. All suggestions are welcome.Thanks! 

1
siennaatsafe
Contributor
6 months ago
vki
Contributor
vkiContributor
asked in Automation

Check attachements in Emails with more than one attachements

To get a file validated, users can send an email to the FME-Server with the file attached. In an automation we first check, whether theres an attachement at all and whether the extension of the file is correct. If so, a validation-workpace starts, If not, the user gets an email back.This works fine, as long as there's just one attachement. But we now have a user with a grafic-file in the email-signature. FME-Server counts that as attachement too and sends him a mail, that he has to send a file with the correct extension, even though the file is there...I would have to loop through the attachements, if there were more than one, but how can I do this?(We are using FME Server 2020.0.2.1) Thanks in advance!Vera 

4
K
6 months ago
badgerseatfrog1
Contributor
badgerseatfrog1Contributor
asked in Automation

webhook message content {message} keep reverting back to the string "Message Content" with no curly brackets. FME Flow Hosted 2023.1

 FME Flow Hosted 2023click into the input variable Text Editor and dbl click the Webhook/message Content and this is the result: Click OK then APPLYClick back into the Text Editor and it's reverted back to this. I can't get it to stick with it's curly brackets:So as you could imagine any actions in the workbench downstream from this complains it's not a valid jsonhelp!this is the parameter published from Flow in_json: loosely following this from 2019https://community.safe.com/s/article/Emailing-a-Survey123-Report-using-FME-Server

1
badgerseatfrog1
Contributor
6 months ago
A
arnoldatk
asked in Automation

Running a workspace from a bat file automatically with 1 click?

@echo offstart "" "C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\fmeworkbench.exe" "%~dp0ReadGdbFromFolder_AA.fmw" --runHi all, currently this bat file when clicked opens FME Workbench and the workspace dynamically based on where the bat file is located in and that's great, but is there a way I can also make workbench run my workspace once it loads up the workspace itself?

4
A
6 months ago
J
j85824
asked in Automation

Engine managment , is there any issue with a automation calling workbenches that cannot run on the same engine?

For example I have automation MyAutomation that runs two workbenches, WB1, WB2. WB1 can run on engines 1 - 5(determined by the folder it is in on the FME Server), WB2 can run on engines 3-5. Can an issue arise where WKB1 is running on engine 2 and completes by calling WKB2, that cant run on Engine 2?

1
hkingsbury
Celebrity
7 months ago
J
jkh
asked in Automation

Calculating moving average (3 rolling points) in FME.

Hello,I have a dataset with 1000 categories (A, B, ...) (please see the following sample). For each category I want to calculate 3 points moving averages. I developed the following workbench that using a Tester filter data for each category and then calculating the 3 points moving averages for one category (here port A). However, for each port of the Tester I should repeat all transformers again (transformer after the Tester), which is difficult for 1000 categories. I created a custom transformer but again I should import the custom transformer 1000 times. In the custom transformer I used a Counter which for each port should start counting from zero. But it is added up after that it is applied for each port. I set the Count Space of the Counter on local. But still didn't work. Can someone please let me know a better way to calculate this moving averages without those all repetitions of transformer. FYI, I am using FME 2022.

4
J
7 months ago
K
kateaew
asked in Automation

Removing workspaces from a repository after 30 days?

We have an 'Archived' repository on FME Flow. I was wondering if there was a way to create a workbench or an automation to, for example, delete a workspace after it has been sat in Archived for 30 days. Thanks

2
K
7 months ago
scarter
Contributor
scarterContributor
asked in Automation

Cron expression - what wrong with this one?

Hi forum, I'm very new to FME Flow. I need to set up a schedule using cron expression for 07:00 Monday to Saturday, all year. I've entered... 0 7 * * 1-6 However FME Flow gives a message: "Invalid cron expression: 0 7 * * 1-6" I cant see what's wrong with it. Any thoughts? See attached image.Thanks,Stuart  

4
scarter
Contributor
7 months ago
nurbek
Contributor
nurbekContributor
asked in Automation

Hi Community, I have problems with automatation, i have a workbench which receives xlsx file in zip by email, i have published workbench to server, and start to receive below error:

Excel Reader: Failed to open the dataset 'E:\\apps\\FMEServer\\resources\\system\\temp\\subscriptions\\efbc8d67696c47d6b70bc0aa87c67166.json'. Error message was 'It is not a xlsx file. Use the xlCreateBook() for a xls file.'

7
nurbek
Contributor
7 months ago
L
lgrie
asked in Automation

How can I read attributes from a json stored using FME Server Automation writer ?

Hello, I store attributes of my workspace in an json array (JSON_FILE_PARAM) using the FME Server Automations Writer (myWriter).{"automation.id":"c48fb4a8-5757-4207-867c-6d0de3947b5e","email.subject":"mySubject","email.received":"Wed Sep 13 09:37:26 CEST 2023","email.body":"e-mail:myEmail@provider.com"} Now, in my automation, I'd like to use the attributes as user keys:{route.myWriter.JSON_FILE_PARAM.email.body}I do have access to those attributes stored OUTSIDE the list but not INSIDE. I'm using FME Flow version 2020.

0
L
7 months ago
zanzibarjack
Contributor
zanzibarjackContributor
asked in Automation

How can I trigger the start and stop of an automation/workspace through either e-mail or application?

How can I trigger the start and stop of an automation/workspace through either e-mail or application? I have a workspace that needs to run on 15 minute intervals after it has been triggered by user input (email or application). User then needs to tell it to stop running. Seems like trigger in an automation can either be incoming e-mail or schedule but I cannot start a schedule based on an incoming e-mail. Same applies to stopping said application Any ideas would be great.

1
david_r
Influencer
7 months ago
M
magda_cz
asked in Automation

Directory watcher to trig a single event for multiple las file

Hi,I created a workspace to process las files and receive raster and contours data set. The workspace supposed to be run with use of a directory watcher but it looks every las file is a trigger to run it again. Is there a way to have a single event with FME Server 2020.2? Thanks

2
M
8 months ago
T
thorian
asked in Automation

Automating WFS download is it possible?

Welcome,I need to download data from 300 wfs servers (list of it in any format) for 2000 objects (3 km buffer form point) like on a picture. Is it possible to add a list with server addresses to FME where it will check the spatial extent of the data from the server and then from the polygon range and download the data?

11
piotrek6116
Contributor
8 months ago
S
stevetaylor
asked in Automation

Has anyone else experienced an issue a FME automation failing to run when it is scheduled at exactly the same time as another job? We only have one FME Engine and are running FME Server 2022.2

If I change the time to be 1 minute after the other job it runs successfully.There is no log file as the job submitter just does not start. FME should place the 2nd job in queue I would have thought.

3
redgeographics
Influencer
8 months ago
jbradfor
Contributor
jbradforContributor
asked in Automation

FME WorkBench - Engine limit

We are hitting our 8 concurrent license limit with desktop. We use cmnd line and a PERL wrapper with our scheduling tool to run batch jobs. From what we read we are limited to 8 per engine, even if we were to buy additional concurrent Workbench licenses. So, that means FME server would be the only other option?Is it called FME flow now? Seems like a pretty big install. All we need is the server and the server cmnd line for a quick fix.

4
K
8 months ago
lifalin2016
Contributor
lifalin2016Contributor
asked in Automation

Automation actions being involuntarily "cleaned" ?

Hi.I have some automations running on 2022.2.2, and had to do a small edit on one of them. Afterwards the automation failed badly.I found that all the workspace actions in the automation had been "cleaned", i.e. set back to their default (workspace) setting of parameters. All of them. And I hadn't edited any of them, just moved some connections.No wonder the automation failed badly, as I'm e.g. using automation writer features to pass information between the actions. And have some global settings too for good measure.Has anyone experienced something similar ?What might have caused this ?Cheers.

12
keziaatsafe
Safer
8 months ago
fmelizard
Contributor
fmelizardContributor
asked in Automation

How do I read in event as JSON in Automations?

In FME Server Notifications I used a JSON Reader to digest the incoming Topic Message and get at the relevant information to pass downstream in my translation. However when I try and create an Automation using the process the workspace fails with a 'file does not exist' error. How can I use the trigger event as JSON to run a workspace in Automations?

11
baileyatsafe
Safer
8 months ago
klingdom
Contributor
klingdomContributor
asked in Automation

What is the POST setup for Corelogic?

We POST data to Corelogic in a Python script that works well for one offs, but we are trying to run 11K and think FME would be faster. The reason we POST is that the bundle we send is greater than a GET can handle (larger number of Lat, Long).We have tried setting up similar to our Py code with URL, json bundle in the Body, and Authorization Token in the Header but no joy see pic _A.  request_post = requests.post(parcel_url, json=parcel_request, headers=coreHead). We also have also setup with Query String ParametersAny help would be appreciated.Examples:URL: https://api-prod.corelogic.com/spatial-tile/parcelsJson: { "geometry" : "POLYGON ((-75.90819777899998 39.808981800000026,-75.90412056399998 39.808855236000056,-75.90812199699997 39.80857331300007,-75.90819777899998 39.808981800000026))", "pageNumber" : "1", "pageSize" : "50" }Auth: 'Bearer li7HyqUBbCaBKVBCYSB0VpLjsBfQ'

2
klingdom
Contributor
8 months ago
pushpa
Contributor
pushpaContributor
asked in Automation

Set NEW Output file name every time User runs the batch file.

I would like to User to rename the output FGDB name every time they run the FME script using the batch file.I have a FME 2022.2.4 workbench file that output Data on to a FGDB.FGDB has many feature classes, line points and polygon.I have created User Parameter called "NAMEFGDB" then linked with the "Writer". When I run the script using workbench or quick translator it prompt and I can change the FGDB name.However when I run using the batch file, even though I can type the new name for the FGDB, it still writes out to Default database name. My Batch file is as below.@echo ## Start translation ## set /p NAMEFGDB=type fgdb name:"C:\\Program Files\\FME\\FME2022-1-2\\fme.exe" D:\\GIS\\Data_extract_by_Area.fmw@echo ## End translation ##pause Is there anything else I need doing to connect the FME script to batch file?

12
pushpa
Contributor
8 months ago
S
solene01
asked in Automation

which command lines to automate fme?

Good morning, I’m trying to automate my fme with a bat file. It’s the first one and I don’t understand what’s blocking it. I attach my bat file if someone can help me tell if the command lines or not =) thank you 

6
tomfriedl
Contributor
8 months ago
ebygomm
Contributor
ebygommContributor
asked in Automation

Identify the User that will run workspaces within an automation

It appears that FME automations run workspaces as the last user to edit the automation, not the automation owner or the workspace owner.  Is there a way to identify the last user to edit an automation and where that differs from the automation owner? I can't see anything within the interface, or returned as automation information via the API (FME Server 2021)

10
kate-safe
Safer
8 months ago
P
pmugridge
asked in Automation

Modern Authentication with Emailer issues

I'm fairly new to FME and am trying to setup the emailer to use modern authentication as per the article: https://community.safe.com/s/article/How-to-use-Microsoft-Modern-Authentication-with-FME When configuring the web connection, I am successfully able to test the connection to the Azure App. However, when I actually try to email using the transformer, I am getting the following message: <class 'requests.exceptions.HTTPError'>: 404 Client Error: Not Found for url: https://graph.microsoft.com/v1.0/me/sendMail Any ideas? 

0
P
9 months ago
gisbradokla
Contributor
gisbradoklaContributor
asked in Automation

retrieve last used oid value and set counter to start with next number. Postgres 14/PostGIS oid

I am writing to postgres/postgis st_geometry in an autmation that is loading many dwg datasets. (runs workbench on each dwg)The postgis writer shows that ver 14 ignores writing od. I need to get an oid calculated beginning with the last oid used (in the previous automation) NOTE: postgis writer specifies that oid is ignored at postgres 14. I tried just using a counter and hoped that writing to existing would automatically write the oid. (I get an error the oid already exists).I am using this oid as the primary key so that It doesn't have to be set when adding to esri. I have attempted to read the flat postgres table and sample the last n and then use that as a parameter to set the start number of the counter. But have not been successful getting that to work.Any ideas on how to do this? 

1
virtualcitymatt
Influencer
9 months ago
S
stlj
asked in Automation

Accessing FME_TOPIC parameter inside automation

HiI'm working on a project where we are migrating from a solution based on subscriptions into more automations. I ran into problems when I try to pick up the topic name from fme server parameter FME_TOPIC. Inside a workspace triggered by a subscription all is fine, but when a use automation with a FME Server Topic Trigger, the value of FME_TOPIC is a GUID like string. First part of is the same as the automation id. I have no problem with FME_TOPIC_MESSAGE parameter. Any ideas? Thanks, Stefan  

6
jwarren
Participant
9 months ago

Badge winners

Show all badges
28,811
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.