FME Flow

We have a pair of tasks running on FME Server, the first one selects a range of records to process and builds the predicate to access them, the second one uses this predicate to read and process. The first bit looks like this... (the min and max passed parameters are my fix) so we pass _where_clause to the called job. This has worked fine for 2 years with fme 2020.2. I've now updated to desktop and server 2022.1 and when that parameter is accessed in the called job I see....so the parameter is not resolved. However if i take the min and max values from the calling model and pass them through i see...(to get the logger values I used an attribute manager to turn the user parameters into attributes ) Any idea what’s changed here? 

I've attached some screenshots to show what it's doing.It will only reset the hour back to 12 it still honors the exact minute I specify. I did look over the known bugs for 2022.x but was unable to find any mention of this. FME Server 2022.1 Build 22618 - win64

I use a python script to set up project directories for specific tasks, The script also copies the workbenches and needed and uses some regex to adjust the paths in the fmw's. Sometimes the schema of the files changes, so I would like the readers to update feature types when opening FME without having to re-import them. I'd appreciate any shared experience and hopefully an example. Thanks!

I have a legacy Notification set up with Publications, Subscription and Topic. Trigger (publication) is an email that publishes to topic. A workspace subscribed this then "Get the Value from Topic Message". In order to work with O365/modern authentication in Server 2022, I'm having to re-do this as a new style automation. I have the email part figured out. But whether I have my next 'Action' (my workspace) parsing the incoming parameter "email.body" or the "Event as JSON", I cannot get this to work as before. The existing old-style solution expected input in this format:{"imap_publisher_content{0}": "  ","fns_type": "imap_publisher","imap_publisher_sent": "   ","imap_publisher_from": "   ","imap_publisher_subject": "   ","imap_publisher_content_type{0}": "TEXT/PLAIN; charset=ISO-8859-1","imap_publisher_received": "   ","imap_publisher_to": "   "}"Event As JSON" seems to feed me more JSON than necessary. Is it really necessary, as this thread suggests, to go back to using Topics, or is 

Hi,I'm encountering an annoying issue where the DateTime picker stops working in the FME Server Web UI after the initial run of a workspace. It works the first time for any workspace, but when trying to run the same workspace again, the date time picker will not work in the UI and the date fields will be empty.Any date entered manually gets converted to the text "invalid date" in the subsequent request.The following errors appear in the console:Running FME Server 2022.1.2 Build 22627 - win64. Clearing the browser cache allows a single run of the workspace again before the issue reoccurs. Is this happening for anyone else?

At the moment we are dealing with not enough licenses, part of the problem is naturally to buy new licenses, however sometimes users have their FME workbench session open for a long time, while they are not doing anything at all in the FME workbench. So I think it would partly solve the problem of not enough licenses, if inactive FMe desktop workbenches are closed down after a certain duration. Is something like that possible to configure for the users of FME desktop. It would be nice, if the changes made are saved automatically and no changes made are lost.

At our organization, we don't have enough licenses at the moment. Naturally, part of the solution is to buy new licenses, however it would also be nice to implement something that certain users get priority in getting a FME desktop license over other users. I was looking at the following link https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop_Admin_Guide/FMEInstallation/Restricting_Licenses_to_Users_or_Groups.htm. I see it's possible to reserve for certain groups, however instead of reserving, I would like to do priotising. Is it possible to configure something like that.  

Dear all, I hope the community is fine 🙂 I am using FME Server to run a workspace that has 2 optionals user parameters published. After launching the workspace, everything is ok.Next time I go to run the workspace, the optional parameter is set with the previous value.    The user can click on the "reset" button to clear by himself, but I would like to know if there is a way to automatically clear these optional parameter values in FME Server? Kind regards, Aymeric

Hi all, Can this be done with published parameters and/or Python scripting in Server Apps? So, I would like to have two fields that are dependent. First field would be choice only and second field would be filtered based on the first field. Second field is multichoice. Only the values from the second field would be calculated for output. Example of a table with two columnsAnimal, SpecsCat, BlackCat, Halloween queenDog, BrownDog, Mr. WednesdayDog, LoyalGiraffe, SmallGiraffe, Excellent listenerSo, the first field would list all the animals and once the animal chosen, then the second field would list specifics for that animal only and then the user can choose from those for the output.Thanks in advance

I have a Server App with that converts coordinates in a Excel spreadsheet. I followed the Article:HTML Page with Link to Download Excel File - FME Server App (safe.com)And it works really well with small files but falls over with a 404 error with large spreadsheets. The workbench works fine on desktop, within Server & as an App without the webhook.Would anyone have any suggestions about what the issue maybe?

i need to get the email address from this [{""email"":""228_mg_primarydistribution@hotmail.com""}]  And  { "token": "-QPWNTxHkE4R1TM8u_M1AOUohy0X2i69BMJBEy0oUDZnqugzS4IKCWiAMrI6YqbLDxJKDyahZ0vrhoAj7FQ49EM4AWkxohFN54D5vJJLzxxR6M_3xcb2mI4iG8E0WDj3fR1my34kAB0_oRNcfNlueTm-jwpxb-OI6WxCJoLkvzaF9y74XYmGUbBeISz1Wmr-U5nFxUCrXbVOtEt5bd9Qh5qwrc9nZeZ6W7uP0oUyXs-wmqHxFxXOl7dhho4LmD-0bo2525vNwKvEZRsgfn6ep8WC264IfwNW7h7UvFX1d6Y.", "expires": 1665744258308, "ssl": true} and other query i need extract only bold values

