User guide

• See the Validate phones and user records, on page 241.
Step 4
Insert phones with users records.
• See the Insert phones with users into Cisco Unified Communications Manager, on page 243.
Add phones with users using the BAT spreadsheet
Create a CSV data file for adding phones and users in bulk.
Procedure
Step 1
To open the BAT spreadsheet, locate and double-click BAT.xlt file.
You can download a BAT.xlt file.
Step 2
When prompted, click Enable Macros to use the spreadsheet capabilities.
Step 3
At the bottom of the spreadsheet, click the Phones-Users tab.
Step 4
Follow steps 4 through 10 in Create phone CSV data file using BAT spreadsheet, on page 78.
See Table 11: Field description in BAT Spreadsheet for adding users, on page 187 for field descriptions in
for adding users in the BAT spreadsheet.
Related Topics
BAT spreadsheet data collection for CSV data file creation, on page 10
Topics related to phones with users, on page 238
Upload and download files, on page 17
Topics related to phones with users
• Add new phones with users, on page 237
• Phones with users combinations file format, on page 587
• Add phone and user file format, on page 239
• Validate phones and user records, on page 241
• Insert phones with users into Cisco Unified Communications Manager, on page 243
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
238 OL-28580-01
Add phones with users using the BAT spreadsheet
REVIEW DRAFT - CISCO CONFIDENTIAL