Minkus

Great fix, thank you. Looks like Microsoft may not officially support running ODT in the LOCAL SYSTEM context (as @petben found in previous posts below) but this is still a great fix!

I would imagine that PHP logging being broken might have resulted in 500 errors (the script usually generates a few warnings whenever it runs!) - howtarp is the expert for n-weekly timetables, see post #38 for his instructions on 2-weekly, let us know if you need anything different for 3-weekly.

Have you modified the code? Check the php error log (set up in php.ini if it's not already) and post any Warnings or Errors (ignore any Notices). This should give us a clue as to what is going wrong.

Have you modified the code? Checked php error log (see php.ini for the path)?

Had this problem on our network recently, and discovered that it can be resolved by using the old (version 12.0.0) drivers for the OfficeJet 6000. The problem started occurring when we upgraded from 12.0.0 to 14.0.0 - deleting the old drivers & installing 12.0.0 instead resolved the problem. You can get 12.0.0 from HP Officejet 6000 E609b Printer Driver Download - I know it's an 'unofficial' site, but check the digital signatures after downloading the '12.0.0 - Basic (IT)' x64 drivers, and so long as it's signed by 'Hewlett Packard Company', dated ‎21 ‎January ‎2009 03:14:22, you should be OK.

Had this problem on our network recently, and discovered that it can be resolved by using the old (version 12.0.0) drivers for the OfficeJet 6000. The problem started occurring when we upgraded from 12.0.0 to 14.0.0 - deleting the old drivers & installing 12.0.0 instead resolved the problem. You can get 12.0.0 from HP Officejet 6000 E609b Printer Driver Download - I know it's an 'unofficial' site, but check the digital signatures after downloading the '12.0.0 - Basic (IT)' x64 drivers, and so long as it's signed by 'Hewlett Packard Company', dated ‎21 ‎January ‎2009 03:14:22, you should be OK.

Regarding the Smoothwall Kerberos / NTLM issue, I believe it is possible for Smoothwall to support Kerberos and NTLM on a single port - would need some extra work on their part though but I *think* it might mean we don't have to configure Java any more. Have posted a suggestion to Smoothwall's UserVoice forum here: Support Negotiate authentication fully to allow Kerberos AND NTLM to be configured on a single port If you'd like to see this, please support the suggestin by voting for it

Thanks - you're welcome!

I have just set up a scheduled task via Group Policy Preferences, which detects if anyone is logged on, and if not, shuts down the machine when it is idle. This is all without scripting etc - performed entirely with built-in Windows tools and Windows Batch FTW! Control Panel Settings/Scheduled Tasks New Scheduled Task (Windows Vista and later) Action: Replace (required to be able to remove it when it falls out of policy) Name: Shutdown on Idle When running the task, use the following user account: NT AUTHORITY\System (just enter 'System' in the selection box) (Run only when user is logged on - default - works fine) (No need to run with highest privileges - works fine) Triggers... New Trigger -> On idle Repeat task every: 5 minutes For a duration of: Indefinitely (catch cases where the user logon state changes while still idle) (Activate: set to the time we created the task) Actions... New Action -> Start a program Program/script: %ComSpec% Add arguments: /C "for /f "tokens=* usebackq" %i IN (`%WINDIR%\system32\wbem\wmic.exe ComputerSystem GET UserName /value ^| findstr /X "UserName="`) DO "%WINDIR%\system32\shutdown.exe" -s -t 60" (This command will run 'wmic.exe ComputerSystem GET UserName to detect if a user is logged on, and if the UserName field is blank, run the system shutdown) Conditions... Start the task only if the computer is idle for: 15 minutes (Can't get the idle timeout any lower than 15 minutes, as Windows only checks the state that often - [url]http://msdn.microsoft.com/en-us/library/windows/desktop/aa383561(v=vs.85).aspx[/url]) Wait for idle for: Do not wait Stop if the computer ceases to be idle Settings... (Allow task to be run on demand - for testing) Common... Remove this item when it is no longer appliedHope this might help some other people trying to achieve the same thing. As it says in the notes, it's hard to get the idle timeout any lower than 15 minutes, as Windows only checks the 'Idle' state itself that often. If you start up a machine and then wait for it to shut down, it usually takes about 26 minutes to do so - this is probably due to Windows not checking the idle state for at least 15 minutes after startup, plus the idle time itself. However if you wait it does work, and seems fine on all our computers so far.

Nope - if setting '$postData[16][1] = 1;' seems to fix the problem, you should be good to go. I'll let a few other people test this as well, and once I get a chance to update our MRBS, I'll update the script too. EDIT: The 1.3 download post is now updated with a link to post #97 above

OK - that would be helpful. I would have a look but am completely snowed under, so no time to upgrade to 1.4.10, let alone modify the script with the changes! All you need to do is find the new POST variables for the new frequency settings (which you should be able to find in the HTML source for the 'Add Entry' screen - look for the HTML tags), find out what they should be set to to replicate the previous settings (Weekly, Number of weeks: blank), and then modify the following parts of the script to reflect this: $postData[12][0] = "rep_type"; $postData[12][1] = 2; $postData[13][0] = "rep_end_day"; $postData[13][1] = date("j",$lastDOT); $postData[14][0] = "rep_end_month"; $postData[14][1] = date("n",$lastDOT); $postData[15][0] = "rep_end_year"; $postData[15][1] = date("Y",$lastDOT); $postData[16][0] = "rep_num_weeks"; $postData[16][1] = "";If you manage to get it working, please post your changes to the forum so that everyone can test them - if they are tested and work OK for most people, I'll release a new version of the script with the updated changes. Good luck!

Hi, What version of MRBS are you using? The script was last tested by me with 1.4.8 - I believe some of the repeat booking settings have changed since then, so the script may need some modification...

I've just tried importing the second file you supplied into our MRBS (with a fake room number) and it seems to work fine. Have you fiddled with the script at all? What version of PHP are you using? I'm afraid I'm at a bit of a loss on this one.

It looks like your file has two teachers teaching the same class in the same period in a number of places: e.g.: Try combining these double entries into a single period, like so: "1","Mon","Mon:1","7yz/Sp1","SMA GPT ","Sp",29 See if this helps. We don't have this situation in any of our timetabled classes - I suspect this is causing the issue. If so I'm afraid you'll have to modify the script to handle this scenario - or just change the files before you import.

You can ignore the Notices - it's just 'less than ideal' PHP coding. Regarding the warnings - could you post a sample of the room data file you are uploading, to make sure it is all OK? Kind regards, Chris

An easier way to do this that we found was to run the following commands on each system BEFORE the first user logon: attrib +H "C:\Users\Default\Desktop" attrib +H "C:\Users\Default\Documents" attrib +H "C:\Users\Default\Downloads" attrib +H "C:\Users\Default\Favorites" attrib +H "C:\Users\Default\Links" attrib +H "C:\Users\Default\Music" attrib +H "C:\Users\Default\Pictures" attrib +H "C:\Users\Default\Saved Games" attrib +H "C:\Users\Default\Videos" This hides all of the relevant folders in the Default User profile before they are copied over into each new profile. If the folders are redirected by Windows, they will remain hidden - if they are not, it appears that Windows removes the Hidden attribute itself as part of the profile setup - so this is the perfect solution whether you are using Folder Redirection on all folders or not. It seems to work fine on our system - shame that Microsoft don't recommend this as it is much easier than all the other solutions we've found such as deleting the folders or enabling 'Move the contents' as in KB2533930.

An easier way to do this that we found was to run the following commands on each system BEFORE the first user logon: attrib +H "C:\Users\Default\Desktop" attrib +H "C:\Users\Default\Documents" attrib +H "C:\Users\Default\Downloads" attrib +H "C:\Users\Default\Favorites" attrib +H "C:\Users\Default\Links" attrib +H "C:\Users\Default\Music" attrib +H "C:\Users\Default\Pictures" attrib +H "C:\Users\Default\Saved Games" attrib +H "C:\Users\Default\Videos" This hides all of the relevant folders in the Default User profile before they are copied over into each new profile. If the folders are redirected by Windows, they will remain hidden - if they are not, it appears that Windows removes the Hidden attribute itself as part of the profile setup - so this is the perfect solution whether you are using Folder Redirection on all folders or not. It seems to work fine on our system - shame that Microsoft don't recommend this as it is much easier than all the other solutions we've found such as deleting the folders or enabling 'Move the contents' as in KB2533930.

Mmmm... looking at the changes in Post #38 I think it *should* work with just the same changes... Give it a try - if not howtarp will have to help!

Dear all, Version 1.3 of the script is now available, with the following improvements: Import multiple rooms from a single file (you can select multiple rooms in SIMS, change all of the IDs in one go, and they should all be imported at once - saves time!) Check for matching teachers when combining periods as well as room, class, and day Download here: SIMStoMRBS1.3.zip To install: Extract bulkYearMake.php and copy it to your main MRBS folder Extract Room Timetables.RptDef and import it into SIMS.Net Edit bulkYearMake.php according to your own school's needs: Default entry type for booking, and an alternative type for certain subjects if you want - see first few lines of the script. MRBS period setup - search for 'PERIOD EXPLANATION' inside the source for more details. You need to tell it how the periods in the SIMS export file match up to the periods in MRBS. If you're not sure, there is some advice in the previous posts on this forum, or you could just run it against your MRBS as-is - but make a back up first! (You don't need to map room names to numbers in the script any more - see below). To use: Run the 'Room Timetables' report under SIMS.Net, select the room(s) that you want to import (can now import multiple rooms in one go), and save the file it generates EDIT the file that SIMS.Net generated - replace the name of each room (e.g. "Z") with the internal MRBS 'room' ID (e.g. "1"). To find the MRBS 'room' ID, open a room in MRBS, and look in the address bar for 'room=#'. It should look something like this when you are done: "Room","Day name","Period","Class","Initials","Subject code","Students" "3","Fri","Fri:1","9cr/Gr2","RS ","Gr",22 "3","Fri","Fri:10","8C/Ma","HO ","Ma",32 "3","Fri","Fri:2","9cr/Gr2","RS ","Gr",22 "6","Fri","Fri:5","13B6/Pe1a","MU ","Pe",7 "6","Fri","Fri:6","13B6/Pe1a","MU ","Pe",7 "6","Mon","Mon:10","13B4/Sp1","WS ","Sp",8 ... Navigate to bulkYearMake.php in your Web browser, change the 'Start of Term' and 'End of Term' fields if you want to, select the file you edited earlier, and click 'Go'. (You only need to change the edit_entry_handler.php field if you put bulkYearMake.php into a different area of the website to your main MRBS install). The script should load & create a series of frames within itself, each of which represents an attempt to book a period into MRBS. It may take some time to load - be patient! If it all works OK, you should see each of these displaying the MRBS calendar, and the necessary entries created. If not, you may see an MRBS error message or a Scheduling Conflict. If you get an error message, try importing again, just in case this helps. If you get a scheduling conflict, and you are running MRBS 1.4.8 or above, you should be able to tell it to ignore the conflict if you want to. Make sure you get rid of bulkYearMake.php from your MRBS directory when you're done. It's not insecure in the way it accesses the MRBS database, but it was hacked together & is probably full of XSS vulnerabilities. The script was tested with MRBS 1.4.8 - let me know if it stops working in a later version. Can I also encourage you to upgrade MRBS to at least version 1.4.8 if you haven't done so already, as it supports the ability to ignore scheduling conflicts for repeat entries and create as many entries as it can, which is great if you already have bookings in your database. It's released under the GPL as before, so if you do make any changes that others might find helpful, please post them back here so that we can all benefit. For instructions to modify this script to ensure operation with MRBS 1.4.10 and above, see here: http://www.edugeek.net/forums/scripts/40387-sims-mrbs-script-available-7.html#post1074321

Hi, If you put the following line in your php.ini, it will stop 'Notice' and 'Deprecated' warnings from appearing: error_reporting = E_ALL & ~E_DEPRECATED & ~E_NOTICE Maybe not the response that you want - but notices are not 'fatal' errors, just warnings of less than perfect coding - which this script definitely has lots of, I'm afraid

The above line just disables it for new areas. You still need to go into MRBS / Rooms (at the top), select each 'Area', click the 'pen' to the right, and UNtick 'Allow Tentative Bookings' Hope this helps!

Hmmm... not sure then. If you want to disable confirmation completely, switch it off in the Area setup. Otherwise I'll have to look at this next time I update the script, but this might not be until next September, I'm afraid! :/

Re the 'confirmed' thing, try adding the following lines near the bottom of the script, just after $postData[20][1] = "series"; $postData[21][0] = "confirmed"; $postData[21][1] = "1"; This should tell the script to create all confirmed entries. We don't use confirmation here - hence why this has been missed out. Let me know if this works, and if so I'll add it to the script next year.

See howartp's post #38 above

Dear all, Version 1.2 of the script is now available, with a minor bug fix spotted by howartp - thank you very much! This is the only change to the script - if version 1.1 worked OK for you, just wait until next year before updating. To install: Extract bulkYearMake.php and copy it to your main MRBS folder Extract Room Timetables.RptDef and import it into SIMS.Net Edit bulkYearMake.php according to your own school's needs: Default entry type for booking, and an alternative type for certain subjects if you want - see first few lines of the script. MRBS period setup - search for 'PERIOD EXPLANATION' inside the source for more details. You need to tell it how the periods in the SIMS export file match up to the periods in MRBS. If you're not sure, you could just run it against your MRBS as-is, but make a back up first! (You don't need to map room names to numbers in the script any more - see below). To use: Run the 'Room Timetables' report under SIMS.Net, select a single room, and save the file it generates EDIT the file that SIMS.Net generated - replace the name of the room (e.g. "Z") with the internal MRBS 'room' ID (e.g. "1"). To find the MRBS 'room' ID, open a room in MRBS, and look in the address bar for 'room=#'. It should look something like this when you are done: "Room","Day name","Period","Class","Initials","Subject code","Students" "3","Fri","Fri:1","9cr/Gr2","RS ","Gr",22 "3","Fri","Fri:10","8C/Ma","HO ","Ma",32 "3","Fri","Fri:2","9cr/Gr2","RS ","Gr",22 ... Navigate to bulkYearMake.php in your Web browser, change the 'Start of Term' and 'End of Term' fields if you want to, select the file you edited earlier, and click 'Go'. (You only need to change the edit_entry_handler.php field if you put bulkYearMake.php into a different area of the website to your main MRBS install). The script should load & create a series of frames within itself, each of which represents an attempt to book a period into MRBS. It may take some time to load - be patient! If it all works OK, you should see each of these displaying the MRBS calendar, and the necessary entries created. If not, you may see an MRBS error message or a Scheduling Conflict. If you get an error message, try importing again, just in case this helps. If you get a scheduling conflict, and you are running MRBS 1.4.8 or above, you should be able to tell it to ignore the conflict if you want to. Make sure you get rid of bulkYearMake.php from your MRBS directory when you're done. It's not insecure in the way it accesses the MRBS database, but it was hacked together & is probably full of XSS vulnerabilities. The script was tested with the latest version of MRBS (1.4.8), and let me encourage you to upgrade to this if you haven't done so already, as it supports the ability to ignore scheduling conflicts for repeat entries and create as many entries as it can, which is great if you already have bookings in your database. It's released under the GPL as before, so if you do make any changes that others might find helpful (one idea would be to modify the script so that it can handle more than one room at once), please post them back here so that we can all benefit. SIMStoMRBS1.2.zip