Exporting SIMS timetable into MRBS
I have read a few threads on here for exporting the timetable into a CSV which is great, but i have 2 problems still and could not see an answer already posted.
1. Although I have set the current academic year to 2009/2010 it is still giving me 2008/2009's timetable. What am I missing? I have tried it with staff/all, staff/current and staff/all future but still get this years output - help!
2. Has anyone created the query that will input the data to MRBS? I can handle simple queries but this seems over my head :o
My report generates...
Surname, forename, staff code, room, class, day name and period (Thanks to a post by Howartp for that :) )
We work on a 2 week timetable but i have a query that will move the bookings on the start of each half term, its just getting that data into MRBS in the first place that i would like to automate. The last 3 years we have input the data manually which takes most of the day for 2 of us.