- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,744 Posts
50,979 Replies

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

12744 Posts

asked in Transformers

Split attributevalue into 2 different attributes

I have an attribute [complete] withe the value 1-A. I would like to split that value to attribute [split1] with the value 1 and attribute [split2] with the value AI've tried AttributeSplitter;AttributeTrimmer;AttributeCreator

9500

7 years ago

jakethepainterContributor

asked in Transformers

2017 performance issues with Point On Line Overlayer

Has anyone else experienced performance issues with the Point On Line or Point On Area Overlayer? In 2016 I have a workbench that does some overlays of about 700,000 lines with 2500 points and it runs within about 30 min (most is reading in features for other parts of the process). But when I try to run it in either 2017.0 or 2017.1 I get to a point where it says, "Creating spatial index" and it's been at it for hours. I tried upgrading the transformers to the latest version, with no change.Just wondering if anyone has any ideas or has had a similar experience.

130

7 years ago

rcoodey

asked in Transformers

Access SQL Creator Info in FME Server PostgreSQL Repository?

I wasn't able to find any schema documentation for the FME Server repository, is there any public details I might have missed? Essentially just trying to query source and targets for each workspace. Was able to query this information for readers and writers but we often use "SQL Creators" and/or "Joiners" to pull in tabular information. Is there a way to access those from the repository database? To list out the connection name would be great or even grab the SQL?Here is what we have so far:SELECT fme_item.name AS "Workspace", fme_item.title AS "Workspace Title", fme_item.username AS "Username", fme_item.lastpublishdate AS "Publish Date", fme_dataset.location AS "Data Location", fme_dataset.format AS "Data Format", fme_feature_type.name AS "Table/Feature Name", fme_repositoryinfo.name AS "Repository", fme_dataset.is_source AS "Is Source"FROM public.fme_item, public.fme_dataset, public.fme_feature_type, public.fme_repositoryinfoWHERE fme_item.item_id = fme_da

140

7 years ago

millstj

asked in Transformers

FME Inspector - Trend Micro AV - Problems?

FME Data Inspector disappeared from machine this morning. Upon investigation, it look like Trend Micro AV has picked it up as a virus. Anyone else had this problem?

7 years ago

fmelizardContributor

asked in Transformers

What are all the FME Server config files where the hostname is listed?

What are all the files that specify the FME Server hostname, that can't be accessed from the FME Server Web UI or backend database?

7 years ago

dheeraj

asked in Transformers

How to use AttributeJSonPacker and Unpacker

I need to pack all the attributes of DGN file by using AttributejSonPacker but unable to expose the attribute "_packer" how can i unpacked the same?

190

7 years ago

pepote

asked in Transformers

Point on raster value extractor: How to give z coordinates to points depending on their position on a geotiff?

1140

7 years ago

mygisContributor

asked in Transformers

FME Desktop Question on Talk like a Pirate day

Ahoy, Matey!Would the "Scuttler" be a good name for a transformer created by an FME "Savvy" on the Talk Like a Pirate day?http://metro.co.uk/2017/09/19/international-talk-like-a-pirate-day-pirate-phrases-to-say-to-ye-crew-mates-6937117/

7 years ago

venuContributor

asked in Transformers

Move Floor plans side by side

Dear All,I have multistory building plans and each floor located the same place.I need to move each floors side by side.for example, 15 floors need to move side to side as like 5 (Column) X 3 (Row)Please advice to achieve this taskThanks in advance.Venu

7 years ago

michael_pieters

asked in Transformers

How to derive width (polygon) at point feature locations.

Hi,I am trying to calculate the width from a polygon at point feature locations (see figure). I was thinking about creating perperdicular linen at the point feature locations (perpendicular to polygon). Clipping the perpendicular lines (using the polygon as clipper) and calculating the length of the perpendicular lines. Is there an easier way to do this?Kind regardsMichael

120

7 years ago

barrett_hContributor

asked in Transformers

LineOnAreaOverlayer - Road polygon attributes to centrelines

