Automation

I have succesfully set up a PostgreSQL trigger and PL/Python function to POST some JSON to a webhook using our on-prem PostgreSQL database and FME Server. It works well following the instructions here and here. However, our PostgreSQL database is moving to AWS RDS and PL/Python3u and PL/Perlu are not allowed as untrusted languages and the trusted versions won't allow the GET/PUT/POST operations. I have seen mention of using Act

Currently, I have 15 workbenches in one FME Server Automation.  I have it set up to filter through the respective workbenches to find the correct workbench to run, but now I'm struggling with figuring out how to run the second workbench once the first one is run successfully to completion.  Through testing purposes, I noticed that my automation would select the correct workbench and then immediately run the second one despite the first one not being completed. It'll run the second workbench after triggering the first one to run. SO, it isn't necessarily waiting for the first one to complete successfully.  Is there anything I could add to my FME Server Automation to pause my second workbench until my first one is finished successfully?   

I have a Python script that executes a set of tools in QGIS. I would like to execute this Python script through FME.In FME Desktop, is it possible to run a python script that is stored on disk, and not within the Python caller?

The proxy documentation states that proxies are not support for automations. How do I set up my automation and/or proxy to use the FTP Diectory trigger when a proxy is in place?Curently when I add the FTP details to the FTP Directory Trigger and try to validate the connection i get the following error:  Invalid - Connection attempt timed out. Verify that the port number and security type are correct. I have tried all the combinations of secutiy settings available and get the same error each time. 

I was able to insert 847k records out of 1.6M last Friday then it just failed (token was refreshed). This morning, I've disabled / re -enabled versioning in ArcPro and was able to insert 600+ new records using FME. Tried another 600+ and failed with the below error. ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: 'Unable to complete operation.'. Details: 'Insufficient permissions [42000:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The EXECUTE permission was denied on the object 'i24_get_ids', database 'CORPGIS', schema 'gisadmin'.] [Prod_Address]'ARCGISPORTALFEATURES writer: A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details P.S. I have tried adding new records using ArcPro thru the same feature service and works fin

Hello. I would like a workspace app to send an email containing a download link for the data package that this same workspace app has created by running, just like the workspace that workspace app is built on does. I have gone through the forum and I realize that there are many answers on this issue as it has been brought up before, such as emailer in workspace, httpCaller, automation, FME automationWriter, email address as a published parameter....  But I kind of need it hand fed to me, how do I do this for dummies, steps from A to Å? My workspace has no emailer in it or anything at this point, it just reads in data and clips it and writes out the result. Published to the Server as Data Download service and works 100% when run as workspace, sends the email and all. Nota bene Server is 2021.2.6 So any help would be greatly appreciated.

We need to check an email account for new emails at an exact time of the day and the poll interval of the email trigger isn't helping us.We have to configure a 5 minutes interval to get close to the time we want. So why check an email account every 5 minutes when you only need to check it twice a day (7 am and 7 pm)? We have tried different poll intervals but the polling behaviour is always the same: it adds a few extra minutes to the interval and the number of minutes added change every time.  Is there an alternative to using the email trigger to check for new emails that let us fix a time it should be checked?

