Skip to main content
  • EN

FME Form

A space to discuss FME Form

27505 Posts
vki
Contributor
vkiContributor
asked in Data
Problem opening reader for Intergraph GeoMedia Access Warehouse

Hi  We have a GeoMedia Access Warehouse with about 170 tables in it. When we try to add a reader to this warehouse, we got an error-message:  GeoMedia Reader: Reading from GeoMedia Access Warehouse version 5 or better Database error: '[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.' SQL is: ' SELECT "csguid","basestoragetype","geodeticdatum","ellipsoid","projalgorithm","zone","falsex","falsey","latoforigin","lonoforigin","hemisphere","latoftruescale","scalereductfact","standpar1","standpar2","stor2compmatrix1","stor2compmatrix6","stor2compmatrix13","stor2compmatrix14","stor2compmatrix15","azimuthangle" FROM "GCoordSystem"' Successfully closed GeoMedia Access Warehouse reader   Adding readers to Warehouses with less tables

71
fmelizard
Contributor
11 years ago
M
mferwerda
asked in Data
FME Server 2012 sp4 upgrade to ArcGIS 10.1 - does not see ESRI libraries

We have upgraded out FME server 2012 sp4 to arcgis 10.1.  For some reason it seems not to be able to see the ESRI Libraries now.  We installed full ArcGIS 10.1.  What can we check to see why it is not finding the libraries ?

83
M
11 years ago
fmelizard
Contributor
fmelizardContributor
asked in Authoring
FME Licensing for parallel processing

Hi Folks, With FME 2012, Safe threw in more restrictive licensing for node-locked (fixed) licenses. No matter how many cores a computer has, the number of instances of FME running is limited by the type of license.  My question is twofold: a) Are the limits different between "group by" parallel processing and workbenchRunner parallel processing.  b) What are the limits for each of these? They don't seem to be documented anywhere.  The most I can find is group-by limits http://evangelism.safe.com/fmeevangelist94/ - and it says they're provisional at that time.  Our Oracle Edition seems to be limited to 8 FME workbenchRunners, which is a shame because we have 16 cores purchased explicitly for FME.  Thanks. Jonathan

95
fmelizard
Contributor
11 years ago
P
paopen
asked in Transformers
SchemaMapper problem: multiple features mapping (coming from the same .gdb reader) using the same schema, in the same fme project

Hi all,  I've got a problem with schemamapper.  It works perfectly if I use one feature from the reader (.gdb file) to one (or more) features to a writer (a different .gdb file).  Instead, It doesn't work (passes only one feature class from the reader!) if I use the same schemamapper using multiple reader's features.  These are my questions:  1) What's wrong?I tried both an excel file and an access table for my schemamapper...they both include fields "new filter" (field1, value1... from reader) and "new attribute" (field2, value2).  2) Do I really have to split all my "mapping" to different .xls (or .mdb, or .csv ) each one for each reader's feature class??  3) How can I set the same flow to UPDATE the writer?  Thanks in advance  Paolo 

102
P
11 years ago
B
blekros
asked in Data
SQL Creator and CURSOR_SHARING in Oracle 11g

I am creating features with SQLCreator on Oracle 11g.   I have some complex joins and filters ... and a LOT of them to issue.  So many that Oracle CPU performance goes to hell.   I'm told because it can't do all that hard parsing, because there are no "bind variables"  I am using FME Server 2012.   There are 16 engines, each submit 2 queries per job to get the features it needs to process.  At any given time there are 32 queries executing at once and by the end of an hour 250+ jobs will have to run.   That is over 500 queries needing a hard parse.  With CURSOR_SHARING set to EXACT, the CPU thrashes itself to death.  How can I get SQLCreator to use bind variables?   Or should I use a reader and parameterize all the SQL for the Reader?   Do readers force bind variables?  Brad

94
B
11 years ago
U
uccelli
asked in Data
Writer Spatialite Generic geometry

Guys,   I try to create a spatialite file with Dynamic porperties. The workbench works well but when I want to add this file in QGIS (connect a spatialite table database), I have the following error message :    "dbname='...sl3' table"..." (GEOMETRY) sql= is an invalide layer and cannot be loaded.   But, if I drag and drop the file in QGIS, it works correctly.     Does anyone kown why ? It's really annoying becose I'd like to keep the same Qgis project working with Postgis (same layout and layers, just the database changes).     It must be a problem with Generic geometry ou Specific geometry    Cheers   

70
U
11 years ago
M
mvw
asked in Authoring
where are my attributes? (AreaOnAreaOverlayer)

Hello, I'm an FME newbie.  I have a set of polygons which represent parks. As overlays I have layers of elements that exist within these parks, such as parking lots, ovals, playgrounds. The goal is to produce a new layer that covers that area covered by the parks, but that has many more polygons representing what's in the overlays.  I'm pretty sure AreaOnAreaOverlayer is the transformer for the job. But when I select the static schema option, the attributes aren’t being written to the new layer. Not even the _overlaps attribute is being written. And when I ask it to make a List by entering a string in the List Name field, I don't know where this list of attributes is going. Where am I supposed to find this list?!  TIA, MvW

