Import event dates
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
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
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
Select a CSV file, which you want to import.
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“.
Define, if the CSV file contains the character code UTF-8 or ISO-8859-1.
Choose if the delimiter is a semicolon, a comma or a tab. CSV files with a semicolon as delimiter can be better processed.
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.”