Automation

Excel Reader: Failed to open the dataset 'E:\\apps\\FMEServer\\resources\\system\\temp\\subscriptions\\efbc8d67696c47d6b70bc0aa87c67166.json'. Error message was 'It is not a xlsx file. Use the xlCreateBook() for a xls file.'

Hello, I store attributes of my workspace in an json array (JSON_FILE_PARAM) using the FME Server Automations Writer (myWriter).{"automation.id":"c48fb4a8-5757-4207-867c-6d0de3947b5e","email.subject":"mySubject","email.received":"Wed Sep 13 09:37:26 CEST 2023","email.body":"e-mail:myEmail@provider.com"} Now, in my automation, I'd like to use the attributes as user keys:{route.myWriter.JSON_FILE_PARAM.email.body}I do have access to those attributes stored OUTSIDE the list but not INSIDE. I'm using FME Flow version 2020.

How can I trigger the start and stop of an automation/workspace through either e-mail or application? I have a workspace that needs to run on 15 minute intervals after it has been triggered by user input (email or application). User then needs to tell it to stop running. Seems like trigger in an automation can either be incoming e-mail or schedule but I cannot start a schedule based on an incoming e-mail. Same applies to stopping said application Any ideas would be great.

Hi,I created a workspace to process las files and receive raster and contours data set. The workspace supposed to be run with use of a directory watcher but it looks every las file is a trigger to run it again. Is there a way to have a single event with FME Server 2020.2? Thanks

Welcome,I need to download data from 300 wfs servers (list of it in any format) for 2000 objects (3 km buffer form point) like on a picture. Is it possible to add a list with server addresses to FME where it will check the spatial extent of the data from the server and then from the polygon range and download the data?

If I change the time to be 1 minute after the other job it runs successfully.There is no log file as the job submitter just does not start. FME should place the 2nd job in queue I would have thought.

We are hitting our 8 concurrent license limit with desktop. We use cmnd line and a PERL wrapper with our scheduling tool to run batch jobs. From what we read we are limited to 8 per engine, even if we were to buy additional concurrent Workbench licenses. So, that means FME server would be the only other option?Is it called FME flow now? Seems like a pretty big install. All we need is the server and the server cmnd line for a quick fix.

Hi.I have some automations running on 2022.2.2, and had to do a small edit on one of them. Afterwards the automation failed badly.I found that all the workspace actions in the automation had been "cleaned", i.e. set back to their default (workspace) setting of parameters. All of them. And I hadn't edited any of them, just moved some connections.No wonder the automation failed badly, as I'm e.g. using automation writer features to pass information between the actions. And have some global settings too for good measure.Has anyone experienced something similar ?What might have caused this ?Cheers.

In FME Server Notifications I used a JSON Reader to digest the incoming Topic Message and get at the relevant information to pass downstream in my translation. However when I try and create an Automation using the process the workspace fails with a 'file does not exist' error. How can I use the trigger event as JSON to run a workspace in Automations?

We POST data to Corelogic in a Python script that works well for one offs, but we are trying to run 11K and think FME would be faster. The reason we POST is that the bundle we send is greater than a GET can handle (larger number of Lat, Long).We have tried setting up similar to our Py code with URL, json bundle in the Body, and Authorization Token in the Header but no joy see pic _A.  request_post = requests.post(parcel_url, json=parcel_request, headers=coreHead). We also have also setup with Query String ParametersAny help would be appreciated.Examples:URL: https://api-prod.corelogic.com/spatial-tile/parcelsJson: { "geometry" : "POLYGON ((-75.90819777899998 39.808981800000026,-75.90412056399998 39.808855236000056,-75.90812199699997 39.80857331300007,-75.90819777899998 39.808981800000026))",

I would like to User to rename the output FGDB name every time they run the FME script using the batch file.I have a FME 2022.2.4 workbench file that output Data on to a FGDB.FGDB has many feature classes, line points and polygon.I have created User Parameter called "NAMEFGDB" then linked with the "Writer". When I run the script using workbench or quick translator it prompt and I can change the FGDB name.However when I run using the batch file, even though I can type the new name for the FGDB, it still writes out to Default database name. My Batch file is as below.@echo ## Start translation ## set /p NAMEFGDB=type fgdb name:"C:\\Program Files\\FME\\FME2022-1-2\\fme.exe" D:\\GIS\\Data_extract_by_Area.fmw@echo ## End translation ##pause Is there anything else I need doing to connect the FME script to batch file?

Good morning, I’m trying to automate my fme with a bat file. It’s the first one and I don’t understand what’s blocking it. I attach my bat file if someone can help me tell if the command lines or not =) thank you 

