Online Resource Booking System

[SimpleSi]

One of my primary schools has an e-learning centre so that Year6/7 children can come and use the school ICT facilites after school for homework.

 

Booking these facilities by phone is causing some problems and he'd like an online resource booking system. E.g parents logon the previous evening or during the day and book their child in for that day.

 

Does anyone use any such system or know of one that could be used for this purpose.

 

I think our LEA can provide us with PHP/SQL facilities ( I just know these buzzwords - I don't know what they are and Dos-box is always telling me just to ask and I will receive ) so it wouldn't cost us anything to host something.

 

regards

 

Simon

[Ric_]

@SimpleSi: MRBS could probably be used with a couple of very basic tweaks. I assume that you book the individual computers out so you could replace the word Room with Computer and authenticate against either a basic database or simply set up the logins in the config file.

 

There's a few of us that use MRBS for booking out computer suites so we can help with any probs.

[wesleyw]

Yeah we use it here I set it up for this September and it's been a big hit!

 

The only trouble is the bloody way our timetable works on a 2 week rota and which week it will be after each half or full term lol. But MRBS is excellent!

 

Wes

[Ric_]

@wesleyw: Should not effect Si since it will simply be 1 block for each PC after school each day.

[plexer]

wesleyw: We have the exact same issue. 2 Week timetable then a holiday throws the whole thing out so I do the bookings for half a term at a time and then you get the clever dick teacher who books more in advance.

 

Will have to see if I can restrict that would be great to be able to insert holidays etc... and have it automatically move the bookings forward

 

Ben

[ChrisH]

I posted some code in the scripts forum a while ago to let you limit the days ahead people could book on MRBS. That could solve one of your issues.

[wesleyw]

I changed part of the code because it booked until 2010, I know someone would book a year in advance if they could! lol

 

I'll have to look out for that then Chris.

 

Thanks

 

Wes

[ChrisH]

Post is here: http://edugeek.net/index.php?name=Forums&file=viewtopic&t=357

 

Ive not had any issues with it so far since August.

[SimpleSi]

Thanks for info - the webmaster at Lancs is setting up a database for me - so I;ll be back shortly asking the really stupid questions - like how do you switch it on

 

regards

 

Simon

[u8dmtm]

It may be too late to post this but here goes anyway. We use a home-grown ASP/SQL solution which suits us. However another school in our LEA uses OARBS - which is a free online booking system:

 

http://www.oarbs.com/

[webman]

We use OARBS as well, you may notice that my place of employment is also mentioned on the OARBS front page (not me )

[SimpleSi]

@webman

This looks great for the simple task we need it for- but why/how is it free = what's your involvement?

 

regards

Simon

[Grommit]

It may be too late to post this but here goes anyway. We use a home-grown ASP/SQL solution which suits us. However another school in our LEA uses OARBS - which is a free online booking system:

 

Welcome to OARBS Software Corporation: Resource Management Systems and Print Auditing Software

 

Can't seem to find a download link for this ?

[Grommit]

Where is the installation documentation for MRBS as it doesn't work on my XP PC... ?

[Marci]

The only trouble is the bloody way our timetable works on a 2 week rota and which week it will be after each half or full term lol.

Should be able to nudge all entries + or - 7 days to move it into line after holidays with a MySQL query... add 604800 to start and end times (and end date for repeat table) to move it forward 7 days. subtract to move it back 7 days on both the entry and repeat tables. Should be able to script it with php somewhere to do it at push of a button. Haven't done it meself yet but it's on my list of things to do as they've decided to collapse timetable for an intensive study week first week back after half term, and am unsure where it lands us in terms of week1 or week2 when things get back to normal.

 

EDIT: change mrbs_entry and mrbs_repeat to match your table names.

 

UPDATE mrbs_entry SET `start_time`=`start_time`+604800,`end_time`=`end_time`+604800

UPDATE mrbs_repeat SET `start_time`=`start_time`+604800,`end_time`=`end_time`+604800,`end_date`=`end_date`+604800

 

Run those on your MySQL database to shift everything forward one week.

 

 

UPDATE mrbs_entry SET `start_time`=`start_time`-604800,`end_time`=`end_time`-604800

UPDATE mrbs_repeat SET `start_time`=`start_time`-604800,`end_time`=`end_time`-604800,`end_date`=`end_date`-604800

 

Run those to shift everything back a week.

Edited October 29, 2008 by Marci