Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 12,582 Posts
  • 50,403 Replies
12582 Posts
B
batesy
asked in Transformers
insert into identity column option in SQL Server spatial writer

G'day guys,  Just wondered if anyone could explain how the "insert into identity column" option in the format parameters of the SQL Server spatial writer works, please.  I want the writer to create a table with an Identity column called "Row_No" and populate it as the features flow into it, so I created an Identity column called "Row_No" in the writer, then set the "insert into identity column" option to 'yes' but get the following error : "Cannot insert the value NULL into column 'row_no'" and nothing gets written to the table.  If I set the set the "insert into identity column" option to 'no' then it populates the "Row_No" field as I'd hoped but the log shows : "identity' of attribute `row_no' of feature type `test' is not supported for writing.  Attribute will be ignored by writer"  It's as if the yes and no option do the opposite of what I think they'r

3
sigtill
Contributor
11 years ago
fmelizard
Contributor
fmelizardContributor
asked in Transformers
Welcome to the FME Community

Welcome everyone to the new FME Community.    The FME Community is the place to ask your burning questions on anything related to FME. Customers, partners, product specialists and Safe employees are waiting to share their best practice insight and lessons learned.    I know we already have a great community and out hope that this site will help it to contine to grow.    Thanks!      Note: This community will replace the FME Talk Google Group. The Google Group will eventually be turned read-only but the existing content will remain indefinitely.

1
sigtill
Contributor
11 years ago
fmelizard
Contributor
fmelizardContributor
asked in Transformers
AttributeExploder

AttributeExploder seems to output attributes in a different order to those in the input.  Is there a way I can either prevent them being reordered or somehow tag and re-sort to the original order later?

1
sigtill
Contributor
11 years ago
B
brian
asked in Transformers
How can I compress a mosaicked raster?

I am using the RasterMosaicker to combine over 40 ecw aerial photo plates but the resulting ecw file is ginormous... I didn't notice a "RasterCompressor" (or similar) transformer... is there any way to compress the written file? Thanks, Brian

2
sigtill
Contributor
11 years ago
C
charlotte_t
asked in Transformers
Move points onto close lines.

Hello,  I'm having  point features, which are placed near lines and I need to move them onto the lines.  I used the neighborFinder so I know a distance between the points and the lines, but I can not find how to displace the points so they touch the lines.  Thank you for your advices!

3
C
11 years ago
G
gg
asked in Transformers
3D Data validation by using FME

Hi All,  We are in the process of procurment of FME software for validating 3D data, (validating tools for finding errors like gaps, flipped surfaces, box-in-box, in correct geometry etc.,).Could you please suggest which edition of FME will fulfill our requirements.

2
sigtill
Contributor
11 years ago
G
gjg
asked in Transformers
setting up the sdo_geometry

i have a string with coordinate pairs forming a polygon. the missing parameters are created using sql. I was wondering if there is an easier method setting up a default polygon in the desired geographical area. just the sdo_ordinates vary for each inserted line in the table.

1
davideagle
Contributor
11 years ago
S
steve
asked in Transformers
Extract select characters from string

We have a workbench with close to 50 transformers that do a .dgn to GIS ETL.  The ETL creates building room polygons in GIS with a unique id for each room.  Part of the workbench extracts text(the unique id) from a dgn level.  Some of the text on this level is preceeded by a room type (stairs_202M).  My question is, which transformer should I use to select a subset of text like this.  So for the example above, I would search for text that contains "stairs" and then which transformer would I use to just extract the "202M" and leave out the "stairs_".  A tranformer that would either replace "stairs_" with a blank or would omit the first 7 characters (stairs_)?  Thank you

8
takashi
Contributor
11 years ago
B
boyen
asked in Transformers
AreaOnAreaOverlay not working as expected

Hello,  I'm trying to calculate the amount of overlays of features in a geodatabase. Im using the AreaOnAreaOverlay transformer for this. However, what comes out of the transformer is quite strange. The amount of input features is 13, yet, the _overlays attribute gives values upto 24. Additionally, it fills in gaps (holes) that aren't part of the shape but are surrounded by the shape.   In the attached file I provided the workspace and files I'm working with.  ftp://ftp.safe.com/incoming/FME_AOA_error.zip  I would really appreciate the assistance, I don't quite understand how this is happening.

7
B
11 years ago
maremare
Contributor
maremareContributor
asked in Transformers
Gedatabase Version

