Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 12,684 Posts
  • 50,748 Replies
12684 Posts
G
guidoclaessen
asked in Transformers
Random Vendor port when no Vendor port is specified ?

If no Vendor port is specified in the safe.lic file, a random port is used. Is the random port really random or is there a specific port within the range of 1700 to 8000 which is used ?

110
david_r
Evangelist
7 years ago
I
irfan
asked in Transformers
Simple polygon Spatial Join which can add Mode of numaric field

In FME there are more then one possibility of Spatial joins for the polygons and I have tried all.I have two polygon shape files, one is source and other is target.From source file (which includes some numeric fields) I want join data to target polygon where both polygon layers intersect. For text field this is not a problem but what I am looking for is a Spatial Join which can also add Mode of numeric field to the target layer.

50
I
7 years ago
F
fhilding
asked in Transformers
Inserting newlines in XML Templater?

Hi!My XML Templater workflow is as follows: One feature triggers the root template, that then processes three subtemplates. However, I can't get the subtemplates to begin on a new line.Current state:</node><node id="80000000010000007000" attributes=""> <tags>...</tags></node><node id="80000000010000007001" attributes="">    <tags>...</tags></node><node id="80000000010000007002... Desired state:</node><node id="80000000010000007000" attributes=""> <tags>...</tags></node><node id="80000000010000007001" attributes="">    <tags>...</tags></node><node id="80000000010000007002... But I can't seem to work out how to get a newline in there. I've tried both some CDATA-suggestion from https://stackoverflow.com/questions/10917555/adding-a-new-line-break-tag-in-xml as well as  - neither of which are permitted.

560
F
7 years ago
J
johannesbloemen
asked in Transformers
Removing all intermediate vertices from polylines

Hi,I have searched everywhere but can't seem to find a solution to a this simple task.I want to remove all intermediate vertices from my polylines, result should be polylines consisting of just the original start and ending points.Can anyone point me in the right direction? Thanks!

1110
J
7 years ago
W
winnie
asked in Transformers
Extract cell rows to individual columns

