Automation

Hi there,I am attempting to set up automated email notifications with the workbench attached via FME.I have followed the instructions present on the Help document for the transformers called as FMEFlowEmailGenerator & FME Server Notifier. However its not sending the emails through.I have set up new working connections to FMEServerNotifier, using my own login details connecting to FME-TEST, which is FME Flow. No email is being sent. I ran this via FME dekstop, which should work according to documentation:https://s3.amazonaws.com/gitbook/Server-Authoring-2019/ServerAuthoring4RealTime/4.17.TransformerWorkspaceTopics.html I also wish to include the attachment generated by the Feature Writer before the FMEFlowEmailGenerator, it looks like the path may be a incorrect. How would I also fix this if it will cause issue? I have tried to get this email notification service to work with and without the email attachment in case it was causing the issue. It would not work either way.Any suggesti

I have several database connections under Files & Connections in FME server. The passwords of these databases change frequently and currently I’m updating them manually. Is there any way to automate updating the credentials of these database connections under FME server ? Any API available ? Thanks in advance 

I have a workspace in FME Flow but I don’t know wich automation it’s used in. How do I find it? We have 75 automations, I don’t want to manually search through them. It hasn’t run in a while so I didn’t find it under Jobs/Completed.

Hello,I continue to have trouble converting PDFs to JPGs!  I am/have been followed the instruction on:but keep getting errors on the Writer. JPEG writer: This format cannot support more than 3 bands.  Please remove the extra bands and try againJPEG writer: An error has occurred. Check the logfile above for details How do I find out the number of Bands as they pertain to ImageRasterizer’s Raster Properties Number of Columns and Number of Rows??  Or is there another way?? ThxBrian

Hi All, I had a case with FME flow where I could create automations and run them, but received an error when trying to turn them off : We fixed the issue by updating the JDBC drivers and everything worked fine.I then moved to a different environment (production) and assume that this fix had been applied but it hadn’t. I created an automation and then could not turn it off, so I deleted it.When I look at the automations page I can see that there are no automations, but the one I setup and deleted is still running jobs on its scheduled interval (every 10 minutes). I had to delete the workspaces from FME flow to avoid these from running. Does anyone know if I can go into the FME SQL Database and delete the automation from one of the tables? I don't know if there is any dependencies on Primary/Foreign keys and don’t want to corrupt any tables. If this is possible could you please advise the table as I don’t have access to view these and our IT team will want to know exactly what to delete

I believe automations with names containing for examlple commas (',') are not able to use incoming email attachments. The email attachment is downloaded to a temporary folder like the example below where the name of the automation becomes a part of the path:C:\\ProgramData\\Safe Software\\FME Server\\resources\\system\\temp\\emailattachments\\20211230112047-<Name_of_automation>-<Email_Subject>-7ac8a779-9ea4-4ab3-a228-c880ec539c95\\data_562_1715_20211013_0933.xml Spaces in the automation name is replaced by underscore but a comma sign is not. I am not using the option to download the attachment to a specified folder.I got this error (with the triple dots added by me):XML Parser error: 'unable to open primary document entity 'C:\\ProgramData\\Safe Software\\FME Server\\resources\\system\\temp\\emailattachments\\... analys,_uppdate...data_562_1715_20211013_0933.xml Note the bold part with a comma in the path.I renamed the automation and the problem was solved.

I have a workflow that takes a file in input , does a conversion , then outputs the converted file.I published this workflow to fme flow . and i want to use it to in my simple node js project : simply : the user clicks on “Choose an input File” , and chooses the file he wants to convert ; and after clicking on “Convert and download result!” , his file should get uploaded to my fme server , the workflow gets applied on it , and the resulted file gets downloaded to the users computer.  And I don’t know how to apply the workflow on the file that the user chooses , because the filepath of the reader dataset is static , and can be changed only manually in the fme flow web interface ;​​

