FME Flow

Every week we have a field crew collect and add data to a geodatabase throughout the week. At the end of the week the Supervisor wants an excel spreadsheet of all the data collected in that week. I have a workspace that runs FME every Monday to collect the weeks worth of data. Right now, I use a tester transformer and I pre set the dates for the following week so when the workspace runs, I have the correct weeks' worth of data. We have field in the geodatabase that collects the date the asset was collected. Then I have task schedular set to run the workspace.  My question is, is there a way to pre set the dates instead of me re-setting them every week? I have tried using Datetimecalculator but I can't seem to get the parameters right. Please let me know your thoughts, thanks in advance!   

Hi everyone!In order to reduce increases, we want to move the FME Server in the cloud, currently on the AWS platform, to the Digital Ocean platform.The best options are installation on top of Linux.I know FME will work great with Linux, our problem is that we work continuously with ESRI systems (sde,gdb), and I know it requires an ArcPro or Enterprise license, at least on Windows.Is the situation similar in Linux?I ask, because ArcGis Pro does not have a Linux deployment option.Would appreciate help!Thanks!

Hi, i have a emailer transformer in my workbench.Ik get an error:812023-4-27 10:51:20 | Python Exception <ModuleNotFoundError>: No module named 'fmepy_emailer'822023-4-27 10:51:20 | PythonFactory failed to load python symbol `fmepy_emailer.Emailer'832023-4-27 10:51:20 | Factory proxy not initialized842023-4-27 10:51:20 | Emailer_CALLER (PythonFactory): PythonFactory failed to process feature852023-4-27 10:51:20 | An error has occurred. Check the logfile above for details When i search fme support for a solution is see posts that i should remove some things in de packages etc. But in my packeges there are no files from emailer. I tried removing the root folder(system) bust it came back but still with no emailer packages. Versions of fme workbench and server are the same 2022.1 Can i manualy put fmepy_emailer files in teh map, as so where can ik find the files from workbench.

We have processes in place for ArcGIS Enterprise patching but none for FME Server.  Occasionally there is a hotfix that is released that is security related. Or last month there was an update from our vendor on their website related to CVEs and upgrading. Is there a central place that we can get this information from? Preferably without having to do a manual check on a website page etc.  I have signed up our support email to the Stay Informed email list on safe.com/downloads. Would this email list suffice or are there any other feeds that we could check in relation to security patches?

Hi everyone,We are using this web connection MS Graph Type Application https://hub.safe.com/publishers/supporter/web-connections/microsoft-graph-type-applicationWe have the required details below: - Tenant-ID- Client-ID- Client SecretHowever, this keeps expiring every hour and we have to re-authenticate every time. Screenshot of the expiry time below:Is there a solution to this? There are other articles about Microsoft Graph Teams but the configuration is different.In our configuration, we keep the default setting and I notice the grant_type=client_credentials. 1. Do we need to ask our Cloud team to grant us a refresh token & grant_type = refresh_token?2. Also, do we need to ask them to add the fmeoauth URL to the Redirect URI in the MS Graph App like how we normally do with other Oauth2 App?If these need to be added, should they be mentioned in the hub?Many thanks!

Hi ,i just upgrade FME server from 2021 to 2022.2.5 and i get this message during running job on FME server.AUTOMATIONS writer: AUTOMATIONS_2: Error, unsupported list attribute detected...is it a bug and not solved?please advise , my goal is counting records from written shapefile.also attached the log file. thanks in advance.

i just upgrade FME sever from 2021 to 2022.2.5 and i get the error:AUTOMATIONS writer: AUTOMATIONS_2: Error, unsupported list attribute detected '_feature_types{}.countis it a bug? or what can do to solve the issue.my goal is want number records from written shapefileThanks

I have an almost identical setup for a different source file type (xml) and that works perfectly, specifically the automation says it ran successfully, the jobs run as they should, and the files are moved and renamed. I can manually trigger the workbench in automations by adding the manual trigger and it performs correctly.  I tried separating that one workspace into a different automation that is triggered by a topic at the end of the first one, that doesn't work.  I can test the topic trigger and that makes the automation and workbench run, and things work correctly.  It seems I can only get it to work by triggering things manually.It works fine on desktop. The paths are all UNC. I've experimented with adding the path to resources and referring to the location using that. When things don't work, there is no error and no relevant warnings.  Thanks for any ideas.  FME Server 2022.1.3Build 22630 - win64 Desktop Client is also 2022.1.3   

Hi list.I've just upgraded our FME Server from 2020.2.5 to 2022.2.2.I'm still using the 2020 workspaces, and I've noticed a changed behaviour.I did some test with Automation a while back, and thus have some remnant automation output features in some workspaces. In 2020 these worked well, yielding no erros or warnings, but in 2022 a runtime error like this is logged:AUTOMATIONS_2: Server connection error.  Unable to send Event to automation route 'Trin2a': { ..... }Why does this throw an error ?Luckily it doesn't matter in this workspace, but I have used Automation extensively elsewhere (nightly data-imports), so I am concerned about whether my other workspaces, that have active automation logic, will work?Is the error above just a disclaimer that it didn't run in a started automation, and so doesn't have anything connected to my "Trin2a" automation feature output, and warns about it in version 2022 (but not in 2020) ?Any insights about this is welcome.Oh well, I guess I'll see what hap

I was testing an email triggered workflow using FME Server Automation and in that try to attach a file from UNC path (network path) as attachment using Global Key to pass a value to 'Email Attachment ' parameter inside an Email(Send) - external trigger . However the workflow doesn't recognize the file path mentioned in my Global Key . Alternatively if I use a file from FME Shared Source Temp directory path ,the workflow runs without any issue and I was able to receive emails with attachment. So I am not sure using file UNC network path as Global Key in FME Server Automation is supported or not. Any insights appreciated.Ex: ( Using Global Key - Not Working) global.EMAIL_ATTACHMENT = \\\\kcr-fs-v\\ShrData\\Staff\\KS\\20230419_EmailAttachTestLog.txtEx : (Using FME Shared Resource Temp Directory - Working )(FME_SHAREDRESOURCE_TEMP)/test/20230419_EmailAttachTestLog.txt

Hi, we have a process that takes an email with an .xml attachment (generated from a pdf form) and processes the data to SQL. We have an email inbox watch setup to catch any emails that come through. What happens though, is it concatenated the email subject, the xml file name ans the directory path on the server together. But if this all goes over the 255 character limit, the process fails. We have found that some users are adding extra information in the email subject ans this is sometimes taking it over the limit. Is there a way to truncate the email subject before it hits the server and stop it from failing to process?

In other words what do I put in here, FME Cloud is a linux box so I dont think it will be an exe. Many Thanks for the help in advance!

In a FME Server workspace app, how do I prevent the job from being cancelled if i close the tab or browser before the job has finished? In our case the processing of the job takes a very long time, so I don't want to expect the user to leave the tab open all the time.

Hi, I am trying to connecto to an API that supports only POST method to generate the tokens via OAuth2. After some testing and fiddling, I can see that FME Desktop (2022.2) sends first a GET request when trying to get the token. So this request is declined by the server and I cannot continue further. Is there a way to enforce POST for the whole OAuth2 flow in Desktop/Server?

I have multiple FME workflows that trigger once via my directory watch. How do I avoid a SQL deadlock since they all upload to the same SQL database table?

Is FME Server 2021.2.0.1 (Build 21789 - win64) compatible with Tomcat 9.0.72? Thanks.

Hello all, Because of this Microsoft notice on e.o.l. for .NET Framework 4.5/6/7 I got questioned of the dependencies of FME Server. A quick search both on the Safe documentation, as on the interweb did not yield a satisfying answer, so I post it here... On which Microsoft .NET components and versions thereof does FME Server depend? Will upgrading to .NET Framework 4.8 break an FME installation? Client asks for an official statement from us, or from Safe Software that upgrading the .NET framework won't cause any issues. [edit]: It involves both FME Server version 2021.1.1 and 2018.1  Kind regards, Martin p.s. I checked the Windows-FME-servers I have access to, and they all have .NET framework 4.8 installed, so I do have my gut-feelings on this subject. Also I would be more than astonished to hear Safe developing newer releases of their product using outdated Microsoft frameworks.Only those things won't convince the client involved.

I would like my automation to watch a directory. If there's a update, then the rest of the automation runs, but only during the night.I could use a directory watch trigger to run the automation immediately after a change, or use the schedule-trigger to run the automation during the night, but how can I combine those triggers?Thanks, Vera

I am in the process to change FME server from http to https per our cyber security requirements. I am relatively new to the ssl certification installation for web applications. I followed this article to install SSL certificate for FME server. https://community.safe.com/s/article/Using-a-CA-Certificate-with-FME-Server, I obtained a cer file successfully after submitting the CSR string to my company's CA authority. But this command fails to import the certificate for FME server: keytool -import -alias tomcat -keystore tomcat.keystore -trustcacerts -file D:\\FME\\certs\\hou0etgis16\\certnew_base64encoded.cerkeytool error: java.lang.Exception: Failed to establish chain from reply. I tried installing or not installing the root and intermediate certificates using the same cer file, but still the same error for the above command. Any idea? Allen 

When importing the certificate i get this error? Has anyone had this happen and what was their resolution?

Dear Community, I have set up a similar Workbench to this tutorial:https://community.safe.com/s/article/extracting-data-within-a-clipping-polygon Except I am fanning out a JSON files for each feature_type. This seems to work in FME Desktop, however when uploaded to the Server I get the following error when using Data Streaming: 1762023-3-25 15:54:00 | Cannot define schema for 'EXAMPLE_DATA' as the feature does not contain schema information, and schema source is set to 'Schema from Schema Feature'. Please verify writer feature type configuration1772023-3-25 15:54:00 | FME API version of module 'JSON' matches current internal version (3.8 20210302)1782023-3-25 15:54:00 | Writer `JSON_1' of type `JSON' using group definition keyword `JSON_1_DEF'1792023-3-25 15:54:00 | FME API version of module 'JSON' matches current internal version (3.8 20210302)1802023-3-25 15:54:00 | Opening the JSON writer with destination dataset 'D:\ProgramData\Safe Software\FME Server\resources\system\temp\enginer

IF I WANT TO FIND RELATED INFORMATION FOR A VERY SMALL AREA MAYBE A 1 MILE SQUARE AOI BUT I HAVE N SDE DATABASE WITH PROBABLY 14 MILLION RECORDS IN IT. THERE IS NO ATTRIBUTE INFORMATION THAT WOULD ALLOW ME TO PREQUERY THE DATABASE RECORDS THAT WOULD BE RELATED.ALSO THERE COULD BE 4 OR 200 RELATED RECORDS. I HAVE TRIED A LOT OF DIFFERENT METHODS. BUT CANNOT FIND A WAY OTHER THAN READING ALL 14 MILL RECORDS. AND IF I HAVE 2 SMALL AOIs THEN I HAVE TO WAIT ALL OVER AGAIN. THE SOURCE OF THE AOI IS USSUALLY KMZ LINE PLACEMARK. ANY HELP OR IDEAS WOULD BE APPRECITATED.

If there any way to configure Server Apps to have require authentication by default? Would it be possible that only an Administrator have permission to turn off authentication on a Server App?

I tried to install a python package in cmd, windows 10, but got error "This workspace requires a Python 2.7 interpreter". How do I make it use python 3.* instead? The same command worked for my colleague so something is wrong in my program setup. I have python 3 installed also.  C:\\Program Files\\FME 2022.2.2>fme.exe python -m pip install cron-descriptor --target C:\\Users\\as302\\Documents\\FME\\Plugins\\PythonERROR : This workspace requires a Python 2.7 interpreter, but FME has removed Python 2.7 support starting with FME 2022.0. Please open the workspace in Workbench to change `Navigator > Workspace Parameters > Scripting > Python Compatibility' and update the Python code to be Python 3.x compatible Failed to create Python interpreter for Python version keyword '%0'Program Terminating Translation FAILED.

Hello all,I have an ArcGIS Portal Hosted Feature Layer that has a number of sublayers. One of the layers contains photo attachments.  I've had success when the attachments are not in a sublayer using this video as a reference: FME World Tour 2022 How Do You Get 30K Photo Attachments Out of ArcGIS Enterprise or ArcGIS Online? - YouTube However, I'm stuck trying to figure out how to download the photos given they are in a sublayer. The Esri ArcGIS Portal Feature Service doesn't seem to offer the option of sublayer access. Thanks