Import Wizard Introduction

The Import Wizard empowers the user to import sample data directly from an Excel file into eLab. The wizard presents the list of the available properties and provides the option of linking a column in the file being imported to those properties or setting them to a particular value.

Figure 11.1. The Import wizard template specification screen.

The main screen of the wizard consists of a table with four columns:

Database Field. This column presents a tree-view of all the properties associated with samples. Properties are grouped into areas of functionality and collapsed into nodes.
Source. The option selected from this column determines whether the property of the associated row is linked to a column in the file being imported , set to a particular value , or not set.
Value. This column determines the value of the property of the associated row, it can be set to a specific value or be linked to the value from the file being imported.
Mapping. The mapping column allows you to examine the data from the relevant column in the underlying file and map values of that column to new values to be uploaded into eLab.