Importing metadata

The Import Metadata tool

To import metadata into a CLC Metadata Table, go to:

        File | Import (Image Next_Folder_16_n_p) | Import Metadata (Image add_to_results_metadata_table_16_n_p)

The first column in the selected file must have unique entries. That column will be designated as the key column. A different column can be specified as the key column later. For the optional step for association of data elements to work, the first column must contain entries that can be matched with the relevant data element names.

Select the Excel, CSV or TSV format file with metadata to be imported. The rows in that file are displayed in the Metadata preview window (figure 13.4).

The format of the columns should reflect the column contents. The designated format can be changed from within the Metadata Table editor, as described in Editing metadata. There, you can change the column data types (e.g. to types of numbers, dates, true/false) and you can designate a new key column.

Image metadata_import_basic-step1
Figure 13.4: Rows being imported from a file containing metadata are shown in the Metadata preview table.

Associating metadata with data (optional)

The "Associate with data" wizard step (figure 13.5), is optional. To proceed without associating data to metadata, click on the Next button. Associating data with metadata can be done later, as described in Associating data elements with metadata.

To associate data with the metadata:

Image metadata_import_basic-step2
Figure 13.5: Three data elements are selected for association. The "Prefix" partial matching scheme is selected for matching data element names with the appropriate metadata row, based on the information in the Sample ID column in this case.

The Data association preview area shows data elements that will have associations created, along with information from the metadata row they are being linked with. This gives the opportunity to check that the matching is leading to the expected links between data and metadata.

You can then select where you wish the metadata table to be saved and click on Finish.

The associated information can be viewed for a given data element in the Show Element Info view (figure 13.6).

Image metadata_data_element_show_info
Figure 13.6: Metadata associations can be seen, edited, refreshed or deleted via the Show Element Info view.