TimeTabler and Arbor integration to import school and student details

If you are using TimeTabler, you can export your data out of Arbor to import into TimeTabler, so you don't have to set everything up twice! This process should be completed if you've not used TimeTabler before.

Export your school information

We recommend completing this step to export your teacher, subject and room information into Timetabler for three reasons:

  1. You won't need to manually type in all this data again into TimeTabler
  2. When you import your timetable into Arbor, we'll be able to automatically map all your teachers, subjects and rooms, saving you time on manually matching these up
  3. The import will also be as accurate as possible because you can be sure the same items exist in both systems

 

To export your data, go to School > Timetable > TimeTabler Integration > Export Basic Details.

You can pick what you want to include in the download from Arbor, then click the green button to download the export to your computer. 

 

In the file, you'll see TC for the teacher, SB for subject and RM for the room. We recommend to not edit the file, as this could cause import issues or data inaccuracies!

Screen_Shot_2020-01-22_at_16.46.49.png

 

Then in TimeTabler, select the file from your downloads folder and import it.

Please note that if you're importing only one type of data (for example, only Rooms), you'll need to ensure Identifier required? is unticked within TimeTabler prior to importing the file.

TimeTabler_2.jpg  

 

You can also export student details to import into TimeTabler's Options software! See the instructions below for how to do this.

Export your student information for Options

Download this report and save the file on your computer until it's needed in the next steps. 

Go to School > Custom Report Writer and click on the Create New Report button, then click Import a report. A small window will then open.

Click on browse and locate the file you previously saved on your computer, then click Upload.

Screen_Shot_2020-01-22_at_16.59.18.png

 

You'll then be able to view your report, which by default will show all students in Year Groups 7, 8, 9, 10 and 11. 

To download the report, click the Download button and select CSV to download the report to your computer.

Screenshot_2022-12-13_at_12.16.20.png

 

To edit this to only include the year groups that you want to import into Options, click on the Edit button.  

On the Edit report page, scroll to the Filters section, and click on the pencil icon on the right.  

Screen_Shot_2020-01-22_at_17.00.41.png

 

In the slide over, remove the year groups that you don’t want to include by clicking the crosses, or add other year groups from the dropdown, then click Save.  For example, you might want this report to only show year 9 and 11, as they will be choosing their GCSEs and A-Levels for the following academic year.

Screen_Shot_2020-01-22_at_17.01.49.png

Then click Save and View Report.  

Screen_Shot_2020-01-22_at_17.02.29.png

 

Then you can import this file into Options to confirm the column names on the matching page.

 

 

 

Once you've got all your data into TimeTabler and have created your timetable, you can import this timetable into Arbor. Read this article on Importing a timetable from TimeTabler for how to do this.

Was this article helpful?
2 out of 9 found this helpful
I'm still stuck!

Comments

0 comments

Article is closed for comments.