- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,683 Posts
50,748 Replies

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

12683 Posts

Recently active

Most replies Most views Newest first

samaye

asked in Transformers

How to segment a line from a particular point and continue segmentation as the line branches.

Hello, I'm working with Ordnance Survey data, in particular their OS MasterMap Highways Network RoadLink and RoadNode datasets. This is a topologically correct link and node dataset. I'm looking for a way to segment the RoadLink polyline dataset at 25m intervals up to 100m starting from RoadNode points marked as roundabouts, as shown in the example image below.My intention is to merge all lines with the same road name and road number using the LineCombiner transformer and then use the Chopper transformer to segment the lines at the required intervals. However for this to work, I need to be able to orientate the direction of digitisation of the lines away from the roundabouts nodes, as the chopper will do it's chopping in the same direction as digitisation. I can then chop them starting from the roundabout point and up the line away from this point. My main question is, is there a way to use a point that lies on the end of a line and identify if the line is digitised toward

193

3 years ago

spidermanContributor

asked in Transformers

how to change coordinate min extent and max extent to new coordinates ?

how to change coordinate min extent and max extent to new coordinates ?i would like to move polygon from his coordinate to new coordinates .i have used attribute creator to change x min and x max and y min and y max ,but i found it changes the coordinate as attribute but i want to move the polygon from his main coordinate to new coordinates.could someone help me ,how i do that ? FME 2018

301

3 years ago

ahgnoy

asked in Transformers

Workbench and Data Inspector recognizes features differently

Hi FME,I am working on a Microstation V8 DGN file with DGNV8 reader. Some of the polygons are recognized differently in Workbench and Data Inspector as attached in the images. Is this a known issue? For example, the green polygon in the Workbench (see the attached image) is losing some of the boundary edges when compared to the same polygon drawn in the Data Inspector that is showing the correct shape. I changed Workspace Parameters > Advanced > Preserve curves "Yes -> No" and then "No -> Yes". But neither was successful. Since the feature shape is wrong at the reader level, adding transformers after the reader won't fix the issue. Do you have any ideas on this? My FME Desktop Version is FME(R) 2020.2.3.0 (20210129 - Build 20820 - linux-x64) and running on Ubuntu 20.04 LTS.

114

3 years ago

avdb

asked in Transformers

FeatureJoiner - 1 attribute fails to join

I am hoping someone may have suggestion as to why a FeatureJoiner fails to join on 1 attribute only.Left input: table of records, including CouncilRegion attributeRight input: polygon feature class with Region's NameThe transformer successfully joins all records from the left input table, to the feature class..., apart from the table records in "Hawke's Bay"The join is successful for all other records. I have trimmed any potential white space at the end of the attributes.Anyone can think of where the problem may lie, what test I could do to ensure Hawke's Bay records do join?Many thanks

742

3 years ago

janet

asked in Transformers

Workspace that used to run in 2019.0 but not in 2019.1: "Error running translation"

I've come to adopt a project file that seems to fail intermittently on the same input DWG file. This workspace was developed over time and it's now in an FME Server 2019.1 environment (2019.1.3.1, Build 19643 - win64) where we thought it would be a risk-free minor version upgrade, but some files now fail against it. My Workbench is also the same version in troubleshooting this. I'm at a loss now for where to look to try to resolve this. This is what I've tried:Upgrade all transformers to the latest version, including the ones in embedded transformersReplaced deprecated embedded transformers, such as ClosedCurveFilter (LoopFilter) and HorizontalAngleCalculator (AzimuthCalculator).Changed Connection Runtime OrderDisabled transformers to locate the troublesome ones. They're typically on the embedded transformers, NeighborFinders, FeatureMergers, and LineOnLineOverlayers, but I'm expecting that there's no significanct change to them to make this stop working. From my desktop, a change I ma

243

3 years ago

tdunlevie

asked in Transformers

Creating a 'report' from data from a SQL db which shows a count of data collected on a weekly basis. The week starts on a Wednesday.

I have a sql table with a date field.it shows Lab Code (MINA / Intertek), sample ID, Lab_report_dateI want to show this data as a table or export such as: The week is not calculated as a standard 'week', but from Wed - tuesday.I've been playing around with DateTimeCalculator & Attribute Pivoter without much luck.Is this even possible? thanks

3 years ago

bwc

asked in Transformers

How to relate to attribute filters?

PL.shp with attribute 1 Excel with Attibute 1 and Attribute 2Attribute 1s relateI have AttributeFilter set for Attribute 1 to extract Attirbute 1 from PL.shp I need to relate Attribute 1 to Attribute 2, which was not in PL.shp, but is in a related Excel Once the relate is attained from 1 and 2, I need to create a shp that retains the name of Attribute 2 which is then written into a folder with Attribute 2 name. This will have to be done 200 times, so how can I efficiently get from reader to writing 200 shps that need to be in attribute 2 named folders? Then from there, the shp needs to be created into an excel that is placed in attribute 2 named folder.

3 years ago

david_prosack88

asked in Transformers

