FME Form

Using a RabbitMQConnector in Stream mode to continuously listen for change events. It is set to not Auto Acknowledge messages as we do not want that to happen until confirmation it is written to the database. Was thinking to use a FeatureWriter as it chains outputs after writing. Doing this with Transaction Type of None and it inserts/updates the features in real-time fine. But the output from the FeatureWriter seems to always be blocking. We ideally want to use that output to acknowledge the message in RabbitMQ. Would try a SQLExecutor but also need to write the shape to an ESRI geodatabase. Worst case can probably use a PythonCaller using arcpy. But would be nice to have a persistent connection with an actual writer. Any thoughts on how to do something like this while keeping a data steam going?  

I am wondering about how it works if you want to have mulitpled editons of FME Desktop using the same Lic seerver, so floating lic. So say if we had 10 floating lic, and had 8 ESRI Editions, and 2 professional Editions how does that work on a Lic server, can users pick an edition when they start FME Desktop ?, or do you have to set up user groups for specific edtions, or would you need 2 lic servers, one for each edition ? Just trying to understand how this would work and what the options are for users to be able to choose an edition.

My organization is upgrading to FME Server 2021 (from 2018), and we'd also like to update our authentication method from Windows Directory to Azure.  I restored the backup configuration from our FME Server 2018, so all our user profiles are coming from the Windows Directory. I have successfully set up a connection to Azure and can import new users (the user says Type = Azure AD), but is there a way to migrate my existing users from Type = Directory Server to Type = Azure AD? Alternatively, I could re-import all my users from Azure AD and re-assign roles, but I was hoping there would be a way to switch the authentication.  Thanks

Hi,I'm looking to see if I can retrieve all tables with the same prefix and then save the table content with a dynamic writer in shape format. For this I start with a SQLCreator with the query:select TABLE_NAME GV_TABLEfrom colswhere TABLE_NAME like 'AB$_%' escape '$'and TABLE_NAME in(   select object_name from user_objects where object_type = 'TABLE') The result is then picked up in a SQLExecutor:select *from @Value(GV_TABLE) Attributes to Expose is left empty in the SQLExecuter. The result of the SQLExecuter looks like empty records but if you look with Visual Preview the attributes per table are present. With a dynamic writer I try to write to a shape file per table. The writer does not write anything. So is it possible to make the attributes visible after the SQLexecuter? Attributeexposer does not have a *.* wildcard.

Hello FME friends, Server Apps TroubleshootingAs I mentioned previously, I'm getting a weekly report of new and updated knowledgebase articles, and the one that stood out this week is FME Server Troubleshooting: Server Apps. Besides simple troubleshooting steps, there are a number of FAQ-type issues, such as "Why don't users have the ability to upload files to my app?" Solution: Ensure the "User Can Upload" setting is enabled.  Also, there's an interesting issue where the OK button doesn't work (answer: there's a user parameter that's hidden, but is required and has

Hi,I want to read google sheets with FME, in order to update AGOL feature service.On my Google drive, I have a folder "HEBERGEMENTS", with 9 spreadsheets.In FME, I defined a Google Drive Connection, and I use the GoogleDriveConnector. I can access to the folder HEBERGEMENTS, but when I run the connector, it reads nothing...Is there a option to see files ?I don't understand...Because the goal of that is to run my workspace with a batch.Thank you very much for your help !Christine  

Hi! I just want to know if this is possible before I start to dwell deeper into it.  What I have is a web-application created in ArcGis Portal. I can select points within the app using a polygon. What I need is to be able to send only the selected points to an FME-script that should run and do an analysis on the points, all from within the web-app. The point layer is published to ArcGis portal and its stored inside a PostGis database. Is this possible at all?  

I need to use a unified database connection string which contains primary and secondary/DR database. Secondary /DR database is an exact replica of primary database. When the primary database is down , it should automatically connect to secondary database. All my existing workspaces are configured considering a single database connection . With the change to include primary and secondary db connection, can you please suggest how I configure this FME with least number of changes since it has an impact on all the existing workspaces.

I am trying to read this wms-service/url using the featurereader (espg 3857): https://geoservices.knmi.nl/adaguc-server?DATASET=RADAR&SERVICE=WMS&&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&LAYERS=RAD_NL25_PCP_CM&WIDTH=1131&HEIGHT=489&CRS=EPSG%3A3857&BBOX=-199509.20245398767,6500000,1419509.2024539877,7200000&STYLES=radar%2Fnearest&FORMAT=image/png&TRANSPARENT=TRUE&&time=2022-01-05T14%3A40%3A00Z Somehow this gives me the wrong return, what's more: If I change the date/time the result stays the same, which should not happen Using the exact same url in the httpcaller and saving it as a .png gives me the proper result (but i dont want t

Hi, Is it possible to supress certain warnings in the translation log?For example, when i use a Oracle spatial reader with 2 or more geometry columns I use the parameter "Spatial Column : GEOMETRY1". In the translation log I get: Column `GEOMETRY1' of table `A_TEST' has been chosen to hold the geometry. I would like to remove such warnings in from the log.    

