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 Flashcards & Flashcard Categories
How to Import Flashcards & Flashcard Categories
print icon


  1. View Flashcard 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 the headers even if you will not supply content under all of them.
  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. Compress any content files directly referenced by filename.
  5. To import:
    1. In BluePrint, navigate to Other Tools under Utilities. Select Import Content.
    2. On the Import page, under Flash Cards, choose the CSV that you want to import. 
    3. If applicable, import zipped files of images and/or HTML referenced under side_1 or side_2 in the CSV. 
    4. Select Import at the bottom of the screen.
    5. Visit the Activity Log. Once the import is complete, the task will read “successful.”
  6. All Flashcard Categories and Subcategories will now appear under Flashcard Categories on the left-hand nav. Flashcards are viewable under Flashcards in the left-hand nav. 

Breakdown of Spreadsheet 

Information on how to include content in each column (* = value required). View alongside Import Template: 
Note: Order of flashcards and categories in CSV affects end order. Order for categories, subcategories, and individual flashcards is changeable after import, if necessary. 

  1. First column: side_1_content_file*
    1. What: Terminology located on the front side of the flashcard (what the user sees first) 
    2. Can only appear once (no duplicates)
    3. To upload formulas or equations, include the MathML or HTML
    4. Special characters should be amp-encoded
    5. To upload images, structure tag as <img src="filename.png" /> and compress all images in a separate archive 
      1. Src value is case sensitive!
    6. Alternative: include full name of HTML file uploaded previously or as part of this upload 
  2. Second column: side_2_content_file*
    1. What: Explanation or definition of what is on side 1 (what the user sees upon flipping the card)
    2. Same parameters as “side_1_content_file” above
  3. Third column: flash_card_category_name*
    1. What: Parent category
  4. Fourth column: sub_flash_card_category_name
    1. What: Sub-category
  5. Fifth column: related_lessons
    1. What: Creates “connection” on backend between flashcard and lesson(s), currently not shown to end user
    2. Comma-separated lesson sort orders (e.g. “3,4” to connect to third and fourth lesson)
  6. Sixth Column: term_voiceover_file
    1. What: voiceover of side 1 content
    2. Full filename of file uploaded previously or as part of this upload
  7. Seventh column: definition_voiceover_file
    1. What: voiceover of side 2 content
    2. Full filename of file uploaded previously or as part of this upload
0 out of 0 found this helpful

scroll to top icon