Automation

I have a workbench intended to run daily on FME Server. It does the usual data transformation stuff and then it email reports to a member of staff once per week. The report contains information relating to contractor performance over a 30 day period. I only want to send out a report if there's in new activity in the past 30 days. Currently, I have 9 x reports (one for each contractor). The reports are updated daily. I want the Emailer transformer to email only those reports containing new activity. I have gotten as far as calculating which reports are valid (i.e. within 30days) and using an Attribute Creator to fanout a new attribute, being the path & filename of the report. The Emailer then reads the fanout parameter as the Source File, picks it up and sends it. The problem is, the Emailer is sending each attachment in individual emails. I want the transformer to recognise which reports are valid and then send them together in a single email. The image I have attached shows 5

I'm having some issues with our FME Server which I don't understand. Every now and then, when running a nightly scheduled job, a FeatureReader fails to read a CSV file. The log returns:Trying to find a DYNAMIC plugin for reader named `CSV2'Library 'D:\Program Files\FMEServer\Server\fme\plugins/CSV2.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this libraryModule 'CSV2' is unavailable for use with this FME editionWhen I resubmit the job, everything works fine... which is great for the data being processed, but harder to debug. The issue feels somewhat familiar and I did find similar questions but not related to CSV2.dll.I'm quite sure this is not related to desktop/server versions. Version is 2019.1.2.As far as I am aware nothing has changed in the installation, I do know the certificates were replaced recently but I doubt this has anything to do with it. Not sure where I should start looking, can anyone point me in the right direction? Update: 

Hi all.Has anyone attempted this ?I'm exploring the possibility, and although it ought to be possible, it fails to validate.One this puzzles me though: All configuration examples I've googled, mentions both an EMAIL ADDRESS and a USERNAME, which is also an email. And they're different when accessing a shared mailbox.But the automation trigger only has one "IMAP Email Account" setting.Is the IMAP trigger missing a setting ?Cheers.

I am trying to set up an automated fme workbench to run once a day. I ran the Workbench in FME Server and it ran just fine without error. All this workbench does is run a SQL Creator that sends the data to an excel writer (one for each type of permit) and then it saves the files into a folder on FME Server. That is all it does. The version is FME Server 2022.2.1.

Hi everyone, I'm trying to convert a PDF file containing geographic data into a shapefile format using FME. There is a lot of work that has been going on in the recent past on this, and even I had tried a few online tools, QGIS plugins and now playing around with FME using a few transformers.Actually, my spatial pdf file has the transmission lines network that includes transmission lines, substations and the geographic region with text information provided that represents the points and lines on the file with a descriptive legend.Since I couldn't efficiently work with that file as it is 15Mb and has around 800k entities, I am working on a sample pdf.Can someone guide me through about what concept can be applied to perform this?Thank you.Attached:wallawalla.pdf: sample fileERCOT: Practical file

Hello. Using FME Server 2022. I have an issue monitoring our FTP. I want to monitor all subdirectories for changes. I keep getting an error where "/." is being appended to the "Path to Watch Directory" an infinite number of times. I get thousands of errors from the automation. Here is the error message:When I check into our ftp client logs, here is an example of the file path that FME Server creates: /upload/Directory/./././././././././././././. Why doesn't the trigger just detect and stop at the directories that exist?     

Using my basic FME skills, I've been able to automate the download of the OS Mastermap Topographic Area, Line and Point but am struggling over how to maintain the changehistory feature collection type which FME wants to insert a single value. Being a common task amongst many GIS users, I would hope there are some models out there....?

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 ActiveMQ, NodeJS and others and wanted to know if anyone has a working solution in AWS to share or can point me in the right direction?

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 fine. it only fails in FME even if I try to insert only

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 : (Automations) Logging events for component...6 2023-01-09T19:32:45Z | 410105 : (Automations) Creating project "test"...7 2023-01-09T19:32:45Z | 410116 : (Automations) Finished assembling automation "test"8 2023-01-09T19:32:48Z | 410160 : (Automations) Automation successfully triggered9 2023-01-09T19:3

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?