Hello, I am having difficulty getting the SHAPE field in Oracle to populate correctly. Features are 3D in FME, but the features SHAPE in Oracle are displaying as 2D not 3D after FME translation. How can I resolve this?

151

3 years ago

joe.cusdin

asked in Transformers

Vectors not being read by AffineWarper in FME Server

I am using an AffineWarper to translate some co-ordinates based on a series of control points. My control points are stored in a CSV file containing the following columns: Start_X, Start_Y, End_X, End_Y These are a series of control points representing start and end locations for the transformation. These are turned into vectors which are the vectors for the AffineWarper to perform it's transformation (see screenshot). This works fine on desktop FME, but when I upload the workspace to FME Server and upload the same CSV file, I do not get any features written. I get a warning in the logs saying the AffineWarper requires a minimum of 4 points, when the file does have at least 4 lines. I have written the outputs of the PointAdder and I can see the 4 vector lines being correctly created. However, it doesn't seem to be getting passed into the AffineWarper?

176

3 years ago

istvanvParticipant

asked in Transformers

How to pass a las file to the R Caller

I have a pointcloud.las and I would like to apply some R functions on it using the lidR package. I'm having some hard time figuring out on how the pointcloud should be formatted, or passed on to the data.frame within the R Caller?Same goes for grabbing the output.Any clues are much appreciated

475

3 years ago

mhabContributor

asked in Transformers

Esri Geodatabase (ArcSDE Geodb) Reader with Archive Where Clause (GDB_FROM_DATE/GDB_TO_DATE): Handling of fme_db_operation Where-Clause for attributes of type date/timestamp

I am reading from an Esri SDE GeoDB (ArcObjects) and use Archive Where Clause with GDB_FROM_DATE/GDB_TO_DATE to read archived data.... after processing the data, I write it to another SDE with mostly the same schema. This is my first migration step. After a while I want to do the same workflow for the data which were changed since the first migration. So I use GDB_FROM_DATE/GDB_TO_DATE in order to find the changed data in the source SDE. At the end of the second processing I need to update some of the features of the first migration (those which have been removed since the first round) and I try to use fme_db_operation UPDATE and a fme_db_operation_where clause attribute, where I try something like this:fme_db_operation_where=UUID='DEBE0707Hb000020' AND BEG='20170619110522' AND ENDE IS NULL BEG is a column of type timestamp (in the underlying Oracle DB) and needs to be compared to the value read from GDB_FROM_DATE which is of type date I get errors like the following an

728

3 years ago

preiserContributor

asked in Transformers

I have a collection of Roads (lines) and would like to find the nearest other road(line) to the starting point..

I have used snipper to get the starting points of the lines, then I used NeighbourFinder to find the nearest line to the starting point, but i want to exclude lines with same id as my point.. It is possible with Postgis, but know that I got a license I prefer FME if possible.

132

3 years ago

hallkbrdz

asked in Transformers

Merge tables with no join value

I am trying to merge two tables with no common key. How can I do this? 1 is from a select returning the database name (dbname) and server name (srvname). For example:BlueSpark, WINSQLPRD001 2 is from a function and returns database role information. Example:sa, sysadminNTSERVICE\\SQLWriter, sysadminNTSERVICE\\Winmgmt, sysadminNTSERVICE\\MSSQL$INST1, sysadmin I want to take the two items from 1 and add them to each row from 2 such as:BlueSpark, WINSQLPRD001, sa, sysadminBlueSpark, WINSQLPRD001, NTSERVICE\\SQLWriter, sysadminBlueSpark, WINSQLPRD001, NTSERVICE\\Winmgmt, sysadminBlueSpark, WINSQLPRD001, NTSERVICE\\MSSQL$INST1, sysadmin I've tried using various transformers and all require a common key. So I tried converting the results of 1 into attributes and using that to populate the columns of the output, but it creates separate rows with the results of 1 and 2 - they are not merged such as:BlueSpark, WINSQLPRD001,,,,,sa, sysadmin,,NTSERVICE\\SQLWriter, sysadmin,,NTSERVICE\\Winmgmt

1831

3 years ago

pasi.kahonen

asked in Transformers

Objs to Cesium Ion via Cesium Ion Connector don't have geolocation

Hi,See attachments for my pipeline. In the pipeline I have a simple 3dmodel and a some amount of random generated points in a certain area where to populate that model to. The pipeline seems to work all the way to the end. If I inspect it in FME, everything is in correct place on the map, but once I send the obj to Cesium Ion, it no longer has the geolocation data, and it wants me to place it by hand in the Cesium Ion Portal. Any idea what might be wrong? If I open the obj that I just generated again in the FME Desktop, it shows the models on map correctly. https://cesium.com/docs/tutorials/import-3d-models/

3 years ago

lojs

asked in Transformers

NeighborFinder and excluding candidates after matched

Hello! I am using NeighborFinder to match points from two different datasets. Once a point has been matched I would like to exclude it from the candidates. How would I do this?

949

3 years ago

samt

asked in Transformers

Example usage of PythonCaller FMEFactoryPipeline

