After the import of data from CASES21 there will still be some data which needs to be entered into the new database. Rather than input data manually, some schools may choose to populate their new database using CSV files.

The format for the CSV files is as follows:

Data File

Order of Fields and Special Instructions

Teachers

Teacher Code, Surname, Given Names, Preferred Name, Salutation

 

NB       Salutation is optional

 

Student Group

Group Code, Group Name, Coordinator Code

 

NB       Coordinator Code is optional

 

Subjects

Subject Code, Subject Name, Year Level, Coordinator Code, Report Position, Subject Description

 

NB       Report Position and Subject Description are optional fields.

 

Classes

Class Code, Subject Code, Teacher Code

 

Enrolments

Student Code, Class Code 1, Class Code 2, Class Code 3,…

OR

Student Code, Class Code

Student Code, Class Code

Student Code, Class Code…

 

NB       There is no limit on the number of classes which may be imported or exported for each student.

 

Schools may use a spreadsheet program like Microsoft Excel or a text editor like Notepad to create their CSV files.

Below are some example csv files which may be downloaded.

Example teacher.csv file

Example subject.csv file

Example class.csv file

Schools may find the majority of the required data can be found in places such as the school timetabling software, CASES21 and other school admin databases.

This page gives instructions on importing CSV files

Add comment

Security code
Refresh