Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,714 Replies
10000 Posts
xtian79
Contributor
xtian79Contributor
asked in Transformers
Snipper with multiline case

Using Snipper with a geometry that is composed by a IFMMEMulticurve, The Snipper returns 2x the values expected (as the multicurve includes 2 IFMELines).Let's take a look to the example: this is how it is seen on the Data Inspector: IdValuea = 10b40c60 Something like this sketch is the result:the points that their measure are beyond the minimum/maximum measure of the line, are located at the beginning/ending of each segment. How could I manage this behavior? 

140
caracadrian
Contributor
T
tbarnard93
asked in Transformers
How do i create a pivot chart using data as headers?

Hello,I am trying to create what I would call a pivot chart in excel using FME, I have managed to input my data which represents the number of exports from a certain area of a building by date&year; (similar to below - however my table has a lot more rows as it runs to 2030).DateAreaNumberUnitsExported01/01/2020Area 1501/01/2020Area 2401/01/2020Area 31001/02/2020Area 1201/02/2020Area 2801/02/2020Area 31101/03/2020Area 1101/03/2020Area 2501/03/2020Area 38Basically I am trying to get my data to look like this:-Area 1Area 2Area 301/01/2020541001/02/2020281101/03/2020158so that I have the date running down the side, the Area Number as the table header and the units exported in the relevant cell corresponding to the correct area and date. I would then like to export this as an excel fileHow should I go about achieving this?Thanks,Tom

90
kyrgyzkiwi
Contributor
R
rqf4v9
asked in Transformers
Replace key values in a list

Essentially I want to use an Attribute Value Mapper against a list. I have a csv lookup table of old ID's and new ID's. Then in my workbench I have a json attribute of a configuration file, which I send through a regex string searcher to get a list of all the old ID's in the config. Is there a way to replace all the old values in the list for their looked-up values from the table, so I can then reinsert them in the config? Or should I just hand this step off to python? I have about 20 features going through the workbench and around 60 features in the lookup table. Each json attribute has anywhere from 5-50 matches feeding the list. I've also looked at the List String Replacer but it doesn't allow me to import the lookup table like the attribute value mapper does. I'm not seeing a way of doing this keeping the transformers under a handful. How would y'all approach this problem? Thanks

2010
becchr
Influencer
lifalin2016
Supporter
lifalin2016Supporter
asked in Transformers
Multiple input tags in custom Python transformer ?

Hi group (especially @mark2catsafe I think).Is it possible to build a custom transformer with Python with multiple INPUT tags? Much like what's possible with a custom transformer in Workbench.I have the multiple OUTPUT tags option covered, but can't seem to find any examples of multiple INPUTs.I've scrutinized an FMW file with an embedded custom transformer with two input tags, but can't find anything relating to tags, just a bunch of TeeFactory's.Is it possible to make one such? And if so, how should one define them in the FMX file?Cheers Lars

790
jstanger
L
lawrence
asked in Transformers
Extracting webpage and map content from url

Hi,I would like to extract the project listing as well as the corresponding Lat/Long from the map content together with its attributes such as Project Title, Location, Project Type, Status etc. from the project linkurl: https://iaac-aeic.gc.ca/050/evaluations/exploration?active=true&showMap=true&document_type=project Sample project url:https://iaac-aeic.gc.ca/050/evaluations/proj/80774 I have limited past exposure to htmlextractor, any assistance will be much appreciated.

110
L
chandan
chandan
asked in Transformers
Assign incremental ID to a network based on connectivity

Hello,I have two layer of networks, one is base (red line) and another is candidate (black lines). Want to populate ID in candidate layer as per connectivity with base. All first intersect of candidate layer should get ID 1 then remaining lines should follow the order. Any help? Thanks in advance.

60
danilo_fme
Evangelist
R
rodrigo_ferrao
asked in Transformers
Cluster points based on quantity or maximum distance

Hi Folks,I got a set of 235 points and I need to cluster them, but based in two parameters. I need to spatial optimizer them in clusters of max 5 points and maximum distance between them of 15 km or in groups with less them 5 points and maximum distance between them of 15 km. I am trying to use a NeighborFinder approach, but I got strugle into points that could be in on or more clusters and because of this, I don´t know how to optimize them.Any ideas or tips?

5210
R
freddy17
Contributor
freddy17Contributor
asked in Transformers
Rating a FME Workspace

Hi Everyone, I have quite an interesting question on how one can "Rate" your Input data in the FME workspace. The idea is to use some predefined questions, and then check the Workspace if the requirements are met. If the requirements are met, the Evaluated table gets a Rating/Value. Once this is done, an HTML page is exported with the rating.  I have made an example, but I find the process to be quite tedious, and can be a bit overwhelming on bigger workspaces. My Question is: Are there better ways to rate tables and create ratings on quality of the input data? Or should I rather work with loggers? So in my example, I have a table to Evaluate. I am using three different "Codes" to use for my Rating system Using Statistical Calculators, Aggregators and FeatureMergers, I add the Rating "CODE", to my Evaluated Table.  The Workspace:   The final result is a HTML: 

