Cisco Unified Communications Manager (CallManager)

Document ID: 110967

Contents

Introduction
Prerequisites
      Requirements
      Components Used
      Conventions
Associate User to the Phones.csv File
Associate the Phone to the users.csv File
      Update Users in Cisco CallManager
NetPro Discussion Forums - Featured Conversations
Related Information

Introduction

The Bulk Administration Tool (BAT) is mainly used to insert users, phones, gateways, Forced Authorization Code (FAC), Client Matter Code (CMC), and others, but it can also be used to update devices, users, phones, etc. BAT is usually used to bulk import certain devices, such as phones and users, especially during big phone deployments.

Prerequisites

Requirements

Cisco recommends that you have knowledge of these topics:

• How to insert phones with Bulk Administration Tool

• Cisco CallManager Administration

Components Used

The information in this document is based on these software and hardware versions:

• Cisco CallManager 5.x and later

• Bulk Administration Tool

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Conventions

Refer to Cisco Technical Tips Conventions for more information on document conventions.

Associate User to the Phones.csv File

You can modify the owner user ID in the CSV data file in order to associate existing users to the existing IP phones in the Cisco Unified CallManager database. Complete these steps:

1. From Cisco Unified CallManager Administration main page, choose Bulk Administration > Phones > Export Phones > All Details.

   

   The Export Phone Configuration window appears.

2. In the Export Phone Configuration window, complete these steps:

   1. Choose the All Phone Types option in the Select the Device Type drop-down list.

   2. Enter the name of the file to be exported in the File Name text box and a job description in the Job Information area.

   3. Click the Run Immediately radio button in order to export phone records.

   4. Click Submit in order to create a job to export phone records.

   

3. Use the Job Scheduler option in the Bulk Administration main menu to activate this job.

4. You can now search and download the exported file with the Upload/Download Files option in the Bulk Administration menu.

5. Open the downloaded phones.csv file with Microsoft Excel.

6. Modify the Owner User ID column with the user that you want to associate to that particular IP phone.

7. Choose the Upload/Download Files option in the Bulk Administration menu.

8. Click the Add New button, which opens the File Upload Configuration window.

9. In the File Upload Configuration window, complete these steps:

   1. Browse to the phones.csv file that you updated.

   2. Choose Phones as the Target and Insert Phones - All Details as the Transaction Type from the drop down menu.

   3. Choose the Overwrite File if it exists option, and click the Save button.

   

10. Now, choose Bulk Administration > Phones > Insert Phones. The Insert Phone Configuration window appears.

11. In the Insert Phone Configuration window, complete these steps:

    1. Click the Insert Phones All Details radio button for the Insert Phone section.

    2. Choose the File Name from the drop down menu.

    3. Choose the Override the existing Configuration option, and click Submit.

    4. Click the Run Immediately radio button to update the user records immediately.

    

12. You can now use the Job Scheduler option in the Bulk Administration main menu in order to verify the status.

Associate the Phone to the users.csv File

Update Users in Cisco CallManager

In order to export the CSV data file and update CONTROLLED DEVICES of existing users, complete these steps:

1. From Cisco Unified Call Manager Administration main page, choose Bulk Administration > Users > Export Users.

   The Export Users Query window displays.

   

2. Click Find but do not enter any search text in order to find all the users that are registered in the database.

3. Click Next.

4. Configure these settings in the Export Users Configuration window:

   • In the File Name text box, enter users as the file name.

   • Choose All User Format from the File Format drop-down list.

   • In the Job Information area, enter Export Users as the job description.

   • Click the Run Immediately radio button to export user records immediately

   • Click Submit in order to create a job to export user records.

   

5. Use the Job Scheduler option in the Bulk Administration main menu in order to activate this job.

6. You can now search and download the exported file with the Upload/Download Files option in the Bulk Administration menu.

7. Open the downloaded users.csv file with Microsoft Excel. The exported users.csv file has these columns:

   FIRST NAME,MIDDLE NAME,LAST NAME,USER ID,PASSWORD,MANAGER USER ID,DEPARTMENT,PIN,DEFAULT PROFILE,USER LOCALE,TELEPHONE NUMBER,PRIMARY EXTENSION,ASSOCIATED PC,IPCC EXTENSION,MAIL ID,PRESENCE GROUP,SUBSCRIBE CALLING SEARCH SPACE,ALLOW CONTROL OF DEVICE FROM CTI,DIGEST CREDENTIALS,USER GROUP,CONTROLLED PROFILE,CONTROLLED DEVICE,PASSWORD LOCKED BY ADMIN,PASSWORD CANT CHANGE,PASSWORD MUST CHANGE AT NEXT LOGIN,PASSWORD DOES NOT EXPIRE,PASSWORD AUTHENTICATION RULE,PIN LOCKED BY ADMIN,PIN CANT CHANGE,PIN MUST CHANGE AT NEXT LOGIN,PIN DOES NOT EXPIRE,PIN AUTHENTICATION RULE,ENABLE MOBILITY,ENABLE MOBILE VOICE ACCESS,REMOTE DESTINATION LIMIT,MAXIMUM WAIT TIME FOR DESK PICKUP,PASSWORD IMSINFO,PIN IMSINFO,USER PKID

8. Modify the CONTROLLED DEVICE column, and add the phone that must be related to the user.

   Note: When you update user records, you can keep values or settings for a user that were previously stored in the Cisco CallManager directory. You can use a symbol such as “#” for fields where the value must be retained. In the example users.csv file, under the DIGEST CREDENTIALS, PIN, PASSWORD use the # sign, which tells BAT to keep these fields the same as entered in the DC directory.

9. Choose Bulk Administrator > Users > Update Users. The User Update Configuration window displays.

10. In the User Update Configuration window, complete these steps:

    1. From the File Name drop-down list, choose the users.csv file.

    2. From the User Template Name drop-down list, choose the Bat-user template you created for this bulk transaction.

    3. In the Value for fields to be ignored box, enter the # symbol. This symbol is used to retain the values stored in the DC directory.

    4. In the Job Information area, enter the job description.

    5. Click the Run Immediately radio button to update the user records immediately.

       

    6. Click Submit in order to create a job to update the user records.

11. You can now use the Job Scheduler option in the Bulk Administration main menu in order to verify the status.

NetPro Discussion Forums - Featured Conversations

Related Information

• CallManager Bulk Administration Tool (BAT) Common Problems and Solutions
• Voice Technology Support
• Voice and Unified Communications Product Support
• Technical Support & Documentation - Cisco Systems