Skip to main content
What's the best way to export a FGDB schema to Excel?  I want a sheet (tab) for each feature class with the attribute name, type, size, etc.

 

 

I've tried exporting the FGDB to XML and reading it in but am having trouble fannning out the feature classes to sheets correctly.  Is XML schema the way to do this?
Hi Jon,

 

 

I think the Schema (Any Format) Reader is suitable to do that.

 

The reader reads schema from a dataset and creates non-geometry features which contain  attributes storing the schema.

 

-----

 

fme_feature_type_name: feature type name

 

attribute{}.name: attribute name

 

attribute{}.fme_data_type: data type name (FME general)

 

attribute{}.native_data_type: data type name (format specific)

 

etc.

 

 

If the format is FGDB, specify the directory name (*.gdb) to the reader Dataset. Since you cannot select a directory in standard Select File dialog, enter or modify the Dataset manually in the text box.

 

 

# a yen symbol in the image represents a back slash (Japanese environment).

 

 

You can use the ListExploder to convert "attribute{}" to individual elements. And then, write them into Excel sheets with fanout option by "fme_feature_type_name".

 

 

Takashi
If u fan out to excell make sure to replace spaces with underscores. Excell writer can't handle names with spaces (at least till fme 2013sp2).

 

 

Gio

Reply