From Cambridge University Caving Club - CUCC wiki
Jump to: navigation, search
(New page: 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. Po...)
 
(To do)
Line 31: Line 31:
 
:*Logbook view(s)
 
:*Logbook view(s)
 
:*QM list views
 
:*QM list views
 +
 +
*Import bits and bobs
 +
:*non-204 QMs

Revision as of 16:19, 5 July 2008

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