Skip to main content

Integration

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

  • 1,130 Posts
  • 3,980 Replies
1130 Posts
ienesaglam60
Contributor
ienesaglam60Contributor
asked in Integration
Draw a dodecagon

I have coordinate list. I want to draw a dodecagon with a known radius. example

908
bwn
Evangelist
hayley.lam
Contributor
hayley.lamContributor
asked in Integration
Sharepoint Online Connector - running from Flow does not read the current data?

Hi there, I have a workbench published to FME Flow. In the workbench I have a SharepointOnlineConnector which reads in an Excel Sharepoint spreadsheet, and downloads it to my shared data source in Flow server. The workbench runs successfully and the output (a table in ArcGIS Online) says it has updated, however the values are all old data. When I run the workbench manually from Form, the SharepointOnlineConnector reads the current data in the Excel. Any pointers on how to get Flow to read the current Excel Sharepoint?

281
kate-safe
Safer
ctmitch
Participant
ctmitchParticipant
asked in Integration
Reading/Executing Microsoft Access Queries

Hello! I'm working with one of our legacy systems built in Microsoft Access, and I need to extract data from a query. So far, the only method I’ve found involves using the system caller and command prompt. Are there any alternative ways to achieve this? I've tried using the system caller, but I’m encountering security issues with the runtime version. It appears that I need to set the location as trusted, but I can't do that with the runtime alone. We're aiming to avoid installing the full version of Access, so we're limited to using just the runtime.

221
bwn
Evangelist
alfasud
Contributor
alfasudContributor
asked in Integration
Installing on Ubuntu 24.10

Hi there, I am a new user so this may be a newbie error. I have just tried to install FME on my Ubuntu Workstation. It is running the latest version, 24.10. The latest version that FME lists has is fme-form-2024_2024.1.3.24627~ubuntu.22.04_amd64.deb so I downloaded that. It fails to install with a long list of failed dependencies. Is this install going to be possible? TIA. Kerry

26010
DanAtSafe
Safer
sel
Contributor
selContributor
asked in Integration
Integration of QGIS Model (py) in FME

I created models in QGIS Desktop. These models repair geometries of lines and polygons. Now I want to reduce the working steps, so that the data gets directly repaired in FME. Does anyone has experience in that?

11810
sel
Contributor
ben09lore
Contributor
ben09loreContributor
asked in Integration
Dynamically changing URL in reader

Hi, I have an URL that I’d like to read in, but it contains the current date and thus is being updated everyday. How may I change the URL within the reader so that it’s automatically up-to-date? I’ve tried define a user parameter as a URL but I don’t manage to make it dynamic there. I thought I could replace the date e.g. 2024-11-05 with @DateTimeFormat(@DateTimeNow(),%Y-%m-%d) in the Default Value URL but it doesn’t work. Any help appreciated!

282
ben09lore
Contributor
ivanwriter
Contributor
ivanwriterContributor
asked in Integration
Use Microsoft App Registration in Entra ID to Connect to Azure BLOB - Is that Possible?

Is it possible to use Microsoft app registration in Entra ID to connect to Azure BLOB (non-anonymous, for read+write)? I find information on using a key to connect to BLOB--but my IT policy doesn’t allow keys. I need to be able to connect to BLOB from FME Flow. App registration with Entra ID works w/ connecting to Sharepoint. How about Azure BLOB?

1293
ivanwriter
Contributor
rita
Participant
ritaParticipant
asked in Integration
IFC to cityGML

Sono un neofita del programma, devo convertire un IFC in cityGML con un algoritmo già elaborato. Inserisco il mio file IFC ma mi compaiono questi errori : ISO10303-21: Unknown entity or type name '\xD0\xCF'.ISO10303-21: Invalid file format, unable to continue readingCosa posso fare? Ho provato ad inserire il file in IFC 2x3 coordination view 2.0

270
rita
Participant
dannykgf
Contributor
dannykgfContributor
asked in Integration
HTTP transfer error: SSL connect error

Hi all, I had build a workspace in FME dekstop using httpcaller to get data from an api and its working. When i publish this on the server, then i get the following errors. HTTPCaller (HTTPFactory): [1]: HTTP transfer error: SSL connect error HTTPCaller (HTTPFactory): [1]: Please ensure that your network connection is properly set up HTTPCaller (HTTPFactory): [1]: No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered I have already check on the server and i can reach the api by web. Does anyone what the issue is? kind regards,

