+  ConfTool Support Forum
|-+  Use of ConfTool
| |-+  Scheduling of the Agenda
| | |-+  How to transfer the ConfTool agenda to Sched

Topic: How to transfer the ConfTool agenda to Sched  (Read 4728 times)

We are using the conference schedule software Sched (sched.org) and are wondering how we can import the ConfTool agenda to that software? Furthermore, can we also import speakers or moderators to Sched?
We have create a special export that can be used to facilitate the import into Sched.
  • Please download the import template from sched.org (see images 1 & 2).
  • Please go to the ConfTool export page, enable the “expert options” by clicking on the cogwheel in the bottom navigation bar and then use the export called “Export Formatted Schedule” with the default settings (see image 3). Please use the Excel export format.
  • Now comes the tricky part: As Sched requires using exactly the template file with all headers (i.e., do not delete any lines at the top of the template table provided by Sched), the data of the columns have to be copied manually from the ConfTool export to the template provided by Sched. However, this takes only a few minutes. Please do not copy or change the header lines.
    We recommend the following column assignment:

    ConfTool Column Name 
    		Sched Column Name 
    		Remark 
    session_ID
    		ID
    session_title_combined
    		 Title
    		 You can also use the columns session_short or session_title if preferred
    session_public_visibility
    		 Published?
    		 Alternatively, you can use "Y" or "N" for all columns, depending on your requirements.
    session_start
    		 Start Date & Time
    session_end
    		 End Date & Time
    session_room
    		 Venue
    Session_room_info
    		 Physical Address
    		 Optional!
    type_track_title
    		 Type/Track
    		 Depending on your requirements you might also use other columns like the topics etc.
    session_topics
    		 Sub-Type
    		 See above
    description
    		 Description
    chairs
    		 Moderators
    authors
    		 Speakers
    discussants
    		 ?
    		 Maybe use the Artist column and rename it in Sched later.
  • Additionally, you can also use the following imports if you want to add more information to the authors, chairs etc.: Export the “Index of Authors” for all accepted submissions (see image 4) and import the name, email and organization to the list of speakers in Sched.
    Furthermore, export the moderators (your session chairs) by using the “Export Registered Users” with the filter “Only Users With Status” and set it to “Moderator” (see image 5) and copy this data to import a list of moderators in Sched.
    These imports can be done via the tab “Directory” in Sched.org (see image 6).

Hint:
Please note that every user from ConfTool (author, chair, discussant, and participant) will be counted as participant in Sched for (your pricing plan for Sched might include fees per participant).