Troggle

Troggle is a system under development for keeping track of all expo data in a logical and easily accessible way, and displaying it on the web.

It uses Django and a Postgresql database. Potentially, it could replace the old system of csv files and scripts which produce the expo website.

Current status

There's a preview and testing period going on. Go to aarongcurtis.com/admin to try it out. Ask aaron for username and password. Please mess around and try to break it- the database will

Done so far

• Necessary django data models written

• Expos
• Caves
• Entrances
• Cavers
• Trips
• QMs

• Import scripts from the old csv files

• cavetabReader.py imports caves from CAVETAB2.CSV
• tripReader.py imports logbook entries from the format used on this wiki
• folkReader.py imports people from the old folk.csv file
• 204qmReader.py imports the qm csv tabe from 204.
• makeExpos.py simply creates expos for 1976 to present, skipping 1986

• The beginnings of templates / views written

• Who was on which expo table
• Main cave index

To do

• The rest of the templates / views

• Individual cave template / view
• Logbook view(s)
• QM list views

• Import bits and bobs

• non-204 QMs