Integration

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 I am hoping someone here may have add a similar error and found a solu

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, a few seconds and you move to the next screen" Thank you! Dor

Hello everyone, I have colleagues who were wondering whether there would be git integration available with fme workbench.I understand now at the moment there is no integration directly in fme workbench with git. However it's possible to manually check in .fmw scripts in git I heard, but I think it would be an useful functionality if you dan do that directly from fme workbench. I was wondering whether something like that would be available in the future.

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 MicroStation reader or any

Hi folks, I had a question regarding creating an FME script that takes attributes from a system of record dataset into an existing record created in a feature class within an Enterprise Geodatabase. Workflow consists of the following: Two layers with the same information and attributes in different systems of record – one in an asset management system and feature class in an Enterprise Geodatabase. No integration exists between the two systems yet as there is a new replacement system being developed in a project, but in the intermediary, it has been decided that the business will be updating the asset in the asset management system, then updating the feature class attribute table in the Enterprise Geodatabase. Therefore, they will be maintaining two datasets in tandem until the pilot project for the replacement system is complete. The difference is that the layer in the asset management system only stores XY/Lat/Long values whereas the true layer in the feature class in the Enterprise

Hi I’m interested in using MQTT connector to retrieve IOT messages and then publish to ArcGIS Online. I see there is a MQTT connector as an install. https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/mqttconnector-pkg.htm Can this connector also work with FME Flow (hosted)? I don’t have access to FME Flow at the moment but wanted to know if this is possible for use case above.

Hello, My FME FORM 2023.2 recently has been updated to FME 2024 without my notice. And the new version installed was incomplete, so I can not use FME entirely. I did not see any option for auto updating in the FME software itself, did I miss anything? How to disable the auto updating? My IT team said they did not push out the upgrade. Can any one help please? or direct me to where I might get help? Thanks.

Hi, I would like to populate the "public.pdl_steg" table in PostgreSQL/PostGis with features from a "pdls" shapefile layer. public.pdl_steg includes triggers in some fields. The id_pdls field is of the serial type.The code_pdls field is unique. The triggers work well in PostGis et QGIS. Shapefile “pdls” table: However, after several attempts, I was unable to add the features from the "pdls" layer to "public.pdl_steg". The execution does not emit any errors and nothing happens. Any help is welcome.

I received a service bus connection string in the following format: Endpoint=sb://sb-sb-s-sbb-mastersupa.servicebus.windows.net/;SharedAccessKeyName=Andblablablab;SharedAccessKey=blablablablablablalbablablablabla+blablabla=;EntityPath=moreblablablablablatest But it gives me an error in FME 2019,2020,2021 Is says: Error: claim is empty or token is invalid. Should I enter the string in another format? Also: In 2022 and 2023 I get an error: No module named ‘uamqp’. Looks like this module is not available in this Python library set?

Hi, I am just wondering if you know the way to get the list of the layers that are chosen in particular Layer List widget in ArcGIS Web AppBuilder. I have used: ArcGISOnlineConnector to get into the web app and HTTPCaller with Request URL that have following structure https://YourPortalUrl/portal/sharing/rest/content/items/YourItemId/data?f=json Unfortunately t the only infrmation that I got in _response_body in relation to this widget is the label given for the widget in the app "id": "widgets_LayerList_Widget_20", "index": 5, "label": "Layer List_2", "name": "LayerList", "uri": "widgets/LayerList/Widget", "version": "2.21"

After upgrading to ArcGIS Pro 3.0.3 i get the above error when writing to an Esri Geodatabase (File Geodb). Does anyone know what the reason could be? I've also upgraded to FME 2022.2. Thanks in advance!

Hey, I have FME Server running great, my workbenches are running fine on schedules etc. I have several that are 'job submitters', and I am now trying to use the mobile app to trigger them manually, each time I connect to my server, navigate to my Repository and open the workbench, I click "Run Workspace" and I am immediately thrown an error: Failed to submit job. Error: 404 I am not finding any help articles etc, has anyone seen this issue before?

Is it somehow possible to receive a connection from another party using OAuth2? Do I need to add a specific user to the user list? Do I need to create an application? Could it be done using a webhook or an automation? Or should i build a webhook or automation and use that as a trigger to connect to another location using OAuth2? The other party does not want to send data to my FME Server without using OAuth as a security measure.

Can Imagefetcher download the images from a excel thst have google drive image link

Our goal is to write files on Sharepoint. Therefore, we used the Sharepoint Online Connector transformer, whereat the connection to Sharepoint works fine, but we currently have the following issue: The specific site we want to connect to does not show in the sites list within the transformer. We already checked the rights, but everything looks correct. What are the preconditions that a specific site is listed in the site list and can be used by the Sharepoint Online Connector transformer?

My customer want me to automate a report how many times diffrent map services has been reqested. It’s on a unfederated arcgis server with arcgis server manger. In arcgisserver manager i can export this information one by one to a csv file and get how many times a service has been requested in a set time period. I need to find a way to automate this process. Is it possible to retrieve this statistics using FME and then print it to an Excel file? Then on FME-server I need to get a report every month how many times diffrenbt map services has been used.