[Web4lib] Room booking software

Thomas Bennett bennetttm at appstate.edu
Mon Jul 12 14:55:37 EDT 2010

We use a system I wrote to use with Google Calendars in python for Zope.

The request form python script checks the 4 Google Calendars for conflicts.  
First, the room calendar, then the Special Collections Hours calendar, then 
the Library Hours calendar, and last the Holiday Calendar.  This room is not 
available if Special Collections is closed.

  If there are no conflicts, the data goes into a postgresql database and an 
email is sent our approver with a brief summary and with a link the retrieves 
the the data into a WEB page.  The approver can click Approve or Not Approved.  
The approver may also change any data if need be, the data is brought up in a 
form just like the original request page except with the approval buttons.

  If the request is not approved then the requester is sent an email, there is 
an option to add additional information to that email, informing the requester 
the event is not approved.

If the request is approved then a boolean field in the database is updated to 
publish the event in Google Calendar.  Also, the room setup crew gets an email 
copy of the event and the event is copied to their Google Calendar which is on 
the student worker's machine (WEB desktop).  If the checkbox for room use 
instruction was checked, then another email goes out to the person responsible 
for training people how to use equipment in that room.

A python cron job running every 15 minutes checks the database for any new 
records that has the publish boolean equal to true for and reads each of those 
records from the database and publishes them to a Google Calendar.

And, I receive a copy of all the emails.

If you or anyone wants more particulars I will be glad to share the scripts 
and Zope information.  It is likely all of this can be done just with apache 
and python with the files I have and editing of course.


On Monday 12 July 2010 12:32:48 Lin Light wrote:
> Who is using what program to manage booking of auds,. and studyrooms?
> Lin
> Lin Light
> Head of Computer
>  & Technical Services
> Herrick District Library
> 300 South River Ave.
> Holland, MI 49423
> Voice 616-355-3727
> Fax   616-355-1426
> _______________________________________________
> Web4lib mailing list
> Web4lib at webjunction.org
> http://lists.webjunction.org/web4lib/

Thomas McMillan Grant Bennett           Appalachian State University
Operations & Systems Analyst            P O Box 32026
University Library                                Boone, North Carolina 28608
(828) 262 6587

Library Systems Help Desk: https://www.library.appstate.edu/help/

More information about the Web4lib mailing list