Hi all,I have a polygon layer representing the sealed area of our road network with numerous attributes about the road. I also have a road centreline layer which has no attribute information. I want to get the road polygon attributes applied the appropriate centreline. The obvious transformer is the LineOnAreaOverlayer, however, this creates a lot of 'stub' centrelines that get associated with an intersecting road (please see image for an example). In the example, a small section of Road 2 is given the attributes of Road 1.So far the methodology that I have come up with is to:1. assign a unique identifier to each centreline2. process through the LineOnAreaOverlayer3. determine the lengths of each segment 4. combine segments based on unique identifier 5. use the attributes of segment with the greatest length for the attributes of the centrelineIts not ideal as there is potential for error, so I would be keen to see if anyone else could come up with a better methodology.Thanks as

1020

7 years ago

jasonleemann

asked in Transformers

MSWordGenerator and FME Cloud?

Is it possible to use the MSWordGenerator transformer to out .docx via FME Cloud?

140

7 years ago

fmelizardContributor

asked in Transformers

Yarrrr mateys! how do I get theee cool pirate badge? The winds tell me that today is the day

7 years ago

smartman63Contributor

asked in Transformers

Clip and dissolve.....best way

Hi all.I Need some help. I have two ESRI shapes, the yellow one and a pink one.Both have a column named ID with the values shown below. The red label is for the pink areas and the black label belongs to the yellow areas.The yellow areas can completly be overlapped by each other. (area 800 is under area 700)I want all to be "clipped" and joined between the pink and the yellow based on the ID column. I need the result as shown in the second image, the blue hatched resulting areas in a shape file.Any ideas?

730

7 years ago

havmoejbvContributor

asked in Transformers

DWG reader: Not all layers read as Feature Types

I am running into something while trying to read a DWG file and handle the data based on layers. I set up the reader with 'Group Entities By Layer Name' and most layers are being sent to my writer as Feature Types, with one exception: There is one Feature Type that seems to contain data from several layers, as in this example:The Feature Type is A208, while the autocad_layer is A234. Both A208 and A234 are available as Feature Types from the reader, but the A234 reader contains no data. The data on layer A234 (and other layers) can be exported from A208. I found a workaround on this by exposing autocad_layer in A208 and take it from there, but in a different setting I may have missed it. Is there something special with these layers that make them come "grouped" up like this, and how can I determine if my DWG files have things like this? I'm a GIS person, not a CAD person, and Autocad is a bit alien to me...

7 years ago

clives_online

asked in Transformers

Could not open File Geodatabase table `Delta_Block_Polygon'

I keep getting an error trying to write to a specific table, getting an ESRI gdb error message (http://support.esri.com/en/technical-article/000004275).It claims that the table name has a leading underscore.I placed a StringReplacer (Image 1)I keep getting the same error listed in the ESRI blog above????Geodatabase Error (-2147467259): General function failure.Could not open File Geodatabase table `Delta_Block_Polygon'A fatal error has occurred. Check the logfile above for detailsAny suggestions appreciated

7 years ago

clives_online

asked in Transformers

TestFilter not working as expected

I have a TestFilter query that works on most dwg layer names but not on a number of layer names.There are approx 70 Dwg files with approx 300 feature names, most work but one (Tree) does not??I tried two queries Else IF @Value(fme_feature_type) IN AF_Tree,G902TREELINE,G902DTREE3,G903TREE_DECIDUOUS,00__TOPO__TREE__LINES,00__TOPO__TREE_CONIFEROUS_SPREAD_SYMBOLANDElse IF @Value(fme_feature_type) = AF_TreeElse IF @Value(fme_feature_type) IN G902TREELINE,G902DTREE3,G903TREE_DECIDUOUSElse IF @Value(fme_feature_type) IN 00__TOPO__TREE__LINES,00__TOPO__TREE_CONIFEROUS_SPREAD_SYMBOLI keep getting G902DTREE3 rejected into the Unfiltered layer?? Any recommendations would be appreciated.

260

7 years ago

oscardInfluencer

asked in Transformers

Extract gml:name from CRS definition

Good morning!I have a process that needs to get the definition for several CRS. To do that, it uses a HTTPRequest:http://www.opengis.net/def/crs/EPSG/0/4258http://www.opengis.net/def/crs/EPSG/0/3042From the response I get, I have to take only the first <gml:name> element:<gml:name>ETRS89</gml:name><gml:name>ETRS89 / UTM zone 30N (N-E)</gml:name>I wanted to use XQuery, but it requires the declaration of the namespace. The problem is that every CRS definiton has different namespaces:<gml:GeodeticCRS xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:epsg="urn:x-ogp:spec:schema-xsd:EPSG:1.0:dataset" xmlns:gml="http://www.opengis.net/gml/3.2" xmlns:rim="urn:oasis:names:tc:ebxml-regrep:xsd:rim:3.0" gml:id="ogp-crs-4258" xmlns:gco="http://www.isotc211.org/2005/gco" xmlns:gmd="http://www.isotc211.org/2005/gmd"><gml:ProjectedCRS xmlns:epsg="urn:x-ogp:spec:schema-xsd:EPSG:1.0:dataset" xmlns:gml="http://www.opengis.net/gml/3.2" xmlns:rim="urn:oasis:names:tc:e

