Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 12,752 Posts
  • 51,005 Replies
12752 Posts
N
neilhellas
asked in Transformers
What's the process to rename FME PlugIn Java SDK classes?

The documentation "FMEPlugInSDK_Java.pdf" refers to a script "rename_format_java.py" that presumably renames classes and files so you can build your own custom plugin.Where is this file? It does not appear to be installed (though similar corresponding scripts for C++ and Python plugins are present).

100
nathanatsafe
Safer
6 years ago
L
lc
asked in Transformers
JDBC connection string - password masking

Hi,When using JDBC connections, there is an option to enter in user/pass as parameters, but I am unsure how to format the connection string to leverage these parameters. So far, I can only connect if I embed my user/pass (as plain text) in the JDBC connection string. Any ideas?jdbc:scwapi:<server_name>;<powerhub_user>;<passwd>;<database_instance><database_name;<username>;<dbpasswd>

540
ravenkopelman
Safer
6 years ago
D
dylanlelievre
asked in Transformers
AEC Objects and Multiple View Blocks from Autocad

Hi, As new user of FME and because I haven't found any answer elsewhere on the Internet I created this topic.I would like to use MV blocks an AEC Objects from Autocad in FME respectively as Simple blocks and Polyline.With FME:-MVblock doesn't provide anything.-AEC Space provide a rectangle with the dimensions of the Space (draw as a polyline in Autocad). So the specificities of the polyline are lost.I can modify my DWG file to make it workable and this is what I am doing. But my question is : How to read correctly MVblocks and AEC Objects in FME ?Dylan. 

750
D
6 years ago
G
gsteinmon
asked in Transformers
is it possible to sort based on geography

I am building large datasets and am outputting to a geojson. Since I can't put in an index, I was wondering if it was possible to sort the feature order from east to west?

1870
C
6 years ago
P
philippe33
asked in Transformers
Add zeros in real numbers

Hi,I have the geometry of some points in GML format like this :<gml:pos>45.2690694444444 0.022336111111111</gml:pos> (Geometry obtained with geometryExtractor)In some cases, i have less than 6 decimals in the representation. For example :<gml:pos>44.8845083333333 2.4274</gml:pos>I search the way to add 2 zeros at the end of this number in such a way to obtain this :<gml:pos>44.8845083333333 2.427400</gml:pos>It's a validation ruleI used stringFormatter for simple attributes but in the cases of geometry written in GML format, i don't have an idea ...

778
lars_de_vries
6 years ago
nicholas
Contributor
nicholasContributor
asked in Transformers
Inline Querier EXCEPT vs NOT IN

I want to use Inline Querier to find all rows in table CSV that are not in table DCDB. Lot_plan is the common columnthis works (returns rows)SELECT Lot_plan FROM CSVEXCEPTSELECT Lot_plan FROM DCDBThis does not work (returns zero rows)SELECT * FROM CSVWHERE Lot_plan NOT IN (SELECT Lot_plan FROM DCDB)Why does the EXCEPT statement work and not the NOT IN statement?

140
takashi
Contributor
6 years ago
N
nindalf
asked in Transformers
How to snapping edges endpoints to node?

Starting point: I have a broken topology with nodes an edges as shown in the first picture below. The problem is that not all edges are graphically connected with the respective node.Attempt to solve: I used a "AnchoredSnapper" with the nodes as anchor and the edges as candidate. The "Snapping Tolerance" is depicted with the grey area in the pictures. The edges and the node which belongs together have a equal attribute what I use to group the elements.Problem: After the "AnchoredSnapper" the edges and the respective node are graphically connected as shown in the second picture (green lines). But unfortunately also the ends of the edges which have already a node and are within the "Snapping Tolerance" (red lines). Question: How can I avoid the wrong connections (red lines)? Adjusting the "Snapping Tolerance" is not an option because the not connected ends are not always in the same distance from the target node.

400
jdh
Contributor
6 years ago
G
garethgis
asked in Transformers
A faster/better way to calculate raster values that fall within polygons - ie Basic GIS but mixing raster and vector

@takashi I have a number of numeric raster datasets with the value of NDVI or vegetation type. I have a polygon dataset with various properties and property types (public, road, private, etc). First I tried the standard raster and vector tools in FME but found that compared to other programs I have used FME is very slow with images. So I got sidetracked into point clouds and FME was on steroids. Then I kinda ran out of tools and knowledge and also realised that the final output would have to include vectors not just the analysis so I will probably bite the bullet and revert to slow and traditional. I would like to continue to see what I could do with point cloud though. Fail points were 1. converting the point cloud into vectors - I did see some workflows of buffering the points, dissolving etc but ran out of time to play and wasn't sure how quick these would be. A brief play with HullReplacer just gave me a big square. 2. Analysing the point cloud against vectors (assuming I didn&

640
M
6 years ago
I
ieukcoca
asked in Transformers
How can I convert an attribute of type string (but all digits) to type integer?

