Instructions for Item Import

Instructions Importing Items

Certiverse supports importing items via a comma-seperated values (CSV) file. For proper import, the file should be in a specific format as covered by these instructions. To create the CSV file, use the data format table and the sample csv file as a guide, located at the end of end of the article.

CSV File Formatting

  • The file must be a CSV (comma-separated values) file with UTF-8 encoding.
    • This can be selected, or verified, by using “Save As” to save the csv file from Excel, Notepad and other editing tools.
  • First row must be the correct header names for the selected item import type.
  • Fields should be separated by a comma.
  • Fields that contain a comma should be wrapped within double quotes.
  • Double quotes in a field should be wrapped within double quotes; and the double quote within the string should be replaced with two double quotes.

Importing New Items (see here for a step-by-step video tutorial)

Items will be imported with the status of PENDING IMPORT and must be approved before they are "Accepted" Items.
  • The item name can be auto generated or an existing item name can be imported. Imported item names cannot match an existing item name for the Organization.
  • New items can be imported using one of three Item Content Import Methods listed below, depending on the formatting of the item content you need to import.
    • Item Import with Formatting
    • Item Import with images
    • Item Import Without Formatting
  • Item Import Data Format and Sample File

Importing Item Translations (see here for a step-by-step video tutorial)

  • A language translation can be selected for any of the three Item Imports (Item Import with Formatting; Item Import with images; or Item Import Without Formatting).
  • Item translations can be added or updated for existing items, with the same Item Name. 
  • Only the item content (scenarios, stems, options) can be added.
  • Existing  translations will be overwritten.
  • Item translations can be imported using one of three Item Content Import Methods listed below, depending on the formatting of the item content you need to import.
    • Item Import with Formatting
    • Item Import with images
    • Item Import Without Formatting
  • Item Translations Data Import Format and Sample File.

     


Item Content Import Methods


Item Import with Formatting

  • Supported HTML Tags
    • Fields that support HTML formatting can contain HTML tags such as bold, italic, and underline.
    • HTML tags which are not allowed, including <style> and <script> will be stripped
    • The list of HTML attributes which are potentially dangerous varies from browser to browser, and even from browser version to browser version. As such the item import uses an allow-list approach, and only accepts the following attributes:
      • abbr, accept, accept-charset, accesskey, action, align, alt, axis, border, cellpadding, cellspacing, char, charoff, charset, checked, cite, class, clear, cols, colspan, color, compact, coords, datetime, dir, disabled, enctype, for, frame, headers, height, href, hreflang, hspace, id, ismap, label, lang, longdesc, maxlength, media, method, multiple, name, nohref, noshade, nowrap, prompt, readonly, rel, rev, rows, rowspan, rules, scope, selected, shape, size, span, src, srcset, start, summary, tabindex, target, title, type, usemap, valign, value, vspace, and width
    • If all of the content in a required field is stripped, an error will be generated for a missing required field.
  • HTML tags in the Item Content
    • Any html tags that are part of the item content; and intended to be displayed to test takers and not used for formatting; should be escaped using “&lt;” and “&gt;”.
    • Examples: 
      • Correct
        • Import File: “The correct tag for bold text is &lt;b&gt;, and should be used to bold text.”
        • Display: “The correct tag for bold text is <b>, and should be used to bold text.”
      • Incorrect
        • Import File: “The correct tag for bold text is <b>, and should be used to bold text”
        • Display “The correct tag for bold text is, and should be used to bold text”


Item Import with Images
(See here for a step-by-step video tutorial).

  • File Format
    • The import of item content with images requires a zip file with a single csv and sub-folder named “Images” containing all of the image files referenced in the item content.
  • HTML Image References
    • Images should be referenced using the “<img>” tag and “src” attribute, and reference an image file in the "Images” sub-folder.
    • Example: <img src="Images/Image File.png">


Item Import without Formatting

  • All item content will be treated as unformatted text.
  • Any html tags in the item content will be escaped, and displayed within the item content.
    • Examples:
      • Import File: “The correct tag for bold text is <b>, and should be used to bold text”
      • Displayed: “The correct tag for bold text is <b>, and should be used to bold text”


Importing Benchmark Statistics
(see here for a step-by-step video tutorial)

 

Contact Us

If you have any questions or need additional assistance, please contact us by either emailing support@certiverse.com or by submitting a ticket from this article.