Not logged in - Login
< back

Display SIMS Timetables in Office 365 Calendars

For SIMS customers with Office 365 it is possible to automatically publish the SIMS timetable data as events in the Office 365 calendars for the pupils and staff they apply to.

Please be aware this only applies to timetable events and not to the SIMS Calendar/Diary

Setting up the Timetable Service

Prerequisite actions

Please ensure your site is set up for Office 365 within SIMS ID. You can do this by using the Office 365 Self Onboarding tool that forms part of the enablement of OneNote Write Back.

The Timetable Service requires that SIMS ID is linked to your office 365 tenancy. For best results we would recommend using SIMS ID to carry out your Office 365 provisioning and management, however, this is not mandatory to use the Timetable Service

Preparing SIMS to use the service

You will need to run the following SQL script against your SIMS Database to licence SIMS for the Timetable SSM Package.

if you are unsure of how to carry out this action please speak to your SIMS Support organisation

Please download the below SIMS Patch

SIMS O365 Timetable Patch

Please run

INSERT INTO sims.db_process_class
([process_name], [description], [licensed], [readonly], [available_offline])
VALUES
('ServicesManager:capita.simsid.timetable','Send SIMS Timetable to Office 365', 'T' ,0 ,0)

Having runinstalled the abovepatch SQLagainst Script,SIMS, please install the capita.sims.timetable package into SSM - this is available inside SSM in the Manage Packages section.

Timetables will start to sync within 120 minutes.

Due to the large volume of data that may need to be transferred and the rate limits applied by Microsoft in Office 365 it may take up to 72 hours for all timetable event to be present. Following this period timetable events will update every 60 minutes.