Hello
I am Looking to export the Geodatabase schema ( manay tables) without the data to an excel sheet
column 1: table name
Column2: attribute name
Column 3: attribute type
Column 4:width
Solved
Export GeoDB to Excel
+11- Contributor
Best answer by takashi
Hi @boubcher, you can use the Schema (Any Format) reader to read only the schema features. Each schema feature has a list attribute called "attribute{}" which contains the information on the schema of a single feature type.
- fme_feature_type_name: feature type (table) name
- attribute{}.name: attribute name
- attribute{}.native_data_type: data type name in the source format
- attribute{}.fme_data_type: FME generic data type name
Data type name contains width if necessary. e.g. fme_char(64).
Alternatively, you can also use the FeatureReader to read only schema features, if you set "Schema Features" to the Features To Read parameter.
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.
- Best Answer
Hi @boubcher, you can use the Schema (Any Format) reader to read only the schema features. Each schema feature has a list attribute called "attribute{}" which contains the information on the schema of a single feature type.
- fme_feature_type_name: feature type (table) name
- attribute{}.name: attribute name
- attribute{}.native_data_type: data type name in the source format
- attribute{}.fme_data_type: FME generic data type name
Data type name contains width if necessary. e.g. fme_char(64).
Alternatively, you can also use the FeatureReader to read only schema features, if you set "Schema Features" to the Features To Read parameter.
+11- Contributor
@takashi
the geoDb has no data in it, I used creator, but I am getting nothing schema-export-to-excel.png
@takashi
the geoDb has no data in it, I used creator, but I am getting nothing schema-export-to-excel.png
+11- Contributor
@takashi
I am not getting the mentioned attribute list on the output , is there any specific configuration ?schema-export-to-excel-output.png
@takashi
I am not getting the mentioned attribute list on the output , is there any specific configuration ?schema-export-to-excel-output.png
+11- Contributor
@takashi
Sorry I am still not getting all the attributes list there
please see attached the WS and the output
@takashi
Sorry I am still not getting all the attributes list there
please see attached the WS and the output
You will have to learn more about List. Read the documentation: About List Attributes