Automation

I have a FME 2022 Script that run against an Oracle Database and extract list of boundaries and output on to a FGDB. I would like to let User to run the script using a bat file, rather than intervene with the Script on FME workbench. I have a list of boundary IDs on an Excel that attached to the script then User can extract boundaries on the excel sheet. But I would like User to extract any boundaries begins with boundary ID ie: "AA-X-BB" I would like some help to understand how to write the script that the bat file extract all the boundaries begins with my ID rather than a single boundary.Any help would be appreciated. thanksPushpa

I've recently developed a Workspace App using FME Flow where users can enter search criteria, and the backend workbench processes this input to return an HTML results page with a list of database query results. I now need to implement a printing feature that allows users to print a selected row from the results table. Here's my current setup:I've added a print button to each row of the results table.When a user clicks this button, it triggers a webhook URL intended to initiate an FME Flow automation. This automation isn't yet configured but will be responsible for creating a printable document. My initial idea, which I'm open to feedback on, is as follows:Capture the data from the selected row and pass it to the webhook URL.Use the necessary workbench logic in the automation to generate a Word/PDF document with the chosen information.Allow the document to either be downloaded dir

I created a workspace that takes a zip file (nested zip), unzips it to a temporary folder (I used StartUp Python Script to do so). It then reads all the unzipped SHP files from the temporary folder (uses dynamic ESRI Shapefile Reader), reprojects all the files, filters them by feature type (to points, lines, polygons), checks for duplicate features and if the geometry is valid. Finally, it saves 3 output shapefiles:1. all point elements consolidate into one output shapefile2. all linear elements consolidate to one output shapefile 3. all polygon elements consolidate into one output shapefile  I would like the workspace to be independent of the input dataset (attributes). Because now when I run workspace with a second set of zipped shapefiles (with different attributes), I get shapefiles in the output with empty attributes that are in the first set of data. For example first dataset (which was used to create workspace) has ‘A’, ‘B’, ‘C’ attri

Hi,Is it possible to download Automation workflow/save it to a file, so that it can be easily transferred to another FME Server/Flow?

I thought it would be as simple as Trigger (FME Flow System Event) -> Action (Log) ->External Action (Http Request that includes the information for the system event via the log ).

We're in the early stages of proposing external access to FME Server 2021.2 via a reverse proxy. I was wondering if it is possible to duplicate a service so that it can essentially run on multiple URLs since not all users will have access to the remote proxy (IT processes outside my control). I can see there is the possibility to create a new service but I'm unable to configure as required.Not sure if i'm overthinking this or missing something simple but any assistance would be greatly appreciated. Thanks

Hi everyone, I have a workspace/server app which has a Data Download service published. It produces a downloadable zip file of the writer results. We a user clicks ok to run the server app and the status is completed, the data download url is shown. I have an Automation however which receives a topic and this triggers another workspace to send an email with the job details (rest api).Is there a way to hide the above data download link URL and still create the url behind the scenes>

how to continue this workbench as no data have passed to next stage how can i redirect the data to final data if no data is passed in this step?

I have setup a FME Server Webhook trigger in the automations section and want to put the payload received into a database table by running a workspace after the action is triggered. Please help or advise if this is not the correct way? Thank you #Automation​ #Webhook

I have a workspace that includes two Emailers that send emails based on what file is added to a folder. If a zero byte file is added to Folder A then an email will be sent; if a file that is more than zero bytes is added to Folder A then an email will be sent. It runs good in FME Form, it send two emails one notifying the recipient of a zero byte file added to Folder A and one email notifying the recipient of a non-zero byte file added to Folder A. But, after I publish this workspace to FME Flow, and create an Automation with the Directory Watch Trigger (triggered only when CREATE .... new file is added to the folder) that kicks off the workspace, it sends me 8 emails. Is this a bug with using the Emailer Transformer? I notice that in FME Flow I cannot view the Emailer parameters as I can with other Transformers.  Any ideas on how I can get this Automation to send me only two emails? ​

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!

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! 

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 

 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: 

@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?

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?

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 w

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

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  

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.'

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.

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.

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

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?

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.