Upload data in to Timetable 2.0 manually

Modified on Thu, 15 Oct at 12:55 AM

If you use Timetable (E10), you can access its help articles here

Introduction

Timetable 2.0 requires student, employee, room and subject data to create timetables.

If you don’t have a MIS/SIS or your MIS/SIS is not connected to Timetable 2.0, you can upload your data manually.

This article outlines how to download your school data from your systems and upload it into Timetable 2.0.

IN THIS ARTICLE

Before you begin
Manually download student data to our templates
Manually download teacher data to our templates
Manually download subject data to our templates
Manually download room data to our templates
Upload data into Timetable 2.0
Troubleshooting manual upload
Up next

Before you begin

You will need Data Controller access to be able to manually upload data in Timetable 2.0.

Check with your school’s Timetable 2.0 organisation administrator if you require access.

Note: uploading data into Timetable 2.0 will update data across any connected Tes products.

Manually download student data to our templates

Go to Admin and select Upload data:

Select Download students template (this will download the student .xlsx template to your computer).
Complete the student .xlsx template on your computer, consisting of the following data fields in the table.
When all your data is populated into the required columns, save the file locally to your computer.

Data	Description
First name	Student’s given name (required)
Last name	Surname, family name of student (required)
Email	Student email address (required)
Date of birth	Student birth date (required)
Gender	Student gender (required)
Source ID	MIS/SIS ID or unique identifier (required)
Year group	Year the student is in (required)
Registration group	Home room or tutor group (optional)
Group1Code	These are custom groups of students that don’t exist in your MIS/SIS, for example: groups of special needs students, sports groups, etc. You can add as many columns as required to capture all custom groups (optional).
Group2Code
Group3Code

You have downloaded student data to our student template.

Note: You can also follow the template instructions on the next tab of the template and copying the sample data provided.

Manually download employee data to our templates

Go to Admin and select Upload data:

Select Download employees template (this will download the student .xlsx template to your computer).
Complete the employees.xlsx template on your computer, consisting of the following data fields in the table.
When all your data is populated into the required columns, save the file locally to your computer.

Data	Description
First name	Employee's given name (required)
Last name	Surname, family name of teacher (required)
Email	Employee email address (required)
Source ID	MIS/SIS ID or unique identifier (required)
Subjects	Subjects taught by this employee (optional)
Groups	Student cohorts and year groups taught by this employee (optional)
Non-working days and times	Specific days and times that the employee is not available to teach at school (optional)
Non-contact time	Allowance time for employee planning, preparation and assessment (PPA), release from face-to face (RFF) or duties other than teaching (DOTT) (optional)

You have downloaded employee data to our employees template.

Note: You can also follow the template instructions on the next tab of the template and copying the sample data provided.

Manually download subject data to our templates

Go to Admin and select Upload data:

Select Download subjects template (this will download the student .xlsx template to your computer).
Complete the subjects .xlsx template on your computer, consisting of the following data fields in the table.
When all your data is populated into the required columns, save the file locally to your computer.

Data	Description
Subject code	Short unique code to identify the subject e.g.; MathsYr10 (required)
Subject name	Name of subject (required)
Source ID	MIS/SIS ID or unique identifier (required)

You have downloaded subject data to our student template.

Note: You can also follow the template instructions on the next tab of the template and copying the sample data provided.

Manually download room data to our templates

Go to Admin and select Upload data:

Select Download room template (this will download the student .xlsx template to your computer).
Complete the room .xlsx template on your computer, consisting of the following data fields in the table.
When all your data is populated into the required columns, save the file locally to your computer.

Data	Description
Room code	Short unique code to identify the room e.g.; MathsYr10 (required)
Room name	Name of room (required)
Source ID	MIS/SIS ID or unique identifier (required)

You have downloaded room data to our student template.

Note: You can also follow the template instructions on the next tab of the template and copying the sample data provided.