- - Community Resources
Ideas
Product Updates
Events
Groups
Support
Knowledge

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

10,000 Posts
52,712 Replies

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

10000 Posts

Most replies

Most views

Newest first

sofiaContributor

asked in Transformers

IterativeSnipper - combine polylines and segment a continuous feature by a certain distance

I have a layer with several polylines that represents a hiking trail in southern Sweden. I need to segment this trail into equal lengths in one direction along the line, either starting from the north or the south. At one point the trail splits in two and one feature ends in the middle of another, otherwise all features are joined on the start and ending vertices of each other. The sum of lengths of the lines is 85 266.31 m.The layer uses projected geographic coordinate system: SWEREF TM 13 30, which I believe is LatLong @david_rI am trying to use the IterativeSnipper to cut the trail into 4000 m segments. First I tried to aggregate the polylines, since I want the lines to go in one direction, or to have one starting and one ending point. The translation failed because of invalid geometry that time. And I couldn't get the LineCombiner to work either @egomm.And when I use only the IterativeSnipper with the below parameters, I get a result of 27 polylines with most of the features (1

1040

6 years ago

krenty

asked in Transformers

Why does the DatabaseJoiner transformer work so much slower in FME 2018.0 vs FME 2017.1? (Bug?)

I have been developing an FME workflow in version 2017 and have since upgraded it to run in version 2018 but am noticing a vastly slower processing speed when running the DatabaseJoiner transformer in the 2018 version. I can literally count each feature as it gets joined. This used to happen in 5 seconds at the slowest in the 2017 version and in fact I can run the DatabaseJoiner in a workflow identical(data and workflow) to the slow 2018 version and it will run super fast. This may be indicative of a bug in this transformer. Can someone help me find out if this is the case? I used to be able to run this workflow in less than 3 hours but in the 2018 version it takes over 9 hours to finish processing.

700

6 years ago

sigtillSupporter

asked in Transformers

Clip 6 000 000 triangles against 20 areas

How to speed up Clip 6 000 000 triangles against 20 areas. Have tried Clipper, Spatialrelator, spatialfilter. With no luck for speeding.Using Postgres is an option, but would prefer a lightning-fast solution that only includes FME without a DB-backend :)

6 years ago

iluvatar

asked in Transformers

Convert a file for me please ?

Hello all,I am a newbie to FME and have failed at the first hurdle to convert an .XML file to .csv format.I really want this converted but do not have the time to learn how to use FME (wonderful, though it is) to complete the task.Would anyone like to do this as a simple challenge to their skills? The file is of no commercial value but it is about 115MB in size. I would simply like it converted to an .xlsx or .csv file with a flat structure.(I would use somethimg like www.wetransfer.com to send it to you).Any takers?Thanks one and all !!

3170

6 years ago

oliver.morrisContributor

asked in Transformers

JSONTemplater displaying floats values go long

I am pushing data that I have cast as a double number to the JSONTemplater - it goes in as 0.09 once it comes out it gets longer becoming: "prod_index" : 0.09000000000000001This seems like a floating point rounding number issue. Can anyone suggest a way around this.Many Thanks,Oliver

313

6 years ago

usrfabian

asked in Transformers

Processing IFMEPointCloud in Python Transformer

Hi together,I'm trying to create a transformer that processes point cloud data from a LAS file. To do so, I'm modifying the CenterOfMassCalculator_Python example.How can I access the point cloud data? The feature.hasGeometry() attribute is true, but feature.getGeometry() returns None. Code:def input(self, feature): self.logger.logMessageString("--- input() ---") self.logger.logMessageString(" Feature type (fme): " + feature self.logger.logMessageString(" hasGeometry (fme): " + str(feature.hasGeometry()), fmeobjects.FME_INFORM) if feature.getGeometry() is None: self.logger.logMessageString(" Geometry is none")Output:--- input() --- Feature type (fme): LAS hasGeometry (fme): True Geometry is none

420

6 years ago

georgefloros

asked in Transformers

UPDATE SQL Server & UpdateDetector

Hello,I have inserted an Excel spreadsheet in SQL Server with total rows = 6.357. I want to update the existing table with an updated version of the same spreadsheet (i.e. 2 row values have changed; else remains the same). My workflow is:Readers: (I) new excel spreadsheet and (ii) connection to the existing table in db. I then use the UpdateDetector transformer and the output is: Unchanged: 6.356 and Inserted: 1 and Deleted: 1.This one is the one I modified in excel, so it is the right one. My modification however, was to add a prefix in two of the column values of one row.Thus, I would expect to find the change in the UPDATE. Could you please enlighten me why this happens?What I wish to achieve is, update the db with all the changes of the spreadsheet in any time. Do you think it is feasible, without having to specify a column value on the where clause?I want to automate the process of updating the db based on an updated spreadsheet using FME Server. This means, I do not want to be th

340

6 years ago

fikusasContributor

asked in Transformers

Coordinate index out of bounds

I'm getting the error when reading from GDB 9.3 with FME 2008. Any ideas how to fix this?

410

6 years ago

arthyContributor

asked in Transformers

How can I add elevation on arc without changing its structure?

Hello,I would like to add elevation values on arc without changing its structure.Before, I have this arcAnd after I would like the arc to have this where the highlighted values should be the elevation valuesSO far my idea to do that is to usearc =feature.getGeometry() feat.setStartPoint(fmeobjects.FMEPoint(feat.getStartPoint().getXYZ()[0], feat.getStartPoint().getXYZ()[1], elevation_start)) feat.EndStartPoint(fmeobjects.FMEPoint(feat.getEndtPoint().getXYZ()[0], feat.getEndPoint().getXYZ()[1], elevation_end])) but it is not working.Any hints?

