Difference: CornellAcademicCalendarInICalFormat (3 vs. 4)

Revision 42010-08-03 - DickFurnas

Line: 1 to 1
 
META TOPICPARENT name="WebHome"

Cornell Academic Calendar in iCal Format

Changed:
<
<		The Cornell Academic Calendar is no longer available for Oracle Calendar Users since Cornell has moved to Exchange. I have massaged the information in the on-line pdf file into an iCal file for my own convenience. You may find it useful as well smile
>
>		The Cornell Academic Calendar is no longer available for Oracle Calendar Users since Cornell no longer uses Oracle Calendar. The iCalendar format presented was also useful for iCal on the Mac, Mozilla Thunderbird and Mozilla Sunbird and many other calendar programs.
 
Changed:
<
<		The file presented here is an .ics file which can be directly used by iCal, and probably other software using the open iCalendar format.
>
>		I have massaged the information in the on-line pdf file into an iCalendar file for my own convenience. You may find it useful as well smile

The file presented here is an .ics file which can be directly used by iCal, and probably other software using the open iCalendar format.

 
Table of Contents

Quick Overview:

The file is available from:
Deleted:
<
<
 
Changed:
<
<		Once downloaded, you will have an .ics file which can then be imported into iCal for use.
>
>

You may need to right-click the link to save the file to your hard drive. Once downloaded, you will have an .ics file which can then be imported into iCal for use.

 

More details:

Line: 25 to 26
  or you may be prompted to open the file directly in iCal when downloading.
Changed:
<
<		Otherwise, double click the downloaded file. You will probably want to open it as a new calendar, separate from any others you may have.
>
>		If not directly prompted to load into iCal, double click the downloaded file. You will probably want to open it as a new calendar, separate from any others you may have.
  You now have a local copy of the Cornell Academic Calendar as one of your calendars in iCal.
Line: 37 to 38
 

Colophon:

Added:
>
>		 (Or, gory details of how I made the file presented here.)
 
  • Took the pdf file from the Cornell Academic Calendar page as a start.
  • Held down the Option key and selected various rectangles from the pdf to collect the first and second columns of information from the pdf file.
Changed:
<
<
  • Pasted the text into BBedit.
>
>
  • Pasted the text into a text editor ( I used BBedit ).
 
  • Cleaned it up by hand so rows of the original columns were restored.
Changed:
<
<
  • Searched for the SPACE character in each row of the Day Date column and replaced them with TAB character.
>
>
  • Searched for the SPACE character in each row of the Day Date column and replaced each with a TAB character.
 
  • Manually added the year to dates in 2011 so dates would be interpreted properly when pulling into spreadsheet.
Changed:
<
<
  • For events spanning several days, inserted a TAB character and a full date for the ending date.
  • Copied the individual columns and pasted them into an OpenOffice spreadsheet.
>
>
  • For events spanning several days, inserted a TAB character and edited to form a full date for the ending date.
  • Copied the individual columns and pasted them into a spreadsheet. ( I used OpenOffice ).
 
  • Proofread the resulting columns (some cleanup still necessary inserting and deleting cells to get things aligned properly).
Changed:
<
<
>
>
 
  • Read its import advice.
  • Put headers on the columns in the spreadsheet.
Changed:
<
<
  • Added column in spreadsheet for Allday Event and set value to TRUE for all rows.
  • Deleted extraneous rows with no date data.
>
>
  • Added a column in the spreadsheet for Allday Event and set value to TRUE for all rows.
  • Deleted extraneous rows with no importable date information.
 
  • Copied the contents of the spreadsheet to the clipboard.
  • Pasted into text editor (BBedit again).
  • Saved as text file.
  • Imported into iCal using iCalTextImport3.0 .
Changed:
<
<
>
>
  • Named calendar AcadCal11.
  • Exported AcadCal11 from iCal to file AcadCal11.ics .
 
  • Uploaded AcadCal11.ics to here.
  • Enjoy!
View topic | History: r25 < r24 < r23 < r22 | More topic actions...
 
This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.