Importing Events From Comma Separated Files (CSV)
Applies To:
WebCalendar Creator 2002
Overview:
Most programs can export comma delimited files (CDF or CSV), so you can often use this format as a common format for importing events into WebCalendar Creator. The following WebCalendar fields can be imported from CSV files:
Event Date *
Calendar Name
Full Name *
Event URL
Event Location
Event Description
Start Time
End Time
Time Zone
* - these are the minimum fields required to import
It's not necessary to have your CSV file fields in any specific order - you will be able to match the fields of the import file to the relevant WebCalendar Creator fields before the import is completed. However, it's recommended that the first line of your csv file contains the field names (as shown below). The following three lines are an example of a csv file:
"Date","Calendar Name","Full Name","Description","Start Time","End Time" 9/3/01,"School Closed","Labor Day-Schools Closed","The school will be closed to observe this holiday",7:00,17:00
9/4/01,"First Day","First Day of School","This is the first day back to school",0:00,0:00
To import a CSV file select FILE > IMPORT > EVENTS FROM COMMA DELIMITED FILE. Then, navigate and select the file to import. Then, a field mapping form will be displayed that allows you to match the import fields to the relevant WebCalendar Creator fields. At a minimum you must map the 'Event Date' and 'Full Name' fields. When ready, press the 'Import' button to complete the import.
|