6 years ago

pelwinderpal

asked in Transformers

Removing one of 2 coordinate systems

I have a citygml file and it contains 2 coordinate reference systems. One of them is 2 dimensional and the other is 1 dimensional for height. I want to remove the coordinate reference system just used for the height. Currently I can only remove coordinate systems for both using coordinate system remover.

200

6 years ago

terezia86

asked in Transformers

Attribute Filter

In incomming data to AttributeFilter has the table about 80 cells, after filtering has table only about 50 cells. What happend that 30 cells dissapear?

6 years ago

jryan

asked in Transformers

Geocode and OSM Timeout

Hello,I have been trying to determine why the Geocoder transformer (using OpenStreetMap source) keeps stalling after ~500 features have been processed. Does anyone know if there is a limit that can be processed?Thanks

240

6 years ago

georgefloros

asked in Transformers

2D lines to 3D Features

Hello Everyone, I am looking to convert 2D Lines to 3D Features. I am not looking though to add Height value, what I want to do is take a line and based on an attribute value (diameter: 250mm for example) create a 3D cylindrical version of it. Then I will add elevation values using the 3D Forcer, that I am aware of. I have taken a look at 3D Forcer/Interpolator, SurfaceDraper, etc. but I do not believe they do the trick. Could you please point me to a direction? Thank you for your time. Kind regards, George Floros

1510

6 years ago

bubblebebContributor

asked in Transformers

random letter generator

I am creating some anonymized data for testing purposes and need to create a fake Land Registry Title Number (found in the UK). These are references such as CU556644 or LAN33445. I can generate the random numbers for it but I need to generate random letters in either combination of 2 or 3 letters or both. Has anyone come across a way of doing this?Thanks

2603

6 years ago

sidhucivil5932

asked in Transformers

Help with Python and IfcOpenShell

Greetings for the day, I am new with the coding world. I am using Python and IfcOpenShell to work on IFC files. I want to use a command ifc.open but it is not working. I am using Python 2.7. Please help me with this issue. Thank you

660

6 years ago

nedwatermanContributor

asked in Transformers

Create schema for CSV file

Hi, I'm trying to read in a CSV file that has no header information. Additionally the data is spread around several columns rather than in a single line. Looks like the first row is junk.The second is the site name.The third is the site number.Fourth is pressure informationFifth is the date and start time of the data6 onwards is the dataHow do I first create a schema that FME uses before it tries to open the file? I attach a file as an example.Thank you.

710

6 years ago

arthyContributor

asked in Transformers

How to add a measure on point of a line?

