From Cambridge University Caving Club - CUCC wiki
Jump to: navigation, search
 
(7 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 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/
<table border="1">
+
 
 +
Note that the information there is incomplete and editing is not yet enabled.
 +
 
 +
<table border="1" cellspacing="0">
 +
 
 
   <tr>
 
   <tr>
 
     <th><p>Feature</p></th>
 
     <th><p>Feature</p></th>
Line 8: Line 12:
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
     <td><p>Cave stats generated from survex file</p></td>
+
    <td><p>Logbook</p></td>
 +
    <td><p>Yes; manually formatted each year</p></td>
 +
    <td><p>Yes; wiki-style</p></td>
 +
    <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>
 +
  </tr>
 +
  <tr>
 +
     <td><p>Cave index and stats generated from survex file</p></td>
 
     <td><p>Yes</p></td>
 
     <td><p>Yes</p></td>
 
     <td><p>Yes</p></td>
 
     <td><p>Yes</p></td>
     <td><p>Done</p></td>
+
     <td><p>Done; see [http://troggle.cavingexpedition.com//cave] </p></td>
 +
  </tr>
 +
  <tr>
 +
    <td><p>Survey workflow helper</p></td>
 +
    <td><p>Yes; minimal. surveys.csv produced an html table of whose surveys were not marked “finished”</p></td>
 +
    <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>
 +
    <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>
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 17: Line 33:
 
     <td><p>Depends on the cave. Each cave had a different system.</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>Yes; unified system.</p></td>
     <td><p>Done, but only 204 and 234 Qms have been imported from old system so far.</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>
 
   <tr>
 
   <tr>
Line 23: Line 45:
 
     <td><p>No</p></td>
 
     <td><p>No</p></td>
 
     <td><p>Yes</p></td>
 
     <td><p>Yes</p></td>
     <td><p><br />
+
     <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>
 
     </p></td>
 
   </tr>
 
   </tr>
Line 30: Line 52:
 
     <td><p>Yes, manually html coded.</p></td>
 
     <td><p>Yes, manually html coded.</p></td>
 
     <td><p>Yes, wiki-style.</p></td>
 
     <td><p>Yes, wiki-style.</p></td>
     <td><p><br />
+
     <td><p>Not done yet.<br />
 
     </p></td>
 
     </p></td>
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
 
     <td><p>Expo handbook</p></td>
 
     <td><p>Expo handbook</p></td>
 +
    <td><p>Yes, manually html coded.<br />
 +
    </p>Maybe. Needs to be discussed further.</td>
 
     <td><p><br />
 
     <td><p><br />
 
     </p></td>
 
     </p></td>
    <td><p><br />
+
     <td><p>Not done yet.</p></td>
    </p></td>
 
     <td><p>Not yet</p></td>
 
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 45: Line 67:
 
     <td><p>Yes</p></td>
 
     <td><p>Yes</p></td>
 
     <td><p>Yes</p></td>
 
     <td><p>Yes</p></td>
     <td><p>Done</p></td>
+
     <td><p>Data has been parsed, this view hasn't been written yet. </p></td>
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
     <td><p>Automatic calendar for each year of who will be on expo when</p></td>
+
     <td><p>Signup form, System for keeping contact, medical and next of kin info</p></td>
    <td><p>No, manually produced some years</p></td>
 
    <td><p>Yes</p></td>
 
    <td><p>Mostly done</p></td>
 
  </tr>
 
  <tr>
 
    <td><p>System for keeping contact, medical and next of kin info</p></td>
 
 
     <td><p>No</p></td>
 
     <td><p>No</p></td>
 
     <td><p>Yes</p></td>
 
     <td><p>Yes</p></td>
     <td><p>Not yet</p></td>
+
     <td><p>Signup form should be ready by 20 Jan.</p></td>
  </tr>
 
  <tr>
 
    <td><p>Survey workflow helper</p></td>
 
    <td><p>Yes; minimal. surveys.csv produced an html table of whose surveys were not marked “finished”</p></td>
 
    <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>
 
    <td><p>Survex, scanner, and tunnel integration still needs doing.</p></td>
 
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 69: Line 79:
 
     <td><p>No; some manual photo galleries put together with lots of effort</p></td>
 
     <td><p>No; some manual photo galleries put together with lots of effort</p></td>
 
     <td><p>Yes</p></td>
 
     <td><p>Yes</p></td>
     <td><p>Photo upload done, gallery needs writing</p></td>
+
     <td><p>Photo upload done, gallery needs writing.</p></td>
  </tr>
 
  <tr>
 
    <td><p>Logbook</p></td>
 
    <td><p>Yes; manually formatted each year</p></td>
 
    <td><p>Yes; wiki-style</p></td>
 
    <td><p>Done</p></td>
 
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 81: Line 85:
 
     <td><p>No</p></td>
 
     <td><p>No</p></td>
 
     <td><p>Yes</p></td>
 
     <td><p>Yes</p></td>
     <td><p>Done</p></td>
+
     <td><p></p></td>
 
   </tr>
 
   </tr>
 
</table>
 
</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