- - Community Resources
Ideas
Product Updates
Events
Groups
Support
Knowledge

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

10,000 Posts
52,716 Replies

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

10000 Posts

asked in Transformers

bug in group mode ?

Hi folks,I don't know if it's a "new" bug. when I configure a reader DWG in grouped mode (single merge feature type) but not directly when creating the reader, but afterwhile, in the parameters of one of the faeatures :The number of entities increases anormally ... and do never represent the real number of entities presents in the layer.For exemple, I have 3000 entities (block) in a layer.If I check the box "merge feature type" it increases to 20000 without reason.I am surprised because I used this function a lot of times, without any problem.Does anyone know if there is a problem known about it ?Or maybe I do the bad manipulationRegards

3111

5 years ago

gcarmichParticipant

asked in Transformers

how do I process one-by-one and store just text results for table

In my workflow, I want to evaluate the intersection of a circle with a set of lines, extract the vertices, do some calculations, then store just the text results in a table. The set of lines remain the same but a new circle is created for each intersection analysis using a different circle center. There are 200,000+ circles whose intersections with the set of lines that need to be evaluated.The workflow I created works for a single circle (using the Sampler to extract the circle) but when I want to evaluate multiple circles, the all start to overlap which doesn't provide the desired results.How can I run the intersection of the circle with the line set one at a time and write out just the text results for each circle? I tried GroupBy in the Sampler2 but didn't get the desired results. I'll try to have the image and workflow posted with the question.

5 years ago

mferwerda1111Participant

asked in Transformers

Create point from PLSS location

This seems like something someone would have done already, but has anyone created a workflow to generate a point from a PLSS (Public Lands Survey System) description, such astownship 45N Range 43W section 20, NE, SW, NW, SE ? Any thoughts how to go about that ? not all are down to the QQQQ, some are only QQ, etc

110

5 years ago

jbradforContributor

asked in Transformers

AmazonAthenaConnector

