Skip to main content

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

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 is the sample Data we are looking to export to Excel

export-to-excel.zip


@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

Schema features will be output via the <Schema> port.

 

 


@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

Generally list attributes won't appear on the Table View in FME Data Inspector. To inspect detailed contents of the feature including list attributes, see the Feature Information window after selecting a feature on the Table View.

 


@takashi

Sorry I am still not getting all the attributes list there

please see attached the WS and the output

sechema-extraction.fmwattribute-exposer.xlsx


@takashi

Sorry I am still not getting all the attributes list there

please see attached the WS and the output

sechema-extraction.fmwattribute-exposer.xlsx

Have a look at the ListExploder transformer.

 

You will have to learn more about List. Read the documentation: About List Attributes

 

 


@takashi

It work finally , after using the attribute exploder


Reply