Archive for October, 2004

Importing into iCal

Tuesday, October 26th, 2004

While “switching” my wife to Mac OS X, I needed a way to get her calendar information out of Yahoo and into iCal. I found a few solutions out there, one of which ran in mono, another of which ran in perl.

I ended up taking concepts from both and referring back to the iCalendar format specification for some more information. I tied it together with the perl Module Text::CSV_XS for parsing Yahoo’s CSV output destined for Outlook.

Disclaimer: This is quick and dirty. It met my needs. I was willing to handle embedded commas with pre-processing and post-processing, as well as go back and fix recurring events by hand (When you output to CSV for Outlook, Yahoo creates unique events for each incidence of a recurring event up until the year 2037). The script is here. I consider it to be in the public domain - use it how you like, if you like.

Someday I may create a .dba->.ics converter, but I’ll probably write it in ruby.