133
M
11 years ago
farfar
Contributor
farfarContributor
asked in Transformers
TestFilter

Hi, I've a feature that contains 100 regions and i'd like to get shp file writer for each region. I use TestFilter transformer to do it but i must set TestCondition 100 times (If @Value(regionId)=1 else if If @Value(regionId)=2 else if ....). Is there other solution ? Thanks an advance. Farfar

233
farfar
Contributor
11 years ago
R
rhodri
asked in Transformers
"Cartographic Rendering Tricks"

Quite some time ago I asked about styling vector map local/ district with FME, since then it's been put aside cause we've had numerous other things to get done.    However I'm back at it, and I found the video done by Dotted Eyes "Cartographic Rendering Tricks with VectorMap Local"    On the AreaSymbolizer custom transformer, he (presumably) draws symbols using the information contained in the (in the example) 10k style, but it's very much a "and then magic happens" explination.    I know what i want to do, and roughly how do to it; Read the xml in -> create the symbol -> pass the symbol to the SymbolFiller custom transformer    However, I have no idea how to make FME do that. Any pointers would be greatly apprechiated    Thanks in advance    Rhodri

72
redgeographics
Celebrity
11 years ago
H
habsstan
asked in Transformers
GeometryValidator

In FME 2013, there is a 'REPAIRED' port on the GeometryValidator transformer.  In FME 2012 there is not.  Has anyone built a 2012 workspace that attempts to repair FAILED port features?  Can you share advice/guidance?  Thanks

162
david_r
Influencer
11 years ago
A
azeisinger
asked in Transformers
Measuring the distance from a point to a line

Hello,  I have a dataset (many datasets) that have a single line (of arbitrary orientation) and a large number of points.  I wish to add the perpindicular distance to the line as an attribute to each of the points.  This seems like a simple GIS question with an easy answer ... but I can't find it.  The closest I have come is the NeighborFinder, but if I use the points as bases, and the line as a candidate, it appears to measure the distance to an endpoint of the line, not the closest point.  The NeighborFinder works properly if I use the line as the base and the points as candidates, but then it only finds one point and the attribute is added to the line, and I need it the other way around.  Is there a simple way to do this, or do I need to do the geometric math myself and just calculate the distance with an arbitrary formula?

2563
takashi
Contributor
11 years ago
farfar
Contributor
farfarContributor
asked in Transformers
Scan folder before starting workbench traitment

Hi, I use schedules to launch my workbench every x minute. my workbench starts by reading shp files into my folder. I have a problem if there are no file in folder, the job starts and i get errors with no files. I look for a solution to test if my folder contains files and continuous traitment of workbench.  I try with python script but i can't. Any help? Thanks

66
farfar
Contributor
11 years ago
mhab
Contributor
mhabContributor
asked in Data
Mapinfo Text creation with specialized Font

Hello  I need to use a spezialized Font in order to create text characters which represent symbols with predefined symbolization.  All this because Mapinfo's Font-points are not scaled usefully while zooming, so I will try to use Text instead. I have a specially defined Font and I know the number of each character in the font-table.  My problem now is, that I need to create an attribute with a char-value which I cannot type in through the keyboard, as I only know the number of the font character.  How can I create an attribute with a one character-value whose font-char number (e.g. 45) is in the attribute "symbol_number" ?  I guess Tcl or Python may do the trick, but how ?  Thanks Michael

33
mhab
Contributor
11 years ago
F
flatlander
asked in Transformers
empty geometry field

Hi all,  This is the issue: I have an Oracle spatial (point) table where at least one record has an empty geometry field. The field isn't null, it's completely empty. This record caused my initial workbench to crash with an spatial index creation error.  I identified the offending table and started analyzing the table starting with a workbench containg only the table (using an Oracle spatial reader) and an inspector. That one gave this error:  An error occurred converting an Oracle OCINumber object to an integer: `OCI-22060: argument [2] is an invalid or uninitialized number'. (serverType=`ORACLE8i', serverName=`pkgnnat', userName=`KGNAT_HAVL', password=`***', dbname=`') Error converting Oracle Spatial object geometry type to an integer: message was `An error occurred converting an Oracle OCINumber object to an integer: `OCI-22060: argument [2] is an invalid or uninitialized number'. (serverType=`ORACLE8i', serverName=`pkgnnat', userName=`

584
david_r
Influencer
11 years ago
R
raphael
asked in Data
Oracle spatial Index

Hello,  How can i choose my tablespace when i create my spatial index with FME 2013 ?  Thank you  Raphael

168
R
11 years ago
R
russ
asked in Transformers
Line Direction

We have a need to determine the direction in which a line is drawn.  This is importand because some of our line features are custom line styles that when drawn on a map signify certain attributes.  As an example the symbols for Cliffs, Rocks and Depression Contours indicate the low side (elevation) of the terrain.  Each of these features have certain rules pertaining to how they are to be drawn (west to east, clockwise etc).  Is there a transformer or FME attribute that can help us determine if the feature is drawn correctly?   Cheers,  Russell

