You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
Home > Manage Content > Importing to BluePrint > How to Import Lessons & Lesson Categories
How to Import Lessons & Lesson Categories
print icon


  1. Copy Lessons Import template. 
    1. Use a spreadsheet with all column headers under “Breakdown of Spreadsheet”. The order of column headers must match the order below. Include them all even if you will not be inputting information under every header. 
  2. Follow information under “Breakdown” to add values. 
  3. Export spreadsheet as CSV UTF-8. 
    1. Any special characters should be amp-encoded with their corresponding HTML entities 
  4. Compile and compress content files directly referenced in the spreadsheet.
  5. To import:
    1.  In BluePrint, navigate to Other Tools under Utilities. Select Import Content.
    2. On the Import page, under Lessons, choose the CSV (encoded as UTF 8) that you want to import. 
    3. If applicable: 
      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 start of importing process: under Images and/or Multimedia, choose the zipped files associated with the CSV. 
    4. Select “Import” at the bottom of the screen. Wait for the page to reload.
    5. Visit the Activity Log. Once the import is complete, the task will read “successful.” 
      1. If import fails the first time, try adding quotation marks around id in the first column header like so: “id”. Then reupload and import the CSV. 
      2. For this import to work, the course cannot have ever had Lesson Categories or else Lesson import will not work. 
  6. To generate Lesson Categories: 
    1. Navigate to Other Tools under Utilities. 
    2. Select “Generate Lesson Categories”. 
    3. Visit the Activity Log. Once complete, the task will read “successful.” 7. All Lesson Categories and Lessons will now appear under Lesson Categories on the left-hand nav.

Breakdown of Spreadsheet 

Information on how to include content in each column. Best viewed alongside the Import template:

Note: Order of lessons and categories in CSV affects end order. Order for categories, subcategories, and individual lessons is changeable after import, if necessary. 

  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 
  4. Fourth 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. 
  5. Fifth column: voiceover_file
    • What: voiceover of lesson content
    • Can be name of .wav or .mp3 file zipped and uploaded separately
0 out of 0 found this helpful

scroll to top icon