Import my participants

Some basic rules

Your file must be in .xls, .xlsx or .csv format.
One row must be assigned per participant.
One column must correspond to one piece of information: a field, an accreditation or a category.
The formatting rules of your file will be respected: for example, uppercase or lowercase letters will appear as they are on your badges.
To import your file, see this article.

Advanced management

Import a category

It is possible to import participants belonging to different categories. Simply create a column that provides the participant's category name.

Import an accreditation

You can also import accreditations specific to each person. To do this, you must create a column for each check-in point for which you want to import accreditations. The different values can be:

-1 : the number of accesses will be unlimited for the person concerned and the check-in point of the column
0 : access will not be granted. If the person already has this accreditation and you perform an update export, the accreditation will be removed for that check-in point.
Other numeric value > 0: the number of accesses will be equal to the value read.
Non-numeric value: the cell will be ignored.
Empty value: the cell will be ignored.

Import my program sessions

Download the template file

name : Session name
display name: Session name displayed to the public
uid : Session identifier (automatically created if empty)
session_type : Session type (conference, workshop, training, others, ...)
thematics : Session thematics separated by commas
location : Session location
capacity : Capacity (use -1 for unlimited)
price : Price
tax : Tax (e.g.: 5.5 for 5.5%)
start_date : Start date in universal format (e.g.: 2020-04-22T09:00:00+02:00 for April 22, 2020 at 9:00 - Paris time - +02:00 offset)
end_date : End date in universal format
description: Text field, you can modify the font and font size
checkinable : Check-in enabled or not for the session (accepted values: true or false)
speakers : Session speakers (represented by UIDs) separated by commas
exhibitors : Session exhibitors (represented by UIDs) separated by commas
illustration : URL to an image already stored internally

Fields specific to Live sessions

location : Session location, room name
live_session_type : Live type (webinar for webinar, streaming for streaming, video_conference for video conference and from_video_file for pre-recorded)
archive_streams : Records the session stream and offers replays (true or false)
live_session_chat_moderation_type : Moderation type (none, passive or active)
before_start_notification_enabled : Allows participants to receive a notification 5 minutes before the live starts (true or false)
chat_highlight_messages_enabled : Allows selection of questions in the chat (true or false)

To obtain a file with your own sessions, and to update them more easily you can also go to the program page, session, click on more then export the session list. You can then update all your existing sessions via Excel and add more if needed!

Import my thematics

Download the template file

An example of a compliant file is displayed on the import page to help with structuring. The minimum required columns are:

name (Thematic name)
color (associated color)

Optional columns allow enriching the import:

uid : unique identifier of the Thematic, useful to update data or keep an external reference.
path : hierarchical structure of parents, separated by arrows (→). Example: Sport → Raquette defines a parent Sport containing a sub-theme Raquette.

Hierarchy and translation

The path column allows reconstructing a classification tree, with up to six hierarchical levels supported. Parent Thematics mentioned in the path are automatically created if they do not exist in the database, without requiring a dedicated row.

When additional languages are enabled on the event, translation columns can be added for each language. This enables smooth multilingual management of Thematic titles.

Import tracking and error handling

After uploading the file, the user can monitor the import progress in real time. In case of an error, a clear summary is displayed in a modal with the affected rows and identified issues.

Export Thematics

From the same page, it is possible to export all Thematics. The generated file includes all columns compatible with the import. This feature facilitates mass edits and reimports, particularly for updates or structural adjustments.