Follow

Getting Started

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.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.