Agenda Bulk Upload

Audience: This feature is used by event organizers and Touchpoint administrators to import agenda content in bulk.

Agenda Bulk Upload is the process to import multiple agenda sessions into Touchpoint via a spreadsheet. Agenda Bulk Upload is the most efficient way to enter all Agenda Sessions in Touchpoint.

Bulk Uploading Agenda Sessions

Use the Agenda Bulk Upload Template Spreadsheet to create an Excel file with (at minimum) the following columns:

Name: Enter the name (title) of the session, as you'd like it to appear on the Agenda in the app.
Start Date and Time: Enter the start date and time of the session, together in the same column, in this format: MM/DD/YY HH:MM AM/PM (Ex: 9/4/2020 9:00 AM).
End Date and Time: The End Date and Time is optional. If you leave this column blank, the session will be uploaded with a Start Date and Time, with no end time displayed. Enter the end date and time of the session, together in the same column, in this format: MM/DD/YY HH:MM AM/PM (Ex: 9/4/2020 9:00 AM).
Parent Event Name: If you would like a session to be "nested" as a "Child Session" inside of a "Parent Session", enter the EXACT name of the Parent Session in this column.
Note: Make sure you have created a row for the Parent Session as well. Because the Parent Session will simply serve as a receptacle for the Child Sessions within it, the only details you need to include on a Parent Session row are Name, Start Date and Time, and (optionally) End Date and Time. No other information will be displayed for the Parent Session in the app, so there is no need to include it in the bulk upload.
Description: Enter description text about the session in this column, including any HTML formatting tags.
Event Visual Cue: An Event Visual Cue is a small icon image that appears next to the session title on the agenda list view in the app. You may only use 1 Event Visual Cue per session.
Event Visual Cue choices (Enter one of the words below in all lowercase in the Event Visual Cue column):
working = pencil icon
social = 2 people icon
poster = easel icon
food = knife & fork icon
break = coffee cup icon
Location: Enter the location (i.e., room name) of the session. If this location has not already been created in the Touchpoint CMS, it will be created upon import. If this location is already created in the Touchpoint CMS, be sure to enter the Location name exactly as it is entered in the Touchpoint CMS to avoid creating a duplicate Location upon import.
Floor Plan Map Name: To associate the Location of this session with a floor plan map, enter the name of the map in this column.
Speaker Names: Enter the name(s) of the speaker(s) to be assigned to the session. If a Speaker's record is not already created in the Touchpoint CMS, it will be created upon import. If a Speaker's record is already created in the Touchpoint CMS, be sure to enter the Speaker's name exactly as it is entered in the Touchpoint CMS to avoid creating a duplicate Speaker record upon import. Do NOT include the Speaker's prefix (Dr.), suffix/credentials (PhD), or job title. These additional details can be added to each Speaker's profile using the Speakers bulk upload spreadsheet. Enter ONLY the first and last name of each speaker, separating multiple speakers with a vertical pipe ( | ). Example: "Sandra Waller | Anthony Jones | Rashida Morgan".
Survey Name: If you have created Survey(s) in the Touchpoint CMS, enter the name of the Survey that should be attached to each Session in this column.
Participant Types: If you are utilizing Participant Types to tailor the Sessions each Attendee can view in the app, enter the Participant Type(s) who should be allowed to view this Session in this column. Note: Separate multiple Participant Types with a vertical pipe ( | ). Example: "Marketing | Sales".
Capacity: If there is a capacity limit on the Session, enter the number in this column.
Capacity Constrained: Enter TRUE if the number of Attendees allowed to for the Session should be constrained to the number entered in the "Capacity" column. Enter FALSE (or leave blank) if capacity constraints are not required.
Registration Required: Enter TRUE if Session registration should be synced back to Certain Platform or another 3rd party event management system. Enter FALSE (or leave blank) if registration is not required.
Group Header: _______: If you are utilizing Groups to label/filter the sessions on the app, and you have an existing Event Group in the Touchpoint CMS, enter the Group Header here, including "Group Header: ________" as the column header. For example, for an Event Group titled "Track", this column header should be "Group Header: Track". You can also create a new Event Group via this spreadsheet by adding a new "Group Header: ________" column. You can add as many Group columns to the Agenda spreadsheet as needed. In each Group column, enter the group term(s) that should be associated with the Session. Separate multiple group terms with a vertical pipe ( | ). Example: "Data Analysis | Exposure Response".
Related Link: _______: To add a Related Link to a session via import, enter the title of the Related link here, including "Related Link: ________" as the column header. For example, for a Related Link titled "Presentation", this column header should be "Related Link: Presentation". You can add as many Related Link columns to the Agenda spreadsheet as needed. In each Related Link column, enter the URL for the related link that should have the associated title you entered in the column header attached to the Session.
Education Credits: Create separate columns for each Credit Type, and enter the name of the Credit Type in the column header. Enter the number of credits associated with each session in the column. Note: Before importing, you must first create each credit Credit Type under the My Credits feature in the Touchpoint CMS (My Credits > Credit Types > Manage > Add New). During the import process, each Credit Type column should be mapped to the "Education Credits" field. The credit values will be mapped to the corresponding Credit Type label you created in the Touchpoint CMS for each session.
Check In Type: Use this column to assign a check in to a session. Choices: Unverified, Scan, Code, Time bounded, Code and time bounded, None.
Check In Code: If you have designated the Check In Type as "Code", enter the Check In Code in this column. There is no character limit, and check in codes are not case sensitive.
External: If you have an External ID for a session, enter it in this column. This will be used only for internal purposes only included on exports of your Agenda from the Touchpoint CMS. It will not appear in the app.
Time Zone: If you would like to set a specific time zone on a session (different than the overall event time zone), enter it in this column.
Save: Save your Excel spreadsheet on your computer.
On the Event Dashboard, either select the Agenda feature, then click Import > Excel in the upper right corner, or select Import Content under Related Resources on the left side menu and select Event from the Resource type dropdown menu. Click Choose File, select the Excel file from your computer, then click Save. Verify your field mappings. Notes: For each Credit Type column, select "Education Credits" from the field mapping dropdown menu. If you are importing Groups and/or Related Links that do not already exist in the Touchpoint CMS, these columns should be mapped to "Group Header: CREATE NEW" or "Related Link: CREATE NEW". If you are importing Groups and/or Related Links whose titles already exist in the Touchpoint CMS, these columns should be mapped to the corresponding "Group Header: [Title]" or "Related Link: [Title]", which you will see at the bottom of the dropdown menu for each field mapping. For example, if you already have an Event Group titled "Level" created in the Touchpoint CMS, map your "Group Header: Level" field to the existing "Group Header: Level" selection from the dropdown menu. Click Confirm. On the next screen, double-check your field mappings one more time, then click Import. This will start the import process. If there are any errors found while uploading the spreadsheet, you will see the errors on the screen. Once the import is complete, you will see a message that says "# records have been successfully imported."

Import Process and Validation

Was this article helpful? 0 out of 0 found this helpful. Have more questions? Submit a request. Return to top.

Bulk Uploading Content
Personal Itineraries Bulk Upload
NEW Badge Game UX
Surveys
Managing a Live Poll from the VIP Portal

Comments 0 comments Please sign in to leave a comment.