- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,686 Posts
50,749 Replies

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

12686 Posts

luke.giles

asked in Transformers

AutoCAD QLeader spline not displaying correctly

When opening and trying to view qleader arrow types in FME from an AutoCAD file, the qleaders appears just as 2 straight lines, where as it should appear as a spline. Multileaders appear to work fine. The autocad_path_type is autocad_spline_leader See the attached dwg for an example. The 2 large straight lines on the right appear as proper spline leaders in AutoCAD. Is there any workaround to transformer these into the proper splines? I can't even see attributes carried through to be able to do this manually. Thanks in advance,Luke

350

4 years ago

pbiffar

asked in Transformers

lat lon to geometry

4 years ago

jsprattParticipant

asked in Transformers

How to create key:value pair in JSON from fme_attrib_info{}.field_name and fme_attrib_info{}.field_value?

I have attempted a few different techniques to get my desired output.1.) Reader->AttributeExposer->JSONTemplater2.) Reader->AttributeExposer->ListConcatenator->JSONTemplater3.) Reader->AttributeExposer->JSON Writer4.) Reader->AttributeExposer->ListKeyValuePairExtractor->5.) Reader->AttributeExposer->ListExploder->JSONTemplater6.) OthersI am working with values such as:objid | fme_attrib_info{}.field_name | fme_attrib_info{}.field_value |-------+--------------------------------------+--------------------------------------|1 | SERIAL_NUM | 12345 |2 | TYPE | SOME_TYPE | My desired output would be as follows:{ "SERIAL_NUM": "123456", "TYPE": "SOMETYPE}I've used the tutorial on site here for extracting attributes from CAD blocks. Now, I would like to take these attributes and make a json payload per unique block to be wri

141

4 years ago

arnovananrooijContributor

asked in Transformers

Bulk attribute rename and sum values of duplicate attribute names

Hi community,I have a very complex challenge. I have a csv with an unknown set of (dynamic) attributes. I was asked to rename the attributes so everything from the dot is removed. That is very easy I would say with the BulkAttributeRenamer (BAR), but then I found out I get duplicate attribute names and this is not allowed in the BAR. I asked what to do with these duplicates and they said I have to sum the attributevalues if there are duplicates. So for instance I have and attribute xxx17.1 and xxx17.2 the result must have an attribute xxx17 and the values have to be summed. This is no problem with a fixed schema, but I have a dynamic one and I have no idea how to do this. I have attached an example csv. All ideas are welcome.Thank you.

230

4 years ago

bino

asked in Transformers

How to Trim the overlap lines based on priority

Requires functionality in a CAD environment that allows anyone in the * .dwg or *.shp file layers to prioritize what can be common "Trim" the lines (TRIM function) according to the given priorities.

4 years ago

michaelpascoe

asked in Transformers

Is it possible to add functions to be available in the Arithmetic/Text editor

Hello all, Is it possible to add your own python functions to be callable from the Arithmetic/Text editors? I find I keep having to write multiple entries in an AttributeCreator to do things like find the smallest difference between two angles. ie. Situations where you need some state so you cant just use an expression. It would be nice if I could add a python function to a workspace that is then callable like the Math functions that are available in the Arithmetic editor.Let me know if this is not currently possible and I will add it to the ideas section.ThanksMichael Pascoecc: @deanhowell, @luke.giles

4 years ago

ltsanthony

asked in Transformers

Hello, I am new to FME and could use some help with the FME FeatureMerger Transformer. I have two excel files that contains a matching key field, however I am unable to pull in the 'other' column of data associated to the key fields.

I know it's probably something simple, but I'm not seeing it. I thought perhaps inlineQuerier would help, but I am not versed with SQL. Essentially I want to do a "vlookup" from one file into the other based off the key field. thanks in advance!

4 years ago

gellerroma

asked in Transformers

How write measure to postgis?

Hello.I have calibrated route in file geodatabase (ArcGIS). I have line coordinate (kilometre) in the start and the end point. I try export this route with M-value to PostGIS in FME. But in result I have line without M-value. Do you know how it works?If i created MULTILINESTRING M in postgis directly sql it work. So metadata field geom support M-value PS GeometryExtractor have field with M-value

260

4 years ago

richardtContributor

asked in Transformers

How to remove repetitions from output of PointOnPointOverlayer?

I am looking to merge into a list selected attributes from nearby points and output a single feature for each group of nearby points. PointOnPointOverlayer perfectly finds the nearby points and generates the list I want, but outputs all the input features with a list of all the other features. Thus for say 4 nearby features it will output 4 features each with a list which identifies the other 3 features in the group, but without anything like a group ID with which you could select just the first in each group with a DuplicateFilter.This is almost exactly the example given in the PointOnPointOverlayer manual page which creates lists of crimes at common locations... but doesn't explain how to not have multiple copies of the same list at the same location. Am I missing something obvious? It seems that PointOnPointOverlayer has done all the hard work!The closest I could get to generating a group ID is to give all my input points a unique ID field, then set "Merge attributes"

126

4 years ago

edhere

asked in Transformers

Help needed on spatial transformation (overlapping coordinates)

Hello all, I need some help performing a spatial operation. What I haveA set of coordinates (sample enclosed) What I wantRemove / dissolve coordinate pairs if the are within 2 km radius of each other so that only coordinate pairs remain that have no overlap. What I've triedA Bufferer transformer with a radius of 2km connected to a PointOnAreaOverlayer.The result is a bunch of overlaps but I don't know how to further process these. Cheers,Eduard

4 years ago

j_geo

asked in Transformers

LAS tansformation and local coordinate system

Hello,I am a researcher from Slovenia. I'm having huge trouble working with Slovenian datasets, as they are in EPSG:3912 or EPSG:3794. These two systems are not supported by FME. I solved this for shapefiles by using ESRIReprojector. But it does not seem to work with las datasets. I am trying to extrude footprints using LIDAR data and convert that to KML, which needs WGS84 data.Is there a sollution? I am quite surprised that FME does not support all EPSG projections.I even tried to add custom coordinate system and was not successful.Regards!Jernej

420

4 years ago

whatahitson

asked in Transformers

How to count the number of features with the same value for an attribute

Hello, I'm passing a load of lines through an FME workbench and eachline has a project name as an an attribute. I want to add an attribute that counts how many lines are in the project (share the project name). Does anyone know how to do this? I've tried playing around with the counter but have had no luck. what I need is it to separate out into all the different projects, use the counter, then chuck everything back together. I would use a filter but there are hundreds of projects. Any ideas? Thanks

16160

4 years ago

joe.fmeContributor

asked in Transformers

Hi, I'm a pretty experienced FME user but this has got me stumped. I'm trying to parse a date field, but it's not parsing the Nulls/Empty/Missing entries despite being selected to

I have fed it into a NullAttributeMapper to make sure all Nulls, Missing and Empty fields are uniform. That's fine, and so is the Date transformation when inspected. However it still rejects any of the Null fields, and when it outputs to the AttributeManager, all of the fields are then Null. Even the ones with a date value. I've checked the "Passthrough Nulls, Empty and Missing" values to "Yes", but still no luck. It seems to apply the null to everything in the DateTimeConverter.I've tried with a new Transformer/rebuilding that section, and have also restarted the workspace, as well as clearing any temp files. Any help? Thanks

17613

4 years ago

jan

asked in Transformers

A problem with Statistics Calculator

The statistics Calculator gives this error when trying to count the sum of an attribute: 2020-08-11 12:49:59|2233.8| 2.3|ERROR |Python Exception <MemoryError>: 2020-08-11 12:49:59|2233.8| 0.0|FATAL |@Python failed to execute function `StatisticsCalculator.recordFeature'2020-08-11 12:49:59|2233.8| 0.0|ERROR |StatisticsCalculator_2_InputProcessor (TeeFactory): StatisticsCalculator_2_InputProcessor: @Python execution failed2020-08-11 12:49:59|2233.9| 0.1|ERROR |StatisticsCalculator_2_InputProcessor: @Python execution failed There was approx 2.5M features passing through each one having a value of 1. So the sum operation should not be exhaustive. What could cause this? A bug?

590

4 years ago

jseigneuret

asked in Transformers

Isolate list of attributes in published paameters

I use a custom transformer with two inputs, 1 per table.In my custom transformer i have 2 published parameters to get the attribute of:table A - Fieldtable B - Field But both parameters return globales listes of fieldsIt's possible to isolate the fields list for each table on it specific parameter

4 years ago

francis_mContributor

asked in Transformers

Multiple attachment emailer

I have a simple workbench that read data from a table and produce a number of Excel files. Depending on the config, the output can be 2, 3 or more Excel files (via FeatureWriter). At the end, I want to send the result by email. If I use Emailer and put my attachment manually, it works perfecly, but if I want it to be more flexible, I want as many attachment as my workbench produce. Is it possible to concatenate the output dataset produced ? I tried but failed... any Idea ? No zip please!

710

4 years ago

muhammad_yasir

asked in Transformers

Defining dataframe at Python Caller

Hi there, I am defining a data frame at Python caller on __init__ function like below: class FeatureProcessor(object): def __init__(self): df2 = pandas.DataFrame(columns= ['INCIDENT_DATE',INCIDENT_MINS','INCIDENT_VALUE']) later in the program at input function I am storing feature attribute value in data frame something like that: def input(self,feature): self.pyoutput(feature) df2['INCIDENT_DATE'] = feature.getAttribute('DATE') df2['INCIDENT_MINS'] = feature.getAttribute('MINS') df2['INCIDENT_VALUE'] = feature.getAttribute('VALUE_LOST') However, when I ran the Python caller block, it throws an error message that df2 is not defined at the input block. Could anyone point out where am I making the mistake?

442

4 years ago

mike707

asked in Transformers

FME Uses Proxy Even When "No Proxy" is selected

I change FME Proxy Settings from "Use system proxy settings" to "No Proxy". But FME is still using the system's settings. So I edited the systems's settings and disabled proxy, and removed proxy settings from environment variables. FME still uses proxy settings. I restarted FME, and it still uses proxy settings. I can't connect to the proxy right now, so the transformation crashes. Snapshot below. How can I get FME to not use any proxy? FME 2020 here. Thanks in advance, Mike

170

4 years ago

boubcherContributor

asked in Transformers

Right left side of the road

I am not getting the right info when I use the rightleft transformer for the position of the point to the road I check the segment and is has the same direction all Point are getting RIGHT position valueany thought please

4 years ago

bbulla

asked in Transformers

Exported shapefile problems - FeatureWriter

Hi,So after lots of testing, it's looks like when I export shapefiles using the FeatureWriter and include the .sbn Spatial Index, the shapefiles do not function properly. When first loading them in ArcMap, they appear to be ok, but when zooming, selecting, panning the map, I get very odd results with certain features suddenly dissapearing, not being selectable, etc. If I modify my FeatureWriter to not include any spatial index, then the shapefiles work fine. I only have this problem when I include the spatial index. I would like to include the spatial index. Is there a fix for this?? Thanks,

400

4 years ago

mattebridges

asked in Transformers

How to create attributes from JSON arrays?

Hi - I'm trying to create individual records with attributes from a JSON response from an API. I've been able to call the API using the HTTP Caller and have tried using a JSON Fragmenter to extract attributes. I don't seem able to get attributes from this but as shown in the attached there are a number of attributes in one of the returned rows. This looks as if it is a list called 'array' (there are 49 members in the 'list' which is as expected). I'd have thought I could use a List Exploder but this transformer doesn't pick up any list attributes. I'd really appreciate any advice on how I might explode this structure in to individual rows with attributes. Thanks and all the best. Matt

5950

4 years ago

ateko

asked in Transformers

ESRI Reprojector - Read Source Coordinate Sytem from feature

Is it possible to read the coordinate system from the input features and use it as source for the ESRI reprojector? Background is, that I don't want to define a transformer for each UTM zone as the destination coordinate system and the geographic transformation will be identical for all, so it would make sense to read the source coordinate system from the input files. Unfortunately I have no idea how to realize this. I've tried a User parameter, but I have no idea how to dynamically populate this value with the source coordinate system.

250

4 years ago

gsgoraya

asked in Transformers

Create buffers based on Distance and find the count of points within buffer

Hello All,I have two datasets. The first dataset is excel files that show citizens' residence the second dataset is GTFS. I want to find the number of residents who live within 400 meters from the existing bus stops. I would appreciate the help or advice. Thanks

440

4 years ago

bonbon

asked in Transformers

How to clip a raster with clipper's extend?

Hi,I want to cut a raster with shp file, and the result raster will have the extent of the clipper's instead of the clippee's. (consider null or nodata as filled up)

2630

4 years ago

bkolubenka

asked in Transformers

I would like to ask about creation list from several columns

I just want to create a line from below table in screen. To do it may be needs to create list as below but I do not know how it manage. Please help Sample of list below. Facility Name | Request User | X | Y |========================================Line | MEKK | x1 | y1 |Line | MEKK | x2 | y2 |Line | MEKK | x3 | y3 | Line | MEKK | x* | y* |

4 years ago

Page 190 / 508

Badge winners

joeluhlinhas earned the badge Student (Grey)
sguru7667has earned the badge FME Form Basic Training
chditthas earned the badge Welcome Back
vaspelinhas earned the badge Student (Grey)
vaspelinhas earned the badge Teacher (Grey)

Show all badges

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