Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Groups
Support
Knowledge

EN

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

10,000 Posts
52,725 Replies

When you subscribe we will email you when there is a new topic in this category

10000 Posts

syedh2993Contributor

asked in Transformers

Create sub-element to every element of the list

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 element2 element3 element4 List{1} element1 element2 element3 element4 List{2} element1 element2 element3 element4 List{n} element1 element2 elem

kenortey8Contributor

asked in Transformers

GML LOD2 To point cloud

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

mahapandianContributor

asked in Transformers

Folder and data segregation and validation in FME form

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 correctly segregated or not. I am currently performing this process manually, which involves copying, pasting, and validating each folder and village individually. This manual process is quite time-consuming and manpower. Kindly help me about this test cases and workflow. I am new to FME and am eager to learn more about its functionalities. Thanks.

davnciniContributor

asked in Transformers

Distribute point within polygon

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

malthernParticipant

asked in Transformers

How do I add a folder with FME Packages SDK

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

vimva679Supporter

asked in Transformers

How to make it AttributeManager handling easy ?

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 ?

p_c_20Supporter

asked in Transformers

Fanning out different attribute schemas to different Excel tabs

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…..🤔

dbannon22Contributor

asked in Transformers

Logging in to new FME AR App

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.

asked in Transformers

Convert STEP-files (.stp) using FME?

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?

vxn43Supporter

asked in Transformers

New record added to table - notification question

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.

vxn43Supporter

asked in Transformers

HTML question for Text Editor

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.

sarvaniContributor

asked in Transformers

How to get LOC_ERROR field added in FME output, like similar to "Make Route Event Layer" - 'add_error_field' in ArcGIS

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?

asked in Transformers

Is there a way of working with GraphQL APIs using the HTTPCaller transformation?

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.

efennContributor

asked in Transformers

SchemaMapper help needed: data not written to new attribute field

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 attribute and removing it with the same result.Thank you!

timboberooskyContributor

asked in Transformers

ArcSDEQuerier - database client sofware failed to load

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 single ArcSDEQuerier, I can connect to the same DB using the same credentials without issue: I know the obvious answer is that something has changed with ArcSDE,

doni.tanParticipant

asked in Transformers

Passing published parameter into Schemamapper within a custom transformer

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 reader: Failed to open file &#39

gorangoContributor

asked in Transformers

Esri SDE Writer truncating function doesnt Reset OBJECTID Counter.

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

pedro.villaObserver

asked in Transformers

How to properly merge three separate features?

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. What would be a better approach before adding the Writer?Thanks!

woltersContributor

asked in Transformers

Perform date conversions within rasters

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!

evoteckEnthusiast

asked in Transformers

I built Excel file attribute feature joiner workflow and I am happy for that.

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-ezema/

ugulsumerdoganObserver

asked in Transformers

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.

asked in Transformers

Chart creation through PythonCaller?

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.

darkspatiallord

asked in Transformers

GDA2020 gotchas - Australian Datum shift

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.

cochdpContributor

asked in Transformers

Work around for SQLExecutor when a column name contains a reserved word

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]”

dilipContributor

asked in Transformers

Filter data using a date field

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,

1
...
19
20
21
22
23
24
25
...
527

Page 22 / 527

Badge Winners

madihas earned the badge FME Form Advanced Training
thiago.brigagaohas earned the badge FME Flow Authoring Training
nia.colebrookehas earned the badge Teacher (Bronze)
skuleprammhas earned the badge FME Form Basic Training
gimmy15+has earned the badge FME Certified Trainer

Show all badges

Community Stats

31,821: Posts
120,861: Replies
39,452: Members

Latest FME

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.