+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1
    walkden-high's Avatar
    Join Date
    May 2009
    Location
    salford- manchester
    Posts
    29
    Thank Post
    6
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Post MRBS Scripts

    Hi all

    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?

    Thanks

    J


  2. #2

    Join Date
    Jan 2008
    Posts
    100
    Thank Post
    6
    Thanked 18 Times in 14 Posts
    Rep Power
    17
    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.

    Simon

  3. Thanks to NotSoFast from:

    walkden-high (7th June 2009)

  4. #3
    walkden-high's Avatar
    Join Date
    May 2009
    Location
    salford- manchester
    Posts
    29
    Thank Post
    6
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Thumbs up MRBS Scripts

    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.

SHARE:
+ Post New Thread

Similar Threads

  1. MRBS Help
    By mickeyh080 in forum Network and Classroom Management
    Replies: 4
    Last Post: 21st June 2008, 04:05 PM
  2. MRBS Help
    By Scotmk in forum Wireless Networks
    Replies: 5
    Last Post: 27th March 2008, 08:34 AM
  3. Help running scripts within scripts
    By SimpleSi in forum *nix
    Replies: 7
    Last Post: 7th March 2008, 09:23 AM
  4. MRBS Help!
    By adamf in forum Network and Classroom Management
    Replies: 1
    Last Post: 22nd April 2007, 09:48 PM
  5. MRBS
    By j17sparky in forum Web Development
    Replies: 6
    Last Post: 17th November 2006, 03:11 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •