Solved

Export GeoDB to Excel


Badge +3

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

icon

Best answer by takashi 30 May 2018, 08:18

View original

9 replies

Userlevel 2
Badge +17

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.

Badge +3

This is the sample Data we are looking to export to Excel

export-to-excel.zip

Badge +3

@takashi

the geoDb has no data in it, I used creator, but I am getting nothing schema-export-to-excel.png

Userlevel 2
Badge +17

@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.

 

 

Badge +3

@takashi

I am not getting the mentioned attribute list on the output , is there any specific configuration ?schema-export-to-excel-output.png

Userlevel 2
Badge +17

@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.

 

Badge +3

@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

Userlevel 2
Badge +17

@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

 

 

Badge +3

@takashi

It work finally , after using the attribute exploder

Reply