Importing flashcards into a course that is in a conversion state will completely replace any previously existing flashcards.  Once a course is in a published state, you will only be able to add additional flashcards via an import.

Instructions 

1. View the "Breakdown of Spreadsheet" section below, and download the Flashcard Import Template.
   1. The order of column headers must match the exact order below. Include all headers even if you will not supply content under all of them.
2. Following the information under “Breakdown of Spreadsheet,” 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.
3. Export the spreadsheet as a CSV UTF-8.
4. Compress any content files directly referenced by filename.
5. Import your flashcards in BluePrint:
   1. Navigate to your course in BluePrint, and click on Other Tools. Select Import Content.
      NOTE: More about the Import Tool can be found here.
   2. Under "Flash Cards," click on Choose File, and select your CSV.
      1. If applicable, import zipped files of images and/or HTML referenced under side_1 or side_2 in the CSV.
   3. Click on Import at the bottom of the screen.
   4. Navigate to the course's Activity Log. Once the import is complete, the activity will update to “successful.”
6. All flashcards will now appear under the Flashcards tab on the left-hand panel. All flashcard categories and subcategories will appear under the Flashcard Categories tab.

Breakdown of Spreadsheet 

Below is information on what to include under each column (* = value required). The Flashcard Import Template can be downloaded here.

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

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
      -   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