60
chrisatsafe
Contributor
robotix
Contributor
robotixContributor
asked in Transformers
SQL Executor Error (sometimes) 2019.1

I have a sql executor using an ODBC connection with parameters in it. The params are fed by published params and an inbound reader [into the executor]Only a few small columns are returned and typically less than 200 rows.-When I run the query with params it errors about every other time. Not much detail in verbose just 'Error running translation.' Then it terminates.-When I attach a logger to the result of the SQL executor the translation never errors. -When I hard code the sql executor [just for testing with no params] it never errors. Unless I have nothing attached to the 'result'.- In short the translation works with a logger attached to the 'result' of the sql executor regardless of params or no params, it fails with nothing attached to the 'result' regardless of params, and it works occasionally with params and no logger attached. I can run the translation in production with a logger attached but why do I need to? And why doesn't it work without

470
M
magm
Contributor
magmContributor
asked in Transformers
Self intersections not detected in GeometryValidator

Hi.I'm trying to find self-intersections using GeometryValidator but it just keeps passing all geometry. What am I doing wrong?Above is a zipped shape file which I've tried running through a GeometryValidator in multiple versions of FME. 2015, 2017, 2018, 2020. Checking for self intersections in 2D. Always passes no matter what settings I use. Here's a screenshot.It's originally a rectangle that I've twisted so that it self intersects in the middle. To me it should be obvious that there's a self intersection but as mentioned the GeometryValidator fails to detect it. Does anyone know what the problem is? 

2440
magm
Contributor
warrendev
Enthusiast
warrendevEnthusiast
asked in Transformers
Chart Generator Bar Chart Background Color Not Changing

I've been experimenting with the chart generator transformer and can't seem to get the background color to change, even after I change the color using the "Background Color" parameter under the Style section. This is for a bar chart. No matter what color I change it to, it will only keep the default white color RGB(1.0,1.0,1.0).  It won't change the color in the preview or after I write it out to a png. The documentation states: "This parameter sets the background color of the chart. The default background color is white, with an RGB value of 1.0,1.0,1.0."  FME 2020.0.0.1  

130
debbiatsafe
Safer
kahramannkadirr
Participant
kahramannkadirrParticipant
asked in Transformers
How to smooth the surface of a resampled DTM raster?

Hello everyone!  There were two adjacent DTMs with different resolutions(one is 0,5m and the other is 5m.). I resampled them to bring together and mosaick at 1m resolution. There seems to be no problem with 0,5m res. area in the mosaicked image, but after the resolution is reduced for 5m area, defects like a stair steps appear in 3D view(as seen in the image). So, how can i get a smoother suface for the downsampled area from 5m to 1m. Which transformers or parameters should i use in my workflow. Thanks a lot. @daleatsafe @daveatsafe @takashi @jovitaatsafe @redgeographics @deanatsafe @rylanatsafe @hollyatsafe @lenaatsafe @annabelleatsafe @steveatsafe

2130
jdh
Contributor
rva1
Contributor
rva1Contributor
asked in Transformers
convert ifc to dae

Hi there! hope someone can help.I'm trying to convert IFC into DAE, but having trouble getting the IFC Global ID into the DAE Name and ID properties.Any suggestions?cheers,ronald 

790
virtualcitymatt
Celebrity
jez
Participant
jezParticipant
asked in Transformers
Using Regular Expression Editor to find number strings between 8 and 14 digits long

Hi, I need to find and extract numbers from a string of text, numbers and characters (see example below). The conditions needed are that the number string can only be between 8 and 14 digits long.I'm inexpericed with writing Regex but following some previous guidance from this wonderful FME community I did make a start (see below) however it's not doing exactly what I need it to do.Initally I thought I had solved this until I realised the data has number strings of between 8 and 14 digits/ I'm using the String Searcher transformer. My expression seems to be finding strings of 8 (or more) digits but only extracting the first 8 digits. This means that when the number string is greater than 8 it cuts the trailing numbers off (se below).The data I have been provided with is messy to say the least!In addition to the above question I'd like to ask if its possible to identify and extract, from results of the above, number strings of 8 digits that start with the digit '23&#

14701
ebygomm
Influencer
markcoopersdc
Contributor
markcoopersdcContributor
asked in Transformers
Can you get a list of attribute values in transformer (eg Tester)?

HiI am trying to filter a dataset to show a features that are in set of values . I am using the Tester transformer with the IN operator. If I were to do this in an ESRI product, I could select the field (attribute) I want to filter and it would list all the unique values for that field to enable me to chose the ones I require. However, I cant see a way to get that info in FME - I have to stick in another transformer and inspector and then copy and paste the values I want into the expression, which is far from an ideal workflow.Please could someone tell me if there is an easier way to do what I want to do? Many thanks