2915
G
11 years ago
B
bino
asked in Data
Direction Change

Hi,  I need to change the direction of linear element any diection into clockwise direction.I used orientor transformer,it change the direction of shape only line,linestrings directions are not chaged. any other option is there to change the directon of linestrings. 

2684
G
11 years ago
C
chickenbranches
asked in Data
How to label Google Earth Polygons with kml

Hello, I am very new to programming and recently downloaded the trial version of this software because I saw this link:  http://fmepedia.safe.com/articles/How_To/How-Do-I-Label-Google-Earth-Polygons#heading_toc_j_0  I have no idea how to use this program, and I have quite a short deadline so any help on this matter would be helpful. I have several hundred polygons on Google Earth and they must all be labeled, preferably with a placemark. Can this software do that?  Many thanks in advance.

671
fmelizard
Contributor
11 years ago
V
vince
asked in Transformers
TCLEmailer

I was watching a demo and noticed what I think is a transformer named TCLEmailer that appears to enable you to send emails from FME Desktop. I am not able to find it in Desktop. Does anyone know anything about it?

111
david_r
Influencer
11 years ago
2
2003_yeti
asked in Data
Colour raster TIFF to Black and White raster TIFF

Hi....I am trying to figure out how to convert 4 band high resolution raster TIFFs to black and white raster TIFFs....I'm not have much luck searching around.....I'm using FME 2013 Pro.....any tips are greatly appreciated.....Scott

824
A
11 years ago
A
andrewaus
asked in Data
SDE30: SHP -> SDE Feature Dataset

Hello,  I'm trying to load a SHP file into an existing SDE Feature Dataset (MS SQL).  Using SDE30; however I cant see where you can specify a Feature Dataset? It will happily write to the Root.  I have found similar issues reported: https://groups.google.com/forum/#!topic/fmetalk/STzkdjCzJfo however I'm still stuck.  Any assistance would be greatly apprieciated.  FYI I'm not a big user of FME.  FME Desktop 2012 - MS SQL  Thanks

61
A
11 years ago
E
erin
asked in Data
Oracle Non Spatial Reader to CSV Writer

I'm relatively new to FME, so any help here would be greatly appreciated. I can link to a SQL server to pull specific information from a table. However, I don't have write-access to the server, so I want to save the results of my SQL query in a CSV file. I've tried just doing a Reader of Oracle Non Spatial to a Writer of CSV. It reads the data fine, but nothing actually gets copied into the CSV File; it is just an empty file. I'm obviously missing something here. Can anyone help? Much obliged!

83
E
11 years ago
A
Anonymous
asked in Transformers
Sleep in FME?

Can you pause execution (sleep) in FME? I am using the HTTPFetcher to send an address to Google to get back geocoded XML and extracting lat and lng. I find that some of the lat lngs are blank; however, when I examine those that are blank and send  the url directly to Google through the browser, I always get back the correct XML.  I'm thinking that because the HTTP fetch is inconsistent in the time it takes, something gets overwritten. I also did geocoding with Google using Python, and put in a sleep for two seconds. A sleep in FME might help.  By the way, I used the Gisgraphy geocode service in FME and found that it gave incorrect results. That's why I'm using Google.  Thanks

583
fmelizard
Contributor
11 years ago
vki
Contributor
vkiContributor
asked in Authoring
Passing parameters between workspaces

Hello  I created a workflow that transforms some data. As I have to do the same transformation for various oracle-users, I'm using the workflow-runner in a second workbench. But it's not only the name of the user, that I need to pass to the transformation-workflow, but also a second parameter (an attribute in a table). I read in a post, that I have to concatenate the two values an pass them as one parameter to the other workflow.  But how can I integrate that parameter in my workflow? There is a transformer "parameter-fetcher", but it needs input from a reader. I also have to split the parameter again (Attribute-splitter) and use one of the two parameters for my reader (oracle-user) and the other in my writer (attribute).  Thanks in advance Vera

1302
vki
Contributor
11 years ago
ebygomm
Contributor
ebygommContributor
asked in Transformers
FeatureMerger - not possible to use list element?

I'd like to use the FeatureMerger with the first element of a list as the Requestor Join Attribute. Unlike with most other transformers it doesn't appear to be possible to do this.  Expected behaviour or a bug (or user error?)

95
ebygomm
Contributor
11 years ago

Badge winners

  • Teacher (Grey)
    joelhas earned the badge Teacher (Grey)
  • Welcome Back
    joelhas earned the badge Welcome Back
  • Socializer (Talker)
    arcvancouverhas earned the badge Socializer (Talker)
  • FME Form Basic Training
    mitchellhas earned the badge FME Form Basic Training
  • FME Form Basic Training
    scorlisshas earned the badge FME Form Basic Training
Show all badges
30,061
Posts
Terms & ConditionsCookie settings