Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 12,751 Posts
  • 51,002 Replies
12751 Posts
rob_z
rob_z
asked in Transformers
SliverRemover and arcs

Hi, when I apply the sliver remover after an areaonarea-overlay I noticed that arcs get dissolved. I would like to remove slivers but keep arcs as arcs. Repair method is set to "longest boundary". It seems even arcs get dissolved (turned into line segments) for areas/arcs where there is no sliver.FME 2017.1 Is that behaviour as designed? Did not find anything about in documentation. Thank you, Rob

410
rob_z
6 years ago
L
li_fme
asked in Transformers
Smallworld to Json

I created a workbench translating data from Smallworld to json. It was just a plain Smallworld reader and then a connector that connects to write to a json writer. After the translation is done, the FME Data Inspector tells me there is no geometry in my json file. Do I need some sort of transformer in between to create the geometry in json? Thanks!

60
erik_jan
Contributor
6 years ago
oliver.morris
Contributor
oliver.morrisContributor
asked in Transformers
FME Cloud API return Zip file

Hi,I have some JSON GET requests working AWS API Gateway and an FME backend thanks to @GerhardAtSafe and @stewartharper for the youtube videos and github repo. The next step is to offer up zip files. The workbench streams a small zip file and I am now trying to get this working through the AWS API Gateway. I have added application/zip for the content type and got the gateway to support application/zip binary. When I try to make the call though I only get an empty zip file - although the FME job does run successfully and a file is created. I suspect it is because the body mapping is incorrect. There is some information for images here:https://aws.amazon.com/blogs/compute/binary-support-for-api-integrations-with-amazon-api-gateway/Does anyone know what I should put in the body mapping template for the integration response?Many Thanks,Oliver

244
stewartatsafe
Safer
6 years ago
D
david_prosack88
asked in Transformers
Feature Compare Validation

Good afternoon all!I am having a problem with developing a QA/QC process for some CAD data. The ultimate objective is to compare the layers within the CAD files against base layer names located in a spreadsheet (i.e Elevation Contours, Houses, Lights, etc). I think the best way to do this is using Python. I have tried transformers but they only look at the data that is being run. I'm new to FME Python and I'm kinda lost so far. Any assistance would be great!Thanks! David

110
danilo_fme
Evangelist
6 years ago
A
aliciadmallette
asked in Transformers
Number polygons in sequence

I have a road allowance that I have divided into multiple sections. I need to number these polygons from one end of the road, to the other, in sequence. When I use the counter and group by road_id, it seems to move from top to bottom in numbering, so if a road curves or is circular, the polygons get numbered out of sequence through the curved area. Is there a way to keep these polygons numbered in sequence even through a highway ramp or a curved street? Any suggestions as to how I can assign numbers to these polygons and keep them in order from start of road to end of road?

80
gio
Contributor
6 years ago
annette2
Contributor
annette2Contributor
asked in Transformers
Send email - topic exists but there is no subscription

Hi,I have a 2015 FME Server that I am preparing to upgrade to 2017.We found out last week that 3 of the 50 legacy jobs do send emails and are in daily use by our DMS team.The email part of the workspaces consists of a FMEServerEmailGenerator transformer and FMEServerNotifier transformer that connects to the topic Email.However there are no Subscriptions configured on the 2015 FME Server.So I'm wondering how is it working so I can port the configuration to FME Sever 2017 and test these important jobs? Every article I read about configuring sending Email refers to a Subscription.I have made a sample workspace and send an email by using the 2 transformers above connecting to the topic, so it is working.I've checked \\Utilities\\smtprelay\\james\\apps\\james\\SAR-INF\\config.xml on the 2015 server but don't see anything specific. I know the SMTP relay service is part of the FME Core in 2017. Any tips would be appreciated.Thanks,Annette

60
david_r
Evangelist
6 years ago
E
edhere
asked in Transformers
Update phone numbers based on Excel file (RegEx, AttributeManager or FeatureMerger?)

Hi all,  I have to bulk update a whole bunch of phone numbers. The current format is ten digits, starting with a 0. I need to convert these numbers to area code + local number.The area code is either three or four digits followed by a dash (-).  The area codes are stored in enclosed file "PhoneUpdating" The input and output phone numbers are in "PhoneOutput"  What I'd like FME to do:When the first three or four digits in the "Phone" column match with the thee or four digits found in AreaCode: then replace these with the data found in AreaCodeUpdated. (output examples in green)  Example files:Thanks again, Ed

103
takashi
Contributor
6 years ago
F
flugan87
asked in Transformers
CAD polyline to polygon. Some polylines don't create areas even though they should.

