File Geodatabase schema to Excel

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