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