Integration

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?

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.

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

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! 

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?

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

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,

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    

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

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.

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. 

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? 

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

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

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 

- 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? 

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 :)

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!

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

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

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.

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.

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 

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. 

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/