FME Form

is there a way to replicate sde. default database and store it in the folder? also for recurring backups or replication of the database would not be overwritten and saved into a different folder with a different name. Please let me know if I can accomplish this in FME. Thank you,Sarah

I have one column with this values. I would like to filter only words that contais ABC letters. But can´t be JACABC or RDABC. Sometimes the ABC is stay in second or third word after the comma, like image below:  Thank´s

Below as a screenshot of the Revit project (what i am trying to export) followed by what i am able to convert and export into ArcMap. Missing room tags and door swings.

For more information visit us:AutoCAD Classes in PuneAutoCAD Course in PuneAutoCAD Training in Pune

Has anyone experimented with connecting to "Databricks on AWS" data sources? If so, which reader format or transformer should be used to make the connection and browse the available data?

Hi, I'm trying to insert a decimal into a string of numbers, so 123456 becomes 1234.56  Thanks!

What format can I write to using FME so that my vector data can be read/processed with OpenCV?I'm in the early stages of an image segmentation project to identify impervious cover data from aerial imagery but we're having some early issues getting my vector impervious cover data into a format that my computer science counterpart can use in OpenCV. It seems like XML or GeoJSON would work, but I don't have any experience with OpenCV. Any ideas?

Hey there, So I recently set up a Data Distribution service on FME Server using this tutorial https://community.safe.com/s/article/data-distribution-fme-server-app . Everything works fine and I can use the area of interest box to draw an area and download all the relevant layers. I am trying to add a second option in the User Parameters to allow the user to either draw a selection or choose a layer to clip by.In user parameters I added a 'Choice' option and added a layer as an option to clip by my thought was I could add a second geometryreplacer, set the encoding to OGC well known text and the source as $(LAYERCLIP) by when I run it and select the City Boundary to clip but FME gives me the error INVALID_PARAMETER_GEOMETRY_SOURCE. Is it because FME doesn't know what GISOWNER.city_boundary is? Its a layer in our enterprise SDE. I tried adding in a featurereader to read the layer before it goes to the replacer and had no luck. Thanks!

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 no default value). I think that's definitely worth knowing about. Also on my list this week:Known issue launching FME Server 2022 on a Cloud Starter instance (new)How to make a Minecraft world with FME (updated) Server Automations DemoSomething I tried for the first time last week was FME Server Automations. I only made a simple two-workspace chain, started by a schedule, but

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 to be saving files). Any clue what i might be doing wrong?

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 merged into it. Right now im running them through their own clipper into a copy paste of the feature output which would mean doing that for every single layer i want to download. Just want to make sure theres no better way of doing this

"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