FME Form

I have 3 Excel files and each one has multiple sheets [T1(sheet1, sheet2..,etc), T2 (sheet1, Sheet2,..etc), T3(sheet1, sheet2,...etc). The names of the sheets in all files are identical and the name of the fields in each sheet are identical too but fill with different data. I need to join or merge each sheet from one Excel file with the corresponding one from the others based on a common field (ID) and have one excel file. I did different attempts but I did not get the right results. Could you help please.

Hi everyone,I'm trying to replicate the "Explode" functionality of ArcGIS Pro in FME. The Explode tool in ArcGIS Pro breaks multipart geometries into individual single-part features. For example, if I have a multipart polygon, it will split it into multiple single-part polygons, each becoming a separate feature in the output.I've looked into the GeometryPartExtractor, but I'm not entirely sure if this is the correct transformer or how to configure it properly for this task. Is there a specific transformer or method in FME that is directly equivalent to ArcGIS Pro's Explode?Any advice or examples would be greatly appreciated!Thanks in advance for your help.

Folks,  I have upgraded from 2024.1.x to 2024.2.1.0Clearly the Transformer Suggestor where you start typing a name and it suggests transformers to you is not working properly (I dont know what the function is officially called)But in the previous version - i would start typing and it suggested everything with that name. Now it hardly suggests anything - and when it does its decidedly odd. For instance i type the word “String” and get nothing.. Is there anyway to change the behaviour of this feature? its been useful for years and i really liked it returned a longer list.

Hello everyone,I am trying to use the change detector to compare changes from the current input data compared with previous runs to filter out Features that have not changed in order to save some processing time.  In order to do that I create a hash using the CRCCalculator and save that away. With each new run those hashes are compared agains the previously saved hashes. The ChangeDetector gives me pause though.For some tables the ChangeDetector identifies changes where there are none. Whats more is, when I rerun the ChangeDetector, second time around the results are as expected without changing anything in the workspace. Maybe anyone has some insight into what could be going on here?1st time running identifies updated features that arent updated at all2nd time running without changing anything: differ

HiI need to extract the distinct attribute values of each field/column. An example is provided below: Input    Owner Building_Type Building_ AgeRow 1:  Steve Office 1970-79Row 2: Adam Office 1980-89Row 3: Steve House 2001-5 Output:   Owner Building_Type Building_ AgeRow 1:  Steve Office 1970-79Row 2: Adam House 1980-89Row 3: NULL NULL   2001-5 Any help will be appreciated. 

Hello everyone,My colleague is trying to read a zip file in FME Form that contains 3 .xlsx files. My colleague read in this these three files and exploded the data, so it looks like image 1 and we were wondering how we would be able to transpose it to image 2. A criteria is that A1, B1,C1 should be in the same row  as shown as in image2. I was thinking of using the xlsx_row_id variable and maybe the name of excel file as attributes for sorting that out later. However, to go from image 1 to image 2  beforehand is unfortunately still  a bit of a mystery to us. I looked up into the attributetransposer, but that didn't yield the result I wanted. image 1image 2

Hi all,I’m facing some troubles converting IFC data to Cesium 3D Tiles.Background:I have several IFC files containing mostly 3D objects concerning civil engineering source coordinate system: EPS:2056 different, user-defined PropertySets different IFC versionsGoal:Cesium 3D Tiles with all attributes (PropertySets)What I did so far (transformers in FME):Adding a dynamic reader with autodetecting IFC version Extracting PropertySets from Geometry Doing some cleaning on Geometry, i.e. removing extra Bounding Boxes and adding Vertex Normals Scanning the schema Writing dynamically to Cesium3DTiles FME Version: 2024.2.1.0 (Build 24801)Problems:some features are missingI cannot see why some features/objects are missing. They obiously run through all transformers until the writer. There are no errors, only 2 w

hello there we need to calculate the length of each polygon edge , the polygona could be in irregular shape considering the polygon is 4 edges if we use chopper or Geometrycoercer  transformer we get many edge  we are suppose to get only 4 Thanks  

​Bonjour,Je bataille depuis quelques temps avec l’appel de l’API SIRENE v3.11https://api.insee.fr/catalogue/site/themes/wso2/subthemes/insee/pages/item-info.jag?name=Sirene&version=V3.11&provider=insee En utilisant un HTTPCaller j’arrive bien à faire fonctionner l’API mais je ne comprend pas comment appliquer les variables de la recherche multicritère de l’API POST /siret.Avez vous déjà fait appel à cette API et des conseils à me donner ?Merci d’avance :) Voici l’appel à l’API que je souhaite :

Hello everyoneI am trying to do the following: My workspace writes into a database. I have set a user parameter to give the user an option “delete Database and start a fresh database OR continue adding data onto existing data”. In case of deleting the Database the creation of IDs (which are created in the Process) should start at 1. In case of adding data to the existing database the creation of IDs should continue from whatever the max value already existing in the database is.I believe this should work as follows using a YES/NO User Parameter.Test Filter on that User Parameter:YES → Sampler (create single initiator) → SQL Executor (delete all data with “delete from tables”)NO → Sampler (create single initiator) → Feature Reader on Database → Statistics Calculator (extract max ID) Now in a different path within the workspace I have a Counter which I use to create the IDs. I thought I could simply use a conditional Value set on

Hi having an issue where my FME data update job is running fine from Desktop when you click run.  But when I published the job to FME server and set up an automation to run nightly, it seems to be pulling in old data when it runs. The job reads an excel spreadsheet in a folder and plots it and inputs the output data into our SDE.  It seems like when I publish to FME server the excel spreadsheet is not being picked up live from its file location.  

Happy 2025!I’m processing some OpenStreetMap PBF data and have found a duplicate attribute name, hard to believe but I think an artifact of OSM’s XML ancestry, two attributes differ only in string case, like my_attribute and My_Attibute.  My processing changes all attributes to lowercase so I have two fields my_attribute.  I tried a ListDuplicateRemover on the Schema output of a SchemaScanner but I get an invalid schema definition.  Does anyone with knowledge of FME internals have a tip for dropping one of the duplicate attributes?  Thanks.

This is a HowTo.I had a hard time adding a raster to an HTMLReportGenerator. Thanks to some remarks in an old Question of the Week I found a solution. Many thanks to ​@mark2atsafe!I share my solution here for others that may encounter the same problem (and for myself, in case I encounter the problem once more in a few months 😉).HTMLReportGenerator can't use a raster, but it can use an image. This image must be in binary encoding. The image can be embedded in the HTML, so it suffices to have a temporary image. The temporary image will be automaticaly removed when the workspace finishes.So the process becomes:Use a TempPathnameCreator to provide a path for temporary storage of the image file Use a RasterExtractor

I am reviewing some of the Transformers I either rarely use or have never used and came across the Feature Holder. Can someone provide me an example or two of why/when it would be a good idea to use the Feature Holder Transformer?

Hey. I have created a workspace on my desktop where I used source data from a local disk as part of my testing. Now I would like to have the data for all WS that use these sources in one place on the FME server, specifically on the Resources\Data path. The specific file path is "$(FME_SHAREDRESOURCE_DATA)/TopSky/AirportHeliport.BASELINE". Before publishing WS to the server I set this path on the reader as well, see attachment, however the file cannot be found when running WS from the server. Do you know where could be the problem?Thank you

Hi All,I would require your help dealing with empty values in a columnI have a file with "n" features. In one of the column (Example: Column A) certain values are null/empty. I would like to replace it with non-empty value. Also, Column A has only 2 distinct values - either null or date.Example:Feature     Column A1            Jan 20252            Jan 20253            Jan 20254            null5            null6            null7            Jan 20258            Jan 2025I would like to change Feature 4,5,6 to "Jan 2025" instead of null.In Java world, I would store them in local variable and run column A in loop and replace with value if null.Not sure how to perform similar scenario in FME. Would really appreciate your help in achieving the above expected output.Thanks in advance

Hi all.I'm having a hard time figuring out why lists with one entry, especially if it's read from XML, is mishandled in FME.A list may have any number of entries, and if reading such from XML, they often have any number including zero entries.When flattening the output, cycling thru the list, one normally uses ListExploder. However, if the list in question has one entry, it's auto-exploded, which makes ListExploder reject it. So I have to check the rejected features to see, if the list had been auto-exploded or if it had no entries at all. E.g. two or more transformers instead of just one.Why?Wouldn't it be more logical to _always_ create a list, if there are 1 or more entries ?It works as such in 2021.0Is this behaviour specific to XML (or JSON?) flattening ?Cheers.

Dear community,I want to automatically write all metadata for my geodatabase using FME. So I managed to set this up using XMLUpdater. But I only manage to do this for feature classes. I would also like to write metadata for the feature dataset, and even on the highest level, the geodatabase itself. How can I access the XML for these higher levels of gdb structure?The XML that I find with FME for a feature class only contains metadata for that particular class and not for the higher levels.Thanks in advanceNathan

I have Excel sheet with 2 fields, and I need to create folders with the values of the field 

Hi all,We have a set of points that we want to replace with symbols that are currently in a .dgnlib file. Opening the .dgnlib file does not give us the symbols directly within FME.How can we style the points using the symbols from the .dgnlib file?Kind regards,Ivan

Hello Guys I have a polygon  we need to know the length of each segment and which direction the segment is facing north , south , East or Ouest. Thanks 

I want to read some views in Microsoft SQL Server Database using a Database-Alias (not the Servername).I tried to make a DB-Connection using Microsoft SQL Server (ADO), but it didn't work with the alias (it works with the Servername).With a Microsoft SQL Server (JDBC)-DB-Connection, I can access the DB, using the DB-alias. Then I wanted to read the views, using the Microsoft SQL Server Spatial (JDBC)-Reader:I can access the database, but not the views. (In a database-application like DBeaver it works fine) TheDB- user account I use, is allowed to read the view, but not the underlying tables. Is FME not able to handle those permissions?  

This is my first time using the FeatureReader and the WHERE clause. I’m trying to tidy up my workspace and make it a bit more efficient.In the workspace I want to read in all the track points from an ArcGIS Online feature class and then in the WHERE clause filter it to just the last 24 hours.This is the WHERE clause I’m using. It has the correct date field. I’ve formatted it in the DateTimeConverter like this %Y-%m-%d %H:%M:%S."location_timestamp">='@Value(_24hrsago)'It filters immediately (I think) to what I need (first screenshot), but by the end it has passed through all the points in the feature set. Do I have the wrong output port connected up? Is there something I need to select in the parameters? 

Hi I had to create a script to be able to webscrape a web page using Selenium. I would like to be able to launch the script from FME but I don't know how to do it.If I share the script someone can help me ? thx Francesco

Hi there, Could I please have an update on if the I3S writer support point clouds after the release of 2023.1.1? If not then could I please have an update on the timeframe on this? Thanks, Shilpa