- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,683 Posts
50,748 Replies

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

12683 Posts

Recently active

Most replies Most views Newest first

gpt_geoinfoContributor

asked in Transformers

Trouble with Custom Transformer and published parameters

Hey Y'all,I'm having troubles with creating a custom transformer and its published parameters. The goal is to add a number (calculated with SQL and a chosen leading number) to different (existing) numbers. These numbers are stored in different attribute names, i.e. id, type. When I create a custom transformer with the 'id' and want to use it with the attribute 'type' it keeps calculating the 'id' OR if I edit the parameter I can't choose it from an attribute anymore. I'm stuck!A sample workspace is attached (FME 2021).Any ideas appreciated.Cheers,Maria

125

3 years ago

mahbouberezaiee

asked in Transformers

Optimization of processing time for a large dataset

Hi. I have prepared a workflow that is full of many tansformers. I've tested it for just 3 Buildings and that works perfect but when I run it for a large dataset, the processing takes too much time(3 or 4 hours). Can somebody helps me to know how to reduce this time?Thanks

3 years ago

neel_d

asked in Transformers

How to use a User parameter in the 'Feature Types to read' parameter of the Feature Reader

Hello,I have set-up a workflow that needs to be run several times using different set of input-data. The names of the input data are all the same except for a number at the end (for example: 'WSbekken_1', 'WSbekken_2' etc.). The input data is in shapefile, geodatabase and tiff format. I want to use a user parameter ("RHS_2") indicating the number of the input datasets to use and have different FeatureReaders reading the input data. I managed to get the shapefiles and tiffs read like so: but not the geodatabase because the user parameters do not seem to work in the 'Feature types to read' parameter field, which I need in the case of geodatabase. I tried the following but it is not working, in the log file I see it tries to read a file "WSbekken_" so it seems to completely ignore the "@Value($(RHS_2))". I figure I could split up my geodatabase so that I have one dataset per database and set the parameter to 'all feature types &#3

2423

3 years ago

walker_henry

asked in Transformers

How to transform JSON file from Esri Extract Changes API call back into features I can write to another hosted feature service.

