Books for Keeps magazine cover

Launched in 1980, Books for Keeps is noted as being "the most important periodical in the world of British children's books". There was even an uproar from authors when a star-rating system was introduced as this had not been done in their industry before - you can see when this happened as early issues have no ratings on reviews. With over 12,500 reviews and 2,000 articles as well as information about authors and artists, this project was no simple Drupal upgrade but more an exercise in data cleansing and migration.

Over the years, due to the configuration of their existing system, Books for Keeps had stored detailed information about each of the books reviewed and/or articles had been written about, in two fields 'Supplemental 1' and 'Supplemental 2'. Due to the fields not being suitable for the data contained within, along with typos, often patterns were not able to be followed to migrate the data and it would have to manually be adapted. For example you would have authors as "Danand Adrianna Wilson" which would need to be split into "Dan Wilson" and "Adrianna Wilson".

Once the data cleaning process was complete the system is now much easier to navigate, with sections used mostly by school teachers so they can search for books on particular topics, see which books illustrators have contributed to, who has written what, and so on.

A key accomplishment was using Drupal's Panels, mini-panels, views, and blocks in order to present one issue on one URL. By splitting the reviews into age-ranges, which was the one piece of data we knew site visitors would know about their intended audience, we were able to achieve this compact yet detailed design.

A second phase of the project saw a new front page created with a number of content queues created for content managers to easily highlight specific articles and reviews, along with links to the latest edition. The magazine recently stopped print publishing and the online version still receives ongoing praise from the industry and teachers, the main users of the website.