User guide

3
Set the Security Level to Medium.
4
Close BAT.xlt and open it again. When prompted, choose Enable Macros.
After the request to migrate an SCCP phone to SIP through the Migrate Phones - SCCP TO SIP
window is submitted, model 7940 and 7960 continue to show up as SCCP phones.
Problem After the request to migrate an SCCP phone to SIP through the Migrate Phones - SCCP TO SIP
window is submitted, Cisco Unified IP Phones model 7940 and 7960 continue to show up as SCCP phones.
Solution To solve this problem, power cycle (power off and on) individual phones after migration.
For Cisco Unified IP phones (models 7905, 7911, 7912, 7941, 7961, 7970, and 7971), the migration
activity works correctly, and the phones register as SIP after migration.
Note
Record does not match the file format selected.
Problem Record does not match the file format selected.
Possible Cause When you create a CSV file using MS Excel with the last column blank, MS Excel fails
to add a comma for the last column after row 15. This error occurs when such a CSV file is used for any
of the BAT operations.
Solution If you want the last column of CSV file to be blank, use the following steps:
1
Enter some dummy value for the last column while creating the CSV file.
2
Save the CSV file and close it.
3
Open the saved CSV file using Text Editor/Notepad.
4
Replace the dummy values with a blank value and save it.
BAT.xlt is working in compatibility mode with Microsoft Excel 2007.
Problem BAT.xlt is working in compatibility mode with Microsoft Excel 2007.
Possible Cause The excel template bat.xlt is a Microsoft Excel 2003 file. When the file is opened in
Microsoft Excel 2007, the file opens in compatibility mode. In compatibility mode, the excel template
acts like a Microsoft Excel 2003 file, and the features of Microsoft Excel 2007 are not available.
Solution Make sure that BAT.xlt is in normal mode. Open Bat.xltl; then choose File > Save As and click Excel
Macro Enabled Workbook. Provide a name, and click Save. Close the bat.xlt and open the file that you saved
(the Saved As file).
Troubleshooting BAT Performance
Keep in mind that it is best to send bulk transactions during low-traffic periods. When you insert BAT files
to the first node database during the time when Cisco Unified Communications Manager is processing a high
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
OL-28580-01 575
Troubleshooting BAT Performance
REVIEW DRAFT - CISCO CONFIDENTIAL