I wonder if I setup azure ad authentication service on my FME Cloud instance, would I be able to read and write drirectly from a azure fileshare? sourceFile //xxx.file.core.windows.net/yyy/source.extdestinationFile //xxx.file.core.windows.net/yyy/destination.ext Is this a common thing?  

Hi all, We are planning our 2022 Server upgrade and it is the first time I have have done it with a parallel machine where we want to retain the original same server CNAME. We are also using IIS as our webserver with a URL rewrite. The machine is only internally available and is hosted in Azure. Our current proposed steps are to: 1. Install existing certificate on new Azure server2. Install FME Server3. Test basic server installation using localhost on the server itself4. Configure FME Server for IIS via URL rewrite based on CNAME5. Test ALL workspaces - access FME Server application via client with modified lmhosts6. DNS switch - turn off old server, turn on new server The new machine will be placed in the same Azure subnet so all existing firewall rules and whitelisting with apply to the new machine. Does anyone forsee any issuses with this approach? 

Has anyone had to switch existing notifications/publications in FME Server from IMAP which is easily configured in the web UI to MAPI? Is there a way without having to roll your own using custom code? I don't see any such options in FME 2020, nor in 2022 that I'm currently spinning up. I'm being told I need to make that switch! Lucky me 😫 

When creating a connect to AD, what is the synchronnization period?

Our fme cloud export has been going wrong for about 2 months.Every other week we import gml-files into a Postgress database. The export from our Postgress database gives errors in a small part (16 of 235) of our export files in the formats csv and shape.Only the BGT_WGL_*.shp/shx/prj/dbf and BGT_WGL_*.csv files fail. The fme scripts have not been changed in recent years.When we run the fme script locally (fme2019) on a PC the export of these files gives no errors.Has anything changed in the "FME cloud" environment lately? In some of the transformers? Last Friday (sept 16) we did a reboot of the FME-cloud environment but this did not help. Attached are some examples of a shape and csv file which look like an error file in html format.Also, we can't find any log files in the cloud of the fme creation process of the shape and csv files.These log files (which we do have locally) can help us on our way solving the problem.We also did not receive an error message that it was no

Has anyone tried do configure a FlexLM manager on a Kubernetes environment? Can someone inform me whether it is possible or not? If yes, what should I should watch out for?

Hey everyone, fairly new to FME here. I was wanting to see if there was a way to mass pull down all published layers from AGOL online into a workspace. I am wanting to automate our AGOL backups, but since we have over a hundred published layers, I was wanting to see if there was a far more efficient way of doing so than individually adding over a hundred readers.

This should still work <fmeblock><p style="font-family: Arial; font-size: 11px;">Din bestilling (id {id}) av data er nå ferdig produsert. Resultatdatasettet er tilgjenglig i 24 timer og kan lastes ned fra<br />{urlPrefix}{ResultRootDir}/{@getFileName(@zip(OutputLocation))}</p></fmeblock> However when used in 2021 it still says: https://fmeserver.com/fmedatadownload_undefined_/_undefined_ Is this not valid anymore?   According to this: https://docs.safe.com/fme/2022.1/html/FME_Server_Documentation/ReferenceManual/EmailTemplateLanguage.htm#Function

Dear FMEers, We are proceeding to upgrade to 2022.1 FME Server and would like to take advantage ofthe Azure Marketplace install option. Our cloud provider noticed that domain joining is not supported in the current Marketplace install. There are some workarounds available but this negates some of the benefit of using Marketplace. Has anyone used this configuration and what is their experience? We need to decide early next week whether to go down this route or whether to go for a tried and test traditional deployment on an Azure VM. At the moment we have a single stack and should stay this way for the next year. Any tips or experiences would be appreciated. Annette  

I want to run a SQL before a writer to a postgis database.I am using parameters to dynamically run the SQL queries. Since SQL is case sensitive and my tables include case characters I need to put quotations around my table names. But putting quotes around my statement make it a string. I just want to add quotes the parameters value.select * from "$(schema)"."(fme_feature_type)"Desired resultselect * from "MySchema"."A_Table" Is there a way to escape the quotes somehow to just add quotes around the paramaneter value.

Hello, I'm trying to implement a a html report when user runs my workspace app. When the workspace goes to failure I'd like that the server returns the log file straight to the user.

Hello,I have a (static) file in the FME Server resources folder and I would like to have a copy of this file to the output of my workspace. I tried AttributeFileReader with AttributeFileWriter. This gives a file in my output with the correct name, but it's unreadable. I also tried a FeatureWriter with File Copy but I can't get it to work.Any ideas? 

I am getting error while starting the services on local machine where I install the FME Server 

I've been digging into issues with an Engine running on a separate host in a distributed setup. Service looks to be running but is no longer chatting with Core and is not longer showing up under Engines in the web UI. After ruling out some of the obvious causes on this troubleshooting page. I've started logging running processes and ports being used on that Host to understand at what point the service goes silent or inactive. That's when I noticed what seems like large number of TCP connections FMEProcessMonitorEngines uses with multiple ports open. The Architecture Diagram and Documentation are really helpful. So I recognize the 7070 for FMEEngines services and the 7082 for Database Server but then there are a bunch of ports that I assume are what FME dynamically picks. If I only have one job executing on that engine at a given time, how many of those ports/connections will be in play? Is having 3-5 or so that I don't recognize an indication that something may not be