FME Flow

 hello everyone I want to produce a point from this data in text format and the XY values ​​I need are in a single stub. The FME dataset area is common for x and Y. I will bring these XY values ​​side by side and produce a point from the vertex creator, but I did not know how to do this.

Hello there, I looked into FME system parameters and Python APIs to find a programmable way to identify release info, such as 2023.2.1, etc., in an FME Form session, to no avail. I would appreciate you sharing your approaches. Bo

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

Hi,I'm trying to ingest log files into Azure monitor so I can send out organisation wide notifications but i've run into an issue. When I look into the machine that flow is installed on, I can see that it is storing logs in folders in batches of 1000 and it will create new folder each time it hits a multiple of 1000. I can process files into Azure, but this doesn't seem to work with a wildcard in the /current/ folder - it needs a folder that already exists. Is there a way to write these logs all to the same folder? The file pattern/query i'm using: C:\\ProgramData......logs\\engine\\current\\jobs\\*\\job_*.txtMany thanks, Sam

QUESTION: Is there anyway to adjust the login timeout for MS SQL connections? Periodically, I've been logging an error from the SQLExecutor transformer which appears to be related to timeout issues when connecting to a MS SQL database. The error below seems to occur at random and is hard to replicate on demand.  'Provider error (-247467259) Unable to complete login process due to delay in opening server connection' I suspect that the connection, periodically, is talking longer then the timeout configured in FME. I know of the 'Command Timeout' parameter but as I understand it this is only applicable to the query length timeout, not the login connection timeout

Buenos días, tengo instalado FME en un equipo que va muy lento, ¿Podría desinstalarlo de este equipo lento e instalarlo en otro que acabo de comprar mucho más potente?

What Parameter should we use to connect to .sde(s) file uploaded  to File & Connections-> Database Connections, on Flow?$(FME_MF_DIR)part_etl_server.sdeUsing above parameter we are able to connect the part_etl_server.sde which we attached into script publishing from Form but we need to connect into what we already have on server? Thanks

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!

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.