To download the bat.xlt file, on the Cisco Unified CM Administration page, navigate to Bulk Administration > Upload/Download Files and click the Find button if no files show.
1. Select the check box in the row with the bat.xlt file.
2. Click the Download Selected button and the Open File dialog box opens. Choose Save File and click OK. 3. Open Microsoft Excel and open the bat file you downloaded.
4. There are many different workbook tabs along the bottom of the spreadsheet. The first tab that opens displays the guidelines to use the bat file. Row 11 has directions if you are using Excel 2007.
5. Follow the directions if needed. After the file is saved as a macro-enabled workbook and reopened, a security warning will show under the ribbon regarding the macros included in the spreadsheet. Click the Options button and a pop-up window will open. Click the Enable this content radio button and click OK. See Figure 9-59 for an example of this page.
Figure 9-59. Excel Security Warning
6. It will be necessary to use the small tab navigation arrow in the lower-left corner of the window to scroll to the Phones worksheet tab.
7. Click the Phones worksheet tab at the bottom of the page. At first, it looks like there are only two fields for phones: MAC Address/Device Name and Description. This is where the macros come in.
8. Click the Create File Format button in the first row of the spreadsheet and a Field Selection window will open. The fields are divided into three categories: Device Fields, Line Fields, and Intercom Fields. This window allows you to modify the spreadsheet to include any of the various fields listed, thus customizing the file to only the information you need to import.
9. In the Line Fields section, scroll down to the Directory Number and click the double arrow (>>) button to move the field to the Selected Line Fields box. See Figure 9-60 for an example of this page.
Figure 9-60. Excel Field Selection
10. Click the Create button near the bottom of the window. An information dialog box will open asking whether you want to override the existing CSV format. Click Yes.
11. The spreadsheet will now have a new column for Directory Number 1. What if you want to assign more than one directory number? To the right is a column with a Maximum Number of Phone Lines box.
Note
Lab 9-4, Task 7 demonstrated creating a phone button template that supports three directory numbers. This lab will demonstrate using that custom button template, so if your template has fewer buttons (or more), adjust the number of directory numbers selected to match your custom phone template.
12. Enter 3 in the Maximum Number of Phone Lines box and then click outside of that column. The spreadsheet will automatically add extra columns to create the requested number of lines!
something you would never do outside a lab. However, importing phones with unknown MAC addresses is used in production systems in two cases: when the MAC address will be updated later manually or when using the Auto Register Phone Tool (TAPS), where the temporary MAC address is replaced with the correct one after the users follow the prompts of an Interactive Voice Response (IVR) server. As a result, leave the MAC Address/Device Name column empty, but select the Dummy MAC Address check box (right above the Maximum Number of Phone Lines box). This check box does not enter MAC addresses into the spreadsheet (the dummy addresses will be created on import to CUCM). Rather it tells the error-checking script to ignore the blank MAC address fields.
14. In the first row under the Description column, enter BAT_Phone_Test1. Excel has a handy feature: Grab and drag the little black box in the lower-right corner of the selected cell, and it will copy down and autoincrement the values for the selection. Click and hold before dragging down the first description cell to create four phone descriptions. 15. Use the CUCM Pod Phone Number Table in Appendix B and the last manually assigned directory in Lab 9-5 to determine the next directory numbers to use for the phones. The same Excel feature can also be used to autoincrement numbers when dragged to the right. Enter the next available directory number in the first phone row, under Directory Number 1, and then drag the little black box to the right to have it automatically fill in numbers for the other columns. Repeat this step for the other three dummy phones. See Figure 9-61 for an example of this window.
Figure 9-61. Four-Phone Data Import Example
16. After all the data is entered, click the Export to BAT Format button (right above the Dummy MAC Address check box).
17. A dialog box will open to allow you to specify the path and to change the filename to PhoneImport1 to save the new file. Click OK.
Note
The filename cannot have spaces or special characters. Only alphanumeric, dash, underscore, and dot characters are allowed.