Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,712 Replies
10000 Posts
jaymiecroucher
Contributor
jaymiecroucherContributor
asked in Transformers
How to use a parameter to get a table from an SDE connection.

Our team are trying to create a workbench which will be used to answer user data requests. The workbench should provide a packaged export from our Oracle database, including a schema definition, metadata and various file type(s).  I'm trying to make this as simple as possible by using parameters for the user to input, including table name and spit out folder at the end however I'm stuck when trying to create a parameter for the table name we want to download using the Esri Geodatabase (ArcSDE Geodb) Reader.  I've actually managed to work around this for the metadata by setting a default table, using the merge feature type option and using a wildcard, then setting a parameter from that. However when I try this with features although I get the geometry I get an empty attribute table.  Anyone have any experience of this or potential better solutions?

2460
jaymiecroucher
Contributor
williams_s21
Contributor
williams_s21Contributor
asked in Transformers
User Parameter for use in Attribute Filter

Forgive me for what is likely a very simple answer to this question, but I'm still rather new to FME. I'm wanting to use a defined User Parameter (Type - Text) which will then inform my AttributeFilter transformer (where the user parameter directly corresponds to a specific field of the dataset being read by the AttributeFilter transformer). However, when I set the transformer parameters as per the screenshot below, I don't then get the expected output, i.e. the dataset filtered for that specific value. Is there something I'm missing? Thankyou for taking the time to read this post. 

3660
williams_s21
Contributor
joy
Enthusiast
joyEnthusiast
asked in Transformers
How retrieve one value of one column /row from table 1 and get that into table 2 in which all rows get that one value?

Hi everyone, I am trying to get the value of the first table (that only has one row with info about xmin, xmax, ymin etc.) into the 2nd table. The second table has more rows and my wish is to have all the rows in table to get the same value for e.g. xmin from the first table. However in the 2nd table only the first row gets the value of the first table, while I want to have all the rows the same value for that column. Does anyone how that might be achieved? In case my question is not clear, just let me know.

1380
joy
Enthusiast
A
a_castro
asked in Transformers
Can you read in files to FME that contain special/accented characters in their filenames?

Hi! I am trying to read into FME a series of images (jpeg/tif/png) and then match them to a different datasource and rename them using pieces of information from both sources. All works well. But. I have some files which contain special/accented characters which aren't being read in. For example the filename below  Anadolu Koyu PLAN_IZMIT KÖRFEZI TO ISTANBUL.jpg throws an error 'Anadolu Koyu PLAN_IZMIT KÖRFEZI TO ISTANBUL.jpg' cannot be located. Please ensure the file exists and is accessible' The common denominator in all of the errors is the special/accented characters. My question is whether I am missing something and I can get FME to read the filenames and bring them into the workspace, or whether I need to handle these (hundreds of) files manually? All helps much appreciated!

110
david_r
Celebrity
joy
Enthusiast
joyEnthusiast
asked in Transformers
How make a dwg (autocad) file during conversion smaller?

I am converting a dgn file with lightweight polylines to an autocad file. The input dgn file has a size of 70 MB and when I am converting to a dwg the size becomes roughly 97 MB. The dng consists thus of lightweight polylines and during conversion to autocad there is automatically a z component in the autocad file. Based on the following page FME Creates Large AutoCAD DXF Files (safe.com) I included an autocad_original_entity_type attribute in the attributemanager with the following value autocad_lwpolyline . The size becomes then 95 MB. I would like to make the dwg much smaller, how can I make the file much smaller than 95 mb by changing somethign in the autocad writer or doing some kind of transformation.

4690
danminneyatsaf
Safer
S
srinivas9my
asked in Transformers
Hi when I am connecting from Postgresql db to FME getting below error Fetching Feature types error failed to retrieve feature types Please ensure that the dataset is accessible and has feature types available to read

Log details :  FME Configuration: Using connection values from 'J10_170' for R_3Creating reader for format: PostgreSQLTrying to find a DYNAMIC plugin for reader named `POSTGRES'FME API version of module 'POSTGRES' matches current internal version (3.8 20180604)FME Configuration: Using connection values from 'J10_170' for R_3Creating reader for format: PostgreSQLTrying to find a DYNAMIC plugin for reader named `POSTGRES'FME API version of module 'POSTGRES' matches current internal version (3.8 20180604)Opening POSTGRES reader for dataset 'postgres'PostGIS client encoding: 'UTF8'PostgreSQL 9.5.25 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bitSuccessfully closed POSTGRES database readerSuccessfully closed POSTGRES database readerMerged 0 schema features read from 1 datasets into 0 resulting feature typesUniversalReader -- readSchema resulted in 0 schema features being returnedReader Parameter(

