Getting Started – Free Flow Info

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	m f i	1	The student’s gender.
student_pp	No	0 1 Y N	1	Whether the student is considered “Pupil Premium”.
student_send	No	0 1 Y N	1	Whether the student is considered “SEND (Special educational needs and disability)”.
student_eal	No	0 1 Y N	1	Whether the student is considered “EAL (English is an additional language)”.
student_cat	No	low med high	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	2-4 4-11 11-16 16+	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	Mr Mrs Miss Ms Dr	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	m f i	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	Mr Mrs Miss Ms Dr	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	guardian supporter	9	Whether the user is a guardian or a supporter of the student.
user_relation_type	Yes	carer parent aunt uncle grandparent brother sister family_friend	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