Above is an example of the Online Staffing Sheet in action. Names can be modified by typing in the fields. Hitting "Submit" automatically updates the storage directory.

Download

All relevant files are included in the staffingsheet.sit archive.

You also need the Text::Template, MailTools and TimeDate perl modules. (CPAN will query, download and build perl modules automatically)

Configuration

Configuring the staffing sheet is easy.

Front-end changes can be made to the table.html file, which stores the layout of the staffing sheet and is used to generate the database file. The table.html file uses some non-standard tags:

• \{ form(); \}
  Use this tag to start your form instead of the HTML <FORM> tag. (You should end the form with the normal </FORM> tag.)
• \{ inputbox("shift"); \}
  This tag specifies the name of a workshift, as in \{ inputbox("Door 1"); \}. The text enclosed in the tag is used as the workshift name, and is used to generate FORM INPUT fields by the shift.cgi program. Characters allowed within the tag include spaces, digits, and letters; however the tag cannot begin or end with a space. To ensure trouble-free use, please keep the tag on ONE line. For an example of intended use, check the source of table.html.
• \{ warnings(); \}
  If, during the time between when you load the form and when you submit your changes, one of the fields you are changing has been changed by someone else, your changes will not be accepted and a warning will be issued next to the input box for that field. You can use the \{ warnings(); \} tag to return a list of all warnings, so that you can locate them prominantly on the resulting page.
• Note: old-style <WORKSHIFT>shift</WORKSHIFT> tags can be converted to \{ inputbox("shift"); \} tags with the convert-template.pl program: ./convert-template.pl old-table-file.html >new-table-file.html.

Back-end configuration involves editing a few lines in the shift.cgi file. The $template_file variable must be set to the full path and name of the front-end table.html file. The $data_directory must be set to the full path and name of a directory where the data will be stored. If you want to enable the optional mail-notification feature (will send email to anyone who has their shift replaced if they included an email address), set the $mail_smtpserver variable to the name of an SMTP server which will relay your messages, set the $mail_from variable to the address you wish to appear in the From:, Sender: and Reply-To: headers, set the $mail_subject variable to the subject you wish to appear in the Subject: header, set the @mail_cc variable to any addresses you wish Cc:'ed, and set the $mail_footer variable to a message which will appear at the bottom of all warning messages.

###
# user-servicable parts
###

$template_file = '/home/ivan/staffsheet/table.html';
$data_directory = '/home/ivan/staffsheet/data';
$mail_smtpserver = 'localhost'; # set blank to disable
$mail_from = 'ivan-misconfigured-shift-from@420.am';
$mail_subject = 'Your shift has been replaced';
@mail_cc = (
  'ivan-misconfigured-shift-cc@420.am',
  'ivan-misconfigured-shift-cc2@420.am',
);
$mail_footer = <<END;

Sorry, I don't have any more information.  The person who installed the 
staff sheet didn't customize this message.

END

###
# end of user-servicable parts
###

Use

To use the files, install shift.cgi in a public web directory as a CGI program. (probably by placing it in a cgi-bin directory or using AddHandler). Permissions for all files must be set correctly. To make the shift.cgi excecutable, set its permissions to 755 (rwxr-xr-x):

chmod 755 shift.cgi

mkdir /path/to/data_dir

chown httpd /path/to/data_dir
chmod 755 /path/to/data_dir

Contact

Any questions or problems with the staffing sheet should be directed at mike@viberation.com or goolie@cloudfactory.org - We'd be happy to answer reasonable questions about the functions of the staffing list program.