McGill University has recently chosen to migrate from its custom Web Publishing Software (WPS) to Drupal. As a team made up largely of McGill alumni, we were really excited to be involved in one of the first projects in McGill's move to Drupal: the undergraduate course calendar website.
The undergraduate course calendar displays a huge amount of content from McGill's internal databases including over 10,000 courses and over 400 programs.
We used the ApacheSolr Search module to create the search interface for the site, allowing students to easily find courses in their faculty, department, or program. The search interface is integrated with each faculty's section of the site, so that any page listing courses or programs has a corresponding set of filters allowing staff and students to refine their results.
We also created synchronization scripts to pull in all the courses, programs, and regulations from McGill's internal databases. The course regulation content is stored in a document management system called Documentum and the course and program data is stored in an Oracle database system called Banner.
The undergraduate course calendar includes a large number of regulations and one of the challenges was to create a menu structure that would make these regulations more browsable. We created a custom "Flat Book" module which alters the normal Drupal book display and automatically collapses book pages, which maintaining their hierarchy.
We collaborated closely with McGill's Content and Collaboration Solutions team throughout the project. The course calendar's theme is a subtheme of the main McGill Drupal theme and the site includes a number of McGill's custom modules.