Skip to main content
  • EN

Integration

Connecting FME to web services. Use of APIs. Mobile Apps.

  • 1,137 Posts
  • 3,998 Replies
1137 Posts
syedh2993
Contributor
syedh2993Contributor
asked in Integration
Data Rollback on "ArcGIS Portal Feature Service Writer" for Multiple Layers

Hi,I am trying to write data from database to 3 different Feature Layers (Hosted) on ArcGIS Online. 3 layers have different set of feature attributes.While trying to write data, I would like entire transaction to be rolled back if publishing data to one of the layer fails.Example: If writing data to layer 1 and 2 was successful, but layer 3 fails, I would like to rollback layer 1 and 2 as well.For this scenario, I am trying to use 3 readers and 3 writers in same FME workspace. Is there any kind of Try/Catch or related mechanism that can be used to rollback the transaction ? Any help would be much appreciated, Thanks in advance. Regards,Syed 

601
todd_davis
Influencer
eulniyy
Participant
eulniyyParticipant
asked in Integration
- Sketchup Studio 3d Modelling - I want to do it even if I transform the glb file into 3d tiles and go to cesium ion, is it possible in FME?

- Sketchup Studio 3d Modelling - I want to do it even if I transform the glb file into 3d tiles and go to cesium ion, is it possible in FME? 

501
saraatsafe
Safer
valentinthonen
Contributor
valentinthonenContributor
asked in Integration
Why can FME not properly position an AutoCAD drawing, while ArcGIS Pro can?

Hey all,I have a general question about how FME deals with AutoCAD files.I have an AutoCAD .dwg drawing which contains multiple xrefs. When I open the xref file in ArcGIS Pro it is positioned on exactly the right position on the map, while when I open the same file in FME it is positioned somewhere in France. I know that the reason why the drawing is placed somewhere in France is because FME does not recognize the coordinate system. But how is ArcGIS Pro then able to do it? When I click in ArcGIS Pro on the source tab of one of the sublayers properties I see that the coordinate system is unknown. The reason why I ask this is because I would prefer to use FME as a workflow to convert .dwg files to feature classes in .gdb database, but that as long as the drawings are not possitioned right this would be useless to do. Wondering if someone knows about how this can be the case.Looking forward to the asnwer, thanks :)

422
bwn
Evangelist
philippeb
Enthusiast
philippebEnthusiast
asked in Integration
Integrate EXIF info in a JPEG without writing new files ?

Hi FME Universe,Is it possible with FME to integrate EXIF info in a JPEG file without writing a new file?Is FME able to integrate EXIF info in the original JPEG?My first thought is no but maybe I’m wrong?!Thanks!

221
nielsgerrits
VIP
syahirah
Contributor
syahirahContributor
asked in Integration
Transfer file from application website to FME using API

Hi communities, I need help for above post which has not been solved yet. I’m totally stuck on this.

181
nielsgerrits
VIP
jackfanzhang
Contributor
jackfanzhangContributor
asked in Integration
Potential bug in FME 2024.1.2.1 failed to support Databrick JDBC connection

Hello,I have a workbench which includes Databrick JDBC Connection. It was working fine with FME 2024.0.3.0. However, after upgrading to FME 2024.1.2.1, it starts throwing error “java.sql.SQLException: [Databricks][DatabricksJDBCDriver](500151) Error setting/closing session: Connection not obtained from this manager.”Feels like something is missing with the upgrade. Has anybody seen the same problem? Could Safe support team please check? thank you.Full error attached below.java.sql.SQLException: [Databricks][DatabricksJDBCDriver](500151) Error setting/closing session: Connection not obtained from this manager. at com.databricks.client.hivecommon.api.HS2Client.openSession(Unknown Source) at com.databricks.client.hivecommon.api.HS2Client.<init>(Unknown Source) at com.databricks.client.spark.jdbc.DowloadableFetchClient.<init>(Unknown Source) at com.databricks.client.spark.jdbc.DownloadableFetchClientFactory.createClient(Unknown Source) at com.databricks.client.hivecommon.core.H

751
hkingsbury
Celebrity
mgrimnes
Contributor
mgrimnesContributor
asked in Integration
Problems accessing stored web- and database connections in FME Form 2024

I have just installed FME Form 2024.0. Previously, I have added the option of sharing my connections by setting up the neccessary registry enties.When I open the Database Connections in FME Options I get this message:Which means I have no available Database connections. When I “upgraded” my FME Form installation from 2022.x to 2023.x, this was not an issue.I also see that my Web Connections have the same issue. Is this expected behaviour from FME Form 2024, have I missed some important steps when upgrading/installing 2024 or is this an error in 2024? My 2024 install is in parallell to my existing 2022.2.8, 2023.2.1 and 2023.2.2 installations.We have customers running different versions of FME, so I need FME Form installations in parallell.

2894
bo
Contributor
mr_fme
Enthusiast
mr_fmeEnthusiast
asked in Integration
Library Python in FME

