Windows Server 2000/2003 Thread, MRBS Scripts in Technical; Hi all
I am trying to book periods into rooms with an SQL script into mrbs_entry for several different rooms ...
5th June 2009, 10:35 PM #1
I am trying to book periods into rooms with an SQL script into mrbs_entry for several different rooms for each term, so far I have managed to create scripts for each room that books the periods for the rooms for a whole week and that works great.
The problem I am having is that when I created the script for repeating the bookings into mrbs_repeat is that the script inserts ok and shows up in the query browser in the mrbs_repeat but it does not populate the rooms on the web interface.
I know that when you do repeat a booking on the web interface it makes two entries into the database one for mrbs_repeat and then in the mrbs_entry it creates entries depending on how many weeks you I have booked ahead.
So my question is really, has any one managed to figure out how to to create repeat bookings with a script that will work.
My setup is on a windows server 2003 I am not sure whether it will make any difference?
6th June 2009, 09:19 AM #2
I don't know anything about server scripting.
When I did it, I just created many single bookings since the "repeat" feature didn't really work for a 2 week timetable. I was trying to put our entire timetable for the whole school into MRBS so we could use it for booking any room or facility during or outside school hours.
My original post with the (Access) database that created all the entries for different dates is here.
It's certainly not perfect (or finished) but it worked for me and you may be able to build on it.
Thanks to NotSoFast from:
walkden-high (7th June 2009)
7th June 2009, 09:47 PM #3
Thanks for your feedback Simon what you have done so far looks good, you have obviously put a lot of time and effort in to it.
By mickeyh080 in forum Network and Classroom Management
Last Post: 21st June 2008, 04:05 PM
By Scotmk in forum Wireless Networks
Last Post: 27th March 2008, 08:34 AM
By SimpleSi in forum *nix
Last Post: 7th March 2008, 09:23 AM
By adamf in forum Network and Classroom Management
Last Post: 22nd April 2007, 09:48 PM
By j17sparky in forum Web Development
Last Post: 17th November 2006, 03:11 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread