Home Access Plus+ Thread, Bookings from SIMS in Projects:; Hey all, thought I'd share a SIMS report I've made for getting room timetables out. There's a bit of find ...
29th January 2013, 02:17 PM #1
Bookings from SIMS
Hey all, thought I'd share a SIMS report I've made for getting room timetables out. There's a bit of find & replacement to do after running the report, but it at least puts the xml in the right format to copy into staticbookings.xml. Basically you just run the report, selecting your bookable rooms, then do a bit of find and replace on the output to convert the day and lesson names to the right format.
eg. in our case:
Fix the Lesson fields by doing find and replace:
"AMon:" --> "Lesson " (space is important)
"ATue:" --> "Lesson "
"AWed:" --> "Lesson "
Our period names output as ~ 'AMon:1' so you just need to get rid of the day bit. You might have 'Day1:' or something. -
Then fix the Day fields by doing find and replace on:
"AMon" --> "1"
"ATues" --> "2"
In our case we don't need to do anything with username as our staff initials in SIMS are used for this in the first place. As far as I know it won't break anything if you leave those as they are, but you may also want to replace staff initals with usernames.
I'd be interested to hear if anyone else can get it to work ok for them as I know SIMS timetable setups will differ.
And here's a reminder to back up (and not blame me if anything goes wrong.. )
By iceman in forum MIS Systems
Last Post: 22nd May 2012, 03:59 PM
By IT_Man_Dan in forum Educational Software
Last Post: 23rd January 2012, 06:30 PM
By ljlbray in forum MIS Systems
Last Post: 21st September 2011, 07:46 AM
By mattgrimley in forum Home Access Plus+
Last Post: 11th July 2011, 02:36 PM
By TimH in forum MIS Systems
Last Post: 25th August 2009, 11:38 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)