Just thought I would share this, as I have uploaded the school holiday dates into my calendar for 2012/13 and 2013/14, should be fine for most schools in England (just double check yours) but is definitely correct for schools in Waltham Forest - dates taken from the WF website. Note though that they do not have any dates from Spring Break 2014.
So first of all for those who don't want to continue reading find the csv files to upload for the school holiday dates, one for 2012/13 and one for 2013/14, click here
Import these files into your calendar and you will have the school holiday dates "just like that"
The other side to this is if you want to be able to import in bulk to your calendar using csv. The following is true for most calendar but is reliable for Google calendar. If you think I have made a mistake please point it out.
First of all you will need to open a new spreadsheet, you can use the two as above as a template instead of creating from scratch.
You will need the first row of your spreadsheet to have the following fields,
Subject, Start Date, Start Time, End Date, End time, All Day Event, Reminder On/Off, Reminder Date, Reminder Time, Meeting Organizer, Description, Location, Private
The first two fields are mandatory. Ensure that your Date columns are formatted as date (dd/mm/yyyy) and your Time column formatted as time (hh:mm:ss)
If you want to insert a date range then Subject, Start Date and End Date are mandatory and either Start Time and End Time or All Day Event = TRUE
Note if you use All Day Event then your end Date must be "your end date" + 1, otherwise your event will finish a day earlier than you want it to.
Thus for range 1/1/2013 - 20/1/2013, I would acutally enter 21/1/2013 as my End Date if I want the event to finish on the 20/1/2013 in my calendar. This is only an issue if you use All Day Event, otherwise just use Start Time 00:00 and End Time 23:59 and copy this down through all of your events.
No comments:
Post a Comment