Hey. Hey. I need some way to automate adding a time interval to a script in pythoncaller see attachment. I have a regular WS which I don't publish directly to the server, however it is not a problem to publish to the server, I have it available as well. It depends on whether the automation will be handled within some workspace or by some setting on the server, I don't know what your advice implies.So I have a calendar created in postgress DB see attachment, where I have airac_start and airac_end values - this is the time interval. I need to add these values to a script in pythoncaller ( there are two in WS ). This addition would happen by pasting the source files somewhere on disk ( probably watching for a change in the contents of the folder would be like a trigger ), which would start the whole process and depending on what cycle should be running, the airac_start and airac_end values would be added to the script. Can anyone think of any way to automate this thing? The way I work now

I am learning how to use Keys in Automations. I have created a Global Key (see screenshot below). As viewed in the text editor, is there a way to make the text “Automation Name:” bold or change its font? 

Hi Team, I am trying to create workspace applications in a newly installed instance of FME Flow 2023.1.1 (has to match our Form version) and when creating Workspace applications I can no longer select the "User can Upload" option on any newly created workspaces. If I select workspaces a historic workspace (brought in via backup from 2022) the option is there.  The only thing in changed in between screenshots was selecting a different workspace (same user, repository and service)Any ideas? All help appreciated 

HiI am creating an automation in FME Flow.My first workbench looks at a SQL database and extracts the most recent date/time. I would like to use this value to feed in to the Where clause of an Oracle reader in a second workbench so I can extract all records greater than that date/time without having to read all the records in. However, I cannot find anyway to pass the attribute value of the first workspace to the second. Im sure I read somewhere that this was possible using parameters with workspace runners in Form?    

Can someone provide a link/info on where I can learn more about CRON Expressions? I know what they are used for and why but have never actually used them before. Thank you. 

Can someone expound on this topic a bit, why would someone use Schedules and create Notifications in Schedules when it can be done a whole lot easier in Automations? Example, setting up an email notification in an Automation is just a matter of adding the Trigger --- Workflow --- Email (one for Success and one for Failure if you like). As opposed to going through the brain twisting effort of using Notifications (Classic) to do this.  Automations are so much easier to work with. Does Safe have plans to remove Schedules and Notifications (Classic) in future releases? keep only Automations and improving upon them?

Hi,also see item Error when attempting to turn automation off - Have to run jobs via automation | Community (safe.com).We also encounter this issue after fresh install of FME Flow 2023.2.1 on a new Windows 2022 server. Below are all answers on questions asked in the related topic. Can anyone suggest some path to solutions?: What version and build of FME Flow are you using?FME Flow 2023.1.1 Build 23774 Win64Is this an express, distributed, or fault-tolerant deployment of FME Flow? Distributed (database on a separate MS-SQL Server)If you restart FME Flow, does it resolve (even if temporary)?We restarted FME Flow and that resolved it once. Later we ran into the same issue and after another restart it did not resolve.what is the FME Flow database? The default Postgres, or another, like SQL Server? This is a MSSQL 2019 Database Connect string: DB_JDBC_URL=jdbc:sqlserver://guo10794.k-domstad.org;port=1433;databaseName=fmeserver;TrustServerCertificate=trueThe connect string uses jdbc driver.

I added a new row of info in Attribute Manager in the workspace. This row needs to be added in the Service request on Cityworks. Would republishing the workspace with same name brings in those changes in the Service Request, provided the source will include the new row ? Any insights are highly appreciated.

When creating an automation, I find that the "Next Action" boxes will just clutter the workspace and I end up deleting them anyway. Is there any way that anyone is aware of, that they can be hidden by default? Typically, I setup data downloads to refresh data from various other agencies. So I have a single Trigger, which then executes / queues, multiple workspaces. They can definitely be useful if creating smaller workspaces, so this is where a toggle button would be useful!

When creating an Automation, I usually use a Trigger to schedule my jobs. (FME Flow Schedule)But is it possible to create an APP whereby the user gets to choose the Date / Time to run it instead of an instant submission of the job? (User Param maybe) 

