Appendix 1

Importing new users – the file format

Below is shown a sample file formatted to allow its importation into LASS.

In LASS 8-121 there is an example file (junior_import.txt) be in a folder called [Archives] off the main database folder (see also Appendix 2).

In LASS 11-15 the example file is called secondary_import.txt and its contents may differ a little from those shown below.

Argos,Ann,F,12/09/2001,Group1,

Bering,Bobby,M,30/05/2002,Group2,apples

Charles,Cheryl,F,11/02/02,Group1,kiwi

Danson,Daniel,M,20/06/01,Group3,orange

Ericsson,Edwina,F,09/03/2001,Group1,apples

Forlan,Frederic,M,12/09/2002,Group3,apples

Grimshaw,Gregory,M,25/07/2001,Group2,banana

Hart,Helena,F,17/12/2001,,grapefruit

 

There are up to 6 fields which should be entered for each student as follows:

Surname, Forenames, Sex, date of birth, Group*, Password*

 

Notes on formatting

* denotes optional fields.

Each new user's details should be in a separate line.

Fields should be separated by a comma with 5 commas in total.

Names don't have to be in alphabetical order as they are sorted within the software.

The sex must be represented as either M or F.

Date of birth must be in the standard British short date style dd/mm/yy

If the Group or Password is omitted you must retain the comma which would have preceded it. In the example above, Ann Argos doesn't have a 'password' but the comma before it is still there; also Helena Hart doesn't have a 'group' so she will be allocated to the default group 'Universal'.

Please note: All student names used within this Guide are fictitious and used for demonstrative purposes only.