Please help, How can I create a Geodatabase in Workbench, if I have the computer installed ArcGIS 10 and Fme12, considering that in the Help says that I  need to have ArcGIS 9 version.?  Another question, how can I save Workbench that I did in Version FME 2012 at downgrade FME2010 example? Is this possible?

2
maremare
Contributor
11 years ago
B
bruce
asked in Transformers
Attribute Filter

Something silly, I know, but has me stumped ...  I have a dataset with fishing activities, which I want to filter according to the FishingType, and Species caught  I'm going to run two sequential Attribute Filters e.g. FishingType = 1 and Species = scallops  I import the possible attribute values for each of the attributes, I have 10 FishingTypes and 20 species ....  But I'm getting no attributes being filtered on the FishingType - they all go through the UnFiltered port  Species works no problem ....  Can you filter by a "decimal" Attribute Type or does it have to be a character$   ?  Thanks,  Bruce

6
B
11 years ago
J
jharpster
asked in Transformers
XMLTemplater

Hi All,  I'm trying to use the XMLTemplater to create an XML doc from database table. I'm trying to generate the template using an XSD that I know is valid.  Workbench keeps choking on specific elements I suspect because there is an 'xsd:import' pointing to a remote document. Does anyone have any experiene with this?  Thanks!

5
fmelizard
Contributor
11 years ago
reservoirdog
Contributor
reservoirdogContributor
asked in Transformers
transfer AutoCAD mtext-rotation to SQLite

Hello community!  I tried several times to get mtexts of a dwg into sqlite without success. the mtext-entities are represented as points in sqlite, transferring text-string and text-rotation as attributes of these points. text-string as well as other stuff (height etc.) can be exported without any problems, but with rotations i never had any success. i tried "autocad_text_rotation" as well as "autocad_rotation" as well as "fme_rotation" but always gives a "0" as result in sqlite. datatype of rotations in dwg is always "number, 31,15". I tried using "decimal, 31,15" for the sqlite, but it says in the log, fme can only create "decimal, 29,15" datatype in sqlite.  What's the problem? Why can't i use the dwg-mtext-rotation? thx for any help, best regards from switzerland.

1
davideagle
Contributor
11 years ago
M
mfantin
asked in Transformers
Schema Mapper bug?

Dear all,  I'm wondering if I have misunderstood the SchemaMapper transformer of if it has a bug.  I'm using it to map any attribute names in a list to another name. However, the Schema Mapper creates every single attribute in this mapping list.... Which I don't want. I just want a mapping.  The FME Desktop version I use is 2012 SP4 Build 12266 for WIN32 and the Action I selected in the transformer is 'Map Attributes'.  The following seems to indicate that it is not supposed to create new attributes:  " when FME finds an attribute whose name is defined in the SourceAttribute column of my CSV file, then it renames it to the name in the corresponding DestinationAttribute column. In this example. if FME finds an attribute called “class” then it gets renamed to “Klasse”" (http://evangelism.safe.com/fmeevangelist41/)  Thanks in advance,  Maryse

4
M
11 years ago
M
marco_soave
asked in Transformers
Obtain Lod2 building starting from lod1

Hello all, I'm doing some enrichment on the cityGml automatically generated model of my city for a european proj called I-scope. At this moment I have only buildings geometries and i'm trying to texturize the model. I encountered some problems, expecially for Lod1 Building: I found the way to distinguish between flat and vertical features after a deaggregator and to rewrite the model as composed only of Lod2 buidings with separated surfaces. What I want to do now is to recognize the roofsurfaces(flat) from the ground surfaces. I tried a lot of possible transfomer but not encountered yet the way to compare the surfaces in an appropiate way. I need a way to find the max Z value between features with the same parentID an to split the output in ground and roof surfaces.                 Sorry for my bad english and thanks in advance, Marco  

2
M
11 years ago
T
tjapsen
asked in Transformers
Identifying long, narrow polygons with FME

I'm not an FME wiz so I tought I'd ask you guys:  I have extracted a number of holes in a layer of agriculture fields to find barrows (round features) that are located in the fields. But the layer also includes irrication canals. Is there any way that I can identify these long, narrow features so that I can delete them? They have more or less the same area as the barrows.    Do you have any tips?

5
takashi
Contributor
11 years ago
A
amit
asked in Transformers
Plotting points along linestrings at variable intervals

Hi,  I'm trying to replicate a function in ArcGIS (Make Route Event Layer) in FME.  I have a series of polylines in a shape file, each with a unique identifying code, (e.g. DH, CL, etc.).  I have a spreadsheet with a list of features I want to show as points along the line strings as defined by a meterage value from the start of the line,   e.g. Identifier (DH) & Meterage (15) - I want the dot to the plotted (with the relevant attributes) 15m along the line from the start of the line DH.  I can see transformers that plot points and split lines but only at specific intervals, not at attribute specified intervals.  Thanks.  Amit  

