- 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 |
|
|
| 3 | Description |
Text |
Yes |
|
Event description
|
| 4 | Start Date/Time |
Text |
Yes |
yyyyMMdd HH:mm
|
This is used to avoid confusion with different date format, example: '20110915 18:30'
|
| 5 | End Date/Time |
Text |
Yes |
yyyyMMdd HH:mm
|
This is used to avoid confusion with different date format, example: '20110915 18:30'
|
| 6 | All Day Event?
| Boolean
| Yes
| True or False
| |
| 7 | Category |
Text |
No |
xx;xx; |
Category name separated by ";". Example: 5;7; where 5 and 7 are the category ID.
|
| 8 | Image URL
| Text
| No
| FileID=xx
| Where xx is the file ID from the DNN database.
|
| 9 | Attachment URL
| Text
| No
| FileID=xx
| |
| 10 | Attachment URL 2
| Text
| No
| FileID=xx
| |
| 11 | AllowRegistration |
Boolean |
Yes |
True or False
|
|
| 12 | AllowMemberOnly |
Boolean |
Yes |
True or False
|
|
| 13 | MaxRegistration |
Integer
|
Yes |
|
|
| 14 | IsFree |
Boolean |
Yes |
True or False
|
|
| 15 | Fees |
Text |
No |
|
Example: Public|50|All Users;Members|10|Registered Users;
|
| 16 | Email |
Text |
No |
|
Event owner's email
|
| 17 | OptionalItems |
Text |
No |
xx;xx; |
Optional item name separated by ";" |
| 18 | RegStart |
Integer |
No |
|
Relative number of days to the event start date to allow registration to start
|
| 19 | RegEnd |
Integer |
No |
|
Relative number of days to the event start date to allow registration to end
|
| 20 | IsApproved |
Boolean |
Yes |
True or False |
|
| 21 | AddUserRole |
Integer |
No |
|
The user role to assign to the participants once they register the event.
|
| 22 | AddUserRoleUpon |
Integer |
No |
|
0 to Add User Role upon event registration immediately. 1 to Add User Role upon successful payment online.
|
| 23 | IsFeatured |
Boolean |
No |
True or False |
|
| 24 | AllowMultipleAttendees |
Boolean |
No |
True or False |
|
| 25 | RegOncePeruser |
Boolean |
No |
True or False |
|
| 26 | RegModerated |
Text |
No |
True or False
|
Is registration moderated?
|
| 27 | ShowMapLink |
Boolean |
No |
True or False |
|
| 28 | PublishDate |
Text |
No |
yyyyMMdd HH:mm |
This is used to avoid confusion with different date format, example: '20110915 18:30'
|
| 29 | EventFullMessage | Text | No | | Message to be rendered once the event is fully registered. |
| 30 | TimeZoneID | Text | Yes | | Time zone ID for the event, example: Singapore Standard Time, Mountain Standard Time |
| 31 | CustomEventCat | Integer | No | Default to -1 | The custom properties category to be used for the event data. |
| 32 | CustomRegCat | Integer | No | Default to -1 | The custom properties category to be displayed on the registration form. |