- - Community Resources
Ideas
Product Updates
Events
Groups
Support
Knowledge

en
Start a post
Log In

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

10000+ Posts
53,413 Replies

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

10000+ Posts

asked in Transformers

How to expose KML tag with XQuery

I am trying to extract the KML tags for the KML below (structure) using the XQueryxtractor transformer declare default element namespace "http://www.w3.org/1999/xhtml"; for $x in /html/body/table/tr/tdreturn fme:set-attribute($x/td[1]/text(),$x/td[2]/text()) the result is coming out empty. Any suggestions ?kml_description (encoded: UTF-16LE): <html xmlns:fo="http://www.w3.org/1999/XSL/Format"> <body> <table border="0" width="370" cellpadding="0" cellspacing="0"> <tr bgcolor="ffffff"> <th width="370" align="left"></th> <th width="370" align="left"></th> </tr> <tr> <td bgcolor="#ffffff">Manhole ID</td> <td&g

1018

8 years ago

mrdanalvarez

asked in Transformers

Oracle Select Statement Causes Warnings and Other Readers to Fail

I'm using FME Workbench 2017.1.I have a reader connection with multiple features (tables) being read from it. One of the features (let's call it Users for example) uses a SELECT STATEMENT option to get additional information (I can run and test the select, it's valid and it works). Right before FME uses that select statement to "obtain features for feature type", I'll get a bunch of warning messages in the log output like this:WARN | Oracle Reader: Column 'ID' specified on Feature Type but does not exist in table 'SCHEMA_NAME.USERS' and will be ignoredThis will happen for all columns of Users. I can verify that the columns exist in my source table.Even with these warnings, the records of Users will be read and written to their new destination. However, every other feature type that needs to be read/written after Users (say Logins, Favourites, Friends, whatever) will give me the same warning message for each of the

846

8 years ago

andygale

asked in Transformers

This is error message on the FME server.Microsoft SQL Server Spatial Reader: Connection failed. Connection string `Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=gis02;Initial Catalog=nlpglive;Integrated Security=SSPI'. Provider error `(-2147467259) Cannot open database "nlpglive" requested by the login. The login failed.However, on the desktop I almost the same error when I try to list the tables in the above databaseServer 2012 Native Client...Microsoft SQL Server Non-Spatial Reader: Connection failed. Connection string `Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=gis02\\sqlexpress;User ID=;Password=********'. Provider error `(-2147217843) Invalid authorization specification'However, when I test the connection it is OK and successfulIf I use a reader or writer I can see all the tables !Any ideas? I have tried SQL Authentication for various local and domain accounts st

1713

8 years ago

tk97434

asked in Transformers

fme2018 - bug transformer statistics calculator

Since I installed the new version of fme (build 18284 WIN64), I can not get results anymore. missing value

215

8 years ago

arka

asked in Transformers

Matcher and match_id further selection

Hi all,I have used Matcher to find duplicates. It works very well. I create "_match_id" attribute to create "small groups".The problem is there, I need now to sort into these "small groups" using an other attribute called "Hierarchy" (numeric attribute). The feature with bigger Hierarchy's attribute value into this small group (based on _match_id value) will have a red color, the other will have a blue color.So, I have to compare each value into this small group, keep the highest value and assign to this feature red color.I have to do this for every small groups.Any ideas ?Thanks

573

8 years ago

dvanrielContributor

asked in Transformers

Select network lines that are within a certain distance along the network from multiple points

I have a network of sidewalk lines and multiple points of community centers. I want to select all those sidewalk lines that are within a certain distance along the network from all of the points. Select both entire lines and clip the lines at the specified distance.

1535

8 years ago

michaeljsee

asked in Transformers

Map Chainage (Stn from and to) from a Table on a Measure

Hey AllI have been googling this and trying to sort it out for a couple days now and cant seem to get it to work.I have a table with attributes for starting and ending Chainage (10+050 / 10+100). I want to map these as linear features on an alignment. The alignment is in as a measure and I'm trying to use the Snipper:Every feature is rejected by the Snipper. If I manually input the same attributes in the Snipper Starting and Ending Locations, it works fine for that one location.Also - it appears as though the Snipper keeps the attributes for the Measure, but not the ones from the input table, which would be needed.Any help would be great - is there a better way to map chainage/station for linear and point features along an alignment?Mike

1617

8 years ago

lazarlubomirContributor

asked in Transformers

Multiple condition in XML Templater

Hello,please, I try to compress more conditions into XML Templater in Root template, but unfortunately desktop refuses to run up translation repeatedly, because he misses comma between conditions. But, as You can see below, comma is there?Log is below:Does anybody know please, how to correct the statement?Thank You so much!Lubo

1252

8 years ago

adriano

asked in Transformers

how to write JSON Array of Objects to the MongoDB Writer when the number of Json objects in the array are not fixed

The MongoDB Writer for fme currently does not support writing to the MongoDB array data type. I am trying to develop a workflow in fme that can write to a JSON array data type in MongoDB when the number of objects in a json array are not fixed, for example (see "alternateNames array"):{ "geonameId" : 3, "name" : Toronto, "alternateNames" : [ { "alternateName" : "Toronto", "isoLanguage" : "af" }, { "alternateName" : "Toronto", "isoLanguage" : "fa" } ]} in another record from the source, this "alternateNames" array might be contain more objects:{ "geonameId" : 1859924, "name" : Kashiwa, "alternateNames" : [ { "alternateName" : "Kashiwa", "isoLanguage" : "eng"

4876

8 years ago

ivopaffrath

asked in Transformers

remove / delete unknow empty attributes(column), writing shape

I have various data source with various attributes. I want update all data's just like that no empty attibutes are writing. For example: Shapefile (name "blabla.shp) in directory should be read in, automatically remove all empty attributes (column) and writing a new shapefile (blabla_del.shp) in same directory.The Python Script in other posts not works. Example in zip.

1943

8 years ago

schatt15

asked in Transformers

Pivot table and aggregate based on a field

I am pivoting a table based on an ID field so that all diagnosis codes are pivoted and grouped based on the ID. Here is an example of source and final tables I am trying to acheive. What transformers will be appropriate to get this done?

1824

8 years ago

dms2Contributor

asked in Transformers

XQuery in XMLTemplater throwing error

This is the template expression I'm using in XMLTemplater based on what I've learned from other questions/answers on this forum (like this one):The problem is that it throws error 'invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?) near line 14, column 18 of the query' and I don't know why.It works if I omit the <gmd:desc> block though.What am I doing wrong?

561

8 years ago

reto_meier

asked in Transformers

Snipper with Paths

Hello thereI work with polylines in an ESRI Personal Geodatabase and want to shorten every polyline by distance using the Snipper. But for certain features there are more than one remnant. I guess, the reason is because features consist of Paths. Do I have to split Paths first and then use the Snipper for Lines and Arcs separately? Thank you for every hint.

735

8 years ago

kuirsetabc

asked in Transformers

Using Previously-Downloaded .xsd Files In Offline Processing?

We are trying to build a workbench which can work offline if it needs to, but can't find a way to supply it with the .xsd schema files at run-time.We already have the .xsd files (the data is from the Ordnance Survey, and they gave us the files) but haven't been able to find a good way to provide them to the workbench - It looks like the only way is to open the workbench file in a text editor and edit the XSD_DOC and SKIP_SCHEMA_LOCATION_IN_DATASET values.Is there a way to tell the workbench to (optionally) look in a specified location for the schema?

160

8 years ago

maliodpalube

asked in Transformers

Deleting repeated attributes

Hello,I am digitalizing an AutoCAD drawing and making polygons. Those polygons should have an area and I have succeeded in extracting these informations using AreaCalculator and LineCloser, AreaBuilder. After I extracted the area, I get some double cells. Some parcels have objects on them and I don't want to have their area in two cells. I am attaching a screenshot to show you all what is my problem. How can I keep only these rows that have both informations? There are some parcels where only one cell is filled because they don't have an object on them.I have tried with Matcher but it is not working with all the settings that I have tried.

967

8 years ago

gossyrossa

asked in Transformers

Generalize a polygon by a max number of vertex, max widht and max area forcer

I am interested in generalize a polygon following these criteria: max area (areaforcer), max number of vertex and max width allowed (for example a river with maximum width of 3 m and 200 vertex). How could I create this?

912

8 years ago

Anonymous

asked in Transformers

Dashboard Data for Unused Workspaces

The Dashboard data is great for seeing patterns over a period of 30 days but if the period were extended it could provide other information too. For example, "how long has it been since a certain workspace has been used?" That would identify FME scripts that are no longer being used.It would be easy to build something that would store the daily data better than the current CSV files, for example, a SQLite database, and then build reports off of it. However, I'm wonder if Safe has something like this in the works already?

767

8 years ago

mathieu_ambrosyContributor

asked in Transformers

I would like to center a text in an output PDF

Hi,I created a red colored box with PDFStyler and PDFPageFormatter.Now I would like to center a text in front of this box.Any idea ? How FME computes text position ?

1966

8 years ago

joostsiebenContributor

asked in Transformers

Find lowest Z-values in a area

Hi,I am doing a analyse to find most low z-values in a buffer of 50 meter from a point. I started with this steps:- buffer points, - Clip raster file on buffer area's- Use RasterCellCoercer to extract point value's only in this buffered area for efficiency- PointonAreaoverlayer, use buffers and points to merge attributes.But now I get stuck, these buffers have an overlap with each other. So some points only get the ID from one bufferid, not from both buffers with an intersect.(Arcgis 'Intersect' does it the way I like to see with all points tested on all intersecting buffers) Goal: I want to find the 10 lowest Z-values in each area(buffers from a point with main ID) Who can help me to achieve this goal?Thanks a lot!

636

8 years ago

felixderglueckl

asked in Transformers

Solid on solid overlay

Found no transformer or question on the Knowledge center so here is my simple question: Is there a possibility to realize something like a SolidOnSolidOverlayer that does an intersection of incoming solids and just outputs the intersecting parts of the solids? Just tried to do that with the CSGBuilder but I think this transformer just outputs the solid features which are completely within another solid.Also visualized my expected result in 2D (the red solid is the intersected solid I wanto to get):

961

8 years ago

dcam

asked in Transformers

FTTPCaller Inconsistent Timestamp

I'm using the FTTPCaller to get a list of files from a sftp site. The attribute that gets returned has an inconsistent timestamp. Is there a way to return the full timestamp like Mar 09 2018 17:35:00 In the _file_contents attribute there is a list of files but the time stamps are not consistent eg. Mar 02 17:36 that has time but no year and Jan 26 2018 which has year but not time.-rwxr-xrwx 1 ftpadmin ftpadmin 74240 Mar 02 17:36 9192815.dgn -rwxr-xrwx 1 ftpadmin ftpadmin 65024 Mar 02 17:35 9192816.dgn -rwxr-xrwx 1 ftpadmin ftpadmin 294400 Jan 26 2018 9192817.dgn -rwxr-xrwx 1 ftpadmin ftpadmin 311296 Jan 15 2018 9192818.dgn -rwxr-xrwx 1 ftpadmin ftpadmin 359936 Dec 18 2017 9192819.dgn -rwxr-xrwx 1 ftpadmin ftpadmin 54272 Sep 18 2017 9192820.dgnThe parameters in the caller

406

8 years ago

gladwinh

asked in Transformers

Creating a point featureclass

I have 5 polygon featureclass and 1 point featureclass. I would like to create a point featureclass that contains certain attributes from each of the polygon featureclass. How would I go about doing this.Thank you in advance.

873

8 years ago

fmelizardSafer

asked in Transformers

Where would I look for the FME named connections file on Debian or Ubuntu?

I have database and web service connections set up in FME Options - where are these connections stored on a Debian or Ubuntu system?

311

8 years ago

tiejim

asked in Transformers

Data Viewer Filter Features not displaying results.

Hello,I am new to FME but not to GIS. I am following the basic tutorials. When I use the filter features in the Data Viewer the results are not showing. I believe I have followed all steps per instruction. I am using FME 2018 desktop with Windows-7 on VMware Fusion.Jim

332

8 years ago

frsisani

asked in Transformers

Dangle line

Hy GuysI need to identify and remove dangle geo of a netw To be clear I need to remove all blue geo in the bmp attached.I tried some workaround with coordinates but no successFrancesco

2748

8 years ago

Page 368 / 400

Badge Winners

prathyushay8has earned the badge Online Training
ahmed_emamhas earned the badge Online Training
crunchyd_12has earned the badge English Speaker
elbazhas earned the badge FME Form Advanced Training
aliciadhas earned the badge English Speaker

Show all badges

Community Stats

32,488: Posts
123,403: Replies
40,673: Members

Terms & Conditions Cookie settings Accessibility statement

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 Trust Center Privacy

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.