Automation

I have two tables, they have the unique ID to compare with each other. There is another column called year in both tables. I am hoping to find records in table2 with the same ID in table1 and then compare the 'year' attribute, only keep the latest one. Which transformer should I use? The feature joiner can find all records in table 2, but it can't dynamically decide which one to keep.  

I am using system caller in child workbench which trigger 3rd party service using command line and start the process e.g. abc.exe in windows. Sometimes process get stuck at their server and I am not able to get the status of the same, hence child workbench continue until any response gets from System caller. Is there any solution to kill the 3rd party process using windows process name or ID if its taking more than a particular time e.g. 1 hr?Note: I am using FME Desktop with concurrent process of 3 jobs, so it should kill only the process which are not getting finished within 1 hr.Can anyone help me on this?

Have two automations happening where one downloads files off an Azure Blob storage. The other is actively listening to the folder where the first automation downloads files too to trigger a workspace. My problem is that for some reason AzureBlobStorageConnector sometimes downloads files as 0kb. Is that cause it's trying to download files that haven't fully uploaded to that Azure Blob Storage? I.e the same thing that happens when you download something off the internet and it goes to the download folder as a temp file - until it downloads fully. CheersDan

I want to terminate child workbench automatically if its taking more than the expected time (e.g. 30 min). Also it should be treated as successful translation in the workspace runner so that next job in queue can start concurrently. Is there any solution?

I was using Httpcaller for an automation but I could not get it to work. The URL to the service I wanted to use worked fine in the browser but when my automation ran, it resulted in an error from the service saying "invalid URL". It turned out that my URL contained spaces that was encoded as %20 wich the Httpcaller encoded in turn to %2520. Replacing %20 with a space in the Httpcaller solved the problem. Is this desired behaviour? I'd excpect the Httpcaller to understand not to encode an URL that is already encoded.

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?

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