136

7 years ago

maicaContributor

asked in Transformers

Unexpected Input.

Hello,I implemented a workflow that read a shp file, does some basic elaboration and writes the result in an Oracle table.I call the input file using a variable.Now, if I modify the input (more record but with the same structure), I receive this message in a window in FME Desktop:"Unexpected Input: During translation, some feature were read that did not match a reader feature type in the workspace. This can happen if the reader dataset if changed, or a reader feature type removed or renamed."If I execute the same workflow in FME Server, I don't receive any error message, but zero feature are written in oracle.Any idea about this strange behaviour? What can I do to better investigate?Thanks.

910

7 years ago

rdellar17

asked in Transformers

Fusion Table Writer - Getting the newly Created Table Id / Retry Logic

Quick Questions. I have a Writer that is writing to a Google Fusion Table. I know that it is creating a table with the "Table Name" that I give it and a new Table Id that is created behind the scenes.1) First Question: Is there some way in FME to get that Table Id? For any follow up operations (reading, etc) you have to use the Table Id and not the Table Name. I know that FME is using the Table Id. I can see it in the INSERT INTO statements that it is using... (I replaced the Table Id with Xs.)Google Fusion Tables: HTML SQL Request: 'POSTFIELDS=sql=INSERT INTO XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ('geom', ...Seems like the Table Id would be a nice thing coming out of a FeatureWriter... But maybe there is a way to get it today? 2) Second Question: Fusion table requests seem to fail pretty frequently. Is there any way to turn on retry logic so that on fatal errors (that haven't added data) the API request can be retried?Thanks!

7 years ago

fmelizardContributor

asked in Transformers

How to search a text field for given values and use them to join or merge tables.

I have a spreadsheet with a list of company names, and an RSS with a text field that may contain one or more of the company names (along with other text). How can I use FME to search the RSS text field and match it to my company names? So far I have tried the InlineQuerier with an SQL JOIN and LIKE statement, but I'm not getting as many matches as I expect and only one company name matching when there may be >1. I want my output to contain a field that lists all the company names found in the RSS text field. Any suggestions or alternative workflows would be greatly appreciated!

281

7 years ago

masonb12Contributor

asked in Transformers

I would like to add elevations to a point shapefile using a point cloud .xyz file. Can I use the surfacedraper for this? If so, how do I get the new shapefile as output? thanks

200

7 years ago

virtualarchitec

asked in Transformers

How to drape a GeoTiff on Clipped Triangles or TINSurface using AppearanceSetter

Hi,I'm trying to drape a selection of map tiles in GeoTIFF onto a Triangle or TINSurface with the AppearanceSetter. After trying using the TINGenerator > Clipper > AppearanceSetter I followed a few tutorials and help articles (e.g. https://gis.stackexchange.com/questions/130870/help-with-draping-an-image-over-a-tin-in-fme-for-viewing-in-meshlab-or-similar ).The closest result (see image) was by passing SurfaceModeller > Clipper > FaceReplacer > AppearanceSetter but the output terrain had a single map tile repeated across the whole surface.To address that tried ensuring that the tiles and terrain aligned perfectly by introducing BoundaryReplacer earlier in my process and then passing that to SurfaceModeller > Face Replacer > AppearanceSetter. My tiles are still being rejected by the AppearanceSetter.Any suggestions would be appreciated.

1290

7 years ago

ujjwalpakhare

asked in Transformers

Would like to find out the points which is not exactly placed on the vertex of its associated line.

My DB contains line (say street network) and points (say Bus Stops), the points has to be placed on the vertex of the lines.Would like to find out all those points which is not placed on the vertex of the snapped line.

7 years ago

ujjwalpakhare

asked in Transformers

I would like to find out point which does not intersect with line.

440

7 years ago

Page 376 / 510

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.