Entering Tournaments
As soon as we know the tournament dates in the fall and spring, we set up a webpage where people can choose which tournament they want to play in. We normally give one week for people to sign-up. I’ve observed that sending 2-3 reminder emails is very effective. After the deadline we meet to decide to which tournament send checks, form tentative teams for each one and assign a tournament captain.
FORMS HELP
MIT documentation in http://web.mit.edu/acserv/toolkit/advanced/scripts.shtml
INTERNAL DOCUMENTATION
/afs/athena.mit.edu/activity/w/wave/internal/TournamentSignupPaola07
INSTRUCTIONS
- Create an html file with a form (look at examples in directory, e.g. SignupsS07.html).
- Create a txt file that will process the html and send the email. You can use the automated script translate form:
- Using PINE set up a folder (e.g. ‘SignupsCV’) and a rule (filter) based on the email subject ’signupsCV’
- Create a folder -> from main menu, type L(list folder), go to pine folder list, type A(add folder) and the name (signupsCV)
- Create a filter -> from main menu, type S(Setup) type R(rules), F (filter), A(add). Give a nickname to the rule (signusCV) set the ‘Subject pattern’ to the subject (SignupsCV), scroll down until you find ====Action begins here=== and set Move , enter the name of the folder (SignupsCV)
- Open pine and make sure the emails have been transferred to the right folder. (This step has to be done every time you receive new mails, before processing them.)
- Use process-comments.pl to process the email. If you still don’t have the script, type:
- Once you have processed the data, to produce the new “tournaments.html” page you can use the excel file attached (SignupsSp07.xls) where the first sheet (SignupsSp07) contains the raw data. Sheet1 automatically process the raw data to get out the names of people who want to play. Sheet2 is a nicer formatting of Sheet1 (done manually, with copy and paste). Sheet3 creates the web page, using information from Sheet2 (copy and pasted there). You can then use the script tourney.m (in matlab, sorry this is the only language I can use!!) to create the page. As all of this is too geeky, please just contact me (pcappell@gmail.com) if you really want to use the system (I’m not even sure it’s faster than doing it manually) or just create a better way to handle it!!
-
%: add cwis
%: translateform foo.html foo.txt Notice that you’ll have to customize the txt file (mainly putting your email and a subject for the email -e.g. ’signupsCV’)
-
%: add cwis;
%: cp /mit/cwis/process/process-comments.pl process-comments.pl
Notice the scripts are in the main folders of the wave and chickvb directories.Then use the script as:
%: process-comments.pl ~/mail/signupsCV -o namefile.txt
The directory ~/mail/signupsCV has the same name of the folder where you are filtering the email. namefile.txt contains the processed data. You can open it with excel to obtain a spreadsheet.