FME Flow

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?

I need to publish a workspace into FME Server that has a disabled connector and disabled transformer. In FME Desktop 2021, the workspace can run successfully with these disabled. If I publish this workspace to FME Server 2021 and create/run an Automation, will FME Server recognize the disabled connector and transformer and not run them?

hi i have to add some properties in the ifcpropertysinglevalue for the objects in an ifc file but those properties i need to inject them in a certain propertyset and under some conditions ( if i have for example IFCFLOWFITTING i need to add x properties ?

I'v been succesfull in loading additional python site-packages on FME flow hosted.Now I have a site-package that needs a newer verion of numpy then the one that's allready in the standard installation.Can I upgrade numpy on the FME Flow hosted environment? 

I have a service that runs on a schedule that regularly fails to connect to a hosted ArcGIS Online service. If I manually resubmit the same failed service it succeeds. I have other scheduled services that use the same AGOL connection without any problems. I have tried recreating the scheduled task, republishing the service, and re-authenticating the connection. Does anyone have any ideas why this scheduled service is failing but succeeds when manually running and other scheduled services using the same AGOL connection succeed?

Hello all, I have had an automation running for the better part of a year and I set it up to send me emails (post topic on failure). I needed to revise this and set up 2 separate automations to separate the types of jobs, daily vs every 30 minutes. Prior to setting up the new automations, I stopped the original and deleted it. It is still sending me emails now. I also made sure I replaced every instance where it was tied to a schedule, and I deleted the topic itself, and I am still getting emails. It has been stopped and deleted for over a month now and I am searching for a solution to end the emails. Any help or suggestion would be appreciated. Example below, it is sending failure notifications from over a month ago:{"automation.id":"cac0de02-77e3-4c13-b330-dba1175dfaf7","workspace":"CMPT CG Future Allocation VW.fmw","timeRequested":"Wed-31-May-2023 05:00:00 PM","requestKeyword":"SERVER_SCHEDULER","ti

Error executing SQL command ('TRUNCATE TABLE "quali"."wa_hydrant"'): 'ERROR: permission denied for table wa_hydrant'Error truncating table 'quali.wa_hydrant'. Assuming table exists and attempting to appendError executing SQL command ('COPY "quali"."wa_hydrant" ("gis_id", "gesellschaft_bd", "gemeinde", "standortwerk", "_rbe", "_fehler_nr", "_fehler", "_pruefdatum", "_fme_prozess", "_temptext1", "_temptext2", "_temptext3", "_temptext4", "_temptext5", "_temptext6", "_temp_num1", "_temp_num2", "_temp_num3", "_temp_num4", "_temp_num5", "_temp_num6", "fstatus_id", "geom_pt") FROM STDIN USING DELIMITERS ':' WITH NULL AS 'NULL''): 'ERROR: current transaction is aborted, command

We (rarely) get a glut of job submissions to some of our FME Server queues (Running on FME Cloud).  These glut of jobs usually come from someone who has automated a bunch of submissions (we're totally fine with that). We want these jobs to be processed, but at the same time we still want to be able to handle other user requests in a timely manner. I created an idea over here which would help me: https://community.safe.com/s/bridea/a0rDm000001Sf7kIAC/option-to-move-submitted-queued-jobs-to-new-queue It outlines the scenario in more details. Just looking for tips or idea on how to work around this. The service in question is essentially just a clip and snip but depending on what the user wants the request can take anywhere between 10 seconds and an hour or so to process.

I'm just wondering if there's an impact on performance having multiple automations running constantly. They are triggered by a schedule within the automation to run once per day.

Is it possible to use FME Flow Hosted with a Remote engine located on an internal network. Thinking that this configuration would minimise FME Flow core maintenance, Simplify firewall rules, provide access to internal network resources like file system shares and databases... If it is possible, is there any documentation on how to setup this configuration.Cheers,e. 

Hi All We've recently deployed FME 2021.2.0.1 Desktop (64-bit) to a new server environment shared by many users.After some time we realized that this installation has somehow changed File association for JPG to associate with FME Data Inspector. This is unintended and very undesirable. What's the best way to reset the JPG File association to whichever program it was prior to the FME Desktop install? If I change this setting manually through Windows options (assuming I get local administrator rights), does this get propagated to all user profiles? Also we are running a Citrix server environment. Any help is much appreciatedThanks! 

When I install a new version of Desktop on my (Windows) machine, all my file extension defaults are reset. (I have to choose which software I want to open a .xlsx file when selected in File Explorer, again.)  I think this is recent behavior? Do I miss a setting during installation? Can it be made undone?

Hi, I have a spreadsheet in sharepoint where one of the sheets needs to be updated weekly, from another sheet that is in another file in sharepoint.  I tried using the sharepoint connector but it makes me lose cell color, formulas and other formatting. The ideal would be just to delete a sheet inside a sharepoint file and insert a new sheet, without harming the other sheets. How can FME help me with this?

We sometimes have a problem with our MQTT-connector that is disconnecting (always running on our FME Server), but it only shows in the log as a warning. 21318 2021-5-17 11:08:21 | MQTTConnector: Unexpectedly disconnected from broker. Will attempt to reconnect automatically... Error: Connection Refused: unacceptable protocol version. Restarting it works just fine, but it didn't try to reconnect, or at least no log message about it. It was haulted like that for 10 days until I manually stopped & started it … When this happenes, the job seems to be running like normal, and you manually has to go into the log (when running) to see that the job has stopped receiving data from the MQTT-provider. I had to implement a separate test on a different FME Server job to check whether sensordata came in or not, but the optimal would be to get a notification (eg. by email) if the connection is not reestablished within a few seconds. Looking forward to suggestions & future updates. Kenneth.

I created an FME Server role that provides read-only access to view FME workspaces published there (i.e. - Workspace Viewer). I would also like to add read-only access to view items under Schedules but only see options for Full Access or None for a role's permisssions. is there a way to provide read-only acccess to Schedules? We are currrently running FME Server 2020.1.2.1 (Build 20624).

I have a flow source Movie    Role    ActorM1         R1        A1,A2M1         R2        A1,A3M2         R1        A2 and I need to switch to the vue Movie     R1      R2M1      A1,A2    A1,A3M2        A2how is it possible, I tried AttributePivoter but didn't find a way to switch rows to columns. The Roles list is not known before, so it should take all unique roles as columns.

Hello,  Currently, I'm having a delay and I don't know how to fix. The FME server time is not the current time, instead it is the time UTC that is displayed. How can I change it? 

Trying to install on my mac, silicon version. Have uninstalled one version completely. New version still has the same bug. When loading a package, going to database connections etc: Failed to install web service '/Users/xxx/Library/Caches/Safe Software/FME/Packages/23319-macosx-aarch64/PackageFiles/safe-lab.genai/web_services/OpenAI.xml'. Reason: Unable to read from file '/Users/xxx/Library/Caches/Safe Software/FME/fme_publicKey.fmeks', No such file or directory (Code 2) I checked for the folder and it doesnt exist.