What I might try it to convert the NovaT export so that it resembles what could be produced via a report and tweak the script to read that.
Peter - how do you get hold of the sdk?
I've just uploaded a sample report output from mine - it's a .txt file to upload, but rename it to .csv and it should work?
It isn't really an SDK, it's an executable (CommandReporter.exe) which takes certain parameters to run reports on demand.
I've just zipped it and attached to this post.
Once unzipped you'll probably need to right-click on it, go to properties and tick/untick the box which is to do with unblocking content from a remote location - otherwise you'll get a load of blank pages when you open the .chm
I see you have AMon and BMon, does that indicate a two week timetable ?
That should be manageable, I book each timetabled class individually for 8 weeks ahead rather than using repeat bookings (which I originally did) - there was a reason,...errm maybe to allow booking managers to hand remove a single booking from a set.
When mrbs is updated I send a clear all timetabled bookings command then refill, it takes 20 mins or so but as it runs by schedule at night that doesn't matter.
Yes, we run a two week timetable.
The 'weeks' skip over the holidays, so if it is week A in last week of term, week B would be the first week of the next term whether it is a one-week or two-week holiday. This breaks the repeating feature, but if you manually create entries 'by hand' in the script, that should be tweakable to skip the holidays.
What do you do about staff making bookings; if you wipe the timetabled entries and regenerate them all, does it delete any manual bookings that clash with new timetabled entries?
To clear timetable entries I added a script to our mrbs (only a few lines, will include with booking script when I get there) that says
delete from $tbl_entry where create_by=\"timetable\"
The automated bookings are made as a fake user "timetable", so any that have been hand adjusted won't be touched as they will have been created by a real person !
Likewise if an entry has replaced a timetabled one and the automatic booker tries to replace with timetable, it fails silently on that period.
I'm on holiday for a fortnight now - I'll come back to this thread when I return.
I've been playing with this today, and got it all working.
Unfortunately if you have any support staff assisting in lessons (ie two teachers per lesson) then you'll end up with clashed bookings.
I thought I'd go back into SIMS and play with it, but my report now tells me there is no data for my report. :( Hopefully it is related to the issue where you can't run period reports for future dates - I guess you can't run them for past dates either? It's a shame if so.
I've written mine so that in the existing MRBS code at edit_entry_handler.php, whereever it generates or appends to $err (which means an error has occured) it outputs it to a log file. Then at the end of the script which generates all the bookings, it checks for the existence of the log file - if it doesn't exist, then everything worked. Otherwise, it displays it so the timetabler can manually check and deal with clashes.
(I'm proposing to only run the script on demand to start with, whilst we prove whether it works or not!)
I have gone through this thread and find intresting.
Could SIMS experts be some specific on how the system works Please.
we do room bookings in both sims and outlook but we want to move this to MRBS system.
Any suggestions and help would much appreciated