Transformers

Hi All,I am working with lists and require some guidance on the below scenarioI have list which contains 'n' elements. I would like to add a sub-element to each element in the list.Assuming my list name called as "list{}"Example: (My list currently looks like this)    List{0}        element1        element2        element3    List{1}        element1        element2        element3    List{2}        element1        element2        element3    List{n}        element1        element2        element3        I would like to add new sub-element called "element4" at the end of each list element (i.e., add "element4" as sub-element below "element3" )        Expected Output (I would like to achieve something like below)    List{0}        element1        e

I’m at working on matching indoor point cloud data to gml LOD2 data using ICP so I want to transform my gml data to a point cloud data to help ease the matching. Can anyone please help me? question is how do I transform GML LOD2 to point cloud data? also if there are other suggestions to complete this task. Thank you 

Hi,I have some villages (Primary and secondary villages), each containing a main folder, a subfolder, a data folder, and some empty folders. I will designate one village as the primary village. All sub-village files/data will be stored in the main village folder. Only location path links will be kept in the secondary village folder (marked in red color). Other data will be sourced from different locations (Marked in green color). Finally, I must validate whether all folders and data have been correct

I have a point feature which has been developed based on the polygon ID. All of these points are created at the polygon Centroid, I want to distribute the point randomly within the polygon

I have been using the FME Packager in Python to create my own transformers. I am trying to add an “images” folder to my package that my transformer will use however I get errors whenever I try to package my project.This is my package.yml file, Ive been using the Hello World Package guide for references and trying to look up ways to do it This is my file structure This is the error I get  

How i have atleast 20+ AttributeManager in my FME workbench and this take a lot of my time in editing each of them every time..... When i delete / rename any of my headers......is there better way when i rename / delete Input Attribute it reflects the changes till the end ?

Am creating three sets of numbers from one source file. Each set has a different attribute structure. I want to fan these out into separate tabs of an Excel spreadsheet, using a created attribute that is common to the three streams, but has a different value for each. Have tried every permutation of setting I can think of in the Writer/dynamic schema defn, and cannot get it to respect the three different attribute schemas. Feels like this should be easy, but…..🤔

The new FME AR app update has introduced a login page with a URL or Barcode (see attached). Are these logins for a server app or a FME Flow instance? I cannot find any documentation on the process here. I have not been successful in logging into my FME Flow Instance or server apps so I am not sure what else the login url could be. Any help is appreciated.

Anyone who knows a way to convert STEP-files (.stp) using FME? I cannot find a reader for this format, closest one is IFC I guess. The format is ASCII-based so maybe there is some workaround using other readers/transformers?

I am using FME Form 2021. I have a table with vehicles listed by department.  Vehicle 1234 Department 1Vehicle 4532 Department 1Vehicle 5645 Department 2Vehicle 8472 Department 3 When a new record (example: a vehicle) is added to the table, I want an email to be sent only if the new vehicle is associated with a specific department. For example, Vehicle 6577 is added to the table and is associated with Department 3; thus, an email would be sent notifying the recipient that a new vehicle has been added. However, if the vehicle is associated with Department 1, then no email would be sent.  What Transformer(s) that would trigger the email do you recommend I use to achieve this? It sounds like ChangeDetector could be an option, but I am only using a single table.

I am using FME Form 2021.In the Emailer Transformer Message - Body (Text Editor), Can someone tell me the proper HTML syntax to make text bold?<b>Total Number of Vehicles:<b><br><br>Number of Vehicles by Division- Using the above syntax, the email sent shows all the text is bold, including “Number of Vehicles by Division-”. I only need “Total Number of Vehicles:” to be bold. 

The scenario is as follows: We are able to get the dynamic segmentation done using Feature Merger & Snipper transformers based on event table and routes, but we also want to capture "LocationError" field values like similar to "Make Route Event Layer tool in ArcGIS" Any thoughts are suggestions like how do we achieve it in FME? 

I am in the process of working on an integration between Cityworks and ArcGIS Urban. While I am well-versed in using the HTTPCaller transformer for REST APIs in FME Desktop, after s few hours of working with an HTTPCaller, the only way I was able to make a GraphQL API call was using a PythonCaller with some custom code using the requests library. For now, the PythonCaller route will work well enough, but I would rather lean on the HTTPCaller for when others have to take over this integration who are not Pythonistas.

I’m trying to write data from one ArcGIS Online hosted feature layer to another using schema mapper for field mapping. I’m finding that the features from featureclass1 are being appended to featureclass2, but there isn’t any data written into the attribute fields for these appended features. Am I missing a setting in schema mapper?This is the result of my workspace (featureclass2). Features 4-7 were appended from featureclass1 to featureclass2, but the data didn’t come through.This is featureclass1, you can see there is data for those features.I’m using a csv file for my schema mapping. The schema mapper is mapping one → newfour and two → five. I’ve tried this keeping the source at

