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.
- 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
boubcher wrote:
@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
boubcher wrote:
@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
boubcher wrote:
@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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.