Transformers

Hello everyone,I am using an XML template like the one below to generate fields dynamically in FME Workbench:<field> <name>cod_imovel</name> <description>{fme:get-attribute("cod_imovel")}</description> </field> <field> <name>tema</name> <description>{fme:get-attribute("tema")}</description> </field> <field> <name>dat_atuali</name> <description>{fme:get-attribute("dat_atuali")}</description> </field> My question is: if a new attribute appears in my source data (for example, atrr_1), is FME able to automatically add a corresponding field like this in the template:<field> <name>atrr_1</name> <description>{fme:get-attribute("atrr_1")}</description> </field> Or do I need to manually edit the template each time a new attribute is added?

Hi all, I’m new to FME and would like to know if there is a way to generate a v5 UUID in FME 2024? From what I have read I can’t see a method for this. Thanks.

Prior to Desktop Version 2022. I could read an AGOL service with attachments relatively fast. Now with 2022, it doesn't seem to work at all. I can view the source from the workbench ok, I can read the features in if I disable read attachments. But it doesn't seem to work with read attachments set to Yes any more. The log gets stuck at 'Updating Access Token for..." Updating the token doesn't help either. Has anyone else had this issue? Thanks

Hi everyone,I’m having some trouble with the XMLQueryExtractor. I need to extract from the xml_fragment field the values inside the <name> and <description> tags.Currently, the output from FeatureJoiner is in the format: Theme | ID | xml_fragment What I need is for the extraction to produce the following table: Theme | ID | xml_fragment | name | description

i am trying separate stacked point data in to individual points, can suggest in FME or ArcMap 

Hi all I have a list like somelist{0}.val = 'apple'somelist{1}.val = 'donut'somelist{2}.val = 'aardvark'somelist{3}.val = 'apple'somelist{4}.val = 'aardvark'somelist{5}.val = 'apple'  the list histogrammer transforms it into _histogram{0}.value = 'apple'_histogram{0}.count = 3_histogram{1}.value = 'aardvark'_histogram{1}.count = 2_histogram{2}.value = 'donut'_histogram{2}.count = 1  now I want this information as attribute pairs like attribute_name    attribute_valueapple                   3aardvark              2donut                   1 any Ideas how to do this in FME without fancy scripting or looping are much appreciated! 

I’m using FeatureWriter to write data using dynamic schemas to multiple worksheets of an Excel file. In the particular case where I detected the issue, the data meant for the last worksheet contain just one row and value in just one of the columns. This value is ‘No’.As you can see, the native_data_type of the respective schema attribute for this value is ‘string’.In the result excel file, however, the ‘No’ value is changed to FALSE. I can’t figure out why this happens.The Writer writes other ‘No’ values to other worksheets and all of them appear to written correctly as ‘No’. This is the FeatureWriter setup:   Have I made a mistake somewhere, or is it a bug in the Excel Writer?

Dear FME Community,I’m using a dynamic writer in my workspace and have run into an issue with newly added attributes.In my workflow, I added a transformer to perform an analysis and wrote the result to a new attribute field. However, this new attribute is not appearing in the output file.I understand that the dynamic writer uses the schema from the reader, and since this new attribute doesn’t exist in the original schema, it seems to be excluded from the final result.How can I ensure that this new attribute is included in the output when using a dynamic writer?Is there a recommended way to update or override the schema dynamically?Thanks in advance for your help!

I need to run a mapinfo data converter to convert tab file to map info bin. Wondering how to configure SystemCaller to run MapInfoDataconverter.exeI’m using version 2025.1 of FME. MapInfoDataConverter is an executable specifically aiming at RouteFinder / Drivetime BIN routing files, which is different from normal TAB export when using FME to write standard MapInfo TAB/BIN files (NativeX format).

