Skip to main content

Attaching People to Schedule Items (CSV import)

How to attach speakers to schedule items via the CSV import

Cyril Fluck avatar
Written by Cyril Fluck
Updated over 2 weeks ago

You can attach people (e.g. speakers) to schedule items via the CSV import so that your attendees can see their profiles with a simple tap.

To add speakers to your schedule item:

  1. Import the People using the CSV import and you must provide a "Unique ID" field, like it sounds must be different for each person you import.

  2. Import your schedule or multitrack CSV, you can provide and map a "People IDs" column. The value of this column should be the person's Unique ID you provided with the people import. To attach multiple people, include more than one ID, separated by a comma.

The attached people will appear under the "Speakers" section of the schedule item.

Example with a sample of the Conference demo app

  • People page

    Image of a spreadsheet, with 6 rows of data and headings Unique ID, Email, First Name, Last Name, Title, Company & Location. The Unique ID column is highlighted.

  • Multi-Track page

    A spreadsheet, with 8 rows of data, and column headings Track, Title, Date, Start Time, End Time, Location and People IDs. The People IDs column is highlighted.

Attaching multiple people to a session

To attach multiple people, include more than one ID, separated by a comma.

Spreadsheet with People ID data highlighted.

If you edit the file manually and don't use a spreadsheet application (like Excel or Google Sheets for example), you need to wrap the IDs using double quotes

Image of text: "gu-chen,marielle-luzon"

You can verify that it is configured properly during the import process

Import Data, first step, people IDs are highlighted

Using a formula to generate the Unique ID

It is possible to use a formula to automatically populate the Unique ID in the CSV file for People.

Formula example for Google Sheets when there are no homonyms:

=CONCAT(CONCAT(LOWER(C2),"-"),LOWER(D2))

Image of spreadsheet showing use of formula to compute a unique ID

Did this answer your question?