- - 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

mjoarder_pln

asked in Transformers

How can I upload a zip file and two other parameter(need to input) (project_name) and email (direct URL) through data upload in FME Server?

230

7 years ago

mjoarder_pln

asked in Transformers

XML schema mapping in FME workbeanch?

Hello everybody, I dont have any experience in handling XML and convertion into new xml schema. We have xml file metadata in arcgis enterprise geodatabase, this metadata is in ESRI metadata standard format. I can open this metadata in FME ,that's fine, but we want to convert this metadata into our own schema. We developed one meta´data schema based on INSPIRE and Datacite. For this conversion i have our schema in xml format, i really dont have any idea now which Transformers should I use now for this conversion and which files I require. I am looking for help in this circumstances.Thanks

540

7 years ago

lazarlubomirContributor

asked in Transformers

Point extraction and line joining

Hello, please, I have one issue to solve. I have topology with junctions and nodes. In that topology there are two types of nodes - type A and type B. What I need is extraction of B nodes and then I want to join lines into one feature. Result is just one line feature between A nodes. For better imagination, I attach pics below.Does anybody tips how to figure out thi issue please?Thank You so much!Lubo

440

7 years ago

eldertt

asked in Transformers

CoordinateReplacer replaces too much

Hello, I discovered the CoordinateReplacer, a great strong transformer for many purposes.But now I have the following issue with it:I got 2 coördinates with different xy but equal z values. Of one of these coordinates I need to replace the values by a new value. CoordinateReplacer seems a great way to do that. However, it also replaces the z-value of the correct coordinate. I was hoping it would only replace the z-value if he'd found matching x- and y- values as well, but unfortunately it seems to work more like an OrdinateReplacer. Does anyone have any idea how to workaround this?

100

7 years ago

takashiContributor

asked in Transformers

Which is a correct category name, "Format Specific" or "Format Specifics"?

Hi, I noticed that a custom transformer belonging to the category "Format Specific" (singular) cannot be uploaded to FME Hub. I guess the reason is that Hub doesn't have that category. There is a category called "Format Specifics" (plural) instead.Is it intentional that the category names are different between Transformer Gallery and Hub?

7 years ago

pi_hellzParticipant

asked in Transformers

Compare multiple fields after a spatial filter

I'm looking to compare the difference between multiple columns that is resulting from a feature merger.example : IDTypeYearCityStreet_type_year_city_street121999QCDuke21999MTLDuke232001MTLKing12002MTLThomasI need to identify each difference and export them to a report. The problem I have is that another validation of the same benchmark might have too 8 columns to compared.Thanks for your help

130

7 years ago

marine

asked in Transformers

Geometry recovery from SQLCreator Postgis

Hi, When I precise some attributes into a PostGIS SQLCreator (including the geometry) in the SQL request “SELECT id, geom FROM test”, FME doesn’t recognize the geometry. Its is only seen as attribute, but not the geometry of the feature. It only finds the geometry with “SELECT * FROM test”. Do you know what can cause this error ?

142

7 years ago

sigtillContributor

asked in Transformers

FuzzyStringComparer - many versions - many issues

Just to let anyone using the FuzzyStringComparer some hands up with FME2017 - its a real struggle to get it working as it has changed a lot and there are many versions of it. If it does not work - try to right click on it - edit and copy all the transformers to the main workspace.

1011

7 years ago

vimapper

asked in Transformers

Process multiple files individually using FME Server

Hi, I have a bunch (16k) tiff files that I want to individually process through FME Server. I've gone through all the configuration options I can find, but regardless the files are processed as one file. I know I can make this work using a batch file, but curious to discover if the server GUI offers a faster route. Hopefully I'm missing something obvious. Cheers, Steve

1010

7 years ago

rrdlpl

asked in Transformers

How to publish a workspace to a FME Server through command line?

Hi,I have multiple workspace files and publishing them to our FME Server is demanding too much time. Is it possible to published them through the command line or python? If so, how?Thanks

270

7 years ago

rrdlpl

asked in Transformers

How can I cast a string to datetime for MS SQL?

Hi,In my workspace I'm inserting through a FeatureWriter into MS SQL Table and I'm trying to cast a string to a datetime, but it doesn't seem to work.This is the format that I'm reading: dd/mm/YYYY and I'm trying to parse the attribute column in FME as this:@DateTimeParse(@Value(DATE_OF_BIRTH),%d/%m/%Y)But I'm getting this error from the console:2017-07-26 15:25:28| 162.1| 0.0|WARN |Table1_StudentUpdate_FeatureWriter_f2afd4cb_4a56_4aec_8f42_9e384693c40417: Failed to evaluate expression '@DateTimeParse(03/13/2010,%d/%m/%Y)'. Result is set to null.

