Skip to main content

Transformers

Using transformers to modify data.

  • 12,947 Posts
  • 51,689 Replies
10000 Posts
3d_ff
Contributor
3d_ffContributor
asked in Transformers
FME Python Script for Automated DDH Desurveying (Minimum Curvature, Flexible Intervals)

​@daveatsafe Dear FME Community, I am seeking assistance in developing a Python script for use within an FME workspace to automate the desurveying of diamond drill holes (DDH) using the minimum curvature method. I aim to create a flexible solution that allows users to specify a custom desurvey interval (e.g., 1m, 3m, etc.). Background: Desurveying a drill hole involves calculating the actual XYZ coordinates along its length based on the collar location and survey data (azimuth and dip at regular downhole distances). I've researched existing methods and found the following resources helpful: Understanding Drillhole De-surveying: https://seequent.zendesk.com/hc/en-us/articles/360001547955-Understanding-drillhole-de-surveying Desurveying Methods and Interactive Tool: https://endarthur.github.io/writting/desurvey.html Drillhole Desurveying Python Code (GitHub): https://github.com/WilliamsB39/Drillhole-Desurveying QGIS Geoscience Plugin: https://www.spatialintegration.com/processing-drill-h

313
3d_ff
Contributor
agelfert
Contributor
agelfertContributor
asked in Transformers
BUG? Dis/Enabling transformers within bookmarks - FME 2024

Working in FME Workbench (Form ) 2024.2. When I disable all transformers inside a Bookmark (via right-click => “Disable all Objects in Bookmark”) and then enable them again using the same method, those transformers are still all listed as ‘Disabled’ in the Navigator. FME “knows” they are enabled because the right-click now allows me to “disable” them. But this seems like a bug. How do you disable a disabled transformer?! Not a functionality issue but kinda annoying, as I’m upgrading a bunch of large workbenches and like to turn things on/off for testing.

561
hkingsbury
Celebrity
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
Neighbourfinder - One to one Relationship

Dear All, I am attempting to spatially join the nearest points based on a one-to-one relationship but cannot get it to work. Below is a graphical example of my query: I aim to join the closest yellow dot (627 records) to the nearest black dot (71,533 records). Essentially, I want the Neighbourfinder to identify the closest one-to-one relationship and disregard the others. The default settings of the transformer calculate the nearest points for all 71,533 records, which I wish to avoid. My objective is to integrate the information from the yellow dots into the black dots for only the 627 closest records. Any ideas? Thanks :)

475
galigis
Enthusiast
F
fentanyl
asked in Transformers
Each column value in separate row

I am new to FME and I wish to make the following transformation. From:IDColAColBColC1A1B1C12A2B2C23A3B3C34A4B4C45A5B5C5 To:IDColumnNameValue1ColAA11ColBB11ColCC12ColAA22ColBB22ColCC23ColAA33ColBB33ColCC34ColAA44ColBB44ColCC45ColAA55ColBB55ColCC5 Can anyone help me out?

214
drandall
Participant
kristen
Contributor
kristenContributor
asked in Transformers
Extend Lines to a Point

Hello Safers, I have a layer of tie points, and another layer of line segments. I was wondering how would get FME to snap segments to these tie points? I believe I have to use the line extender, and intersector without incorporating my tie points. Or, is there another way? Basically, I have roadcentrelines from various locales and I have to snap lines together from them to make an unified dataset. Thanks!

301
crutledge
Enthusiast
vxn43
Supporter
vxn43Supporter
asked in Transformers
Automatically change year in new attribute

I have a new attribute named EXPORT_YEAR. I want the Attribute Value to automatically change to 2026 at 12:00AM Jan 1, 2026. Until then it will stay 2025. Is this possible? if yes, what expression do I use?

271
takashi
Influencer
bromp
Contributor
brompContributor
asked in Transformers
Esri Portal Connection for Survey123ReportGetter

