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?
Question
File Geodatabase schema to Excel
+5- Contributor
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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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
+15- Contributor
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