Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,711 Replies
10000 Posts
N
nzg00ner57
asked in Transformers
add suburb attribute to roadname point using suburbs polygons shp

I have a point file with road names but no suburb and I have a suburbs polygon shp how do I populate a suburb field in the roadnames shp from the suburbs shp ?

90
arnovananrooij
Contributor
jugoslaviaa
Enthusiast
jugoslaviaaEnthusiast
asked in Transformers
Finding time in attribute with StringSeacher

Hi all, I have a set attributes and some of them consist of day time.And I would like to catch those that have such information. Examples:- BUS LANE 6-9A EXC SAT-SUN-HOL - MON-FRI 8A-8P SAT - SHUTTLE BUS ONLY 6A-8P MON-FRCan I catch those with StringSearcher? How should be the reqular experission for that? Thanks in advance. Best, Nilüfer

51
david_r
Celebrity
T
tobiasb
asked in Transformers
Using xfmap to create multiple values for one attribute

I am currently mapping a MVDxml and I am not able to create multiple values for an attribute.This is what I want to map:<ConceptRoot uuid="e4b5239f-16dd-4813-a632-71911712a26d" name="IfcWall" status="proposal" applicableRootEntity="IfcWall"> <Applicability uuid="00000000-0000-0000-0000-000000000000" status="sample"> <Template ref="ad664563-049e-45d1-8379-1553f9172d33" /> <TemplateRules operator="and" /> </Applicability> <Concept uuid="6082a8f9-f04c-44c6-a4ce-61bf4a12dbbb" name="Property Sets for Objects" status="sample" override="false"><Template ref="f74255a6-0c0e-4f31-84ad-24981db62461" /><TemplateRules operator="and"><TemplateRule Parameters="PsetName[Value]='Pset_WallCommon'" /><TemplateRule Parameters="PsetName[Value]='Pset_ConcreteElementGeneral'" /&g

520
friesewoudloper
Participant
E
edhere
asked in Transformers
ReplaceRegEx failing in AttributeManager

