+ Post New Thread
Results 1 to 7 of 7
Network and Classroom Management Thread, MRBS and Facility CMIS in Technical; Hi everyone. I've got loads of help over the last few months reading through the forums, especially with regard to ...
  1. #1

    Join Date
    Jan 2008
    Posts
    120
    Thank Post
    6
    Thanked 19 Times in 15 Posts
    Rep Power
    17

    MRBS and Facility CMIS

    Hi everyone. I've got loads of help over the last few months reading through the forums, especially with regard to room booking systems. I've done a lot of work getting MRBS set up and working, and now just need to solve a couple more problems before we adopt it as our school system.

    a) It would be great to be reassured that lots of schools are using this as a "robust" solution for room booking. We plan to use it for all our bookings: ICT rooms, study spaces, room changes, lettings etc etc, so it has to be solid. If you're using it in that sort of capacity I'd love to know how reliable you've found it and any issues that you've picked up.

    b) We use Serco's Facility CMIS MIS. I've developed a process using Access to take a CSV of the timetable from CMIS and output a text file for MRBS. This works, but it's clunky. Has anyone found a better way? Would anyone like to have a look at what I've done so you can use it/improve it?

    Thanks in advance,

    Simon.

  2. #2
    ricki's Avatar
    Join Date
    Jul 2005
    Location
    uk
    Posts
    1,477
    Thank Post
    20
    Thanked 164 Times in 157 Posts
    Rep Power
    52
    MRBS is quite reliable. I have been using it for a bit now and the only problem I have is people booking rooms and then not using them. The main room booking for the school when setting up the timetable is done on sims and I have not found a way to transfer the data from one to the other as smoothly as you have so congratulations on that.

    If anyone does know a way to transfer room booking from sims thats on the admin network to mrbs could you let me know at the moment we enter them by hand every half term.

    Thanks for all your help.

    Richard

  3. #3
    budgester's Avatar
    Join Date
    Jan 2006
    Location
    Enfield, Middlesex
    Posts
    486
    Thank Post
    4
    Thanked 38 Times in 30 Posts
    Rep Power
    24
    [QUOTE=NotSoFast;145633]
    b) We use Serco's Facility CMIS MIS. I've developed a process using Access to take a CSV of the timetable from CMIS and output a text file for MRBS. This works, but it's clunky. Has anyone found a better way? Would anyone like to have a look at what I've done so you can use it/improve it?
    [QUOTE]

    Hi,

    This sounds interesting, I am connecting to CMIS using php and odbc and would like to have a look at your solution.

    Regards

    Budgester

  4. #4
    Sirbendy's Avatar
    Join Date
    Nov 2005
    Posts
    2,298
    Thank Post
    8
    Thanked 203 Times in 154 Posts
    Rep Power
    111
    We use MRBS as well for ICT suite bookings and resource booking. Standalone though.

    Rock solid to date..minor bug in the last version, but the programmer is very helpful.

  5. #5

    Join Date
    Jan 2008
    Posts
    120
    Thank Post
    6
    Thanked 19 Times in 15 Posts
    Rep Power
    17
    @ Budgester: I'll look at posting what I have when I get back to work next week. I have a Word file of "instructions" I wrote to help me remember what I did, plus the Access database itself. It's quite a large file though so I'm not sure if I'll be able to post it here. I suppose I'd better change names etc as well.

    Thank you to everyone else for your responses.

  6. #6

    Join Date
    Jan 2008
    Posts
    120
    Thank Post
    6
    Thanked 19 Times in 15 Posts
    Rep Power
    17

    CMIS to MRBS - my clunky solution

    OK, attached you should find a zip file with my Access file and a Word file I wrote (to myself!) as I went along. I know it's not amazingly clear, but I haven't had time to update it for general consumption. I've removed a lot of the records from the "ready for import" table as there were over 60,000 and that made the file too big to upload here.

    The main things I learned from my research were:
    • An MRBS_entry record uses the UNIX timestamp (ie. no of seconds since 1/1/1970) to store times.
    • If you are using the periods feature of MRBS, times are stored as 12:00, 12:01, 12:02 etc for that date.
    • You have to allow for BST/GMT


    So my database creates a unique record for each instance of a lesson (not just the lesson slot itself), adds the extra fields required by MRBS, matches the CMIS room to the MRBS room ID and converts the date and time fields exported by CMIS into a UNIX timestamp value.

    Anyone is welcome to use/adapt this for their own ends, but please do share any improvements you make.

    Thanks,

    Simon
    Attached Files Attached Files

  7. Thanks to NotSoFast from:

    amvc (30th July 2009)

  8. #7

    Join Date
    Jan 2008
    Location
    Watford, Hertfordshire, UK.
    Posts
    14
    Thank Post
    16
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi,

    I have just started working for a Comprehensive School in East London as a VLE administrator and I need to find out what CMIS stands for, as we are currently using this system or any good links to further explain?

    Also, is anyone any good at using Microsoft Sharepoint, as this is the VLE I will be using.

    Thanks,
    Gary.



SHARE:
+ Post New Thread

Similar Threads

  1. ePortal / Facility / CMIS
    By daveyboy in forum MIS Systems
    Replies: 2
    Last Post: 9th October 2007, 08:13 PM
  2. Facility CMIS on Citrix
    By CyberNerd in forum Thin Client and Virtual Machines
    Replies: 6
    Last Post: 19th July 2007, 04:25 PM
  3. Serco CMIS Facility
    By bursar in forum MIS Systems
    Replies: 11
    Last Post: 22nd May 2007, 05:36 PM
  4. Serco CMIS Facility and Groupcall
    By nigelp in forum MIS Systems
    Replies: 3
    Last Post: 27th February 2007, 01:25 PM
  5. Facility CMIS 2.8 build 34
    By CheeseDog in forum MIS Systems
    Replies: 58
    Last Post: 14th February 2007, 01:25 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
  •