- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,745 Posts
50,983 Replies

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

12745 Posts

Most replies

Most views

Newest first

redgeographicsCelebrity

asked in Transformers

Can Safe support look into this?

https://knowledge.safe.com/questions/56497/show-metadata-on-autocadcivil-blocks.html

7 years ago

ypyao1993

asked in Transformers

GDB to CityGML about GeometryCoercer Error

The cityGML results keep all data except geometry data, then this error alert. What's the matter?Have you ever meet this problem?

130

7 years ago

bggart

asked in Transformers

Populate row based on value in previous row, when new value encountered use that value for following rows. Currently trying AttributeManager

I'm doing this via PostGres table, but attached is a small example of some of my data in excel. Also attached are my transformers. I'm trying this via AttributeManager using an expression. Not sure if my syntax is just wrong or if my approach needs work also. Question: When I encounter a null value I want to use the value from the previous row. I want to accomplish this for all rows until I hit a new value. Then when I hit that new value I want to use that new value in the null rows underneath it. I want to do this until the end of file. I have several thousand records like this. Reference the well_location column to see what I'm describing. Thanks for any help!

1500

7 years ago

dbklingdom

asked in Transformers

Setting the Schema of a File GDB

Hello, Below is a Concatenation of Schema from two shape file that have similar schema now put together. I send it in as SCHEMA{}.schema to the writer. Since this is basically a csv and the Writer see it in Dynamic mode i would think it would set the schema, but does not. any suggestions please? AREA_MI fme_decimal(15,3),CENT_LAT fme_decimal(9,6),CENT_LONG fme_decimal(11,6),CFCC fme_varchar(3),COUNTY1 fme_varchar(100),COUNTY2 fme_varchar(100),COUNTY3 fme_varchar(100),CTY1FIPS fme_varchar(3),CTY2FIPS fme_varchar(3),CTY3FIPS fme_varchar(3),CTY_FIPS fme_int32,ENC_ZIP fme_varchar(5),ID fme_decimal(15,0),NAME fme_varchar(130),NAME1 fme_varchar(100),NAME2 fme_varchar(100),NAME3 fme_varchar(100),NAME4 fme_varchar(100),NAME5 fme_varchar(100),NAMETYPE fme_varchar(30),NAME_TYPE1 fme_varchar(30),NAME_TYPE2 fme_varchar(30),NAME_TYPE3 fme_varchar(30),NAME_TYPE4 fme_varchar(30),NAME_TYPE5 fme_varchar(30),PO_NAME fme_varchar(100),PT_LOC fme_varchar(1),RPO_FLAG fme_varchar(1),STATE fme_varchar(2)

150

7 years ago

ncc

asked in Transformers

Drivetime isochrone from multiple points of origin (Network Analysis)