Hi there, I am trying to generate a survey123 report using FME. I have downloaded and added the custom Survey123ReportGeter transformer however I am using a portal connection instead of an AGOL connection: After this step i have the Tester that checks for the submit_response_body beginning with {"jobId" however the flow always fails here. I get an invalid token message in my submit_response_body: {"error":{"message":"498: Invalid token.","code":498},"success":false} I am not sure if the request URL needs to be different for portal? or if the token i am providing in my query string parameters is not being read in properly… Any help would be greatly appreciated. This is what my transformer looks like:

221
bromp
Contributor
armando_amador
Contributor
armando_amadorContributor
asked in Transformers
Saving images from data inspectors

Is it possible to save the frame of the data inspectors?I mean, I have this: Two layers overlapped Is it possible to save this image at certain zoom directly in FME from data inspector or the regular translation environment?

312
max_h
Contributor
colejo02
Contributor
colejo02Contributor
asked in Transformers
Organization's locator not working with Geocoder transformer

Hello FME Community, can someone help me configure the Geocoder transformer to use our County geolocator service? I’m using a single-line address, with the locator on an ArcGIS Server. The URL is https://gis3.montgomerycountymd.gov/arcgis/rest/services/geocode/Composite_Locator/GeocodeServer. This is a public-facing locator service for Montgomery County, MD. I’ve tried: Using the above URL Using the locator as an AGOl item in the transformer, both fail. Setting the URL with different paths to the operation or the base geocode folder. Setting the transformer geocoding service parameter as ArcGIS Server or ArcGIS Online. I can successfully use the geocoder transformer with the ArcGIS Global geocoder, but I prefer the County geocoder to ensure the addresses and intersections are within our County. All rows/addresses are rejected with the FME Rejection Code ERROR_DURING_PROCESSING. The County Locator Service works properly in ArcGIS Pro or when an address is presented to the Address Candid

222
colejo02
Contributor
kalbert
Supporter
kalbertSupporter
asked in Transformers
FME 2025 SpatialRelator removes Requestor attributes (BUG?)

@safe I just recognized that the SpatialRelator in 2025 does not release my Requestor attributes as before (2024 and any older version I remember). I’m used to use the SpatialRelator with the setting ‘Generate List’ checked (incl. some selected attributes) and keeping the ‘Merge Attributes’ unchecked. As a result I see all my Requestor attributes and where applicable the list attributes according to the spatial relation I’m looking for. Now in 2025 the above setting ONLY releases the list attributes and all my Requestor attributes are removed. The only way to bring it back is to check the ‘Merge Attributes’ checkbox as well, which is not my intention. I guess it’s a bug since the Transformer page still states for ‘Output’: These are the Requestor features with the new attributes added. One list entry is made for each of the Suppliers that has at least one matching predicate. FME Form 2025.0 build 25208

895
kalbert
Supporter
izabreton
Contributor
izabretonContributor
asked in Transformers
How to Retrieve Error Messages During Translation and Send via Email (FME Form)

Hi everyone, I'm working in FME Form (not FME Server), and I would like to capture any error messages that occur during translation and send them via email using the Emailer transformer. I tried using the LogMessageStreamer transformer, but it seems that it doesn't capture error messages — only warnings and general log info. Is there a way to retrieve the error messages (or even the full log) during a translation, and pass them into the Emailer transformer? I'm looking for a solution that works within FME Form. Any ideas or best practices would be greatly appreciated! Thanks in advance,Isabelle

564
gistech_
Contributor
tthach830
Participant
tthach830Participant
asked in Transformers
Running multiple SQL queries from excel file

Hi, I have 50 SQL queries stored in a excel file. Column A: Name_SQL_Query Column B: SQL_Query I am having a hard time find ways to execute the query and export to a CSV file with Name_SQL_Query. I set the csv writer to dynamic exposed. however, when i run the workspace i only repeated sql 6016 times (this is the number of rows I get when i execute the sql by itself). it seems like the first Query from the excel list is working when i sampled the first 1. However, I am getting the repeating of column A and B. How do i export the result straight from the SQLExecutor?

513
takashi
Influencer
thierry
Contributor
thierryContributor
asked in Transformers
autocad_color in autocad_OD writer

Hello, Do you know why autocad_color parameter is allowed from 0 to 256 for Autodesk Autocad DWG/DWF writer but is strictely limited to 1-255 for Autodesk Autocad Map 3D Object Data writer ?It prevents to write entities with ByLayer (256) or ByBlock (0) Color parameter in addition with OD tables

1063
thierry
Contributor
javierml
Contributor
javiermlContributor
asked in Transformers
How are intersections between 2D and 3D solids possible?

Hello everyone, I’ve been working with 3D Buildings recently and I’d like to add some info to the walls (e.g. indicating which wall has an entrance door). I could set up this information with the 2D Footprints by using the BoundingBoxReplacer and HorizontalAngleCalculator (I’d have used it with my 3D Buildings themselves, but it only works for 2D lines). But I can’t find the right way to add this information to my 3D walls. If I directly extrude the 2D walls instead of the 2D polygons, I lose the classification of Building_IDs that I want. If I reconvert the 2D walls into 2D polygons with an aggregator, all my info goes away and I’m back at the starting point. I tried converting the walls into points with snipping and then converting them into 3D Features with Offsetter and Bufferer such as other past suggestions, but then I hit a wall (pun unintended) becacuse SpatialRelator and SpatialFilter don’t work for 3D Data (INVALID_GEOMETRY will be written). The only transformer that seems to

727
javierml
Contributor
oliver.morris
Contributor
oliver.morrisContributor
asked in Transformers
Feature Reader not respecting max features to read

Hi, wondering if anyone know how to limit the featurereader, I am trying to read only the first 10 rows from each table in postgres and it is still pulling back every row before passing on only 10. What am I doing wrong? Thank you in advance

2497
gracecai
Contributor
bellrosemike
Contributor
bellrosemikeContributor
asked in Transformers
I have photos stored in a database. Normally, I simply use an AttributeFileWriter to extract the photo. However, I want to use the JPEG Writer. Can JPEG Writer be used from an Attribute?

I wish to use the JPEG writer rather than the attribute file writer, because I want to add EXIF data to the image that doesn't exist in the original BLOB. I do not see a way to add this EXIF information when simply using an attribute File Writer.

1454
danilo_fme
Evangelist
katt
Supporter
kattSupporter
asked in Transformers
Find point where lines are parallel

I have two lines that are starting from the same point (blue point). I would like to calculate the geometry of the points where the lines start to run in parallel (approx. where the green points are). How can I do it in FME ?

362
danilo_fme
Evangelist
anderstgd
Contributor
anderstgdContributor
asked in Transformers
Force custom transformer to process features one at a time

Is it possible to force a custom transformer to process features one at a time when there are blocking transformers within the custom transformer? I run into this problem when I try to create a 3DGeneralizer and want to process lines individually. Example: A custom transformer splitt lines into vertices. The lines are also generalized. NeighborFinder is used to match vertices and generalized lines. I want the NeighborFinder to only process features (line and vertices) from a single line at a time. If Group By is used in NeighborFinder it will block features until all lines have entered the custom transformer. Thanks, Anders

454
anderstgd
Contributor
jugoslaviaa
Enthusiast
jugoslaviaaEnthusiast
asked in Transformers
FME Feature Writer - Default Values Not Applied

I have a template.gdb that contains feature classes, and some attributes within these feature classes have default values. Like here for the attribute FLOWDIRECTION When writing features into these feature classes using the Feature Writer, I expect the default values to be applied to attributes where no value is provided. However, this is not happening. What could be the reason for this issue? How can I ensure that the default values from the geodatabase are correctly applied?

303
takashi
Influencer
kalbert
Supporter
kalbertSupporter
posted in Transformers
BulkAttributeRenamer - unexpected attribute removal in FME 2025.0

Just recognized, after migration of a workspace from 2024.2 to 2025.0 a BulkAttributeRenamer shows strange results: The transformer is set to change attribute names to lowercase (mode rename) for a selected set of attributes. This works as expected. However the remaining attributes (not selected for any change) got almost completely removed. ‘Almost completely’ means from the >5000 records only 4 have the attribute after the transformer while all other records show the attributes as <missing>. @safe - although it’s easy to mitigate it might be worth to dig into it. note: in mode ‘keep original attributes’ results are as expected. Klaus

1377
DanAtSafe
Safer
limo
Supporter
limoSupporter
asked in Transformers
How to get seamlines for different aerial photos?

Hi, we are searching for a solution to create seamlines between aerial photos. So we have a lot of photos with different overlapping areas like this: footprints Is there a possibility to create seamlines between the images? So we wouldn´t like to do this manually. It should be approximately the center line of the overlapping areas. At the end we wanna cut out the origin arial images based on the seamlines. Does anyone have experience with this?

293
evieatsafe
Safer
nicholass
Contributor
nicholassContributor
asked in Transformers
Having a problem with data type 'double' when fme is writing shapefiles

Hi all, I work on a mapping project that requires all of our shapefiles to be quality checked at the end of production. I currently have an FME workbench that converts Esri geodatabases to shapefiles for the final check. However, I’m having an issue with one of my attributes. The attribute is being written out by the workbench as a ‘double’ (which I believe has a max width of 19). The quality check tool checks both the data type (needs to be real) and the specified width of each attribute (needs to be 19). When it is checked by the quality check tool I get an error message which states the expected length is 19 and has found a width of 15? It’s fine with it being a ‘double’ though? Any ideas? Will provide more information if needed.

463
takashi
Influencer
sazerty2
Participant
sazerty2Participant
asked in Transformers
How to display GroupID with SpatialSorter using FME Workbench 2024

Hi, I am trying to use the SpatialSorter in my workspace to sort data by location and define group size. However, as I’m currently using the FME Workbench 2024 version, the SpatialSorter is quite different and doesn’t provide a new attribute named “GroupID”, it’s also impossible to define a group size in the parameters. It is quite inconvenient because it’s not possible to use the Aggregator transformer on the GroupID attribute afterwards to group sorted spatial data. As far as I know, there is no unexposed attribute generated from SpatialSorter in the FME 2024 version. To compensate, I used the NeighborhoodAggregator but I’m not satisfied by the results. I was wondering if anyone else encountered the same issue and found another solution ? Thank you for reading!

252
sazerty2
Participant
sleschi
Contributor
sleschiContributor
asked in Transformers
Big difference in behavior between TINGenerator in FME 2021 and 2025

I have a workspace in FME 2021.2.6 where I produce a TIN from a DEM with the TINGenerator. In this transformer there is a parameter called Tolerance. I was playing with this tolerance to find the right amount of detail, that is still acceptable for my task and reduces the amount of triangles in the TIN. Now we’re about to switch to FME 2025 soon, so I thought there might be a performance win with the new Version, so I gave it a try. But I found out, that this transformer does not work the same way anymore and whether I put in 1 or 100 or 10000 in the tolerance, it does not really matter. The result looks way different and in my opinion is worse, than with the 2021 version. Can someone explain me, how I can produce kind of the same results as with the 2021.2.6 Version? How can I reduce the number of produced triangles and level of details within the TINGenerator if the tolerance does not has any effect on this? Thanks for your help Simon Different tolerances in the TINGenerator in FME 2

827
sleschi
Contributor
aron
Supporter
aronSupporter
asked in Transformers
Create group ID based on conditions?

The two lines below share the same end nodes and I want to give them a common group id for later processing. This is to be the step after a TopologyBuilder. I thought this would be pretty simple, but have run aground. So how do I achieve this? The geometris are to be left unchanged. I just want them to have a common “id” if they intersect at both ends. The conditions for the ‘join’ are: _from_node = _from_node AND _to_node = _to_node OR _from_node = _to_node AND _to_node = _from_node Because sometimes the lines orient in different directions.

496
aron
Supporter

Helpful Members This Week

Badge Winners

  • Socializer (Ice Breaker)
    doniwanickahas earned the badge Socializer (Ice Breaker)
  • Teacher (Grey)
    oskarhas earned the badge Teacher (Grey)
  • Welcome Back
    pgammiehas earned the badge Welcome Back
  • Welcome Back
    casperroelofshas earned the badge Welcome Back
  • Student (Grey)
    oskarhas earned the badge Student (Grey)
Show all badges

Community Stats

31,080
Posts
117,834
Replies
38,837
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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