Top

Introduction

The Import Settings screen allows you to specify how the CSV data is to be imported.

Note: You must select a Choice Column to continue.

Top

Features

The settings are divided into three sections.

CSV File Format

Header Row

Many CSV files use the first row of data to label the fields (columns). Set this option to ON if the CSV file you are importing uses the first row for field labels. Set to OFF if the CSV file you are importing has regular data in the first row.

Field Delimiter

Despite being called a CSV (comma separated values) file, the values can be separated by punctuation other than a comma. You must pick the delimiter that is actually used in the file being imported. The initial value is a best guess by analyzing the imported file.

Text Delimiter

It's possible that a value in the CSV file contains the same punctuation used as the Field Delimiter. When this happens the value must be placed within the Text Delimiter. You must pick the delimiter that is actually used in the file being imported. The initial value is a best guess by analyzing the imported file.

Multi-value Delimiter

This option let's you specify a delimiter to be used to separate multiple values in the same column. This is used for attributes associated with multi-select lookup lists and for listing picture paths for items with more than one picture. No attempt is made to guess at this delimiter. You must pick the appropriate value for the file being imported.

Date Format

Dates can appear in many formats. If the imported data has date values then you must pick the appropriate setting. If the dates are textual (month name is spelled out or abbreviated) then use System Default. If the dates are all numeric but are in the standard format for your country then use System Default. If the dates are all numeric but the day, month, and year numbers appear in an order that isn't standard for your country then pick the option that matches the date format in the imported file. Any punctuation is ignored so 05/10/2011 or 05-10-2011 would be treated the same. In both cases these would either be May 10 or October 5 depending on the chosen date format.

Duration Format

Durations can appear in one of three formats. Pick the format that matches any duration value found in the imported file.

Import Source

Choice Column

This required setting specifies which column in the CSV file contains the list of choices to be imported.

Imported Item Processing

Replace Existing Choices

If ON then all existing choices will be deleted and replaced with the imported values. If OFF then the imported values will be added to the existing choices. Duplicate values will be ignored.