Skip to main content
  • EN

Unanswered questions

19954 Posts
I
iturbides
asked in Authoring
How can I View my stored data on Oracle with FME Universal Viewer 32 bits

Hello Im trying to View my stored data on Oracle with FME Universal Viewer 32 bits.   I have installed Oracle_Client 11g 32 bits on my PC.  Also I have Win 7 64 bits    When Im Trying to did it, it sent this message:  Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`orcl', userName=`itu', password=`***', dbname=`') Failed to open database with username='itu', retrying using uppercase username Environment variable ORACLE_HOME is not set.           

10
I
11 years ago
C
chrismugdan
asked in Transformers
Adding centroid fields

I want to compute a centroid for polygons then add the X and Y fields to my features.  I could not find any way of doing this in FME desktop as I have it. Can anyone suggest how I might do this please?

4
M
11 years ago
fmelizard
Contributor
fmelizardContributor
asked in Authoring
FME truncate fails

Is there a known issue concerning FME (in my case 2011SP4 and 2012SP3 aswell) about not being able to truncate Oracle base, stating: Truncating table `EESTITOPO.HYB_VOOLUVEED_75T_J'... Failed to truncate table `EESTITOPO.HYB_VOOLUVEED_75T_J'. Table may not exist  However, when truncate is defined in the "SQL To Execute Before Translation" under advanced writer properties, then truncate operation succeeds.   Thank you, Raivo Alla Estonian Land Board

4
S
11 years ago
fmelizard
Contributor
fmelizardContributor
asked in Transformers
FME 2013 DWG additions

Hi,  I was going throught the whats great in FME 2013 and came across this: "Added new template files to (FME_HOME)\\autocad directory, both of which have AutoCAD standard line type definitions loaded in them (PR#36706)"  Does it means that FME 2013 will have the ability to create line types other that continous? as is the case with FME 2012.  Also will I be a able to set the dwg line type from input attributes stating the desired line type?  That would be great!  Cheers,  Itay

4
fmelizard
Contributor
11 years ago
G
gisjunjun
asked in Authoring
Warning: not all FMESessions that were created were destroyed before shutdown. This may cause instability

??Windows?????????:               fme.exe wb-xlate-1353554731187_5952           --SourceDataset_MapGis6x """""C:\\Documents and Settings\\Administrator\\My Documents\\1.WT"" ""C:\\Documents and Settings\\Administrator\\My Documents\\1.WP"""""           --DestDataset_MapGis6x "C:\\Documents and Settings\\Administrator\\My Documents"           ???? ... Feature Manipulation Engine 2012 SP2 (20120417 - Build 12238 - WIN32) FME_HOME is 'C:\\Program Files\\FME\\' FME Desktop Professional Edition (floating) Permanent License. Machine host name is: fangjun START - ProcessID: 904, peak process memory usage: 26024 kB, current process memory usage: 26020 kB FME Configuration: Command line arguments are `C:\\Program Files\\FME\\fme.exe' `C:\\DOCUME~1\\ADMINI~1\\LOCALS~1\\Temp\\wb-xlate-1353554731187_5952' `LOG_STANDARDOUT' `YES' `LogCount' `C:\\DOCUME~1\\ADMINI~

2
K
11 years ago
E
eww125
asked in Authoring
Dynamic Reader Based on Today's Date

Hi, is there any way we can bring in an input file based on today's date? For example, if we save a file from a database every day, and today's file is called  "20121114_Switch_Data.xlsx" can we have a default input (reader) to prepend today's date and grab the latest file?

4
M
11 years ago
B
brendan
asked in Authoring
Trace a single feature through a workbench

Hi,  I'm trying to debug a workbench and was and was wondering if it's possible to see the flow of one particular record. About 85k records (all with a unique ID) go into the workbench and flow through a network of transformers before all coming out via a single writer. I have identified several features that have been processed incorrectly but in order to work out what went wrong I need to work out the path they took through the transformers.  Any suggestions on how to achieve this? Thanks

2
sigtill
Contributor
11 years ago
G
gis_geek
asked in General
FME justification

Hello FME Community,  I have been looking at FME for some time and have been contemplating putting together a purchase justification for management. So,  I have searched all over the website and done many Google searches, but I am having a hard time finding any concrete quantitative benefits or value statements to use in my justification.  As well, I could also benefit from some information on ownership stats. For example, I work for a city gov't in Vermont.  Does anyone know if other local cities own FME or if there are any other FME installs in Vermont ?  So long story short, I want to buy FME but need some ammunition to justify the purchase. My bosses have no idea what I do (or really care) as long as they get their maps.  So, any simple / high-level ammunition would be greatly appreciated.      