Hi, this is probably a very simple question but the brains not working this morning. I can do this in excel but want to know how to do this in FME.I have a cell with an address split by new rows (Char(10) and I want to split this cell and put the outputs into new, individual columnsexampleDetailsNameOfficeRoadTownCountyPostcodeJohn Smith  Corporation Building  Common Road  London  City of London  W1 2DEDetailsNameOfficeRoadTownCountyPostcodeJohn Smith Corporation Building  Common Road  London  City of London  W1 2DEand I want this DetailsNameOfficeRoadTownCountyPostcodeJohn Smith Corporation Building  Common Road  London  City of London  W1 2DEJohn SmithCorporation BuildingCommon RoadLondonCity of LondonW1 2DE

640
mygis
Contributor
7 years ago
K
khalid_omer
asked in Transformers
Chop line from the beginning

Dear All , We have a line with two vertices , we try to to shorten the line from the beginning to 10 meter using choper by length but not effect , Can someone help us archive this . Thanks ,

40
K
7 years ago
M
mitra
asked in Transformers
creating kml file from sketchup model

Hi allI have a sketchup model where I need to place one tree at certain xyz points. The thing is I already have the point where the tree need to be placed as shape file and a model of a tree in sketchup.Has anyone tried replacing a point data set with a sketchup model and then exporting the whole thing as a kml file.Any ideas would be appreciated

130
M
7 years ago
mark2atsafe
Safer
mark2atsafeSafer
asked in Transformers
FME Community: Flavour of the Month (May 2017)

Hi FME'ers,It's that time again when we get to recognize the contribution to our community by one particular user, and in this case that user is @itay Congratulations Itay. You are the "Flavour of the Month" for May. That's quite an achievement when you were also at the FME User Conference for a week.As a quick reminder, the Flavour of the Month badge is awarded to the community member earning the most reputation points over a calendar month. Itay wins for earning 615 reputation in May, and joins the list of previous winners: @takashi, @david_r, @jeroenstiers, and @jdh Points are earned for all manner of actions, but mostly from the votes gained on questions you have asked, and answers you have posted. So, please, do keep voting when you see a question or answer worthwhile of recognition.It was great to meet so many of you at the recent FMEUC, and to take part in the Hackathon with you. I can't wait to do that again, and I have a few ideas for our comm

30
mark2atsafe
Safer
7 years ago
M
max
asked in Transformers
Take off the Georeferencing - 3d Sketchup Model

Hello Friends.   Recently I have downloaded a 3d sketchup model to put on my kml file. However that 3d sketchup model  came georeferenced (http://sketchup.google.com/3dwarehouse/details?mid=1568c242397cda99752ea028d9049dd3&prevstart=0). So what I am trying is to pass my coordinates x and y and place the .skp according the coordinates, converting it into a kml file. I see that is possible but I am working with many OffSetters, what is really confusing. I would like to know if there is a way to take off the georeferencing in the  sketchup model  to after I just put my coordinates.   Could you help me?   Thanks in Advance

80
M
7 years ago
O
oaralb
asked in Transformers
Replace point dataset with sketchup tree components

Hi allI am creating a large sketchup model where I need to place a large number of trees at ertain xyz points. The thing is I already have all the points where the trees need to be placed as GIS table in a local Postgis database and a model of a tree in sketchup.Has anyone tried replacing a point dataset with a sketchup model and then exporting the whole thing as a new sketchup file.Any ideas would be appreciated/Morten

80
M
7 years ago
F
florena1
asked in Transformers
How to add decimal to a Pointcloud

Hello,i have to thin out a few Pointcloud files. I tried with PointCloudThinner, and it works fine. But i have problems with the decimals. In the original File are all Coordinats with two decimals ,but in the edited file some coordinates have only one decimal. How it add a zero to the coordinate, i tried it with round, and format, but it dosent work.

60
F
7 years ago
salvaleonrp
Enthusiast
salvaleonrpEnthusiast
asked in Transformers
Clone a polygon x times

I have one polygon intersecting a pole. There are 2911 features on this pole feature class, there's only one polygon. After the pole feature class reader, I have a counter that counts the features, I want to use the max count of the counter to pass to the polygon cloner. See workspace below. My cloner number of copies is manually typed. I know I can use the statscalculator, but I'm looking for other options. The rest of the workspace - offsetting coor0 of each cloned polygon to a pole already works.

60
takashi
Contributor
7 years ago
J
jaygis
asked in Transformers
Missing Polygons

Hi There, I am in process of troubleshooting a workspace (2016 64 bit). The workspace sources data from oracle database and then matches the keys with few spatial layers followed by clean up and merging based on key attributes. The output of this process is a shapefile (approx. 100K records). I noticed that FME run misses some polygons that it should have included in the output. I ran the process with just the problem area and it works fine. The problem shows up when I run the full process. I am curious if someone has come across this issue and had any suggestions for me. ThanksJay

780
takashi
Contributor
7 years ago
franco69
Contributor
franco69Contributor
asked in Transformers
sort lines after clipping

I have a route and clip it against areas....but i need the result in order of the flow direction of the route.....which parameter sorts me that because now the result is in no order and when i put a count on it it is no logical order.So please help me... i think its no t abig problem for u guysThx Franco

60
franco69
Contributor
7 years ago
A
aquamarine
asked in Transformers
Composite Test AND OR order in TestFilter

Hi, I am using the TestFilter with a composite test set up. However, the results are not what I am expecting. I believe it is something to do with my use of brackets and the AND and OR operator order.I can't get the following composite test to work:(1 OR 2 OR 3) AND (4 OR 5 OR 6)Can anyone explain the order of precedence for OR and AND in the TestFilter composite test and whether the brackets are even recognised?Thanks

80
david_r
Evangelist
7 years ago
fmelizard
Contributor
fmelizardContributor
asked in Transformers
How to split section polygons into quarter sections

We have polygons that represents sections. We want to use FME to split all these polygons to subsections. i.e. quadrants. Any good ideas?

1860
mygis
Contributor
7 years ago
F
fariyafarhad
asked in Transformers
Last two records in a column

Hello all!This seems like it should be a very simple thing to do but I am drawing a blank. I have an attribute column full of numbers (Dates). I just need to sort it and get the latest two records and put them under separate attributes. This is what the column looks like (already sorted descending). I need to assign "170503" to one attribute (let's call it "DATE")I need to assign "170331" to "previous_DATE"Any help will be appreciated. Thanks!

130
danilo_fme
Evangelist
7 years ago
J
jgillespie
asked in Transformers
What is the best way to bulk transform with GridInQuestIIReprojector?

I have a collection of points in a .CSV which are currently in OSGB36 and have been through the OSTN02 transformation. The CSV file has the following headers;IDXYZabTypeDescriptionI want to put them through the OSTN15 transformation. Is the way my CSV file is formatted causing the problem ? I have been playing around with the GridInQuestII Reprojector, but I have not been able to transform my coordinates successfully. As my points are in the Scottish highlands I know there should be some change, even if it's just a few CM in the Z.Should I re project into ETRS89 Geodetic first then re project into OSTN15 ? I am currently using FME Workbench 2017.0 (32) beta and I'm fairly new to FME so I could be missing something obvious.

140
M
7 years ago
verdoodtdries
Contributor
verdoodtdriesContributor
asked in Transformers
Can you read from a .zip folder that contains only one file ?

Hello FME-community, I have a peculiar situation in which I need to read files inside a .zip-file, and the .zip-file contains only one .fmw-file.I want to do this in a dynamical way, so I make use of the FeatureReader transformer to read the files.Reading from a .zip-file works if the .zip-file contains at least 2 different files. It fails however if the file-file contains only one file or two files with an identical extension.Is it possible to read (Directory and File Pathnames) from a .zip-file that contains only one file inside it?Kind regards, Dries

160
verdoodtdries
Contributor
7 years ago
M
mitra
asked in Transformers
sketch up

I have a question about sketching up with FME. I have some points (shape file) with coordinate system. The points are the location of streetlights. I have the sketch up file (skp) of these lights and I would like to replace the coordinate of sketching files with the coordinate of points. However, I do not know how to do it. Any help would be appreciated.

100
mygis
Contributor
7 years ago
P
pshapley
asked in Transformers
I want to apply the 'DonutBuilder' transformer to several polygon layers, the output layers will be merged into one polygon layer containing the combined dropped 'holes'. How can i achieve this?

70
gio
Contributor
7 years ago
M
mjvoorwinden
asked in Transformers
Convert text to JSON

Having the input txt file , how can I easily convert this into JSON? Each indented line is a new array in JSON. It should look like .Any suggestions how to do this?

1250
mygis
Contributor
7 years ago
ingalla
Contributor
ingallaContributor
asked in Transformers
Convert OS Mastermap with styling

I am trying to convert some 5km tiles of OS Mastermap data to a raster TIFF, but need to include all of the styling as in the Ordnance Survey Mastermap user guide.  Has anybody managaed to convert this data, into any other format really, and include all of the styling?  If so how did you do it.

520
M
7 years ago
4
40_eme
asked in Transformers
Generate unique digital sequential value for each record

Hello, How do I automatically create a unique digital sequential value for each record, unrelated to the record number? Thank you

130
4
7 years ago
K
kajciuk
asked in Transformers
Save number of input files into an attribute

I would like to count the number of input files and return this number to be able to use it in an arithmetic calculations afterwards.To be more precise, I have X Excel files, each containing values that are regularly repeated, but each with a different frequency. I calculated how many times each value occurred in all the files (so I have 2 attributes: value and count), and now I would like to divide each count by X (number of files) to get the frequency as a 3rd attribute.I tried using Aggregator, Statistics Calculator and Counter to get the number of input files, but I get 'missing' or 'null' values when I try to save it as an attribute. How can I 'save' or return this number?

320
K
7 years ago

Badge winners

Show all badges
30,179
Posts
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.