Hi,I’m trying to use the mgrs library in FME, but the following error is shown:Message Type: fme::internal::_v0::py::ExceptionPython Exception: <ModuleNotFoundError>: No module named 'mgrs'If I run it in a standalone script, it works very well. The library has been successfully installed on my machine.Thank you.

1422
mr_fme
Enthusiast
fares
Contributor
faresContributor
asked in Integration
ExcelToPDFWriter

Has anyone tried running the ExcelToPDFWriter in an FME flow? I’m encountering an issue where Excel cannot open the file when I run this transformer in the FME flow. However, I don’t face this issue when running it directly in FME Form. Any insights or solutions would be greatly appreciated!. I found the sloution here : Microsoft Excel cannot access the file (Java -> cmd /c python -> Excel) - Stack Overflow 

7512
fares
Contributor
gisgeek
Contributor
gisgeekContributor
asked in Integration
Extracting tables contents from webpage

Hi there I have been trying to extract the contents of a webpage the Facilities Masterlist which is on our internal sharepoint. I have downloaded a local copy of the page I am trying to extract contents from and attached it. I haven’t had much luck extracting the contents to replicate the table on the page. This is what I have so far. 

221
todd_davis
Influencer
nielsgerrits
VIP
nielsgerrits
asked in Integration
FME wallpapers

I was wondering where the FME wallpapers are moved to? The old link does not work anymore.https://www.safe.com/support/support-resources/fme-downloads/wallpaper/

804
david_r
Celebrity
ridleyj
Contributor
ridleyjContributor
asked in Integration
Sharepoint List Reader returns unexpected NULL values when Sharepoint Column settings allow multiple selections

Is there a solution to correctly read sharepoint list attributes that are multi-select columns?When reading a sharepoint list with relevant permissions to read,write etc. the data table returned shows only <NULL> values for any column that has multi-selection enabled - adjacent columns with single select settings that hold the same data type (username) are returning the expected values - only the column settings differ.[Note the column setting for allow selection of {people only / people and groups} may also play a part in this question]The column that is returning NULL only has settings as below: List columns that return the expected values have settings: 

795
emmaatsafe
Safer
philippeb
Enthusiast
philippebEnthusiast
asked in Integration
Why FME uses a deprecated WKID version ?

Hi,For the writer ArcGIS Portal Feature Service why using by default a deprecated WKID (102100) ? It’s even written in the FME doc  : hereAccordingly to the Spatial Reference organization, this WKID has been deprecated for quite a while now (before covid!) We need to use 3857 instead. So I don’t understand why FME continues to use the old one by default. Why don’t we see his replacement : 3857 ?Thanks ! 

411
hkingsbury
Celebrity
amber369
Contributor
amber369Contributor
asked in Integration
Create feature service from URL in ArcGIS Portal

Hi All,I'm still somewhat new to FME and am hoping someone can advise me.Through another workbench I have been able to gather a a list of service URLs from an AGOL. I would now like to automate the process of creating a new item in ArcGIS Portal via the New Item > URL workflow.I have looked through the Esri ArcGIS Portal Feature Service Reader/Writer and a few other transformers but none seem to accommodate for creating a referenced item via URL. Google is leading me nowhere either.Any advice or pointers?Thanks very much for your time! 

1005
amber369
Contributor
jsdbroughton
Contributor
jsdbroughtonContributor
asked in Integration
All attempts to create a web service authentication fail on redirect

I have followed the documentation on setting a custom OAuth2.0 web service connection and all steps work within the Test… flow until it comes to redirecting to https://localhost . Is FME listening to a specific port on the localhost or should it be registering itself as a temporary server? This is the returned screen.Following the same flow within a external browser window also ends up here but the returned access_code is present in the URL.How is this being retrieved by FME - I’m kinda stuck here. 

71
todd_davis
Influencer
guygur
Participant
guygurParticipant
asked in Integration
Utility Network

Hi, I want to migrate my data from geometric network to utility network. Can someone help me?

351
hkingsbury
Celebrity
svante9
Participant
svante9Participant
asked in Integration
How to make a 3D building in FME

HelloI have 8 building surfaces with z-value. I also have a ground model. I wonder how to get the building surface to go down to the ground model so that there are sides, 4 sides that go down to the ground model. Now the building surface floats above the ground model in arcgis pro. I want to take the result into arcgis pro.What transformers do I need to process my 8 building surfaces so that they become blocks that correspond to a building.Now it looks like this in arcgis pro:  

1853
vadis
Contributor
lifalin2016
Contributor
lifalin2016Contributor
asked in Integration
SharepointOnlineConnector and web connection woes

Hi all.I’ve tried to setup a connection to a list of files on a (customer) Sharepoint service without much success.I’ve read multiple other questions about it here, and some provided useful help (prompt=login), but most does not address my issues.The customer has created the site, and provided me with tenant and client IDs, and client secret. And he has created an “app” with an approval of my client (FME Form).First I tried to create a web service, but never got the “Test...” to work. First it erred insisting on getting an approval, but “prompt=login” solved that, but not it errs with a “refresh token” error.The same happens when I try to create a new web connection using the web service in a SharepointOnlineConnector.I then saw that there was an alternative use, using FeatureReader with “Microsoft Sharepoint List”, and here I was able to create a web connection using the previous web service unaltered. Sofar it can only access root douments, but the connection works, it seems.But now