Hello,I have multiple segments line for which I would like to add a measure on the starting/ending of each segment. In other words, I would like to create a "fake" LRS where the measure will be computed from some attributes of the feature.I thinking of using python with this logic def addMeasure(feature coord = feature.getAllCoordinates() n=len(coord) mfr=feature.getAttribute('MEASURE_TO') mto=feature.getAttribute('MEASURE_FROM') if mfr!=None and str(mfr)!='': setMeasure(coord[0], mfr) setMeasure(coord[n-1], mfr feature.addCoordinates(coord)where setMeasure should be a python version of the measureSetter Transformer.How should I proceed?

443

6 years ago

mike_gale

asked in Transformers

Autocad - Zoom to Data Extent when opening DWG

Hi all I am using FME to convert a ESRI File GDB containing building polygons to AutoCAD DWG. Really simple styling and the resulting file looks fine except for one thing - when opening the DWG it opens at THE SAME location as the template file. The template file is overidding the new data. This is not great if I have data in say Manchester and the template file is in London. This is a process I need to batch repeat for multiple locations are the UK - but the resulting DWG will always startup in the London location despite there being no data there. I have not had this problem before with a similar task. (1) Is there a format setting I can utilise to tell the DWG to zoom to data extent on startup? (2) The only styling information I am taking from the Template file is "Visual style - Realistic with no isolines" (creating 3D Polygons) is it possible to set this in FME without the need for a template file. This is a really simple issue that I can't seem to fix and

1200

6 years ago

nielsgerrits

asked in Transformers

FeatureReader outputs only schema feature for first initiator.

Something I encountered recently: When I send multiple features into a FeatureReader, I only get one SchemaFeature. I expected one SchemaFeature per initiator feature.As I needed a SchemaFeature per Initiator, I merged them using a FeatureMerger after the FeatureReader. But I keep wondering if this is how it is supposed to work?Thanks!

1340

6 years ago

nielsgerrits

asked in Transformers

FeatureReader does not prefix attributes on SchemaFeature.

When the FeatureReader outputs a SchemaFeature, the attribute handling differs from Features. For example, I use the Prefix Initiatior option a lot, but it does not work for SchemaFeatures.Is this how it should work? Thanks.

6 years ago

arthyContributor

asked in Transformers

How to create geometries with a python caller?

Hello,How can I replace a line with its corresponding points with a python caller?I tried the following code but it is not working.import fmeimport fmeobjectsclass pointCreate(object): def __init__(self): pass def input(self,feature): if feature.hasGeometry(): coord = feature.getAllCoordinates() cpt = len(coord) #coordSys = feature.getCoordSys() for cpt in range(0,len(coord)): feature.setAttribute('X_e', coord[cpt][0]) feature.setAttribute('Y_e', coord[cpt][1]) feature.setGeometry(fmeobjects.FMEPoint([float(coord[cpt][0]), float(coord[cpt][1])])) #feature.setCoordSys(coordSys) self.pyoutput(feature) def close(self): pass Any ideas,Thanks

2744

6 years ago

stephenhersee

asked in Transformers

SQLCreator - Attributes to Expose help

Hi, I'm new to the FME world, and have a question that probably has a super obvious answer to anyone with experience with FME. SQL is rather new to me too. I've got an SQLCreator with the following SQL Script running in it, against an Oracle Spatial Object database.I know I need to enter something in the 'attributes to expose box', but I can't for the life of me work out what it needs to be.FME_SQL_DELIMITER /DECLARE GLASSHOUSEAR number;BEGIN select count (*) INTO GLASSHOUSEAR from GLASSHOUSE_AR;END;/DECLARE RAILWAYSTATIONPT number;BEGIN select count (*) INTO RAILWAYSTATIONPT from RAILWAYSTATION_PT;END;/DECLARE MARINEWATERAR number;BEGIN select count (*) INTO MARINEWATERAR from MARINEWATER_AR;END;/ When I use the following in the SQL script, all I need in the 'attribute to expose' is 'count(*)' and it throws the count out as expected.select count (*) from RAILWAYSTATION_PT; Could someone point me in the right direction so that I can get the SQL creator to output the correct th

1026

6 years ago

ivanpasiczd

asked in Transformers

Using FME to create quantized mesh tiles?

Hi,I know that FME has WebMapTiler as one of transformer utilities and it's good for creating image tiles in 2d web map applications.However, as 3d web gis is evolving and as there is more possibilities to build nice 3d web gis applications using libraries like CesiumJS and similair, i wonder if there is any plan in near future to enable tiling of 3d datasets using FME. For example, that you have 3d mesh and you want to create quantized-mesh tiles using some FME Transformer ? I know it's probably not so easy to implement at the moment but I would like to know if it's something that is on TODO list or not? Thank you and kind regardsIvan

940

6 years ago

joshuadamronContributor

asked in Transformers

Manually save backup copy (Workbench)

I am hoping someone can point out if FME has a "Save a Copy" feature for manually saving a back up copy of a workbench. I searched here in the community and elsewhere and found references to backup functions for FME Server Workspaces, but nothing specific to the desktop workbench. Perhaps this function is called something else in FME speak so here's a description of my workflow:When developing a workbench I periodically save a back-up, currently when I do this I go File > "Save As" and save the file with a sequential suffix like [filename]_ii.fmw then a while later I'll save another copy as [filename]_iii.fmw and later [filename]_iiii.fmw. Sometimes I'll tag a date on the end. As the project nears completion and its down to the final tweaks I find that I'm working out of a "master" .fmw that is simply [filename].fmw and when I save a back up I use "Save As", add the sequential suffix, then do "Save As" again and s

590

6 years ago

lifalin2016Supporter

asked in Transformers

Merging multiple WMS images ?

Hi.What is the optimal way to merge several pictures from different WMS servers on top of each other ?All pictures are transparent PNGs except the bottom layer, which is JPEG.All pictures have the exact same size and map view.I'm using ImageFetcher to get the WMS images.Cheers.

360

6 years ago

Page 299 / 527

Badge Winners

mglimsdalhas earned the badge Welcome Back
bchadhas earned the badge Webinar Watcher (Ruby)
fme_studenthas earned the badge Webinar Watcher (Grey)
jkenneyhas earned the badge English Speaker
brownjusthas earned the badge Webinar Watcher (Grey)

Show all badges

Community Stats

31,802: Posts
120,812: Replies
39,429: Members

Latest FME

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

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.

This file cannot be downloaded

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

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.