Integration

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

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/

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:

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 ! 

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. 

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

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:  

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

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 

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 

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? 

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.

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?