Transformers

Hello, I have a table with 3 records per house. The table includes hundreds of houses. I want to create a new attribute called Type. There are two types only : A and B.For Type A: two values of attribute a1 per house equal the value of attribute a2 of another record of the same house.For Type B: two values of attribute a2 per house equal the value of attribute a1 of another record of the same house.How can I automatically assign the type to each record of any given house? Thx.  

I am downloadning data by several url from different organisation webpages that I later import to tables in a Microsoft SQL server database.I want to get the information if all the attributes that I exposed for a datasorce isn’t containing any values (the value is missing).Is it a way too choose all or multiple attribute at the same time and test if they contain any values?I have data that has like 50 attributes and it is going to take a long time to manually set like a test for each of this attribute individually.

I am fairly new to FME and I am trying to pass an Excel file pathname to systemCaller so I can use it in a Python script. I need to use the SystemCaller as I am using a bat file to change virtual environment and then call Python.What I am trying to do is get FME to just pass the Excel filename via a user parameter to SystemCaller using this statement"C:\temp\Excel_processing.bat" --input "$(excel_infil)"where excel_infil = “C:\temp\Excel_processing\infile.xls”But I get a “File path is incorrect” error in the logger (not in english, so the error is a translation). I have even tried to just hardcode the input filename to the statement but get the same error. I tried this:"C:\temp\Excel_processing.bat" --input “C:\temp\Excel_processing\infile.xls” If i just use the statement "C:\temp\Excel_processing.bat" in SystemCaller, then I dont have any issues and the .bat/python script works as expected but I need FME to pass the filename along. 

I have a file A from which I am reading the creation date through a “Directory and File Pathnames Reader”.Now I want to add the date as data in a column of file B.It should look like this:ID path_created_date 1 2025-04-04 2 2025-04-04  I tried using AttributeManager, but what I get is this:ID path_created_date <missing> 2025-04-04 1 <missing> 2 <missing>  I am very thankful for any other ideas or solutions.

I’ve been trying to process IFC data and convert it into a GDB format, however when running it will just stop processing at 19%. The workspace as worked with other IFC datasets but with a few of them it will stop at random arbitrary percentages too.Has anyone run into this issue before and is there a solution?  

Hello everyone I've been designing a new custom transformer to sum up part of my workflow (in FME Form 2025.0). The issue is that I can't add any of my attributes to the text editor even though all attributes are selected to be exposed in the input parametres.Moreso, If I edit it individually, no attributes appear (as obvious), but if I edit them inside a workbench session and I choose specific attributes to expose, they are still not availaible in the text editor, but they  get instead automatically added as user parametres for the custom transformer. Can anyone explain me how this works? I don't get a clear answer from looking at 

FME Form 2024.2.4 on Windows Server 2016 I’ve been using the SlackConnector transformer for quite some time to send messages when jobs have finished in both FME Form and Flow. It’s been working without fail for the past two years.Just recently we had to reinstall a few things on our VM which caused our user accounts to be wiped. This meant all our existing connections had to be recreated.Unfortunately I’m no longer able to create the webconnection in FME for Slack as it keeps failing on the authentication step telling me “your browser is not supported”.  Slack stopped supporting older browser on 15 March 2025I initially thought the default browser was causing issues so I set it again to Chrome, but I think FME Form must be running an in-built version of IE or something. I’ve also tried recreating to connection of various other machines running windows, but same issue. I can’t seem to find any way of forcing FME to use

Hi everyone, can you please help me out with this one? I have a vector layer with canopy heights. For example:name, index0-1m, 01-2m, 12-3m, 23-4m, 34-5m, 4As the features had been captured by LiDAR, they overlap each other. I am trying to clip the features to show max canopy heights, if that makes sense. 0-1m will be clipped by canopy heights >1m, 1-2m will be clipped by canopy heights >2m, 2-3m will be clipped by canopy heights >3m, etc.I don't understand how to set up a loop in a way that can filter and dissolve higher canopy heights. All feedback and suggestions are appreciated. 

