Transformers

I use several XMLXQueryExtractors in my workspace, each with queries similar to the example below. Sometimes a query returns no results, which causes the transformer to generate a warning. This leads to a lot of unnecessary log entries and clutters the log.I’ve tried checking whether the query returns a result before processing it, but the check still sometimes evaluates to “no result.”Does anyone know how to prevent these warnings? Could it be related to the fact that return only uses fme:set-attribute and therefore doesn’t actually return a value?Query:declare namespace gml = "http://www.opengis.net/gml/3.2";declare namespace aixm= "http://www.aixm.aero/schema/5.1";let $id := fme:get-attribute("arc_id")for $arc in ( //gml:Curve[@gml:id = $id]/gml:segments/gml:ArcByCenterPoint, //aixm:Curve[@gml:id = $id]/gml:segments/gml:ArcByCenterPoint)return ( fme:set-attribute("startAngle", if ($arc) then string($arc/gml:startAngle) else ""), fme:set-attribute("endAngle", if ($arc) then strin

HI All,I have a bit of geometry challenge to create a rectangle (or square) polygon based on a cross geometry, some example below:Any ideas how to achieve this?Thanks :)

I trying to find out the differences (and uses) of the 4 version types available in the Esri Geodatabase (ArcSDE Geodb) reader/writer:Version from SDE connection Transactional version Historical marker specific date and timeI’m not clear on the differences between them especially version from SDE connection and Transactional version where the version can be specified. From my understanding the transactional version is where the sde version is specified and if not then the default is used?An explanation or pointing me in the right direction would be very much appreciated.

Using FME Form 2025.1.1.0, I have some 30.000 features that have an attribute containing a polygon in Well-Known Text form. For about 4000 of those, GeometryReplacer rejects them with the fme_rejection_code of ‘INVALID_PARAMETER_GEOMETRY_SOURCE.If I check the WKT, I can’t find any problems with it, and if I use https://wktmap.com/ (with an EPSG:28992) the handful of polygons I’ve checked show up just fine without any errors.Example of one that goes wrong but looks good to me (and wktmap):POLYGON ((78388.897 419890.033, 78421.563 419868.628, 78426.311 419875.727, 78429.69 419880.662, 78426.428 419884.195, 78422.297 419888.73, 78417.812 419891.98, 78413.315 419895.15, 78401.216 419903.072, 78397.477 419905.515, 78379.315 419917.4, 78377.366 419915.657, 78378.144 419913.401, 78379.163 419910.789, 78381.446 419908.255, 78384.409 419905.029, 78389.638 419899.094, 78392.82 419895.507, 78388.897 419890.033))As far as I can work out, it does seem to always be the same features (this is from th

I have a Excel in which some cells have STRIKEOUT text. I can find the cells where the whole cell text is STRIKEOUT by using the advise of the below post.Recognize "strikethrough" in cells | CommunityBut the cells which have STRIKEOUT text and normal text are not recognized. I need to exclude the STRIKEOUT text and work further with NON STIKEOUT text, even if both are in one cell. The first record I can find and exclude but the third record STRIKEOUT is not recognized. Is there a way I can only read NON STIKEOUT text if it is included with STIKEOUT text?The STIKEOUT text could also be part of a sentence like: abcdefghijek mno pgrs tuvwxyzwhere pqrs should be left out.

Hello, I have a polygon dataset and I am trying to find the polygons that are within 200m of another polygon. I am trying to do this using the NeighborFinder in candidate only mode with the “Number of Neighbors to Find” = 1 and “Max Distance” = unset and then using a tester to select the features where _distance is less than 200.  I am getting a lot of features out of the “unmatchedcanidate” port though. I would have though with number of features to find = 1 and an unset max distance all candidates would be matched and given a distance to their nearest neighbor? am I missing something?

In a workspace processing AutoCAD data, I have recently replaced a bunch of transformers with an InlineQuerier, and downstream of it is an AttributeFilter, filtering on the autocad_entity attribute. Because of this, I found that the InlineQuerier is dropping this attribute, regardless of whether it’s exposed when entering.I don’t need the attribute for my queries, so I had not originally added it to query columns, but after some testing, the only way I can get the attribute to persist on the features exiting is to include it in the query columns, specifically include it in my SELECT statement, and also not include fme_feature_content in the SELECT. With a simplified query:Works - autocad_entity is present on outputNot working - autocad_entity missing in outputI found this post  Geometry Replacer - missing attribute after output | Community where the replies note the GeometryReplacer will remove this attribute (among others) to avoid issues downstream - this makes sense, and I’ve found

Hi,  Has anyone else noticed that when you use an attribute creator in your model, or renamer, or in your manager where you reuse an existing field, it works perfectly in your model but is not transferred when you write it to your shapefile? I always have to use a separate creator at the end This used to be no problem at all. I am now using 2025.2, but I had already noticed this in version 1.

