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

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

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?

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 attachm

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     

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.

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!

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

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!

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.  

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.

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?

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.    

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?

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.

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.

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

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. 

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.

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)  

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

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 troubleshoo

 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 :)

Hello I'm hoping that someone could shed some lights on this issue which I'm experiencing and not related specifically to FME 2020.2 So basically if I make a change in a Reader / Writer, i.e. changing the path of the destination then (Re)/Publish the workspace, I can see the changes made in FME Web UI but in Automations, the settings remain unchanged. That is problematic. I changed the DFS path from "MVGIS02-Data" to "GIS-Data". FME Server WebUI Automations Log