FME Flow

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 a bit of a dilemma. I'm setting up a self-serve workflow where the end-user will have to upload some files and then run them through a validation and processing workspace. The files that are needed are 1 mid/mif and 5 csv's with different schema's. To make things easier I want the user to zip them all up and upload them as a single file. I'm using a File user parameter then point that to a Generic reader which reads [somethingsomething].zip\\*.* and then use wildcards to match them to the specific feature types. This works fine if a single zip file is processed. However... this data is grouped by region and the customer indicated that sometimes they need multiple regions. Plus... features from two adjacent regions may actually geographically coincide, so the processing workspace needs to have them both at the same time.  I set up the File parameter to handle multiple files as input, split the value and then run them through a FeatureReader. That's where the i

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!

Hello Forum, In FME Flow's App builder I would like the word in the OK button to be 'Run' instead of 'OK'. This is because OK, is often thought of as also meaning close (yes, I know the users could just close the browser tab).  But of course, in the case of FME Flow Apps OK most definitely means 'run it'. So, it would be better if the word OK was replaced by Run.  I've looked in Flow Apps>Manage Workspace Apps>(click the App in question)>Customise, but there doesn't seem to be an option to change the wording of the OK button. Any ideas? Thanks,Stuart 

I performed the express install of FME Flow 2023. Then I restored a backup from FME Server 2021. I do not see the backup schedule promised at https://docs.safe.com/fme/html/FME-Flow/AdminGuide/Perform_Scheduled_Backup.htm. Did my restore over write it? How can I automate a backup of FME Flow?

I have a issue in which your urgent help is required. I have a shared FME flow 2023.1 database which is accessed via two nodes. Both nodes have 5 engines each.When I check from fme flow url I can see all 10 engines ( 5 from each node) available. But if jobs are fired then only 5 engines become available and 5 always show idle.Please help to resolve this issue as it is stopping us from upgrading to latest FME flow.

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.

When i start the program FME Workbench version 2021.1.2 and 2021.2.6, the system start up as expected. But when i try to start FME Workbench 2022.2.2, 2022.2.4, 2022.2.5 or FME Form 2023.0 the start window appears. But when it comes to "Initzialising main window" the system craches every time whith a loggmessage in the Windows Event Viewer: (Sorry about the swedish language in logg) "Felet uppstod i programmet med namn: fmeworkbench.exe, version 2023.7.46.23275, tidsstämpel 0x6436125d, felet uppstod i modulen med namn: ucrtbase.dll, version 10.0.19041.789, tidsstämpel 0x2bd748bfUndantagskod: 0xc0000409Felförskjutning: 0x000000000007286eProcess-ID: 0x3300Programmets starttid: 0x01d9a4d0db7b26d8Sökväg till program: C:\\Program Files\\FME2023_0\\fmeworkbench.exeSökväg till modul: C:\\WINDOWS\\System32\\ucrtbase.dllRapport-ID: 47a2422c-3812-46fc-be60-5a47781d95a4Fullständigt namn på felaktigt paket: Program-ID relativt till felaktigt paket: " It locks like there is som

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

We have upgraded to FME FLOW 2023.1. Now the workbenches that write or read to to our SQL Server Spatial - SDE MS SQL Server 2012 fail. It looks like an SSL certificate error.  Microsoft SQL Server Spatial Writer: Failed to connect using Microsoft OLE DB Driver 19 for SQL Server. Provider error '(-2146893019) SSL Provider: The certificate chain was issued by an authority that is not trusted. '. Connection string 'Provider=MSOLEDBSQL19;Data Source=djskfjdksfjslfjslf-sqlserver-se.cdvhtvcfec0o.ap-southeast-2.rds.amazonaws.com;Initial  Failed to open writer MSSQL_SPATIAL writer: An error has occurred. Check the logfile above for details. Not sure what is going on and how to fix it. The workbenches on FME Form fail as well with the same error.  

When doing a start of the services after the DB has been initialized; I get this... com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". Have verified the Server/Port pair are correct, as well as verified the port accessibility from the Flow Server to the DB.

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! 

May I ask what is the default password for fmeserver database?

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.

Hi all, Is there a way to remove the word '(optional)' when generating a Flow App?I find unnecessary text too noisy for the user...they don't need to see the text (optional) on the app. Be good if there was an option to turn this prompt off?? thanks,Tim

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.

A user created a Flow App with a data upload but the upload is not working (no response from server). The stacktrace below shows that the backend cannot connect to some HTTPS endpoint. How can I find out what endpoint it is trying to connect to? Some config variable? This is a distributed FME Flow 2023.1.1.1 installation on Ubuntu 22.04. Stacktrace from /opt/fmeflow/resources/logs/tomcat/oxdedc001svdb02/catalina.2023-11-15.log:15-Nov-2023 17:12:26.716 SEVERE [http-nio-127.0.0.1-8081-exec-9] COM.safe.web.servlet.HttpRESTModel.handleException GET:/dataupload/Korridor_B_Test/shapefile2postgis.fmw  java.net.ConnectException: Connection timed out    at java.base/sun.nio.ch.Net.connect0(Native Method)    at java.base/sun.nio.ch.Net.connect(Unknown Source)    at java.base/sun.nio.ch.Net.connect(Unknown Source)    at java.base/sun.nio.ch.NioSocketImpl.connect(Unknown Source)    at java.base/java.net.SocksSocketImpl.connect(Unknown Source)    at java.base/java.net.Socket.connect(Unknown Source)

Hey, so I'm looking at the download page here https://engage.safe.com/support/downloads/#official And I'm seeing tabs with "FME 2022.2" and "FME 2023.0" and "Past Versions". Is it fair to assume that FME 2023 is still in Beta? I think this page is pretty confusing now. I'm pretty sure this used to have a Beta section. Anyone visiting this page who wasn't familiar might just download FME2023 thinking it's ready for production... Checking the FME Cloud console I can see that FME 2023 is still listed as Beta anyone at Safe wanna fix the webpage? @andreaatsafe​ @nampreetatsafe​ @mark2atsafe​  

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.