Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 12,684 Posts
  • 50,749 Replies
12684 Posts
T
tom.p
asked in Transformers
Want to set specified layernames in the Feature Writer

Hello I want to set the Layernames in my output like in the picture, like the attribute-names of "description"But If I set it in the feature writer like this:Finally in the data inspector, I have still the wrong layernames:What am I doing wrong? Tried a lot of things, but cant solve it by myself. Thank you in advance!  

20
T
3 years ago
giuseppecfgeo
giuseppecfgeo
asked in Transformers
TIN to pointcloud

Hey community!How can I create a point-cloud from a TIN surface?tnkx

300
kailinatsafe
Safer
3 years ago
brandonguo
Contributor
brandonguoContributor
asked in Transformers
Translation Log not giving the correct information

I am using fme_db_operation to write some data into SQL spatial server. After the running finished, in translation log it says:=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Features not written - verify feature type fanout/dynamic settings=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- (Check that fanout/dynamic feature type attribute exists and has a value)=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 12809==============================================================================Total features not written 12809 From my checking, all new data are insert successfully.  Another error log is: Microsoft SQL Server Spatial Writer: Data type `identity' of attribute `gisids' of feature type `featureXXX' is not supported for writing. Attribute will be ignored by writer. The attribute was not ignored, it successfully updated in the database. I am really get confused by the log, it ca

100
M
3 years ago
alc33
Contributor
alc33Contributor
asked in Transformers
microstation (DGN) group - unique value ?

Hi!I would like to be sure... the "group value" on microstation (group of complex elements, like symbol and text) is really unique, by group of element, on each file?On others words, is it possible to use it like an unique identifiant to extract informations link to the same object? thanks!

10
alc33
Contributor
3 years ago
W
wlau
asked in Transformers
Find out matching postal codes from 2 tables

​I have 2 spatial files with postal codes and I already filtered out the duplicates in each table. I want to match the postal codes in the 2 tables and find out those that are not match.   The 2 fields I want to match are 'ADDR_POSTAL_CODE' and 'POST_CODE' (in 2 different tables). Thanks!

40
W
3 years ago
giuseppecfgeo
giuseppecfgeo
asked in Transformers
Shapefile projection

Hey Community!How can I find and know the right projection système of a shapefile that he has not the .prj file?Tnkx 👽

280
david_r
Evangelist
3 years ago
M
myoungy
asked in Transformers
I am using StringReplacer to remove unwanted words from an excel column. Is it possible to remove more than one word at a time or do you have to add a StringReplacer for every word I need to remove.? Thank you

I

576
ebygomm
Contributor
3 years ago
T
tinatuco
asked in Transformers
FME Transformer Example Workspaces

Hi all, Often users from this forum reply and attach a file with a sample workspace that shows how the transformer works. So I wonder if there is a collection of example workspaces for any transformer somewhere ? Thank you!  

20
redgeographics
Celebrity
3 years ago
kirken
Contributor
kirkenContributor
asked in Transformers
Why transformatsion from multipatch shapefile to Cesium 3D tiles results in rotating buildings?

I am trying to load some buildings to Cesium but when translating shp to Cesium 3D tiles I get rotating buildings in Cesium (when changing the camera position), although the buildings' location is correct in Cesium. I've tried converting this shp file to gml and then loading this gml to Cesium ion which makes 3d tiles itself and this works - buildings are not rotating. What could go wrong with FME Cesium tranformer when tiling?

470
kirken
Contributor
3 years ago
I
ianh
asked in Transformers
How to ensure File Geodatabase feature classes have metres as units

I am converting IFC to file geodatabase. Some are in mm. I have used scaler to convert but the geodatabase properties would seem to indicate that the units are still mm. I am not able to convince myself that my script has actually converted correctly. I use 'generate script' to statically convert from ICF to GDB inserting the scaler where there are features to convert before writing out.Any help would be appreciated,Ian

