Importing Data

To import sample data into eLab, follow these steps:

Click Import from the Sample Actions group of the Materials tab. The Import Wizard is displayed.

Figure 12.1. The Import wizard - Import filename screen.
Enter the location of the Excel file or click the button next to the File name box to browse to the location of the file.
The remaining controls will be automatically populated. Ensure the settings are correct , otherwise make the required changes, and then click Next.
Set the required properties and values or click Load template and select a template to apply.
Click Next.
Review the information to be uploaded on the summary screen, and then click Accept.
The data to be imported will be validated. If the validation process is successful, click Yes on the dialogue box that is displayed.

Note:

You may be prompted to clarify any ambiguities in the file or inconsistencies between the Excel data and the database that are found during the validation process.
To import data from another file format use Microsoft Excel to convert the data to an Excel file before using the Import Wizard .