Importing
Three files
This format uses three file with a comma character to separate each field. The three CSV text files must be named:
ACLASS.CSV
ASTUDENT.CSV
ASTUDY.CSV
This specific format is used in other software from SMPCS and is imported by SM-Reports Online as many schools have developed procedures to generate the required files.
- As an old format, some fields are no longer used but must still be present even when empty.
The format of these files is detailed below.
ACLASS.CSV
Name,Teacher,Subject,Year,,
The file with the classes must have 6 fields and the fields must appear in this order. There must be exactly 5 comma delimiters on each line. For example, one line in the file ACLASS.CSV could be as follows:
12M2,Ms Green,Mathematics,Year 12,,
The last two fields are empty. Here is another valid class line:
7PH1,Mr White,"Health, Physical Education",7,,
In this example there are quotes around the course because the name has a comma in it.The year field can be either a numerical value such as 7, 8, 9, or Year 7, Year 8 and so on.
ASTUDENT.CSV
Family name,Given name,Preferred name,Gender,,,,Student ID
The file with the students must have 8 fields and the fields must appear in this order. There must be exactly 7 comma delimiters on each line. For example, one line in the file ASTUDENT.CSV could be as follows:
Garland,Judith,Judy,Female,,,,150486
Here is another valid student line.
Wright,Tony,,M,,,,
Note the preferred name field is empty, but is still included. As a minimum there should be the family name, given name, and gender. The gender field can be either Male, Female, M, or F. If the preferred name field is empty, it is assumed to be the same as the given name.
ASTUDY.CSV
Student family name,Student give name,Class name 1,Class name 2,Class name 3, ...
The file with the students' classes must have at least 2 fields.and the fields must appear in this order. For example, one line in the file ASTUDY.CSV could be as follows:
Wright,Tony,12E1,12M2,12PHY2,12EC3,12GSA
The lines in the ASTUDY.CSV file can have a variable number of fields. There is an additional field for each class. The spelling of the student and class names, must be the same as those in the ASTUDENT.CSV and ACLASS.CSV files.