Automation

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!

The end product is intended for viewing only so ancillary staff can see and drill down to certain engineering levels without having to download or know how to use engineering software like Bentley or CAD.  I have an FME pipeline built already so am going back thru and optimizing. looking for others who maybe have completed a similar workflow to compare notes with. What worked \\ what hasn't etc.  Some notes - Client does not have ItemTypes set up so am not working with much attribute info. I am expanding cells to extract constituent geometry. Interested also in methods to handle 3d Geometry.  We are also interested in utilizing FME Server to potentially automate as new files are added to a directory. Please feel free to direct message.

G'day, We have some Asset software which has an API available, on the most part we are interfacing with the API well. There is an upload component which I have never been able to automate, yet I can use the manual swagger page to test it out no worries. The swagger page with the /api/geo/add_geo_package can be found here - https://api-albury.conquest.live/swagger/#/GeoPackageImportService/GeoPackageImportService_AddGeoPackage Basically, I need to manually click 'choose file' from the webpage, which I can do, but I want to automate this step using FME, so I don't know how to replace the manual "choose file" button with a simple file path location to tell it where the file is currently located.  I have just noticed there is an 'upload file' option in FME, I am trying to implement this, it seems straightforward, so I have setup my tranformer as per this screenshot:  This runs well, but the _output field is empty, and the swagger site provided above states

I have a simple PythonCaller (for now) which basically is something like thisimport fmeimport fmeobjectsimport arcpy class FeatureProcessor(object):    def __init__(self):        """Base constructor for class members."""        pass     def input(self, feature):                geom = ["Point", "Multipoint", "Polyline", "Polygon","Envelope"]        for geo in geom:          print(geo)          self.pyoutput(feature)     def close(self):        pass     def process_group(self):        passCan you please let me know 1- Pass the Result of Python  from PythonCaller to User Parameter Choices   2- How to Pass selected values from here to second PythonCaller2 to only simply print out the selected choice? I tried to make it as simple as possible and sorry for confusion! 

Run into a strange issue. We recently migrated our FME server (2022.0) from a Windows server 2012 R2 to 2019 a few days ago. Everything has been working fine until a couple of days ago when I found out I can not save changes to some automations or create a new one. They just hang at save. I narrowed down the issue is with the automations that have any workspaces that take parameters from the upper-stream workspaces, such as the upper-stream workspace name and job ID. I am attaching a simple test workspace that takes two published parameters. The workspace is added to a simple test automation. When I save this automation, it hangs. I am also attaching the screen shot of errors in the browser developer console. Note all migrated automations with this kind of workspaces have been working fine. I just can't make changes to any existing automations or creating a new automation that include this kind of workspaces.

Dear fellas,  Someone created an FME-workbench for me to input a DWG with lines, and output an DWG with all hatches.  However, when looking in the hatch properties in the generated DWG, this hasn't got an area. BUT, when I click once on a grabpoint, deselect, and select the hatch again, it DOES give me an area. Autocad tellls me the problem is within FME and there's no tricks in autocad to avoid this needed click. Because seems like Autocad doesn't realize the hatch exists, untill its clicked once, till then, the area is never calculated.  Any way to solve this problem? cause select something like a thousand hatches, click them, deselect, and select again takes a lot of time. generating all the boundaries at once isn't a solution because there's islands in the hatches.

I have tried an area calculator and area selector for polygons less than 1m2which appears to work but I wonder if there is a better method

Hello is there any steps to speed up the run time of FME workbench, My workbench is taking more than 6 hours of time for execution.

I have a workspace where I am using the Emailer Transformer.  What is the best way to send a single email based on reading a list of 5 email addresses in an Excel Spreadsheet? Would I still use the Emailer Transformer? I am thinking there are parameters I need to change in the Emailer?

I have a FME 2022 Script that run against an Oracle Database and extract list of boundaries and output on to a FGDB. I would like to let User to run the script using a bat file, rather than intervene with the Script on FME workbench. I have a list of boundary IDs on an Excel that attached to the script then User can extract boundaries on the excel sheet. But I would like User to extract any boundaries begins with boundary ID ie: "AA-X-BB" I would like some help to understand how to write the script that the bat file extract all the boundaries begins with my ID rather than a single boundary.Any help would be appreciated. thanksPushpa

I've recently developed a Workspace App using FME Flow where users can enter search criteria, and the backend workbench processes this input to return an HTML results page with a list of database query results. I now need to implement a printing feature that allows users to print a selected row from the results table. Here's my current setup:I've added a print button to each row of the results table.When a user clicks this button, it triggers a webhook URL intended to initiate an FME Flow automation. This automation isn't yet configured but will be responsible for creating a printable document. My initial idea, which I'm open to feedback on, is as follows:Capture the data from the selected row and pass it to the webhook URL.Use the necessary workbench logic in the automation to generate a Word/PDF document with the chosen information.Allow the document to either be downloaded directly (preferred) by the user's browser or present it for printing. I’m aiming for t