FME Form

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

Hi there! I want to create polygons from an attribute that contains a string of coordinates and other information. My problem is that I don't know how to only extract the coordinates from the string and then create the polygons by their ID attribute. The string in the coordinates attribute looks like this: “{"type":"Feature","properties":{},"geometry":{"type":"Polygon","coordinates":[[[13.707920553133594,60.03475791657763],[13.708950521395312,60.03304306231432],[13.705474378512012,60.03160680337132],[13.702513219759567,60.02997753853561],[13.702255727694139,60.030577803349054],[13.703929426119434,60.03184261136259],[13.706161024019824,60.032571461785544],[13.707920553133594,60.03475791657763]]]}}” ID attribute 1 to 10 Regards, Ricardo :)

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.

I have a DXF file that consists of multiple geometries and attributes. I want to convert this DXF file to a file geodatabase with multiple layers based on each geometry type in the DXF. The different layers also need to retain the same attributes as the DXF files. I attached the file as a zip to this post. I tried loading the DXF file in FME using the Autodesk Autocad DWG/DXF reader and splitting the geometries using a GeometryFilter. That worked fine. However, the attributes disappear when I read the DXF file in FME. Do you have any suggestions on how to retain the attributes of a DXF file when reading it in FME and converting it to a GDB? The data was gathered with a Leica gs18T in case that helps.

Hi. Is there an authoritative list somewhere of which versions of FME uses which versions of Python ? So far I have: 2020=3.7, 2021=3.8, 2022=3.9+3.10, 2023=3.11, 2024=3.12 I’m assuming that the Python executable is located in [FME_ROOT]\fmepython###\python3.exe (or the dll’s). Is this correct ? And where is this executable’s site-packages folder located ? Is it at [FME_ROOT]\python ? Or [FME_ROOT]\python\python312 ? Or somewhere entirely different ? And is this location the same in an FME Engine for Server/Flow ? I’m contemplating adding a special Python package for use in both desktop and server. Cheers.

Hi FME World, Anyone having this issue ? Every $%?&* time I open FME I have to replace the Navigator bar correctly through the right side. Kind of annoying. I’m using 2024.1.2 and Windows 10.

Why do I get the message: The following potential problems were detected in this workspace: Transformers are used that are not installed: 'AttributeExposer (version 2)', 'Clipper (version 16)' The install/machine that created this workbench, and the install/machine I’m trying to run it on are different, is it a version mismatch? How can I fix it?

Context: Feature Type with a WHERE clausePurpose: To only read records relating to a user defined Iwi (Maori Tribe). When the WHERE Clause is, for example: "IWI"='Whakatōhea', the transaction is successful and returns the expected records. However, when the WHERE Clause is set with a User Parameter "IWI"='$(IWI)' and the User Parameter is set with the value Whakatōhea, the transaction is successful but no records are found. This behavior is only affecting records with macronated vowels, which is common in Maori language. Users need to be able to input their Iwi of interest for this workbench.Can anyone suggest where the WHERE clause setup might fail? Many thanks

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.

Hi, I have a workspace that reads a shapefile. My workspace has around 450 transformers. I defined published parameters for the user to insert the row quantities of the shapefile. How can I automatically get the number of features from my file and save it in a published parameter to use in the middle of my workspace, simulating the values inserted by the user?

Hi all, I have a set of JSON files which return an error upon trying to read them in - that it encounters an unexpected character "\\". If i open the JSON in a text editor and remove all the \\ characters it reads successfully in FME then. As i have a batch of 300 JSON files i cant do this manually. I have tried reading in each one as a text file and using a StringReplacer but it is incredibly slow. Has anyone got any suggestions or solutions? Kind regards, Jack

Hi, Suddenly, the feature count in FME Desktop disappeared, even with the "Enable Feature Counting" option ON. The log shows: Cannot connect to feature count server "65051." Why does this happen? The problem occurs with all formats. Thanks.

I need something like the AttributeManager but it needs to work only on a limited set of attributes. What I need is a transformer that sets values (conditionally) to a handful of attributes. I need the ability to copy paste this box to various places in a workspace or to other workspaces. I’ve been using AttributeManager but the problem is it gets overwhelmed with other attributes and the transformer changes based on the input stream. I need something that’s sort of shielded from what’s in the pipe. These limited set of attributes are common to various workspaces or workflows (eg, datemodified, lastuser, datecreated etc) and are always guaranteed to exist. So naturally I need them handled in a simple, separate transformer that can be reused. Is there any way to achieve this? Thanks

