CSV file requirements for bulk import

Reva Jhanji

02 February 2021 00:19
Updated

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.

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

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
SchoolID	Required	Discovery Education School Passcode
FirstName	Required
LastName	Required
Username	Required	Google SSO - use email address Office 365 SSO - use email address No SSO - school email is recommended
Email	Required	Used to reset passwords
TeacherID	Required	Used to update username and email Duplicate values not accepted Used to link teachers to classes in import

CSV file example below -

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
SchoolID	Required	Discovery Education School Passcode
FirstName	Required
LastName	Required
Username	Required	Google SSO - use email address 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
Email	Optional
StudentID	Required	Used to update username and email Used to link students to classes in import
Grade	Required	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
Discovery Primary School	ABCD-1234	Alice	John	ajohn16		DP1236
Discovery Primary School	ABCD-1234	Peter	Martin	pmartin17		DP1237

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
TeacherID	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

Comments

0 comments

Article is closed for comments.