785
AliAtSafe
Safer
syedh2993
Contributor
syedh2993Contributor
asked in Integration
Error Handling in FME - Retry running workspace

Hi Team, I am new to FME and would appreciate if you could help me by giving some tips on Error handling in FME, Below is my scenario, My FME application reads the data from Database and writes to arcGIS Feature layer. Application overwrites the data to feature layer everytime it runs. If application fails for some reason, is there any transformer (or any other method) to retry running the workspace again or add some kind of Try/Catch mechanism? Below could be possible error scenarios in my application, 1) Error connecting to Database 2) Error occurred during transformation 3) Error occured writing to arcGIS Online Thank you in advance, Regards,Syed

1592
s.jager
Influencer
louiseboyce
Participant
louiseboyceParticipant
asked in Integration
Python FMEObjects Missing DLL files

Hi - I am hoping someone can help. Apologies in advance for the long message. I am using FME Workbench 2022.2.8. I am trying to set up a workspace that has three readers (using a SQL database that retrieves data from three separate tables) connected to a PythonCaller and then a feature writer (connected to the Python caller) that writes the data back into a SQL database. I need all the readers to have finished before the PythonCaller is executed as it uses all of them in the script. I initially tried to run this using the built in Translator Python3.9+ but every time I did It said no module named pandas. I attempted to configure my own python.exe that I have as part of anaconda navigator (2024.10.1). I created an environment called fme_env and set the Python version to 3.9. I was able to successfully set up all this, but I encountered the no module called FMEObjects error. I went into my FME installation path and there was a folder called fmeobjects and inside that there were several v

1212
david_r
Celebrity
aharport
Contributor
aharportContributor
asked in Integration
unable to create required workspace factories

I am trying to convert 15 dgns (approx. 50 MB) into 5 gdbs using a workbench. The conversion is aborted with the error shown in the jpg. If I deactivate a few readers (dgns), the run is completed without errors. Could this be a memory problem? Please help.

323
aharport
Contributor
ryanwillshear
Observer
ryanwillshearObserver
asked in Integration
Dynamic AGOL login when using FME workspace as SpatialETL tool in ArcGIS Pro

I’ve been creating some workbenches that regularly update datasets on ArcGIS Online, but I’ve hit a small issue with the ArcGIS Online authentication within FME. It’s fine when I run the workbench, but if someone else runs the workspace they need to use their own AGOL account. I’ve added the workbench into an ArcGIS Pro toolbox as an ETL tool so it can be scheduled in Pro, so is there anyway to pass a persons ArcGIS Online account info from Pro to a FME workbench? Or force it to need a login prioir to running.

171
todd_davis
Influencer
awrob_
Contributor
awrob_Contributor
asked in Integration
Databricks (JDBC) Reaer

Hi, I’m trying to connect using the ‘Databricks (JDBC) Reader’ but I’m receiving an error. I’ve attached a screenshot from the Error - Log Window. Any ideas?

594
awrob_
Contributor
alegat
Participant
alegatParticipant
asked in Integration
Orientation de symbole

Bonjour, Je souhaiterais trouver un moyen d’orienter un ponctuel (des supports électriques) par rapport à l’orientation de leurs ligne.

452
alegat
Participant
ssmith_ftr
Contributor
ssmith_ftrContributor
asked in Integration
Neo4J JDBC driver warning messages

I’m using FME to push and pull some data from Neo4J. For the connection I’m using the JDBC driver from Neo4J with the SQLExecutor. I’m getting various warning message in my FME logs and wondering if some configuration that can be done with the driver settings (connection property/value) to either prevent them or quiet them. To be clear, my workbench succeeds and have no issue with everything completing. It is just these popup in FME Flow for completed Job logs. Here are the two most popular (both warnings): JDBC Reader: Unable to preload JDBC Driver Class 'Neo4j'. Error: Neo4j JDBC Reader: Skipping data in column '.errorMessages' due to error (JDBC Type = JAVA_OBJECT, Vendor Type Name = MAP, Error: Method getBytes in class org.neo4j.jdbc.Neo4jResultSet is not yet implemented.)

472
ssmith_ftr
Contributor
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?

481
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.HiveJDBCC

701
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.

2874
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::Exception Python 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.

1272
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

Helpful Members This Week

Badge Winners

Show all badges

Popular Tags

Community Stats

31,140
Posts
118,062
Replies
38,759
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.