Skip to main content
  • EN

Integration

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

  • 1,128 Posts
  • 3,966 Replies
1128 Posts
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 isfme-form-2024_2024.1.3.24627~ubuntu.22.04_amd64.debso 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?

1263
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 errorHTTPCaller (HTTPFactory): [1]: Please ensure that your network connection is properly set upHTTPCaller (HTTPFactory): [1]: No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been enteredI have already check on the server and i can reach the api by web. Does anyone what the issue is?kind regards,

775
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    

1552
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 version bu

1192
david_r
Evangelist
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
Supporter
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 

591
todd_davis
Supporter
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? 

472
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

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

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

1262
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
Supporter
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/

794
david_r
Evangelist

Badge Winners

Show all badges

Community Stats

31,105
Posts
117,928
Replies
38,858
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.