- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Flow
Automation

Automation

Schedules, triggers, events, alerts, and notifications.

720 Posts
2,409 Replies

When you subscribe we will email you when there is a new topic in this category

720 Posts

Recently active

Most replies Most views Newest first

frank_herbert

asked in Automation

Emailer - how to send fanout outputs in a single email

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

1 year ago

nielsgerritsCelebrity

asked in Automation

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 library

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:

1 year ago

lifalin2016Contributor

asked in Automation

Using an Office 365 shared mailbox as an IMAP automation trigger ?

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.

1 year ago

pauldeq

asked in Automation

I am trying to automate a workspace on FME server, but i am getting a red dot with an exclamation point in it saying "Component needs configuration". What does this mean?

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.

1 year ago

parashari

asked in Automation

Spatial PDF to Shapefile/Geopackage

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

1 year ago

dsmylie

asked in Automation

Why is the FTP Directory Trigger not working when "Watch Subdirectories" set to "Yes"?

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?

1 year ago

dragons8mycat

asked in Automation

Hi, new to FME and trying to move from OSLoader to FME for the automation of the OS Mastermap products to PostGIS. Being a common task, are any premade models out there?

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

1 year ago

mixedbredie

asked in Automation

How can I POST to a webhook from AWS RDS PostgreSQL in order to trigger an 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 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?

1 year ago

mwight06

asked in Automation

Running second workbench after first is completed.

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?

1 year ago

binaryannamolly

asked in Automation

In FME Desktop, is it possible to run a python script that is stored on disk, and not within the Python caller?

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?

1 year ago

jackydContributor

asked in Automation

How to Use FTP Directory Automation Trigger when you have a proxy

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.

1 year ago

anthrax_79

asked in Automation

ArcGIS Feature Service

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

1 year ago

hlynurContributor

asked in Automation

Workspace app to send a email containing a link for downloading the result data (like a workspace does)

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.

1 year ago

dbannon22Contributor

asked in Automation

Long File Paths - Over 260 characters

After enabling long file paths in all the proper locations there are still long file path restrictions on the FileCopy writer. Am I missing something? I ended up using a PythonCaller to get around this restriction, but thought I would bring up the issue so it can be updated or fixed. Thanks

1 year ago

dms2Contributor

asked in Automation

Alternative to email trigger to check for emails at an exact time

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?

1 year ago

rinfante_coc

asked in Automation

How to trigger an Automation when a server job fails without using the Topic protocol?

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?

arthyContributor

Unable to write in microsoft azure sql database spatial (JDBC)?

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

1 year ago

aiko

asked in Automation

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

1 year ago

gmailautomation

asked in Automation

Is it still possible to automatically create Gmail drafts?

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!

1 year ago

jweParticipant

asked in Automation

Automation - workbench metadata extraction

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.

1 year ago

cnieman

asked in Automation

Automations webhook keys not working?

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

1 year ago

jkr_wrkInfluencer

asked in Automation

Python: No module named Platform

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.

1 year ago

Page 8 / 29

Badge winners

noggerhas earned the badge Student (Grey)
skjalghas earned the badge Webinar Watcher (Grey)
skjalghas earned the badge Norwegian Speaker
skjalghas earned the badge English Speaker
skjalghas earned the badge Student (Grey)

Show all badges

28,868: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.