Integration

Hello,I’m working with the ArcGIS Open data portal and I want to publish all my layers within a geodatabase to my AGOL folder as new Feature Services. Since there are multiple items(layers), I’m looking for a batch process. I’ve came across several transformers but none of them seems like working for me. I would appreciate your suggestion on transformer selection for this.Thank you.Rajesh

 Hi Everyone,I’m working on an integration workflow between an editable polygon feature class in an enterprise geodatabase and an asset tracking the same asset in an Asset Management System (which will be where the majority of the info is populated). We cannot write directly to the Asset Management System database, and need to write/get to it via API.The GIS feature class has a few attributes that are not in the layer in the Asset Management System and vice versa therefore it is not a straightforward cloning. That being said, I will have the attributes/fields required in the GIS Feature layer already so that new fields/attributes themselves don’t need to be created in the FC. However, we want to set up an integration as the diagram shows above.So the lifecycle of the asset will start in GIS, whereby a user will tra

Hello,I have a situation that I cannot seem to understand.It seems that fme.exe is locking/using a file that I try to rename in the Startup Script, although that file is not used at all in the workspace (the processing where the file gets created/saved/renamed is happening in the startup script).The logs don’t mention this file/folder as being used at all.i don’t have the file open in any other app, closed everything else except FME.This is happening on windows.  Logs say:2024-05-24 11:32:20|  18.7| 18.5|INFORM|15160 fme.exe is using C:\Users\myuser\Documents\DataProject\CAFile\dtCA.xlsx2024-05-24 11:32:20|  19.1|  0.0|ERROR |Python Exception <PermissionError>: [WinError 32] The process cannot access the file because it is being used by another process: ‘C:\Users\myuser\Documents\DataProject\CAFile\dtCA.xlsx’ The interesting thig is that on another machine with the exac

 Hi, I’m using a change detector to see if any updates has been made from the new data, to the data  on ArcGIS Online. Previously I had the error about missing ObjectID on updated records, but I fixed that using a feature joiner from this Guide: How do I write updates to an existing ArcGIS Online feature service? – FME Support Center (safe.com) I got it working on points, lines and polygons, however if I want to update tables, I get the above error. By a search I found that this error has also been found in Survey123: 

