E10 - Synchronisation to Apple School Manager via Export (CSV)

Modified on Fri, 19 Sep at 6:08 AM

TABLE OF CONTENTS

Step 1: Configure the Apple School Manager sync export

Make sure that your region in 'Setup > School info > Admin' is set to your correct region and not 'Unknown' or 'Other'.The Apple School Manager sync will not appear in sync drop-down if the incorrect region is selected.In Tes timetable file (E10), select File > Synchronise > Configure In the Configure tab, select 'Apple School Manager' from the drop down list of options.

Tes Timetable and Apple School Manager integrate via flat file. E10 outputs the following .csv files for Apple School Manager to import:

Classes
Courses
Locations
Rosters
Staff
Students

The information contained within this article is a collaborative effort between Tes Timetable and Apple School Manager. If there is anything missing or requires change, kindly get in touch with Apple School Manager.

Step 1: Configure the Apple School Manager sync export

Make sure that your region in 'Setup > School info > Admin' is set to your correct region and not 'Unknown' or 'Other'.
The Apple School Manager sync will not appear in sync drop-down if the incorrect region is selected.

In Tes timetable file (E10), select File > Synchronise > Configure

In the Configure tab, select 'Apple School Manager' from the drop down list of options.

Multiple systems can be set up to sync. It is common to have both the Edval webserver and the school's learning management system configured, along with any other systems the school wishes to regularly sync with.

Select the Configure button, which will move you to the Connection tab. A destination folder must be selected to direct where the .csv files will be saved to. Select Browse and locate or create the desired location.

'Sync each time you save' - This means the sync will occur automatically on a ctrl-S save. In this case, data is first saved locally to disk, and then an attempt is made to sync with all external systems. This is simple, but you may want to disable this if the external systems or your network is slow to sync, or you want more control about 'when' you publish data through to other systems. No message is shown on a sync-on-save, as it is done quietly. Only active sync via menu/ctrl-K will show a completion message.

Step 2: Other tab

Option	Details
School code:	When entered, this school code is prefix onto class, course, and roster IDs
Additional class types to include:	Any classes that need to be included in the export
Locations are:	School code: Your school code is used as the only location. Campus code: Your campuses are used in the in the locations.
Exclude classes wildcard;	Any class that needs to be excluded from the export file can be added here followed by wildcard.
Use student Statewide ID:	Use the student id's to be uploaded into the exported file. Student id's in students >student data >View >state wide ID
Exclude students without emails:	Exclude any student for whom no email address is recorded in the timetable file

Step 3: Perform the sync

The following steps will be performed each time new data is to be sent to Apple School Manager:

Navigate to File > Synchronise > Sync now.
Select / ensure that the Apple School Manager option is chosen in the Filter menu on the top right.
Select 'Create TT publish file'

A number of files will be created which will be used to import into Apple School Manager

The table below details what type of data each CSV file consists of when exported:

File Name	Data column (A)	Data column (B)	Data column (C)	Data column (D)	Data column (E)	Data column (F)	Data column (G)	Data column (H)	Data column (I)	Data column (J)
Classes.csv	Class code	Class code	Course code	Teacher with the most amount of lessons	Teacher with the second most amount of lessons	Teacher with the third most amount of lessons	Campus of year/School code.(The last row in locations.csv is the default campus)	N/A	N/A	N/A
Courses.csv	Course code	Course code	Subject	Campus of year/School code	N/A	N/A	N/A	N/A	N/A	N/A
Locations.csv	Campus code (or School code if there are no campuses)	Campus name (or School name if there are no campuses)	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A
Rosters.csv	Roster ID (Row number, starting at 1)	Class code	Student code	N/A	N/A	N/A	N/A	N/A	N/A	N/A
Staff.csv	Admin ID (Teacher code if there is no Admin ID)	Admin ID (Teacher code if there is no Admin ID)	First name	N/A	Surname	Email	Everything before the @ in the staff email address	Teacher main campus. The last row in locations.csv is the default campus	N/A	N/A
Students.csv	Student code	Student code	First name	N/A	Surname	Year level	Email	Everything before the @ in the student email address	N/A	Campus of year/School code. The last row in locations.csv is the default campus

In a 'Multi-campus' file, any Year Level that is not associated with any campus will pick the 'Default campus'

Apple School Manager has no concept of timetable or bell times.