- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Flow
Automation

Automation

Schedules, triggers, events, alerts, and notifications.

804 Posts
2,720 Replies

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

804 Posts

Recently active

Most replies Most views Newest first

sdepriestContributor

asked in Automation

Small change to workspace, republish to FME Server, affects Automation?

Do I need to refresh the "Run Workspace" action in an Automation on FME Server when I make an expression change in an Attribute Manager in the workspace? I've published the updated workspace to FME Server already. Will the Automation run the newest version of the workspace? Or do I need to make it "see" the change somehow?

392

3 years ago

drc43Contributor

asked in Automation

Processing one file at a time through the entire Automation?

I have built a simple Automation that is set up to read in email attachments, process them in workspace 1, and then move the attachment files to another folder location in workspace 2. The trigger is an IMAP trigger, which polls every 10 min. This means that sometimes, there are two or more emails waiting to be processed when the email is polled. When this happens I would like email 1 files to be processed through both workspace 1 and 2, before moving on to email 2, but I am having trouble setting this up. Currently, my job logs show:Workspace 1Workspace 1Workspace 2Workspace 2But I would like them to process in a different order so the job logs would look like this:Workspace 1Workspace 2Workspace 1Workspace 2I had a similar Automation set up and working this way in version 2018.1, but I haven't been able to replicate it in 2020.2. Did something change between these two versions? Or am I just missing something simple?

Can FME connect/read the database files of the 4D system? (extensions like: .4DD, .4DB)

104

3 years ago

wisegisContributor

asked in Automation

Is it possible to remove a field before it is read?

I have a time series data historian that I have established an ODBC connection to successfully. I can pull tables in and have filtered the data by time to reduce the records while I am testing. The table I am attempting to bring has a field called _index. I am not sure why they used a reserved word, much less started a column name with an underscore. It is causing FME to choke every time, understandably so. Is it possible to remove or have FME ignore that field and bring the rest of the data into workbench?

375

3 years ago

smolContributor

asked in Automation

Automation: Custom email attachment download patch results in dead symlinks

ProblemThe problems are caused by the underlying functionality of how FME Core downloads the email attachment and with the default FME Server Cleanup setup One of the functionalities that will be broken with this, is, for example, Backing up the FME Server. Resulting in a `COM.safe.fmeserver.configuration.migration.FMEConfigurationException: java.io.FileNotFoundException:` for the attachment. This is reproduced with the following steps:Create an Automation Trigger of an email (SMTP)Define a custom "Download Attachments To (optional)" path. Preferable something that is not covered by the default FME Cleanup, like`$(FME_SHAREDRESOURCE_DATA)/custom/mail/received/`Make sure this is triggered and the attachment is downloaded to the locationNotice that the FME Server seem to create symlinks in `$(FME_SHAREDRESOURCE_DATA)/custom/mail/received/` which are linking to the default mail attachment resource `$(FME_SHAREDRESOURCE_SYSTEM)temp/emailattachments`Wait for the default "Dele

Create FME Server action based on whether features exist on transformer output port

Hi all,I have an FME Server automation that runs a number of workspaces one at a time. In the first workspace I want to apply some kind of action depending on whether there are any features on a certain transformer output port. For example, I can place a NoFeaturesTester on this port, and:If it reports no features, I would like to inform the user in some way and continue with the remaining automationIf it reports that there are features, then I would like to send the user a list of these features (via email perhaps), and also look to pause or terminate the Automation.Can anyone advise a sensible way of doing this?Thanks,RB

3 years ago

aguanContributor

asked in Automation

How to pass parameters to a chain of workspaces in automation?

Assume I have an automation that starts with a directory watch to capture an updated zip file in a folder. The zip file name is passed as a parameter (File Path) to the 1st workspace. This workspace is followed by a second workspace, which needs to use the same zip file as a parameter. I can not figure out an easy way to feed the File Path (zip file path) to the second workspace as a parameter, other than writing it to a text file and let the 2nd workspace to read from the file. Any advice to make this easier and streamline? The FME server is 2020.1.3.

772

3 years ago

ninixinkContributor

asked in Automation

Is there any Pushbullet alternative option that can be used for iPhone?

Hi everyone, I have tried to set up push notifications to our phones and Pushbullet has done an amazing job for Android devices, easy to set up, and more importantly, it's FREE. For anyone who is interested, I've used this transformer from FME hub https://hub.safe.com/publishers/jrn/transformers/pushbullet. However, Pushbullet doesn't support iOs devices while all of our work phones are iPhones so now I am looking for an alternative option for Pushbullet that can be used for iPhone. Would be much appreciated if you could recommend any other alternative open-source option. Many thanks!