I keep getting an error in my translation because one of the reader attributes is a string (utf-16) and I'm trying to read it into an integer attribute in the writer. But I can't seem to find a way to convert it. I'm sure I've accomplished this in the past but can't remember how and am not seeing anything in the docs about how to do this specifically.

6080
I
6 years ago
M
mjoarder_pln
asked in Transformers
Published Parameter- choice list must convert schema name in lower case and alwayes update automatically for ESRI Geodatabase(ArcSDE Geodb) reader

Dear everyone, I have an fme workbench which is maintaing a connection between my sql server enterprise gdb and having some paramaters, I am using it for data download. It is facing two problem, 1) fme is reading featureclass name as we see inside arcgis catalog (i.e, DBO.test) while in sql server we find it as dbo.TEST. We have also a automatic process to read metadata where the table name we read as dbo.TEST. But our fme workflow is reading it as DBO.test so our download button is not working. How can I change the schema name in lowercase? ANother this is , i was trying to use a choice list for automatically updating new featureclass or table name inside reader, but when I import it as fme_feature_type , it is importing nothing!

150
M
6 years ago
S
shankar
asked in Transformers
Is there a transformer in FME that can build sector polygons based on coordinates provided.

Is there a transformer in FME that can build sector polygons based on coordinates provided.     e.g. Source data has 10,000 point geometries. Output needs to be list of polygons with no more than 500 points within the polygon.

20
S
6 years ago
S
sgoodchildbrown
asked in Transformers
dwg to skp, keeping layers seperate

I am using the Arc Data Interoperability ext. FME 2016.0.1.2(20160224-build16177 - win32).Trying to maintain layers in the skp file, I reference @sander solution but am still having difficulty. When I say 'run' I get the translation parameters prompts below.This is my geometry property setter parameters, for the first layer. the others I tried to give numbers, but it makes no difference. And of course then doesn't run so I cant send you a log file. I have been using FME infrequently for years but definitely still at beginner level, clearly.Also battling with the help files for this issue.Below are two pics showing the difference I'm after. If I can maintain the layers (not all in 1 layer), it makes editing in skp easier. I need to simplify the buildings there, by taking cityGML LOD4 and making it +-LOD2.5.

10
S
6 years ago
B
bob123
asked in Transformers
FME 2018 bug annotation

When I create a tunnel from a long connection line than the first annatation is the same length as the connection line.

50
andreaatsafe
Safer
6 years ago
nath
Contributor
nathContributor
asked in Transformers
Adding writers tot bookmarks

Hi,it may be a stupid question, but if you add a writer/reader/inspector in fme2018 to a transformer that is in a bookmark, he always puts it out of the bookmark. My model is very large and has a lot of bookmarks that run into each other so that is not so convenient. Is there a way around it?ThxNathalie

120
andreaatsafe
Safer
6 years ago
B
bhagatanshul123
asked in Transformers
Multiple destination nodes as input for Stream Order Calculation tool.

I am working to calculate Stream order for Geobase National Hydro-logical network for Canada. I used this link for my task -->https://knowledge.safe.com/articles/1228/calculating-strahler-stream-order-numbers-streamor.htmlThis is really good FME model and stream order are just fine for the network having just one destination point. But I have few problems with this model, which I am trying to solve:1. If the Hydro network have more than one destination point. How can I input more nodes as destination points for each network in stream order calculation tool, so that it calculates stream order for that network based on all the destination points instead of just one destination point. Also, is this even possible with the existing stream order calculation tool?2. I have few destination points for few networks which do have a lowest elevation but those points are on mainland (maybe inside a ditch, pond etc) and not inside the ocean but the network actually ends inside the ocean but mayb

120
lars_de_vries
6 years ago
clang
Contributor
clangContributor
asked in Transformers
SQL Executor DateTime issue