Does the connector support parquet? Getting a forbidden error. Any suggestions on privs of the account required.HIVE_CANNOT_OPEN_SPLIT - com.amazonaws.services.s3.model.AmazonS3Exception: Forbidden (Service: Amazon S3; Status Code: 403; Error Code: 403 Forbidden;

509

5 years ago

k_landerContributor

asked in Transformers

Custom Transformation Issue: CSRS 1997 to CSRS 2010

Hi all, I'm attempting to set up a custom XFORM_DEF to move between CSRS (1997) and CSRS (2010) using the grid shift file CVG69710.gsb provided by NRCAN, and I'm having trouble getting it to show up in FME Options > Coordinate Systems. I was wondering if anyone might have experience setting up this transformation or if anyone could otherwise spot what might be going wrong. I've placed the grid shift file in Reproject\\GridData\\Canada and placed this definition in the bottom of the MyCoordSysDefs.fme file. I also did a test by uncommenting the ASTRLA66-Grid_to_GDA94 XFORM_DEF in the same file and it shows up in Workbench without issue.Here is my custom definition:I was thinking that perhaps I need another datum to represent either CSRS (1997) or CSRS (2010), but I'm not really sure. There seems to be some ambiguity surrounding the representation of different CSRS realizations within the EPSG code system and I am unsure which is being represented by the CSRS datum I&#

280

5 years ago

alfonsContributor

asked in Transformers

Extract roofs from multipatch feature

Good afternoon, I have a Multipatch Building Data Set (LOD2) (*.GDB). Consisting of wall and roof areas. Since only the roof areas are interesting for my further work, I would like to extract them into a 3D polygon. Unfortunately, there is no attribute that tells me that the polygon is a roof surface or a wall surface. Is there a transformer which separates the corresponding roof area? If this is not possible, my idea would be to calculate the inclination for each polygon and define all polygons with an inclination of ~90° as a wall. For this I would consider the transformer "SlopeCalculator". Is there perhaps a more efficient way to reduce the calculation of the inclination of several million polygons?Thanks a lot.

900

5 years ago

yomiContributor

asked in Transformers

Writing ffs to pdf

Hello FME family,I am new in using FME and I really want to learn more about the software.I have FFS table that I want to write in PDF. Also in the PDF output, I want to show the number of time a feature (string) occur in one of the attribute columns. I will appreciate a tip on how to go about it because I have tried all I know but not working.Thank you.

230

5 years ago

gianpiero

asked in Transformers

Georeference Revit file and read in FME

Hii,I have a .rvt file that I have georeferenced in Revit (epsj 23032 - UTMED50 32N). Now, my target is to visualize that file in FME. I'll show you how I tried to do it:In the first figure I show you about the Revit survey point, and for me it's ok. Because the coordinates values are coerent with the coordinate system of the project.In the second figure I show you about FME reader setting that I have used.When I use the reader to import the file in FME Desktop 2020 the model don't match with the correct location :-(Someone can help me!!!RegardsGianpiero

530

5 years ago

gogopotter90Contributor

asked in Transformers

how could i convert the function of pointonlineOverlayer and neighbor finder transformer to work with both of coordinates,minimum and max. coordinate instead of only minimum coordinate

i have lines and points ,both of them as input .i want to find which lines intersectes with points and which notand show me the id of each station that line intersected so i tried by point on line layer and neighbor finderand it find correct data of overlapped point but i have still problem,when one line intersected with two points ,the output that i got only id of this line and and overlap 2 and name one of the two station .it did not show me the 2 stations that line intersectedso i noticedthat it checked only by xmin and ymin of the line which point intersected . this is the station that it has chosen and another point at end of the line ,it did not show me bcs it is xmax and ymaxbut the line intersected with 2 point as the output said 2 overlap,so how could i solve this problem .and i get id of each 2 pointand i tried also neighbor finder but both of them works with xmin ymin close candidatehow could i let both of them work with xmin ymin and also x max y maxbcs it means also if i

110

5 years ago

robertdbuckley

asked in Transformers

jsonfragmenter: How to flatten attributes which are deeper in the data structure?

I am using the jsonfragmenter to expose the attributes "name", "street", "city", "zip" in the following json.I want to also expose the geographicpoint attribute and append the "latitude","longitude" as a field on the same level as the other attributes so that I can obtain the following data structure."name", "street", "city", "zip", "latitude", "Longitude" How can I delve into the "geographicalPoint" attribute and flatten ist further in my schema? JSON{"name":"Medicus-Apotheke","street":"Walsroder Str. 8","city":"Soltau","zip":"29614","email":"medicusapotheke@googlemail.com","geographicalPoint":{"latitude":"52.9836451","longitude":"9.8358444"},"contactName":" Andreas Hagedorn","services":[{"service_id":34,"service_name":"Krankenpflege","service_icon":"ico_krankenpflege.png","service_url":"","service_descript":"Krankenpflege","service_longdescript":"Krankenpflege","service_type":0},{"service_id":35,"service_name":"Verleih","service_icon":"ico_verleih.png","service_url":"","service_de

160

5 years ago

terezia86

asked in Transformers

Area on area Overlayer

Hello, I have got 2 sets of Polygones. 1 consist of big areas (431) and the second one has the smaller Polygones. Theese smaller polygones includes infos/attributes which I need to write into that larger polygones. The problem is that I get from AOAL too much Polygones, but not this result what I want...I want to get the infos from (many) Polygones in the larger (less) Polygones. Maybe to use a different transformer?Any Idea?Thanks

190

5 years ago

scobierob

asked in Transformers

Using FME to Populate/Explode Missing Date Records With Values From Last Updated Record

I am trying figure out how to populate missing date records in a COVID database using the last known value.Here is an example of input data:CountryLast UpdateNumber of CasesMexico3/1/20205Mexico3/3/20205Mexico3/6/20206Mexico3/8/20207Mexico3/9/20207 I would like to generate a record for each day. CountryLast UpdateNumber of CasesMexico3/1/20205Mexico3/2/20205Mexico3/3/20205Mexico3/4/20205Mexico3/5/20205Mexico3/6/20206Mexico3/7/20206Mexico3/8/20207Mexico3/9/20207 Any ideas on where I would start with this one?

590

5 years ago

stefanhContributor

asked in Transformers

The Things Network integration - airquality sensor data

There are some air-quality sensor in the area I work. These are connected with the LORA-network and The Things Network (TTN). Data can be accessed by the MQTT-protocol. However I have no experience with this. I found the MQTTReceiver (which uses an old Python version) and MQTTConnector. I tried both Transformers with the settings I received; like this:Unfortunately it is not working. The error I get Anyone experience with this? Thanks!Stefan

286

5 years ago

bwnEvangelist

asked in Transformers

Is there any difference in calculated values between AttributeCreator and ExpressionEvaluator?

As per the topic: Any difference in the values calculated by either Transformer when using @Evaluate in AttributeCreator vs ExpressionEvaluator?

110

5 years ago

lodewykjansen

asked in Transformers

Convert several dxf files to seperate Shapefiles (contained within a ESRI Geodatabase) with specific name of dxf file

Hi New to FME so please be gentle... I think the question lines out what i want to do but for clarity, I have several dxf files in a folder on my c-drive. These dxf files are a combination of point, lines and polygons with a known projection. I want to convert all these dxf files to an ESRI geodatabase (or separate shapefiles -whichever is easiest) with the name of the dxf file naming the "shapefile".Additional - if possible I would also like to reproject the shapefiles to another projection - but not that important now.

2300

5 years ago

sprongandre

asked in Transformers

How to add csv-attribute values to autocad block attribute value

I have a *.csv-file with values, I would like to put them in a Autocad block attributes:The issue is that the 'pino'-values which I filled in by hand will come over. The values from the csv won't (value from Sheet Name 2).I can't get it, who can help me please? :-) Thanks! acad_excel2acad_Safe.fmw0002_Sheet Name.csv

1130

5 years ago

alfonsContributor

asked in Transformers

Counting the 3D Points within a sphere?

Hello, I am looking for the possibility to count all points (3D) within a 3D body/sphere. Using the 3D buffer (it was faster than HUB3DBuffer, but less accurate) I have generated a solid body and now I want to check how many 3D points are inside this body. With the Spatial Relator apparently only points in a 2D space are checked. Is there a transformer in FME that does this job? Thanks a lot.

880

5 years ago

bjudesEnthusiast

asked in Transformers

Exposing Schema Mapper Attributes

Hi, I have used SchemaMapper to create two new attributes that have successfully mapped to my output shapefile. I can see them in the inspector in the Feature Information window. However, I want to map these values into my attribute table. When I try to expose these attributes using AttributeExposer they are not there. I have searched through many posts on these forums and can't seem to find an exact answer. Could someone help me with this?ThanksB

650

5 years ago

maloks

asked in Transformers

From one geotiff image get N smaller jpg images

Hello everybody,I got one GeoTIFF image and I want to get N ( for example 3000 roofs ) smaller jpg images of point of interest in which every roof is one picture. I started making polygons in the place where are points of interest but I don't know how to "clip" it.

110

5 years ago

gylona

asked in Transformers

Create lines from neighbor points

Hello! I would like to build lines between neighbour points. Unfortunatelly the points cannot be gouped by the neigborfinder, as sometimes an other point is closer. But the points are in numeric order as they have an ID. Can I do something with it?

560

5 years ago

syarlagaddaContributor

asked in Transformers

I have table of records(in feature class) i need to write the count of records in other table(oracle non spatial table)

I am interested in zoom meeting if that is possible

520

5 years ago

thomastupuivaoContributor

asked in Transformers

WKB to SDO_Geometry not working correctly with "Multipolygons"

I have a "mapinfo" table that I'm trying to load into a oracle DB with SDO_Geometry. My license doesn't let me create a writer in FME as an Oracle Spatial table. So my workaround is to add the tables as "oracle non-spatial" tables. This works fine for address points but when I run the following SQL;This updates successfully. The issues is when I check in "Data Inspector" if its saved correctly (for this particular record which is a multipolygon). I get only one of the polygon objects returning;

880

5 years ago

delgadojeanethContributor

asked in Transformers

Create lines between points

Hi guys, I am trying to create " cross lines" between 2 points. I just got the lines in black that u can see in the capture. But I wan to get the red lines. Can u help out please?

2760

5 years ago

sprongandre

asked in Transformers

How can I insert a block with (autocad) attributes and fill in the values?

Hi,I have a block which contains (Autocad)attributes, in Autocad you can edit them by double clicking on it.I would like to insert this block in a dwg and fill in some values. When I put this block in a template and insert it with the dwgstyler than it becomes a default block, whithout the 'doubleclick' functionality.How can I insert a block with (Autocad)attributes and fill in the values? Thanks!

1140

5 years ago

andreasb

asked in Transformers

Creating 3d Polyline offsets from a rail

Hello everybody, I hope everybody is doing well! But for the question, I'm currently looking at creating 3d polylines from a rail. I have used the offsetcurvegenerator for getting an offset and then use the neigbourhoodfinder to rebuild my polyline. Now the problem is I need to get the the exact same vertices on the offset polyline as these from the original, as these are the points where the rail was measured. And I don't get this with the offsetcurvegenerator. I have seen the use of the buffer transformator but also this isn't giving me the correct results. Can somebody guide me into solving this problem. Many thanks and keep safe,Andreas

740

5 years ago

Page 232 / 527

Badge Winners

aqueehas earned the badge Webinar Watcher (Grey)
sredarhas earned the badge Teacher (Grey)
leonietreblehas earned the badge Welcome Back
skill_72has earned the badge FME Form Basic Training
ibrucehas earned the badge Student (Grey)

Show all badges

Community Stats

31,815: Posts
120,836: Replies
39,445: 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.