820

3 years ago

patlougheedContributor

asked in Automation

Is it possible to publish a workspace to FME Server from the command line?

Hi folks, I'm building a set of workspaces that are combining into a larger whole and will be running on FME Server. Given it's a number of different workspaces, I'd like to be able to publish to the Server from the command line - partly because I'm lazy, but mostly because I'd like to avoid getting versions out of sync between my local repository and what's on the Server. It appears (based on text output) that the publishing process from FME Workbench uses a process behind the scenes, but I can't find any documentation about how to publish from the command line. Is this possible? If so, is there any documentation or can someone provide the appropriate command line magic to make this happen? I know this could be accomplished with the API, as well, but I'm attempting to avoid writing anything new if I don't need to. Any help much appreciated, and thanks in advance! Pat

3 years ago

jgarciafdez111

asked in Automation

I’ve been using dropbox watch for automation and worked fairly well (fast trigger after modifying a file in dropbox folder). now, almost never recognize the modification, and if so, it takes more than 2 mins to start the event ☹. any thoughts? Thnks

3 years ago

cardiofaz

asked in Automation

Error when attempting to write to existing PostGres Table

Hi,I attempting to write to an existing table which contains polygons based in Postgres database. I have selected truncate existing table. I get following error:Error was 'ERROR: null value in column "objectid" violates not-null constraint The object ID seems to be an issue only when attempting remove existing data and add new data. When creating a new table, this is not a issue.

Hi all, I need to be able to automate a changing url so it can be automatically called and downloaded.

I am wanting to automate PDF's to be downloaded on a weekly or fortnightly basis. The url changes slightly each week/fortnight: 'https://www.admiralty.co.uk/WeeklyNMs/Year%20-%202021/05wknm21_week05_2021.pdf " for example the '05wknm21_week05_2021' would change to '06wknm21_week06_2021' and so on. There is usually only 1 or 2 numbers in the urls that will change each week going up by a factor of 1. Is there a way I can automate these changes? Note I had a different example here but that link had a redirect URL which solved the problem for that particular URL but unfortunately it was not the same for the link above. Thanks in advance for any help.

3 years ago

lucassaliba

asked in Automation

How to create polygons to fill a percentage of a previous polygon?

Hello everybody... I'm trying to find a way to delimit a preservation area within the parcels of my allotment. The area to be preserved has always to be 30% of the parcels area, also it has to be on the bottom side of the parcel. I tryied to had draw it on the pic above. Is there any transformer that could fill a the polygon within a given percentage, or create another polygon wich the área corresponds to the a percentage of the lot?

Attempting Automating Live Data into Map Service in ArcGIS Enterprise via FME

Hi all, Hope you are well. I have recently created a FME workbench which gathers all the information and updates every 15 minutes via FME Server. This then writes directly to a PostGres Database. I have got this part working and have successfully published the data to ArcGIS enterprise. The issue I am facing is how does ArcGIS enterprise update the data every 15 minutes when the Postgres database gets updated without me having to publish it manually every time? Is there a possibility for FME to do this? The output currently is in a map service.

303

3 years ago

jtermaatenContributor

asked in Automation

Gallery Apps don't show custom image

Our Gallery Apps on FME Server don't show a custom image as icon, but leave the space blank instead. In previous versions of FME Server this was not the case. Our installation is FME Server 2020.2, build 20787, win64.Any ideas on how to solve this issue?

122

3 years ago

stefanhContributor

asked in Automation

Get expiry time from FME Server API

Is it possible to retrieve the advanced information from Automations (like 'Queued Job Expiry Time' and 'Running Job Expiry Time') from the FME Server API?I would like to automatically check if these options are used for all my automations.

3 years ago

someliene

asked in Automation

Create excel drop-down lists with FME

Is it possible to format an Excel file with FME to create drop-down lists (function data validation in Excel)? I have multiple excel files that need multiple drop-down lists and a supplier excel sheet with all values. In total there are hundreds of drop-down lists that need to be created, therefore wonder if there could be some solution available with FME.

Trigger Automation with file dropped into directory, and move/archive file when finished