3590
fmelizard
Safer
boubcher
Contributor
boubcherContributor
asked in Transformers
Filter Odd and even Number

Hello Guyswe need to filter thousand of address into Odd and even number,we are using the test filter, I think we should use the reg expression for the condition,any idea how to write the expressionThanks

5695
boubcher
Contributor
T
tk_st
asked in Transformers
Bin packing problem with polygon

Hi, I have to fit the maximum number of polygon with specified dimensions into another polygon.I have to analyze two positions: vertical and horizontal and choose the most optimal placement (the largest number of polygons inside)for example:Do you have an idea how to do it in FME?  

970
T
jon
Contributor
jonContributor
asked in Transformers
Converting floating point date based on 1900 Date System

I have a floating point number (i.e. 41165.2823011227) that I need to convert to year, month, day, hour, minute, second.  All I've been told is that the floating point number is the number of days since January 1st, 1900.  After a little bit of research, it looks like you can convert these in Excel (make sure you have 'Use 1904 date system' unchecked under Advanced Options).  When I enter the floating point number and format the cell to Date, I get 9/13/2012  6:46:31 AM which looks correct.  Is there a way in FME to accomplish this same conversion?  More info on the 1900 Date System here: http://support.microsoft.com/kb/180162

3856
avdb
Contributor
R
ravis91
asked in Transformers
Insert Geometry columns from 2 different but related tables into Postgres Database

I have 2 tables say table1 with a geometry column geoloc, and table2 with a geometry column geom,. table1.geoloc in general contains table2.geom. I want to pick those rows where the condition is such, and combine the two tables and create a 3 rd table with both the details including the geometry colmns. I want to rename the columns before inserting into 3rd table

320
chrisatsafe
Contributor
B
burton449
asked in Transformers
On the fly OSM Data reader/converter?

Hi,  I see FME has an OSM XML data Reader. I wonder if its possible to have this reader/converter on the fly using transformers. I use the HTTPCaller to extract data via the Overpass API and I would like to convert the output XML into features, but that's not easy as I first tought because of the way OSM data is structured.  Is there a way to convert the xml data returned by the HTTPCaller into FME features without saving the XML on disk and then using the OSM Data Reader?  Thank you!  Maxime Demers

2040
G
sprongandre
sprongandre
asked in Transformers
Writing to dwg surface

What are the settings (writer and additional attributes) to write to a dwg-surface? So for example to convert a pointcloud to a surface (dwg)Now when I would like to write it to dwg it becomes a mesh (object ;-) ). Thanks!

350
sprongandre
A
amit
asked in Transformers
Remove all attributes with empty fields

Hi,  I have a geodatabase with multiple feature  classes.  The FCs do not all have identical fields.  I want to write a test that removes attributes fields that are empty.  I can't find a way to do this, i.e. select all attribute fields.  The BulkAttributeRemover seems like the best bet, but not sure how to code the expression.  Also, tried the custom transformer NullAttributeRemover, but the script expects the user to select which attributes to utilise (not a Python user).  Any suggestions appreciated!  Thanks.

71415
redgeographics
Celebrity
koenvdw
Contributor
koenvdwContributor
asked in Transformers
gaps after resampling dsm tiles

Hi We have dsm tiles with gcp 3.5 cm, I want to resample them to 25 cm. This is my workbench: The result has gaps of 25 cm, like this: How can I prevent that? Thx

50
redgeographics
Celebrity
H
hgirish31
asked in Transformers
HOW CAN WE CALL PYTHON SCIRPT IN FME

HOW CAN I CALL A PYTHON SCRIPT IN FME, IT IS SIMPLE ONE CREATE A RANGE OF NUMBER AND WRITES TO A TEXT FILE IN RANGE LOOP

220
deanhowell
Influencer
T
thewindgone
asked in Transformers
Extruding lines to faces, the points of each face point in a different order

Hi, I use Extruder to extrude several lines to surface (Parameters: Direction: Vertical). But after extruding, the vertices of each surface point to different orders, some of which are clockwise (the bottom figure) and some of which are counterclockwise (the above figure). If I want to unify the directions of vertices as counterclockwise, how to set?Can anyone help me?

710
T

Badge Winners

  • Welcome Back
    lizsanderson21has earned the badge Welcome Back
  • Integrate Spatial Data
    jbrontehas earned the badge Integrate Spatial Data
  • English Speaker
    strangbyhas earned the badge English Speaker
  • Swedish Speaker
    strangbyhas earned the badge Swedish Speaker
  • Welcome Back
    strangbyhas earned the badge Welcome Back
Show all badges

Community Stats

31,811
Posts
120,827
Replies
39,439
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.