370

7 years ago

florena1

asked in Transformers

How to thin an PointCloud where the Points are lined up

Hey,another problem ocurret with the PointCloud file, in this case all Points are lined up in the orignal File like rectangles. If i do the "normal" thin setup i became only slope lines. I need mixed up points all over the area. Is it possible to do ist with FME. You can see the problem an the Setup on the screenshots.

7 years ago

rody

asked in Transformers

Replace values in textfile with values extracted from the filename for multiple files

Hello,I have several textfiles which have filenames such as this with varying numbers:2017061_XXX_6183378N_568614E_20170708_001.asvpInside the files is a header which is crucial that it is not altered as well as two columns of data:( SoundVelocity 1.0 0 201707081732 0.0 0.0 -1 0 0 KM_DEFAULT E 0205 )0.458 1475.5220.379 1475.5320.354 1475.5230.393 1475.525 I need to extract the 6183378 and 568614 from each file and its filename, these numbers varies for each file since they are Y and X coordinates. This task is simple and I have done that in another workflow which builds a list of files. However what I need for this workflow is that it replaces just the 0.0 0.0 in the header with the coordinate values from the filename, this needs to be done on multiple files without making any other changes on the file contents or its delimiters.I have tried several ways which includes bringing the textfile in as CSV and try to rename the attribute with a list value to no success. I have tried importi

490

7 years ago

holtstephenw

asked in Transformers

Using Spatial ETL Tool Combine Multiple GTFS into ArcSDE

I am trying to combine roughly 50 different GTFS feeds (a feed is composed of 13 CSV/txt files) into ArcSDE using the spatial ETL tool. I need to update the stop_id field in each of the csv text files to continue the stop_id sequence that of the agency table in the SDE. Basically i need to remove and match the Stop id from the incoming feed to the stop id sequence in the SDE. I am very new to spatial ETL i have only been using it one day so please bear with me if i am not making much sense as this is very new to me

7 years ago

velasquezvictor

asked in Transformers

Read Features from .zip or .tar.gz

