DATA IMPORT
In this section, we will discuss importing event data from CSV files, including Session and Speaker Data. First, access the "Data & Backups" screen through the navigation menu on the left. The interface should be visible as shown below.
To import Sessions and Speakers, navigate to the "Event Data" section and click the "IMPORT" button. This action will open a dialog with the necessary inputs as shown below.
| FIELD | DESCRIPTION |
|---|---|
| SPEAKERS CSV | Allows you to select the CSV file containing your speaker data |
| SESSIONS CSV | Allows you to select the CSV file containing your session data |
If the format of your CSV data is correct, the "SELECT" text will change to a success message indicating proper data formatting. Refer to the "DATA FORMATING" section for guidance on formatting your CSV. After pressing "CONFIRM", the import process will begin, and a success message will appear if the import was successful.
DATA FORMAT SPEAKERS CSV
The CSV file must use a comma (,) as the delimiter, with all fields in text/string format. For data formatting please see the table below. All headers must be present, even if not all are used. The file should only contain the header row and the rows of data below it, with no additional content. Download Example File (Open with notepad to see and check formatting)
| COLUMN | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| HEADER | ID | NAME | ROLE | COMPANY | BIOGRAPHY | IMAGE URL | |
| FORMAT | HTTPS | ||||||
| CONTAINS | Unique ID | Speaker Name | Speaker Role | Speaker Company | Speakers Email (Provides additional authority) | A short biography | A HTTPS URL to a publicly available image |
| REQUIRED | YES | YES |
DATA FORMAT SESSION CSV
The CSV file must use a comma (,) as the delimiter, with all fields in text/string format. For data formatting please see the table below. All headers must be present, even if not all are used. The file should only contain the header row and the rows of data below it, with no additional content. Download Example File (Open with notepad to see and check formatting)
| COLUMN | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HEADER | ID | NAME | FORMAT | CAPACITY | LOCATION | START TIME | END TIME | DATE | DIFFICULTY | SPEAKERS | HANDOUT LINK | HAS Q&A | TINT | SYNOPSIS | DESCRIPTION |
| FORMAT | HH:MM | HH:MM | YYYY-MM-DD | speakerID,speakerID or speakerID | true or false | HEX Color #FCBA03 | |||||||||
| CONTAINS | Unique ID | Session Name | Session Format | Session Capacity | Session Location | Session Start Time | Session End Time | Session Start Date | Session Difficulty | Session speaker or list of Speakers | A HTTPS URL to a publicly available location | If the session has a live Q&A session | The tint color defined in HEX COLOR FORMAT | Short session description | Long session description |
| REQUIRED | YES | YES | YES | YES | YES | YES | YES |
CONTINUE TO BACKUPS