384
I
3 years ago
L
left65
asked in Transformers
I am trying to transform a list of data from a sql table to table like format - probably not making sense so I'll try an explain more

The following is how the data comes in using SQLCreatorAnd this is how i want it to lookThe other tricky part is that there is no limit on the number of nar_num records (rec_seq) that can be linked to a single ass_num - at the moment I have a max of 17 but that could go up or down I looked at the pivoter and didnt have any luck with that but i am new so maybe i am missing something.Anyone have any ideas?         

10
L
3 years ago
A
asmith36
asked in Transformers
Combining weighted attributes into a new attribute in FME Desktop

Hi all, I have a seemingly easy question. I have two feature classes that I have spatially joined using the spatial relator. There are two cities fields in this new feature. For the sake of the example, we can refer to them as Cities A and Cities B. Some values are null in both fields, however the Cities A is more accurate. How do I combine Cities A and Cities B into a new field with priority given to Cities A, assuming it is not null. i.e. if Cities A is null and Cities B has a value, we use Cities B. If Cities A and B both have values for a feature, then only Cities A would be used.

70
A
3 years ago
K
kouri1986
asked in Transformers
I have a line and I want to figure out it's endpoints.

I have different features that are segments of cable. Each one is different and the shape is always straight. My goal is to find both end points and then label one as start and one as end. My question is how do I get the points from a line.

6300
M
3 years ago
giuseppecfgeo
giuseppecfgeo
asked in Transformers
To clip a TIN surface across a 2D square

Hey community! I have a square in 2D and I want to clip a TIN surface inside this polygon, how can I do?tnkx

50
owen
3 years ago
util_ryan
util_ryan
asked in Transformers
Basic PythonCaller If/Else Statement Not Functioning Properly

Hi All, I'm trying to use PythonCaller for a few more complex date calculations that I couldn't find how to easily do with other FME transforms. One of the things I need to do is some standard if/else testing to set a variable based on two other feature attribute values for further processing down the chain, however the results are not returning correctly. I've split out what i'm trying to do into a simple PythonCaller: import fmeimport fmeobjects# Template Function interface:# When using this function, make sure its name is set as the value of# the 'Class or Function to Process Features' transformer parameter def processFeature(feature):    #Define vars    completionDate = feature.getAttribute('PREREQ_COMPLETE_DATE')    notRequiredDate = feature.getAttribute('PREREQ_NOTREQUIRED_DATE')    useDate = None    #Test if completionDate is null and fill with notRequiredDate if so     if completionDate is None:        useDate = notRequiredDate    else:        useDate = completionDate #Set new 

628
util_ryan
3 years ago
T
timhongjong
asked in Transformers
Tester for line features

Hi @everyone, I want to test my 3D Dataset for vertical lines (only horizontal are allowed). I instructed the transformer to test if the z-start point is the same like the z-endpoint. Now the problem is the amount of z-points in the data set differs, some lines got more than 6 or less:  How can I test dynamically for the end z-point? Thank you in advance.

520
ebygomm
Contributor
3 years ago
kalbert
Contributor
kalbertContributor
asked in Transformers
Log message: which transformer fires 'Expression: !isPoly || curve->isClosed2D()' ?

Hello,I have a bigger workspace with a lot of spatial transformations writing into .ffs files. The process is running since two yeas on FME Server 2018. Now after migrating the workspace to FME 2020 the process ends with a FATAL 'Expression: !isPoly || curve->isClosed2D()'.However the .ffs are written successfully.Now I 'm searching for the transformer which might have fired the message to analyse what I have to change.Any ideas?thanks Klaus 

380
J
3 years ago
fikusas
Contributor
fikusasContributor
asked in Transformers
Reading WFS in defined portions

I have to read all the WFS features, but it can't be sequential read, because server crashes then using this method (feature count is ~3 000 000). I managed to read in all features with 10 different WFS readers and XML filtering by attribute. Is there any simpler/faster way to pull it? For example it is possible to somehow read first 100k features, then request another 100k and so on?