Hello, I am writing to ESRI geodatabase that uses MS SQL. Every time I get "Unable to convert value taken from Z_ORIGIN keyword to a float data type". So far i have: Used a 2dforcer, changed the "z scale and z origin" to 0 or 0.00000 under table creation parameters set "Contains Z Values" to No (also set to yes, and blank on other trys) Recreated the writers Set the writer geometry to table, not a point file. Nothing has worked. I am under the assumption that the writer is passing a "Null" value to the writer which in turn says that "null" cant be a float value. Finally I have looked at the other posts on this and nothing has helped. Any suggestions? Just to update, I used a vertex creator to make new geometry, and still didn't work, but i can insert all of this into a file geodatabase and then import that to my enterprise database. If anyone has any help please post it, this issue doesn't have a good answer on the forms yet.

I have a whopping great big table in my workbench with 2100 attribute fields in it! 😯 The data originates from JSON files, and I need to write it into several csv files. The csv files need to pick up the schemas of tables in an Oracle db. These tables have a couple of hundred attribute fields / columns in, so many of my attribute fields will be dropped from the massive table in the workbench when creating the csv. This is good! The Oracle tables do not feature in the workbench at all, so I just need to grab the schema of the existing tables, bring them into the workbench, and use them in the csv writers. I’ve tried to use Schema Scanner, and Schema Mapper but with no luck. I am sure the answer must be really simple and I am doing something wrong. Any help will be much appreciated. Stuart

I have seen some partial answers to this while searching but nothing definitive. Can someone explain the best way to install a transformer [package] manually on Windows? More specifically, the emailer package from FME Hub. We don’t have internet connection to FME Hub so would need to download the package and install it. Does it have to be installed for each profile or can the users share a location for the package? Thanks!

Hi I have a spreadsheet (see table below) with a start and end point coordinates for different road sections and I'm trying to extract the road segments between the start and end points from another dataset containing my road geometry. Unfortunately the start and end points do not always lie on the road so I would need to snap it to the closest road. The road directions (road ways) are stored as separate features in the dataset with a common road id.Section IdStart LatStart LongEnd LatEnd LongA-33.938..., 151.151.-33.935...151.131...B-33.949...151.138..-33.931...151.154...C------------E.g. For Section B, I want to extract the two segments in green from the underlying blue road. The eastbound (EB) and westbound (WB) road features have a common road id of 1. I tried using two vertex creators, a point on line over layer, a topology builder and feature merger, but I haven't had too much success. Any ideas on how this could be achieved?

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

How to buffer a line with different distances on the left and right side? The question is about road centrelines, where buffer needs to have different distances from centre line on left and right side.

Is there a way to turn on logging of the SQL statements that FME is issuing to Oracle in Workbench 2014?

Hi All, i’m having an issue writing to an AutoCAD DWG file, with a template file. I want to preserve the Model Space, but not the Paper space as i’m editing some attributes within the drawing title block in FME which I want to write back out in the paper space. Even though I am setting preserve paper space in the writer to No, the original blocks from the template file, including the original attribute values, are being written as well as a copy of the block with the new attribute values I have updated in FME. As a result I have 2 overlapping blocks, 1 with the new values I want to keep and 1 with the original values I am trying to replace. I just want a single block with my new values. In the attached, you can see the output from the writer, with the same block duplicated with the new value I have updated and the old value in the template (highlighted in yellow). Any thoughts/ideas/assistance with this would be greatly appreciated, whether this is possible or not possible. I have done

I had a workspace with 13 user parameters. When renaming them all, I accidentally erased one's identifier, and it duplicated it and the new one is bugged. When I try to save, the workspace crashes. After publishing it on the server, trying to run it shows not a single user parameter. I can not delete it, and it is linked to every single transformer of the workspace (copy pasting any transformer from the bugged workspace to a new one imports the bugged user parameter and therefore corrupts the workspace).

Hello, I have previously in Form 2023 added custom paths in the “Edit Data Download Properties → Include Data from Writers” when preparing to upload to Flow. The issue I now have in Form 2024.1 is that after I have published the workspace to Flow or if I reopen the workspace my custom paths are not saved within the workspace, or if it’s saved to Flow as it was in Form 2023. This makes the Republish option button not useful as I can see as I have to rewrite the custom paths. Or have I might missed something? To be clear I belive this only counts for custom paths and the benifit with custom paths is that I can customize how files are organised within the .zipped file from the Data download service.

Hi, this must be easy but can't seem to find it... I want to convert duration from seconds to hours, minutes, seconds. So 337759 seconds should be 93h49m19s. I thought the DateTimeConverter should help me, but can't seem to get it right: results in 21h49m19s... I could calculate it myself, but I guess I'm overlooking a setting in this transformer?

Is there a way in FME to run a workflow similar to esri Intersect tool where a 1 line feature (1 route) could intersect a second line feature (roads) with multiple lines and get a point feature for each crossing point with the distance along the first line feature. Basically crossing point and stationing along a line?