Magazine Subscriptions Database

joomla.gif

The publishers of NZ Geographic Magazine were launching a new website and had organised most of their subscriptions system through Dioscouri. I was asked to work with their chap Jimmy Anderson, to convert their legacy records into the new Joomla PHP database

It has required a fair amount of detective work in a short time to deduce the intricate database architecture of the Dioscuri system, and to bend the legacy data to suit. For example, we had several years worth of records, thousands of transactions, which did not actually say what had been bought. Exactly the kind of challenge that I like. (And the cake was very welcome too, thanks!)

I also have found use for my experience at Google Geocoding, to write a small utility which helps clean up the (sometimes wayward) addresses from all around the world.

PHP, Joomla
Date: 2011

Top of page