McTedo

Before School = Slot 0 Period 1 = Slot 1 Period 2 = Slot 2 Period 3 = Slot 3 Period 4 = Slot 4 Lunch = Slot 5 Period 5 = Slot 6 After School = Slot 7. You need some sort of code that manages the period number and adds one; e.g. if(substr($period[$item],4,2) == "Rg"){ $pmrbs = 0; } else { $pmrbs = (int)substr($period[$item],4,2); if($pmrbs >= 5){$pmrbs += 1;} } i.e. If the Period >= 5, then Add 1 to make the Slot Number correct.

The attached KIX script can be run during your logoff procedure to check if a user has left any USB Mass Storage devices plugged into the computer. This includes USB Sticks! Although devices such as USB CD/DVD drives will not be detected, USB Card Readers will be picked up. This is by design (for us at least), as Card Readers here are loaned from the IT Dept so on logoff need to be returned. Some Internal Card Readers are connected by a motherboard Internal USB connection and appear as USB Card Readers; these need to be added to the exemptions list in the script. e.g. ; Insert device IDs here for devices which are permanently attached to a computer DIM $Exemptions[3] $Exemptions[0] = "&VEN_TEAC&PROD_USB___HS-CF_CARD&" ; Internal card reader for Dell OptiPlex 740 $Exemptions[1] = "&VEN_TEAC&PROD_USB___HS-MS_CARD&" ; Internal card reader for Dell OptiPlex 740 $Exemptions[2] = "&VEN_TEAC&PROD_USB___HS-SD_CARD&" ; Internal card reader for Dell OptiPlex 740 $Exemptions[3] = "&VEN_TEAC&PROD_USB___HS-XD/SM&" ; Internal card reader for Dell OptiPlex 740 If amending this list don't forget to change the Variable Declaration! To find the device id to be added to the exemptions list, check Device Manager > (a Device) > Details > Device Instance ID. Enjoy! (Released under GPL). CheckForUSBStorage.zip

@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!

Downloads fine for me in Firefox, but not in IE!

Bug Fix: Now allows lessons longer than 2 periods long; i.e. a triple or quadruple.SIMStoMRBS(1-0-1).zip

Released under GPL - sorry, hadn't thought of this. Added GPL statements and copy to zip file.

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: Place the PHP Script in the same folder as MRBS' config.inc.php Amend the PHP Script (see below) Amendments to make for your school: Room Names to ID Numbers (Script Lines 44-61, using mrbs_room table in database for reference) 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) 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: Export SIMS timetable for ONE ROOM using attached Report Definition Load PHP Script in Web Browser Fill out form, including File to Upload [start/End Term Dates auto-suggested] Press Go. CSV File Notes (auto-setup in Report Definition though): ONE ROOM ONLY Order of Columns: Room, Day, Period, Class, Teacher, Subject Code, NoStudents Period should be defined as 'Mon:7' or 'Mon:07' Hope this helps!