I am in the process of automating feature service creation and uploads to AGOL. We have built this process in FME 2023.2.2 and it works as intended. After updating to FME Form and Flow 2025.2, I am getting this error message (see below) when trying to create a fGDB by importing an XML schema created just upstream from the fGDB writer. I have updated my AcrPro to 3.6.0 and made sure that the Python Compatibility is set to ESRI ArcGIS Python 3.13. I have confirmed that the XML is valid by importing it into a working fGDB in ArcPro, and that it is finished being created before the attempt to create the fGDB. The ArcObjects error number points me towards the article linked below, which tells me I have a spatial reference issue, so I am not sure what the actual resolution could be. I am overwriting the spatial resolution in the XML to reflect the state plane coordinate system the potential project will be located in, which was never an issue with previous FME versions. Has anyone else come

so i have this polygon and i can see the min extents and max extents in the record information window. i know that i can get the coordinates and calculate the length and width of the polygons, but i’m interested to know if the min and max entents in the geometry portion of the Record Information can be obtained directly?  

We currently use the ArcGIS Data Interoperability extension for standardization and validation of alphanumeric and spatial data, processing datasets ranging from 1,000 to 10,000,000 records.We are aware that there is a difference in the number of transformers available compared to FME Form, but we would like to understand whether there are deeper technical differences that a beginner user should consider when deciding between continuing with ArcGIS Data Interoperability or investing in a full FME Form license.Specifically, we would like to know: 1. Performance with large data volumesAre there significant performance differences between the two solutions, especially when working with millions of records? 2. Structural limitations of ArcGIS Data InteroperabilityWe would like to understand whether there are important limitations regarding: automation and scheduling of routines, database integration, advanced geometry manipulation, building and debugging more robust workflows.  3. En

I am new to lists and xml in FME and having a bit of trouble. I am trying to use the XMLTemplater to populate an XML tag using a list value.My XML template looks like this: <prompt>{fme:get-attribute("prompt")}</prompt>            <output>{fme:get-attribute("output")}</output>            <data>            {            for $testcount in fme:get-list-attribute("itemlist{}")            return <item>{$testcount}</item>             }            </data> Test count is the output of a list element counter, and itemlist is a list attribute of the items. My output looks like this: <prompt>Material</prompt>            <output>Survey Attributes/Material</output>            <data>                        </data> There are no contents being created within the data tag.I am trying to get it to output like this: <prompt>Material</prompt>            <output>Survey Attributes/Material</output>     

