- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,684 Posts
50,748 Replies

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

12684 Posts

Recently active

Most replies Most views Newest first

eshirinyan

asked in Transformers

Creating a CityGML with BuildingPart in a proper and compact way

Hi, I am trying to write a CityGML LOD1 file containing building parts in a proper way. I use OSM data (3dbuildings.com) in geopackage format as a proving ground. The only example workflow I have found was about Cesium https://www.youtube.com/watch?v=xSB_GLB_ikQ but the output file consisted of building parts only. Actually I find resulting files looking similar to sample data from Hamburg in FZKViewer but I am not sure anyway. The main idea as I get it right is to remove geometry in case of a building that consists of building parts and link them to a parent building with a gml_parent_id. Do I need to create a separate gml_id for each building part or it's enough to leave a part without it? Unfortunately there are errors while validating an output file. Can I connect directly buildings without geometries and building with geometries into the same CityGML Building writer? Is there a more compact manner to get a right result (please find attached a workspace)? It looks clumsy ma

791

3 years ago

tintin20

asked in Transformers

3D Rotation of extruded polygon

I've been trying to rotate a 3D feature around its own axis using the 3DRotator but I don't seem to be able to get the custom axis right. Could someone please help me setting the parameters based on the input feature coordinates so that the result is rotated 90 degrees around the feature axis? I've attached my workspace as starting point. Here's what I've got: Buffer line to polygon:Extrude to solid Now rotate the feature along its axis (indicated by red line) - rotate as shown in green:

436

3 years ago

mcannalea12Contributor

asked in Transformers

Apply Statistics Calculator summary to all features

I have two groups of features, we will call them Group A and Group B. I'm processing them separately and then summing up Group A attributes using statistics calculator which I then need to use to calculate values for Group B features. Is there a way to force the .sum or .max value to features not a part of the original calculation?

1131

3 years ago

eddyfleming

asked in Transformers

JSON Defragmenter value issues

Hi, I'm having problems with the JsonFragmenter. When I supply de HTTPCaller output to the Defragmenter some values are adjusted. I can't explain why.Anyone with a solution? Regards,Eddy FME InformationEdition: FME Database Edition (floating)Version: FME(R) 2018.1.1.2 (20190121 - Build 18586 - WIN32)

148

3 years ago

lambertusEnthusiast

asked in Transformers

Reading XML as output from ZipExtractor

Using a HTTPcaller I downloaded a Zipfile which contains a XML. Using a FeatureReader I retrieved the path of the XML file. Furthermore the FeatureReader was used to read this XML using 'path_windows' as attribute which contains the XML file. However, I got stuck there. In case I read the XML directly using a XML reader it works perfectly.See the attached screenshot for my workflow.

445

3 years ago

jgarciafdez111

asked in Transformers

Produce an image (from vector and pointcloud) and link/embed it in a HTML report

HI guys, I am trying to create an image from vectors and point clouds, and later include it on an HTML report generator. After RasterExtractor and a BinaryEncoder, the HMLResportGenerator is unable to open the image file. Do you have any suggestions? Thank you!

361

3 years ago

jgarciafdez111

asked in Transformers

Filter points based on centre of mass

Hi guys! I am facing what it seems an easy challenge. I have a group of points and I want to filter them using as reference the center of mass of the cohort. For the center of mass Im using CenterpointReplacer (based on their hull) + coordinate extractor. I dont find the way to transfer these X, Y coordinates to the sparce cloud. Tried the following path: 1_FeatureMerge, not working, parameters on the image. I guess it's related with the number/string format2_Set variable - retrieve variable . When retrieving, I dont find the variable :S Any idea? Thank you! J *featuremerge parameters>

3 years ago

pasi.kahonen

asked in Transformers

How to populate random points in an area with 3d objects?

Hi,I'm a complete noob with FME with just a few days of dabbling around with it.So far I've managed to filter out areas from a shape file and extrude those areas with a value from a variable and send it to Cesium Ion and display it in Unreal Engine. But now I'd like to know how I can add random points to those areas and populate those points with a 3d-object and use the generated tileset with Cesium Ion and Unreal. So far this https://community.safe.com/s/question/0D54Q000080hDPMSA2/adding-a-3d-model-and-georeferencing-it-with-multiple-xy-points, is the only thing I've found related to this. But haven't been able to get it to work. See attachments for my current pipeline, which does bring a single object to Cesium Ion, but no location data (Tileset location has not been set). How far off am I? Thanks in advance.

130

3 years ago

sigtillContributor

asked in Transformers

Schemamapper - attributerange