Hi, I am trying to create drivetime isochrones from multiple nodes with a routable road network. What I am trying to achieve is a visualisation that looks something like this. This was created with Qgis + python - Source (http://planet.qgis.org/planet/tag/drive%20time%20isochrones/) I have managed to work out the drive time isochrone from one node using this example using the network cost calculator (Thanks to the Calculating the emergency response travel time example (https://knowledge.safe.com/articles/Samples_and_Demos/Calculating-emergency-response-travel-times)) However I am not sure sure how to progress from here as the network cost calculator does not work with multiple source input. I would appreciate if anyone can shed any light on this problem. Regards, Matt

2700

7 years ago

tfsrichard

asked in Transformers

Financial Year Calc

(not sure how to cast that _year attribute to an integer)Hi,I need to only filter records from a date field that are in the current financial year.e.g. if month(current_date) => Julystart_date = 1st July getYear()end_date = 30 June getYear(+1)elsestart_date = 1st July getYear() -1end_date = 30 June getYear()

793

7 years ago

andyew

asked in Transformers

Duplicate points and offsetting each duplicate

Folks,I have a CAD output from a Mapinfo source. One of the challenges I'm facing is overlapping labels and blocks.Some blocks are symbols representing co-located features.My goal is to try and detect the duplicate label\\block placement points and perform some kind of offset to separate the objects.In most(all) cases I'm using the CenterPointReplacer or LabelPointReplacer to determine the label\\block insertion point.In some cases an ideal placement methode would be to detect the duplication and then alter the placement with a polar offset.For example 4 co-located symbols would be placed as 0, 90,180,270 1m radius.Are there any suggestions how I might be able to firstly detect the duplicates and work on the "duplicate sets" to calculate new polar coordinates?

520

7 years ago

andyew

asked in Transformers

Globally update DWGStyler Block\\Name source with new source DWG

I'm moving a workspace to a new PC and I have about 40 DWGStylers inserting blocks. Is there a quick way to update the source dwg for the block inserts? I'm hoping not to have to right click on each one and browse a new location for the DWG.

7 years ago

sav426

asked in Transformers

PDFSTYLER - URL's exporting corrupt. Pics and Workbench attached.

Hello,I am exporting data from SDE to PDF and would like url's associated with each grid to open a file.I have created the path for each url within an attribute creator and associated it with the PDFSTYLER.Here is the "corrupt" url when you click it in the PDF:Here is the Tooltip showing the proper data for URL (same is used for the URL):Here is the details within the PDF of the URL box showing it carried over correct:If you change it opening weblink or opening a file etc etc doesnt change the way it adds all those random symbols in the link when you actually link it.I will also attach the actual workbench.This is the version of FME I am using:Edition: FME Desktop Smallworld Edition (floating) Version: FME(R) 2016.1.0.1 (20160516 - Build 16494 - WIN32) Here is the workbench:Id appreciate ANY help with this.Thank you! Savas

7 years ago

emorecas

asked in Transformers

Obtain the degrees between 2 points on FME

I need to know how to get the degrees from 2 nearby pointsAny help?

190

7 years ago

ben_nion

asked in Transformers

Reading Mesh Model in OSGB v3.4

Hi, I'm doing something with Mesh model in OSGB format. But I found that only the geometry can be read by FME. The texture is missing. Did anyone tried something like this and had a solution of this?

180

7 years ago

longhornfan

asked in Transformers

FME Server deleting jobs information daily

We have a major issue. For no apparent reason FME Server 2016 is clearing out the jobs and logs of completed and failed jobs daily. We have not changed a single setting. When we look at the set times to hold onto these items it is still set at 7 days. Again, nothing was changed. The GIS Manager also reviewed this completely and he's come to the same conclusion, something all of the sudden is going wrong.Please note we have not upgraded or done anything out of the ordinary. When midnight rolls around tonight all of the notifications about completed jobs will once again be deleted by FME Server 2016 and a new day of notifications will begin again.Has anyone seen this or dealt with this issue?

200

7 years ago

fnealContributor

asked in Transformers

Assign line length, then snip points at interpolated values.

I have irregular line segments that I need to create points along using station (M) values. The actual Shape Length of the line and the station values are not the same (i.e. shape length of 50 and end M value of 75). The line feature has the M values as a property, but not as an attribute. The beginning and end M values for the line segments are known.Is there a way to reassign line length (in memory) based on the known M values so that I can place (snip) points on interpolated values along the line?Thanks in advance,Freddy

7 years ago

robertdbuckley

asked in Transformers

How to modify the UUIDGenerator so that the ID starts with a letter

I have to create an UUID and wanted to use the UUIDGenerator. My XSD File has defined the UUID as an ID which may not start with a number. The UUIDGenerator put a number at the front though and I see no way of modifying it. Why is this? and how should I best generator an ID otherwise?

4066

7 years ago

cjones28

asked in Transformers

Writing conditional values into SQL Creator

Hello,I'm not sure whether this is possible or not. I've created an SQLCreator with the following SQL, the objective is to return all records from the table 'TableA' that do not join on 'equip_no' in 'TableC' because the attribute name 'SERIALNUMBER' is not available.SELECT m.EQUIP_NO,m.EQUIP_GRP_ID,EQUIP_CLASS,PLANT_NO,a.TABLE_DESC as "ROUTE",b.TABLE_DESC as "DELIVERY UNIT",c.TABLE_DESC as "ENGINEER",d.TABLE_DESC as "SECTION MANAGER"FROM TABLEA mLEFT JOIN TABLEB a on m.EQUIP_CLASSIFX2=a.TABLE_CODE and a.TABLE_TYPE='E1'LEFT JOIN TABLEB b on m.EQUIP_CLASSIFX11=b.TABLE_CODE and b.TABLE_TYPE='E10'LEFT JOIN TABLEB c on m.EQUIP_CLASSIFX13=c.TABLE_CODE and c.TABLE_TYPE='E12'LEFT JOIN TABLEB d on m.EQUIP_CLASSIFX16=d.TABLE_CODE and d.TABLE_TYPE='E15'LEFT JOIN TABLEC e ON m.equip_no=e.equip_no and e.ATTRIBUTE_NAME='SERIALNUMBER'where(e.equip_no is null and m.EQUIP_GRP_ID='AU190RTK0001' and m.DSTRCT_CODE='RTK1')or(e.equip_no is null and m.EQUIP_GRP_ID='AU190RTK0002' and m.DSTRCT_CODE='RTK1')The

7 years ago

janseppanen

asked in Transformers

FME Server reinstallation (Red Hat 7) fails with permission denied for postgres

Hi, We are reinstalling/upgrading to FME server 2017.1.1.1 (64-bit version) on our linux machine (Red hat 7). But there is permissions issue related to postgres. The installation is run with root priviledges and we have fmeserver user as part of root group. We have tried to change installation directory from opt/fmeserver -> data/fme_installation.snippet of the installation process (express option):Enter the port number for the Server where the Web Application Server will be installed. [80] : 8001 ...FME has been successfully installed to /data/fme_installation...Setting up Database...bash: /data/fme_installation/resources/logs/installation/initDB.log: Permission denied cp: failed to access ‘/data/fme_installation/Utilities/pgsql/data/postgresql.conf.tmp’: Permission deniedWe have checked that there is no other postgres installation running during the installation time. -JanFollow-up: We managed to successfully install the server. The issue was the permissions on the installation f

7 years ago

kumarkannan1980

asked in Transformers

Hi, I need to convert the data from Oracle spatial to Microstation v8 using .net FME library (c#.net). I am facing problem while converting point features, it is coming as line feature (zero length) even though I set "igds_cell_name" and "cell librar

150

7 years ago

jportemer

asked in Transformers

Drape several object using real coordinates

Hi everybody,I have a single orthophoto, and several 3D objects I created from a shapefile and the Extruder transformer. Both datasets share the same coordinates system (EPSG: 2154).I am trying to texture all features using this same raster and the true coordinates which already indicates where each pixel should go. With no particular settings, each object is render with one entire copy of the raster, which is not what I want. But I can't find the way to set the texture coordinates properly.Can you help me to find the right setting and/or the right transformers for my need?For the moment, I use the ApparenceSetter transformer with these settings:_xmin, _ymin, _xmax, _ymax being the bounds of each feature and XMIN, YMIN, XMAX, YMAX being the bound of the raster used for texturing. But this result with all featured rendered in black with stripes, so this setting is not right.Thanks a lot for your help!Jean

7 years ago

larrybird

asked in Transformers

XML Templater Error

Hi!While using the XMLTemplater, I sometimes come across this error:""XMLTemplater_2(XMLTemplaterFactory): The following error occurred near line 4, column 25 of the query:XMLTemplater_2(XMLTemplaterFactory): invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?)""What does this mean? The XML has been pasted from XMLSpy whom have no issues with the XML. Some while ago I managed to see what was wrong myself. But instead of writing it down I thought "I will remember". I did not.Cheers!

498

7 years ago

pflegpetContributor

asked in Transformers

String Replacer with Conditional Value

Hi! I'm trying to create a conditional value for a StringReplacer but I don't get it to work. Basically I have an attribute that can contain substrings starting with a space followed by a slash (e.g. "keep / remove"). In such cases I want to remove everything after "keep" exept for one special case where I want to keep the whole string (e.g. "keep / keepalso"). I tried doing so by setting up conditional values for the "text to replace" parameter with this logic: IF attribute contains "/" AND Attribute != "keep / keepalso" Output = regex _/.*$, ELSE Output = <empty> In other words the StringReplacer should either replace the regex with an empty string (exept for "keep / keepalso") or do nothing. It seems to work for replacing all " / remove" substrings but also overwrites all other instances with empty values. Is it even possible to do what I want to do with one StringReplacer? Thank you

1820

7 years ago

vemanamanu99

asked in Transformers

How do I find values in a list searcher

I have a list as structured below._list{0}.Name = Apple_list{0}.list1{0}.code.value=1_list{0}.Name = Banana_list{0}.list1{0}.code.value=2How do I search using a list searcher so that I want only the results for code.value=2?

1640

7 years ago

rob14

asked in Transformers

Split Lines Only where attribute value is Different

Hi,I am using FME Desktop 2015.1.0.2.I am trying to split lines where they intersect each other. So far so easy.Now clouds to the silver lining. However, two classes of lines exist, which flagged as SOURCE or TARGET within an attribute. I want to ONLY apply the split where SOURCE and TARGET interact and NOT where SOURCE and SOURCE or TARGET and TARGET interact; sort of an inverse group by. I was trying to complete this within the transformer processing as opposed to mass processing, creating a mess and creating, tests anf ilters to clean out and repair mCan anybody suggest if there is a way via which I can do this via some clever logic or attribute manipulation?In some transformers you can set 'attribute/s which must differ', but looking at Intersector/TopoBuilder there is no option to do this. Also please note that there are Measures associtated with the line geometries and I want to retain these split/updated values during and after the processing, therefore I had been attemp

100

7 years ago

matkins

asked in Transformers

Geometry distortion ESRI vs. .tab

The issue I am seeing is geometry/spatial distortion between two different formats, .shp and .tab when converting from a spatial oracle table.I am currently using FME 2015.The spatial metadata for oracle has set bounds and the same spatial extent was set for min/max x/y for the .tab writer. Below, the distortion is quite evident.Red: .tab with no spatial bounds Green: .tab with same spatial bounds as oracle spatial metadata Blue: ShapefileI have tried to restrict the spatial extent to a smaller area in the .tab format but the distortion is still evident (see below). The distortion improved but it is not consistent.Black: .tab output with original spatial extent, same as oracle spatial metadata. Blue: .tab with spatial extent changed to another smaller area. Green: Shapefile output with original spatial extent, same as oracle spatial metadata Red: .tab with spatial extent changed to the smallest area possible.Is there a way to minimise or if possible, remove the distortion?

7 years ago

gavin_082

asked in Transformers

Filtering Top Result

I am sure this is a really simple action, but I don't seem to be able to sort it out. I'm needing to filter off the top result out of a sorter in an attempt to make my workbench generic. I've run the data through a sorter, and the details I need are showing in line #1. Cheers for any assistance provided.

750

7 years ago

kumarc

asked in Transformers

FME Can deal with registry data ? ex : HKEY_CURRENT_USER key and values data

Useing FME desktop Can i read and write "HKEY_CURRENT_USER" data ?I need Created the key at run time and set the value according i will read the parameter values.

7 years ago

Page 369 / 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.