Open Forum

Speaker codes are separated by commas when importing sessions so I'm wondering if they can't themselves contain commas. Can someone confirm this?

For example, speaker codes might be: John Smith, MD and Mary Smith, PHD. Then if they were both on a session together, in the speaker code field in the import, it would look like:

John Smith, MD,Mary Smith, PHD

But, then would that be an issue?

#Creating/ManagingEvents

------------------------------
Joshua Kumin
Events Coordinator - Kempe Center
University of Colorado SystemUnited States
------------------------------

I can't speak to Speaker Codes specifically, but I have run into this exact issue with session descriptions before when doing the import via CSV.  The workaround I have used was to create a CSV file that doesn't contain any commas, so skipping description, and entering any speakers with commas in their titles without the comma (John Smith MD).  I imported that file, then when into each individual session record and added the description there.  For Speakers, you would be able to go into the Speaker record and update the information to include the comma.

I'd love to know if anyone has a better way to handle this!

------------------------------
Jess Olcott
Training Program Coordinator
ETC, Inc.
------------------------------

Original Message:
Sent: 07-13-2023 16:37
From: Joshua Kumin
Subject: Can speaker codes have commas in them?

Speaker codes are separated by commas when importing sessions so I'm wondering if they can't themselves contain commas. Can someone confirm this?

For example, speaker codes might be: John Smith, MD and Mary Smith, PHD. Then if they were both on a session together, in the speaker code field in the import, it would look like:

John Smith, MD,Mary Smith, PHD

But, then would that be an issue?

#Creating/ManagingEvents

------------------------------
Joshua Kumin
Events Coordinator - Kempe Center
University of Colorado SystemUnited States
------------------------------

Hi Joshua,

This does cause an issue when more than 1 speaker is assigned to a session as it will not import the speakers correctly if they are separated by multiple commas. I would recommend not using speaker codes with commas in your import file if it is common for you to have more than 1 speaker assigned to a session and just doing something like John Smith MD for the code instead, with no comma. 

------------------------------
Julia Plymack
Client Success Manager
Cvent
------------------------------

Original Message:
Sent: 07-13-2023 16:37
From: Joshua Kumin
Subject: Can speaker codes have commas in them?

Speaker codes are separated by commas when importing sessions so I'm wondering if they can't themselves contain commas. Can someone confirm this?

For example, speaker codes might be: John Smith, MD and Mary Smith, PHD. Then if they were both on a session together, in the speaker code field in the import, it would look like:

John Smith, MD,Mary Smith, PHD

But, then would that be an issue?

#Creating/ManagingEvents

------------------------------
Joshua Kumin
Events Coordinator - Kempe Center
University of Colorado SystemUnited States
------------------------------