Hello! So my company has traditionally relied on Topics, Subscriptions, and Notifications (which I'll call the 'old way' for short) to send an email when a job fails on the server. It is now wanting to move into Automations, as the perception is that they fully replace the functionality of the old way (and that the old way will be deprecated at some point). I'm looking at the available Trigger protocols and see that, at a glance, the only relevant one appears to be "FME Server Topic Notified". Is this correct? Because if so, it would seem that our perception that Automations fully replace the old functionality isn't accurate, as we'd still have to rely on some of it to trigger the new one in the first place. Can anyone confirm if this indeed the case? Will there be a way to do this through Automations alone eventually?

I have an automation that starts with a JMS Message that reads ActiveMQ. I have a workspace that processes JSONs from ActiveMQ. How do I configure the automation to pass the JSON message from ActiveMQ to the workspace so that the workspace will use the JSON as the input to process?

Hello everyone,I'm hoping to get some guidance on how to use live wind data with base imagery. I'm trying to create a map that shows real-time wind direction and speed, but I'm having trouble finding a reliable source of live wind data and a method to display it on my map.Do any of you have experience with this? I would appreciate any tips or suggestions you may have, such as the best sources of live wind data, how to pre-process the data, how to visualize it on a base imagery, and how to make it user-friendly and easily understandable.I tried using API call from windy.com, but not much success there.Thank you in advance for your help! I'm looking forward to hearing from you.

Hi,I have this list of substations that has the city, state, zip, county, lat/lon information present already, and I want the name of the substation plotted in the name field. Is there a possibility to do this using ChatGPT?Spatial Regards.

Hello,I wrote an ETL where read an microsoft azure sql database spatial (JDBC) table using the feature writer. However, I can't update because when writing the selected format is grey.  How to fix this issue? ThanksARmel

Hello, from an aerial view, is there a solution to extract or identify the geometry of roofs, roads or any other shape.

Dear community, I found this video (https://www.youtube.com/watch?v=-dbRKOj-1zw) and this forum (https://community.safe.com/s/question/0D54Q000080h9MY/drafting-of-gmails-automatically) about the possibility to create Gmail drafts. However, I am not sure if this is still possible? Please let me know how I could achieve this.Thank you!

Is it possible to extract the following information about a workbench being run through an automation (all automations will be triggered by schedule): Workbench NameAll READER dataset namesscheduled run time & periodAll WRITER dataset type, and output filename/location I am interested in writing a workbench which will use an HTTPCaller to read all automations tagged with a specific tag, and then take each of those automations and extract those specific attributes above into a csv. 

I have been trying to get wehook trigger output keys to work, but haven't had any luck. I have an automation with  a webhook trigger, and an output key configured:The JSON I am posting to the webhook is:{    "email":"user@example.com",    "data":"this is a test"}The Log action is set to log:{webhook.email}{message}The automation log is as follows:1 2023-01-09T19:32:45Z | 410115 : (Automations) Assembling automation "test"...2 2023-01-09T19:32:45Z | 410156 : (Automations) Creating webhook trigger...3 2023-01-09T19:32:45Z | 410109 : (Automations) Creating link from trigger...4 2023-01-09T19:32:45Z | 410136 : (Automations) Updating event keys for component...5 2023-01-09T19:32:45Z | 410150 : (Automati

When running FME Desktop and set the Scripting to Esri Python 3.6+ or other Esri Python version and adding an PythonCaller or PythonCreator the workbench fails and gives an error. This bug seems to be related with Windows removing all Icons form the Start Menu. Reinstalling ArcGIS Pro seems to fix the problem.    

I need to merge individual 1km2 LIDAR tiles in .asc format to form a single layer. I have a table (.xlsx) which lists the .asc files, their folder location and the site reference they are associated to. I have read the table into FME and using a FeatureReader and can open all the .asc files and by using the RasterMosaicker, and Reprojector I can combine the the .asc files and output the merged LiDAR.  This works fine for a single site. Of course when I add further sites to the table I end up with all the LiDAR merged into a single feature. How can I set up FME to iterate through the table merging the necessary tiles and produce a single LiDAR output before repeating the process for the remaining sites?  

We've been using automations to run jobs, and then report the status back to Teams using an HTTP Request to call a Teams webhook. This was working fine in 2021.1, but since upgrading to 2022.2 the teams message now shows the job variable names, and not the values. The issue seems to occur somewhere within the Adaptive Card format - as I can use a very simple JSON object in the HTTP body of the HTTP Caller (eg. { "text": "{job.id}" } )- but it seems as soon as the variable call is enclosed in square brackets - it won't populate the value. Am I making some silly reference mistake?(Attached HTTP Caller body.)

As the title implies, I have a workspace where two different workflows have to write to the same CSV but different sheets. How do I go about doing that? I've attempted to use fme_feature_type as CSV File Name but that resulted into 2 separate CSV files as depicted by the image attached  

I create an FME workspace with ArcGis Online. I have a new project so I made a copy of FME Workspace and I want to change Feature Services to use a new project. How do I redirect or change Feature Service to new project?

Issue: During the Christmas break, one of our automations failed regularly due to an account issue. I did not get any notifications and only upon my return and a manual review did I see this issue. Question#1 : What is the correct method for tracking automation failures. Can the system send email notifications with the associated error message. If so, how do I do this ( note: my knowledge in the product are still basic ) Question#2 : We are scanning workspace logs from the logs folder , but where are the automation logs ? Many thanks in advance for any assistanceOliver @ EGW 

I want to build an app that will prompt the user to select a file.the file is on our network. I have set a resource for the root folder and set this resource as a parameter in my workbench. (It would be nice if the user could not change this) The first required prompt (parameter will allow the user to select 1 subfolder of the resource folder. Then i have specific values for 2 other subfolders that will be supplied and added to the root and the first selection. The second prompt will be a single file in the now complete folder structure. This folder will then be supplied to the output where the file will be written with the same name + datestamp.I have what i think are the parameters built in my workbench but don't get the path built correctly.I am trying to buld the path like this.$(FME_SHAREDRESOURCE_DATA)$(SELECT_PROJECT_ROOT_FOLDER)\\PROJECT_DATA\\WORKING\\$(SELECT_PROJECT_FILE)any ideas on how to accomplish this?

I am using shapefiles to create multple attributes for dwg OD table output.I have a dwg that does not have a feature for this output. (I am writing this to use in fme server). I use a tester to divert the shapefile feature out of the output stream. but the feature gets created in the dwg regardless.I tried putting a NoFeatureTester to try to keep this from happening. HOW does this feature get through the tester?in the screenshot. the feature that is in the NoFeatureTester ends up in the dwg.

Hey Community, I am trying to map generators/power plants and substations for Texas(ERCOT) region in US. I have got one datasets from HIFLD and the other that I have already(my org). I have created a workbench that preps the data and compares the two data for generators. Also, there are a lot of substations that have got 'Unknown' names and is not possible to compare the two. Is there a possibility where I can run the workbench and it compares the two datasets with satellite imagery(Bing Aerial, OSM, Earth street) and provide a validation result.