6
M
11 years ago
jdh
Contributor
jdhContributor
asked in Authoring
Custom transformer dynamic attribute name

What is the best way to specify the output attribute name on a custom transformer?  I can add a paramter , but the logical transformer (AttributeCreator) let's me link the value of an attribute easily enough, but not it's name.

5
jdh
Contributor
11 years ago
R
romainjanil
asked in Transformers
coordinateConcatenator bug?

Hi, is there a bug in the ouput of the coordinateConcatenator ?: last 2 couple of coordinates are glued together in the output string attribute whatever the delimiter is. Other coordinates pair (or trio) are well delimited though. This is very annoying for further pyhton operation (seems awckward to put a test or an error checking for something that's aobviously a bug). On FME 2013 beta but also 2012. Did anybody else seen this ? Thanks

1
R
11 years ago
I
iturbides
asked in Data
How can I migrate Intergraph Warehouse data to Oracle Spatial Object with FME ?

Can you have a Step by Step manual that explains How can I migrate data (Intergraph Geomedia Warehouses) using FME to Oracle database (Oracle Spatial Object) ? Remember that Intergraph use GOOM Package for storage on Oracle. Have FME an alternative ?  I appreciate your valious time.  Regards, Iturbides

2
fmelizard
Contributor
11 years ago
sidra
Participant
sidraParticipant
asked in Data
Formatting attributes when converting from an ArcGIS dataset to KML

How do I set attribute symbology when converting from and ArcGIS dataset to KML? Can it be done during the conversion process through FME, or do I need to format the KML file after conversion? 

3
sigtill
Contributor
11 years ago
D
daslthem
asked in Data
Converting ArcMAP text to AutoCAD Multi-line text

Hello folks I trying to find away to convert ArcMAP text to AutoCAD Multi-line text. Is this possible with FME?

2
mhab
Contributor
11 years ago
K
karen
asked in Data
Update a file geodatabase using dynamic readers and writers

I have an 'update' file geodatabase and a 'destination' file geodatabase. I want to replace an existing feature class in my destination file geodatabase with the updated version from my update file geodatabase. I am using dymanic readers and writers. Usually when I do this with shapefiles I chose to truncate the table and it works fine. However, this doesn't seem to be working for my file geodatabase. The new features from the update file are being added to the existing features (i.e. the existing features remain in the file geodatabase). Is this to do with using file geodatabases (the writer mode can't be set for file geodatabases as it can be for SDE writers), or is it to do with using dynamic readers and/or writers? Can this be resolved?

2
K
11 years ago
mark2atsafe
Safer
mark2atsafeSafer
asked in Architecture
FME Server Download Humouring

Hi all, Less a question, more an answer. I know this came up on FMETalk, so I wanted folk to know that we added a "humouring" device to FME Server in 2013.  Whenever you run a data download/job submitter process, you get a spinny wheel thing with an elapsed time counter.    Hope this is useful  Cheers  Mark

0
mark2atsafe
Safer
11 years ago
michael
Contributor
michaelContributor
asked in Data
ArcGIS Data Distribution demo issue

I'm attempting to standup the demo ArcGIS Server data distribution application. I configured the workspace and can successfully run it from Desktop and from the FME Server Web User Interface. However, when I attempt to use the web application itself (arcgis.html), the Step 2: Set Parameters form which is supposed to be dynamically generated based on the REST API is not populating.  For reference, this is what I'm tying to do: http://fmepedia.safe.com/articles/Samples_and_Demos/Standalone-data-distribution-demo-ArcGIS-Server  Michael

2
P
11 years ago
fmelizard
Contributor
fmelizardContributor
asked in Data
Proper use of the OSM reader?

I'm trying to load OpenStreetMap using FME. This works great with small datasets in 2012, however as soon as I start playing with large datasets (millions of features) I hit the problem that the FME OSM reader acts as a grouper - it reads the entire dataset in before it actually trys to translate everything.  Does this have to happen? Is there a way to disable it or is this a limitation of the XML reader? It's massively slowing down everything because even with 32GB of RAM, FME is still filling it up and then writing to temp disk space (despite the original dataset only being about 7GB uncompressed).  Using 2012 SP4 64bit. 2013 13206 is 5.5 times slower on the small dataset, so not using that despite changes in #13082 to make "it better with large datasets" - not sure what that means.

5
fmelizard
Contributor
11 years ago
G
graeme
asked in Transformers
Oracle/SDE sequence increment

