You will be provided with a CSV template by Free Flow Info which will allow you to upload all pupil/student information, including their teachers and classes.
Please see the table below which details all of the information needed to ensure a successful upload.
Student class CSV
Field Name |
Required |
Valid values |
Max length |
Description |
---|---|---|---|---|
student_id |
Yes |
Free text. |
16 |
The unique ID used to identify the student in the system you are importing from (i.e. your database). |
student_forename |
Yes |
Free text. |
32 |
The student’s forename. |
student_surname |
Yes |
Free text. |
32 |
The student’s surname. |
student_email |
No |
A valid email address. |
255 |
The student’s email address (if available). |
student_dob |
Yes |
YYYY-MM-DD (e.g. 1995-01-13) |
10 |
The student’s date of birth as an ISO 8601 date. |
student_gender |
Yes |
|
1 |
The student’s gender. |
student_pp |
No |
|
1 |
Whether the student is considered “Pupil Premium”. |
student_send |
No |
|
1 |
Whether the student is considered “SEND (Special educational needs and disability)”. |
student_eal |
No |
|
1 |
Whether the student is considered “EAL (English is an additional language)”. |
student_cat |
No |
|
4 |
The student’s CAT level. |
class_id |
Yes |
Alphanumeric string. |
32 |
The unique ID used to identify the class in the system you are importing from (e.g. a database ID). It is important you use a unique value here as it will be used as a reference when performing later imports. |
class_name |
No |
Free text. |
64 |
The name of the class. If this value is omitted a name will automatically be generated using the teacher’s name and class subject (e.g. Mr Dunn’s English Class). |
class_year_group |
Yes |
A positive integer. |
2 |
The year group of the class (e.g. 11) |
class_school_type |
No |
|
5 |
The age group of students this class covers. If this is omitted, the value will automatically be determined by the year group of the class. |
class_subject |
Yes |
Free text. |
255 |
The subject name of the class (e.g “Maths”, “English”). If you omit this value, the class will be saved as a “form” class. |
teacher_id |
Yes |
Alphanumeric string. |
16 |
The unique ID used to identify the teacher in the system you are importing from (e.g. a database ID). It is important you use a unique value here as it will be used as a reference when performing later imports. |
teacher_title |
Yes |
|
4 |
The teacher’s title. |
teacher_forename |
Yes |
Free text. |
32 |
The teacher’s forename. |
teacher_surname |
Yes |
Free text |
32 |
The teacher’s surname. |
teacher_email |
Yes |
A valid email address. |
255 |
The teacher’s email address. |
teacher_dob |
No |
YYYY-MM-DD (e.g. 1995-01-13) |
10 |
The teacher’s date of birth as an ISO 8601 date. |
teacher_gender |
No |
|
1 |
The teacher’s gender. |
student_of_class_from |
Yes |
YYYY-MM-DD (e.g. 1995-01-13) |
10 |
The date the student joined the class. |
student_of_class_to |
No |
YYYY-MM-DD (e.g. 1995-01-13) |
10 |
The date the student left the class (if applicable). |
Related users’ CSV
A related user is someone who has a relationship with a student. This could be a family member, carer or family friend. A pupil/student may have more than one parent/ Supporter, and a parent/Supporter may be related to more than one pupil/student.
Field Name |
Required |
Valid values |
Max length |
Description |
user_id |
Yes |
Alphanumeric string. |
16 |
The unique ID used to identify the user in the system you are importing from (i.e. your database). |
user_title |
Yes |
|
4 |
The user’s title |
user_forename |
Yes |
Free text. |
32 |
The user’s forename. |
user_surname |
Yes |
Free text. |
32 |
The user’s surname. |
user_email |
Yes |
A valid email address. |
255 |
The user’s email address. |
user_relation_role |
Yes |
|
9 |
Whether the user is a guardian or a supporter of the student. |
user_relation_type |
Yes |
|
13 |
The unique ID used to identify the related student in the system you are importing from (i.e. your database). This value should be match the value used to import the original student. |
0 Comments