833
lifalin2016
Contributor
evoteck
Enthusiast
evoteckEnthusiast
asked in Integration
Geodatabase writer error

Hi folks, how can I resolve the error below;2024-09-06 07:06:19|   1.5|  0.0|ERROR |BADNEWS: No MULTI_WRITER dataset name was specified (couldn't find a value for `PRIMARY_DEST_DATASET' or `MULTI_WRITER_DATASET')2024-09-06 07:06:19|   1.5|  0.0|ERROR |(D:\code\fme\source\engine\core\engine\writrimp.cpp:672) class StatusInfo __cdecl STFWriterImp::getDataset(class stk::ex::UString<0> &) const 

1416
evoteck
Enthusiast
femo
Contributor
femoContributor
asked in Integration
Python Start Up Script results used within User Parameter

Hello,i am facing the following task. csv-files that have different headers (different columns) are to be processed. In other words, file1 has a set of attributes, file2 has a different set of attributes, etc. In a Python start up script, the different columns are determined whenever the workbench is started. Now i would like to use these attributes within published parameters. The idea:A published parameter “p_city” asks for the column which corresponds to “p_city” (name of the city). The user can select among the columns that have previously been determined by the start up script.How can i pass the determined columns from the start up script to a fme parameter? Or do you have a better idea?Best wishes 

272
femo
Contributor
robotix
Contributor
robotixContributor
asked in Integration
How do I get FME to select the right cert for Client Cert Authentication to server?

Part of the handshake is described as:Upon receiving the Server Hello containing the Client Certificate request & list of Distinguished CA names, the client will perform the following steps:The client uses the CA list available in the SERVER HELLO to determine the mutually trusted CA certificates.The client will then determine the Client Certificates that have been issued by the mutually trusted Certification Authorities.The client will then present the client certificate list to the user so that they can select a certificate to be sent to the Server.So the last part of this states the cert list is provided to the user so they can select the cert to sent to the server. In this case the user is FME. How does it select which cert to pass to the server? 

1466
martinkoch
Supporter
User17042260974539197207
Participant
User17042260974539197207Participant
asked in Integration
RAPIDS conda environment for FME Form and Flow under Linux?

I have a need to access some advanced graph algorithms in the RAPIDS (rapids.ai) package from a PythonCaller, which is normally installed as a Conda environment.  I have found a few references on selecting the Conda-environment-specific Python interpreter, but unfortunately, they all assume we are running under Windows.  We are running Ubuntu Linux, and the Linux installation of FME Form (as well as the macOS installation) doesn’t support custom interpreters.Any ideas on how I can get around this?  I’ve previously managed to install pip packages into the standard FME interpreter environment with no issues, but it’s very difficult to successfully install RAPIDS using pip due to its many binary dependencies.

512
User17042260974539197207
Participant
_jacques_
Supporter
_jacques_Supporter
asked in Integration
Extracting workspace metadata

Hi,  I’m working on automating our FME workspace deployment on Azure Devops using the functionality in pipelines. One thing I would like to automate is to extract metadata about every workspace pushed to the repository and write it to a README.md file. With such a file placed next to every workspace it would be easier to navigate our repo. I would like to see basic information like workspace name, description, number of transformers etc.What’s the best way to extract this data? I have tried using python to read the .fmw text directly and using the FME workspace reader with partial success.  Has anyone else done something similar or have ideas? 

393
redgeographics
Celebrity
marias
Contributor
mariasContributor
asked in Integration
Run "dynamic" SQL queries

Hello,Could you please help with ideas how to implement the following: I run SQL query by SQL Executor that checks something in PostgreSQL DB and as a result provides set of SQL queries that should be executed in the database afterward. How to execute those newly generated queries? How can I run all those resulted queries after SQL Executor?

1047
ebygomm
Influencer
losanca
Contributor
losancaContributor
asked in Integration
Esri ArcGIS Server Feature Service

A month ago, I generated an fmw (Build 24202) that read from Esri ArcGIS Server Feature Service, (url, user, pwd) correctly.today when opening the fmw gives error and is not able to read, I do not know why it can be, if everything is the same as a month ago.Thank you so much!  

293
hkingsbury
Celebrity

Badge Winners

  • Student (Grey)
    nick3_s75has earned the badge Student (Grey)
  • Teacher (Grey)
    nick3_s75has earned the badge Teacher (Grey)
  • Welcome Back
    nick3_s75has earned the badge Welcome Back
  • Student (Bronze)
    geo-xhas earned the badge Student (Bronze)
  • Student (Grey)
    geo-xhas earned the badge Student (Grey)
Show all badges

Community Stats

31,197
Posts
118,250
Replies
38,801
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.