Summary

Manage multiple Google Calendars to schedule multiple instruments.

The key program objectives

Get ICS line from the calendar


CronJob - every two hours

Date Conversion Function

Filter Program

filter.php

Reporting

cat 2014.$1* | grep -v ^start | sort | uniq > rpt.2014.$1.csv

Import into Spreadsheet

XXXXXXXX.ics ;20140908T130000Z;2014-09-08 09:00:00;20140908T210000Z;2014-09-08 17:00:00;;20140829T140109Z;;;LAST-MODIFIED:20140829T140118Z;; CONFIRMED;;Dzzzz;
YYYYYYYYY.ics;20130722T120000Z;2013-07-22 08:00:00;20130722T140000Z;2013-07-22 10:00:00;;20130719T173240Z;;;LAST-MODIFIED:20140828T033344Z;; CONFIRMED;;Vzzzccc;

YYYYYYYYY.ics;20140820T123000Z;2014-08-20 08:30:00;20140820T140000Z;2014-08-20 10:00:00;;20140820T121625Z;;;LAST-MODIFIED:20140820T121625Z;; CONFIRMED;;Joe;
YYYYYYYYY.ics;20140820T123000Z;2014-08-20 08:30:00;20140820T143000Z;2014-08-20 10:30:00;;20140820T121625Z;;;LAST-MODIFIED:20140820T143556Z;; CONFIRMED;;Joe;

YYYYYYYYY.ics;20140820T183000Z;2014-08-20 14:30:00;20140820T200000Z;2014-08-20 16:00:00;;20140820T171902Z;;;LAST-MODIFIED:20140820T171902Z;; CONFIRMED;;J;
YYYYYYYYY.ics;20140820T190000Z;2014-08-20 15:00:00;20140820T213000Z;2014-08-20 17:30:00;;20140820T171902Z;;;LAST-MODIFIED:20140820T182942Z;; CONFIRMED;;J;

YYYYYYYYY.ics;20140821T130000Z;2014-08-21 09:00:00;20140821T140000Z;2014-08-21 10:00:00;;20140820T204402Z;;;LAST-MODIFIED:20140820T204402Z;; CONFIRMED;;XXXXX;

Not Converted

Repeating events
seen in ICS file as

DTSTART;TZID=America/New_York:20140911T080000
DTEND;TZID=America/New_York:20140911T170000
RRULE:FREQ=DAILY;UNTIL=20140912T120000Z