Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 7,009 Posts
  • 25,828 Replies
7009 Posts
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?

1870
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. 

150
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

190
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

51
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

220
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

210
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...

170
L
srg
srg
asked in Data
DWG READER- PRESENCE OF PRJ IN THE SAME DIRECTORY WITH THE SAME NAME AS DWG-PROJECTION BEING READ FROM PRJ FILE

I accidentally noticed that FME automatically reads the projection system for DWG files when a PRJ file (created using ArcGIS) with the same name as the DWG file is present in the same folder. Initially I thought that FME can now read projection system from DWG files. But when noticed that the projection system was incorrect and further investigating the issue, found FME reading the projection system from a PRJ file which is part of SHP files created using ArcGIS with the same file name as the DWG. This was notice is FME 2012 SP4 as well the latest BETA build of FME 2013. Has anyone noticed this problem? However this is not happening with DGN files for me! Regards SRG 

150
srg
sigtill
Supporter
sigtillSupporter
asked in Data
Removing FFS extended dataset files from the directory '' left no remaining datasets likely due to naming conflicts.

Removing FFS extended dataset files from the directory '' left no remaining datasets likely due to naming conflicts. Try renaming the source dataset files to avoid names like <basename>_<number>.ffs to avoid conflicts. Note that the FFS reader is sensitive to all files in the source directory and not just the selected files  Not sure how to solve this. I have split the 500 files into 5 subfolders with 100 files in each, and that seems to solve the problem. Is the problem the number of files selected per Reader? If the Reader could not open all the files it should abort - and not let me "think" that all files are selected. Not easy to discover when you merge many files into one large one.

40
sigtill
Supporter
C
chrismugdan
asked in Data
writing features to a postgis database after using FeatureMerger

I want to merge a shapefile and a dbf file joined by an attribute and write them to a postgis database. Is FeatureMerger the way to do this? How do I extract the merged feature information (i.e. all the merged attribute metadata) and provide it to the postgis writer so that the correct table structure is created for the merged feature type?

70
B
T
torbenhansen
asked in Data
How to write a varbinary(max) to SQL Server Spatial?

For compatability-reasons with Geomedia I need to write an additional field of the type "varbinary(max)" to all the tables in our SQL Server Spatial database. In FME I can set the varbinary datatype, but I can't set the "max" value. I've asked around and so far it seems the only workaround is to create the field with the datatype "image" and then alter the datatype directly in SQL Server afterwards. Any ideas on how to do a better workaround?

471
sigtill
Supporter
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

70
fmelizard
Safer
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? 

110
sigtill
Supporter
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?

130
mhab
Contributor
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?

210
K
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

100
P
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?

750
davideagle
Contributor
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.

40
J
R
ree8281
asked in Data
Has anyone exported attributes from an XFM-DGN to any type of spatial database?

I would like to know if anyone has exported attributes from an XFM-DGN to any type of spatial database successfully? The XFM-DGN reader was made available in the 2012 version and our organization is starting to test this functionality. Any thoughts on the translation process? Did everything work as expected?

51
srg
M
mapsrus
asked in Data
Can FME Server (FME Engine) read TrafMan Databases?

Just wondering if FME can read data from a TrafMan Database? (data generated by street traffic counters)

00
davideagle
Contributor
O
omiotti
asked in Data
Best way of logging counts of an attribute from numerous transformers into csv file??

Hi there I have a fairly complex workspace and I would like to record the number of items that come out numerous transformers (in particulat feature mergers). What I have done so far is adding a statistic calculator and an attribute creator after each important transformer and I write  the data into a csv file.. The output is presented in two columns: definition of count and count. The problem is that it makes the workspace very messy as it adds a lot of connectors. Is there a simpler way of doing this? This info is recorded by FME anyway as it is displayed on the connectors and in the log file...just wondering if there is an simpler way to log numerous counts into a csv file...thanks

281
davideagle
Contributor
S
shepthedog
asked in Data
Launch workspace from MapInfo?

HI,  We're an ESRI shop, but I have some colleagues that run river modelling software that is closely linked with MapInfo.  They want to batch process raster grids that emerge from the models (raster cell calculations and polygon and surface creation).  Is it possible to define an FME workspace and then trigger that from within MapInfo, like it would be by creating a 'Spatial ETL Tool' in ArcGIS?  Thanks, Ian

220
davideagle
Contributor
annetdeboer
annetdeboer
asked in Data
Bring readers/writers back to Workspace from Navigation Pane

Hi, it's probably something supersilly but when I have added readers/writers to the Workspace (FME Workbench 2012), delete them, but keep them in the Navigation Pane. How can I get them back to show up in the Workspace? The solution to this probably also works for the question I have about the XML reader, when I add an XML reader it never shows up in the Workspace it only stays in the Navigation Pane.  I searched the web but I got the impression that I'm the only one with this problem (or the only one not finding the solution :S) and for some reason I keep forgetting to ask somebody else. Now finally there's a community 24/7 ;-)  Cheers, Annet

230
K
S
sraza
asked in Data
PostgreSQL Scirpt (.SQL)

Instead of directly writing in it, is there any way to write an SQL script to run at an appropriate time while using PostgreSQL reader/writer?

130
G
T
trevor
asked in Data
I am trying to assemble three different sets of output data, adds, edits and deletes into a geodatabase

I am trying to assemble several datasets into one. I need to add the edited or added data in to our original/master/parent/production data set.  I also need to delete the data that should be deleted.  I have a separate feature class for the added, edited and deleted data.  I am not sure how to delete data from the original geodatabase.  I think that I am getting two ids for the added and edited when they are added to the output/published geodatabase. 

80
sigtill
Supporter

Badge Winners

  • Student (Grey)
    diannebcgrayhas earned the badge Student (Grey)
  • Student (Grey)
    saraatsafehas earned the badge Student (Grey)
  • FME Certified Professional
    laurentphas earned the badge FME Certified Professional
  • FME Form Basic Training
    eslam_elbadryhas earned the badge FME Form Basic Training
  • Webinar Watcher (Grey)
    ldrhas earned the badge Webinar Watcher (Grey)
Show all badges

Community Stats

31,358
Posts
118,954
Replies
38,988
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.