Importing Calendar Events Through Webmail:
Webmail supports importing calendar events from Outlook in CSV format. The first row should contain the column names, which webmail uses to determine what each column represents. Note that if an error happens in the middle of the import, events that were imported before the error will remain on the user's calendar. However, most problems will either emerge before the import actually inserts events, or will affect all rows and so no inserts will succeed. Some common things that can go wrong:
The size of the import file is limited to 5000 lines, to limit execution time and out of memory errors. If a customer needs to import more than 5000 events, split the import into multiple files. The line limit check happens before any events are imported, and includes all lines in the file, including blank ones.
Each event should be entirely on one line of the CSV, or the import will fail.
"An error occurred while importing your calendar. Please make sure your .csv data is valid." There are two main causes of this error:
A. The start or end date of an event can't be parsed. The import script relies on PHP's strtotime(); for a list of compatible formats, see http://www.php.net/manual/en/datetime.formats.php
B. The "Allow duplicate events" checkbox is not checked, but the import file contains duplicate events, or events that are already in webmail. Webmail defines uniqueness as a combination of the event owner (user), ICal UID, subject, and start and end times.
C. If neither of the above conditions are true and the import fails, please call our support staff so that they may assist you with this matter.
