Populating the Template

<< Click to Display Table of Contents >>

Navigation:  Import/Export > Import >

Populating the Template

Previous pageReturn to chapter overviewNext page

The Import Templates utilise Microsoft Office Excel tables to assist with easy visualisation of the data you are entering into the template.

 

The first row contains the column header information, which relates to the corresponding table column that the data will be imported into in ESdat.  Columns with an asterix (*) in the header are required fields and must be populated with data.

 

Enter your data starting from the first blank cell below the header (in the example below this is cell A5).

 

clip0525

 

As you enter data, subsequent rows in the Excel table are alternately highlighted to indicate they will be used for import.

 

clip0520

 

It is important that you enter your data within the Microsoft Office Excel table.  Data outside this table will not be imported.

You can identify the Excel table extent by its alternating row colours and the clip0523 in the bottom right corner of the table, or by using the standard Excel "Insert Rows" function.