Hoping someone could provide me with a comlplete example of how to use fmeobjects.FMEFactoryPipeline() in a PythonCaller Specifically I would like to take points as in input and use the SurfaceModelFactory with the undocumented parameter MAXIMUM_EDGE_CALC_LENGTH to hopefully produce a mesh with trimmed edges.

321

3 years ago

rickes6g

asked in Transformers

StatisticCalculator multiple Attributes

Hi everyone,we have installed the 2021 Version already but now we don't know how to select multiple attributes in StatisticCalculator. In earlier versions i.e. 2019 it has been possible to select multiple attributes by clicking on the 3 points, unfortunately I can't find this option in 2021 Version. Do I have to select all my 100 attributes if I need a statistic about them? 😖 Is there any possibility? Kind regards,Sandra

3 years ago

mahbouberezaiee

asked in Transformers

Poincloud to a plane or polygon

Hi. Is there any way to create a plane or polygon of a set of pint cloud? I want to create roof surfaces from point clouds, but I have found no transformer.Thanks

3 years ago

ewanrobertmclau

asked in Transformers

Blocked Looping stuck in a continuous loop

I have a custom transformer to fit rectangles into a polygon. The inputs are the polygon, and the rectangles. They go into a spatial filter which checks for "contains within", failed features are rotated and looped back to the candidate rectangles port to see if they will pass the "contains" filter again. I set the "maximum number of iterations" parameter under advanced to equal 4. The issue is that the transformer will just spin the failed rectangles infinitely instead of just 4 times.

121

3 years ago

mcgregrrContributor

asked in Transformers

Finding distances between buildings using neighborfinder?

I have a 2D polygon shapefile representing buildings. I want to determine the distance to and from each building. I have tested the neighborfinder and think that may be strategy however I tested one building as the candidate and all other buildings as the base. However I do not want to create separate building polygons to use and rerun the transformer a couple hundred times. Is there a way to use the full building set as both the candidate and base?

3 years ago

lenanielsenmail

asked in Transformers

While/looper

HiI have a SQL table where I have cust no. = 1, Created date = 2020-02-01 and Last date = 2020-06-30.cust no. = 2, Created date = 2020-01-01 and Last date = 2020-07-30. I need to insert each month between Created date and Last date into a SQL table for each cust no. Any ideas how do I do that? I tried Looper and Endless looper but I can't make it work and can't find any documentation

3 years ago

tim_woodContributor

asked in Transformers

Use list of files in Excel to copy into a ZIP file

We have a set of DWG files covering our geographical area. Sometimes we need to supply contractors with a subset of these files. The files are named by their map reference. We can generated a list of the required files using our GIS. So we have an Excel file with a list of these tiles in, which are also the file names of the DWGs. I have built a Workspace in FME 2020.1 to read the Excel file, construct the path and filename, and pass it to the FileCopy Writer. This successfully copies the files to a folder, but when I try to get it to ZIP the files, I only get some of them, and this message appears in the log: 2021-05-17 17:22:04| 13.4| 11.2|WARN |MULTI_WRITER: Skipped adding of some files to zip file 'X:\\SomeFolder\\selected_DWG_files.zip' because they already exist I don't understand the error because all the DWG file names are unique. I assume it's referring to the ZIP file, but I don't understand why I get varying numbers of DWG files in the ZIP each time and w

781

3 years ago

avinashdalvi_

asked in Transformers

How centroid is getting linked to one Parcel if centroid is lying on boundary of adjacent parcel

In my case there Parcel is who is supplier and building centroid is requestor in SpatialRelator of FME Script. You can see black round in one below picture. So even if centroid is falling on adjacent parcel boundary it got link of one parcel. How come ? why it's not gone for one to many matches ?

615

3 years ago

junn.d

asked in Transformers

Enter bulk test conditions into TestFilter

Hi Everyone, Can you please assist if there is a way to enter bulk Test Filter Clauses into the TestFilter Transformer? I have almost 100 test clauses that need to select points along a road by start and end in a spreadsheet. See belowThe TestFilter will filter out by these section to create a speed zone. Was wonder if there was an easier way to enter the test clauses instead of having to enter in 100 times? Thank you so much for your help in advance

723

3 years ago

joe.fmeContributor

asked in Transformers

Formatting number (8,2) for SQL Server

Hi all, I'm trying to write a fixed-length number to a SQL Server Non Spatial database, and most work fine, but this one doesn't - Microsoft SQL Server Non-Spatial Writer: Unable to format data '4411398' for column 'ciFloorArea' of type 'numeric(8,2)' The other numbers look like so, and must be the exact 8 and 2 parameters - 1305256844113988248072 I just wondered if there was anything I was missing with the one that's throwing the error up? Thanks

1342

3 years ago

Page 159 / 508

Badge winners

cynthia_devoshas earned the badge Welcome Back
havermhas earned the badge Teacher (Grey)
havermhas earned the badge Welcome Back
mcmavehas earned the badge Welcome Back
tunzhas earned the badge Student (Grey)

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.