FME Flow

Good morning, I’m trying to automate my fme with a bat file. It’s the first one and I don’t understand what’s blocking it. I attach my bat file if someone can help me tell if the command lines or not =) thank you 

Installing FME 2023.0.1 doens't deliver the possibility to download and install transformers such as 'Emailer'. FME seems not to find the (correct) interpreter. See long error message below: "An error occurred while installing Python package with 'pip install --force-reinstall --no-deps --no-index --find-links C:\\Users\\YairLevy.AzureAD\\AppData\\Roaming\\Safe Software\\FME\\Packages\\23332-win64\\PackageFiles\\safe.emailer\\python --target C:\\Users\\YairLevy.AzureAD\\AppData\\Roaming\\Safe Software\\FME\\Packages\\23332-win64\\python\\safe.emailer --upgrade --no-compile fme-emailer' : INFORM: The workspace does not contain user Python. FME will attempt to use a Python 3.11+ interpreterINFORM: Using Python interpreter from `C:\\Program Files\\FME\\fmepython311\\python311.dll' with PYTHONHOME `C:\\Program Files\\FME\\fmepython311'INFORM: Python version 3.11 loaded successfullyTraceback (most re

Please guide me how to configure and use OpenAIChatGPTConnector. Thanks

Hello, My IT team wishes to change the IP address of the machine hosting FME Flow. The domain name remains the same. The DNS resolution will be adjusted to point to this new IP. Are there any impacts on the proper functioning of FME Flow?Thank you in advance for your responses.Lau

Hi Is there any time frame on when a version of FME will be available for Debian 12?

I'm working on a server app where users have to upload a photo taken with their phone. There's no need for them to browse the resource folders and so I've disabled access to the resources for that security token (except write access for the temporary folder where the images are stored). However, the users still have the option to browse the resource system: Ideally I'd want that "Browse resources" button to be gone and just have "Upload file". Is there any way to do that (other than write an app of my own)?

I would like to prevent a Job to be automatically restarted after an Instance is restarted. In the FME Flow documentation I saw a "Job Recovery" configuration, does this configuration option exist in FME Flow Hosted (Cloud)? Can I set the max number of retries to 0 somewhere in FME Flow Hosted?

I am getting the "Unauthorized request by user due to lack of proper permissions", none of the provided examples seems to be applicable as it should be engine agnostic, and I can run it on one of the two availible engines.. It is a simple "Read table from oracle database" -> "Write table to different oracle database" Running on a schedule it chooses Engine1 where I get the following error"FME Server error: `FME Server error: `Unauthorized request by user due to lack of proper permissions for connection: ODB . Please see: http://fme.ly/zn8'" It connects to said ODB and then connects to ODB2 and then does nothing. Manual run, it chooses Engine2: Connects and reads from ODB, then writes to ODB2

Hello, everyone! I'm new to FME and seeking some guidance. I have a dataset with numerous columns, and I need to check the values of specific Boolean columns. While I'm aware of using the Tester transformer, it becomes cumbersome to manually create multiple OR and IF statements for each column I want to check. I'm wondering if there's a way to define the columns I want to check in a separate file and have a transformer read that file to use those columns for checking. This would greatly simplify my workflow and make my life much easier. If anyone can advise me on how to achieve this or suggest a better approach, I'd greatly appreciate it! Thank you!

How I can disconnect the borrowed license for FME Desktop for particular user from Floating License Server. Users machine is not available for disconnection so looking to return FME Desktop borrowed license from FME License server

Is there a method to read all workspaces on a server ex. list all workspaces that have specific transformer or list all workspaces that have specific parameter.  Also, where are workspaces on a server? Is there a Folder for workspaces? Are they ascii readable? Thanks in advance

I am writing to postgres/postgis st_geometry in an autmation that is loading many dwg datasets. (runs workbench on each dwg)The postgis writer shows that ver 14 ignores writing od. I need to get an oid calculated beginning with the last oid used (in the previous automation) NOTE: postgis writer specifies that oid is ignored at postgres 14. I tried just using a counter and hoped that writing to existing would automatically write the oid. (I get an error the oid already exists).I am using this oid as the primary key so that It doesn't have to be set when adding to esri. I have attempted to read the flat postgres table and sample the last n and then use that as a parameter to set the start number of the counter. But have not been successful getting that to work.Any ideas on how to do this? 

I have debug logs and found that in the one that has stopped working the request is incomplete:GET /sharing/rest/portals/self?f=jsonThe request in the other add the token:GET /sharing/rest/portals/self?f=json&token=.....Trying to determine if this is a problem on the AGOL side or FME side. Any ideas would be appreciated!Also having the same issue on Desktop.

HiI'm working on a project where we are migrating from a solution based on subscriptions into more automations. I ran into problems when I try to pick up the topic name from fme server parameter FME_TOPIC. Inside a workspace triggered by a subscription all is fine, but when a use automation with a FME Server Topic Trigger, the value of FME_TOPIC is a GUID like string. First part of is the same as the automation id. I have no problem with FME_TOPIC_MESSAGE parameter. Any ideas? Thanks, Stefan  

Hi, I am new to using data download or streaming in FME Server, I have only used job submitter up until now. I am wanting a very basic workspace to generate a CSV which is then returned to the user via the web browser, once they run a fme workbench via FME Server directly (Server App).  Does anyone know which method would be best to return just the CSV file, on demand, direct to the users web browser for download? I am looking through the help files for examples on best practice, but its all a bit confusing. I have currently got a workbench published to server, and its using data download as its registered service, but it keeps downloading a zip file with a half dozen sub folders within, then my CSV file with its associated data. I am presuming I have over complicated things. In essence, I am hoping to get the results of this workbench to the user via a CSV which they can download to their PC: 

Having a SDE Geodatabase and a Feature Class called `Park` can someone please let me know what Triger Event I can use to be notified and action when a New Feature added into the `Park` Feature Class by user 

In an automation, we are utilising an automation writer to pass a dynamically created json syntax for sending an email to a relevant FME Server topic. e.g. { "email_to" : "<to email>", "email_cc" : "", "email_bcc" : "", "email_from" : "<source email>", "email_replyto" : "", "email_subject" : "Hi", "subscriber_content" : "its me again" }  The topic is however sending this as "content" rather than breaking it down into relevant parts when it is passed in as a variable from the automation writer (in this case {route.Output.text_line_data}) However, if I past that same hardcoded text value into the notification, rather than have it come from the automation value, then it works.  We utilise a email subscriber to send all emails, rather than setting up individual email sendi

I have an automation that is triggered when the user enters a record into a database. When that job fails, it would be helpful to have a link directly to the job details in the log file. When the job fails, it sends a failure notification email from an FME workbench that is part of the automation flow. It does this via the emailer transformer. Is it possible to add a link to the log file for the specific jobs that are triggered? Is it better to do this inside or outside of the workbenches inside the automation? Thank you

FBX is EPSG:2326 coordinate system. VRML (*.wrl) converted is (Y and Z coordinate swapped)

Hi,I want to upgrade our FME server 2022 deployment to Flow 2023. We have a three tiered deployment:VM with Core and WebVM with 2 enginesSQL Server with fmeserver configuration databaseNetwork share with configuration directoriesI want to deploy Flow 2023 to a new set of VMs and then cut our DNS over once the deployment is complete, so there is no outage time. However, the point of failure is the database. If I remove it to deploy the 2023 Flow db then the 2022 FME server will stop working.So, can I deploy the new FME Flow with a custom database name - say fmeflow2023? Or is there another way of solving this that I'm not aware of? Thanks,Marc

Hey there,I have written a workbench where I get some data from some weather-stations and generate the average temperature for that station as a line in a new Excel file. It works great but we have 100 Weather stations and I want to make it with all of the stations and get the excel file with 100 lines... I imagine it like:for i in 0..99 loop getDataFromStation(i) processData() writeDatain Excel(i)end loop But I have no way to do those loop in FME Desktop or Server. Or at leat I do not find it...Has anyone any idea?thanks a lot

I have a Fault Tolerant installation of FME Flow that includes a load balancer. I need to use IMAP email protocol to receive emails from FME Flow. ​I have created an automation and want it to send an email if succeeds. In the Automations screen - Email Details, I choose Actions - Send an email. I then see the SMTP parameters, but nowhere found is IMAP protocol parameters. How do I access IMAP protocol parameters if I want to Send an email?

I have a workspace where the Reader reads an Access database using a lettered drive path (K:\\projects\\databases\\access.mdb) The Writer writes to the same database using the same lettered drive path. When I publish this workspace to FME Flow without uploading/selecting files, the Database Path under Published Parameters is empty. ​But, when I change the database paths in my workspace to a UNC path (\\\\gisserver1\\projects\\databases\\access.mdb), I publish the workspace (without uploading/selecting files) and I see the UNC path to the Access Database populated in Published Parameters - Database Path. ​If my workspace reads from a lettered drive path and the database is Microsoft Access, when I publish the workspace, do I need to upload/select files? This would upload the Access database to FME Server.

Is there a way to customize the webhook url in FME flow hosted?

I have created an Automation in FME Server. It is triggered by a Schedule and runs a single workspace. What is the best way to have an email automatically sent to me notifying that the automation has finished running and succeeded or the automation did not succeed.  In FME Server, I see under Automations - Notifications (Classic). But I am not clear on exactly how to set up the email notification. Here is what I have done so far, and it does not seem to be sending me an email after the automation has run. Any suggestions?