Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 7,102 Posts
  • 26,145 Replies
7102 Posts
P
pals
asked in Data
FME2010 SP4 and ESRI ArcGIS licensing problem

Hi, I have runned into some strange behaviour with FME Desktop and ArcGIS.  My ArcGIS licences are 1 ArcInfo, 15 ArcEditor and 15 ArcView hosted on a license server.  Under Citrix I set the variable ESRI_SOFTWARE_CLASS=Viewer as a default environment variable. This works fine, and for example a "double-click" on a MXD icon will launch ArcView. Given this as the default behaviour I provide users with separate startup icons for ArcEditor and ArcInfo (ESRI_SOFTWARE_CLASS=Editor or Professional respectively).  But, when I launch FME and start an ETL-workflow which requires an ArcGIS license, then FME try to launch ArcInfo. Seems like ESRI_SOFTWARE_CLASS=Viewer (i.e ArcView) is not honoured by FME.  The same seems to be the case for local installs. FME honours license settings from the ArcGIS Administrator and not what i set by ESRI_SOFTWARE_CLASS.  Anyone knows a way to force a specific ArcGIS licensetype to be used by FME?  best Pål Herman Oslo, Norway  

233
fmelizard
Safer
J
jerrod
asked in Data
'Subtract' one line feature class from another

Thre should be a simple solution for what I am trying to do, but for some reason I can't think of it.  I have two polyline feature classes.  Feature Class 'A'  is made up of segments of the Feature Class 'B'.  However, not all segments of a line from 'B' exist in 'A'.  Some segments are missing.  What I need to do is compare the two to find out what is missing in 'A'.  Basically just looking for a "subtract" feature for lines.  I know how to do this for polygons, but not for lines.   Any ideas would be much appreciated!  I feel like it is really simple and I'm just overlooking the easy solution!

960
M
R
rob1980
asked in Data
Specifying SQLNET.ORA file