I have the problem that some areas don't become polygon. Don't know why. I tried using snapper and line closer but that did not work. The polylines need to remain as they are in the dwg file. I have sent you a zip file with workbench and dwg file.This is the result I get. Almost correct. You can see in this picture that some lines are missing. Anyone have any ideas how to solve this?

70
F
6 years ago
R
raybouldrob
asked in Transformers
What is the best way to subtract attributes and test the result?

Hello,I'm new to FME and trying to find my way around and could use a little help. I'm trying to subtract one attribute from another and test that it is above one value and below another. My thought was to use the arithmetic editor in the Tester translator, however, the items that pass are not correct. Below is a screenshot of what I'm trying to do but the results appear to be the opposite and have a result value greater than 1000. What am I doing wrong?Thanks!

2240
R
6 years ago
J
jberneathy
asked in Transformers
Querying NED Data from the Web

So I am trying to create a workbench that will take a 3D Polyline and drape the vertices based on the USGS 10m NED data. I would like for the data to be queried based on the 3D Polyline which will be projected into a UTM Zone based on US Survey Feet. The thought of using an HTTPCaller has been suggested, however I am not quite sure on the steps to take to ensure the query is accurate. Has anyone achieved this?

40
fmelizard
Contributor
6 years ago
mhab
Contributor
mhabContributor
asked in Transformers
SurfaceDraper, Shape Writer and Arcs Pitfall

As already discussed here ESRI shape file FME writer issue Shape format does not support arcs.In the linked article it says, that therefore arcs are automatically stroked before writing them to shape.As I had to learn recently this does not work if the arc went through a SurfaceDraper before and turned into a kind of 3D arc (whatever this might be).In that case the Shape Writer raises some weird error message about "extra measures which do not fit to coordinate count ..." - or something like this - and translation stops with ERROR.Solution (as you might guess by now): Use ArcStroker before SurfaceDraper and everything is fine.P.S.: I thought it maybe helpful to post this here ...

90
fmelizard
Contributor
6 years ago
K
kbachmatiuk
asked in Transformers
donuts on the edges, clipping one polygon from other on the edge

Hello,Let's say that I have one big polygon A and two smaller polygons B and C.One small polygon B is fully inside the big polygon A and the other one C is on the border of polygon A. I need to clip them B and C from the big polygon A. I use donutBuilder and for one small polygon which is fully inside, I get a good result (big polygon A with a hole B).The other polygon C which intersects the border of big polygon A is clipped from the big polygon but the part which was outside the big polygon remains as an object. How to get clean cut on the border?

50
K
6 years ago
gis2020
Participant
gis2020Participant
asked in Transformers
UUID generator in GDB in text format

Hi All,I have a data in GDB with some field ID and i want to generate UUID for this in specific format.for this i have used UUID generator but results are not as per my retirements.i.e 32 digit with dash in between eg.I want Entity_ID in such format : 000000000-0000-0000-0000-000000000012.last digit should be from Field ID field.I am not sure which transformer i can use to do this can some body guide me on this ?

4611
tva
Contributor
6 years ago
T
trydlinge
asked in Transformers
Python caller issue/ Grouping points into tiles