Hello!Has anyone successfully used the ArcGISBranchVersionManager transformer to automate reconcile and post operations for branch versioned layers? I created the web connection to our enterprise portal and tested it as specified in this article and even connected to my version, so I know the web connection works but when I configure the ArcGISBranchVersionManager transformer to use the same feature layer with my version I get a rejected feature with this message: “`fme_rejection_message' has value `stopEditing failed for session {xxxxxxxxxxx}: The ArcGIS REST API returned an error: HTTP Error Code:  : 'The workspace is not being edited.' Message Code . Further details: '[]''”.  It seems like maybe I’m not configuring the workspace correctly but I don’t see any option to  start an edit session.  Below is the screenshot of my workspace. I am at FME(R) 2024.2.2.0 (20250114 - Build 24820 - WIN64) .Thanks! 

When running an old script in FME 2024.1.1.0 we get 58 errors “The object at location ___ was previously deleted and cannot be retrieved from the Object Stash” (see attached log file).  It doesn’t appear to affect the output, the log file says “Translation was SUCCESSFUL” and CPU and Memory usage don’t get close to 100%.  Can we ignore these errors?This is part of a much larger script but only this part is producing the errors. We updated the transformers and saved the script to FME 2024 but still get the errors at the transformer FeatureJoiner_13.  The only way to not get the errors is to run the script up to the 2 preceding transformers (“Run to this”) and then run FeatureJoiner_13.  The output appears to be the same as when we were getting the errors.  We tried adding in FeatureHolders before FeatureJoiner_13 but still got the errors. ByeDoug

Hi,Newbie type question. I am currently loading in files to a output on a weekly basis. Issue has been I have to edit the file in the workbench with the new filename. The file I upload changes on a daily basis with its name. How can FME pick up the latest file that has been updated without having to change the file path on a daily basis?I have tried to use this https://knowledge.safe.com/questions/65203/read-only-the-newest-file-from-a-directory.html method but unfortunately I am not getting it to work. I also do not need to generate any further data to my existing table, just was interested in the function where it can automatically pick up the latest file at folder level by date modified. Thank You

What transformer could be used to identify if a townland border which is lines, is supported by an underlying line feature and any areas that are supported to be extracted.

Hi all,I’m having issues trying to generate links within a kml file to a photos in the same folder.First I generate the Hyperlink:<a href="@Value(fme_basename).jpg">@Value(fme_basename)</a> Then I use the KMLPropertySetter The link comes into Google Earth: But the link doesn’t work:\\img_2416.jpgNot sure why there are two extra slashes!  Weirdly if I copy and paste the link into outlook or even this post, the link works, but it doesn’t work when you click on it in Google Earth.  Please can someone help me with the syntax?  Thanks. p.s. I’m after a relative link so I can zip up the folder and send it on  

 Hi there,This is a follow up question to one I asked last year around the FTPCaller transformer:Our security team granted a 12 month exemption to our FME workspace and have asked for an update on the issue.Is there any change in the ability of the FTPCaller transformer to be able to view or configuring the cryptographic algorithms used? Thank you,Jonathan

HiI have recently upgraded the OS of the machine FME Form runs on to Win Server 2022 and upgraded to FME 2025.1.1Since this, I have been unable to connect to amazon s3 and get the following message:S3Connector: The specified AWS connection does not have permission to perform the requested action (Key: '', Bucket: ''). Please check the connection parameters and the relevant AWS security settingsDoes anyone know what the issue may be? Thanks

How can I automatically add all attributes in AttributeExposer after AttributeTransposer without having to manually select each one?

I recently upgraded to version 2025.1.0.1 and am seeing an odd error with the H3HexagonalIndexer, as follows:H3HexagonalIndexer (H3IndexerFactory): The clause 'GEOMETRY_HANDLING_Filling_Indexes Replace' within 'FACTORY_DEF {*} H3IndexerFactory FACTORY_NAME { H3HexagonalIndexer } INPUT FEATURE_TYPE Creator_CREATED INDEX_OPERATION { Index } DST_ATTR { _h3index } GEOMETRY_HANDLING { Replace } H3_RESOLUTION { 15 } GEOMETRY_HANDLING_Filling_Indexes { Replace } DST_ATTR_Index { _h3index } OUTPUT { OUTPUT FEATURE_TYPE H3HexagonalIndexer_OUTPUT } OUTPUT { <REJECTED> FEATURE_TYPE H3HexagonalIndexer_<REJECTED> }' is not recognized by the factory 'H3IndexerFactory'Has anyone else experienced something similar?

