CSV File for Event Import
Experienced authors can import event dates via a CSV file. Download the CSV file here and read the explanations and assistance below.
Explanations for the CSV File:
In the table, mandatory fields are formatted in bold. You can fill in everything else, but it is not required. Please note that all fields are formatted as text fields in Excel to ensure, for example, the correct date order is maintained.
| Field | Explanation | Example Value |
|---|---|---|
| seminarId | Event ID Note: IDs with and without “_1” appended are accepted |
1491295901309_1 |
| start | Start time (Date and time in XML format) | 2017-04-13T09:30+02:00 |
| end | End time (Date and time in XML format) | 2017-04-13T09:35+02:00 |
| last_subscribe_date | End of regsitration, Date | 2017-04-11 |
| last_unsubscribe_date | Deregistration deadline, Date | 2017-04-12 |
| learning_time | Learning time HH:MM Note: If the column is empty, please set to “0” |
01:00 |
| language | Event language: de, fr, it, en | it |
| min_participant | Minimum number of participants Note: If not set, value = 0 |
5 |
| max_participant | Maximum number of participants Note: If not set, value = 20 |
10 |
| waitinglist | Waiting list spots Note: If not set, value = 0 |
2 |
| description | Event date description | Example description |
| event_type | Event type: presence, virtual, ilinc, webex | presence |
| hotel_id | Hotel ID | 1491295901309_1 |
| place | Manually recorded location | Berlin |
| room | Manualy recorded room | Room 1 |
| details | Manualy recorded address | Imaginary road 1 |
| place_id | Standort ID Note: If a location ID is set, the location, room, and details will not be imported. Please note that the event date import accepts the UID format for locations, meaning IDs with and without “_1” are accepted. |
1491295901309_1 |
| place_room_id | Room ID Note: Optional, even if location ID is provided |
1491295901309_1 |
| place_start | Room start time (Date & time XML) | 2017-04-13T09:20+02:00 |
| place_end | Room end time (Date & time XML) Note: If empty, please set the event start time |
2017-04-13T17:20+02:00 |
| status | Event status: active, initialized, planning Note: If empty, Status = active |
active |
| auto_activate | Automatic status change (Date & time) Note: If set, activate the “Set status automatically” checkbox |
2017-04-10T09:40+02:00 |
| coordinator | Coordinator username Note: Coordinator must be an author. Check for necessary permissions. |
max.mustermann |
| speaker | Speaker username Note: Speaker must be a user. Check for necessary permissions. |
john.doe |
| time_referent | Presenter hours HH:MM Note: If not set, value = 0 |
01:00 |
| start_referent | Speaker start time (Date & time XML) | 2017-04-13T09:20+02:00 |
| end_referent | Speaker end time (Date & time XML) Note: If empty, please set the event start time |
2017-04-13T09:20+02:00 |
| referent_2 | Second speaker username Note: Fill in values according to the first speaker’s schema |
jane.doe |
| time_referent_2 | Second speaker hours Note: Fill in values according to the first speaker’s schema |
01:00 |
| start_referent_2 | Secons speaker start time Note: Fill in values according to the first speaker’s schema |
2017-04-13T10:00+02:00 |
| end_referent_2 | Second speaker end time Note: Fill in values according to the first speaker’s schema |
2017-04-13T11:00+02:00 |
| referent_3… | Note: For the third and n-th speakers, fill in everything according to the schema | – |
| price | Price Note: If not set, value = 0 |
50 |
| currency | Currency | EUR |
| presence_list_coordinator | Send attendance list to coordinator: true/false | true |
| presence_list_main_referent | Send attendance list to main speaker: true/false | true |
| presence_list_co_referent | Send attendance list to co-speaker: true/false Note: If not set, value = no |
false |
| send_presence_list_date | Send attendance list, Date | 2017-04-20 |
| external_reference | External reference | – |
| external_reference_type | Type of external reference | – |
| event_sub_type | Subtype for preparation/follow-up Note: Always leave as 1 |
1 |
| reg_confirmation_cc_superior | Superior CC: true/false Note: If the columns “Send registration confirmation CC to” are not set, their value is “no”. |
true |
| reg_confirmation_cc_coordinator | Coordinator CC: true/false Note: If the columns “Send registration confirmation CC to” are not set, their value is “no”. |
false |
| reg_confirmation_cc_owner | Owner CC: true/false Note: If the columns “Send registration confirmation CC to” are not set, their value is “no”. |
true |
Was this article helpful?
Thank you for your feedback!