I am writing to postgres/postgis st_geometry in an autmation that is loading many dwg datasets. (runs workbench on each dwg)The postgis writer shows that ver 14 ignores writing od. I need to get an oid calculated beginning with the last oid used (in the previous automation) NOTE: postgis writer specifies that oid is ignored at postgres 14. I tried just using a counter and hoped that writing to existing would automatically write the oid. (I get an error the oid already exists).I am using this oid as the primary key so that It doesn't have to be set when adding to esri. I have attempted to read the flat postgres table and sample the last n and then use that as a parameter to set the start number of the counter. But have not been successful getting that to work.Any ideas on how to do this? 

HiI'm working on a project where we are migrating from a solution based on subscriptions into more automations. I ran into problems when I try to pick up the topic name from fme server parameter FME_TOPIC. Inside a workspace triggered by a subscription all is fine, but when a use automation with a FME Server Topic Trigger, the value of FME_TOPIC is a GUID like string. First part of is the same as the automation id. I have no problem with FME_TOPIC_MESSAGE parameter. Any ideas? Thanks, Stefan  

Having a SDE Geodatabase and a Feature Class called `Park` can someone please let me know what Triger Event I can use to be notified and action when a New Feature added into the `Park` Feature Class by user 

In an automation, we are utilising an automation writer to pass a dynamically created json syntax for sending an email to a relevant FME Server topic. e.g. { "email_to" : "<to email>", "email_cc" : "", "email_bcc" : "", "email_from" : "<source email>", "email_replyto" : "", "email_subject" : "Hi", "subscriber_content" : "its me again" }  The topic is however sending this as "content" rather than breaking it down into relevant parts when it is passed in as a variable from the automation writer (in this case {route.Output.text_line_data}) However, if I past that same hardcoded text value into the notification, rather than have it come from the automation value, then it works.  We utilise a email subscriber to send all emails, rather than setting up individual email sendi

I have an automation that is triggered when the user enters a record into a database. When that job fails, it would be helpful to have a link directly to the job details in the log file. When the job fails, it sends a failure notification email from an FME workbench that is part of the automation flow. It does this via the emailer transformer. Is it possible to add a link to the log file for the specific jobs that are triggered? Is it better to do this inside or outside of the workbenches inside the automation? Thank you

FBX is EPSG:2326 coordinate system. VRML (*.wrl) converted is (Y and Z coordinate swapped)

Hey there,I have written a workbench where I get some data from some weather-stations and generate the average temperature for that station as a line in a new Excel file. It works great but we have 100 Weather stations and I want to make it with all of the stations and get the excel file with 100 lines... I imagine it like:for i in 0..99 loop getDataFromStation(i) processData() writeDatain Excel(i)end loop But I have no way to do those loop in FME Desktop or Server. Or at leat I do not find it...Has anyone any idea?thanks a lot

I have a Fault Tolerant installation of FME Flow that includes a load balancer. I need to use IMAP email protocol to receive emails from FME Flow. ​I have created an automation and want it to send an email if succeeds. In the Automations screen - Email Details, I choose Actions - Send an email. I then see the SMTP parameters, but nowhere found is IMAP protocol parameters. How do I access IMAP protocol parameters if I want to Send an email?

I have created an Automation in FME Server. It is triggered by a Schedule and runs a single workspace. What is the best way to have an email automatically sent to me notifying that the automation has finished running and succeeded or the automation did not succeed.  In FME Server, I see under Automations - Notifications (Classic). But I am not clear on exactly how to set up the email notification. Here is what I have done so far, and it does not seem to be sending me an email after the automation has run. Any suggestions?

I need to publish a workspace into FME Server that has a disabled connector and disabled transformer. In FME Desktop 2021, the workspace can run successfully with these disabled. If I publish this workspace to FME Server 2021 and create/run an Automation, will FME Server recognize the disabled connector and transformer and not run them?

hi i have to add some properties in the ifcpropertysinglevalue for the objects in an ifc file but those properties i need to inject them in a certain propertyset and under some conditions ( if i have for example IFCFLOWFITTING i need to add x properties ?

I have a service that runs on a schedule that regularly fails to connect to a hosted ArcGIS Online service. If I manually resubmit the same failed service it succeeds. I have other scheduled services that use the same AGOL connection without any problems. I have tried recreating the scheduled task, republishing the service, and re-authenticating the connection. Does anyone have any ideas why this scheduled service is failing but succeeds when manually running and other scheduled services using the same AGOL connection succeed?

Hello all, I have had an automation running for the better part of a year and I set it up to send me emails (post topic on failure). I needed to revise this and set up 2 separate automations to separate the types of jobs, daily vs every 30 minutes. Prior to setting up the new automations, I stopped the original and deleted it. It is still sending me emails now. I also made sure I replaced every instance where it was tied to a schedule, and I deleted the topic itself, and I am still getting emails. It has been stopped and deleted for over a month now and I am searching for a solution to end the emails. Any help or suggestion would be appreciated. Example below, it is sending failure notifications from over a month ago:{"automation.id":"cac0de02-77e3-4c13-b330-dba1175dfaf7","workspace":"CMPT CG Future Allocation VW.fmw","timeRequested":