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

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

  • 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

  • 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

 

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.