I think I may have run into unexpected behaviour. I’m trying to pass some text in a user parameter via a workspace runner but it’s stripping out the quotes within the text when I try to retrieve it.The text I am trying to pass through to a child workspace:"Building_Use" = 'Residential'In the log of the workspace runner it gets passed along in the command line arguments as:--SQL_WHERE_Clause {${="Building_Use" = 'Residential'=}}'and the child workspace receives it correctly when initiating the workbench as:``--SQL_WHERE_Clause' `"Building_Use" = 'Residential''.But when this is retrieved via a parameter fetcher or attribute creator it drops the quotes in the child workspace:Building_Use = 'Residential'However if I run the child workspace on its own (not via the workspace runner) it retrieves the text correctly. I can workaround this by replacing “ with another character before and then replacing it within the child-

I would like to know the name of the localization language file for FME FORM 2024. I know that the localization language file for FME Desktop 2020 is named transformers-localized.* (for example, transformers-localized.zh). I want to know if the new version has changed the name of this file.

Hi everyone, I have an Excel file containing SQL WHERE clauses used as Definition Queries in an ArcGIS project and I want to use the same SQL WHERE clauses in my workspace to create subsets of my data. Is there a way to "convert" these SQL clauses to Tester test clauses? I managed to do a lot with some StringReplacers, to the point where regular (att1= 'this') and list clauses (att2 IN ('this', 'that')) are covered, but I also have a lot of LIKE clauses (att3 LIKE 'th%') and I can't seem to get these translated to Tester's Begins With .  I know about the capabilities of the FeatureReader's Constraints, but in my analysis I need both the entire dataset I am querying AND the SQL-clause-derived-subset. And I want to prevent reading in the data twice, since that slows down my workspace a lot. Thanks in advance everyone!

Hi,I’m massively confused on why certain machines in our office cannot connect to our Floating License Server. We previously had 2 floating licenses (esri edition) and bought a third seat; we then consolidated all three licenses under one Smallworld line item according to this article. To test, I opened FME on one machine, redirect the licensing assistant to use the new smallworld licenses, and everything works great. When I test on another machine however, I can’t connect (previously could)

How to read Multiple AGOL Features using wildcard using one reader?

I want to create a glTF/glb mesh georeferenced, these are my parameters into the writer.Even though, the .prj file has the coordinate system tipe, they don't display the model georeferenced, any suggestion? Thanks in advance

Hi, I am trying to use the ImportFromFME package in Revit Dynamo and need to generate an FME Connection String using the FME Connection String Generator Utility, but I can’t find the FMEPCConfg.exe in my installation folder. Is it saved somwhere else or do I need another FME program like FME Server to use it? I have FME Form 2023.2 installed.The executable is supposed to be in this area, but it’s not there. 

Hi,Has anyone done or has experience with integrating BIM/CAD and GIS data between ProjectWise and ArcGIS Enterprise? I know that this isn’t a solution supported by ESRI, but FME's capabilities allow to process data and connect both environments. I am looking for ideas and solutions for integration and full synchronization between environments. Ultimately, I would like the design data saved in PW to be displayed on the GIS portal.Thanks for any ideas and suggestionsFilip

Is it possible to use OAuth2 authentication using the Kafka Connector?

Is anyone aware of a connector for FME that enables our GIS databases (Microsoft SQL) connect to a Techncology One Property & Rating database? 

I have a non-spatial table in MS SQL database with lat/long coordinates. In my workspace I use the VertexCreator + EsriReprojector to create point geometries in our standard projection. Now I want to write the point features to a new feature class in an Enterprise Geodatabase (SQL Server back end).  The database connection I am using for the writer has permission to create table in the geodatabase and I am able to create feature classes in the geodatabase outside of FME.  But in the workspace, the translation fails with this error:“An error occurred while attempting to create the feature class 'My_New_Feature_Class'. The error number from ArcObjects is: '-2147216035'. The error message from ArcObjects is: {This geodatabase does not support this client or operation [This geodatabase does not support this client or operation] [My_New_Feature_Class]}I have searched for this error code and do not find much out there, so

Hi everybody,My client has a spreadsheet that contains a list of Google Map urls embedded in text, inside cells in a Google Sheet. Using the Google Sheet  V4 reader, I am unable to read the url of the embedded text into the workspace. For example, I cannot read the url for the Google Map url for Safe’s location in this spreadsheet.  I’m really hoping to mine the lat/long coordinates from these urls. I use FME Desktop V2021.2.2.0 in production, but have Form V 2023.2.1.0 available, if needed.Thanks!

I have a Flow App, which performs a relatively long process, which at the end directs the user to a certain url following the success or failure of the process.The url reference is made by a single HTML writer at the end of the process.My problem is that this process can take some time,And in terms of the user experience, the customers are not aware that the process is running behind the scenes.I want to make a reference to some kind of loading GIF that will at least show them that something is really moving behind the scenes..And this is where I need your help.Because if I write to two HTML writers, it simply downloads the two HTML files for me,It does not direct me HTML line after HTML, but simply disrupts the process.Does anyone have a solution?It doesn't even have to be a reference to the HTML of the loading GIF, just an indication in terms of the user experience that will tell the customer: "Don't worry

I have two polygon datastets and i send them to the Topology Builder so that they will get break at the intersection. However it does not give the result I expected. My expectation would be a similar result to thearea on area overlay  my output looks. The overlapping area are not broken. Any idea what i may have been doing wrong 

Shall we consider installing a Graphic card while preparing a machine for FME Form installation. How a Graphic Card impacts on the performance of 3D / 2D data processing.

We have not been successful in setting up a web connection for our GCP environment.  Therefore, we use JSON key files.Has worked just fine via a PythonCaller to read the file and fill in GOOGLE_APPLICATION_CREDENTIALS.  If we had a need to write to a different GCP project we would change the project_id in the JSON file.However, we were contacted by billing recently saying that since we use the project in our JSON file that another area was getting billed instead of our ETL project.We tried to fully qualify using the project id and then the schema in the writer, but that did not work.  It always assumes that you are writing to the project in the JSON file.Is there a way around this issue?

Hi all, Since upgrading to FME 2021, I have found previous workspaces that were working in 2020 are now not working. This appears to be when multiple datasets are referenced in a WorkspaceRunner and through a user parameter. It concatenates the filepaths together and loses the double quotes and separation, causing the reader to fail. Any help would be appreciated. Kind regards,Jack  

I want to use the AzureServiceBusConnector to get the messages from the Queue.But if there are no messages in the queue I want to end the FME Job after 1 minute. Is there a way to terminate the process only if the queue is still waiting.If the AzureServiceBus connector reads the expected amount of messages I don't want to get an error, only if it's waiting for nothing.

Hello please I need help. I converted my Autocad Map 3D files to integrate them into my database using the 'Raw relational' mode because my data has multiple tables and one entity with several attributes. Currently, I would like to convert them back into Autocad Map files while preserving the original file structure. I'm stuck because I can't recreate my different tables (Table A and Table B). What should I do?

Hi Everyone,We are working on an integration between ArcGIS Utility Network and SAp using FME to connect with SAP via their Odata services and Integration Suite.We have successfully used Get calls from FME desktop to fetch a token and get information about an asset.When we switch using a POST call to create a new asset we get a response error of  “HTTP/1.1 403 Forbidden” and response body “CSRF token validation failed”The calls we are using have been successful from postman through integration suite.I have attached the workbench containing the current settings and the latest log file.Any insight i why this would work for GET calls and not for POST calls

Hi,We have an assignment where we are using FME Form 2024 version to convert a DGN file to a GIS format. For us to do it, the design file (DGN) needs to be reprojected and scaled to Web Mercator coordinates. I am not a designer, but a developer and learning about the DGN files as I go. The designers using Bentley’s Micro station tool.Using MicroStation V8 reader, reads the “Name” associated with the coordinate system, which is a free form field and can contain a name that the project designer puts in manually and is not a standard naming conversion.We are trying to read more information from the properties of the coordinate systems like the “Description”, “Affine parameters”.  The description field contains standardized naming that we could use since it is not editable by the project designer. The Affine parameters define the scale factor that will be used to convert from ground to grid coordinates.Need help in identifying how this can be read through the