Requirements for the Import File
  1. The first row must contain the field names for the columns properly delimited. Acceptable field names are listed below
  2. All fields for a single event must be on the same line
  3. Two file types are accepted. Tab delimited and XML

Example Files Tab Example     Tab Reocurring Event Example     Xml Example

Recognized Column Name Column Type Column Description Required
ParentID,
EventID 		Number If included in file then all rows with the same ID will be treated as reocurring events yes, if ChildID/DetailID is present
ChildID,
DetailID 		Number If included in file then all rows with the same ParentID will be treated as reocurring events yes, if ParentID/EventID is present
EventDate,
StartDate 		*Date Date the event starts yes
Title,
EventName 		Text Name/Title of the Event yes
Description Text Description of the event no
StartTime,
TimeEventStart 		**Time Time the event starts yes
EndTime,
TimeEventEnd 		**Time Time the event ends (If value empty then event will be imported with no end time) yes
Location,
LocationName 		Text Location of the event no
LocationURL Text A URL to the location of the event no
Contact,
ContactName 		Text Contact name for the event no
Email,
ContactEmail 		Text Contact email for the event no
AllDayEvent,
IsAllDayEvent 		***Bit (True,False) If event is an all day event the value should be True, otherwise the value should be False yes
Canceled ***Bit (True,False) If event is canceled then the value should be True, otherwise the value should be False yes
EventType Text Event Type name of the event no
Department Text Department name of the event no
CustomFieldName1 Text Custom Field Name 1 of the event no
CustomFieldDescription1 Text Custom Field Description 1 of the event no
CustomFieldName2 Text Custom Field Name 2 of the event no
CustomFieldDescription2 Text Custom Field Description 2 of the event no

*Date format:
"MM-DD-YYYY"
"MM/DD/YYYY"
"YYYY/MM/DD"
"MM/DD/YY"
"MM-DD-YY"


**Time format:
"HH:MM:SS"
"HH:MM"  
"3:00 PM"
"3:00 AM"


***Bit format:
"True", "False", 1 or 0 (1 for true and 0 for false)