Automation

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

I'm just wondering if there's an impact on performance having multiple automations running constantly. They are triggered by a schedule within the automation to run once per day.

Hi, I have a spreadsheet in sharepoint where one of the sheets needs to be updated weekly, from another sheet that is in another file in sharepoint.  I tried using the sharepoint connector but it makes me lose cell color, formulas and other formatting. The ideal would be just to delete a sheet inside a sharepoint file and insert a new sheet, without harming the other sheets. How can FME help me with this?

Hello,  Currently, I'm having a delay and I don't know how to fix. The FME server time is not the current time, instead it is the time UTC that is displayed. How can I change it? 

Hello - I have an FME automation, that downloads the attachments from an email trigger using SMTP protocol. There is slight issue, each time when the job is triggered via received email, FME Server is creating a folder under my desired location, instead of overwriting the file with the same name email attachment. any thoughts or suggestions ? I have attached screenshot of the automation configuration and also target location where FME Server is creating multiple folders. The file name EPS_DATA.csv

Brand new to FME server, and i've only really worked with outgoing REST API calls before in general. What i have is a workspace that is parsing emails and picking out specific data that is then packaged based on conditions and sends out an REST POST request to another platform. The packaged data going out becomes an actionable item in the other platform, and i want to have users be able to click a button to respond to the action item and have that come back to FME Server (i assume it'd be a post request) where i can write to a table some related data. i'm not sure how to "listen" for incoming REST requests? i've read through the v3 documentation and it is pretty likely that i missed it, but i'd love it if someone could help me out?

Good afternoon i am new to FME at this sort of level and interested in digitizing a number of pdf site plans to shp format. I have read a few i must say articles here in the forum, referencing various transformers and i am bit confused i must say. Ideally i would want to georeference the plans and then have them digitised. Is there a way that this could be streamlined by FME?Thank you in advance for your help

Hey everyone, I have an API that hold historical data. I would need to retrieve all the data for the past year. I am using a HTTP Caller to retrieve data. The API only allows for 30 days for one location to be retrieved at once.I have 36 locations, and about 15 months worth of data to retrieve. I already have workbench that retrieve one month for one location worth of data.How can I create a loop that would go through all these locations and date list automatically?

I've built an generic automation that encompasses some business logic. I've isolated the variable input as global parameters, and duplicating the automation and only changing the global parameters to adopt them for another dataset. Is there a way to initiate an automation and setting these parameters ? The automation server app does not provide for this as-is (2022.2.2), so I'm curious as to whether there are other ways to accomplish it ?Cheers.

Having a Workspace like this and the AttributeCreator like  Can you please let me know how I can pass the AttributeCreator Values into the PythonCaller. Like following pseudo code to loop in the attributes from the AttributeCreator     def input(self, feature):      for attr in .pythoncreator.getAttribute:            print(attr )        self.pyoutput(feature)        

I have followed the instructions here. Step two doesn't function properly. I have submitted surveys to the webhook url, postman requests, but nothing has triggered the automation, the log is empty.  However, if use an http caller from a workbench, I can trigger the automation.

I need to be able to trigger a collection of workbenches to run (preferably in parallel) using and HTTP GET request. I need to be able to pass the ArcSDE transactional version name as a parameter in the get request to an FME server process (automation or similar).  The client application an ArcGIS workflow manager step and it cannot make post requests.I have gotten this to work using a single published workspace using a GET request to the trigger service passing in the version name like so:protocol://<SERVER>/fmejobsubmitter/P1907/TRANS-VERSION-TEST.fmw?TRANSACTIONAL_VERSION=”owner.JOB_402” But this only works to trigger a single job. I also attempted a webhook and manual trigger automation that runs multiple job in parallel but it seems that you can only trigger these types of automations using POST requests and the client doesn’t support this.Are there any other options? Could I create a workbench that that acts as simple proxy and creates