FME Flow

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?

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":

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 transac

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.

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?