1080
JennaKAtSafe
Safer
J
jim
asked in Transformers
Creating Lines Perpendicular to Linear Features

I have a linear feature and need to create another linear feature perpendicular to the original feature and at a given distance along the original feature from the beginning point.  Any help as to how to accomplish this would be much appreciated.

5610
M
B
bradosav
asked in Transformers
How to get an attribute value as user parameter

I'd like to have the value of an attribute as a user parameter.I need to make sure tables I work with comply with a schema. The schema field names are in a CSV, imported without column headers. I aggregate the attribute which leaves me with this output:Is it possible to get the string in col0, row 1, as the default value in a user parameter to ensure my output table conforms to the schema? Thanks!

3340
B
joy
Enthusiast
joyEnthusiast
asked in Transformers
How to import models from a dgn file as separate features into FME desktop?

I have a dgn file that consist of many models ( it corresponds to a building and every floor has its own model) and I would like to import the models as seperate features in FME if that would be possible. When I try to import individual feature types in the dgn reader, instead of the models I get all the level names instead that are present in the models. So the feature types do not correspond to the model names, but to the level names. So for example I would like to get a seperate feature type of a model for floor 1 and of a model for floor 2. Does anyone know how that might be achieved in FMe desktop?  

1414
joy
Enthusiast
T
talha
asked in Transformers
Buildings created after tiles were transparent

After .obj files had converted to cesium 3d tiles, buildings created transparently. When I looked behind building, I saw another building. I dont want it. I want that these buildings are opaque. Is there any way for this?Thanks!

450
T
H
hakkeem85
asked in Transformers
How to compare two database schema (File GDB & SDE) including subtype & domains values.

How to compare two database schema (File GDB & SDE) including subtype & domains values.

3650
H
M
malavikavenu96
asked in Transformers
How to remove the intersection of a road in fme?

The input looks like this:The result must look like this:

280
M
V
virgil_robinson
asked in Transformers
SchemaScanner behaving differently inside custom transformer?

Hello,Can anyone explain the difference shown below? Inside a standard workflow, the SchemaScanner captures the order of the attribute names correctly as they appear on the input file. However, when used inside of a custom transformer, the incoming attribute names are sorted alphanumerically. Does anyone have any ideas why this is happening? 

230
V
alc33
Contributor
alc33Contributor
asked in Transformers
convert attributes to a jpeg file

Hi!I would like to export my datas (only attributes) on a jpeg file.I would like to create a sort of table like on excel, with blacks border and dimentionnate the columns in order to not truncate the datas. And then export an jpeg file.I used ExcelStyler and an JPEG writer, but it failed because it's not an raster format. So I tried with ImageRasterizer but I don't succeed. I'm not use to manipulate raster format. So could you give me advices to suceed?Thanks !

1620
alc33
Contributor
ssmith_ftr
Contributor
ssmith_ftrContributor
asked in Transformers
Comparing distance between two Points inside a FME Aggregate.

I had two features that both had FME Geometry of single point that I merged together with FeatureJoiner. The result of join I have single feature with FME Aggregate, with both points inside that. My question is that I want to get the distance (preferred in feet) between the two points that are now inside a FME Aggregate.  I figure the easiest way to do this is with Python caller. I tried looking at the forum question below calling Python. However, I couldn't determine how to use it to get both my FME Points out of FME Aggregate. https://community.safe.com/s/question/0D54Q00008z6yR3SAI/distance-calculation-per-pipe-segment If there are other suggestions, please let me know.  I'm attaching a sample FFS file with the data points. Can open and see the features each have FME aggregate with two FME points inside that.

2710
ssmith_ftr
Contributor
afod
Contributor
afodContributor
asked in Transformers
Shortest path finder returning different routes for same from-to locations

I am currently creating a network by running nodes to a central point, using a 2d Grid as my network. I am noticing that points that should follow a similar route, sometimes take a slightly different path see below. I'm wondering if there is anything i'm missing to try and avoid this?  

1400
afod
Contributor
L
lachichi_farah
asked in Transformers
How to know if an "overlap" include another same field ?

For example, I have two features with different code in their field "code".These two areas overlap when I use the transformer "AreaOnAreaOverlayer"and I have a field named "overlap" where it writes "2".  But now, I would like a field to know if these overlap include the same code of no. In this example, the features (area) haven't the same code. Thank you!

200
redgeographics
Celebrity
birgit
Influencer
birgitInfluencer
asked in Transformers
Using the TempPathnameCreator output in a PythonCaller to write files

