CSV file requirements for bulk import – Discovery Education UK

Users with Admin access within the Experience platform can bulk import teachers, students and classes into the platform. You will need to extract teacher, student and class data from your MIS system into a .CSV file to use with our User Import Tool.

-------------------------------------------------------------------------------------------

If you are the school administrator, but do not have a My Admin tile on your homepage, please email schoolsupport@discoveryed.com so we can transition your account to have Admin access.

Please also read our step by step guide before uploading your files.

-------------------------------------------------------------------------------------------

Column headers and required fields

This section gives a high level overview of the column headers and the fields in each template. Ensure that all columns and headers are present, even if optional fields are not used.

Under Templates List section, 'Details' link will provide you information on the fields that you will require from your MIS for each template type. 'Download' will download the template for you to populate.

Teacher template

Column headers and field details below

Column headers/Fields	Required field	Description
SchoolName	Required	School Name as it is in the platform (Pre-populated by Discovery Education)
SchoolID	Required	Discovery Education School Passcode (Pre-populated by Discovery Education)
FirstName	Required	School to enter teacher's first name
LastName	Required	School to enter teacher's last name
Username	Required	School to enter teacher's email address For Google SSO - use email address For Office 365 SSO - use email address No SSO - teacher work email is recommended as username
Email	Required	Used to reset passwords. School to enter teacher's work email
TeacherID	Required	School to enter an ID, this can be anything (see example below) or the MIS id ID is used to update username and email ID is used to link teachers to classes in import Duplicate values not accepted

CSV file example data -

SchoolName	SchoolID	FirstName	LastName	Username	Email	TeacherID
Discovery Primary School	ABCD-1234	John	Smith	jsmith@discoveryprimary.sch.uk	jsmith@discoveryprimary.sch.uk	DP1234
Discovery Primary School	ABCD-1234	Dave	Robin	drobin@discoveryprimary.sch.uk	drobin@discoveryprimary.sch.uk	DP1235

Student template

Column headers and field details below –

Column headers/Fields	Required field	Description
SchoolName	Required	School Name as it is in the platform (Pre-populated by Discovery Education)
SchoolID	Required	Discovery Education School Passcode (Pre-populated by Discovery Education)
FirstName	Required	School to enter student's first name
LastName	Required	School to enter teacher's last name
Username	Required	School to enter a preferred username for the student For Google SSO - use email address For Office 365 SSO - use email address No SSO - your preferred username. Note, if the username is not unique in the platform, the upload will provide you with an error notification. We recommend you add a prefix to the username to ensure this is unique first time round. See example below.
Email	Optional	School to leave this field blank
StudentID	Required	School to enter an ID, this can be anything (see example below) or the MIS id ID is used to update username and email ID is used to link students to classes in import Duplicate values not accepted
Grade	Required	School to enter the student's 'year group' This is the 'Year' the student belongs to. Used to link students to classes in import

CSV file example below -

SchoolName	SchoolID	FirstName	LastName	Username	Email	StudentID	Grade
Discovery Primary School	ABCD-1234	Alice	John	DPSAJOHN		DP1236	2
Discovery Primary School	ABCD-1234	Peter	Martin	DPSPMARTIN		DP1237	3

Class template

Column headers and field details below –

Column headers/Fields	Required field	Description
SchoolName	Required	School Name as it is in the platform
SchoolID	Required	Discovery Education School Passcode
ClassName	Required	Name that users will see
ClassID	Required	Must be unique within a school
SchoolYear	Required	Differentiates classes from year to year IF ClassID remains the same

CSV file example below -

SchoolName	SchoolID	ClassName	ClassID	SchoolYear
Discovery Primary School	ABCD-1234	Rose	L789	2020
Discovery Primary School	ABCD-1234	Lily	L678	2020

TeacherRoster template

Column headers and field details below –

Column headers/Fields	Required field	Description
SchoolName	Required	School Name as it is in the platform
SchoolID	Required	Discovery Education School Passcode
ClassID	Required	ClassID from Class.csv
TeacherID	Required	TeacherID from Teacher.csv

CSV file example below -

SchoolName	SchoolID	ClassID	TeacherID
Discovery Primary School	ABCD-1234	L789	DP1234
Discovery Primary School	ABCD-1234	L678	DP1235

StudentRoster template

Column headers and field details below –

Column headers/Fields	Required field	Description
SchoolName	Required	School Name as it is in the platform
SchoolID	Required	Discovery Education School Passcode
ClassID	Required	ClassID from Class.csv
StudentID	Required	StudentID from Student.csv

CSV file example below -

SchoolName	SchoolID	ClassID	StudentID
Discovery Primary School	ABCD-1234	L789	DP1236
Discovery Primary School	ABCD-1234	L678	DP1237

Related articles