MySQL

I worked on this site over a four year period whilst employed at LLAS.

Originally a bespoke .NET CMS, I was initially responsible for the maintenance of this CMS and adding new features which involved extensive use of VB.NET and HTML/CSS. Significant work included rewriting the public facing part of this CMS from scratch to incorporate a page templating system to make the pages to be more consistently themed and easier to update. I also implemented a system for administrative staff to create monthly aggregate e-bulletins from existing material on the site.

In late 2008, the site received a major visual overhaul, and working in concert with the designer, I implemented new standards compliant and semantic XHTML and CSS for the design, incorporating strong use of jQuery for navigation and UI elements. This design incorporated a em based fluid width, which scaled the layout elements with font-size. Accessibility and standards compliance were important goals for this project. As part of this redesign, I also implemented this design as a google blogger theme which was used as an accompanying site.

In the winter of 2009, the ageing .NET CMS was beginning to show it's age and could not keep up with the client's modern requirements for it. I led a project to migrate the entire content and design into the open source content management system. This would enable the client to tap into the extensive array of community features provided for drupal, as well as provide much more flexibility for future feature requests. The migration involved extensive database migration from the old MSSQL database to a new MySQL based one, primarily through a custom drupal module to access the old database. Extensive work was also done to migrate the large taxonomies and metadata from the old system. I also reworked the HTML and CSS into a drupal theme. To ease compatibility and maintainable in the future, standard drupal modules such as views were used to generate most of the pages on the site.

As a drupal CMS, I also added several custom modules for the client, including modules to generate specific search pages per content-type, a new CCK field module with a textarea box and title, and to handle event registration. The drupal system also allowed the creation of more features desired by the client, including event registration, custom landing pages for important project themes, and integration with the University of Southampton online payments system to pay for events and conferences.