- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,684 Posts
50,749 Replies

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

12684 Posts

aquamarine

asked in Transformers

Possible TestFilter bug

Hi,I am using FME2016 1.0.1 Desktop, and have encountered, on random occasions, a strange occurrence with the TestFilter transformer.I can't replicate it as it only happens randomly, but sometimes, after I have added a couple of tests into the TestFilter, a yellow right-pointing triangle appears on the top section of the transformer as well as coming out of the TestFilter streams. Whenever this happens, the workbench fails when I try to run it. I then have to delete the TestFilter and recreate it. Usually the second time it is recreated with just with the yellow triangles coming out of the different streams, as expected.Is this a bug? Has anyone else experienced this?Thanks

100

7 years ago

lemzip

asked in Transformers

road network extraction

Hi,I am trying to build a network using the OSM roads dataset. From this i would like to extract all roads within a set distance from a point. This should not be a simple as the crow flies buffer selection but by road distance on each road from the point.Thoughts?

510

7 years ago

aoakes

asked in Transformers

Missing object data tables

When using the FME Quick Translator to convert CAD from Autodesk AutoCAD Map 3D Object Data to Esri Geodatabase (File Geodb ArcObjects) as raw relational static schema conversion, tables with "_od_table" are created. When using FME Workbench using the exact same settings, the "_od_table" are not created. How can I replicate the production of these tables using FME Workbench?

7 years ago

1011analyst

asked in Transformers

What is the best tool/tools for concactenating (shp) results into a csv file?

Hello, I am using FME(R) 2017.1.0.0. I have prepared a workflow consisting of several calculations and selecting attributes from SHP format. I want to output the results into a CSV format. More specifically, I want to transpose results into a custom format which automatically populate a spreadsheet. I am having trouble figuring out the right transformer/writers to transpose and design the spreadsheet the way I need to. I would appreciate this board's feedback.Thanks in advance.

7 years ago

kirstynalex

asked in Transformers

ArcGIS Online Layer Slow to Read and Process Updates

I have a question about integrating FME with ArcGIS Online (which I will be using to create an Open Data site). I am exploring using FME as the method for pushing data updates to our feature services. I have tested this successfully with small datasets, but ran into issues (understandably) with our large parcel dataset (~400,000 parcels). This is very slow to run with the Update Detector method as well as a Truncate and re-populate method. Has anyone ran into this issue and do you have any suggestions for how to do this with larger datasets like this? Any tips or tricks I'm missing? I am thinking that for large datasets we may have to manually publish from ArcMap or Pro (since it takes less than 5 mins), but it would be ideal for us to use an FME workspace for each dataset to keep it clean and consistend. However, if processing time is 2+ hours then that is definitely not the best solution. Here is a screenshot of my (currently running) workspace. I have limited the revised source

1260

7 years ago

1011analyst

asked in Transformers

What is the best transformer/s for transposing (shp) results into a csv file?

7 years ago

proudgis

asked in Transformers

Extruding building heights from 3D terrain model creates sloped buildings

I have asked this on GIS SE but seem to have had little interest. I imagine it would be more suitable to post here.How can i prevent sloped buildings when I extrude building footprints over sloped terrain? I am using FME to drape 2D features over terrain (SurfaceDraper), then using the Extruder transformer to create 3D buildings from OS Building Heights. Unfortunately the height value seems to apply itself to each vertex, which creates sloped building tops (roof geom is not relevant here) - example below: Is there an extrusion method that uses a single vertex, or is there another method entirely?

1070

7 years ago

geosander

asked in Transformers

Is it possible to extract the character encoding of an attribute?

Text attributes can have a character encoding in FME, as we all know. The encoding that is used is shown in the Data Inspector, for instance: I would like to fetch that "iso-8895-1", "utf-8" or "windows-1252" value. My guess is that the answer is no but the question is: is it possible to extract the encoding somehow? I know that the FME Objects Python API allows me to detect if the attribute is an encoded string (FMEFeature.getAttributeType() ==> FME_ATTR_ENCODED_STRING), but it doesn't tell me what the encoding is. It seems to be stored as a (hidden) attribute property though, otherwise the Data Inspector could not show it.Depending on the answer(s) I will get here, I'm thinking of posting an idea for an EncodingExtractor transformer.

1440

7 years ago

tobiasp

asked in Transformers

Calculate volume from TINSurface?

