Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,681 Posts
50,732 Replies

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

12681 Posts

Recently active

Most replies Most views Newest first

asked in Transformers

Transformer won't sort attributes

Using FME Workbench 2014 SP1. Connected a filename part extractor to CSV reader. There are more than two hundred fields and I need to sort them alphabetically to match to the writer which is connected to a legacy database. Right clicking over the output section of the transformer and clicking sort attributes does nothing. Any help appreciated.

asked in Transformers

dynamically read raster only in given extent

I would like to dynamically read a raster using FeatureReader or RasterReader (or anything else?) transformer. This works fine but I don't want to fully load the whole raster and I have not found an option how to tell these transformers only to read the raster in a given extent, as it is possible with the "normal" ArcSDE Raster Reader. So I want to create following Worksspace: processing --> feature (perimeter) -> RasterReader (clipped to perimeter) -> further processing

asked in Transformers

Snap a point to the closest mid point on the same street

Hi guys, I have an address, and I need to move that address point to the closest mid-point of that street segment. I have gotten as far as snapping the address point to the closest mid-point, but not always on the same street. Please help. Thanks in advance.

asked in Transformers

Change Detection -

When I change Lenient geometry from Yes to No there areless elements coming out the Change Detector ports. What does this mean?

asked in Transformers

buffer adjacent polygons without overalp

Hi, I'm trying to buffer a set of municipality polygons.The buffer is only needed on the external edges i.e. the ones that have a coastal edge and the buffer for each polygon musn't overlap with it's neighbour. I've had a go with the buffer and AreaOnArea overlayer transformers but am getting stuck on how to resovle the overlaps. The below diagram is what I'm trying to acheive, starting with the green boundary polygons. Can anyone suggest an approach to this. Many Thanks James

asked in Transformers

Set SDE Data type for strings to SE_String not SE_NSTRING