!HiI am trying to use this python script which would be very helpful for me. I have a huge amount of data from a WFS which needs to be tiled in a good way. @takashi had a very good code, but I can’t get it to work in 2017.10.154 edition (the version I have).I have a test file with more than 2000 points and I want tiles with 230 points each.I have python installed on my computer and I am using the python caller.I get error messages:” FME Configuration: No destination coordinate system setPythonFactory failed to load python symbol `FeatureProcessor'Factory proxy not initialized f_4(PythonFactory): PythonFactory failed to process feature”Why is that?Any suggestions?/Regards, Tobias

62
takashi
Contributor
6 years ago
E
edhere
asked in Transformers
How to merge features?

Hi all,  I'm having issues merging two Excel files - I have tried FeatureMerger but I'm not getting any results.  I have a "main file" that contains a feature "POI_SHORT_NAME".  I also have an "abbreviations" file containing the same feature "POI_SHORT_NAME"  What I'm trying to do: When the postalcodes in both files match then the POI_SHORT_NAME from the abbreviations file should be written to the main file.  Cheers,Ed

160
E
6 years ago
philippeb
Enthusiast
philippebEnthusiast
asked in Transformers
Extract Excel schema automatically

Hello,Is there a way to extract the schema automatically from an Excel file when FME Server runs the scheduled workbench?People who drops the Excel files doesn't change the fields though, only the sheet name.Thanks.

620
fmelizard
Contributor
6 years ago
G
guidos
asked in Transformers
Outfall analysis

Has anyone used FME for Outfall analysis?I have a series of points which represent outfall locations and I need to use the points to follow elevation/DEM to the lowest point on the DEM. Using the path will help me determine what named water body the outfall is effecting.Using esri tools I have to build the dem with contours or lidar points and then use the hydrology tools to figure out the path of each outfall. I think this is doable in FME, but I am not sure I am using the right terminolgy when googleing this so I thought I would ask the community. Thanks,Guido

160
mark2atsafe
Safer
6 years ago
P
puddle
asked in Transformers
Selecting Boundary

Hi I would like to know if there's a way to select all the property boundary that do not have public access to the backyard of a house. For example, the properties circled in the screenshot have to be selected because their backyard is directly adjacent to the backyard of the neighbouring house. The properties on the Northwest corner however have a back alley which allow public access therefore won't be part of the desired selection. Any sort of help would be greatly appreciated. Thanks!

20
P
6 years ago
S
shahsamkit
asked in Transformers
Does FME support reaching Geosoft Grid files with extension .grd ?

https://pubs.usgs.gov/of/2004/1258/Data/grid_facts.txtThe magnetic and gravity grids are available in the following formats: 1. Geosoft OasisMontaj (*.grd, *.grd.gi) binary format 2. Grid Exchange Format (.gxf) (an ascii grid transfer format) 3. ESRI Spatial Analyst (.flt, .hdr) binary format

411
daveatsafe
Safer
6 years ago
R
rickyrbanga
asked in Transformers
Transfer attribute data (elevations) from points to the vertices of a Z enabled polyline?

I’m trying to use FME to transfer attribute data (elevations) from points to the vertices of a Z enabled polyline. I am using an Attribute Keeper so the elevations don’t get dropped, Chopper to break up the lines, SpatialRelator to relate the points and vertices, and rebuilding the lines using the Linejoiner. The Eastings and Northings are transferring over but not the elevations. Any suggesting’s to what the issue could be? Is there an alternative solution?

760
R
6 years ago
nrich
Participant
nrichParticipant
asked in Transformers
Group points into squares

(I'm using FME Server 2011)  hi FME'ers,  I have a whole bunch of points, millions, and I want to create a grid of squares/rectangles (bounding boxes) covering the points so that each grid feature contains roughly the same number of points.  I'm then going to use this grid to set of a whole load of fme server jobs to process the points - so am using the squares as a way to split up the process into managable chunks, by passing in the min/max x/y values to my 'worker' workbench.  I've split this job up so i'm dealing with 10k chunks, so want to divide this 10k square into smaller squares (or rectangles) based on the density within the square.  I also want to reduce the number of jobs I create on the server, so only want to break up the tiles when they are over a certain point count - say 5000, and group them to between 3000-8000 say.  so in the picture below, I want all the green /amber tiles grouped together (but only if they form another square or rectangle

680
T
6 years ago
O
oliwerurban
asked in Transformers
How to insert a character inbetween the string with different lentgh?

Hello.I need to insert a dash into a phone number after first  digit. I know how to do it using attribute manager and text editor only  if the length of the number is always the same. In this case is not. Is there a code I can put instead of "X" to indicate the rest of the value? If I will put fixed number the outcome is incorrect because of mentioned before different string length.Maybe there is other way?Thanks,Cheers

1792
O
6 years ago
jorge_rosales
Contributor
jorge_rosalesContributor
asked in Transformers
Personal geodatabase multi arc feature differences between ArcGIS and FME

I have a multi-arc feature in ArcGIS (4 parts) but FME treats it differently. Any suggestion?The personal geodatabase: Thanks in advance.

30
david_r
Evangelist
6 years ago
S
stysiakaleksand
asked in Transformers
Aggregating 3D polygons based on a common ID, results in corrupted geometry.

Hi  I have a 3D city model made out of individual polygons. Polygons forming one building have a common ID (also attr like Type: Wall, Roof). I need to combine/merge/aggregate together shapes beloning to each building. The output should be a shapefile or multipatch.   I tried using Aggregator in combination with Dissolver and Sorter but data looks fine only in FME viewer. I try to use it in ArcGIS Pro, CityEngine and also in Microstation but data is completely distorted.  When I load non-aggregated data in ArcGIS Pro it works fine. But the problem is it has to be combined before I can use it for my project. Any idea what could be wrong or what other ways I could use?This is my setup And this is the result when viewed in ArcGIS Pro Here's sample data, maybe sth is wrong with this data?

450
S
6 years ago
E
edhere
asked in Transformers
How to trim string length to max. 35 characters?

Hi all,I'm looking to trim a string to max. 35 characters. Actually 34 characters and ending with a "." to indicate the string has been shortened. What transformer can I use? Or does this require some RegEx?Thanks,Ed

910
E
6 years ago

Badge winners

Show all badges
30,463
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.