Hi all,I’m trying to figure out how to use the CodedDomainGDB custom transformer in FME to create domains in an Esri Geodatabase dynamically from an Excel input.I understand that FME does allow creating domains, but it’s generally a manual process—similar to what you’d do in ArcGIS Pro—and Safe Software doesn’t recommend creating domain in FME. However, I’d like to automate this process as much as possible. Input: An Excel file containing coded domain values and descriptions.Goal: Take those Excel values and feed them into the CodedDomainGDB transformer to create or update coded value domains in an EGDB or FGDB.I’m not fully clear on how to structure the input features for the transformer so it produces the correct output. These are the references I’ve found:CodedDomainGDB documentation: https://hub.safe.com/publishers/spatialexjames/transformers/codeddomaingdbExample workflow blog: https://www.spatialex.co.uk/blog/automating-coded-domains-geodatabase/ If anyone has an example workspac

I have a workspace runner that runs a process to do a rough geo-referencing of multiple CAD drawings using a base polygon layer where each polygon matches each drawing.At the end of each drawing, I want to create a simple report with a bunch of attributes and a map / image of the CAD drawing overlayed on my reference polygon to visually see how close it is.I have hundreds of these drawings and don’t want hundreds of reports / images. Is it possible to append a page to a PDF or HTML report after each iteration of the process?   

I am upgrading a workbench from 2022 to 2025, this is updating the Schema mapper from 2 to 3, but SchemaMapper version 3 does not appear to have Microsoft SQL Server as a format type. Am i missing something?SchemaMapper Version 3SchemaMapper Version 2 

Hello, I’m new to this forum and have been working with ETL and FME Workbench for a short time.I’m facing an issue with my XML output: the header and footer formatting come out messed up.This formatting problem does not appear inside the XMLFormatter transformer, but after saving the physical file, the formatting issue becomes clear.Has anyone experienced this or knows how to fix it?

Hi, I was wondering if there is a way in which it is possible to differentiate between an Empty String and a <null> value when using (XQuery in) the XMLTemplator. As an example I created 4 features. The first having a regular string value, and the latter 3 having 'no value', but each a different type of 'no value' (empty string, <null>, <missing>);When creating a dummyXML, I would like to be able to be able to handle/create a different 'b' element, based on the value of the attribute b. Let's say I have two fixed elements 'a' and 'c', and I want my dynamic 'b' element to be placed in between these two, then iterating over the different 4 features I would like to obtain the following result;<dummyXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">    <a>value_a</a>    <b>value_b</b>    <c>value_c</c></dummyXML><dummyXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">    <a>value_a</a>    &l

I’m trying to make use of the JSONUpdater transformer since it seems more clear than doing a search & replace. My issue is I just can’t understand the JSONiq enough to know what I need to do to always find the right JSON Path. I’m reading in a JSON template and in this template are 3 objects at json[“flowcontents”][“processors”]. The problem is the order can change for the processors. I might want 0, 1, or 2. The key is the object # I want always has “name : Build-Parameters”.I’m thinking I have two options.Is there a way with JSONiq to always specify the correct JSON Path in the JSONUpdater, based on the name of each object. Maybe I sort the processors objects in the JSON prior to the JSONUpdater transformer. Then I always specify the correct one to find path. (Thankfully the order doesn’t matter when I push the results back.)I went ahead and made a very simple Workbench which demonstrates my JSON and the problem. Could someone help with either solution or maybe something else I d

I am using FME Workbench 2022.1 along with ArcGIS Pro 3.0. I recently noted an issue when copying data from an AGOL MapService to a local GDB - if the feature class does not exist in the GDB, the Workbench will fail, only reporting "Error running the translation" and no further details in the log file. However, if I create a feature class in the GDB, even without any attributes, and change the writer to "Drop and Create" from "Create If Needed," the Workbench runs. Any Ideas?  Log File attached