+ Post New Thread
Page 1 of 8 12345 ... LastLast
Results 1 to 15 of 106
Scripts Thread, SIMS to MRBS: Script Available in Coding and Web Development; IMPORTANT - The script has been updated, please jump to post 50 for the latest working version. The old attachment ...
  1. #1

    Join Date
    Aug 2009
    Posts
    7
    Thank Post
    0
    Thanked 6 Times in 4 Posts
    Rep Power
    0

    Thumbs up SIMS to MRBS: Script Available

    IMPORTANT - The script has been updated, please jump to post 50 for the latest working version.
    The old attachment has been removed to prevent confusion.

    Dear all,

    Please find attached to this thread a script allowing you to import your SIMS Room Timetable into MRBS, by exporting to CSV first.

    To Set Up:
    1. Place the PHP Script in the same folder as MRBS' config.inc.php
    2. Amend the PHP Script (see below)


    Amendments to make for your school:
    1. Room Names to ID Numbers (Script Lines 44-61, using mrbs_room table in database for reference)
    2. Default Entry Type for Booking, and an alternate entry type, along with which subjects to use this entry type for (Script Lines 17-19, using MRBS config.inc.php for reference)
    3. Your Periods/Break/Lunch system, as MRBS treats each period as a 'booking slot' and break/lunch as a 'booking slot', so Period 10 = 0 (first 'slot') + 1 (registration) + 9 (periods past) + 1 (break) + 1 (lunch) = Slot 12, see script lines 203-217 with longer explanation.


    Instructions for use:
    1. Export SIMS timetable for ONE ROOM using attached Report Definition
    2. Load PHP Script in Web Browser
    3. Fill out form, including File to Upload [Start/End Term Dates auto-suggested]
    4. Press Go.


    CSV File Notes (auto-setup in Report Definition though):
    1. ONE ROOM ONLY
    2. Order of Columns: Room, Day, Period, Class, Teacher, Subject Code, NoStudents
    3. Period should be defined as 'Mon:7' or 'Mon:07'


    Hope this helps!
    Last edited by vikpaw; 25th February 2013 at 05:26 AM. Reason: update notice | Reuploaded Attachment as Corrupted / Reuploaded under GPL

  2. 2 Thanks to McTedo:

    bonjour (7th September 2009), RobFuller (26th November 2009)

  3. #2

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,400
    Thank Post
    636
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319
    Hi Edward

    What licence have you released this under?

  4. #3

    Join Date
    Aug 2009
    Posts
    7
    Thank Post
    0
    Thanked 6 Times in 4 Posts
    Rep Power
    0
    Released under GPL - sorry, hadn't thought of this.
    Added GPL statements and copy to zip file.

  5. #4
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,994
    Thank Post
    120
    Thanked 279 Times in 257 Posts
    Rep Power
    106
    Very nice I will have a good look at this soon .

  6. #5

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,400
    Thank Post
    636
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319
    Thanks for updating Edward, greatly appreciated

  7. #6

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,644
    Thank Post
    858
    Thanked 645 Times in 428 Posts
    Rep Power
    498
    Tried this but my second line in the exported CSV file ws just:

    61,,,,,,,,

    Not sure if its jsut cos the timetable doesn't take effect until 3rd September so will try again next week...

  8. #7

    Join Date
    Aug 2009
    Posts
    7
    Thank Post
    0
    Thanked 6 Times in 4 Posts
    Rep Power
    0

    Bug Fix

    Bug Fix: Now allows lessons longer than 2 periods long; i.e. a triple or quadruple.
    Attached Files Attached Files

  9. #8

    Join Date
    Jul 2007
    Posts
    64
    Thank Post
    5
    Thanked 2 Times in 2 Posts
    Rep Power
    15
    Corrupt zip?

  10. #9

    Join Date
    Jul 2007
    Posts
    64
    Thank Post
    5
    Thanked 2 Times in 2 Posts
    Rep Power
    15
    S'OK. Extracted fine with WinRAR.

  11. #10

    Join Date
    Jul 2007
    Posts
    64
    Thank Post
    5
    Thanked 2 Times in 2 Posts
    Rep Power
    15
    The contents of the compressed archive is a single file, 'SIMStoMRBS', which has no file extension and opens as gobbeldygook.

    Little help??

  12. #11

    Join Date
    Aug 2009
    Posts
    7
    Thank Post
    0
    Thanked 6 Times in 4 Posts
    Rep Power
    0
    Downloads fine for me in Firefox, but not in IE!

  13. #12

    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,381
    Thank Post
    181
    Thanked 211 Times in 171 Posts
    Rep Power
    65
    Quote Originally Posted by bonjour View Post
    The contents of the compressed archive is a single file, 'SIMStoMRBS', which has no file extension and opens as gobbeldygook.

    Little help??
    Download with wget/download manager? Contents should be :

    Code:
    #  Archive C:\SIMStoMRBS(1-0-1).zip
    2009-09-04 10:25          9645          3719  bulkYearMake.php
    2009-08-25 14:43         35147         12112  gpl.txt
    2009-08-25 11:18          4279          4272  Room Timetables.RptDef
    #
    # Total                   Size        Packed  Files
    #                        49071         20103  3

  14. #13

    Join Date
    Jul 2007
    Posts
    64
    Thank Post
    5
    Thanked 2 Times in 2 Posts
    Rep Power
    15
    Works fine through Firefox.

    Pesky IE8...

    Cheers guys.

  15. #14

    Join Date
    Jul 2007
    Posts
    64
    Thank Post
    5
    Thanked 2 Times in 2 Posts
    Rep Power
    15
    Sorry, two quick questions..

    1. Do the room names ID Numbers on lines 44+ have to match exactly with the names and numbers in the MRBS_room table?
    2. Does a room name / number entry have to be created for every bookable item in MRBS? We have some equipment on there that we obviously don't have a timetable for.

    Cheers.

  16. #15

    Join Date
    Aug 2009
    Posts
    7
    Thank Post
    0
    Thanked 6 Times in 4 Posts
    Rep Power
    0
    @bonjour:

    1. Names don't need to match, ID numbers do. (e.g. Sims knows one of our rooms as 'CON', and the name of the room in MRBS is 'Connexions'. The ID number to convert CON into must be the same as in the mrbs_room table.

    2. No; just the ones you are going to import with the script.

    Hope this helps!

  17. Thanks to McTedo from:

    bonjour (7th September 2009)

SHARE:
+ Post New Thread
Page 1 of 8 12345 ... LastLast

Similar Threads

  1. Exporting SIMS timetable into MRBS
    By amvc in forum MIS Systems
    Replies: 2
    Last Post: 29th July 2009, 04:25 PM
  2. Changing passwords for SIMS users by script
    By academic_mwnci in forum MIS Systems
    Replies: 2
    Last Post: 3rd September 2008, 12:02 AM
  3. SIMs backup script after SQL 2005 migration failing...
    By mullet_man in forum MIS Systems
    Replies: 13
    Last Post: 23rd November 2007, 06:03 PM
  4. MRBS help
    By niknik in forum Web Development
    Replies: 0
    Last Post: 29th August 2007, 03:00 PM
  5. SIMS update script
    By nicholab in forum MIS Systems
    Replies: 1
    Last Post: 27th April 2007, 08:17 AM

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
  •