I am using the CoordinateSystemExtractor to extract CRS from shape files. The output attribute _coordsys is an abbreviated name and hard to make use of it downstream. For example. the shape file prj file has the name “NAD_1927_BLM_Zone_15N”, which is an ESRI standard name. But the _coordsys value is _NAD27.BLM-15N.ft_0. I would hope the output is NAD_1927_BLM_Zone_15N so that I can use it directly in EsriReprojector. Any idea to achieve this? I have an excel file with over 150 global CRSs that need to reprojected to WGS 84. Both the sources and transformations in this excel file use standard ESRI names. Want to use this excel file to reproject all source datasets (shape files) into WGS 84 using just one EsriReprojector for which both the source and destination CRS parameters are set directly from the excel file. If you know a solution, please send reply to my work email - allen.guan@woodside.com. Appreciate the help.

I have a workspace that is moving 18million records between databases.  Part of the translation involves updating geometry and reprojecting.  I am running the workspace WITHOUT the option to cache features; however the GeometryReplacer transformer seems to be writing quite a bit of data to memory (expected) and that is not purged (reading 100k features at a time).  Because it’s not cleaning up itself, the workspace is just erroring out because it’s running out of disk space.  I can stop the translation and update the start feature number to continue, but this is cumbersome.  Any ideas how to fix this so I can run this unattended?  

Hi,The TesseractCaller appears to be partially broken at the moment. It sometimes doesn’t return all words from the OCR process and the results aren’t transformed correctly to fit on the page. I suspect that this is the results from Tesseract having been updated since the release of the transformer. See the images below as documentation. Where the existing TesseractCaller produces 38 word results from my input image and the fix produces 81. (This difference is the result of a listexploder rejecting features not containing a list, so nothing has been changed about how FME interacts with Tesseract) The results are also correctly flipped and scaled in FME to match the input image. I have supplied the fixed transformer as a zip to this post. Differences:

Hello Sir/ Madam, So I have a .txt file with Points Name, X, Y, Z. So I would like to create points and import in 3ds Max. My .txt table is as follow Point X Y ZA 822041.761 833958.234 13.519B 821997.708 833954.943 16.341 I create points by using vertex creator transformer. Then I convert to .dxf and import to 3ds Max. It works fine. However, all the points are named "Point" in 3ds Max.  Is there anyway that I can use the Point name "A", "B", etc instead of point? Other formats is fine, as long as I can get the coordinates and point name. Hope somebody can give me a hand. Thank you. 

I am reading some feature types from File GDB as "Single merged Feature Type". One of these feature types while reading is giving me an error saying "Read feature (or portion thereof if SPLIT_AT_ARCS is YES) from the feature class 'xxxyyy' that contains only zero length segments...." How can I read all feature types but ignore this one which is causing error or maybe any Idea how to solve the error problem ? p.s. In different Databases there can be different feature types thats why I am always reading everything but trying to exclude one which name is always the same. Any Idea ?

Since the last update of the GoogleCloudStorageConnector (on 26.03.2025, safe.google-cloud-storage [2.5.0]), it no longer works.I always get this error message:Message Type: fme::internal::_v0::py::Exception Python Exception <TypeError>: JSONConnection.api_request() got an unexpected keyword argument 'extra_api_info' Error encountered while calling method `input' GoogleCloudStorageConnector_CALLER (PythonFactory): PythonFactory failed to process featureI am using FME 2025.0.0 with Python 3.13 on a macOS Sequoia (15.3.2).Except of the transformer update nothing has been changed.The error does not appear on Wondows with the same FME settings.

Hi, I have one column in my excel file that show tha values like below: VARIEDADE ABB4, ABB2, ABB4, ABB5ABB4ABB2, ABB5ABB2, ABB2ABB4, ABB4, ABB4, ABB4 The two last lines have the same value separated by comma. I would like to simplify like below: ABB2ABB4 How Can I do this? Thank´s

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. 

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

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

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!

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?   

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

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 inters

@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

Hi, I have 50 SQL queries stored in a excel file.Column A: Name_SQL_QueryColumn B: SQL_QueryI 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?  

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