Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 6,697 Posts
  • 24,694 Replies
6697 Posts
K
kam
asked in Data
Reading metadata from an ArcSDE Feature Class

I want to map the version last updated date from the metadata to a new field in the feature class.  When you save a feature class as an ESRI layer file it also creates an xml file in the same location.  Previously I would locate the feature class as a layer file saved in my local directory then read in the XML file using an XML reader, flatten the metadata and set the elements to match to 'metadata'  Then I can easily locate the attribute that contains the version date etc - and map this right over to a new field in a feature class.  But now where I have feature classes in SDE not saved as layer files I was wondering if there was any way of following this same process? How do I read that XML and after reading it, how would I carry out the xml flattening and elements to match when it is not using an XML reader?   Thanks

3
Y
10 years ago
B
barani
asked in Data
Writing DTM as TIN surface into CityGML

Dear FME users.  I want to write TIN surface into CityGML as TINRelief (tin) and I am not sure how to do that.  I am using in the CityGML GeometrySetter the following parameters:  CityGML Lod name: extent Feature Role: reliefComponent  Since there there is no option to select lod I set citygml_level_of_details to '0'. Hope that is fine.  Finally I am setting CityGML writer Feature Type Name as ReliefFeature.  When I run the workspace CityGMLWriter gives me this worning:  CityGMLWriter registered 1 messages of type:  The 'extent' citygml_lod_name trait is invalid for 'ReliefFeature' features, the geometry will be ignored, valid values are {}.  and there is no geometry being outputed into CityGML file.  I would appreciate any help very much.  Thank you.  Regards, barani

1
B
10 years ago
J
johng
asked in Data
User Parameters from file

Hello,  Is it possible to read user parameters from a text/xml file. I need to store user parameters in a file which it turn read by a workbench to set a connection info which will be used to connect to db.  Regards,

9
takashi
Contributor
10 years ago
jimo
Participant
jimoParticipant
asked in Data
FME Server Login from localhost

Is there a way to protect the login page for FME Server 2014? I would like to allow login only from localhost, that is, on the machine itself. You can do stuff like this with Apache. Is it possible with FME Server 2014?  Thanks

1
redgeographics
Evangelist
10 years ago
P
pierre
asked in Data
google fusion error 503 & 443

Hi,  I have a workspace runner calling some workspace to export Google Spreadsheet data to Google Fusion. But, sometimes, I have an error like this :   Google Fusion Tables: Unknown SSL protocol error in connection to www.googleapis.com:443 Google Fusion Tables Writer: Unable to create the connection.  Please check your login information, table names and table IDs.  (Error was: 'Unknown SSL protocol error in connection to www.googleapis.com:443 ')  Or like this :   2014-07-15 10:14:12|   4.8|  0.2|ERROR |Google Fusion Tables: HTTP error code : 503 2014-07-15 10:14:12|   4.8|  0.0|ERROR |Google Fusion Tables: HTML Response: 'Internal error. Please try again.' 2014-07-15 10:14:12|   4.8|  0.0|ERROR |Google Fusion Tables: CommitTransaction failed 2014-07-15 10:14:12|   4.8|  0.0|ERROR |Google Fusion Tables Writer: Error inserting features to table 't_facturation'  The next workspace will run without problem. There is no network problem (tested on 2 servers).

0
P
10 years ago
L
l_marsvolta
asked in Data
Rename material and texture from Wavefront OBJ to OBJ

Hi everbody,  i just want to rename the textures associated to my OBJ files. I have for example a file called AB0001.obj and four textures :  noname001.jpg,noname002.jpg,noname003.jpg,noname004.jpg  I want to rename my textures in order to have :  AB001_1.jpg, AB001_2.jpg, AB_003.jpg,AB_004.jpg  So i used "Appearance extractor" and "Appearance setter" but without success.  Thanks!

5
G
10 years ago
Y
yamabushi
asked in Data
Read in feature class from output of a transformer

Hi, I am trying to read in a feature class, the name of this feature class depends on the output of another reader/transformer.  I may be missing something simple (like schemas) but I can't seem to find this.    More specifically I am reading in feature classes from a database, I want to compare the names to a diffTable in the database to see if there are new feature classes or edits that have been made.  I am stuck at the part where I have say 2 new feature class (names) and I want to read those and write them out to another database (just as they are, in 2 seperate feature classes).  I have access to desktop and server.  I was thinking of chaining or using server to run them.  Thanks for any advice.

