User guide

• While saving your CSV file, choose to save it as UTF-8 encoded. In Notepad, you can select encoding
as UTF-8 from the Encoding dropdown.
What to Do Next
Upload the CSV file to the first node of Cisco Unified Communications Manager.
Related Topics
Phone CSV data file Formats, on page 587
Export the fields for all phone details option, on page 589
Phone CSV file examples, on page 589
Phone CSV data file Formats
Different types of phones require specific data formats. Keep in mind that fields that are labeled as optional
in the phone file format become mandatory fields when certain conditions are met.
Related Topics
Phones with users combinations file format, on page 587
CTI ports/H.323 clients file format, on page 588
CTI ports-users and H.323 client-users combinations file format, on page 588
Phones with users combinations file format
The following sample shows the field length and whether the field is optional or mandatory for a text-based
CSV file for phones and the fixed user format.
First Name (Optional, up to 64 characters), Last Name (Mandatory, 1 to 64 characters), User
ID (Mandatory, 1 to 128 characters), Password (Optional, up to 128 characters), Manager
User ID (Optional, up to 128 characters, must use the ID that exists in global directory),
Department (Optional, up to 64 characters), PIN (Optional, up to 20 numerals), Default
Profile (Optional, up to 50 characters), User Locale (Optional, up to 50 characters),
Telephone Number (Optional, up to 20 numerals), Primary Extension (Optional, up to 50
numerals), Associated PC (Optional, up to 50 characters), ICD Extension (Optional, up to
50 numerals), Mail ID (Optional, up to 255 characters), Presence Group (Optional, up to 50
characters), Subscribe Calling Search Space (Optional, up to 50 characters), MAC Address
(Mandatory, up to 12 characters), Description (Optional, up to 50 characters), Location
(Optional, up to 50 characters), Directory Number (Optional, up to 24 numerals and special
characters), Display (Optional, up to 30 characters), Line Text Label (Optional, up to 30
characters), Forward Busy External (Optional, up to 50 numerals and special characters),
Forward No Answer External (Optional, up to 50 numerals and special characters), Forward
No Coverage External (Optional, up to 50 numerals and special characters), Forward Busy
Internal (Optional, up to 50 numerals and special characters), Forward No Answer Internal
(Optional, up to 50 numerals and special characters), Forward No Coverage Internal (Optional,
up to 50 numerals and special characters), Call Pickup Group (Optional, up to 50 characters),
Speed Dial (Optional, up to 50 numerals and special characters), Speed Dial Label (Optional,
up to 30 characters)
Sample
John,Smith,johns,abcde,Daviss,12,12345,johnProfile,English United
States,1,1231123245AB,Dallas,
9725557154,9725557154,Mike,9725557172,9725557196,9725557112,
9725557127,9725557158,9725557189,9725557121/TollByPass,1230000000,Helpdesk
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
OL-28580-01 587
Text-based CSV files
Phone CSV data file Formats
REVIEW DRAFT - CISCO CONFIDENTIAL