Hi everyone, I am currently trying to use the NeighborFinder transformer in Group-By mode to match features from SDE A on features from SDE B. I'm using Group-By to only match objects of the same type (trees with trees, bollards with bollards, etc) and with the same vertical datum class (ground-level with ground-level, below-ground-level with below-ground-level, etc.). However, some feature classes in SDE A do not have a vertical datum class attribute. Using the NeighborFinder in Group-By mode, none of my objects match, since SDE A has <Missing> vertical datum classes, and SDE B has correctly filled in ones.For these feature classes it is alright for the NeighborFinder to only use the obect type attribute. I want to avoid using multiple NeighborFinders in my workspace. I have tried constructing a special Group-By attribute, concatenating the two attributes. But I can't seem to find a nice way for SDE B to not include the vertical datum class when the SDE A featureclass

I already have a date field in the excel spreadsheet. I think I am just missing how to set up the parameters. Please let me know 😊

Hi we have FME Server 2021.3, ArcGIS Pro 2.9 installed [concurrent license - license manager on separate machine]connecting to ArcGIS Enterprise Geodatabase 10.9.1on Oracle database 21c We have a few automations running at different schedules. We have seen intermittent issues while connecting to read/write to the geodatabase. 1) Error while retrieving an ArcObjects update cursor for the table/feature class 'xxx'. The error number from ArcObjects is: '-2147155559'. The error message from ArcObjects is: {Failure to access the DBMS server [ORA-03114: not connected to ORACLE] [xxx]} 2) Could not open the Enterprise Geodatabase because the local version of ArcGIS is not compatible with the server's SDE version. The above 2 issues causes automation to fail Also, the following error occurs consistently for each run, but the automation carries on successfully:3) BADNEWS: Execution of statement `SELECT SDO_VERSION FROM DUAL' did not succeed; error was `ORA-00904: "S

Hi, i'm downloading a zipped shapefile from http caller (going well), saving correctly as a file, but when i try to write it to a new postgis table something goes wrong. I want to dynamically set the Table Name as "sentierisat" plus the value stored in "_timestamp" field: something like "sentierisat_@Value(_timestamp)" but what i get is actually 2 postgis tables, an empty one with the correct tablename and a second one filled with data but named only "sentierisat_". 

The link https://community.safe.com/s/article/send-email-from-automations is enough when you want to send an email from an automation but it does not cover what I'm looking for. I would like have in place an automation that will (i) detect any workspace that failed on FME server as soon as it happened and (ii) send an email to a specific email address. How should I proceed to achieve this double objective?

I have multiple files landing in a folder that is watch to trigger a wksp.2 files go together but don't always have exactly the same name. (they will be similar.) There will also be multiple folders where these files can land and be processed. I need to know several things.1 idea for parsing the file names of separate file types to get them matched into the same wksp. like maybe they land at the same time?2 is it possible to use 1 automation to watch and file both file types and use them to kick off 1 wksp? image 13 all the jobs coming in will be moved to 1 of 3 folders when process is complete using a file mover. Do i need three qutomations in my wlrkspace to tell the file mover where to move the package (both files) or can this be done with the dataset value (being parsed in the file mover wksp? see image 2 IT is also possible that files will land in both incoming locations at the same time. the file types would be the same but the file name would be different I found some inform

Hi everyone, I'm looking for a way to trigger an automation once a job has been SUCCESSFULLY completed BUT contains errors. See job 56207 in the attachment as an example. The automation itself should then initiate another job.  So far, I haven't found a successful way to accomplish this seamlessly and efficiently. I've considered monitoring "/FME_SHAREDRESOURCE_LOG/engine/current/jobs" through an automation, but since I want it to automatically start a new job, it creates an infinite loop. The system events 'Error Message Logged' and 'Warning Message Logged' also do not allow me to trigger a new job via automations based on my conditions. I'm curious to hear your insights.

I have filtered data from the results of a value in a field (using tester) in order to split that data in 2 - North and South.  I want to split different data from a different FGDB (with similar fields but not matching and similar area) based on the split I completed above. Is this possible? if so how would I go about completing this? Im wondering if I could add a field to the second FGDB from the first results even though the area might be slightly different ?  thanks and much apprecaited!