Importing a timetable from TimeTabler

This article covers importing a timetable from TimeTabler if:

  • You are importing your timetable for the next academic year as part of the New School Year Setup process - please refer to Step 6 of your setup guide here to see where to go.
  • You've recently moved to Arbor and need to set up your classes for the first time in Arbor (referred to as 'teaching groups' in TimeTabler)
  • You need to make significant changes your timetable part-way through the academic year (if you do not want to make these changes in Arbor)

If you need to delete and replace a timetable already imported for next year that has been set up incorrectly, or that you've made changes to in TimeTabler and want to write over in Arbor, please see this FAQ.

How does the import work?

When you import a TimeTabler file, Arbor will look to see which timetable slots have changed and for which effective dates. New timetable slots will be created for new courses/classes within the TimeTabler file, and existing courses/classes will have their effective dates extended if all that has changed is the time period.

Effective dates are the dates within an academic year that a timetable slot is active for. For example, you may decide that you'll be having a different timetable in Spring term than in Autumn term. You will set the effective date of the timetable in TimeTabler, and the slots created when you import the file will end on this date. You would then need to import a new TimeTabler file for spring term, or extend your timetable slots in Arbor if you decide not to change your timetable. 

Can I import a TimeTabler file early?

You can't import a TimeTabler file that covers dates in two academic years. If you would like to create a timetable that becomes effective towards the end of the summer term, and which remains effective at the start of the next academic year, you must import two TimeTabler files, one with effective dates for summer, and one for the next academic year.

How does it map the academic year information?

Arbor will recognise the academic year stated within your timetable file and look to see if there is a corresponding academic year that already exists on Arbor. If there isn’t, the import process will ask you to select a date range for the new academic year you want to set up. This would occur when you are importing a timetable for a new upcoming academic year. Otherwise, if you are importing a new timetable for the current academic year, the academic year will remain the same and not be editable.

Tips to prevent duplicates

If you have previously imported a timetable from TimeTabler for the current academic year and are importing a new file, make sure you don't change the subject short name in TimeTabler. This will prevent duplicate courses from being set up when reimporting. The short name is used to help Arbor reference the course to remember what was mapped previously.

Screenshot_26_11_2020__13_19.png

 

To prevent events being mapped incorrectly to duplicate staff, check in School > Data > Data Quality Dashboard > Suspected duplicates > Staff. Resolve them using these instructions: Resolve duplicate staff

 

How long will it take?

  • Add your file and check the dates - 2 minutes
  • Year groups and registration forms - 5 minutes
  • Sites and rooms - 10 minutes (depending on the number)
  • Teachers - 5 minutes
  • Courses and classes - 15 minutes (depending on the number)
  • NTAs - 5 minutes
  • Days of the week - 1 minute
  • Confirm the import - 1 minute
  • Schedule the slots - 5 minutes

 

Before importing

Before importing your file, please read the guidance below to ensure you're completing the process correctly depending on when you're importing the file.

 

Importing your TimeTabler file

Once you have generated your TimeTabler file, go to the timetable import area.

  • As part of the New School Year Setup process - please refer to Step 6 of your setup guide here to see where to go.
  • Mid-year or replacing your import - School > Timetable > TimeTabler Integration > Import Timetable to upload it to Arbor by working through the TimeTabler File Import Wizard.

Screenshot_2022-12-14_at_16.24.03.png

 

Add your file and check the import

Click +Add to import a new TimeTabler file.

Screenshot_2021-04-22_at_08.45.53.png

 

After you have uploaded your TimeTabler file, you will enter the TimeTabler File Import Wizard. Once each stage has been completed and saved, it will show as complete at the top of the screen with a green tick icon.

Screenshot_2021-06-17_at_14.20.41.png

 

During the import process, you can click on a step to see what you've imported so far.

Screenshot_2022-12-19_at_10.11.49.png

 

