Import Students from CSV

The school administration should be able to export a list of current students to a text file.

It should contain the columns below and be be formatted as CSV (Comma Separated) for import to SportsTrak.

The import does not use a header row, but if included, there is an option to ignore it when you do the import

COLUMN NUMBER

COLUMN CONTAINS

REMARK

1

Student Code

Not essential.  If missing, SportsTrak creates a code

2

Surname

Required

3

Given

4

Initial

Not essential, but can be useful to distinguish two students John K Brown, John M Brown for example.

5

Date of Birth

Format can be:  DD/MM/YYYY or DD/MM/YY or YYYYMMDD

eg 27/8/2007 or 27/08/07 or 20070827  - fairly flexible

6

Gender

F, M, or U for unspecified

7

House

Can be full house name, or the house code as entered in SportsTrak.  Take care here, sometimes the admin computer generates a variation.

8

Year Level

Typically Year and Form, but can be just Year

eg 7, 8, 11, 12, or 7A, 07B,