Hello, I have measured some points on some piles of dirt that I need to calculate the volumes of. I have got some points by the foot of the piles and some on top of them to define their geometries. Now is the question how to use this data to get the volumes? I have managed to get a TIN surface from the TIN Generator but I cannot calculate the volume unless it is a solid, right? Any ideas..?

1267

7 years ago

judyz

asked in Transformers

CAD Blocks with Multiple Visibility States to GIS Conversion

Hi,I'm trying to convert a CAD file contains blocks with multiple visibility states as labels. any idea how to convert that to GIS? Thanks

140

7 years ago

mjoarder_pln

asked in Transformers

Deleteing an XML element completely if the value is NULL in XML Templater?

Hello everybody, i have mapped my sql server table to an xml schema and final output we are getting metadata of tables. To input related Foreignkey information inside metadata we have a field and we mapped it, problem is for many rows we dont have values, we have NULL. From current mapping values are coming and NULL values are creating empty elements in final xml file. Please see the screenshort. We want to delete the total bnr:foreignkey element for NULL values. Please correct my code if someone can help me. Thanks a lot. Looking forward.

1258

7 years ago

hoa_leContributor

asked in Transformers

How to convert from shapefile to .mdb?

Hi everybody,I have a shapefile (line) and it includes fields:year, time, commune, province... and I have a .mdb that has a table empty have fields: a_xa, b_ti.I want to get spatial data from shapefile to table in .mdb and get attribute (commune = a_xa, province = b_ti). How can I do? Thank you

310

7 years ago

arxitContributor

asked in Transformers

Change detector attribute no matching problem

Hi everyone,I am using a ChangeDetector, only on one attribute "parcelle", to compare differences between polygon layers, but there is a problem because all of the polygons are detected as "changed" (then they should not, because values of "parcelle" attributes are the same in the two layers) :Port 1 (Added) :Port 2 (Deleted) :I thought that the problem was because of the encoding of these attributes. So I have tried to use the AttributeEncoder Transformer, but it changes nothing :I also have tried a FeatureMerger on these attributes and it works.Thank you.Aurélien

760

7 years ago

lazarlubomirContributor

asked in Transformers

Line joining/tracing till getting elevation value

Hello,please, I wanna solve one problem with line elevation on wastewater network. I have really big network of lines in 2D, but every line has 2 attributes (BOTTOM_ELEVATION_FIRST - elevation of first line vertex and BOTTOM_ELEVATION_LAST - elevation of last line vertex). Unfortunately, values of these 2 attributes are not filled for all features. So, I have situation when some features have both values, some features have just one value and some features have none values. :-/ What I need is to join lines according to fact if the attribute of elevation is filled or not - the goal is getting lines which have filled both attribute values.Do you have any idea, how to figure out this issue, please?Thank You so much!Lubo

7 years ago

mark2atsafeSafer

asked in Transformers

FME Community: Flavour of the Month (July 2017)

