Calendar

How to import own data into Google calendar? Here is an example of  a comma delimited CSV file with information. Here are two examples, all day events, and hour long events:

Subject, Start Date, Start Time, End Date, End Time, Private, All Day Event, Location
Alpha,01/01/2009,,,,,,
Beta,01/02/2009,,,,,,
Gamma,01/03/2009,,,,,,

Subject, Start Date, Start Time, End Date, End Time, Private, All Day Event, Location
Shared Ice,01/20/2009,19:45,01/20/2009,20:45,,,REC S
Shared Ice,01/23/2009,19:45,01/23/2009,20:45,,,REC S
Hockey Game,01/24/2009,15:30,01/24/2009,16:30,,,GRA 1
Shared Ice,01/25/2009,13:00,01/25/2009,14:00,,,GRA 3

The problem is how to make yearly frequency, and this is possible to do converting CSV file into ICS calendar file with line:

RRULE:FREQ=YEARLY;INTERVAL=1;BYMONTH=1

I’m not done yet.

Today was really bad internet connection. I had to restart cable modem many times.

This entry was posted in workday. Bookmark the permalink.

Leave a Reply