I am using the http-caller to upload attachments to a arcgis portal via the addAttachment in the Rest API. It works fine to upload but the image does not behave in the same way as when I make the post with postman. The attachment link in the portal downloads the image instead of showing it in the browser. This is not the case with Postman. Any help appreciated

Hey, I am trying to modify https://community.safe.com/s/article/data-distribution-fme-server-app the data distribution demo script. I am attempting to download 5 different shape files (points, polygons and lines) all with varying attributes. I have the script working and downloading with the exception of the attributes specific to each feature class. Every attribute is blown away. If I change the user attributes to automatic for the output feature class it sort of works except its merging all the attributes together and showing them in every feature class. Ideally I just want to download the 5 shapes and retain their unique attributes. Seems I can either output the shapes with no attributes or output the shapes with attributes from other feature classes m

"Feature Tables" - the buzz word heard around the 2017 FME UC, is now referred to by a more intuitive term "Bulk Mode"... The CSV format has been updated for amazing performance increases, but for what transformers and formats can I expect to see benefits from Bulk Mode? 

Hello, Is there a way to automatically detect datatime fields from a reader reading many tables (at least 2k) and convert them to a different format?

I have Workspace where shapefile has polygons they overlap so i want they should be no overlapping . lowest values are normally on outside so I start clip with the next highest values then you move from low to high 

Since our migration from FME Desktop+Server 2020 to the following versions, it is not possible to guarantee the order of execution for our readers. With the first reader and its transformer I want to download three zips. With the second reader I read those zips, extract them and export them to a database. With FME 2020 this worked fine. With FME 2021 and 2022 it seems that the reader order in the navigator pane is not recognized. Any idea? Thanks in advance!

Currently, I have a dataset which looks like this:I am wanting to produce something that looks like this:Rather than having each different activity displayed as a separate field name, I simply want to convert this into a single field name "Activity" then list the different activity types as a value on separate rows instead of the field header. I then want to apply the relevant frequency field to each activity. Anyone have any ideas? Thanks in advance

The usage notes in ProjectWiseWSGConnector states:The FeatureReader can access ProjectWise directly (without using the ProjectWiseWSGConnector), however, a local copy of the dataset will not be created. But how is this done?  Thanks in advance.

The error in log isERROR |GEOJSON writer: Transcoding the binary string '\\xFF\\xFF\\xF9\\xFF\\x02\\x00@5^:\\xBF$)A`;\\xDF\\x0F\\xCE/)A(1\\x08,\\xC1$)A`B>\\x88\\xCE/)A\\x16\\x00\\x00\\x00E\\x00x\\x00p\\x00A\\x006\\....0' to another encoding can not be doneWhat's this mean?

I have an OS mastermap GML data file. I have multiple <osgb:changeHistory> tags for one particular featureID. Which is as below: <osgb:changeHistory><osgb:changeDate>1998-07-03</osgb:changeDate><osgb:reasonForChange>Modified</osgb:reasonForChange></osgb:changeHistory><osgb:changeHistory><osgb:changeDate>1998-07-03</osgb:changeDate><osgb:reasonForChange>Reclassified</osgb:reasonForChange></osgb:changeHistory><osgb:changeHistory><osgb:changeDate>2002-08-12</osgb:changeDate><osgb:reasonForChange>Attributes</osgb:reasonForChange></osgb:changeHistory><osgb:changeHistory><osgb:changeDate>2003-10-14</osgb:changeDate><osgb:reasonForChange>Position</osgb:reasonForChange></osgb:changeHistory> I am trying to read al

Hi,This isn't so much a question as pointing out a minor issue.The WorkspaceRunner transformer (FME 2022.1.2) doesn't allow the user to select an attribute value for the value of a parameter in the workspace to be called if that parameter is in a group:

I have a dataset of parallel lines that I have buffered (150ft) and dissolved into one polygon. My question is, is there a way I can preserve the actual flow (direction) of the main buffer, and split out where the buffer separates from the main path? I want to keep the main segment as one feature, and where it splits as a separate feature. In the image below kind of explains what I am attempting to do. Segment 1 would be one solid feature, while segment 2 would be another solid feature.    

From original source data, I already have created four corner points (in red) with correct XYZ values. I just need to connect these points and create polygons at vertical plane which will vertically intersect existing gray polygon at XY plane. Any suggestion ? Thanks.

Hello FMEers,Welcome to What's Up Wednesday. Academy UpdateThis week, the FME Server Authoring Trail has been updated on the FME Academy. As you might know, a "Trail" is an extensive course composed of multiple modules, so this is a comprehensive update.  In fact, you can see it's 7 hours of content, worth 4,000+ points, and even consists of multiple smaller trails: Publish Workflows to the Web trailWhat is FME Server?Publish Workflows to the WebCreate Data Integration Apps trailBuild Basic Self-Serve WorkflowsManage FME Server Data

Hello FME'ersWelcome to What's Up Wednesday FME User Conference NewsIf you're attending the upcoming conference, then you'll be happy to know you can now officially create your FME UC Profile & Personal Schedule online and in the mobile app!  Basically, you can see all of the sessions, mark which ones you'll be attending, browse the speaker list, look at event maps, and check out our sponsors. One event on the agenda is the FME Hackathon, 6pm-9pm on Thursday evening, and for which I'm now pleased to announce the themes:  Th