Hi FME'ers,What with vacation and the eventual .1 release, this is a little late - but I certainly didn't forget we need to honour July's Flavour of the Month.This - you'll remember - is the person who earned most reputation during a calendar month (and you had to be in the top ten with at least 100 points, and haven't won this before!)Anyway, the winner for July is: @erik_janErik scored 687 reputation for July, enough to put him into 3rd place overall, and earn a spot among the previous winners (@takashi, @david_r, @jeroenstiers, @jdh, @itay and @gisinnovations)The top ten for July:david_r: 1822takashi: 1534erik_jan: 687redgeographics: 662lars_de_vries: 625egomm: 612Mark2AtSafe: 584jdh: 477stalknecht: 445velasquezvictor: 394Congratulations to you all, but particularly Erik, who earns the custom Flavour of the Month badge for his efforts.Mark

7 years ago

patiaserica

asked in Transformers

Spatial query with SQLExecutor

I am trying to make a spatial query with SQLExecutor and having some issues. My filter is some point buffer features in a ESRI geodatabase and the feature points I want to filter are in an Oracle database. I am extracting the geometry and using SDO_RELATE as shown bellow. Using FME 2016.My SQL query:select * from gds.emb a where a.DATAHORA >=to_date('01/01/2017 00:00:00', 'DD/MM/YYYY HH24:MI:SS') and a.DATAHORA <to_date('01/02/2017 00:00:00', 'DD/MM/YYYY HH24:MI:SS') and sdo_RELATE(a.GEOM,@Value(_geometry),'mask=anyinteract')='TRUE'

4110

7 years ago

fmelizardContributor

asked in Transformers

Recommendations for setting up a fault tolerant file system for FME Server?

When setting up FME Server and configuring for Fault Tolerance, it's recommended that a fault tolerant file system is set up for storing the FME Server system share folders. For anyone who has set this up before, do you have any recommendations for how to create/set up the fault tolerant file system?

100

7 years ago

vkiContributor

asked in Transformers

change units of coordinates from mm to m

I have some data with coordinates in milimeters (swiss LV95) and I need to change them to meters. How do I do that? thanks, Vera

2730

7 years ago

bakkermans

asked in Transformers

Snipper does not work properly

I want to snip the first and the last meter of a line (which is 10 meters). I therefore take a Snipper, set at "Distance (Value)" with Starting Location = 1 and Ending Location = -1. The Snipper only cuts off the first meter as a remnant, but leaves the last meter untouched. Am I doing something wrong here, or is the Snipper not working as it should?PS: FME 2016.1

10514

7 years ago

parashari

asked in Transformers

Text To Column using RegEx

Hi,I am using FME 2017.0 x64 and the input data is PostGIS data from serverSo, there is a column in the table 'other_tags that contains strings as displayed. I want the values in the left of => to be the attribute name and the value in the right of => to be the value of that attribute. The two columns are separated by comma(,).The catch is the attribute name are not in a certain order, so I found a bit of difficulty to create list.Moreover, the values in the columns can be multiple, like surface could be- paved, unpaved, asphalt, grass and many more and since the workbench has to be used for multiple countries the string also cannot be defined.Could there be some easy possible way to extract the values that can make workbench shorter and easier.I tried string searcher with regex- surface"=>".*"$ but something is going wrong.Thanks.

6612

7 years ago

andyew

asked in Transformers

AutoCAD alternative label locations

Folks, I'm trying to create some polyline labels in a CAD writer but using some alternative label positions.By default the label seems to be placed dead centre on the line. Depending on the justification of the inserted text (Bottom Left, Middle Centre etc) you can move the label relative to the label point. However I want to offset the the label a certain distance from this placement.I tried to use the OffsetCurveGenerator and this almost works. However there is some complexity here. There are rules the LablePointPlacer is using to determine "which way is up" so that no matter the orientation of the polyline (drawn direction) the label is always "up" based on standard plan labelling rules. The OffsetCurveGenerator dutifully offsets lines but the concept of "left and right" based on the orientation of the drawn polyline means the offset line is sometimes "above" or "below" the target polyline.If I had to come up with some rules I&#

1040

7 years ago

tiki13457

asked in Transformers

How can I convert a polygon, assuming a whole county into 100m bins?

7 years ago

runnealsContributor

asked in Transformers

Exposing known XML/JSON Attributes

I have a known structure of an XML file/feed and am using an xfmap file to map attributes. The XML feed doesn't always have all of the fields in their feed. Is there a way to populate a reader attributes from an xfmap file?

120

7 years ago

mattdionne

asked in Transformers

How to set Bylayer color in a GIS to CAD transformation

Hi,I'm doing a transformation from a gdb to a CAD that was already setup (with block name, color ect, for each layers). I'm working with the DWGStyler and its working fine. The only problem that I find is that I'm not able to put each color "By Layer". It's possible in the Linetype checkbox to select ByLayer, ByBlock or others lines types but not in Blocks... It is possible to set up the color ByLayer in that type of transformation? Or I have to specific the color for each layers?Thanks!

1070

7 years ago

kanishk3687

asked in Transformers

TweetSearcher Authentication Issue

I am using TweetSearcher on FME Desktop 2016 to find tweets with a keyword and within a bounding box. I used my Twitter login details and it was working absolutely fine earlier.However, since a few days, I am not able to use the same workbench and it returns an errorReceived HTTP response header: 'HTTP/1.1 403 Forbidden' from 'https://api.twitter.com/oauth/access_token'Could you suggest how can this issue be resolved. I can not find parameters in TweetSearcher to provide any access token. Thanks in advance!

7 years ago

Page 381 / 508

Badge winners

evoteckhas earned the badge 12 Days Participant (2024)
marcusthas earned the badge 12 Days Participant (2024)
mattwesenerhas earned the badge English Speaker
johnjmillarhas earned the badge 12 Days Participant (2024)
scottshas earned the badge Student (Grey)

Show all badges

30,185: 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.