Advanced Metadata Import

The Metadata Table Editor can be used to import metadata from an external file. It involves more steps than the basic import tool, but is more flexible and has some basic error checking associated with data types. General features of this importer are:

The Metadata Table Editor can also be used to create and populate a metadata table directly if desired.

Importing metadata using the Metadata Table Editor requires that the table structure is defined first. Information about how to do this is below. However, if the information about the data is in an excel file and the entries in the first column are unique, then the Import Metadata tool described in section 3.2.1 can be used to define the table and import the metadata in one step. That populated metadata table can then be opened in the Metadata Table Editor, where it can be refined, for example setting a new key column (or choosing not to have one), setting data types on columns, associating data as desired, and so on.

To set up a or alter a table structure using the Metadata Table Editor:

The table structure can also be defined manually by clicking on the (Image insert_column_after_16_n_p) button and defining each column in turn.

Columns may be deleted using the (Image delete_column_16_n_p) button. After metadata has been imported, additional columns can be added to the table structure. This can be done by importing the altered structure from an external file, where any columns not already in the metadata table will be added. Alternatively, individual columns can be added using the (Image insert_column_before_16_n_p) and (Image insert_column_after_16_n_p) buttons, which insert new columns before and after the current column respectively.

The metadata table can then be populated by importing information from an external file. The column names in the metadata table in the Workbench will be matched with those in the external file to determine which values go into which cell. Only cell values in columns with an exact name match will be imported. If the file used contains columns not in the metadata table, the values in those columns will be ignored. Conversely, if the metadata table contains columns not present in the file, imported rows will have no values for those columns.

Row information can also be added manually by clicking on the (Image insert_row_after_16_n_p) button and typing in the information for each column.

The progress and status of the row import can be seen in the Processes tab of the Toolbox. Any errors resulting from an import that failed can be reviewed here. The most frequent errors are associated with selecting the wrong separator or encoding, or wrong date/time formats when importing rows from delimited text files.

Once the rows are imported, The metadata table can be saved.