5
G
10 years ago
J
jimbob
asked in Data
changing coordinates of a .LAS file

Hey guys,  this is the first time i have used FME, i have been reading some files and watching the Youtube viedos,  i am sure this will be an easy question for you guy!  i am trying to convert the coordinates from the nationalgrid to are localgrid   i have an Autocad script file that have move and scale commend in it,   MOVE ALL  0,0,0 -346000,211000,0 SCALE ALL  0,0,0 1.000410669  but when i use the offsetter command and scale command with these values, Then coordinateExtractor and Logger to view the Coordinates, they dont match   are you guys able to point out a rookie mistake,  cheers

2
J
10 years ago
francis_m
Contributor
francis_mContributor
asked in Data
FME 64x and ArcGIS 32x

Hi! We are moving our OS from winXP 32x to Windows7 64x. We are using FME and ArcGIS. We will be using FME 2014 sp2 Dekstop and ArcGIS 10.2.1 Desktop. And we also have an ArcGIS server installed with MSSQL Server 2008 r2.  My question is on the correct install to use. I read here (http://fmepedia.safe.com/articles/Samples_and_Demos/Notes-on-FME-and-ESRI-Versions-and-Compatibility) that I can't write those format if I run FME 64x : File, Personal, or ArcSDE Geodatabase (ArcObjects)  But if I read here  (http://www.safe.com/fme/format-search/#!) I can write those format (File, Personal, or ArcSDE Geodatabase (ArcObjects))  I know I can use file geodatabase with the API but It's not my first choice as I'm limited on the API format.  So should I install FME 64x or FME 32x ?  Thank you!  

3
G
10 years ago
V
vikram
asked in Data
load annotation feature class into ArcSDE

Hello,   I have feature class with annotation in the source File Geogatabase . I need it to move to ArcSDE .   WHat are the steps I need to follow to load it into ArcSDE

2
david_r
Influencer
10 years ago
V
vikram
asked in Data
Doubt Regarding Scheduled Task for FME Server

I have subscribed for directory watch if any data is added . But my requirement is to enable a scheduled task and  run it next day at 00.30 am . How can i possibly do this .

1
T
10 years ago
nath
Contributor
nathContributor
asked in Data
write to fgdb

Hi,  I'm trying to overwrite a feature in a file geodatabase but i always get the same error  Geodatabase Error (-2147024894): The system cannot find the file specified. Could not open File Geodatabase dataset `P:\\vmmGeoDB\\IND.gdb' for writing.  Am i missing something? Whe i try to do the same thing with af shp it works fine.  The intention is to write a shp to a fgdb.  Can somebody help me?  Thx!        

1
G
10 years ago
J
julien
asked in Data
In FME Server 2012 - 2013, the token is stored in database.

Why ? Is it possible to encrypt the token ?

1
fmelizard
Contributor
10 years ago
R
rvgeneug
asked in Data
FME Server process does not start FMEServerJobSubmitter

Hi,  I have a few workspaces that are triggered in one main workspace to work in series. In my FME desktop the process runs perfect.  Now the plan is to move the complete workflow to FME Server. All workspaces run perfect when started seperately. Now the issue is getting the integrated workspace working. I changed the workspacerunners to FMEServerJobSubmitters. But when running the main workspace the first workspace from the FMEServerJobSubmitter is queued. Only when killing the main, the second is started.  Any suggestion on this one?

12
R
10 years ago
farfar
Contributor
farfarContributor
asked in Data
Csv file writer empty!

Hi All, My writer (csv file) is created only if i have results to input; But if there is no result, the csv file is not created. Is there possibilities to create it even if is empty?  Thanks an advance.  FarFar

1
T
10 years ago
B
barani
asked in Data
Water body into LnadXML

Dear FME Users, I want to write water body inbto LandXML together with DTM TIN surface. I have the water defined as closed polygons. How do I do it? Should I triangulate the water polygons and save as another surface/s? What about watershed feature (not supported by LandXML writer I believe)? or should I write the water body as polygon/s. Any advice would be appreciated. Thank you. barani 

0
B
10 years ago
P
phildel
asked in Data
Expanding ranges and adding records to a DBF file

Hi I'am trying to create an expanded set of numbers and therefore new records, based on a range of numbers. EG attribute START has a value of 1 and attribute END has value of 5. The result I am looking for 5 separate records where START is 1, 2, 3, 4, 5 & END is 0

2
G
10 years ago
B
burton449
asked in Data
Visualize feature and decide to output it or not (python caller)

For a particular process we hace come to conclusion that we have to do an eye check on the feature to decide if we want to pass it to the writer or not.  Is it possible with a python caller (or other transformer) to show the features individually in a viewer with a button to route the feature to the writer and another that skip it? 

7
B
10 years ago
Y
yamabushi
asked in Data
Is there a python library to make calls to a postgres db in a startup script?

I found some documentation for import psycopg2 but when I try to include this in a startup python script on FME workbench 2014 sp2 it says that there is no module named psycopg2.  I am trying to read/write to a postgres db, more specifically i want to set a value based on a previous feature.  I believe that you cannot iterate features in a python caller.

1
david_r
Influencer
10 years ago
J
jrozema
asked in Data
Replacing old Shapefile Writer with a 2013 Shapefile Writer

I am trying to update some old workbenches we have.  Looking at our shapefile writers, we would like to use the 'spatial index' functionality that is available in FME 2013.  I am looking for an efficient way of adding a new shapefile writer and then coping over the attributes and other properties from the old shapefile writer.    Is there a non-manual way of doing this?   Thank you for your time,   Julia

2
J
10 years ago
D
dominic_doiron
asked in Data
Creating metadata in zipped file geodatabase

I have a workbench set up where I create a Feature Class inside a file geodatabase. the next step is to create the metadata and load it into the same Feature Class. This all works fine.  I'm doing the exact same thing with a zipped file geodatabase and it's giving me errors.  Attempting to create table 'XXXXXXX' with 'geodb_type' set to 'geodb_metadata'. FME features of 'geodb_metadata' can only be written to existing tables. If intending to write metadata, please ensure the table already exists.  If intending to create a new table, ensure the 'geodb_type' is set to a valid table type. A fatal error has occurred. Check the logfile above for details I've checked all my parameters and they are the same between my zipped and non-zipped file geodatabase.  Any idea why?  Thanks

0
D
10 years ago
G
gnrevolution
asked in Data
Write Oraacle Spatial Solid to DGN

Hi there,  I have some solids (GTYPE 3008) in Oracle and simply want to write them out to a DGN v8 file, but I can't seem to get anything except decomposed line strings as an output, am I missing something here?  Surely this is supported, if I write to a DWG instead no problems, but DGN just isn't producing the goods...

0
G
10 years ago
J
jmoggie
asked in Data
Does SQLite spatial writer support UTF-8 characters?

Hi,  Does anyone know whether it is possible to write UTF-8 data to Sqlite spatial?  You get the option to specify encoding when using the Spatialite writer but not the Sqlite spatial writer?  Any ideas?  Thanks

4
J
10 years ago
jhawks
Contributor
jhawksContributor
asked in Data
Desktop destination Directory is different from the servers?

(easy ? and I shoud know this)...When I create the workbench on my desktop I write to c:\\somepath but when I publish I want it to write to d:\\someother path. How do I set the path in workbench?   Both workbench and Server are 2014. The workbench extracts data from oracle and writes shapefiles.

2
L
10 years ago
S
sbaktzg
asked in Data
Is it usefull to fill the workspace properties (Name, Category, Description)?

In the FME Workspace it is possible to fill the properties to describe the workspace: Name, Usage, History, Legal, Category, Description....  Is it usefull to fill them out?  I ask because the most example workspaces from the safe-software webpage do not use them! The most workspaces use an annotation in the workspace.  Is it possible to bring the content from the properties into an annotation automatically?  What is your best practice to use or not to use the workspace properties?  

2
david_r
Influencer
10 years ago

Badge winners

Show all badges
29,702
Posts
Terms & ConditionsCookie settings