It seems that the fme char type for the sde geodatabase writer maps to SE_NSTRING, we have some old ESRI JAVA_API's that don't like this format and are expecting SE_STRING, does anyone know of a way to change the default mapping for the esri geodbwriter in workbench (until we update the java API's)?

asked in Transformers

AreaOnAreaOverlayer issues ... HELP!!!

The AreaOnAreaOverlayer is a great little tool but I have 2 issues when using it. You may know of a better way to do this. Issue 1: I want my output to have the fields from all layers used. Similar to a join in ArcGIS. I can’t tell if I’m limiting that because my existing output file may not have all of the fields, so they are possibly being ignored. Could it be that I’m limiting it? Should the AreaOnAreaOverlayer automatically output all fields? (In my example below I’ve exploded the data to try and resolve my issue). Issue 2: This concerns me a little. Do you know if you can do multiple AreaOnAreaOverlayer transformers (Like I illustrate below) in an FME job? I have to make 3 comparisons as it moves through the process. FYI: All of these layers are polygons. Here’s a description of what is shown in the illustration below (Each number is represented in the picture I've posted of the FME job). The first AreaOnAreaOverlayer comparison is Leases against Boundary Units. (NOTE: IT

fmelizardContributor

asked in Transformers

Missing CFCacheName.DLL with FME 2013 SP1 GeoMedia 2013

Hi there I am using FME 2013 SP1 and have installed GeoMedia Professioanl 2013 after removing GeoMedia Pro 6.1. When I now run a workbech that was writting to a Geomedia access databease I get the following error The program cannot start because CFCacheName.dll is missing from my computer. I know this file was used by GMP 6.1 but was removed when I did the uninstall. Any help would be greatly apprciated Cheers Ron

gioContributor

asked in Transformers

Boundingbox length of sides attribute rounded?Is this a bug and if so, is it fixed in 2014

To rotate my maps in a mapbookserie using ARcMap, i extract a angle using oriented boundingboxes. I use the option to use a attribute for the sides. It's an option in the transformer Boundingboxreplacer. After chopping the boundingbox i use an expressionevaluator to test for lenght of longest side = @Value(length). to acqurie angles of the longest sides. Tester then said all failed??? So look at what fme does: Up to four of the last digits appear different. Not one is the same. (only talking about those that should be the same angel of course.) I assume that lenght() function is accurate. But what is up with the lengthcalculation of the BB-replacer. And does this also occur in 2014 version? This is in oriented mode BB_replacer mode, have not checked non-oriented. ( i now round the test to like 6 digits, its just for selection anyways)

zzupljaninContributor

asked in Transformers

preserve rotation while transforming into other coordinate system

Hello, I have AutoCAD dwg layer feature which i'm converting into another coordinate system. What I'd like to do is to preserve rotation and height informations of input data in output dwg layer (since input contains labelling information that I don't want to resize and rotate in output). I'm kinda new into FME so I apologise in advance if this is a silly question. Thanks.

asked in Transformers

I have a custom coordinate system, I was confused how to translate it for MyCoordSysDefs.fme

Hi, I have a custom coordinate system that I was confused how to translate it to the MyCoordSysDefs.fme for use in Safe Desktop. Here's how it is represented in the prj file. PROJCS["Lumos_Projection_Foot", GEOGCS["GCS_North_American_1983", DATUM["D_North_American_1983", SPHEROID["Geodetic_Reference_System_of_1980",6378137,298.2572221008916]], PRIMEM["Greenwich",0], UNIT["Degree",0.017453292519943295]], PROJECTION["Transverse_Mercator"], PARAMETER["latitude_of_origin",0], PARAMETER["central_meridian",-80], PARAMETER["scale_factor",0.9996], PARAMETER["false_easting",4921259.843], PARAMETER["false_northing",0], UNIT["Foot_US",0.30480060960121924]] I read over the help for FME DEsktop, but the I did not know how to translate it because it had two units and so many Parameters. I appricate any help. Thanks

asked in Transformers

Use data from separate databases and tables in a calculation

Hello, I am having a problem with a workspace (see the screen shot below) and I was hoping someone could help. I am trying to get values from two tables in two databases and eventually use the values as xy pairs in order to create a point. The values from the two tables are passed to an InlineQuerier and I use some SQL queries to obtain the correct values. I’ve tested the queries in ArcMAP and Access so I knkwo that they are correct. What I’m running into is that only one set of values are passed into the 2DPointConnector and the process fails when it tries to run a calculation due to null values. I was wondering if I am going about this the right way or if there is a better method to use. I copied some of the error message from the log file. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Feature Type: `2DPointAdder_OUTPUT' Attribute(64 bit real) : `10-YEAR SWEL' has value `8.27000045776367' Attribute(64 bit real) : `100-YEAR SWEL' has valu

asked in Transformers

Replace function in SQLExecutor? Or any alternative?

Hello all, I'm trying to update an Access table of mine using generated GUIDs, lets say I have the following: Table_one PARENT_GUID,FIELD_GUID ABC123-EFT1,TEST23 ABC123-EFT1,TEST24 ABC123-EFT2,TEST23 ABC123-EFT2,TEST25 Also: Table_two PARENT_GUID,MEMO_FILLED_WITH_GUIDS ABC123-EFT1,#IF##AND##CONDITION#{TEST23}ISNULL#ENDCONDITION##THEN##DO#{TEST24}ISMANDATORY ABC123-EFT2,#IF##AND##CONDITION#{TEST23}ISNULL#ENDCONDITION##THEN##DO#{TEST25}ISMANDATORY Now, due to some reasons, as you can see the FIELD_GUID is non-unique. I want to make it unique, and replace the FIELD_GUIDs with freshly replaced ones. However, seeing Table_two.MEMO_FILLED_WITH_GUIDS is a memo field filled with guids, I'd thought of using the replace function, within a SQLExecutor, like this: UPDATE Table_two SET MEMO_FILLED_WITH_GUIDS= replace(MEMO_FILLED_WITH_GUIDS, @Value(FIELD_GUID, @Value(NEW_GUID_GENERATED)) WHERE PARENT_GUID = @Value(PARENT_GUID) Where NEW_GUID_GENERATED is a GUID generated using FME. How

gpt_geoinfoContributor

asked in Transformers

[XML] order siblings

Hi all, I'm quite into FME+XML. My today's question: How can I order the siblings of a node? Example: in: <Book> <Format Type="Kindle"> <Price>5.00</Price> <Currency>£</Currency> <AvailableDate>2010-05-01</AvailableDate> </Format> <Format Type="Paperback"> <Price>8.00</Price> <Currency>£</Currency> <AvailableDate>2010-03-20</AvailableDate> </Format> </Book> out: <Book> <Format Type="Kindle"> <AvailableDate>2010-05-01</AvailableDate> <Price>5.00</Price> <Currency>£</Currency> </Format> <Format Type="Paperback"> <AvailableDate>2010-03-20</AvailableDate> <Price>8.00</Price> <Currency>£</Currency> </Format> </Book> The node AvailableDate is now before Price. Are th

maktContributor

asked in Transformers

How to add vertices along line?

I am looking to add vertices every X meters along a line (singlepart shapefile). Chopper seems to almost get me there, but it is making a multipart shapefile rather than working at a vertex level. Is modifying the abilities of the Chopper with another transformer the right approach?

asked in Transformers

Extract Attached Line to the Points

Hi, I am working on Windows 7 machine (64-bit). I have a Polyline network. I have found all the end points and now I want to extract all the line attached to those points. How can we do that in FME. (In ArcGIS, we can do it using Feature Vertices To Points and then use Select By Location)

gpt_geoinfoContributor

asked in Transformers

XQuery: replace element value with counter

Hi all, I'm getting stucked. Following problem is to be solved (hope the schematic sample will describe it): inpu xml: <greatgrandfather> <grandfather> <father> <child>foo</child> </father> <father> <child>boo</child> </father> </grandfather> <grandfather> <father> <child>doo</child> </father> </grandfather> </greatgrandfather> expected output xml: <greatgrandfather> <grandfather> <father> <child>0</child> </father> <father> <child>1</child> </father> </grandfather> <grandfather> <father> <child>2</child> </father> </grandfather> </greatgrandfather> goal My goal is to replace the child's value with their index appearance within this xml, kind of counter. What I already did: I took the transformer XMLUpdater wi

maktContributor

asked in Transformers

How to assign merge rules to SpatialFilter ?

I am doing a spatial join by intersect of points to areas (joining an attribute of the points to the attribute of areas). SpatialFilter does what I want exept when there is more than one point that intersects an area. The point attribute that is joined seems to be the max of the candidates but I would like the average. I explored all the settings in SpatialFilter and there does not seem to be any parameter that sets the merge rules for this kind of situation. Do I need to bring in another transformer to join the average value rather than the default max value?

asked in Transformers

Parsing ZIP-file with multiple file-types on FME Server

Hi! I have a zip-file (attached) that I want to parse with a workspace on FME Server. I want to use an Excel reader to read the Excel-file in the ZIP, then if the Shape-file column in the Excel-sheet contains a file-name I want to use the FeatureReader to read the Shape-file (which lies in a known sub-dir). The Excel file reads fine, but I can’t seem to produce the right path to pull up the Shape-file..? The trouble I’m having is producing the temporary path to the Upload service, including the sessionID and the ZIP-file “directory”?? Any help would be appreciated. https://dl.dropboxusercontent.com/u/44513131/DATAPAKKE.zip [Above is the ZIP-file I'm using for testing]

maktContributor

asked in Transformers

How to define the origin of grid created with RasterDEMGenerator before a raster is generated?

I am using the RasterDEMGenerator to create a raster surface from points and I need to align its cells to existing rasters I already have. A common way to do this in FME seems to be to use RasterDEMGenerator to create a raster, then use RasterMosiacker to do a snap. However, RasterMosiacker requires either offsetting or resampling the raster that RasterDEMGenerator already made. I do not want to do either since I am trying to retain the maximum precision possible (I'm trying to recreate an existing dataset). How can I tell RasterDEMGenerator not just cell spacing but also where exactly to place the first cell (for instance defining the _origin_x and _origin_y)?

francis_mContributor

asked in Transformers

SQLExecutor on MS SQL Server 2008 R2

HI, I need to make some simple sql query (like select COUNT(*)) on ArcSDE Table stored on a MS SQL server. When I use the SQLExecutor, I can't connect to my DB. How to connect. I can read with a reader, I can write with a writer, but I need to perform some simple SQL query. How to do this. Server ? Database ? Do I have to create an OLDB connection on my windows OS ? Thanks!

asked in Transformers

Launch FME using Visual Basic

Rather than have our users learn the FME interface, I would like to launch an FME model from within Microsoft Access. I assume that there is a way to do this using Visual Basic. Any Pointers? (The user will populate model parameters in Access which will store the parameters as entries in linked configuration tables stored in SQL Server. My idea is that the user can use Access to populate teh parameters and then launch FME (using a VBA event procedure). FME will then read the appropreate database entries and will also write the (profiling) results to the SQL Server database for the Access you to review).

bubblebebContributor

asked in Transformers

Is there a transformer that can be used to upload a shapefile to an SFTP site?

I have a routine which creates a series of Shapefiles. The resulting SHP are them uploaded to a SFTP via WinSCP. Is there a transformer or writter which will upload shapefiles to a SFTP site?

asked in Transformers

big data -> big headache

Afternoon All, I was spouting how FME could deal with any format and size GIS data, so a friend decided to make me sweat a bit. He provided me with a csv of over 3 billion gps points logged by vehicles to have a play with and laughed at me! I have been scratching my head over this one.... My options seem to be 1) bring up a massive FME_CLOUD Fme server ENTERPRISE with 64 GIGS of ram and try and wrestle it into shape with various fme transformers. 2)Try and utilise one of the online services to load and query the data for me. Amazon , Google cloud services. (havent succeeded here) 3)Find a Hadoop cluster to throw it at 4) admit defeat and enjoy a beer, its sunday after all. Has anyone had any sucess using Google BIGQUERY for GIS data ?Any tutorials for this in FME, success stories ? i have tried to have a play with this and FME without luck.. It seems to only be able to use non spatail data. i have read ALL the GIS Big data articles on the web without finding how to proceed.

asked in Transformers

why can't I write my aggregated lines into a polyline feayure class?

Hello. I have a searies of Lines coming from a FGDB polyline feature class and I have aggrated them into one polyline. When I then try and write this into another polyline feature class I can't. I can the error message "Cannot write a non-linear feature to a polyline feature class". I've tried adding in a geometry coercer after the aggregator but this has no effect. Hsa anyone experienced this before? Is there an alternative to aggrehator that works for lines? Thanks

1
...
463
464
465
466
467
468
469
...
508

Page 466 / 508

Badge winners

bayramhas earned the badge Welcome Back
a.hamannhas earned the badge Welcome Back
aurelienhas earned the badge Integrate Spatial Data
knutoshas earned the badge Integrate Spatial Data
mcseamushas earned the badge Conversationalist

Show all badges

30,161: Posts

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

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.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

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.