Cisco Cisco Agent Desktop 9.0 User Guide
Cisco Desktop Administrator User Guide
86
January 16, 2013
3. If you wish to add agent access to all personal phone books, clear the Disable
personal phone book check box.
4. Click Apply.
Importing and Exporting Phone Books
Importing and exporting phone books makes creating and maintaining large phone
books (up to 3000 entries) easier than with the Phone Book Editor window. Phone
books can be created and edited in any third-party application that accepts
comma-separated value (CSV) files, such as a text editor or spreadsheet. Using the
third-party application, you can edit exported phone books—make bulk changes (for
example, changing an area code), and adding and deleting phone numbers. The
updated file can then be imported into Desktop Administrator to replace the previous
version.
books (up to 3000 entries) easier than with the Phone Book Editor window. Phone
books can be created and edited in any third-party application that accepts
comma-separated value (CSV) files, such as a text editor or spreadsheet. Using the
third-party application, you can edit exported phone books—make bulk changes (for
example, changing an area code), and adding and deleting phone numbers. The
updated file can then be imported into Desktop Administrator to replace the previous
version.
CSV File Format
The phone book CSV file contains the fields shown in
An example of a phone book CSV file is shown below.
"First Name","Last Name","Phone Number","Notes"
"Amanda","Cohen","6511234",""
"Nicholas","Knight","612-555-1228","Sales"
"Natalie","Lambert","952-555-9876","Benefits"
"Joseph","Stonetree","651-555-7612","Manager"
"Amanda","Cohen","6511234",""
"Nicholas","Knight","612-555-1228","Sales"
"Natalie","Lambert","952-555-9876","Benefits"
"Joseph","Stonetree","651-555-7612","Manager"
A phone book CSV files must conform to this format and include the headers in the
first line. During import the file is scanned for illegal characters. If any are found, they
are replaced with question marks.
first line. During import the file is scanned for illegal characters. If any are found, they
are replaced with question marks.
NOTE: Exported CSV files will always show each field enclosed in
double quotes, as in the example above. This is to ensure that any
commas or double quotes that are part of the actual field data are
not mistaken for field delimiters. If your data does not include these
double quotes, as in the example above. This is to ensure that any
commas or double quotes that are part of the actual field data are
not mistaken for field delimiters. If your data does not include these
Table 11.
Phone book CSV file details
Field
Max Length
Permitted Characters
Can Be
Blank?
Blank?
First Name
100
Any printable
No
Last Name
100
Any printable
No
Phone Number
40
0–9, aA–zZ, ‘ ( ) + / : . = ?
No
Notes
256
Any printable
Yes