I'm trying to build an archive off a feature service hosted in ArcGIS Online by getting the changes and writing them to a second hosted feature service. I can get the changes in JSON, but I'm struggling to turn them back into usable features. The format looks like this: "edits" : [ { "id" : 0, "features" : { "adds" : [ { "geometry" : { "x" : -119.58448584499996, "y" : 32.10688862600006 }, "attributes" : { "OBJECTID" : 93, "GlobalID" : "1DF7CAF6-D3CC-4E8D-8FB3-C6714C06890A", "IncidentName" : "Testing", "Label" : "DIV X", "Label2" : null, "LabelType" : "Division", "Other" : null, "CreateName" : "test_nifc", "CreateDate" : 1621322205148, "EditName" : "test_n

1013

3 years ago

yourusername

asked in Transformers

Create bounding box from Bounding Rectangle of a feature

I have this Oracle database that has a trigger that automatically creates a bounding box around any feature, in this case they are parking lots. The index database stores the northernmost and southernmost latitude as well as the corresponding eastern and wester most longitude of the minimum bounding rectangle. I'm trying to crate this bounding box using FME and I'm not seeing the best way to accomplish this. My thought process:Create 4 points for the four corners of each box and then create the areas for them.Create the top left and bottom right corners of each box and then have FME figure out the polygonFind a transformer that just knows what to do with these 4 fields and then get a cup of coffeeOf course the 3rd one is what I'd love to see but I'm not sure that exists. I'd rather not create a ton of points just to create a polygon but I might need to do this. Any thoughts?

4531

3 years ago

mikamattilaContributor

asked in Transformers

How to set up the Query String Parameters in HTTPCALLER with a URL that ends with /1729/1774.mvt where the two numbers are variables in a CSV file.

When using HTTPCALLER I cannot figure out how to use the Query String Parameters. The URL ends with /1729/1774.mvt these two number are in two columns in a CSV file (attached). The whole URL is the one below and if I use that as a Request URL it works (its password protected).https://maps-ver.lantmateriet.se/vt/fastighetsindelning/v1/wmts/1.0.0/fastighetsindelning/default/3006/10/1729/1774.mvt

1531

3 years ago

mauliem

asked in Transformers

please guide to convert the xml file to excel to get all the fields information

3 years ago

jatoxaContributor

asked in Transformers

Style Excel cell values

Hi, I know the ExcelStyler is in beta but here goes the question anyway. Is it possible to style individual cells based on the attribute value? I have tried different approaches that all color the entire row or entire colum as you see below. Result if I filter through a tester and chose to style attribute "c". Result if any of the attributes fail the tester, the entire row is colored. This is what I need, to style individual cells based on their value Thanks! /Jacob

22217

3 years ago

toedeledokie

asked in Transformers

How can I extract XML attributes used as containers for data?

Your input would be much appreciated. I don't know how to proceed and would like to avoid manipulating the source data manually to get it to do what I want. I've received data which is formatted in the following manner. I'm posting the first item and closing it off just as it ends in the file with </markers>:<markers> <marker name="Tilburg" straat="Vloeiveldweg 6a" postcode="5048 TD" plaats="Tilburg" site="" lat="51.600739" lng="5.064299" linkurl="tilburg" status="0" dot="red.png" ></markers> I used an XMLFragmenter and it's configured as:Elements to Match: markers/markerFlatten Options: EnabledFeature Information shows:How do I go about extracting marker.name etc. into their own attributes with values? I've tried various combinations in Elements as XML Fragments but no dice.

482

3 years ago

psmaaaron

asked in Transformers

I'm using the new FME 2021 WMTS reader with a basic authentication. I had to change the password for the user and now the reader down't work. Any ideas on why this is happening?

Listing the available layers works with the authentication and using a HTTP caller to the getcapabilites with the authentication works. It's just when the reader is running.It would be great if there was a way to capture the HTTP(S) request and responses.

3 years ago

lifalin2016Contributor

asked in Transformers

Parameters for custom transformer doesn't accept variables ?

Hi.I've now run into this issue several times now.If I create a custom transformer in my workspace, and create some parameters in it to be given values in the main part, some of those parameters doesn't accept variables, only text editor and workspace parameters.What is triggering this odd behaviour ?Attaching a screen dump from 2021.0

3 years ago

mathikuContributor

asked in Transformers

Create area from line input

I have a road network represented by a centerline (brown) and 2 edges (pink). I am looking to create an area from it.The network is rather complicated so linecloser->areauilder doesn't work. I then tried buffering the centerline, polygoncutter and spatialFilter, which doesn't really work for round-about and junctions. At the moment I am trying to create cross-sections (blue) at a given sample dsitance, using neighbourfinder, which seems to work very well. However, I can't figure out a way to create a hull-like area from the cross-sections. I am considering trying to write the vertices into a list and then to a polygon, but it feels overly complicated.Does anybody have any leads. I can provide sample data tomorrow.

3 years ago

canerakinContributor

asked in Transformers

3D Intersect between 3D line and Solid

I am trying to intersect 3D Polylines and Solid Cubes to determine which cubes are touching the polylines.So far I tried Clipper, intersector, SpatialRelator and SurfaceOnSurfaceOverlay. All the features are ending in the rejected port as invalid geometry.What is the right way to accomplish this task?

1717

3 years ago

michelle_onasse

asked in Transformers

I would like to transform a GeoJSON file into a line feature

Hello everyone, I'm currently trying to make a path from a GEOJSON "link" which was return from a HTTPCaller. Is there any way to transform the link below into a line feature? Thank you in advance. {"code":"Ok","waypoints":[{"hint":"xPMEgEswB4AKAAAAAAAAAFcAAAAAAAAAJ0k3QQAAAADB2cBCAAAAAAoAAAAAAAAAVwAAAAAAAADaAAAAC07F-1foygJzT8X7X-bKAggAnw0GXKGa","location":[-70.955509,46.852183],"name":"Rue du Moulin"},{"hint":"4nEJgIjqCYAMAAAABQAAAH0AAAAaAAAAUXXHQaFyEkF2A31DScJOQgwAAAAFAAAAfQAAABoAAADaAAAAAVjF-47pygK1V8X7u-nKAgUA3w0GXKGa","location":[-70.952959,46.852494],"name":"Route du Fleuve"}],"routes":[{"legs":[{"steps":[{"intersections":[{"out":0,"entry":[true],"location":[-70.955509,46.852183],"bearings":[37]}],"driving_side":"right","geometry":

211

3 years ago

spidermanContributor

asked in Transformers

How to merge multiple Tiff (Tagged image file format ) georefrenced to create one full image with correct coordinates

my example i have folder that contains lots of files that contain tiff extension and tfw extension .i would like to import all images to fme workbench and build one image with the correct cordinates then i could merge with polygon border coordinates ,to check which image suitable to which polygon bordereach image has different min and max extents as pic down,i would like to rearrange them together .How could i achieve it ?Thanks in advance

2752

3 years ago

maschlin

asked in Transformers

Replace feature z-value with point z-value

In the first step Im doing a PointOnAreaOverlay which connects the features with a point inside the features. The next step I want to replace the z-value of the feature with the z-value of the point. I have tried with both CoordinateReplacer and GeometryReplacer. So how to replace z-value of the feature with the z-value of the point?

835

3 years ago

theunderwood07

asked in Transformers

Rename image file name to match data in spreadsheet

I have hundreds of image files that require renaming. I have an Excel sheet with the oringinal file names in one column and in another colomn the prefered file name. I would like to replace the image file (.jpg) name with the new name the column in the spreadsheet. I found an article on how to do this, but I can't seem to get the script to work. I am new to FME. I have provided the workbench file and the spread sheet and a image file.Can some one please help guide me with where I am going wrong?

631

3 years ago

michaeld

asked in Transformers

Missing nodes from LineOnLineOverlayer

Hi all. I'm struggling to get the LineOnLineOverlayer transformer to work. I'm working with MI tab files. I want to create a node at the crossing locations of an linear infrastructure data set 'A' with three other liner datasets 'B', 'C' and 'D'. The results I'm looking for is nodes at the crossing of A and B, A and C, A and D. The problem I have is not all intersections are being generated. The attached image shows an example of this. On the eastern side the blue dot represents an intersection between A and B. However, further to the west I would expect to see another two intersections but nothing has been generated. The green polygon is one of may regions that is used to clip the poly line datasets to a manageable size before processing. The parent datasets are nationwide in geographic extent. What have I missed? Do I need to deaggregate lines somewhere? (I've tried a few locations) Thanks,Michael

3 years ago

badieeau

asked in Transformers

How to write on LandXML from DXF/DWG files

I have got a LandXML schema and I am wondering how can I export a LandXML file based on that from a DWG/DXF reader.Can you please give me some samples/tutorial or guide me how can I map the DXF data to LandXML file? Thank you & Regards,FB

2298

3 years ago

holyg

asked in Transformers

How to extract Populated Places from Openstreetmap

HiHopping this is the correct forumI'm trying to work out how to extract place names from OpenStreetMap(.osm) files from geofabrik.deFor testing I picked WalesUltimately I will push into PostgreSQL / PostGIS database hopefullywithout corrupting non English names In the attached Workbench I used AttributeExposer to show everything thiswas done using the cache My first question how do I make that dynamic?There will be some distinct attributes like name, osm_id, is_in, wikidata etc and some dynamic ones especially non English names My Second question is how do I group similar attributes together and merge into a JSON stringfor instance alt_name:en, alt_name:fr, alt_name:* grouped into alt_namejson this with then be held as a jsonb database type Similarly name: en, name:fr, name:* grouped into official_names json I couldn't see how to do this using AttributeFilter or Tester All other attributes not yet accounted for grouped into all_tags json string I've done something simila

291

3 years ago

spidermanContributor

asked in Transformers

how to avoid black fill color in dgn and change it to yellow background of a map in dgn output file

how to avoid black fill color in dgn file output , i would like to change the background of map to yellow instead of black by default in dgn file .what should i do in fme workbench to modify the background .i have used dgnstyler but it is useless in output ,i see only the changes in inspector in fme but no effects at output dgn filei am using dgn writer at the end of FME workbench FME 2018 Thanks in advance

523

3 years ago

ksm65

asked in Transformers

Hallo , In the excel table I have, there are street name, house number and post code information. Can I create point data of type Shapefile from this information. Or should it have a value of X and Y? Thanks...

3 years ago

larsec

asked in Transformers

Change Detection adds duplicates

Hi all,I have a workspace, where I am detecting the hange between my original data in an SDE and revised data coming from a public source. I'm using the fme_db_operation to push Inserts, Updates and Deletes to my SDE. However it apparantly just keeps adding the data as duplicates. I have 6 exactly same polygons for each feature, with the only difference being a Version ID... Any thoughts?

11212

3 years ago

michelle_onasse

asked in Transformers

I would like to modify a comment section in my table

Hi,I would like to modify a comment section in my table. The comment section is intended when there's a change between two roads. For example, when Road 6 is changing for Road 6-A, the comment section writes : Road 6 is becoming Road 6-A. Now, I got a lot of these examples but the comment section is almost blank (with some examples as above). I want to describe those Roads change when the comment section is blank. I got 4 000+ roads changes, so a formula would be appreciated. Thanks.

111

3 years ago

michelle_onasse

asked in Transformers

I would like to transform a GeoJSON link into a line feature

Hello everyone, I'm currently trying to make a path from a GEOJSON "link" which was return from a HTTPCaller. Is there any way to transform the link below into a line feature? Thank you in advance. This, below, is the GeoJSON file in question.https://docs.google.com/document/d/1-H6F53Z3Mpu9qmOLQwvifWVPuG7xgjtk4aekHyG1nUU/edit?usp=sharing

222

3 years ago

Page 158 / 508

Badge winners

havermhas earned the badge Teacher (Grey)
havermhas earned the badge Welcome Back
mcmavehas earned the badge Welcome Back
tunzhas earned the badge Student (Grey)
ali.hojjathas earned the badge Welcome Back

Show all badges

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