Automation

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":"Wed-31-May-2023 05:00:00 PM","requestKeyword":"SERVER_SCHEDULER","ti

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 a post request to the manual trigger a

I'm trying to replace the deprecated FME Token Service in our data download tool with the FMEServer Rest API but I can't see in the token methods how to include the username/password to create the token. How can I do this? Thanks.

When I create a manual trigger automation and pass in a single key value pair as a manual Key, the complete json for the key seems to be pass to the next action in the automation. The next action is a submit job action that takes a single published parameter (VERSION).    Is there a way to bind just the value from the manual key to a published parameter in the next action (Run a workspace action)?  I created a manual trigger with a manual key called MANUAL_KEY.  In subsequent actions, I apply the MANUAL_KEY from the trigger to a parameter in the action using the pattern “Manual.MANUAL_KEY” the resulting value is complete JSON and includes KEY name and value.   This results in the full json passed in as the published parameter in the workbench action : { "MANUAL_KEY": "Example value"} Is it possible to bind only the value?  Something like “Manual.MANUAL_VALUE.Value” ?? Which would pass only “Example value” into the published parameter of the next action? I have tried

Is there a place from the web interface or configuration files where default values can be modified regarding Automated Retries?  Number of attempts Wait between attempts Backoff multiplier Randomization factor Maximum wait between attempts

Hello, I would like to set up a notification so that every workspace that failed on FME Server will send an email. I have set the configuration the Subscriptions along with changes on the file fmeserverconfig.txtHowever, I received an email with FME transformation job 5237 failed. while instead I would like to receive something like this json  {"id": "3", "requestKeyword": "JOB_SUBMITTER_SERVICE",   "timeFinished": "Mon-15-Aug-2011 02:04:20 PM",   "timeRequested": "Mon-15-Aug-2011 02:04:20 PM",   "timeStarted": "Mon-15-Aug-2011 02:04:20 PM",   "LogFileLocation": "\\Server\FMEServer\Logs\jobsubmitterservice\FME_7D150E1F_1313442260444_4244.log",   "LogFileName": "jobsubmitterservice\FME_7D150E1F_1313442260444_4244.log",   "StatusMessage": "A fatal error has occurred. Check the logfile above for details",   "StatusNumber": "1",   "urlPrefix": "http://locahost/"   } Any ideas?  @rylanatsafe​ , @david_r​ ,  @Takashi Iijima​  and others

Hi, I have a question. How best to build automation on the server regarding the launch of individual workspaces with the condition of a valid result of each of them? I've been looking at fmeworkspacerunner, but at first glance I don't see a definition of multiple workspaces anywhere. Am I going in the right direction or is there a better solution? Thank you

Hi Everyone,I was hoping to find a definitive guide explaining how to use CI/CD automation with FME. Right now we have very few workspaces and so we use a manual process to deploy FME things in production. We use Publications, Schedules, Subscriptions, workspaces, data files (for passwords), database connections, etc. I looking for instructions to help with following:Integration with a source control like GIT so that we have versioning set upA guide/tutorial that can explain how to automate deployment of all things FME. If something cannot be deployed via automation, I would like to know that as well.Any pointers on automated testing of FME workspaces/schedules once they are deployed in an environment.

Hello FME Kings, Here is my situation: I have a script that uses HTTPCaller for geocoding in OpenStreetMap and MapGeoAdmin (retrieve coordinates from an address in an input attribute) and, sometimes, several "addresses" are located for the same input address which gives me a list of addresses (extracted with JSONFlattener). My problem is that I would like, in one script (and I've been working on this for a while), to stop the script and generate a dialog box with the possibility to choose the right address in a dropdown list like thisATTRIBUT ADDRESS ENTRY => CHOICE OF DETECTED ADDRESSES (combobox)  => "1, Chemin du Lac de Mont-d'Orge, La Muraz, Sion, Valais, 1950, Suisse"                => "1, Rue du Mont, Sion, Valais, 1950, Switzerland                => "1a, Chemin du Lac de Mont-d'Orge, La Muraz, Sion, Valais, 1950, Switzerland"... since, in an automated way, it is not possible to know which one is the right o

How we can read any specific Microsoft Outlook email and excelsheet attachment with data from email to add this excel data in FME Workbench to process ahead and generate the required output as reports.

Hi Team, Is there any limitations for size of job log. My job keep restarting if the job log reaches to 25 page. Thank you

I would like to write attributes name including data for each attribute at specific cells in excel file .how could I achieve that Fme 2021

Every week we have a field crew collect and add data to a geodatabase throughout the week. At the end of the week the Supervisor wants an excel spreadsheet of all the data collected in that week. I have a workspace that runs FME every Monday to collect the weeks worth of data. Right now, I use a tester transformer and I pre set the dates for the following week so when the workspace runs, I have the correct weeks' worth of data. We have field in the geodatabase that collects the date the asset was collected. Then I have task schedular set to run the workspace.  My question is, is there a way to pre set the dates instead of me re-setting them every week? I have tried using Datetimecalculator but I can't seem to get the parameters right. Please let me know your thoughts, thanks in advance!   

Hi ,i just upgrade FME server from 2021 to 2022.2.5 and i get this message during running job on FME server.AUTOMATIONS writer: AUTOMATIONS_2: Error, unsupported list attribute detected...is it a bug and not solved?please advise , my goal is counting records from written shapefile.also attached the log file. thanks in advance.