You are here:   Modules > Event Calendar > Excel Template Instruction
Register   |  Login

Import Events from CSV File Template

Minimize
 TitleModified DateSize (Kb) 
Instruction to prepare CSV file template9/18/2011UnknownDownload
ECR5.0 CSV Import File Template9/18/20110.77Download

Instruction to Prepare CSV File to Import Events

Minimize

  • This module allows you to import events data from CSV file.
  • The recommended way to prepare the CSV file is to download the template, and them copy or populate data using the template file.
  • The format MUST be followed in order to import the correct data.
A detailed explanation of each fields in the CSV file:

 #Field Name Data Type Mandatory Format Remarks
 1
Title Text Yes

 2
Venue Text No

 3Description Text Yes
Event description
 4Start Date/Time Text Yes yyyyMMdd HH:mm
This is used to avoid confusion with different date format, example: '20110915 18:30'
 5End Date/Time Text Yes yyyyMMdd HH:mm
This is used to avoid confusion with different date format, example: '20110915 18:30'
 6All Day Event?
Boolean
Yes
True or False
 
 7Category Text No xx;xx; Category name separated by ";". Example: 5;7; where 5 and 7 are the category ID.
 8Image URL
Text
No
FileID=xx
Where xx is the file ID from the DNN database.
 9Attachment URL
Text
No
FileID=xx
 
 10Attachment URL 2
Text
No
FileID=xx
 
 11AllowRegistration Boolean Yes True or False

 12AllowMemberOnly Boolean Yes True or False

 13MaxRegistration Integer
Yes

 14IsFree Boolean Yes True or False

 15Fees Text No
Example: Public|50|All Users;Members|10|Registered Users;
 16Email Text No
Event owner's email
 17OptionalItems Text No xx;xx; Optional item name separated by ";"
 18RegStart Integer No
Relative number of days to the event start date to allow registration to start
 19RegEnd Integer No
Relative number of days to the event start date to allow registration to end
 20IsApproved Boolean Yes True or False
 21AddUserRole Integer No
The user role to assign to the participants once they register the event.
 22AddUserRoleUpon Integer No
0 to Add User Role upon event registration immediately. 1 to Add User Role upon successful payment online.
 23IsFeatured Boolean No True or False
 24AllowMultipleAttendees Boolean No True or False
 25RegOncePeruser Boolean No True or False
 26RegModerated Text No True or False
Is registration moderated?
 27ShowMapLink Boolean No True or False
 28PublishDate Text No yyyyMMdd HH:mm This is used to avoid confusion with different date format, example: '20110915 18:30'
 29EventFullMessageTextNo Message to be rendered once the event is fully registered. 
 30TimeZoneIDTextYes Time zone ID for the event, example: Singapore Standard Time, Mountain Standard Time
 31CustomEventCatIntegerNo Default to -1The custom properties category to be used for the event data.
 32CustomRegCatIntegerNoDefault to -1The custom properties category to be displayed on the registration form.