"-14","Update calendar","12:00"
"-2","Send out email","12:00"
"2","Send out thank you email to attendees","12:00"
"4","Upload drunken pictures to MySpace","1:00"

# Two helper classes to parse CSV files.
class CalendarEvent:
    def __init__(self):
        self.interval_from_start = 0
        self.description = ""
        self.hour = 0
        self.minute = 0
 
    def __str__(self):
        s = ""
        for k,v in self.__dict__.iteritems():
            s = s + "%s:\t%s\n" % (k,v)
        return s + "\n"
 
 
class CalendarEventFactory:
    def __init__(self, csv_file):
        self.csv_file = csv_file
 
    def loadEvents(self):
        # List to hold events.
        event_list = []
 
        # Open the file
        try:
            f = open(self.csv_file, 'r')
        except:
            raise Exception, "Unable to open file %s" % self.csv_file
 
        # Stuff it into the csv reader class
        input_csv = csv.reader(f)
 
        # For each item, create a CalendarEvent object
        for item in input_csv:
            hour, minute = item[2].split(':')
 
            event = CalendarEvent()
 
            event.interval_from_start = int(item[0])
            event.description = item[1]
            event.hour = int(hour)
            event.minute = int(minute)
 
            event_list.append(event)
 
        # Close the file
        f.close()
 
        # Return the list
        return event_list
 
 
# Helper function to list CSV files in a directory, without full path information
def list_csv_files(dirname):
    files = []
    csv_files = []
 
    try:
        files = os.listdir(dirname)
    except:
        raise Exception, "Unable to open directoy %s" % dirname
 
    r = re.compile(".+\.csv")
 
    for file in files:
        if r.match(file):
            csv_files.append(file)
 
    return csv_files

# For each item, create a CalendarEvent object
        for item in input_csv:
            hour, minute = item[2].split(':')
 
            event = CalendarEvent()
 
            event.interval_from_start = int(item[0])
            event.description = item[1]
            event.hour = int(hour)
            event.minute = int(minute)
 
            event_list.append(event)

event.location = item[3]

"-2","Send out email","12:00","home"

#!/usr/bin/python
 
try:
  from xml.etree import ElementTree
except ImportError:
  from elementtree import ElementTree
import gdata.calendar.service
import gdata.service
import atom.service
import gdata.calendar
import atom
import getopt
import os
import csv
import re
import sys
import time
import datetime
from datetime import timedelta
 
from exceptions import Exception
 
 
# This is where the zipfile gets unpacked to.  Put your CSV files in here.
global install_root
install_root = "C:/"
 
# This is the name of your Google Calendar.  Please note that case must match, and you need to have created the calendar
#   in Google Calendar already.
global calendar_name
calendar_name = "Test"
 
# Set this to your gmail account
global gmail_account
gmail_account = 'xxxxxxxxxxxxxxxxx'
 
# Set this to your gmail password
global gmail_password
gmail_password = 'xxxxxxxxxxxxxxxxx'
 
# Two helper classes to parse CSV files.
class CalendarEvent:
    def __init__(self):
        self.interval_from_start = 0
        self.description = ""
        self.hour = 0
        self.minute = 0
 
    def __str__(self):
        s = ""
        for k,v in self.__dict__.iteritems():
            s = s + "%s:\t%s\n" % (k,v)
        return s + "\n"
 
 
class CalendarEventFactory:
    def __init__(self, csv_file):
        self.csv_file = csv_file
 
    def loadEvents(self):
        # List to hold events.
        event_list = []
 
        # Open the file
        try:
            f = open(self.csv_file, 'r')
        except:
            raise Exception, "Unable to open file %s" % self.csv_file
 
        # Stuff it into the csv reader class
        input_csv = csv.reader(f)
 
        # For each item, create a CalendarEvent object
        for item in input_csv:
            hour, minute = item[2].split(':')
 
            event = CalendarEvent()
 
            event.interval_from_start = int(item[0])
            event.description = item[1]
            event.hour = int(hour)
            event.minute = int(minute)
 
            event_list.append(event)
 
        # Close the file
        f.close()
 
        # Return the list
        return event_list
 
 
# Helper function to list CSV files in a directory, without full path information
def list_csv_files(dirname):
    files = []
    csv_files = []
 
    try:
        files = os.listdir(dirname)
    except:
        raise Exception, "Unable to open directoy %s" % dirname
 
    r = re.compile(".+\.csv")
 
    for file in files:
        if r.match(file):
            csv_files.append(file)
 
    return csv_files
 
# Helper function to show a quick and dirty menu of list items.  Returns the index of the list item picked, or exits if the user so desires.
def display_menu(menu_items):
    def print_menu():
        os.system('cls')
        print "Magical Mbira Event Calculator Version 1.0"
        print ""
        print "  Please select your desired event template"
 
        # Menu index
        i = 1
 
        for item in menu_items:
            print "\t%d - %s" % (i, item)
            i += 1
 
        print "\tQ - Exit program"
        print ""
 
    # Loop until they pick something comprehensible.
    picked = False
 
    while not picked:
        print_menu()
        resp = raw_input("\tPlease selecct an event template, or press Q to quit:  ")
        resp = resp.strip()
 
        try:
            index = int(resp)
        except:
            if resp in ('Q', 'q'):
                sys.exit()
            else:
                print "\n\tInvalid choice!!"
                time.sleep(1)
                continue
 
        if index>len(menu_items):
            print "\n\tInvalid choice!!"
            time.sleep(1)
        else:
            picked = True
 
    return index-1
 