I authored some scripts years ago that use the ArcSDEQuerier transformer to query for records in a versioned 10.1 ArcSDE Geodatabase. The machine that FME resides on has FME 2019.3.1, both ArcGIS 10.1 and ArcSDE 10.1, and both Oracle 32-bit (ArcGIS) and 64-bit (ArcSDE) clients installed. The scripts have worked for years without issue. Recently, I’ve had to modify them a bit and on a development FME machine, the ArcSDEQuerier transformer works fine, but promoting them to another same-build FME machine has had some odd results. If I use the exact scripts/workspaces from the dev machine, the ArcSDEQuerier throws the error seen below. Or if I open scripts that were already on this machine, untouched, the ArcSDEQuerier also throws the same error: However sometimes, and I stress sometimes, if I open a brand new workspace and add a si

Hi Everyone, I tried to make use of the schemamapper transformer to create a new output excel spreadsheet which takes a customised schema csv file as an input. The problem is that the schema file sits within a random folder (date time stamp temp folder name - e.g. 20190903100000) each time the workbench run. (PS: the randomised folder is created at the beginning of the workflow and being passed through as an attribute value).Due to the randomised temp folder name which i tried to pass into the schemamapper as the dataset, I am not able to pass it through. I then tried to create a custom transformer where i can pass the temp folder name via attribute value > published parameter for the custom transformer. The new problem I have now is that the custom transformer does not appear to be able to pick up the attribute value (which has become a published parameter) in the dataset field within the schemamapper.It always throws an error shows "ERROR |CSV r

Hello,does anyone know why the Truncate Existing Function in Esri SDE Writer does not reset the OBJECTID Counter of a registered Table. (Table is not Versioned).SDE Writer File is based on World Parameter (not SID) and I am using ArcGIS 3.1.4 and FME 2022.2 (but had the Issue also in constellation ArcGIS 2.6 and FME Desktop 2021)The data is written on Oracle 19.15BrGoran

I have three separate CSVs (readers below in yellow) to which I have added several transformers. I first added a “AttributeFilter” to filter through two values. I then connected to an “AttributeValueMapper” to map the previous two values to given names. Then I added a “StatisticsCalculator” to sum the values within these two values. Then an “ExpressionEvaluator” to convert the values from feet into miles and after an “AtributeRenamer” to rename the field names. Lastly, I added an “AttributeCreator” to add a third field of data. This is seen in the picture below of my workflow. At the end of the workflow, I added an “AttributePivoter” in an attempt to merge all of these together before attaching a Writer and exporting the results as an Excel Sheet. I am not sure the AttributePivoter might be the best way to merge all of this. Wha

I have a raster wherein the values are in epoch time (number of days since 1970-01-01)Is there a way in FME to convert these values into different date formats, such as yyyyddd?DateTimeConverter seems to only work with attributes, but translating all pixels to polygons with attributes for the pixel value is not optimal. I would guess this could be possible with RasterExpressionEvaluator, but if someone can give an example that would be really helpful. Thanks!

Hi folks, I had some urgent need at my workplace, as the GIS database administrator working in a electricity distribution company, I was required to draft out various district data to be used by another department which will require me to decode and clean the data to enable them understand the data format based on their needs. I tried using manual method of copy and past after extracting this data from the database but it was time consuming.I tried FME and I was able to create a workflow using two transformers FeatureJoiner and Matcher and I am happy how this workflow was able to query the two excel files added to the left and right part of the FeatureJoiner transformer thereby giving me the output based on joined attributes file, one is coming as a number and varchar.  Feel free to connect with me on linkedin https://www.linkedin.com/in/anthony-ezem

Hello, I want to cut raster data with a shape data. There are 10 objects in the shape data and 10 raster data. Sometimes the objects in the shape data overlap. There is a column in the shape data that contains the names of the raster data. I want to cut each raster data with only the object with this name. I couldn't find the result despite trying very hard. I am using the clipper transformer. If you have any advice on this subject, I would be very happy.

Hello, I’m trying to create a custom chart (waterfall, combination, etc.) and I couldn’t find a transformer that could accomplish this other than PythonCaller. I’m having trouble integrating my code within FME (2022 version) which requires me to use a few packages to execute. Has anyone been able to accomplish this? I’ve already reviewed the existing FME material out there.

Hi AllA few learned gotchas in regards to GDA2020 transformations.- Dont use the Navigator to convert datums GDA94 > GDA2020 as it defaults to 7 param (unless thats what you want)- Reprojector Transformer is seemingly default to 7Param when it should default to gridshift (have a call logged with Safe)- CSMapReprojector - if you are using Desktop this is the best to use as you can force the transformation from the dropdownHowever if you are going to server and you want the user to select the output coordinate system which may or may not include a transformation you need to automate which method you use by setting it with either a parameter or a conditional value based on the selected coordinate system code  Lots of fun to be had but some caution as well. No transformation is the same.

A column name that I am trying to SELECT in the SQLExecutor is titled: STATEThe line in the SQLExecutor that contains it is as follows:I receive an error message that leads me to believe that it is not grabbing this column, and instead trying to grab the alias that I am trying to establish:Is there a reliable work around for this reserved word? I have tried using the following, to no avail:[STATE][“STATE”][state]“[STATE]”

I am looking to extract data from AGOL to store in a separate table and filter the data by its date field. Essentially I will schedule this every evening to collate all the data with todays date, or run this early morning and filter on ‘Yesterdays’ date. How do I configure the tester transformer to reflect what I need.  Any help is greatly appreciated,