Hi all,I'm trying to clean latlongs using RegEx in the AttributeManager but I'm getting below error. AttributeManager_2: Expected signature @ReplaceRegEx(UTF8,UTF8,UTF8,[BOOL]) but received ReplaceRegEx("latitude" content="52.132932,("latitude" content=)+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `AttributeManager_OUTPUT'Attribute(encoded: UTF-8): `LAT' has value `"latitude" content="52.132932'Attribute(string) : `fme_feature_type' has value `Creator'Attribute(string) : `fme_geometry' has value `fme_undefined'Attribute(string) : `fme_type' has value `fme_no_geom'Coordinate System: `'Geometry Type: IFMENull===========================================================================AttributeManager_2 (AttrSetFactory): An error occurred while evaluating the above expression. If the failed expression is arithmetic, check to ensure there is

622
E
tomw202
Participant
tomw202Participant
asked in Transformers
XML values within tags to attributes

Hi,I have some XML formatted in the below way:<?xml version="1.0" encoding="UTF-16"?><apple colour="red" shape="round">  <attribute type="price" value="1"></attribute>  <attribute type="source" value="supermarket"></attribute>  <attribute type="bought" value="01/01/2019"></attribute></apple><apple colour="green" shape="round">  <attribute type="price" value="0.75"></attribute>  <attribute type="source" value="market"></attribute>  <attribute type="bought" value="02/01/2019"></attribute></apple>I need to get this into a flattened format, with one row per apple in this case, e.g: colourshapepricesourceboughtredround1supermarket01/01/2019greenround0.75market02/01/2019 I've played around with the xml flattener and xfMaps, but can't quite get my head around how to access the data when the values are contained within the tags themselves.Any help would be appreciated!

130
tomw202
Participant
M
martinsutalo
asked in Transformers
How to convert circle to hexagon or octagon?

Hi guys,  As question says, I have a set of circles which I have to convert to either hexagon or octagon. Tried googling resault and didn't find any help.   Any ideas?

360
M
nicholas
Contributor
nicholasContributor
asked in Transformers
RasterBandNoDataSetter Arithmetic editor?

I have an (ecw) image with areas of black that I want to turn null.These pixels have values of 0,1,2,3,4,5How can I set the Parameter of NoData Value to a range of values from 0 to 5?

80
takashi
Celebrity
sunsilk11
Contributor
sunsilk11Contributor
asked in Transformers
FME Server Publishing Error

Hi I am using FME 2018.1 desktop and server and trying to publish a workspace.Today, this comes up with User is not AuthorisedThe specified user credentials were not authorized to perform this action. Ensure with your server administrator that your user credentials are authorized to perform this action. I can login with same credentials to FME Server web user interface. Also I have been able to publish to FME server before today. I am using the admin credentials to publish (which has fmeadmin, fmesuperuser access)Any suggestion what could have changed and how to investigate this issue?

850
J
jugoslaviaa
Enthusiast
jugoslaviaaEnthusiast
asked in Transformers
Cleaning the lines after intersection

Hello everyone,I have center line data and I have created two offseted lines by using OffsetCurveGenerator. How can i cleaned the lines after the intersection of the two lines? By using Topologoy Builder, I have splitted them so those are individual lines. But I could not find way to delete them.Blue lines represents the lines that I would like to remove.

2210
jugoslaviaa
Enthusiast
oliver.morris
Contributor
oliver.morrisContributor
asked in Transformers
systemcaller hide cmd

Hi, is it possible to hide the systemcaller cmd line when using it inside a workspace being run from workspace runner. At the moment my screen looks like this and it is a touch annoying!Thank you   

380
oliver.morris
Contributor
markcoopersdc
Contributor
markcoopersdcContributor
asked in Transformers
Select all records from on table where an attritbute is contained in a field in a second table

I have two tables, one which hold records of planning cases that need to be monitored (Table A) and another which is the master list of all planning cases (Table B). In Table B, there is a string field called 'Proposal' which contains a description that may include the reference number of one of the cases in Table A (there may in fact be many records that relate to a case in the Table A).I would like select all of the records in Table B that contain the case reference from Table A in the Proposal field. I don't think I can use the feature merger as the information in Table B is contained within a Proposal field and is not in a field itself. I thought about trying to extract the case number from the Proposal field but, whilst it is normally at the end of the string, this is not always the case. It is also not a standard length.Can anyone think of a different transformer I could use to achieve this?

540
erik_jan
Contributor
E
edhere
asked in Transformers
How to extract URLs from HTML and create features?

Hi FME ninjas,I'm using the HTTPCaller to call a website containing multiple URLs in its HTML. I'm trying to extract all the URLs that have below format, based on these I'd like to create and attribute (URL) that shows all unique urls as features. What I have: What I want:  Does this make any sense ;-) ?  Thanks,Eduard

33010
takashi
Celebrity
rclarkenz
Contributor
rclarkenzContributor
asked in Transformers
How to maintain contrast of original raster after mosaicing

I created a workbench which reads an ECW (which I call current imagery). I then read GeoTIFFs (which I call new imagery), mosaic the rasters together and then write to a new ECW, which becomes the new current imagery ECW.I've noticed contrast changes in locations which are not being overwritten each time I've added new imagery and recreated the ECW.What could be happening here?The below image is a location which hasn't been overwritten by new imagery. I've run the new workbench 4 times now and you can see its getting darker each time.  More notes: I have done some further analysis.By using the PointOnRasterValueExtractor I was able to get the RGB band values at a location before the mosaic and after the mosaic.Before the mosaic: 82,92,82 After the mosaic: 93,100,94I also used the RasterBandMinMaxExtractor.Before the mosaic the min max was R: 0,251 - G 0,253 - B 0,251 After the mosaic the min max became R: 0,254 - G 0,253 - B 0,254 I expected the min max to change, I jus

80
rclarkenz
Contributor
matself
Contributor
matselfContributor
asked in Transformers
A swedish grid RIK reader for FME

Many years ago, the swedish National Land Survey issued topographical maps on CD-rom, using a self invented raster format known as RIK. Lately, these maps have been published as Open data. But this resurrected format is not known to FME.There is open source code to read this format, and it is supported in GDAL. Thus, it can be read and displayed in Qgis but not (as far as I have found) read with FME. What would it take to create a custom reader in FME using information in the links below? Apparently, the 'custom reader' ability in FME desktop needs a supported format to begin with.https://sourceforge.net/projects/trikpanel/https://github.com/OSGeo/gdal/tree/ab9e80368ef662712c963191fd86fde2c5b75600/gdal/frmts/rik

90
M
nicholas
Contributor
nicholasContributor
asked in Transformers
How to construct lines from one dataset of points and one dataset of pairs

I have two tables.One is a dataset of points, each point has a unique IDThe other is a (attribute only) dataset of pairs, each record refers to two points, via their unique IDHow do I construct a feature dataset of lines? Each line consisting of two points. To re-phrase, how do I add line geometry to the dataset of pairs, using the appropriate points from the point dataset, based on the unique ID of the from and to points?

420
M
A
andre
asked in Transformers
Create arc from 2 points and a radius

Hi FME Community,I'm trying to create an arc from two Points and a radius:The radius can be concave or convex depending on the radius sign (negative or positive)Anyone got any ideas how that can be done using FME?Thanks in advance

1064
A
E
edhere
asked in Transformers
Multiple RegEx conditional values possible within AttributeManager?

Hello,  I'm trying to replace my overdose of RegEx StringReplacers with a single AttributeManager that should contains multiple RegEx functions.  I've set up a short test:The first part of the test works fine: change: "world" to "WORLD" The second part doesn't seem to execute: change the "99" to "100"I'm now wondering: Can the AttributeManager conditional value hold multiple RegEx functions or just one? Thanks, Ed   

596
takashi
Celebrity
jt
Contributor
jtContributor
asked in Transformers
Why is my Local\\Temp\\FMETable folder so big?

Since upgrading to FME 2018, I've noticed my available hard drive space has decreased considerably. Poking around in my Local/Temp folder, I see there is a folder called FMETable that contains over 35GB of files.Diving deeper, there are gigantic files in there related to the FeatureJoiner:So my question: Is this supposed to be happening? Do I need to manually clean this stuff up on regular intervals?

2430
debbiatsafe
Safer
oliver.morris
Contributor
oliver.morrisContributor
asked in Transformers
fme pdf reader fatal error

I am trying to read in some pdfs, unfortunately when the pdf reader fails to open the pdf (if say it is corrupt) the workbench stops:2019-03-07 15:40:24| 391.6| 0.0|FATAL |PDF Reader: Failed to open document '\\xxxx.pdf' because the file is not in PDF format, or because it is corruptedI have set the workbench to ignore failed readers and continue transaction is setup under the Rejected feature handling. Is there any way I can keep it running?Thank youOliver  

400
oliver.morris
Contributor
oliver.morris
Contributor
oliver.morrisContributor
asked in Transformers
PDF reader characters

Hi, I am reading text from a pdf using the PDF reader and in the text I see xEF, xBF, xBE - what are these and how do I remove them.Thank you

240
oliver.morris
Contributor
pat_uow
Contributor
pat_uowContributor
asked in Transformers
download multiple zip files from url

Hi all,I'm trying to download all zip files from the URL below, keep a copy of the zip in one local folder, and a copy of the extracted csv in another local folder. http://www.nemweb.com.au/REPORTS/CURRENT/Daily_Reports/Using the workspace attached , I can successfully download and extract a single zip file and csv content.I believe there may be a list of all zip files available from the URL hidden somewhere in the response, but how would I go about extracting all available zip files and storing the resulting csv ?Thanks

4352
arnovananrooij
Contributor
helmoet
helmoet
asked in Transformers
FME and Hexagon VUE (SmartPlant) files

Hi, I am a true knownothing on this, so here it goes: are there any people that have experience with processing in FME of file resulting from Hexagon's 3D SmartPlant application? Any answer would be greatly appreciated.

810
helmoet
R
ronaldmcoker
asked in Transformers
Making Lines From Points With Specific Fields In Each Feature

I'm having trouble locating a clear answer because of some of the upgrades to the tools that have occured in the 2017 version. PointConnector was superceded by LineBuilder, which works well when I have multiple features with the same value in one field, but sequential values in another field.What I can't figure out is how to create lines from points by specifying certain fields to connect. For example, I have around 30,000 point features in two different point layers (60k total), which need to be connected based on shared values in a shared field.I know I can combine these as Suppliers in the FeatureMerger, join them with a requester, and build lines from points, but the tool seems ambiguous on exactly how this works. In other words, I don't know how the tool knows how I want to build lines.The concept of what I need to do is as follows:VertexCreator A --> Points A (created from A field) --> VertexCreator B --> Points B (created from B field) --> ---> Connect

960
R
tsirkuse
Contributor
tsirkuseContributor
asked in Transformers
Use date user published parameters in SQLCreator

Hello,I am reading my oracle non spatial database with an SQL query containing couple of dates. When inputting the dates directly in the query, there is no problem and it runs smoothly.I would like to make user parameters from these dates. So I have created published user parameters choosing 'date' as type.I then try to use the parameter in my SQL query (where clause) but I get a type error over and over. I have tried couple of different notations but it doesn't seem to work... This works (without parameters)  AUTO_START_DATE <= TO_DATE('15/12/2019', 'DD/MM/YYYY')Then I tried several variation to use :  $(START_DATE)but I can't seem to find the right syntax. Thank you

564
erik_jan
Contributor
gegevensbeheer
gegevensbeheer
asked in Transformers
Setting up a shapefile for different DWG layers with each a different feature table

Hi!Newbie here so i'll start by introducing. I work at a government organisation in which we use a management system and have a need for FME. I wish to learn to use it myself, to help our department and I think a lot of my 'work' can be done by FME.  My question:I have a DWG of a road in which all the objects have their own layer. So all the asphalt have the same layer, grass has same layer, and so on and so on. But for the management system we need different information for the asphalt in comparison to, for example, grass. So we need shapefiles of both with different information. Is it possible that I take the DWG file and let FME translate the layers to shape, and give the different objects their needed feature table. So a asphalt DWG polygon turns into a asphalt shape with a feature table that includes thickness and year, and the grass line turns in to a shape with feature table type of grass and year. And they both will be in the same DWG. My apologies if it is not all

40
itay
Supporter

Badge Winners

Show all badges

Community Stats

31,801
Posts
120,810
Replies
39,422
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.