FME Flow

Hello. I have a workspace that runs locally, which takes two user inputs (stored as user parameters) - a start date (the first date of the PREVIOUS month) and end date (last date of the previous month). When the workspace is run it asks for each date from the user, and they would provide them as '01/03/2022', for example. The dates are then fed into an SQLExecutor and used to help query our database. The workspace is run each month.  I would like to run this process automatically on FME server, but to do this obviously a user can't manually specify dates. I therefore need a way for the bench to generate the start and end dates of the previous calendar month. The bench would always be run on or after the first day of the CURRENT month, but not always on the same day (so I can't just use today's date minus a day, for example). I'd prefer to do this in FME, but if it has to be done in the SQLExecutor query that would be fine as well.  Thanks in advance.Liam Riddy

Hello everyone!I recently saw two very interesting webinars regarding Data Streaming.We want to prepare for our customers proof of concept on the subject.I am looking for a free or low paid data source from which I can extract data and show to our customers.Is there such a data source that can be selected by a particular country, and type of data? (IoT, GPS, etc.).Thank you!@stewartatsafe​ 

I have the FME server in english (version 2021 I think) and I would like to change the language. When I open my apps, It asks me "to upload the file" and I would like to put this message in french. How can I do ? Thanks you

Is there any guidance on installing FME in AWS? The same question (https://community.safe.com/s/question/0D54Q000080hH8aSAE/installing-fme-server-on-aws) was asked 2 years ago but wasn't answered. Kubernetes and FME Cloud are not options I can use unfortunately. I would like to use ephemeral machines that can scale with demand and be auto-replaced if they become unhealthy. I'd also like to simply replace the servers using newer versions of the AMI when OS patches or FME updates are released (I don't want long running servers that I have to nurse and treat as pets). I would like separate auto scaling groups for the engines so I can spin up as many as I want when they're needed and don't have to run more powerful (and expensive) servers when their not required. I might potentially have multiple queues for different types of engine (maybe with different operating systems). I'd need to be able to inspect the queue to know when to scale out/in. I've looked at doi

I have a working Automation that is triggered by either a Schedule block or a Webhook block. It includes a number of "run workspace" actions in series, the first of which currently includes user parameters with values that are fixed in the Automation, one of which is a datetime parameter. I would like to pass a datetime value in the body of the webhook POST, but it appears the first workspace block does not show the "Use a value from upstream keys" for the datetime user parameter, presumably because it is not an ordinary string. Is there a way to accomplish this without changing the user parameter in the workspace to an ordinary string?

I have a directory watch on a network folder and I can successfully trigger the subscription by adding a file to that folder. I can see that the workspace is triggered as well. However, what I'm still trying to figure out is how to pass the path and file name of the zip file placed in it to the workspace. What would the input parameter need to be set as in the workspace? Currently I have it set to a published user parameter with no default value. In the subscription configuration, the "Source Zip File" parameter is set to "Get Value from Topic Message". However, that parameter evaluations to the path of the JSON file created with the topic is published to, not the zip file path. From the log:FME Configuration: Command line arguments are `fme' `Test\\LaTaxTableImportForDirectoryWatcherWBR\\LaTaxTableImportForDirectoryWatcherWBR.fmw' `--SourceZip' `$(FME_SHAREDRESOURCE_SYSTEM)temp/subscriptions/c2177f37ebd94805bd9717d51d228e46.json' `--FME_TOP

I found in the documentation that the recommended destination for installed custom python packages is: Windows: C:\\Users\\<user>\\Documents\\FME\\Plugins\\Python How would I make the packages available to all users of the computer? Help page: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/Workbench/Installing-Python-Packages.htm Best regards,Stefan

I am trying to setup a workspace automation but when i point it to the workspace i want to run it says there are "No Parameters Available" for me to establish. However, when i navigate to the Workspace itself (outside of an automation) I see all of the parameters. I recently upgraded to FME Server 2021.2 and am using Workbench 2021.2 as well. It is an existing Workspace that was authored in a previous release. I opened it in 2021.2 and published it. I copied the contents into an entirely new workspace and published that with the same issue. I authored a simple workspace (XLS->FFS) and the Parameters showed up as expected so I think it may be something to do with the Workspace. It is rather large and I dont want to have to redo the entire thing. Any help would be much appreciated.

HiI have a workbench published as a download service and i can run it from the address bar in my browser using... http://<server>//fmedatadownload/<repository>/<Workbench>.fmw?--TIMESERIES%20%22OP%22where the parameter --TIMESERIES "OP" is as specified in the FMW. however this parameter is ignored it appears.I eventually want to run this from the HTTPCaller and there I can't seem to avoid getting "=" between the name and value which again is ignored. So, i guess the questions is how do I translate workbench parameters to add to the url string?

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {228826AF-02E1-4226-A9E0-99A855E455A6} and APPID {2FD08A73-D1F1-43EB-B888-24C2496F95FD} to the user <user> SID (S-1-5-21-73586283-1409082233-725345543-564895) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.

Hello, Is it possible to get the FME JOB ID from inside the currently running workspace? I have a database that should be updated multiple times during a workspaces run. I would like to update this database from within the workspace itself, but one of the parameters I need is the the FME job id and I cant seem to find a way to get it from within the workspace. Thanks,Samuel

Dear all, I am currently facing a strange behaviour with my writers parameters.I have a got a workspace writing 2 distinct text files in the same destination folder.When publishing the workspace with a data download service in FME Server, I cannot distinguish them because both are <not set> [TEXLINE]Any idea where I can set up kind of an alias or name? Thanks in advance to the FME community.

How do you enable "Resources" tab within workspace application?If I run my workspace in FME Server and want to input source file > Browse Resources.I get the Resources tab (highlighted in Yellow)I have created a workspace application and when you select > Browse Resources. I don't get the "Resources" tab in the application? I'm pretty sure it probably has something to do with how the Resources are shared in FME Server, I have pretty much shared I believe out to everyone in FME Server. Example of resource sharing below: Pretty new to FME Server so I'm sure it is a very easy change.Thanks in advanceBrendan

Hi, I'm currently sending a excel file via a XlSXW writer with FME SERVER. I am able to receive it with fmedatadownload as a zip file. Is there anyway to received it unzip, just as a .xlsx?  I saw in the documentation the following:The download is returned as a zip (compressed archive) file for the following reasons:The result is a number of output datasets (not just one dataset).Folder-based datasets do not consist of a single file; for example, ESRI Shape format has files with the extension .shp, .shx, .dbf, and some others.Even file-based datasets may consist of more than one file; for example, a GML dataset includes both a GML file and an XSD (XML Schema Definition) file. So my guess is that its not possible to receive it unzip.  Thank you in advance, Ian

We have several workbenches on server that we had set up to use the Download service to allow us to extract sections of national datasets for queries and plan production purposes. However, recently they have stopped providing the download links to the results and any new workbenches we've published to the server are also unable to provide links to download (these have also been set up with the download service). The workbenches are able produce the results, it's just not returning any links.Any ideas on what could be causing this would be appreciated.

I have a workspace on FME Server which is initiated by a webhook. There is always an XML that comes with the webhook. The XML is passed into a parameter for the workspace. The workspace parses the XML and processes it into a database. Occasionally, the workspace fails or is aborted. I would like to try to run that workspace again or at the very least extract the XML payload.  When the workspace fails (could be because the XML had an incorrect value or there were network issues), is there any way that I can retrieve the XML? Further, and this is probably more critical, if the workspace has been aborted (perhaps it was accidentally cleared from the queue), can I retrieve the XML? Or reprocess the message somehow?  If I try to resubmit the failed job again , it doesn't seem to have the XML anymore. Or do I have to send the message again from it's source (Maximo)?

We do have FME Server setup on Ubuntu OS, and some of our big data stores are in windows file shares AWS FsX. Our users would like to access windows fileshare from FME workspaces in the FME server. Any ideas on how we can achieve this?

Is FME Server affected by the recent vulnerability discovered in Spring Core? https://www.contrastsecurity.com/security-influencers/new-spring4shell-vulnerability-confirmed-what-it-is-and-how-to-be-prepared

Hi, Our FME Server infrastructure is deployed in AWS on Docker, Core is running on dedicated EC2 with docker and engines are running on docker + EC2 which starts as users start the job. I have a user who has a workflow that uses python script. We followed the documentation and asked the user to upload the module to Resource>Engine>Plugins>Python FOlder. After uploading the module user is still facing the error. I am suspecting this is related to the path where the module is and where the script is looking for the module. Most likely, I am not the first one to encounter this but I could not find any documentation or community post with examples that can help us solve this situation. Any pointers? Thank you in advance. -Naman.    

In my automation I want to include the server name in my success / fail emails. That way from the email you can determine if the emails is coming from the dev / test / production server. Can not find the server name as one of the keys available.

Hi All,Running an automation to pull data from an external SFTP site to be post processed with multiple other workspaces.I've set the time per my server at 4:15 am (and tried 4:30am, now trying 5am), have checked my server, it is set to EST (UTC - 4 since we are in DST now). Schedule trigger states that it uses the local time on the FME server). Looking at the SFTP thin client website, the data says that it was uploaded at 4am today. When looking at the same SFTP site via WinSCP, it says that it was uploaded at 12am today.My automation appears to be working as it should by processing all of the data. However, it is consistently having the previous week's data (it is only uploaded to the SFTP site once a week and I process only once a week). What time should I really be using for getting this data? When I trigger the automation after 8am EST it picks up the currently shown data (although it is dropping it on the server with the 12am timestamp). I would have thought that i

@stewartatsafe​  , you mentioned the modification of templates in :https://community.safe.com/s/article/Deployment-options-for-FME-Server-in-the-CloudI could not find any example (or even better step by step tutorial) to adapt the Azure distributed deployment template to be "ESRI server compatible". The engine instances should have the ESRI libraries included if I understood well. Do you have any kind of resource or advice in this regard? Thanks in advance!Antoine.

I have a working Postman script for an OAuth2 connection.When I look at the raw headers it shows that it sends the following headers:Content-Type: application/x-www-form-urlencodedAuthorization: Basic QjIzRkI3RUU5RTZDRZZZQTRCRDJGNjVEOUM5ZZZxNjE6QzAzM0ZDOTU0RjM5NDQ1Qjg2RjdCOUQ1QzlGQzQ2MDYwM0Q1QkUwNEIzMEE3ZZZDMzFCMTI5NzM5M0MxQUMwRQ==User-Agent: PostmanRuntime/7.29.0Accept: */*Cache-Control: no-cachePostman-Token: a8126467-b10d-4a59-b116-f8a6d1160aa8Host: projectlocation.relaticsonline.comAccept-Encoding: gzip, deflate, brConnection: keep-aliveContent-Length: 182Cookie: SESSION_START_COOKIENAME_29C5C999-84D0-4D23-A8F0-F888A8C64C78=trueBut if I add a new Webservice with the OAuth2 template in FME it looks like it is sending:https://projectlocation.relaticsonline.com/oauth2/token redirect_uri=https://localhost/client_id=12345567890client_secret=ASDFJKLgrant_type=authorisation_codecode=[responseCode] Accept=application/jsonContent-Language=en-USContent-Type=application/x-www-form-urlencodedI

Hello, I encountered an issue using FileDeleter as it fails to delete the files. I have some scripts deployed on FME Server that download some xls files daily, perform some reports and next day, new files are downloaded,and the old ones must be moved to an archive and delete the target file or folder. I get the next error when the transformer FileDeleter is trying to dedlete the files from previous day in order to download new ones. This error is not present in a Windows env (now I am trying to replicate that FME Server installation along with it's scripts on unix env...maybe this can be an issue?) Error: " 2022-3-29 13:58:28 | File Copy Writer: Error attempting to move from '/opt/fmeserver/resources/data/Reports/temp/route_gps_pos_arc_20220329.xlsx' to '/route_gps_pos_arc_20220329.xlsx'. Please check for sufficient permissions on the source and destination. Alternatively, if Overwrite Existing File is set to 'No' please ensure output file does not alre

Suppose I have two workspaces A, and B that run sequentially in a scheduled job. I want to start B if A actually runs through and writes something to the writer. If nothing writes in A, I don't want B to start at all. I could think of a few ways to do it, but all require writing intermediate status data to an external file or database. Should there be a simpler way to do this in the FME server automation (I am at 2021.1.2)? Is it possible to do this in the startup python script - if a condition is not met, terminate the workspace?