I want to map values from the following feature:Myfeature:- x = 100- y = 100- z = 150Based on the following rulesnewattribute = a if z > 0 and z < 50 newattribute = b if z > 50 and z < 100 newattribute = c if z > 100 and z < 120 newattribute = d if z > 120 and z < 175 So this feature will get the attribute:newattribute = dI can not seem to find an example with the schemamapper (or any other solution which is NOT Python-coding).The issue is that I have alot of changing interval-rules, in a database - so they can not be hardcoded in the workspace - but have to be read from a csv / Excel-file so the Schemamapper would be great if it could handle larger than and smaller than etc.

163

3 years ago

ritafan720

asked in Transformers

FME doesn't read csv file properly. Most of the attribute values appear as "Null"

I have few huge csv files (each has nearly 10 millions rows) that I wanted to process in FME. However, FME can't read them properly. For most of the rows, one of the column's values appear to be "Null". Hence I am not able to read the values and join the values with other files. I have tried FME 2020 and FME 2021 but none of them can read the csv properly. Has anyone ever encounter this issue?

1283

3 years ago

scherand

asked in Transformers

How to set text angle when writing annotation feature class to File Geodatabase?

I need to create an annotation feature class in a file geodatabase (FGDB) from input data holding attributes like label alignment and rotation.For some reason, the rotation angle of the text labels is not stored in the FGDB while the other attributes are.According to the documentation (https://docs.safe.com/fme/2020.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/Feature_Representation.htm, section "Annotation Attributes"), the attribute "geodb_text_angle" can be used to specify the angle for the label. It should be measured in degrees, so I assume values between 0 and 360 are sensible.However, while a non-zero value is present in the attribute "geodb_text_angle" just before the writer, the "Angle" is then 0 in the FGDB.I have a simple workspace that demonstrates the issue. It just creates one feature, sets some annotation related attributes and then writes an FGDB. The issue is persistent.I am using FME Workbench 2020.0.2.1 (Buil

604

3 years ago

arhayes

asked in Transformers

I have set of lines and a set of points. I need to find the point that is nearest to the start of each line segment and the point that is nearest to the end of each line segment. I want an attribute from those points to transfer to the line segment

383

3 years ago

frank_forster

asked in Transformers

Hello, I want to generate simple closed 3D shell/volume/surface from complex BIM/IFC/3D building.

My best result is converting my input building model into a point cloud using "PointCloudCombiner". Then converting the point cloud to a surface using "PointCloudSurfaceBuilder". I used the "Poisson" algorithm, which seems to produce the best result. I'd like to improve the result, as you can see in my picture, the final surface is still quite rounded at some areas. Have you any idea to improve the parameters as the "Poisson" algorithm is quite complicated. Thanks in advance, Frank

574

3 years ago

michelle_onasse

asked in Transformers

I would like to know how many points are within 10 meters of my lines

I got two different Readers : one is for my different routes (lines) and one is for my different addresses (points). I need to merge them and I want to know which points are within 10 meters of my different routes. Thanks.

3 years ago

aronContributor

asked in Transformers

Duplicate feature based on attribute?

I would like to duplicate features based on attribute. See following example.The result I would like to acchive would be a set of new features containing only A, only B and only C. E.g. this would require the geometry1 to be duplicated into one A and one B. To make things more complicated the attributes are dynamic, so matching sets need to be found before duplicating. Any ideas on how to achieve this?

123

3 years ago

larsec

asked in Transformers

Change detection on a WFS with restricted amount of features

Hi all,I'm trying to set up a change detection workspace, where I have a WFS that is my updated data and a ArcSDE, which is my original data. I have added a Feature Reader, which grabs my WFS and the three relevant layers and used that as my Revised part in the Change Detector Transformer. The Original part comes from my ArcSDE Reader. My problem is this: The WFS service usually has a maximum amount of features it will allow me to retrieve. I have different layers in the WFS which far exceed that maximum. Therefore my reader will only parse half of the features on to the Change Detector. How do I get past this? I tried adding a layer with polygons covering my area, and connecting it to my Feature Reader, setting the Spatial Filter to "Initiator intersects results". This should help the Feature reader, to only read the features within each polygon at a time, and then "ignore" the maximum amount restriction. But this doesn't seem to work, even though I'v

544

3 years ago

nic_

asked in Transformers

Has anybody had experience with updating a Slowly Changing Dimension SCD (Type 2) table with FME?

I would like to utilise FME to perform an update on a table a Slowly Changing Dimension (Type 2) . Where historical records are preserved, and you have Start, End dates and a Current flag for each record.While the Change Detector transformer helps, it will still require some tricky manipulation.I did find this article but can't see the detail...It would be great if there was a ETL Transformer that could do this.Any help would be appreciated.

290

3 years ago

agelfert

asked in Transformers

Datetime formatting for SQL to SQL Translation - DatetimeParse or DateTimeConverter ?

There is nothing in the FME universe that has me pulling my hairs out as much over and over again as DateTime formatting and conversion. I realize I might be be at one extreme end of the FME user spectrum in that In connect to a very small subset of data source/target types. 90% of my work is reading and writing to/from spatial and non-spatial SQL databases. Which means I don't have much use for the full range of date/time manipulation available in FME. But that makes it even more annoying when I read datetime() from SQL and write datetime() to SQL and suddenly find myself puzzling why any formatting or transformation is necessary!? Then, there are just as many occasions when this does not happen and I immediately forget the steps I took to get things to work. As a recent example, I'm reading a number of date fields using:FeatureReader, Type: Microsoft SQL Server Non-SpatialThen I write some of this data back to SQL using:SQL Executor: Microsoft SQL Server Non-Spatial Now why this woul

2556

3 years ago

ruth_hContributor

asked in Transformers

I would like to select the most recently added attribute which has a duplicate ID on another line.

I have records with the same identifier but I would like to select the most recent activity on the record. So for example - 2 records with an ID of "2465100000" but against that ID are 2 different cross references added on different dates. I want to select the most recent one (or the oldest). Please can anyone advise as to the best way to do this so I have only one line remaining based on date. Many thanks

3 years ago

michelle_onasse

asked in Transformers

I would like to change the format of my attribute (Lengths into this type of format 000+000).

For example, if I have a length of 12356 meters, I would like to have 012+345.Thank you.

3 years ago

ksm65

asked in Transformers

Hi, How can I copy the style (Presentation: color, symbol, size, zoom levels) of another shapefile file to my current project. thanks. I'm using Workbench 2020.2

252

3 years ago

chauContributor

asked in Transformers

Is it possible to use WMS to retrieve SVG data in FME Desktop?

I am trying to configure a FeatureReader to use WMS to request a map in the SVG format (image/svg+xml). I have two options with respect to the output format (jpeg and png) but using the "Open text editor..." functionality I can input the image/svg+xml my self. It fails when I run the workspace and according to the translation log the FeatureReader probably doesn't recognise the format and defaults back to PNG. Even though I have thought of WMS as always returning a raster image, https://en.wikipedia.org/wiki/Web_Map_Service describes it as also being able to return SVG and WebCGM. I haven't browsed through the WMS specification though. I have found this idea https://community.safe.com/s/idea/0874Q000000TlLiQAK/detail which ask for the option to read a plain SVG file so I guess reading SVG is outside the scope of FME so far (even though writing SVG should be available)?

264

3 years ago

tcrossmanContributor

asked in Transformers

Can AutoCAD access user attributes defined in the CAD Writer and written out on *non*-block features, and, if not, of what use is the FME functionality that allows this?

This question is in follow-up to this earlier post, which is, so far, unanswered ... After consulting with some CAD colleagues, I am starting to think that user attributes added to plain features (in my case points), not blocks, by the CAD Writer are invalid for AutoCAD. In fact, a Google search turned up no mention of user attributes outside of blocks ... and opening the output CAD file in FME shows no sign of the User Attributes defined in the Writer. Sigh.

3 years ago

lhuerta

asked in Transformers

Calling a file with FTP caller whose name is partly random

Hello,I am using FTP Caller to call a file with a name like this: A-IPE_810704320_NATH_PM_IPEZMD_V31_@Value(_timestamp)_27.csvMy problem is that the last two digits (here 27) are random...So I tried to replace the last two characters, like this: A-IPE_810704320_NATH_PM_IPEZMD_V31_@Value(_timestamp)_??.csv A-IPE_810704320_NATH_PM_IPEZMD_V31_@Value(_timestamp)_*But it doesn't work and it returns an error.I know I can list all the FTP files in an attribute and then search for the right file with "String Seracher" but I thought it might be easier!PS: The @Value(_timestamp) part works correctly and returns the date in the format used in the file naming. Thanks in advance

3 years ago

tcrossmanContributor

asked in Transformers

How to extract insertion points from point location blocks and write them back out to CAD as points, not blocks.

I am reading CAD point blocks with Explode Blocks unchecked. FME represents these features as points (fme_point), as expected; however, if I then try to write these points back out to a new CAD file, the writer rejects all of them, saying that the blocks are not defined in the CAD file. I don't want blocks written out. I want simple points written out. Now, if I explode blocks on read, only one of the four blocks/feature types in the CAD file produces the insertion points as points. The other three produce all the lines, arcs, etc. but no points. So, how do I go about getting the points for all the blocks and then writing them out to CAD as plain points, i.e. no blocks.

1222

3 years ago

Page 161 / 508

Badge winners

davtorghhas earned the badge Welcome Back
haonhas earned the badge English Speaker
haonhas earned the badge German Speaker
haonhas earned the badge Spanish Speaker
haonhas earned the badge French Speaker

Show all badges

30,177: Posts

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.