Dundee moved to a centralised timetabling approach in 2010/11. Initially, there was no data integration between its student records system – Tribal’s SITS-and its timetabling software, Syllabus Plus Enterprise. This meant two isolated datasets, a lot of duplicated work, and many errors in the resulting timetable.
Between 2012 and 2016, Dundee used a script developed in-house to get these business-critical applications talking. This enabled a one-time import of Modules, Programmes of Study (by School), Students and module selections (by School) from SITS to Syllabus Plus.
Producing a timetable from this data involved creating theoretical Student Sets based on Programmes of Study. But the vast number of possibilities meant that Dundee was catering for module combinations never picked in practice. The process was time-consuming, not responsive to subsequent changes, and the output was impossible to timetable. Constantly striving for improvement in its processes, Dundee was keen to ditch its unwieldy legacy scripts in place of new, reliable and supported solution.
Fully compatible with the most popular timetable applications, including CELCAT, Facility CMIS and Scientia Enterprise, RUIS removes the need to manually enter data for room utilisation reporting, via a suite of data translation interfaces that smoothly convert timetable data to room utilisation data format.
Facility CMIS To RUIS
The tie-in between Facility CMIS and RUIS is achieved by using List Definitions in CMIS to export text files. The List Definitions have already been written, but can be edited in consultation with Mosaic Software if there are particular storage methods for room data in the CMIS database that are specific to an institution. The exported files are processed by the CMIS / RUIS Data Translation Interface and the required RUIS import files are produced. These are then loaded into RUIS.
Scientia Enterprise To RUIS
Integration between Scientia Enterprise or Syllabus Plus Classic timetable data and RUIS involves setting up Location Groups for RUIS, that define for each room the Campus, Precinct, Building, Room Type, and Benchmark Type. Rooms are assigned to the RUIS Location Group in the Scientia images as required. Once this is completed, a COM-enabled image is created, and the Scientia / RUIS Data Translation Interface connects to it. The interface then automatically writes Rooms, Events, Organisation Structure and Utilisation Targets files. Once the interface has finished writing the files, they can be loaded into RUIS.
CELCAT To RUIS
The CELCAT timetabling software contains menu items that command the export of department, room and event information that the CELCAT / RUIS Data Translation Interface processes to turn into RUIS import files. These are loaded into RUIS in the normal way.
Other Timetable Software
Mosaic Software has already written a bespoke data translation interface to convert Infosilem timetable software data into RUIS format. Interfaces between other timetabling software programs can be written on a case-by-case basis.