Skip to main content

Attaching People to Schedule Items (CSV import)

How to attach speakers to schedule items via the CSV import

Written by Luke Melia

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.

A column headed People IDs fills the session's first people list (usually Speakers). If the session has no people list yet, Yapp creates one called Speakers.

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:

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

Import Data, first step, people IDs are highlighted

Importing into more than one list

To fill several people lists, add one column per list and put the list's name after a colon in the heading — for example People IDs: Speakers and People IDs: Moderators. Each column fills the list with that name on every session, and creates it if a session doesn't have it yet. New lists go below a session's existing lists; an import never reorders lists you've arranged in the editor.

In the import's Map your Fields step, each column mapped to People IDs has a List Name. A named column's box is filled in from the heading, and you can change it there instead of editing your file. A plain People IDs column fills each session's first people list — click Name this list… to send it to a named list instead. If two columns point at the same list, the import stops and asks you to rename or remove one.

Map your Fields step with a List Name column: a plain People IDs row shows Name this list, a People IDs: Moderators row shows Moderators

Updating lists with a re-import

  • A cell lists everyone who should be in that list. Anyone left out of the cell is removed from the list.

  • An empty cell removes that list from the session.

  • If a column isn't in your file at all, that list is left as it is.

Exporting

A Schedule or Multi-Track export has one People IDs: <list name> column for each list name used on the page, so you can edit it and import it again. Lists with nobody in them aren't exported, and neither are documents lists. Files with a plain People IDs column still import as before.

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?