Transformers

Hello,I'm working on an electrical network with substations and feeders.I want to assign a number to each feeder using NetworkTopologyCalculator, grouped by substation name. What I get What I want to achieveMany thanks in advance

Dear All,We need to convert TAB files that contain annotations similar to the following into a SQL Server spatial table with point geometry and an attribute to represent the annotation I have created the following workbench but it does not update the “dimention” attribute with the annotation text available in the MapInfo TAB fileOutput 

In FME version 2023.1. We can keep the attribute field order after schema scanner for most of dataset. But for the attached dataset, we can't keep the attribute field order after schema scanner.Is any problem in my dataset?The fmw is attached alsoThanks

Good day Safers,I’m cutting my teeth on the new DocumentPDF Writer in FME 2025.1  Trying to set up a “Ledger” (17x11  inches) page in the stylerhttps://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/documentpdfstyler-pkg.htmNot really clear how to do this with the Page Properties.I know this is a work in progress so hopefully this can be worked out.  Please advise.Best, Reed

Hi All,Has anyone tried to follow the steps for ‘Using the OpenAICompletionsConnector’ tutorial? Link here: https://support.safe.com/hc/en-us/articles/25407431621517-Using-the-OpenAICompletionsConnectorI have used the FMWT attached to the tutorial but I have the following error when trying to run it: A few considerations below:I’m using FME(R) 2024.2.4.0 (20250318 - Build 24831 - WIN64) I have created my own API Key Thanks

Hi everyone,I’m working on an FME workspace where I have two input ports: One port brings in the main data (features). The second port provides attribute values from an Excel file, which I want to use to filter the data from port one. And here you can see how the data from port one looks:Here is what the Excel file looks like: I’m basically trying to filter the data (output of AttributeRemover_6, see first image) where:destination_class_source = StructureBoundary AND  assetgroup.description = InstallationBoundary AND assettype.description = CabinetBoundary and cus_cstype_id = 2 destination_class_source =

Hello, does anyone know how to create a solid from a list of intersecting 3D planes, the result of the intersection of which creates a closed shape? The input 3D planes are not logically numbered with each other in any way.

Hi,As per my current workspace I use feature reader to read layers from AWS and this after some translation is written to Feature writer with file format as gdb. I want the Alias also to be written to the file gdb. Tried by using attribute manager with similar attribute name followed by _alias (same case as existing attribute). This dint work. Any Ideas? 

Hi I have a point cloud that I want to simplify. I need 1 point in every 1cmx1cmx1cm space/voxel. I already did something similar, but that was in 2D with point clouds containing only ground points and with the resulting point cloud as some sort of DTM.In short, I used the 2dgridaccumulator to make a grid. Then I calculated the mean Z value’s of al points in a grid tile and added that value to the centerpoint of that grid. Than I used the vertexcreator to make the new point cloud.  Now I need to do ‘kind of’ the same thing but in a 3D grid…I was looking at some transformers: pointcloudduplicateremover, pointcloudsimplifier, pointcloudspatialthinner, 3dboundingboxreplacer… I haven’t found a really good way to do this. Anyone with ideas?    

Good morning,I have a folder in an S3 bucket that contains a folder for each day of the year and each of those folders contain about 24 files. Since I need to download the data in order to process it, is there a way to only download the folders that contain the word “2025”?  I have not been able to format a wildcard that works for a folder. I could also potentially use a wildcard to select the files, if there is a way to do that.Thank you,Peter

Hi, We use the transformer HTML2PDFConvertor, but for some reason it has stoped working and reject the input. Anyone who has an idea?  

Just want to check I’m not missing something obvious.I want to dissolve some polygons and then aggregate distinct areas into multipolygons. One of the attributes of the original polygons needs to be concatenated into a single line with no duplicates. Fairly simple with a list builder/listduplicateremover/listconcatenator if i was only using the dissolver. But if i want to get combine attributes from both processes it seems unnecessarily complicated without resorting to python (which only requires a couple of lines). Am I missing an easier way to do this?StartEnd  

I’m connecting a Sharepoint dataset to a portal dataset, with the intention of creating geospatial data in portal, each record having an object-id along with geometry. The Sharepoint record would be manually linked via this object-id, and then FME would sync changes of related columns.My question is which transform (there are so many!) makes the most sense, and how can I limit the updates to only those records that have a matching object-id?In my writer, the upsert action exposes a match column config, but the update action doesn’t. I feel like I’m missing something, as an update statement still needs something to match on.

Hi all,I’m trying to create clean cutouts (like donut shapes) from overlapping polygons in FME.For example, lets say I have four geometries A, B, C, and D, with each progressively larger and fully containing/overlapping the smaller ones. I want to subtract the inner shapes from the outer ones (e.g. D minus C, B, A; C minus B, A; etc.) so that only the ring-like areas remain.  I’ve previously used the AreaOnAreaOverlayer with overlap counts to determine hierarchy (e.g. a shape with 1 overlap is the largest, and one with 3 overlaps is the smallest, so I can then figure out what is what).However, this approach breaks when some of the smaller shapes are missing. I still need the output features to retain their original attributes (e.g. A, B, C, etc.), regardless of which shapes are present.

I have been trying to setup the GoogleGeminiConnector in my FME Workbench to able to prompt and use the Gemini 2.0 Flash model to get me the results.Since GoogleGeminiConnector is a FME Hub transformer, the documentation is not friendly for a first time user of Google Gemini.The GoogleGeminiConnector makes use of the Google Gemini Web Service available on the FME Hub, which again needs some configuration.There are several things to be configured from the Web Services in FME to Client ID/Secret, using the on the Google Console and other configurations, some within FME and some outside FME using the Google Console.Due to the documentation is bits and pieces, a FME user is required to jump between various help documents and web pages.It will be good if Safe can provide a single page workflow, that lists out the steps in the correct order to be followed to make the GoogleGeminiConnector to successfully work in FME Workbench.TxSRG

