Automation

Are there any free options out there to use an instance of FME Server (Flow) to be used only for Safe Software’s tutorials or training?

We are in the process of migrating Projects from one FME Flow ( server  ) to another.   The old server is on FME 2021.2 and has been upgraded in place for several years.  So we are cherry picking projects to move to the new server that is running the latest FME Flow.  The old server has several schedules that have mostly been phase out (disabled) but still are on the old server for historical purpose.  While creating a project and trying to include schedules I do not get all of the schedules listed in the Project → Add ->Schedules dialog.  only the first 100 get listed in the sorted pick list and I see not way to get to the others. Has anyone else seen this issue?  Any workaround suggestions would be greatly appreciated.    I have thought of removing the in active projects or renaming the ones I want with a prefix “A1_” or something like that but wanted to check with the community.   Thx in advance.

Hi FME community,I am currently developing a validation script to compare two datasets derived from different versions of the same model, exported as .csv files from Navisworks.The script aims to ensure that the values for Translation X, Y, Z, and Rotation Axis X, Y, Z remain consistent across each version of the model. For instance, the .dwg file "PBD-ALG-SITE-EQP-ACD.dwg" from 27/02/2024 should exhibit identical translation and rotation values when compared to the version from 06/03/2024.Upon confirming that all values are consistent across different versions, the script will assign a "Pass" status, or “Fail” if a value is inconsistent.I'm seeking guidance on the most effective method to achieve this.Cheers. 

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:

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/Fore

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 Not

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 interfa

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 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)

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

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 stat

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?