Hi All, I have a workbench built in FME Desktop 2019.1 which I am planning on deploying to FME Server 2019.1. This workbench does incremental updates to records in a SQL Server database on the basis of updates delivered in XML payloads. The workbench consists of an XML reader, various transformers to transform XML data into the required format, and a SQLExecutor to run an 'upsert' in SQL Server (we elected not to use a SQL Server Writer). XML payloads are delivered to a directory on a file share of some kind (probably FTP, maybe SMB - this is an implementation detail, I can map the directory as a network drive of some kind if required). We do not need to handle any kind of geospatial data. What I am trying to do is determine a way to trigger the workbench in FME Server by a file being dropped into a directory, and then, once the workbench has run, move the file to another archive directory. I can see that triggering an Automation in FME Server on the basis of a change in a dire

List of supported file formats for upload using FME Data Express

I have successfully used FME Data Express with csv files being uploaded directly from the users iOS mobile device. However I now need to have the users upload a .htm file instead of csv for the same type of workflow. It works fine on the browser using a FME Server app to upload a htm, however when using a htm table reader in the FME Data Express app, where the green + sign should be to add a file, I get [Unsupported] Source Dataset. I would like to know what file formats are supported for direct mobile device upload on iOS for FME Data Express, so I can try to develop some sort of workaround.

What is the output of the following?

x = [‘ab’, ‘cd’]print(len(list(map(list, x)))) Source: Python programming tutorial

I would like to know how to set an emailer to a workspace from FME Workbench to send emails to a group of recipients once there is a status change.

712

3 years ago

stefanhContributor

asked in Automation

I get an error when trying a specific API-request to get all the automations with a schedule: https://fme....../fmerest/v3/schedules?includeAutomations=true&limit=-1&offset=-1

The error is 'Unauthorized request by user due to lack of proper permissions'All other API-request seems to work fine. I checked all the permissions, and i have all permissions. Anyone an idea why this is not working. Screenshot Using FME Server build 20787)

122

3 years ago

johnkContributor

asked in Automation

FME failing on reader error when set on a Server schedule.

Hi FME team, I have a workflow on FME Server scheduled every day @ 8am. The workflow reads a HTML Table which is updated every day @ 7am. I am using a simple HTML Table reader, where the URL is always the same, as is the 'Tables/Lists to read'.If I run the workspace with FME Desktop, it runs fine.If I then publish this workspace to FME Server and trigger it to run, it runs fine.However, if I set the workspace to run on a schedule, i.e the next day, the workspace fails and I get the following error message (I have removed the actual URL for sensitivity):185 HTML Table Reader: Could not open HTML file 'https://exampleURL/Example.php' for reading. '<class 'OSError'>': 'Invalid argument'. Notes: my organisation requires each URL called by FME Server to be 'whitelisted'. The URL in question has been whitelisted and I can access it via the browser from the server on which it runs.The previous data source was a CSV download link and this

191

3 years ago

mmccartContributor

asked in Automation

FME Server Automation Directory Watcher Error: Could Not Retrieve File Listing

I am having issues with a Directory Watcher UNC Path. I was able to get it running in our Test environment. However, in the Production environment, I keep getting this error in the Automation Log: 801013 : Could not retrieve file listing. I've checked the following during my troubleshooting: Confirmed domain account has 'log-on as service' rightsConfirmed domain account is running the FME Server servicesConfirmed domain account as full access to the UNC pathConfirmed that I can connect and add UNC path and was able to add it as a resource to FME server and that I see files showing up in FME Server UI. (Resources>Directory)I'm running FME Server 2020.0.1 (Build 20218 - win64). I am able to validate the directory when I configure the 'Directory Watch' trigger in the Automation.I am just trying to read a UNC path with simple .txt files. Am I missing something in my troubleshooting? Thanks in advance.-Mark

Choosing which version on fme (32 or 64 bit) to be run on bat file on same machine.

We have installed both 32 and 64 bit version of fme on same machine. We are running a bat file that has the following struncture: fme python script.py which runs fine and is using the fme 64bit version(that was the first one installed on the computer). Afterwards we have installed the 32 bit version on same machine and we are tring to use a bat file that has the same structure as the one mentioned above but running the 32 bit fme version. Has anyone an ideea about how can this be done? Thanks :)

3 years ago

Page 20 / 33

Badge winners

dvattelanahas earned the badge Integrate Spatial Data
dvattelanahas earned the badge FME Form Basic Training
aurelienhas earned the badge Welcome Back
aurelienhas earned the badge FME Form Basic Training
lynnehas earned the badge Student (Grey)

Show all badges

30,152: 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 Privacy 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.