Importing
Single file
This format uses the tab or comma character to separate each field. This file format is the most general purpose way of importing information into SM-Reports. Most general purpose database systems should be able to generate a file with this format.
The first line of the file indicates the fields names for the data that follows. All field names on the first line must be one of the following:
family
given
year
course
class
teacher
With optional names of:
preferred
gender
sid
teacher email
These are repeated with a separate line for each class the student is in. The other fields are optional, but if teachers use the statement data bank in a co-educational school the student gender is essential. For the import to work, the text file must fulfil three conditions:
- The first line of the file must have a series of field names that indicate what each columns contains.
- There must be enough columns to fully identify the class.
- There is only one class on each line, which means the student names appears on multiple lines.