Installation guide

CSV File Properties ShoreTel Integration with External Applications
17
ShoreTel 14.2 Planning and Installation Guide 319
CSV File Properties
CSV files contains records, each of which consists of data fields. The composition of CSV file fields
and records is described below.
CSV File Field Composition
Each field denotes one property for the file or for one contact. The field entries must conform to the
following syntax rules:
 Data is of type strings and supports UTF-16 encoding.
 Fields that contain a double quote must be surrounded by double quotes. For example:
A “tiny” space -> “A ““tiny”” space””
“Joe” -> “““Joe”””
“Red” Wagon -> “““Red”” Wagon”
 Fields that contain commas must be surrounded by double quotes. For example:
“ShoreTel, Inc.”
 Fields that do not contain double quotes or commas with double quotes may be surrounded with
double quotes.
 Data fields with no information translate into blank entries in ShoreTel Communicator.
CSV File Field Record Types
Each line in a CSV file corresponds to one data record. The end of a record is denoted by a Carriage
Return and Line Feed. ShoreTel Communicator CSV integration files define three types of records:
 File Information Record
 Contact Header Record
 Contact Record
File Information Record
The File Information Record denotes the Source of the data and the Version of the file. Inclusion of this
record in the CSV file is optional.
When it is included, the File Information Record must be the first record in the file.
 Source: This field is associated with all file records in ShoreTel Communicator and corresponds to
the Data Source column in the Directory Viewer. Typically, this value is set to the original source of
the file contents. When this field is not included, ShoreTel Communicator uses the CSV or XML file
name as the Data Source contacts imported into the Directory Viewer.
 Version: This field displays the version of the contact information. When included, this field must
be set to 2.0.