Hi,My customers upload .zip or .tar.gz files to our server, I have a CSV reader, when I set the url (https://mydomain.com/customer1.zip) of a zip file with only 1 file, FME server works fine.Now, a customer send us .tar.gz files with several files in it, for this spacific workspace I need to grab only one file form the package, there is a way to specify which will be the file in the url to process? I tried with https://mydomain.com/customer2.tar.gz\\students.txt with no luck, I manually convert to a zip file https://mydomain.com/customer2.zip\\students.txt but nothing works.ThanksVictorV

535

7 years ago

jjaksic22

asked in Transformers

Duplicate filter not working correctly

Dear all,I have a workbench for some data (feature) filtering inside and outside of some polygons. I'm stuck at final step where I need to remove duplicate features which are inside of one polygon. The problem is with this specific polygon where Duplicate filter is sending one feature that for sure doesn't have duplicate through DUPLICATE port while it should be unique. I've tried different polygon and different features and it worked fine but for this specific feature it's not working right. I've tried the MATCHER also and got the same result, it sent feature to the matched port while it should be not_matched. I've checked for all the possible differencies in attributes between this problematic feature and any else feature and didn't find anything different. The features are autocad_text_strings. I didn't expose any attributes.I hope someone can suggest some other solution or what to check for this specific feature? I can send data if necessary. Thanks

890

7 years ago

jennniibee52

asked in Transformers

everywhere a road intersects with another road and i want it to give me a table with all the roads plus all the names of roads they intersect.

Im trying to figure out everywhere a road intersects with another road and i want it to give me a table with all the roads plus all the names of roads they intersect.I have major roads, and I want to know all the major and smaller roads that intersect each major road (this will be a non-spatial table)I want my end user to select one road, and it will return all roads that crossed this major road's path.

7 years ago

de8a88

asked in Transformers

How to join two tables and keep the duplicates (one to many relationship)

Hi,I'm trying to join two tables using the FeatureMerger and I have enabled the Process Duplicate Supplier since my Suplier table has got more than one entry for each of the Requestor entries I'm trying to match. However, I'd like it to keep all duplications from the Supplier table so that the total Merged includes duplicate rows from the Supplier. Is there a way to achieve this?Thanks!

130

7 years ago

jordan_miller

asked in Transformers

String Search/vLookup

Hi all, I have a question regarding string searching, which is slighlty related to a vlookup process. I have two datasets. One is a shapefile of a pipe network that has a concatenated output from civil design package. The field is named 'Partsizename' and contains values like "305 mm Concrete Pipe" or "151 NB UPVC PN". The other is an excel spreadsheet containing a field named 'Material', which lists 40 common pipe materials (e.g. "Concrete", "UPVC", "Copper"). I want to search Partsizename for the values listed in Material, and if any match, output the matching string into another field. E.g. For a row in Partsizename that contains "305 mm Concrete Pipe", 'Concrete' is one of the materials listed in 'Material', so the output will be 'Concrete'. Thanks in advance for any help!

10410

7 years ago

jaygis

asked in Transformers

issue with converting points to polygon

Hi There, I have a set of points that make up an area of interest. I am trying to create a polygon using the points, using Linebuilder & LineCloser. It does create the polygon but it's not what I was expecting. I am looking for some feedback on how to resolve this. Thanks Jay

640

7 years ago

cliff_wade

asked in Transformers

Testing dataset quality

Hello, I have a query please. The attached table is a snapshot (fictional names etc used) of an Excel dataset of 10000 records, where employees of a company are each given a Card to access the office building, and this dataset logs their details each time they have entered the building, by swiping their card at the entrance door, in the past week.In the ideal world, every employee should have a unique "Employee Number" and also a unique "Card Number." So in this example, John Smith should have an "Employee Number" of 100, and a "Card Number" of 1. However, we can see that he also has a "Card Number" of 2 on two occasions he has entered the building, for whatever reason.Also, we can see that for Sarah Brown, her "Card Number" should indeed be 5, but for some reason, she has two "Employee Numbers" (400 and 500) when in fact she should just have one "Employee Number" of 400.What is the best way, using FME, tha

140

7 years ago

abbas_lokat

asked in Transformers

Lines that exist outside a polygon

I have a file of 100+ polygons and need to find lines that exist outside of the polygon based on a join condition that links the line to the polygon.ie find me the lines in file x that exist outside of a polygon where line.shape not in/not entirely within polygon.shape and line.auth = polygon.authI'm a new FME user - I've experimented with both the spatial relator and the spatial filter. I don't know if I'm just using them incorrectly! any help appreciated!ThanksBaz

410

7 years ago

redgeographicsCelebrity

asked in Transformers

Combine ideas

These two ideas seem to be similar, can they be combined?https://knowledge.safe.com/idea/48591/save-feature-count.htmlhttps://knowledge.safe.com/idea/48474/save-number-of-records-that-went-through-each-port.html

100

7 years ago

harrygibson

asked in Transformers

RCaller timeout error

I'm using an RCaller within a workbench that's processing some reasonably large datasets. The R script I'm using works fine in R itself, and the workbench runs perfectly with a smaller test dataset. However with a full-size dataset I get the following error, approximately 30 seconds after the last feature enters the RCaller and the rscript.exe processes begin:RCaller(InlineQueryFactory): InlineQueryFactory encountered an error when starting R interpreter. Message was: Process operation timed outRunning with the same size dataset in RGui or RStudio, the processing I'm doing takes approximately 10 minutes. However the processing is by group and so I use the ddply package in parallel mode to split the processing across 10 cores, making the process take approximately 1 minute.I've transferred this over to the RCaller in FME, and it starts the 10 processes, but still times out after about 30 seconds. How can I use the RCaller to do work that takes more than 30 seconds to produce an output?

130

7 years ago

tim_woodContributor

asked in Transformers

SQLExecutor - how to update multiple SQL Server columns in one query?

FME 2017.0.1.1 (17291) 64-bit on Windows Server 2008 connecting to SQL Server 2012 on Windows Server 2012.MS SQL Server supports this type of update statement:update db.owner.mytableset field1 = ABC, field2 = XYZwhere primkey = 123I want to do the same thing with SQLExecutor thus:update db.owner.mytableset field1 = @Value(fieldA), field2 = @Value(fieldB)where primkey = @Value(uniqueid)However when I put this into the SQL Statement parameter, the cog on the transformer goes red i.e. something is wrong, but nothing is highlighted red in the transformer properties. Is this an FME bug, or do I need to write it differently?

10216

7 years ago

Page 383 / 508

Badge winners

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

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.