MIS Systems Thread, ideas for SLT shared calendars please! in Technical; Hi
Our SLT want to share calendars including their timetables and private calendar entries. We have Zimbra so they can ...
18th March 2010, 01:14 PM #1
- Rep Power
ideas for SLT shared calendars please!
Our SLT want to share calendars including their timetables and private calendar entries. We have Zimbra so they can share personal calendars but I have no clue how to get their timetables in there.
Is there an export out of SIMS into ical format or anything in SIMS that would do this?
18th March 2010, 01:33 PM #2
I don't know about SIMS (we use CMIS) but it's pretty easy to run an Access query that creates an instance of each lesson in a 2 week timetable for each fortnight in the year. You just export each teacher's timetable individually then make another table that holds each "Monday Week 1" (and so on) date in the year. I use Excel for this as I can just replicate down and across till I hit a holiday, then remove bank holidays and staff development days.
You can then export as a CSV and import into Outlook or whatever you want to use (Google Calendars was the other one we considered but decided to stick with Outlook and Exchange due to familiarity - personally I fancy Google Apps for your Domain!).
Have a look at the attachment.
Hope it's helpful,
Last edited by NotSoFast; 18th March 2010 at 01:35 PM.
Thanks to NotSoFast from:
CarolBooth (18th March 2010)
18th March 2010, 02:34 PM #3
- Rep Power
haven't had time to try this but thanks - that might solve another problem I've got for uploading my room bookings into mrbs (used as a block in our moodle)
18th March 2010, 04:41 PM #4
Yes, I originally developed the database as a solution for putting the timetable as a whole into MRBS (which we never used in the end!)
By Gatt in forum School ICT Policies
Last Post: 18th November 2009, 02:27 PM
By timbo343 in forum Windows
Last Post: 8th September 2009, 06:36 PM
By faza in forum How do you do....it?
Last Post: 23rd June 2008, 09:46 AM
By Stuart_C in forum Windows
Last Post: 8th February 2008, 01:32 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)