You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > Create and Manage Learning Products > Configuring BenchPrep Courses > Lessons > Importing Lessons & Lesson Categories
Importing Lessons & Lesson Categories
print icon
Claire Son
Dec 13, 2023
views icon 923

Importing lessons and lesson categories into a course that is in a conversion state will completely replace any previously existing lesson & lesson categories.

  1. View the Breakdown of Spreadsheet section below, and download the Lesson Import Template.  The order of column headers must match the exact order below.  Ensure all headers are included, even if you will not supply content under all of them. 
  2. View the CSV example section below to download a filled out csv file and review the structure of the upload in the Learning Application. 
  3. Follow the information under “Breakdown of Spreadsheet” to add values to your template.
    1. Any formatting within your content will need to be written as HTML (e.g. bold, italics, lists, line breaks, links, etc.).
    2. Any special characters should be amp-encoded with their corresponding HTML entities. You can use an online tool like this one to encode special characters appropriately.
  4. Export the spreadsheet as a CSV with UTF-8 encoding.
  5. Compile and compress content files directly referenced in the spreadsheet.
  6. Import your lessons in BluePrint:
    1. Navigate to your course in BluePrint, and click on Other Tools. Select Import Content.
    2. Under "Lessons," click on Choose File, and select your CSV. 
    3. If your spreadsheet contains references to other files for images or HTML content: 
      1. Under "HTML Content," choose the zipped file of all HTML files referenced under reading_html_file in the CSV. 
      2. If not completed at the start of importing process: under "Image" and/or "Multimedia Content," choose the zipped files associated with the CSV. 
    4. Click on Import at the bottom of the screen. Wait for the page to reload.
    5. Navigate to the course's Activity Log. Once the import is complete, the activity will update to “successful.” 
      1. All lesson categories must be deleted at time of import. 
  7. Once import completes everything will be imported as a lesson, to generate Lesson Categories: 
    1. Click on Other Tools.
    2. Click on Generate lesson categories.
    3. Navigate to the course's Activity Log. Once complete, the activity will update to “successful."
  8. All lesson categories and lessons will now appear under Lesson Categories on the left-hand nav.

Breakdown of Spreadsheet 

Below is information on what column headers to include in your spreadsheet (*=value required) and how to input content under each column.
Lesson Import Template can be downloaded here.

 

Note: The order of lessons and categories in your CSV will affect the end order. If necessary, the order for categories, subcategories, and individual lessons is changeable after importing.

 

  1. First column: id 
    • What: represents ID for category and subcategories 
    • Can be anything 
      • Best Practice: Input consecutive whole numbers for categories
      • Best Practice: Input consecutive letters for subcategories
  2. Second column: name* 
    • What: name of lesson category, subcategory, or title 
    • Can be any plain text 
      • Lesson names can only be formatted in BluePrint
      • Blank value will cause import to fail silently and break course
  3. Third column: parent_section_id 
    • What: represents ID of category or subcategory specified under first column
    • Must match a value found in first column 
      • Required for subcategory names and lesson names 

        Example of ID, name and parent_section_id columns


         
  4. Fourth column: lesson_category_id
  5. Fifth column: lesson_category_name
  6. Sixth column: sub_lesson_category_name
  7. Seventh column: reading_html_file 
    • What: lesson content
    • Required for rows of lesson names, NOT required for category and subcategory names 
    • Options:
      • Name of an HTML file uploaded separately in a .zip
      • Plain text with no HTML (becomes <p>) 
      • A block of HTML
        • Does not need <html>, <body>, or even <div> or <p>
        • Content will become wrapped in <p> if not wrapped in anything else
        • Special characters should be amp-encoded
        • To upload formulas or equations, include the MathML or HTML
        • To upload images, structure tag as <img src="filename.png" /> and compress all images in a separate archive.
          • Src value is case sensitive!
        • Does not undergo validation, so please ensure all tags are closed
    • Note: If you want to create a lesson but do not have content for it yet, include any placeholder content. Otherwise, you will not be able to edit the lesson in BluePrint. 
  8. Eight column: voiceover_file
    • What: voiceover of lesson content
    • Can be name of .wav or .mp3 file zipped and uploaded separately


Helpful tips:
 

  • The lesson import will not automatically create lesson categories. Remember to Generate Lesson Categories (step 7) to appropriately nest lesson categories. 
  • We recommend utilizing Lesson import to import both Lessons & Lesson Categories at once. If doing so, leave lesson_category_id, lesson_category_name and sub_lesson_category_name blank. 

 

CSV Example:
 

A filled out Lesson Import Template sample can be downloaded here.

The sample results in the following lesson and lesson categories structure:

Feedback
0 out of 0 found this helpful

Tags

close button
scroll to top icon