Make sure you check that:

  • the start and end dates correspond to the right dates
  • that they won't overlap with any timetable slots in Arbor
  • the Days per cycle field displays the number of days after which the timetable is repeated (excluding weekends). For example, if your timetable repeated every two weeks, this field would instead display '10'.

Screenshot_2021-05-14_at_14.43.13.png

 

If they don't map, you'll need to either:

  • amend your timetable length in TimeTabler
  • adjust your timetable in Arbor - click on this field to head to your Timetable Settings page to adjust your periods: Two-week timetable periods. Top Tip: This is only possible to do between 2pm and 5pm.

Screenshot_2023-05-09_at_14.34.40.png

 

If any of this information is incorrect, click the red Cancel button at the bottom of the page, regenerate your TimeTabler file in TimeTabler correctly, and attempt the upload again.

If everything is correct, click Next.

Screenshot_2021-04-22_at_08.56.57.png

 

Importing the timetable

Import Academic Year, Year Groups and Registration Forms

Step One is to import the academic year and map the year groups and registration forms to your existing ones. The names on the left-hand side refer to the groups set up in TimeTabler. The groups that appear in the drop-down menus refer to the groups you have already set up in Arbor.

For each drop-down list select one of the potential options. For example:

  • Map to - The sessions in TimeTabler for the 7A Registration form will be scheduled for the 7FH form in Arbor. We recommend using this option wherever possible. You can map multiple TimeTabler groups to the same group in Arbor.
  • Skip - You will have to create your own group on Arbor and link the courses and classes manually to the correct group.
  • Import - Creates a new group in Arbor. For registration forms, this also schedules timetable slots for this group based on the timetable in TimeTabler. For registration forms, you have the option to import this student group as a registration form or teaching group.

Once you have completed the mapping, click the green Next button.

Screenshot_2021-04-22_at_09.08.22.png

Screenshot_2021-04-22_at_09.09.00.png

 

Arbor will then save your settings in the background.

When it's finished processing, click the notification to return to the import and complete the next step. Don't see the notification? Try refreshing your page.

Screenshot_2021-04-22_at_09.12.40.png

 

Click on In progress to continue the next step.

Screenshot_2022-12-19_at_09.42.30.png

Import sites and rooms

Step 2 imports sites and rooms from the TimeTabler file. For each drop-down list select one of the potential options. For example:

  • Map to - The sessions in TimeTabler for in the room will be linked to the room selecting in Arbor. We recommend using this option wherever possible. You can map multiple TimeTabler rooms to the same room in Arbor.
  • Skip - The lessons on your timetable will not have those rooms assigned, and you will need to assign rooms manually after the import process is complete.
  • Import - Where the site/room does not currently exist in Arbor, you can create a new one by selecting Import.

Once you have completed the mapping, click the green Next button.

Screenshot_2021-04-22_at_09.19.26.png

Screenshot_2021-04-22_at_09.21.44.png

 

Arbor will then save your settings in the background.

When it's finished processing, click the notification to return to the import and complete the next step. Don't see the notification? Try refreshing your page.

Screenshot_2021-04-22_at_09.32.23.png 

 

Click on In progress to continue the next step.

Screenshot_2022-12-19_at_09.42.30.png

Import Teachers

Step 3 is to import or map your academic leads/teachers. The names and abbreviations on the left are the teachers in TimetTabler, the names in the drop-down boxes are your staff that exist in Arbor. For each drop-down list select one of the potential options.

  • Map to - Any courses linked to the staff member in TimeTabler will be linked to the mapped staff member in Arbor.
  • Skip - Courses in your timetable will not have those staff assigned, and you will need to assign staff manually after the import process is complete.
  • Import - Where the staff member does not currently exist in Arbor, you can create a new one by selecting Import. We recommend adding new staff members through the usual route of School > All Staff > Add new staff member rather than selecting Import (creates new record) if you have new staff members in TimeTabler file that have not yet been added onto Arbor.

Once you have completed the mapping, click the green Next button.

Screenshot_2021-04-22_at_09.45.23.png

 

