Comments on the example file (Mandatory fields are formatted bold):
seminarId = ID event 1491295901309_1
start = Starting 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 = closing date, date, 2017-04-11
last_unsubscribe_date = closing date of deregistration, date, 2017-04-12
learning_time = learning time HH:MM, 01:00
language = language of the event date: de, fr,it,en
min_participant = minimum number of participants, 5
max_participant = maximum number of participants , 10
waitinglist = waiting list places, 2
description = description of the event date
event_type = event date type, values: PRESENCE, VIRTUAL, ILINC, WEBEX
hotel_id = ID hotel
place = Location manually
room = Room manually
details = Address manually
place_id = Location ID
place_room_id = Room ID
place_start= Starting time room, date and time in XML, 2017-04-13T09:20+02:00
place_end = End time room, date and time in XML, 2017-04-13T17:20+02:00
status = Status of the event date, values: PLANNING, INITIALIZED, ACTIVE
auto_activate = Automatic Status change to ACTIVE, date and time, 2017-04-10T09:40+02:00
coordinator = user name of the coordinator
referent = user name of the speaker
time_referent = hours of the speaker HH:MM, 01:00
start_referent = Starting time speaker, date and time in XML, 2017-04-13T09:20+02:00
end_referent = End time speaker, date and time in XML, 2017-04-13T09:20+02:00
referent_2;time_referent_2;start_referent_2;end_referent_2;referent_3;time_referent_3;start_referent_3;end_referent_3;
price = price
currency = currency
presence_list_coordinator = send the attendance list to the coordinator, values: true, false
presence_list_main_referent = send the attendance list to the main speaker, values: true, false
presence_list_co_referent = send the attendance list to the co-speaker, values: true, false
send_presence_list_date = Send attendance list, date 2017-04-20
external_reference
external_reference_type
event_sub_type = sub type for pre-event or post-event task, set it always to “1”.
reg_confirmation_cc_superior = superior CC, values: true, false
reg_confirmation_cc_coordinator = coordinator CC, values: true, false
reg_confirmation_cc_owner = owner CC, values: true, false
Import settings
CSV file
Select a CSV file, which you want to import.
Date format
Select the date format you wish to assign to the CSV file being imported.
To change the standard date format, the administrator has to change the system setting “importwizard.default.dateformat“.
Character code
Define, if the CSV file contains the character code UTF-8 or ISO-8859-1.
Delimiter
Choose if the delimiter is a semicolon, a comma or a tab. CSV files with a semicolon as delimiter can be better processed.
Overview
Statistics on current import operation
This area shows you an overview of how many event dates are created newly and which couldn’t be imported.
Details on the event dates
In the table you see single event date, which were imported and which couldn’t be imported. The column “Note” gives information, why a data set couldn’t be imported, for example: “The value entered by you is not allowed.”