Hi,I'm using the SQL Executor transformer to pull back the most recent records from a SQL server DB  since the ETL was last run.  The last run datetime will be held in in a Postgres table and pushed through as a parameter to the SQL Executor, the issue here arises when I push the datetime parameter through to the SQL Executor As a test and to trap the error I've used the attribute creator transformer to generate a datetime attribute which would mimic the last run datetime from Postgres, and hence push this through as a parameter. I've set the value = '2018-01-14 09:18:00'If I run SQL Executor with a set datetime ('2018-01-14 09:18:00') the SQL executor runs successfully  and returns records. However if I run the same query replacing the specified datetime value with the the parameter I get the following error message, despite the value and format being identical?--'. Provider error `(-2147217900) Incorrect syntax near '09'.'The error message points to an issue with the time element of 

420
clang
Contributor
6 years ago
D
dmasl
asked in Transformers
WorkspaceRunner with SQL Statement

Hi there,I'm trying to process an SQL statement for reading a ESRI filegeodb.I want to concatinate the statement in my first workbench and then give it to my second workbench via the WorkspaceRunner. - The first workbench aggregates distributors attributive with a seperator ",". So at the end there is for example a string '0781A21','0761A1'- My workbench2 should dissolves areas based on the distributors. My Reader where clause is actually: DISTRIBUTOR IN ('$(concat)') tried also DISTRIBUTOR IN ($(concat))$(concat) is the published parameter containing the statement. As an example the SQL statement I want to process in the reader of workbench2 should look like: DISTRIBUTOR IN ('0781A21','0761A1')How do I need to definine the statement in workbench1. The workbench2 is actually only processing the first distributor but not the second,third... translation log is --concat '0781A21' --'0761A1'Can find my mistake so I need

70
takashi
Contributor
6 years ago
B
bazooka
asked in Transformers
Decelerator with tweeter

I am trying to make 1 tweet per hour with Tweeter using Decelerator, but I get this error with every second tweet:2018-04-05 20:32:30| 16.8| 7.4|ERROR |HTTP/FTP transfer error: 'Timeout was reached' 2018-04-05 20:32:30| 16.8| 0.0|ERROR |Please ensure that your network connection is properly set up 2018-04-05 20:32:30| 16.8| 0.0|ERROR |No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered 2018-04-05 20:32:30| 16.8| 0.0|INFORM|Updating access token for 'sami Google Gmail'

180
redgeographics
Celebrity
6 years ago
wolters
Contributor
woltersContributor
asked in Transformers
RasterToPolygonCoercer does not extract raster values

Hi,I always use RasterToPolygonCoercer to convert Rasters to Polygons (which, by the way, takes much much longer than the ArcGIS counterpart). However, RasterToPolygonCoercer no longer exports the raster values, although it did before. The Label Attribute no longer shows up in subsequent transformers.Is this intentional or a bug? If intentional, how do you extract raster values into polygons?

420
nathanatsafe
Safer
6 years ago
adriano
adriano
asked in Transformers
pass an FME list dynamically to a sql executer transformer

I have created a very simple list using the list builder that contains multiple values of the same key (stationId). the list looks like this in fme inspector: I want to pass all the statonIds in this station list into the sql executer transformer into my WHERE statement.  The sql executer recognizes this list however, it only allows me to specify a specific element number in the list like this: where originstationId in (@Value(StationList{0}.stationId))The problem is I don't know how many values will be in the list each time so I can't hard code the list element number in it. I would like to pass all values in this list into my query.

1010
adriano
6 years ago
M
mikek
asked in Transformers
Arithmetic Editor - Math Operator (x?y:z) - Failed to evaluate expression

Why doesn't this work?@Value(SP)=FD?@Value(PCT):0 If the value of attribute SP is FD, then use the value of attribute PCT, otherwise 0. I tried using 'FD' and "FD" too.  2018-04-05 22:58:55|   8.1|  0.0|WARN  |AttributeManager_19: TCL Error Message: 2018-04-05 22:58:55|   8.1|  0.0|WARN  |     invalid bareword "FD"2018-04-05 22:58:55|   8.1|  0.0|WARN  |     in expression "FD=FD?10.0:0";2018-04-05 22:58:55|   8.1|  0.0|WARN  |     should be "$FD" or "{FD}" or "FD(...)" or ...2018-04-05 22:58:55|   8.1|  0.0|WARN  |AttributeManager_19: Failed to evaluate expression 'FD=FD?10.0:0'.  Result is set to null.

460
takashi
Contributor
6 years ago
S
samfarnsworth
asked in Transformers
RasterMosaicker - Parameters for better merging?

Hey guys!I'm having trouble with the RasterMosaicker not merging images very well. It's obvious to tell where the imagery is being mosaicked (please see attached image). Is there any way of getting rid of this? I was thinking (from previous remote sensing knowledge) that I could manually stretch the images to have them looking the same and then mosaic them, but I am unsure of how to complete this in FME. Help please!Sam

90
jdh
Contributor
6 years ago
3
3d_superstar
asked in Transformers
Export vertex pool with python

Hello,I am trying to export vertex coordinates from mesh to the attribute, but I am getting this error:TypeError: Failure to convert list values to native values.And here is the code:class FeatureProcessor(object):    def input(self, feature):        mesh = feature.getGeometry()        vp = mesh.getVertices()        feature.setAttribute('VertexPool', vp)        self.pyoutput(feature) 

53
3
6 years ago
I
inovacaogis
asked in Transformers
Doubts about Log in FME Desktop

Hi everyone,I would like to know because some logs in FME Desktop show me the message |Translation was SUCCESSFULBut there are logs that show the results but not the message Translation was SUCCESSFUL:2018-03-27 07:10:46|2344.9| 0.0|STATS |EstatisticaFluxo 11  2018-03-27 07:10:46|2344.9| 0.0|STATS |==============================================================================  2018-03-27 07:10:46|2344.9| 0.0|STATS |Total Features Written 11Both Log are workspaces that run properly.Thank´s

60
trentatsafe
Safer
6 years ago
L
lianaolianov
asked in Transformers
merging fatures which have the same attribute value

Hello,I have a network where this are many connected lines on nodes I wanna make from the ones having the same value of an attribute to get connected and became one feature. Is there any way to do it ? Thank you

350
dustin
Influencer
6 years ago

Badge winners

Show all badges
30,470
Posts
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.