# And really, isn't being a musician really just about getting dates anyway?
def get_gig_date():
    # Loop until they enter something comprehensible.  Comprehensible means a date of the format MM/DD/YYYY
    picked = False
 
    r = re.compile('(?P<month>\d{1,2})(/)(?P<day>\d{1,2})(/)(?P<year>\d{4,4}) (?P<hour>\d{1,2})(:)(?P<minute>\d{2,2})')
 
    while not picked:
        os.system('cls')
        resp = raw_input("Date/time of the gig in the format MM/DD/YYYY HH:MM (military time):   ")
        resp = resp.strip()
 
        mo = r.match(resp)
 
        if mo is None:
            print "Incorrect date format!"
            time.sleep(1)
            continue
        else:
            picked = True
 
    return datetime.datetime(int(mo.group('year')), int(mo.group('month')), int(mo.group('day')), int(mo.group('hour')), int(mo.group('minute')))
 
# Helper function to get a reference to a calendar object by name.  Really, this should be in the library...
def find_calendar_by_name(calendar_service, name):
    # Get a reference to the specified calendar
    feed = calendar_service.GetOwnCalendarsFeed()
    for i, a_calendar in enumerate(feed.entry):
        if a_calendar.title.text==calendar_name:
            return a_calendar
 
    return None
 
 
 
# First, get a list of all the CSV files in the install root directory sorted alphabetically.  Make an event factory for each.
csv_files = list_csv_files(install_root)
 
# Next, print a menu and get the index of the option they want.
index = display_menu(csv_files)
 
# Prompt for the gig date
gig_date = get_gig_date()
 
# Get a description of the gig
gig_description = raw_input("Short description of the gig:  ")
 
 
 
# Load it up via the event factory
evf = CalendarEventFactory(os.path.join(install_root, csv_files[index]))
 
# Authenticate to Google Calendar
try:
    calendar_service = gdata.calendar.service.CalendarService()
    calendar_service.email = gmail_account
    calendar_service.password = gmail_password
    calendar_service.source = 'Google-Calendar_Python_Sample-1.0'
    calendar_service.ProgrammaticLogin()
except:
    print "Error logging into Google Calendar service.  Please check your account settings at the top of the script."
    sys.exit(1)
 
# Find the named calendar
cal = find_calendar_by_name(calendar_service, calendar_name)
 
# ****, Google, could you have made getting the feed ID any more obscure?  You know, like putting it in the field marked ID???!?!?
#  Smart people my ass. If Google employees are so damn smart, why do so many of them live in IRVINE???
cal_id = cal.content.src.replace('http://www.google.com', '')
 
# Loop through the events, and insert them relative to the specified day
for ev in evf.loadEvents():
    event_dt = datetime.datetime(gig_date.year,
                                 gig_date.month,
                                 gig_date.day,
                                 ev.hour,
                                 ev.minute,
                                 0) + timedelta(days=ev.interval_from_start)
 
    end_event_dt = event_dt + timedelta(hours=1)
 
    start_time = event_dt.strftime('%Y-%m-%dT%H:%M:%S.000Z')
    end_time = end_event_dt.strftime('%Y-%m-%dT%H:%M:%S.000Z')
 
    print "Start: %s" % str(event_dt)
    print "End:   %s" % str(end_event_dt)
    print start_time
    print end_time
 
    event = gdata.calendar.CalendarEventEntry()
    event.title = atom.Title(text=ev.description)
    event.when.append(gdata.calendar.When(start_time=start_time, end_time=end_time))
 
    new_event = calendar_service.InsertEvent(event, cal_id)
 
 
 
 
# Finally, add the gig itself
event = gdata.calendar.CalendarEventEntry()
event.title = atom.Title(text=gig_description)
 
end_gig_date = gig_date + timedelta(hours=1)
start_time = gig_date.strftime('%Y-%m-%dT%H:%M:%S.000Z')
end_time = end_gig_date.strftime('%Y-%m-%dT%H:%M:%S.000Z')
event.when.append(gdata.calendar.When(start_time=start_time, end_time=end_time))
 
new_event = calendar_service.InsertEvent(event, cal_id)

event.location = item[3]

if len(item) >= 3:
    event.where = item[3]
else:
    event.where = "undefined location"

event.where.append(gdata.calendar.Where(value_string=item[3]))

event.where.append(gdata.calendar.Where(value_string="Home"))

event.content = atom.Content(text=description)

Traceback (most recent call last):
  File "calendarUpdate.py", line 226, in <module>
    for ev in evf.loadEvents():
  File "calendarUpdate.py", line 83, in loadEvents
    event.where.append(gdata.calendar.Where(value_string=item[3]))
AttributeError: CalendarEvent instance has no attribute 'where'

event = gdata.calendar.CalendarEventEntry()

# For each item, create a CalendarEvent object
        for item in input_csv:
            hour, minute = item[2].split(':')
 
            event = CalendarEvent()
 
            event.interval_from_start = int(item[0])
            event.description = item[1]
            event.hour = int(hour)
            event.minute = int(minute)
 
            event_list.append(event)
 
        # Close the file
        f.close()
 
        # Return the list
        return event_list

 # For each item, create a CalendarEvent object
        for item in input_csv:
            hour, minute = item[2].split(':')

            event = CalendarEvent()

            event.interval_from_start = int(item[0])
            event.description = item[1]
            event.hour = int(hour)
            event.minute = int(minute)
            event.where.append(gdata.calendar.Where(value_string=item[3]))
            event_list.append(event)

        # Close the file
        f.close()

        # Return the list
        return event_list