I am merging incoming attributes in Aggregator.  I concatenate the values from a field but I am getting duplicate values.  How do I create a cleaner attribute without duplicates?  

Hi community, does anyone know how I can convert a LAS file into an RCP point cloud file using FME?

Hello, I have a field consisting of two lines:Line 1: (empty space) String1 (empty space) String2 (empty space) String3 (empty space)Line 2 : (empty space) String5 (empty space) String6 (empty space) String7 (empty space) String8Both lines exist within the same field.My objective:If I choose to keep, for example, **String1** from Line 1 and **String5** from Line 2, then all other strings in their respective lines should be replaced with empty spaces.Alternatively, if I choose to keep **String3** from Line 1 and **String7** from Line 2, the rest of the strings in each line should become empty spaces.In short, I want the ability to retain specific strings from each line while replacing all others with empty spaces.example : Thanks in advance

Hello,I have recently upgraded from fme flow 2024 to 2025.0.1. - (still using fme form 2024 for now)(EDIT: I have since aligned the versions between form and flow, and still getting the same error.)I have a workbench which uses the SharePoint online connector transformer   I am currently using python version 3.12+.I can run this workbench without any errors on fme form 2024, but when uploaded to fme flow 2025 I am getting the following issue:  Any tips on how to resolve this?Thanks. 

We upgraded our migration chain last week from FME 2025.0.1 to FME 2025.0.2 and our Excel writers started to mess up xlsx files. Some column names are renamed and hundreds of them added all with the same name: "Created by LibXL trial version 4.5.0. Please buy the LibXL full version for removing this message."Strange thing is that not all workbenches are messing xlsx files like in the screenshot. Some of them behave as before in FME 2025.0.1. I indeed find libxl.dll library in the plugins folder of FME installation and version is 4.5.0.0.During upgrade to FME 2025.0.2 all workbenches, transformers, readers and writes are upgraded. Recreating Excel writer in FME 2025.0.2 does not help.Can someone please give me a hint if its possible to overcome this issue in FME 2025.0.2?

I have a HTTPCaller to access an API from the Dutch road service Melvin. It returns an attribute with the json including geometry (response_body - here renamed to ‘gegevens’). I am quite new to JSON.In order to extract the features I use 2 JSONFragmenters: one for the attributes and one for the geometry. I've tried many other setups with JSONfragmenters,-flatteners,-extractors etc, but I can't seem to find an answer as to how to get geometry and attributes from a json nicely joined back together.Current setup below. First I extract the geometry from the attribute (gegevens) and then from the same attribute (as the resulting attribute gets changed, thus I created another with the same information named gegevens_basis) by the fragmenter for the attributes. However it multiplies the number of attributes (700+ to 500,000+). Another setup (also below) sent all geometry to rejected. I also tried to do it from the same attribute from a junction but then

Hi,i have an problem with the Oracle Non-Spatial (and Spatial) Reader / Writer.FME seems to have an issue when the password contains a section sign (§).Other special characters don't seem to cause any problems - at least dollar signs ($) and slashes (/) work.As soon as a § is included, the login fails.Version: FME Form 2024.2.1.0 (Build 24801)I tried with Named-Connection and with Embedded Connection Parameters.Maybe it is a similar problem as this post:Error Message:Creating reader for format: Oracle Non-SpatialCreating reader for format: Oracle Non-SpatialEnvironment variable ORACLE_HOME is not set.Connecting to ORACLE database `ABC' with user name of `CARLO_TEST' and password of `***'Error connecting to Oracle database: message

Hi all,I seem to have an issue with writing to the Temp folder location (E:\\Temp, in this case). I will get an error like the following -Failed to write feature data to `E:\\temp\\wb-cache-NSPL_V3.2_ShortName-rUhMFp\\Main_FeatureJoiner_20 -1 24 fo 0 JOINED 0 6641bd2679d46e05f371fbb029766a8cafbc270f.ffsupdating' I've tried creating a new workspace from scratch, renaming it and I am able to copy files to that folder without any issue. I also ran FME Workbench with elevated privileges and as a different user, even with a different Temp location but no success with any of them. Has anyone here had anything like this occur? And if so, is there a known way to resolve it? I've deleted all Temp files and again, no change. All a bit odd out of nowhere!Thank you

I’m migrating to ArcGIS Pro and working on a workflow to convert geodb_pro_annotations to geodb_annotations so that I can edit/create annotations in ArcGIS Pro and downgrade them so that they can be used in ArcMap and read with a legacy tool (that currently has no ArcGIS Pro upgrade path).I seem to be having an issue writing some of the features to a new local FGDB where the FeatureWriter errors out with the following message:“An error occurred while attempting to create a feature using the feature class 'StreetName_Rural_Smaller_LEVEL_63'. The error number from ArcObjects is: '-2147220947'. The error message from ArcObjects is: {Cannot acquire a lock.}”The data is created/edited in an SDE and exported to a local FGDB for this downgrade. There are 25 annotation features containing 1 to 2,000,000 annotation records. This error seems to only occur on annotation features with more than 500,000 annotation records. The others are a

Hi,I have a CSV file containing ObjectID and associated AttachmentNumber values.I want to group the ObjectIDs so that the total number of attachments in each group is as close to 1,000 as possible.How can I achieve this?