These are nerd-instructions. Find a nerd if you think this needs to be done.
This is part of the "new expo year" preparations.
The folk.csv file is stored on the server under version control in the :expoweb: repository in
expoweb/folk/folk.csv
Note that this area is subject to a redesign proposal.
Before expo starts the folk.csv file is updated.
Edit folk/folk.csv, adding the new year to the end of the header line, a new column, with just a comma (blank cell) for people who weren't there, a 1 for people who are there, and a -1 for people who are there but didn't go caving. This is adding an extra column to every line in the file.
Add new lines for new people, with the right number of columns.
This process is tedious and error-prone and ripe for improvement especially as expo proceeds and you have many more names to add. Adding a list of people from the bier book and their aliases (the name in brackets) would be a lot better, but some way to make sure that names match with previous years would be good.
Contrary to what you might expect we find that it is much more reliable to edit this using a text editor rather than a spreadsheet program.
The nerd can log in using the 'expo' userid.
The nerd needs to do this:
This is how you login and run the script:
ssh expo@expo.survex.com
cd expoweb/folk
chmod +w index.htm
python3 ../scripts/make-folklist.py <folk.csv >index.htm
If there are no errors, you will just see the prompt reappear in your ssh session and you will see the result online at http://expo.survex.com/folk/.
It is recommended that the nerd does this locally on their own laptop first. It does not need to be an expo laptop, even a Windows 10 laptop is fine if the script is run in a WSL terminal. The only software you need to install is the default python package.
In the folk.csv file is a field which is typically either "i/john-mugshot.jpg" or "l/john-bio.html". If it is an HTML file, then that file can contain links to several photos as well as containing biographical details: roles in organising expos, CUCC committee positions etc.
There is an example template for this biog file in folk/l/_template.html which shows you how to use the HTML idioms for figures and captions in the context of a troggle page. This bio is viewed by clicking on the person's name in the folk page, but is also copied and displayed as part of the troggle page on the person which includes the list of survex files and logbook entries they appear in.
The script and CSV file also have a README.txt file in the folk folder which contains more detailed coding notes re interactions with other troggle code.
This bizarre Folk update process is a relic of the pre-troggle "script and spreadsheet" phase of the Expo website. Another relic is the complex QM process. All these will eventually be merged into troggle - we hope. At the moment (July 2023), it is not run by a database reset and must be done manually.