How to import data from ScholarOne to EventPilot?

Modified on Thu, 21 Jan 2021 at 09:49 AM

Access the tab in the CMS where you would like to import data: 

Agenda for session data

Speakers for presenters

Media for abstracts

Setting Up the Initial Data Source and Running the Initial Import

  1. From our website, click the CMS Login link on the top right
  2. Log in to the CMS and select either Agenda > Sessions, Agenda > Speakers, or Media, depending on what data source you would like to set up.
  3. Add a new data source by clicking +

  4. A new dialog opens. Select ScholarOne from the Source dropdown
  5. Enter a logical name for the source e.g. S1 API

  6. URL: request from your team

  7. Username: request from your team

  8. Password: request from your team

  9. Site Name: request from your team

  10. Select Next

  11. Complete the field mapping for the table and Import the data 

Additional settings are available:

  • Display Authors (subsessions only) - set to if you want the names of the presentation authors displayed in the session description
  • Display FinalID in Titles (subsessions only) - set to Y if the presentation has a "finalid" field listed and you want it prefixed to the session title (e.g. the title will be "<finalid>: <title>") . 
  • Display SessionAbbr (parent sessions only) - set to Y if the session has a "sessionabbr" field and you want it prefixed to the parent session title (same as above, but for parent sessions only). 

Incremental Imports after Setup

  1. From our website click the CMS Login link on the top right
  2. Log in to the CMS 
  3. On the Homescreen, either 
    1. select the button Import All Data 
    2. or access the appropriate tab in the CMS to import only one of the tables e.g. just the speakers
  4. Select the Publish Menu on the top left and Publish to Proof
  5. After reviewing your data update in the proof version on iOS and Android, you may publish to live by selecting Publish Live Data 


For parent sessions the description field is a combination of fields: location (room+venue) + "Notes" + "Hosts" + "Learning Objectives"

For sub-sessions, the description is a combination of: Location + presentation number (finalid) + Authors + Affiliations (if "show authors") is set

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article