Arbor will then save your settings in the background.

When it's finished processing, click the notification to return to the import and complete the next step. Don't see the notification? Try refreshing your page. 

Screenshot_2021-04-22_at_09.46.14.png

 

Click on In progress to continue the next step.

Screenshot_2022-12-19_at_09.42.30.png

 

If you have selected to import any teachers, you need to set them up as staff members. Click into their name.

Screenshot_2021-04-22_at_09.48.58.png

 

In the slide over, give them a title, name, email address and business role at a minimum. 

Screenshot_2021-04-22_at_09.50.57.png

Screenshot_2021-04-22_at_09.51.28.png

Import courses and classes

In this step, you can see a list of subjects within your TimeTabler file and map each subject from your file to a top-level course that we have on Arbor. We recommend you use this if there's a direct mapping available (e.g. Mathematics to Maths). Alternatively, you can select No direct mapping available (you'll be able to map later) if there is no direct mapping available.

  • If you're importing a timetable mid-year, please map as many of your subjects as possible. This will prevent duplicate courses from being created. The list available to map is based on the courses you have set up in Arbor already.
  • If you have not set up any courses (for example if you're importing a timetable for next year), you can import them all. This will create new top-level courses.
  • if there is no direct mapping available (e.g. the subject in TimeTabler is Mathematics, but in Arbor is KS3 Mathematics or KS4 Mathematics), you can select No direct mapping available (you'll be able to map later).

Screenshot_2021-05-11_at_13.20.08.png

Screenshot_2022-03-30_at_08.51.19.png

 

Arbor will then save your settings in the background.

When it's finished processing, click the notification to return to the import and complete the next step. Don't see the notification? Try refreshing your page. 

Screenshot_2021-05-11_at_13.24.21.png

 

Click on In progress to continue the next step.

Screenshot_2022-12-19_at_09.42.30.png

 

Next, you can map DfE subjects to your top-level courses. Class subjects are required for the Spring School census so we recommend adding this information in, but you can choose to either map or skip.

Screenshot_2021-05-11_at_13.26.28.png

 

Arbor will then save your settings in the background.

When it's finished processing, click the notification to return to the import and complete the next step. Don't see the notification? Try refreshing your page. 

Screenshot_2022-12-19_at_10.14.38.png

 

Click on In progress to continue the next step.

Screenshot_2022-12-19_at_09.42.30.png

 

Next, you'll need to import or map your Course and Classes. There is no way to not import or map a class - you can either import and delete, or omit those classes from your TimeTabler file and reimport.

Any bottom-level courses that you have previously imported a timetable for this year will automatically be mapped. Importing will create a new course.

Top Tip: Have a lot of courses to map? Click the Don't log me out button regularly.

Screenshot_2022-12-19_at_10.16.10.png

 

Arbor will then save your settings in the background.

When it's finished processing, click the notification to return to the import and complete the next step. Don't see the notification? Try refreshing your page. 

Screenshot_2022-12-19_at_10.17.52.png

 

Click on In progress to continue the next step.

Screenshot_2022-12-19_at_09.42.30.png

 

For any classes you imported that are connected to a subject you didn’t map in the first step, you can add them to an existing top level course in Arbor.

If you can’t find a relevant top level course to match to, you’ll need to make add a new top level course via School > Programmes > Courses and return to this page.

Screenshot_2022-03-30_at_08.54.50.png

 

Arbor will then save your settings in the background.

When it's finished processing, click the notification to return to the import and complete the next step. Don't see the notification? Try refreshing your page. 

Screenshot_2021-05-14_at_14.38.35.png

 

Click on In progress to continue the next step.

Screenshot_2022-12-19_at_09.42.30.png

Import Non-teaching Activities 

In this step, you can import any Non-teaching Activities (NTAs) you've set up in TimeTabler. This can include Guaranteed Planning, Preparation and Assessment (PPA) Time, meetings or other types of events. They will be imported as Events in Arbor.

  • You will need to decide whether to map the NTA to an existing event type in Arbor, or to create a new event type.
  • For each NTA, you can select whether or not the event should flag as requiring cover when a staff member is absent. Don't worry - you can amend this at a later date if needed.

Once you have completed your selection, click the green Next button.

Each session of NTA will import as a separate repeating event. This means that if in TimeTabler the 'Home' event happens every week on a Tuesday and Thursday, one event will be created that ones on Tuesday, and one on Thursday.

Screenshot_2021-06-17_at_14.47.20.png

 

Arbor will then save your settings in the background.

When it's finished processing, click the notification to return to the import and complete the next step. Don't see the notification? Try refreshing your page. 

Screenshot_2022-12-19_at_10.22.37.png

 

Click on In progress to continue the next step.

Screenshot_2022-12-19_at_09.42.30.png

Map the days of the week

The final step imports timetable slots from the TimeTabler file on Arbor. Double-check that the days of the week have been matched correctly.

  • If they have not, Cancel the import, edit your file in TimeTabler and re-import.
  • If they have, click Finish.

Screenshot_2022-09-29_at_09.48.07.png

 

Arbor will then save your settings in the background.

Screenshot_2021-04-22_at_10.05.39.png

 

When it's finished processing, click the notification to return to the import and complete the next step. Don't see the notification? Try refreshing your page. 

Screenshot_2021-04-22_at_10.06.01.png

Click on In progress to continue the next step.

Import Timetable slots 

When you click the notification, you can see your completed Timetabler import.

Click on the ‘Updates’ column of the table to view all the actions that have been taken so far.

Screenshot_2022-12-19_at_10.26.27.png

 

Information that needs reviewing is marked in red. You can then click it to resolve the issue.

If there is no missing data from TimeTabler and you're still getting these errors, please contact the Arbor Support Team if supported by Arbor, or your Support Partner if not supported by Arbor.

Error types include:

  • Academic year is missing from TimeTabler XML file.
  • Missing site name in TimeTabler XML file
  • Missing room code in TimeTabler XML file.
  • Missing room name in TimeTabler XML file
  • Teacher name is in invalid format in TimeTabler XML file
  • Missing subject name in TimeTabler XML file
  • Missing subject code in TimeTabler XML file
  • Missing year group name from TimeTabler XML file
  • Missing registration form short name from TimeTabler XML file
  • Room cannot be found for lesson
  • Subject cannot be found for lesson
  • Day cannot be found for lesson
  • Period cannot be found for lesson
  • Lesson end time cannot be determined

 

Import stuck

If you have pressed Finish button, and the import remains In progress:

  • Wait at least 30 minutes to see if the import changes to Complete
  • If it is remaining as In progress for more than 30 minutes, please try importing your file again. Top Tip: You can't import the same file name twice, so rename the file before importing again. The old file cannot be deleted or removed, but as the import is not finished it won't affect your site.

Adding the timetable to calendars

Schedule the timetable slots

Returning to the Import Timetable Overview, the final step is to schedule the timetable slots from within your TimeTabler file. Click Completed.

Screenshot_2022-12-19_at_10.27.38.png

 

Your timetable slots from the TimeTabler file you have imported will be flagged as Provisional and will not appear on any timetable outputs such as the school timetable until they are scheduled. Click the provisional tab, then tick the boxes next to the sessions you wish to schedule. Then click on the Bulk action button to Schedule provisional timetable slots

Screenshot_2022-12-19_at_10.28.20.png

 

Make sure that everything is correct, then click Schedule. The timetable slots will be moved to the Scheduled tab.

Screenshot_2022-12-19_at_10.28.36.png

Complete any further scheduling

When a timetable is ended, sessions are deleted. This means that any functionality based on these sessions that no longer exist will be wiped, and you will need to set these again:

Was this article helpful?
3 out of 5 found this helpful
I'm still stuck!

Comments

0 comments

Article is closed for comments.