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...)
 
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
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.
+
Troggle is a system under development for keeping track of all expo data in a logical and accessible way, and displaying it on the web. At the moment, it is under development at http://troggle.cavingexpedition.com/
  
It uses Django and a Postgresql database. Potentially, it could replace the old system of csv files and scripts which produce the expo website.  
+
Note that the information there is incomplete and editing is not yet enabled.
  
==Current status==
+
<table border="1" cellspacing="0">
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==
+
  <tr>
*Necessary django data models written
+
    <th><p>Feature</p></th>
:*Expos
+
    <th><p>Old expo website</p></th>
:*Caves
+
    <th><p>Troggle: planned</p></th>
:*Entrances
+
    <th><p>Troggle: progress so far</p></th>
:*Cavers
+
  </tr>
:*Trips
+
  <tr>
:*QMs
+
    <td><p>Logbook</p></td>
 
+
    <td><p>Yes; manually formatted each year</p></td>
*Import scripts from the old csv files
+
    <td><p>Yes; wiki-style</p></td>
:*cavetabReader.py imports caves from CAVETAB2.CSV
+
    <td><p>Start at the front page, [http://troggle.cavingexpedition.com/] and click to logbook for year. The logbooks have been parsed back to 1997. </p></td>
:*tripReader.py imports logbook entries from the format used on this wiki
+
  </tr>
:*folkReader.py imports people from the old folk.csv file
+
  <tr>
:*204qmReader.py imports the qm csv tabe from 204.
+
    <td><p>Cave index and stats generated from survex file</p></td>
:*makeExpos.py simply creates expos for 1976 to present, skipping 1986
+
    <td><p>Yes</p></td>
 
+
    <td><p>Yes</p></td>
*The beginnings of templates / views written
+
    <td><p>Done; see [http://troggle.cavingexpedition.com//cave] </p></td>
:*Who was on which expo table
+
  </tr>
:*Main cave index
+
  <tr>
 
+
    <td><p>Survey workflow helper</p></td>
==To do==
+
    <td><p>Yes; minimal. surveys.csv produced an html table of whose surveys were not marked “finished”</p></td>
*The rest of the templates / views
+
    <td><p>Yes. Makes table of surveys per expo which shows exactly what needs doing. Displays scans. Integrated with survex, scanner software, and tunnel.</p></td>
:*Individual cave template / view
+
    <td><p>See it at http://troggle.cavingexpedition.com/survey . Be sure to try a recent year when we should have data. Survex, scanner, and tunnel integration still needs doing.</p></td>
:*Logbook view(s)
+
  </tr>
:*QM list views
+
  <tr>
 +
    <td><p>QM lists generated automatically</p></td>
 +
    <td><p>Depends on the cave. Each cave had a different system.</p></td>
 +
    <td><p>Yes; unified system.</p></td>
 +
    <td><p>Done, but only 204 and 234 Qms have been imported from old system so far. No view yet.</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td><p>Automatic calendar for each year of who will be on expo when</p></td>
 +
    <td><p>No, manually produced some years</p></td>
 +
    <td><p>Yes</p></td>
 +
    <td><p>Done; see http://troggle.cavingexpedition.com/calendar/2007 (replace 2007 with year in question)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td><p>Web browser used to enter data</p></td>
 +
    <td><p>No</p></td>
 +
    <td><p>Yes</p></td>
 +
    <td><p>Everything can be edited through admin, at http://troggle.cavingexpedition.com/admin  . Ask aaron, martin, or julian for the password if you want to have a look / play around with the admin site. Any changes you make will be overwritten. Eventually, data entry will probably be done using custom forms.
 +
    </p></td>
 +
  </tr>
 +
  <tr>
 +
    <td><p>Cave and passage descriptions</p></td>
 +
    <td><p>Yes, manually html coded.</p></td>
 +
    <td><p>Yes, wiki-style.</p></td>
 +
    <td><p>Not done yet.<br />
 +
    </p></td>
 +
  </tr>
 +
  <tr>
 +
    <td><p>Expo handbook</p></td>
 +
    <td><p>Yes, manually html coded.<br />
 +
    </p>Maybe. Needs to be discussed further.</td>
 +
    <td><p><br />
 +
    </p></td>
 +
    <td><p>Not done yet.</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td><p>Table of who was on which expo</p></td>
 +
    <td><p>Yes</p></td>
 +
    <td><p>Yes</p></td>
 +
    <td><p>Data has been parsed, this view hasn't been written yet. </p></td>
 +
  </tr>
 +
  <tr>
 +
    <td><p>Signup form, System for keeping contact, medical and next of kin info</p></td>
 +
    <td><p>No</p></td>
 +
    <td><p>Yes</p></td>
 +
    <td><p>Signup form should be ready by 20 Jan.</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td><p>Automated photo upload and gallery</p></td>
 +
    <td><p>No; some manual photo galleries put together with lots of effort</p></td>
 +
    <td><p>Yes</p></td>
 +
    <td><p>Photo upload done, gallery needs writing.</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td><p>Search</p></td>
 +
    <td><p>No</p></td>
 +
    <td><p>Yes</p></td>
 +
    <td><p></p></td>
 +
  </tr>
 +
</table>

Latest revision as of 02:05, 1 April 2011

Troggle is a system under development for keeping track of all expo data in a logical and accessible way, and displaying it on the web. At the moment, it is under development at http://troggle.cavingexpedition.com/

Note that the information there is incomplete and editing is not yet enabled.

Feature

Old expo website

Troggle: planned

Troggle: progress so far

Logbook

Yes; manually formatted each year

Yes; wiki-style

Start at the front page, [1] and click to logbook for year. The logbooks have been parsed back to 1997.

Cave index and stats generated from survex file

Yes

Yes

Done; see [2]

Survey workflow helper

Yes; minimal. surveys.csv produced an html table of whose surveys were not marked “finished”

Yes. Makes table of surveys per expo which shows exactly what needs doing. Displays scans. Integrated with survex, scanner software, and tunnel.

See it at http://troggle.cavingexpedition.com/survey . Be sure to try a recent year when we should have data. Survex, scanner, and tunnel integration still needs doing.

QM lists generated automatically

Depends on the cave. Each cave had a different system.

Yes; unified system.

Done, but only 204 and 234 Qms have been imported from old system so far. No view yet.

Automatic calendar for each year of who will be on expo when

No, manually produced some years

Yes

Done; see http://troggle.cavingexpedition.com/calendar/2007 (replace 2007 with year in question)

Web browser used to enter data

No

Yes

Everything can be edited through admin, at http://troggle.cavingexpedition.com/admin . Ask aaron, martin, or julian for the password if you want to have a look / play around with the admin site. Any changes you make will be overwritten. Eventually, data entry will probably be done using custom forms.

Cave and passage descriptions

Yes, manually html coded.

Yes, wiki-style.

Not done yet.

Expo handbook

Yes, manually html coded.

Maybe. Needs to be discussed further.


Not done yet.

Table of who was on which expo

Yes

Yes

Data has been parsed, this view hasn't been written yet.

Signup form, System for keeping contact, medical and next of kin info

No

Yes

Signup form should be ready by 20 Jan.

Automated photo upload and gallery

No; some manual photo galleries put together with lots of effort

Yes

Photo upload done, gallery needs writing.

Search

No

Yes