I have an SDE environment with Oracle and am trying to append rows to an existing table.  The primary key is defined in the database by an auto-incrementing Oracle integer sequence.  Normally for a Postgresql or Oracle writer, setting the key to strings like 'DEFAULT' or 'MYSEQUENCE.NEXTVAL' act like they would in SQL.  However I have not been able to get the SDE workbench writer to operate in a similar manner.  When using a 'MYSEQUENCE.NEXTVAL', FME tries to be smart and do a schema check -- it won't allow writing a string to an integer field.  If I try not populating the attribute, FME complains that the NULL constraint on the PK would be violated.  I also was going to try a hack to read in the max key value with the intention of having an FME counter set each subsequent value.  However that won't work because the equivalent of a mapping file @SDEsql call doesn't exist in workbench.  Suggestions on how to do this or other approaches to try out woul

5
G
11 years ago
jdh
Contributor
jdhContributor
asked in Data
Exclude files from batch

Hi all is there anyway to setup an exclusion filter on a reader?  I need to run a script about a thousand times with each file in a seperate directory.  Normally I would just put a merge filter on the featuretype (*) and have the reader parameter be rootdir\\**\\*.xml.  However in this case each directory contains two xml files, one always called metadata.xml and the other is different for every directory.  I only want to read the xml file that changes, not metadata.xml.  Ideas?

3
davideagle
Contributor
11 years ago
S
sweetpea73
asked in Transformers
Merging Polygon Data

What transformer(s) do I need to merge two polygon layers together where the coincident polygons would have both their original attributes and the attributes of the other polygon?  Thanks!

3
davideagle
Contributor
11 years ago
S
stian
asked in Transformers
SQL Executor

Hi!  I'm having a hard time getting SQLExecutor to interpret a SQL string from published parameters. However if I paste the exact same string directly into the transformer it executes without problem. Any ideas why???  The WHERE clause looks like this when i execute the workflow  WHERE ST_Contains(ST_GeomFromEWKT('SRID=32633;POLYGON ((183044.6766 6488587.2041,172720.1045 6526144.3677,205500.5582 6546330.9112,215416.0671 6503714.6016,183044.6766 6488587.2041))'),the_geom32633) and date >= driftsutslipp.date_to_int(date '$(date_from)') and date <= driftsutslipp.date_to_int(date '$(date_to)  And the Error is:  Error executing SQL query: ............................[edited ] WHERE ST_Contains(ST_GeomFromEWKT('SRID=32633;POLYGON ((183044.6766 6488587.2041,172720.1045 6526144.3677,205500.5582 6546330.9112,215416.0671 6503714.6016,183044.6766 6488587.2041))'),the_geom32633) and date >= driftsutslipp.date_to_int(date '$(date_from)') and date &lt

2
S
11 years ago
T
trevor
asked in Data
I am attempting to transform a feature class from a SDE geodatabase to a new feature class in a different geodatabase.

I have items that are not necessary to move from one geodatabase to another. I need to exclude certain items in the source geodatabase.  For example Feature Class 1 has attributes a,b,c,d  I need to generatea new  Feature class based on feature class1 with attributes b and c.

2
J
11 years ago
fmelizard
Contributor
fmelizardContributor
asked in Transformers
How old is FME?

Okay, I feel like I'm on Jeopardy, phrasing my answer in the form of a question, but I wanted to mark the 16th birthday of FME's official release in the community somehow.  So the answer is, it is 16.   The original release announcement is found here: https://groups.google.com/group/comp.cad.cadence/tree/browse_frm/month/1996-11/6b17c9ab20d225c2?rnum=81&_done=%2Fgroup%2Fcomp.cad.cadence%2Fbrowse_frm%2Fmonth%2F1996-11%3F   But perhaps a better question is what do the next 16 years hold? Cross platform UI? FME on Google Glass? Support for spatially enabled video? "Think to add" transformers in the canvas? Let's see what the best answer is...

7
J
11 years ago
S
stian
asked in Transformers
Building dynamic SQL

Cheers!  I'm currently modelling a workflow that uses SQL creator for querying a PostGIS DB and a set of published paramteres in order to enable the user to make choices that will be passed on as predicates in the SQL string.  This works fine for most parameters (to/from date e.g.) but somehow I'm not able to figure out how to prompt for an input geometry file (e.g. a Shape file), extract the geometry and use the WKT ("POLYGON((XXXX))")  from this file in the SQLCreator. I've tried using the GeometryExtractor and this extracts the WKT, but how do I pass this on as a predicate in the SQL creator?  Regards,  Stian Aamot   

3
S
11 years ago
E
eww125
asked in Authoring
Dividing Integers, Managing Number Types

How do I specify what type of number I want for arithmetic operations? For example, when use the Attribute Creator and then the Arithmetic Editor to divide two numbers that are integers, the result is a rounded/truncated integer, but I want a number that is 3 decimal places...

3
fmelizard
Contributor
11 years ago

Badge winners

Show all badges
29,707
Posts
Terms & ConditionsCookie settings