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 “<” and “>”.
- Examples:
- Correct
- 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 <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”
- Correct
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”
- Examples:
Importing Benchmark Statistics (see here for a step-by-step video tutorial)
- Item benchmark statistics can be added or updated for existing items, with the same Item Name.
- Any existing Benchmark Statistics for the items and statistics in the file will be replaced.
- Benchmark Statistics Data Import Format and Sample File
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.