Hello everyone,I am a beginner when it comes to FME and loops. I have the following task: I have an attribute column with a value. (e.g. Person 1, age 18Person 2, age 35Person 3, age 41Person 4 , age 45The age column should now be increased by one value x times per specified loop run. The number of loop runs should be controlled using user parameters and variables.I am using FME 2022. Can anyone help me? I have found examples with loops, but as a beginner I don't understand them.Thank you very much for your support. I look forward to your reply.A.B.

When upgrading from one version of FME to the next, I can upgrade some upgradeable transformers, and I can also upgrade the readers and writers to the latest version. But what about the readers that are called by the FeatureReader (and writers by FeatureWriter)?We just upgraded from 2024.1 to 2025.1, and I upgraded the FeatureReader transformer reading a geodatabase. Does upgrading the transformer, upgrade the GDB reader functionality? Or does it automatically call the latest GDB reader? Or does it stick with the old?

EDIT - I have solved my own issue here! We had some network changes, and I needed the SAS from the top level of the storage account rather than the specific container. Problem solved. I’ve successfully connected to the Azure BLOb using 2025.1 Form using the AzureBlobStorage Connector:I can connect to the “Hosted” folder inside the container “shared-data”. I am connecting using SAS. However, I need to use Flow 2024.2 and so I need to open this same workbench in Form 2024.2…. and this is where the fun starts!The transformer is slightly different, when I try to configure the Container I don’t seem to have the option to add the “Shared-data”. I am a complete novice at connecting to Azure, so please do not worry about over-explaining anything, I need all the help I can get! Many thanks in advance for any words of wisdom.RegardsStu

A caseA column code contains both unique and identical values ​​(e.g., A, A, B, C, C, C, D, E, E).A second column names contains different names.I want to group a column, but the names associated with it need to be merged.How can I easily solve this in FME? Thanks in advanced!

I have a column containing values ​​(contains 1 or more sorted names) that are both unique and duplicate. Now I want to assign a unique number to each value. This means that the values ​​that are the same should also have the same unique number. How can I handle this within FME? Thanks in advance!

I am trying to connect to a SFTP using the FTP caller. I have followed the instructions in https://support.safe.com/hc/en-us/articles/25407554321805-Using-a-Private-SSH-key-with-FTPCaller-to-Authenticate-an-SFTP-Connection-for-FME-Form-and-FME-Flow-on-Windows-Systems and I can connect to the server using other methods (winscp, filezilla) so the new key is working. In the log (with debug enabled) I get the following:SystemCaller: Executing 'start "" "C:\Program Files\PuTTY\pageant.exe" --encrypted C:\PPK\PrivateKey.ppk'FTPCaller (FTPFactory): Using the 'SChannel' TLS library for HTTPS/FTPS connectionsFTPCaller (FTPFactory): FTP info:   Trying ??.??.??.??:22...FTPCaller (FTPFactory): FTP info: Connected to ??.??.??.?? (??.??.??.??) port 22FTPCaller (FTPFactory): FTP info: Failure establishing ssh session: -5, Unable to exchange encryption keysFTPCaller (FTPFactory): FTP info: closing connection #0FTPCaller (FTPFactory): FTP/FTPS/SFTP transfer error: Failed initializationSystemCaller_2: E

Hi All, I have the following set up where / separate's attributes - where Value X and Y can exists multiple times within a month linked to the Item ID.Place / SubPlace / itemID / Year / Month / YYYYMMDD / ValueX / ValueY /  SUMXPlace / SUMXSubplace / SUMYPlace / SUMYSubplace /What i would like to do is after i have the sum per month per place and subplace, is to see the sum again of these sums on a quarterly basis - ie. Jan-Mar = Q1, April-June = Q2.So the final table would be something along the lines of this - to still allow filtering per place/subplace/quarterPlace / SubPlace / Quater / QSUMXPlace / QSUMXSubplace / QSUMYPlace / QSUMYSubplace /Any ideas or help would be greatly appreciated!/Emma  

Hi, I’m working on a script which copies data from an Esri arcsde geodatabase to a postgis database. I need to know if the table in the arcsde geodatabase is versioned before I run the rest of the script, and I have a pythoncaller which runs something like this (simplified here):layername = "schema.layerName"connectionFile = "path_to_connection_file"arcpy.env.workspace = connectionFiledesc = arcpy.Describe(layername)isVer = desc.isversionedfeature.setAttribute("versioned",isVer) self.pyoutput(feature)Now, I don’t want to type in the path to the connection file manually, but rather obtain it by some function which can collect the data from the list of database connections I entered in the settings. Is this possible? I’ve looked into the FME Web Services API reference for such a function without any luck. Best regards,Jacques 👷🏼 

One of the greatest new features of the IFC4x3 schema is that we can write 2D lines to IFC, which was not supported in IFC2x3.Why does the new IFC writer support only 3D surfaces and solids and not 2D line geometries? 

It seems that in the iOS18 update Apple made changes to the HEIC file container that means the FME Feature Reader using HEIF (High Efficiency Image File Format) now fails to read the HEIC files.We are currently using FME 2022.2.Is there a later update that will support iOS18 images? Is there an alternative way to read in these images successfully? 

I'm trying to setup the children and parents list attribute for export to CityJSON. Therefore I thought to use the listbuilder, but I get a different result than it should be. This example is how it should be: And this one is my result. It looks like there is an extra layer in it.How can I solve this?

Hey all, Currently having an issue using the ArcGIS Connector when using FME Flow (or Form without Feature Caching / Counting on), receiving the following error below. Full log posted below the error message. The outcome I am looking to produce is to update a CSV file hosted on an Enterprise Platform. This does run with form with feature caching on. Any help would be much appreciated.Thanks. Ash135 2025-11-14 17:25:19 | Message Type: fme::internal::_v0::py::Exception 136 2025-11-14 17:25:19 | Python Exception <TypeError>: Call to pyoutput() requires an output_tag argument when multiple output ports exist 137 2025-11-14 17:25:19 | Error encountered while calling method `input' 138 2025-11-14 17:25:19 | ArcGISOnlineConnector_2_CALLER (PythonFactory): PythonFactory failed to process feature 2025-11-14 17:24:59| 0.0| 0.0|INFORM|Current FME version: FME 2024.2.1.0 (20241202 - Build 24801 - WIN64)2025-11-14 17:24:59| 0.0| 0.0|INFORM|System Time: 20251114172459 UTC2025

Hi Everyone!I’m currently working on a workflow using a dwg file (water system) to convert it into a geodatabase. I was wondering if anyone has any tips on the transformers and workflow I could use to successfully do this? Right now I have my dwg reader as individual types, leading into an attribute filter, and geometry filter (3 different ones- 1 for water, drainage, and sanitary). These 3 end up writing into the geodatabase. I would like to have feature datasets separating water, drainage, and sanitary written in the geodatabase. I understand this is a big undertaking, but any tips (or perhaps links to guides) would be extremely appreciated! Thank you!