Calendar:Feature Implementations:ImportExport:CSV
Jump to navigation
Jump to search
Development goals
Recommended date format is YYYY-MM-DD with a four digit year at the beginning. Time format should be HH:MM:SS with 24-hour values. Calendar will also understand dates and times in the locale scheme of the operating system but data format must not change within a file. The universal indicators AM, a.m., PM and p.m. are always recognized.
CSV Field Mapping
| # | Event headers |
Task headers |
Calendar property |
Outlook field values |
| 1 | Subject | eq. | SUMMARY | |
| 2 | Start Date | eq. | DTSTART | |
| 3 | Start Time | - | DTSTART | |
| 4 | End Date | - | DTEND | |
| 5 | End Time | - | DTEND | |
| 6 | All day event | - | VALUE=DATE attribute | True, False |
| 7 | Reminder on/off | Reminder On/Off | VALARM component | True, False |
| 8 | Reminder Date | eq. | TRIGGER | |
| 9 | Reminder Time | eq. | TRIGGER | |
| 10 | Meeting Organizer | - | (ATTENDEE) | |
| 11 | Required Attendees | - | (ATTENDEE) | |
| 12 | Optional Attendees | - | (ATTENDEE) | |
| 13 | Meeting Resources | - | - | |
| 14 | Billing Information | eq. | none | |
| 15 | Categories | eq. | CATEGORIES | |
| 16 | Description | - | DESCRIPTION | |
| 17 | Location | - | LOCATION | |
| 18 | Mileage | eq. | none | |
| 19 | Priority | eq. | (PRIORITY) | High, Normal, Low |
| 20 | Private | eq. | PRIVACY | True, False |
| 21 | Sensitivity | eq. | (CLASS) | Normal, .... |
| 22 | Show time as | - | (TRANSP) | 2, ... |
| 23 | Status | (STATUS) | ||
| 24 | Due Date | (DUE) | ||
| 25 | Date Completed | (COMPLETED (in UTC!)) | ||
| 26 | % Complete | (PERCENT-COMPLETE) | Fractions of one | |
| 27 | Total Work | - | ||
| 28 | Actual Work | - | ||
| 29 | Companies | - | ||
| 30 | Contacts | - | ||
| 31 | Notes | (DESCRIPTION) | ||
| 32 | Role | - | ||
| 33 | Schedule+ Priority | - |