Hey everyone, I am trying to write a file to a temporary filepath in my PythonCaller script and I thought that using the TempPathnameCreator transformer might save me some time coding something which is a basic function in FME. Unfortunately if I try to write the file to the location I get a python error that says that the location does not exist. I have used the OS python package to test if the temporary path is valid and it is not. Am I using the TempPathnameCreator incorrectly and is it logical that my PythonCaller is unable to write to the temporary location?

523
david_r
Celebrity
markcoopersdc
Contributor
markcoopersdcContributor
asked in Transformers
Post multiple XML Get requests to SOAP in one session

Hi I need to post requests to SOAP to retrieve some information about Planning cases back in XML and I have read the article: https://community.safe.com/s/article/working-with-soap-services Our process is more complicated as I need to log in and out of SOAP at the start/end of the process.  I created steps in a TestCase in SOAPUI and it worked and I have set up a workbench with the following transformers: CreatorXML Templater (for login)HPPTCaller (for login - cookies enabled)XML Templater (to Get data)HTTPCaller (to Get data)XML Templater (to logoff)HTTPCaller (to logoff) While this worked for retrieving one planning case I actually need to retrieve information on multiple cases but cannot get this to work. I tried two things: 1) I created a spreadsheet with multiple planning case references in, read this into FME (replacing the Creator) and changed the value in XMLTemplater to use the attribute value (using fme:get-attribute), instead of a hardcoded value.This appeared to be attempti

2570
markcoopersdc
Contributor
sudhakary
Contributor
sudhakaryContributor
asked in Transformers
Querying multiple fields in a single table

Hi Community,Based on the Figure 1 table, two fields exist as mentioned and I want to find the results as mentioned in Figure 2I tried so many transformers and had no luck.Figure 1Figure 2Please help me with how to get the results.

50
sudhakary
Contributor
limo
Supporter
limoSupporter
asked in Transformers
How to set Appearance to CityGML trees

I created trees in citygml based on point data. The tutorial is described here:https://hub.safe.com/publishers/con-terra/templates/citygml-create-solitaryvegetationobject-with-implicit-representationWorkflow:Result: No I will set a color for this trees. Unfortunately it is not working with appearance setter. No appearance is set inside citygml file. In the description it is written: "tree models: can be any kind of 3D object (Sketchup, OBJ, DWG, ...) but currently does not work with geometry containing color appearances" So does anyone know if this is possible maybe? We need to color this trees Hope someone has ideas how to solve this kind of problem?

1770
limo
Supporter
joshuajames1979
Contributor
joshuajames1979Contributor
asked in Transformers
Hi there, I have an FME Workbench job that converts a Geometry to well known text but of late there are no results, and I think it may be peak memory usage exceeding FME's peek memory usage.

This process used to work fine but I realised lately since updating the database connection due to SQL server moving I see it does not update the table like it used to. It stops working at the GeometryExtractor but no errors.  I do getEND - ProcessID: 888, peak process memory usage: 226836 kB, current process memory usage: 93912 kB Can that cause the issue and what would be a way around this issue? Regards, Josh

130
DanAtSafe
Safer
agelfert
Contributor
agelfertContributor
asked in Transformers
How to get the SQL Executor to write a NULL when using parameterized statement with FME @Value(---) syntax

So I noticed that when using a parameterized INSERT statement in SQL Executor:INSERT INTO MYTABLE(FIELD1, FIELD2)VALUES ('@Value(FMEATTR1)','@Value(FMEATTR2)',)Any NULL becomes an empty string. How do I use logic like the above and still keep my NULLs? I've tried to wrap the entries in VALUES in case statements to catch NULLs and handle them differently - but to no avail. 

20210
M
viviancfhung
Contributor
viviancfhungContributor
asked in Transformers
GDB to SHP field length >254

We want to convert a GDB to SHP file with field type string and length>254. How can we keep the data with maximum size 254, but not ignore the dataThanks

720
M
charry
Supporter
charrySupporter
asked in Transformers
Cannot convert null string into an integer

BADNEWS: Cannot convert null string into an integer(C:\\code\\fme\\foundation\\framework\\util\\stf\\stfutil.cpp:346) class StatusInfo *__cdecl STF_stringToUInt(const class ObsoleteString &,unsigned int &)... Last 2 lines repeated 6 times ...​this error often display,when read excel 、shp 、 dwg file​

3920
charry
Supporter

Badge Winners

Show all badges

Community Stats

31,801
Posts
120,812
Replies
39,424
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.