Installation guide

CSV File Properties ShoreTel Integration with External Applications
17
ShoreTel 14.2 Planning and Installation Guide 321
Contact Record
The file contains one record for each contact that is integrated into the Directory viewer. The order of
data fields in each contact record must be identical to the fields in the Contact Header Record.
Contact Record Example 1:
“ID_100”,”Johnny”,”Fracas”, “398-212-0012”
Contact Record Example 2:
ID_100,Johnny,Fracas, 398-212-0012CSV Examples
CSV File Examples
CSV file with all fields surrounded by double quotes
“Source=Lotus”,”Version=2.0”
“Contact ID”, “First Name”, ”Middle Name”, “Last Name”, “Company”, “Department”,
“Business Fax”, “Business Phone”, “Home Phone”, “Mobile Phone”, “Pager”,
“Categories”, “Email Address”
“1234”,”Maude”,”June”,”Bigsby”,”Anycorp, Inc.”,””,,”[phone]”
“1235”,”David”,”””Doc”””,”Daniels”,”Anycorp, Inc.”,”Software Engineering”,”(398)
331-9999”,”[phone]”,”[phone]”,”[phone]”,”[phone]”,”New
Customer”,”[e-mail]”
CSV file in which fields with commas and double quotes are surrounded by double quotes
Source=Lotus,Version=2.0
Contact ID,First Name,Middle Name,Last Name,Company,Department,Business
Fax,Business Phone,Home Phone,Mobile Phone,Pager,Categories,Email Address,IM
Address
1234,Maude,June,Bigsby,”Anycorp, Inc.”,,,[phone],,,,,,
1235,David,”””Doc”””,Daniels,”Anycorp, Inc.”,Software Engineering,(398) 331-
9999,[phone],[phone],[phone],[phone], New Customer,
[e-mail],[e-mail]
Home Phone 2 Directory Viewer displays contents under the Home 2 column.
Mobile Phone Directory Viewer displays contents under the Mobile column.
Pager Directory Viewer displays contents under the Pager column.
Business Fax Directory Viewer displays contents under the Fax column.
Email Address Directory Viewer displays contents under the Email column.
Email2 Address Directory Viewer displays contents under the Email2 column.
Email3 Address Directory Viewer displays contents under the Email3 column.
IM Address Directory Viewer displays contents under the IM column.
Categories Directory Viewer displays contents under the Categories column.
Table 70: Contact Header Record Field Names(Continued)