4
A
11 years ago
K
katy
asked in Transformers
Intersector

Hello,  I need a transform that dish points to where a line intersects a polygon. I have entered Résaux road and a municipality. J'besoin the intersection. What trasformer can do this please? (FME 2010 FGDB and / or. SHP as the format.)

5
C
11 years ago
A
alfauske
asked in Transformers
Published parameters - prompt user during runtime

Hi!  Is there a way to use published parameters to prompt a user for input values during runtime?  In the workspace I have some attribute values from the reader (GDB) that has to be changed manually. I want to use a tester, where features going through the Failed port will be displayed for the user, be able to change them and then continue to run the workspace.  There are probably other ways around this, but my experience with FME is limited.   Any suggestions on how this could be done?

4
sigtill
Contributor
11 years ago
spalatla
Contributor
spalatlaContributor
asked in Transformers
Viewing the 3D data loaded to Oracle spatial | schema of 3DCityDB-2.0.6

Hi All,   We have a problem in getting to view the 3D data loaded to Oracle spatial (data is of buildings) loaded with the schema (3DCityDB-2.0.6 | 3D-Geo-Database for CityGML). Can someone suggest how and which parameters to be used in universal viewer. 

2
spalatla
Contributor
11 years ago
H
hektopascal
asked in Transformers
Please allow me to read questions in cronological order

Hi,   Reading the original question, then the last answer, then the second-to-last answer really makes my head spin.   Optimally, the sort order should be an individual preference (first-to-last, last-to-first, highest rank). My preferences can be tied to my profile, my browser or both.    

2
N
11 years ago
L
lisam
asked in Transformers
Grid conversion between British and Irish Grid?

Hi there,  I've recently purchased some data from the Irish Ordnance Survey (.dtm format) which is supplied on the Irish Grid. I would like to convert this data to British Grid for use with other data I already have.  When I purchased this Irish data I was recommended FME software, which I must admit I'd never heard of before, but working regularly with mapping and terrain data it's something I'm really interested in.  I downloaded the trial version to have a look at the software's capabilities, but can't seem to figure out a way to do convert this data? Any help or advice would be much appreciated, I am at a loss!   I've tried to contact FME for both technical support and a personalised demonstration, but to no avail as yet.

4
fmelizard
Contributor
11 years ago
H
hektopascal
asked in Transformers
fme 2013 beta and attributeValueMapper

I've had great succes in FME  2012 using attributeValueMapper. In 2013 beta I find it completely bogus - whatever I do the values are mapped from null to null, including the  "default value" field.   Opening a workspace created with 2012  and inspecting it I see that my mapping are replaced with null to null relations.   This probably means I'll have to revert back to 2012, just as I was starting to appreciating some of the new shiny things of the 2013 beta... :(   Or is it some new functionality / logic / whatever that I get wrong?

1
fmelizard
Contributor
11 years ago
T
travis
asked in Transformers
SQL Connection Problem

I have an automated nightly process that runs and outputs several tables to SQL Server 2008.  This week we have had intermitten issues with connecting to SQL server.  One night it failed and the next it worke and then again it failed.  It is giving me an warning message of:    MS SQL Server: Connection not properly cleaned up, please contact support@safe.com. Connection key '1_|_3_|_TABLENAME_|_DATABASENAME_|_<unused>_|  I am looking for any insight of what might be causing this.  Is it an FME issue or a SQL DB issue.  I am running FME 2012 SP2 Build 12235 WIN32.  Thanks Travis

1
sigtill
Contributor
11 years ago
sigtill
Contributor
sigtillContributor
asked in Transformers
"Star" or Save a discussion

It would be nice to be able to "Star" or "Save" discussions (like Gmail). So you can have a list of all "Starred" Discussions for the future. In that way you can easily find the discussions you want to follow.

0
sigtill
Contributor
11 years ago

Badge winners

  • Conversationalist
    harishhas earned the badge Conversationalist
  • Welcome Back
    harishhas earned the badge Welcome Back
  • Integrate Spatial Data
    michael_v307has earned the badge Integrate Spatial Data
  • Integrate Spatial Data
    leanderhas earned the badge Integrate Spatial Data
  • Expert (Grey)
    damiobasahas earned the badge Expert (Grey)
Show all badges
29,851
Posts
Terms & ConditionsCookie settings