20114
becchr
Enthusiast
3 years ago
T
timhongjong
asked in Transformers
How can I ensure that my layers match the correct features?

Hi, I want to check my dataset( with different layers), which contains polygon and line features for correctness. Which Method can I use to check if there are Layers filled with the wrong features? To check it manually is no option, because the dataset is to large.

60
T
3 years ago
mathiku
Contributor
mathikuContributor
asked in Transformers
Raster to polygon - optimization of workflow

I have a bunch of rasterfiles (Geotiff's) which shows flooding-depths under different scenarios. All in all I have 35 rasterfiles with a resolution of 0.4x0.4 which equals ~12 GB each. I also have the same data split in smaller files (approx. 700 files). What I'd like is some advise on how to optimize my workflow. eg. how do i choose a reasonable tile size? Does the float to intergerconversion pay off? Is it faster to call an external rastertopolygon coercer?Right now I: Tile input -> remove redundant tiles -> convert to integer representation -> reclassify tiles -> rasterToPolygon -> simplify -> clip -> collect. Unfortunately the client is reluctant towards resampling the input.  I added a workspace and some exampledata at https://drive.google.com/drive/folders/1AHXnj8nDOZwjqDsam9KCBgMYoKQzAc6i?usp=sharingLet me know if you need more input. Best, Mathias. 

1060
mathiku
Contributor
3 years ago
giuseppecfgeo
giuseppecfgeo
asked in Transformers
Boundary of a raster to vector

Hey community! How can i create a vector outline from the edge of a raster?

80
giuseppecfgeo
3 years ago
I
ianmtq
asked in Transformers
Creating feature base on unique id

Hello, I have a line feature with a unique ID field. I would like to separate them base on the unique ID, so a feature for every different ID. Is there a way to do it automatically and not do it manualy with a testfilter. Is there a transformer that create feature base on every unique entry in a field?

140
M
3 years ago
giuseppecfgeo
giuseppecfgeo
asked in Transformers
RASTER on a TIN SURFACE

Hey community! How can I extrude or lay a raster on a TIN surface? With a DEM? How?

870
hkingsbury
Celebrity
3 years ago
gcarmich
Participant
gcarmichParticipant
asked in Transformers
Add arrow head to line segment to show direction of line

I've created straight line segments using the VertexCreator (x2) and Rotator. I need to add an arrowhead on each line segment to show the direction (from vertex 1 to vertex 2). I tried to copy the approach listed here:  https://community.safe.com/s/question/0D54Q000080hg35/convert-line-to-an-arraw?t=1611682329612 but I'm not getting an arrowhead as a result. There is mention of 2DPointAdder but I don't see 2DPointAdder as a Transform. Also I don;t understand the Line and ArrowHead portion of the solution on the link. My approach so far is:What am I missing?

130
gcarmich
Participant
3 years ago
F
frederic.haan
asked in Transformers
How to optimize time response for a spatial filter or a neightborfinder research ?

Hello, What are possibilities and what would you suggest to optimize and have the best performance (time response) with spatial anaysis (SpatialFilter and/or neightbor(pair)finder) research ? I work with an "Oracle Spatial DataBase" and at this time FME 2019.2 For exemple if I have a located punctual object with coordinates and need to find the closest street axis or all street axis in a buffer around this coordinates, but i don't want to read all my linear objects "street axis" in the database , otherwise each individual research will be quite slow and I need a high performance for time response Thanks in advance for your help and suggestion Regards Frederic

140
M
3 years ago

Badge winners

  • 12 Days Participant (2024)
    danielleatsafehas earned the badge 12 Days Participant (2024)
  • FME Form Basic Training
    mayatsafehas earned the badge FME Form Basic Training
  • Welcome Back
    romerslhas earned the badge Welcome Back
  • Student (Grey)
    mmestrovhas earned the badge Student (Grey)
  • Teacher (Grey)
    mmestrovhas earned the badge Teacher (Grey)
Show all badges
30,182
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.