Hi!  Has anyone ever had the need to specify which sqlnet.ora file FME uses?  Unfortunately, I need to use 2 different ones to access various Oracle databases and FME does not like the one I use mainly.  I have tried hacking about with both version to merge them but then I have FME not working or TOAD not working, or in some cases neither!  Any suggestions would be great as I am fed up having to keep swapping over :(

322
R
H
hpras
asked in Data
FME Desktop 32bit and 64bit on the same machine

Can I have 32bit and 64bit versions of FME Desktop on the same machine.  I need to use some of the datatypes for some projects, but need >4GB memory space for tothers.  Thanks H

283
mhab
Contributor
U
unwantedstray
asked in Data
FME and clipping ECWs

Has anyone tried to clip an ECW using a shapefile? For some reason the clipper does not respond to the ecw format the same as it does for others. Having the ouput routed to the viewer shows a clipped image. However, when you open the output file again in either the view or in another program the file is back to its original shape.  If i do the same process in arcCatalog, (extract by mask) it works, but it is very slow and requires a few other processes to extract the data afterwards to make it usable.

503
davideagle
Contributor
D
dhiraj
asked in Data
Required Mapping between reader & writer

I have done features migration into FGDB to Oracle SDE Format through Mapping using FME  . There is any tool , this will give me mapping between Writer  & Reader In csv  or any other format .

80
davideagle
Contributor
spalatla
Contributor
spalatlaContributor
asked in Data
Error while connecting from Data Inspector for Oracle Spatial 11g DB.

We are trying to view in FME for connecting the Oracle Spatial data. We are encountering issues when connecting.  Can you suggest while looking at the log.   The following is FME  connection error   FME Data Inspector Version 4.0 Loaded module 'OCI' from file 'OCI.dll' Environment variable ORACLE_HOME has value `D:\\Oracle11gDatabase\\product\\11.2.0\\dbhome_1' Connecting to ORACLE database `pgeprim' with user name of `GRBGAE' and password of `***' Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`pgeprim', userName=`GRBGAE', password=`***', dbname=`') Failed to open database with username='GRBGAE', retrying using uppercase username Environment variable ORACLE_HOME has value `D:\\Oracle11gDatabase\\product\\11.2.0\\dbhome_1' Connecting to ORACLE database `pgeprim' with user name of `GRBGAE' and password of `***' Conn

331
davideagle
Contributor
J
jopie
asked in Data
How to read .xyz file and write points (x,y) with text z-value etc.

I'm trying with the workbench to create a new file.  I want to read a .xyz file. And want to write to a other file (shp, dwg or oracle spatial etc.) and use it in a GIS system.  There are many points (to many) i want to display those points on a distance of 100meters and only inside our city borders. Result must be all points (raster 100m) with a text z-value in our city  I h've: .xyz file and an oracle spatial of our cityborders  It's clear , i'm a beginner can someone put me on the road to solve this question?  greatings,  jopie

18715
sigtill
Supporter
2
2003_yeti
asked in Data
Write Source Pathname to SHP file Attribute

Hi....I need to figure out how to write the source path name of a file to the attribute table of a SHP file. I wanto to do this to generate field hyperlinks in the SHP file.....I can expose the format attribute "fme_basename" to get the filename, but I need to write the entire path out.....can anyone point me in the right direction.....Thanks....Scott

84
sigtill
Supporter
L
lisam
asked in Data
OS NTF Format

Is it possible to write to .NTF format?  I see that the OS NTF option is in the list of readers, but not writers? Is there a reason for this? I'm having the same issue with space delimited .XYZ files - I can ask FME to read these, but no writer either?  Any tips much appreciated!!  Lisa

203
davideagle
Contributor
M
michele
asked in Data
How can I use a public parameter in the name of a writer feature class user attribute?

The user funning my FME workspace enters a year at run time which is used for selecting records.  I want to use the year they entered in the name of a user attribute in the writer feature class.   Referencing the parameter in the user attributes using $(parameter) doesn't work.  I can successfully rename an attribute to incorporate the parameter value with the AttributeRenamer transformer, but the writer feature class won't use that attribute.  What do I need to do to make this work?

453
R
K
kevin
asked in Data
MicroStation V8 to MicroStation V7

I am having to convert MicroStation V8 to MicroStation V7 design files. In doing so I am required to select a seed file for the V7 design file output. Is there a way to use the global origin and units of resolution from the source V8 file? Is there a way to strip off the element linkages that are not valid in a V7 design file?

732
K
D
dhiraj
asked in Data
Regarding oracle spatial server changed or Hostname changed

I have developed many workbences having parameters username=ADPUGSD Servicename : Stage . But I want to move my data into another server having another servicename : 'stage_new' . Then I will modify scripts with changes in parameters on writer side or I will add another writer and then mapped to source. Pls clarify & do needful asap

50
sigtill
Supporter
D
denny
asked in Data
DGN to SHP

I have several MicroStation V7 Files of contours and I would like to convert them to ESRI shape files. In the DGN files are lines, linestrings, polygons and text. I want to convert only the lines, linestrings and polygons that are on certain levels. Has anyone got a good solution?  Dennis

284
davideagle
Contributor
A
ajayel
asked in Data
Run SQL procedure after loading shapefile

Hi, I have a reader and writer to load and re-project a shapefile into MS SQL Spatial 2008 R2.  All good.  Now I want to run an existing stored procedure once after the file loads correctly.  The stored proc has no parameters.  Help greatly appreciated. FME Desktop 2012 SP3

373
erik_jan
Contributor
adrian
Contributor
adrianContributor
asked in Data
Finding No Data in ECW File

Hi,    I have been provided an update of aerial photography in ECW format, I know that some of these files contain areas of black, i.e. there is no new photograph for this area.   I was wondering if there is a way FME can look at each file and tell me is there it contains and area of No Data without me looking at each file individually?    Thanks    Adrain

153
sigtill
Supporter
lpalli
Contributor
lpalliContributor
asked in Data
Parameters into log file

How to log into the log file, not only on the Workbench log window, the workspace parameters used to start it?

826
lpalli
Contributor
Y
ysl
asked in Data
AutoCAD to GIS

I try to convert a stormwater AutoCAD file into ArcGIS feature classes. How can I identify the flow direction. i.e. for a pipeline, which side is upstream or downstream? 

130
T
A
aflynnvelco
asked in Data
KMZ Feature Extract

I have a question about transforming a KMZ file to a shapefile. Each time I import the KMZ file, which has several separate layers, FME is not able to identify the individual layers. The “Select Feature Types” lists out the typical feature types “Animated Update”, “Document”, “Fly To”… but the only feature type that translates into the appropriate geometry is the “Placemark”. However, when I transform the “Placemark” all the attribute information is lost. What am I doing wrong? Is there something I am missing in working with KML/KMZ data?

2081
T
T
trevor
asked in Data
FME is unable to write to an ESRI enterprise SDE database.

FME is unable to write to an ESRI enterprise SDE database.  In the log file, FME says “An ArcGIS license is already checked out. The product checked out is 'ArcView'.”  How can I specify FME use and Arc Editor or Arc Info license?  The computer has ESRI installed. There is a concurrent license that is pointed to Arc Info.  At this point there are several available Arc Info licenses. 

182
M
M
marco_soave
asked in Data
Problems trying to texturize a Lod2 cityGml model

Dear all, I'd like to work on a automatically generated 3d model composed by lod1 and 2 building. What i'd like to do is to apply some generic texture to this model starting from a datset of tiled textures of roofs and walls. I did some experiments but the obtained results are not really good for two reasons:  - the texture is applied individually to each triangle of the model, thus obtaining a bad graphical result. - I'm not able to transform the lod1 buildings into lod 2 and merge the the result in a single datset in which each building has it's own wallsufrace, groundsurface and roofsurface.    To apply the textures I used an apparenceAdder transformer and tried to set the Geometry Filter to "Geometry Type" "is one of" "IFMEFace"  but nothing changed.    To extract the lod1 bouildings from datset and transform it in lod2 building I used the approach find on this forum ( or the older Google group ) but in the output the lod2 building a

221
sigtill
Supporter
S
seshu
asked in Data
Unable to Transfer Objects into Internal World

Hi All,  I am trying to tranfer the objects into the internal world's of either pad,switchgear or substation..Can any one please let me know, is there any possibility way to transfer the internal worlds from source file like microstation.  Thanks, Seshu

70
geolassi
Contributor
owen
owen
asked in Data
Fgdb Annotations to dgn - callouts

Hello,  I have annotations stored in a file geodatabase, and can convert the text into dgn labels.  Is there a way of translating the geomerty of annotation callout boxes into lines/polygons? They do not come through automatically...  Owen

233
fmelizard
Safer
A
annette
asked in Data
writing ESRI Oracle SDE date attributes (date and month are reversed)

Hi,  An easy one, I hope, for the ESRI experts :)  I am writing a date attribute to an Oracle SDE feature class but the month and day are reversed.  The feature class is a new table created via FME.  So 20121128  appears as 11/28/2012 and not 28/11/2012  e.g. US and not European format  I tried the DateFormatter without success.  Any thoughts would be appreciated.    Thanks,  Annette

262
A
hakans
Contributor
hakansContributor
asked in Data
Writing empty MapInfo-files

Every night I update a bunch of MapInfo Tab-files, using FME Desctop.  My Issue: When no features enter the writer to a specific feature type, no update is made to that file. The old content remains. No features to the writer, indicates that I need the resulting file to be empty, rather than containing yesterdays data.  The MapInfo write has no "Truncate first" option, witch would help me out here...

174
L

Badge Winners

Show all badges

Community Stats

31,852
Posts
120,986
Replies
39,485
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.