Before importing a CSV file, the file must be in the required format. The column headers in the CSV file contain required and optional information for creating the item (e.g., vendor ID (required), item type (required), subject (optional), etc.). 

• One column header (and only one) must be ItemVendorID, which identifies the item you want to create. (Refer to Finding Items for more information on item identifiers.)
• One column header (and only one) must be ItemType, which identifies the type of item being created. 
• Other column headers are for optional item metadata/properties or custom tags.
• Each row of the file indicates a single item to be created.

The table below outlines which column headers/properties you may include in the file, as well as the values supported for each property.

Refer to the table below for interaction type codes to use when specifying "ItemType" in the CSV file. 

Note: If you need to remove data while editing the CSV file in Excel, right-click on the selection and choose Delete; otherwise, empty data may be detected when imported. 

To remove existing property metadata from an item, include the property in the CSV file and set the value to null.

If you leave a cell empty, the system skips that value.

Some properties can accept multiple values. To indicate multiple values for a single property (other than "Answer") a column must be repeated within the file so that the values are accumulated. For example, the following CSV file contents would give item 54 the Alternate Items whose Vendor IDs are 48 and 222:

The following image shows a sample of a CSV file appropriately formatted and opened in Excel (click to see it larger):

Prior to importing items from a CSV file:

• Verify that the contents of the CSV file satisfy the criteria outlined in the section above titled, “Formatting the CSV File.”
• If you know an import was started, make sure you get an email indicating that it was processed before beginning another import.

When you are ready to import:

1. Navigate to the Items panel for the Item Bank in which you want to create new items.
2. From the Actions menu, choose Advanced > Import Items.
3. The "Import New Items" dialog appears. 

Drag the CSV file from its location in the File Explorer or your desktop to the blue space provided, or click on the blue space and select your file from its location.

Once you see the filename in the dialog, click Import.

You see a message indicating that the file is under review. It will be imported if no major problems are discovered.

After you click Import, the system reviews the file for any errors. If the file cannot be imported for any reason, you receive an email from ItemLogic explaining what needs to be fixed, and nothing is imported.

If no initial file problems are discovered, the system imports as much of the file as possible. If errors are encountered during the import process, the process terminates and ItemLogic sends you an email indicating that the process failed. The email includes the row at which the import failed and the reason for failure. If no errors are discovered during the import process, you receive an email indicating that the import finished.

If you are importing language/locale information, enter the codes below for the corresponding language/locale.