Palm2CSV / Palm2iCal

What's New

1/26/2012: iCal files now support true repeating events! (Repeating events are encoded using REPEAT property, and EXRULE/EXDATE to designate repeat exceptions; see http://www.kanzaki.com/docs/ical/rrule.html)

10/15/2011: Added info about Yahoo Calendar's iCal (.ics) requirement.

9/20/2011: Now using the latest MDB Tools v0.7-rc1 to convert Palm Desktop 6 files from MS Access / Jet format

9/14/2011: Check out the Palm2CSV video tutorial [YouTube]

8/1/2011: Renamed "Repeat End Date" option to just "End Date". Added "Start Date" option. Cleaned up time zone and repeating event info on Help page.

7/22/2011: Added Max Output File Lines option to support Google Calendar's daily limit of 5000 records.

7/9/2011: Added support for Mac file format!

7/8/2011: Consolidated FAQ and Help pages into Help page.

7/8/2011: Now supporting To Do Archive (TDA) files created with Palm Desktop 6.x.

6/19/2011: Made Time Zone setting default to "autodetect" and added more detailed description for Time Zone and Adjust Times By settings.

6/9/2011: Now showing a warning on the download page when user-specified Time Zone setting setting appears to be incorrect.

6/8/2011: Now honoring Max Output File Size when outputting to iCal format.

6/1/2011: Now doing time zone calculations when dates are read from Palm file, rather than when dates are output to CSV. This should resolve most time zone issues. Also, made the following changes to iCal output format (thanks to Bill van Melle for these suggestions!):

• Event UIDs are now unique
• Removed colons from timestamps (20091120T20:00:00Z is now 20091120T200000Z); both seem to be acceptable forms of ISO 8601, but when importing the former into Google Calendar, Google takes all the times to be midnight.
• Now outputting times in UTC (previously they were in local time based on the original Palm file's time zone)

5/27/2011: Fixed some date/time calculations when converting between time zones. Also fixed a bug with converting TDA files in which the Notes field was inadvertently omitted.

5/21/2011: When generating CSV file, no longer putting the placeholder word "Location" in the location field.

5/21/2011: Added an option to set default settings for importing into Google Calendar or Outlook.

5/18/2011: Fixed a bug whereby events containing double-quotes (") were not being properly escaped for importing into Google Calendar (although other apps like Excel had no problems reading them).

5/16/2011: FULL support for DBA and TDA files exported from Palm Desktop 6.x (Palm Desktop by ACCESS)! Also fixed a couple of minor bugs with repeating events.

5/6/2011: Limited support for DBA and TDA files exported from Palm Desktop 6.x (Palm Desktop by ACCESS). (Full support for these files is coming soon--thanks for your patience!)

4/23/2011: Option to download your converted files as a single Zip file; also fixed a bug where some files didn't honor the Max Output File Size option and others were blank (although no data was actually missing).

4/17/2011: Option to output multiple files, i.e. have Palm2CSV automatically split your CSV file into several files when converting.

4/9/2011: Option to output to iCal format (experimental!)

4/7/2011: Fixed TDA conversion, which must have been broken since 3/17 or so.

3/31/2011: Fixed date format options, which must have been broken since 3/17 or so.

3/17/2011: Option to output directly to browser, or to downloadable file.

2/27/2011: Added option to specify original time zone. This ensures untimed events are shown on the correct day.

2/20/2011: Added option to display time in 12 hr format with AM/PM, for better performance when importing into Google Calendar.

2/18/2011: Added option to display End Date normally, suppressed, or as Start Date, for better performance when importing into Google Calendar.

1/5/2011: You can now specify the date format (American, European or ISO) and separator (slash or dash).

12/11/2010: Fixed a bugs with repeating events which failed to skip dates that were supposed to be exceptions.

9/6/2010: Fixed a couple of bugs with repeating events which showed up on the wrong date or time.

6/22/2010: Added option to suppress display of End Date, to allow for easier (and correct) importing of repeating events into Google Calendar.

6/15/2010: Now exporting times in 24-hour format, without trailing AM/PM. This allows Google to recognize them when importing into Google Calendar.

6/14/2010: Now displaying Category column when dumping Datebook entries.

5/5/2010: Full support for repeating events!

4/28/2010: You can now adjust all dates forward or backward by 1-23 hours to account for different timezones.