[Web4lib] Room reservation program or scripts

[John Bickar]

Hi Glenn,

I'm CCing the Web4Lib list as well.

In response to another question I got about this off-list, we're using 
the following Drupal modules for this system:
Calendar
CCK
Date
Views

We're also using the Validation API Drupal module 
<http://drupal.org/project/validation_api> to do some rudimentary form 
validation. (See http://pastebin.com/r6VhrErt for an example of 
excluding Saturday as an allowed day for reservations, and 
http://pastebin.com/Zb0GfbrT for an example of excluding our 
regularly-closed hours Sun-Fri.)

You could certainly use the Validation API to restrict bookings as you 
describe below. In our case, I didn't spend a lot of time developing 
extensive validation rules because we only allow authenticated users to 
make bookings, and we (as staff) can take a look at the schedule and 
make sure no one is scheduling on top of one another (users are not able 
to delete others' reservations).

With the low amount of use we've had so far, it didn't make sense to 
spend a lot of time developing exclusions for all the permutations of 
hours we're open/closed during holidays, intersessions, summer session, 
etc. Sometimes social solutions are simpler than technological ones :)

-John Bickar
Stanford University Libraries

Glenn Haya wrote:
> Hi John,
> 
> I am a librarian at a university library in Stockholm and we want to implement a group room booking system on our new drupal website.  A colleague forwarded me this post you made on the listserv Web4lib and I really like the booking solution you have there.
> 
> What I am wondering about is we have certain limitations that we want to place on the bookings, for example that a student can book max 2 times in a week and each booking can be for max 2 hours.
> 
> Do you have any kind of limitations like that on your booking system?  If so can you explain a little how you worked that in.  Was it something you wrote yourself?
> 
> Thanks a lot in advance for your help.
> 
> Glenn Haya
> Librarian
> Karolinska Institutets University Library
> 
> -----Original Message-----
> From: web4lib-bounces at webjunction.org [mailto:web4lib-bounces at webjunction.org] On Behalf Of John Bickar
> Sent: den 20 februari 2010 02:46
> To: Gerry O. Laroza; web4lib at webjunction.org
> Subject: Re: [Web4lib] Room reservation program or scripts
> 
> Hi Gerry,
> 
> We are doing this with our Instruction Room in Drupal:
> 
> http://www.stanford.edu/group/cubberley/services/instruction_room
> 
> (Sorry, you need a Stanford ID to actually log in and make a reservation, but I'm attaching a screenshot of the reservation form.)
> 
> I also looked at phpScheduleIt, which is free and runs on LAMP, but the learning curve for me was shorter in Drupal.
> 
> -John Bickar
> Cubberley Education Library
> Stanford University
> 
> 
> on 2/19/10 5:10 PM, Gerry O. Laroza at glaroza at ateneo.edu wrote:
> 
>> Hi All,
>>
>> We are managing four multimedia rooms and we would like to let the 
>> faculty reserve the rooms online. I've seen DIGIREZ but it is too 
>> costly for us. Is there any free scripts or program that will do the 
>> same?
>>
>> Thank you,
>>
>> Gerry O. Laroza
>> Computer & Audio-visual Section
>> Rizal Library
>> Ateneo de Manila University
>>
>> "Hardwork is useless, unless appreciated!"
>>
>>
>>
>> _______________________________________________
>> Web4lib mailing list
>> Web4lib at webjunction.org
>> http://lists.webjunction.org/web4lib/
>>
>