C H A P T E R 4 Working with Users BAT allows you to add users to Cisco CallManager and to associate users to phones and other IP Telephony devices, and BAT allows you to bulk-update and bulk-delete users. This chapter describes working with users only. For information about working with user combinations, such as phones and users or CTI ports and users, see Chapter 3, “Working with Phones, IP Telephony Devices, and User Combinations.
Chapter 4 Working with Users Adding Users BAT can also associate CTI ports to existing users. This ability proves useful if you are adding users who will have applications that require a CTI port, such as Cisco IP SoftPhone. See Adding Phones and Other IP Telephony Devices, page 3-2, for more information. To add users to the Cisco CallManager database/LDAP Directory in bulk, you must perform these steps: 1.
Chapter 4 Working with Users Adding Users For instructions on creating the CSV file, see • Creating a CSV File for Users Using BAT.xlt, page 4-3 (recommended method) • Creating a Text-Based CSV File for Users, page 4-5 Creating a CSV File for Users Using BAT.xlt Follow this procedure to create the CSV file for bulk-adding users. BAT uses the information that you provide here to add the users to the Cisco CallManager database. Procedure Step 1 The BAT.xlt file resides on the publisher database server.
Chapter 4 Working with Users Adding Users • In the Last Name field, enter the last name of the user to whom this phone will be issued, up to 50 characters. • In the User ID field, enter the user ID for the user to whom this phone will be issued, from 1 to 30 characters. • In the Password field, enter the password that the user needs to access the Cisco IP Phone Configuration window, up to 20 characters. Although it is considered optional in the CSV file, you must enter a password.
Chapter 4 Working with Users Adding Users Note Do not specify new phones, CTI ports, or phones that were added using BAT with the “BAT” prefix (meaning, they have not been updated in the Cisco CallManager database with the MAC address yet) in this field. • In the Directory Number field, enter the directory number for the primary extension (usually Line 1) for the phone, up to 50 numerals.
Chapter 4 Working with Users Adding Users If you created the CSV file by using the BAT.xlt file, you can skip the following procedures in this section. Note If you use comma or double quotes as part of string in one of the fields, you must enclose the entire text string with double quotes. Tips Use BAT.xlt to input data because data validation is performed on that file. The CSV file provides a common textual way of providing tabular information.
Chapter 4 Working with Users Adding Users Note For BAT inserts, you cannot use CSV files for users that are saved anywhere but C:\BATFiles\Users\Insert Users\ on the server that is running the publisher database for Cisco CallManager. Tips for Creating a Text-Based CSV File The following example format shows the field length and string types followed by an example of a CSV file for users.
Chapter 4 Working with Users Adding Users Example If the manager for a user is blank John,Smith,johns,abc123de,,0012055,9989,johns profile,English United States,1231123245AB,1231123245AB,9725557154,0010EB001234 Example You do not have to supply information for the optional fields.
Chapter 4 Working with Users Adding Users Caution Note Do not insert CSV files that are generated by the export utility from a Cisco CallManager server that is using one directory type on a Cisco CallManager server that is using another type of directory. If you are inserting files that are generated with the export utility, insert the files in descending order based on the _MgrLevel# suffix, where # is 1 through 20.
Chapter 4 Working with Users Adding Users Step 8 Note The export utility saves users with the same CTI application use, call park retrieval, and enable authentication proxy rights settings in the same file. The export utility appends the suffix _t (enabled) or _f (disabled) for each different setting to the file name that you entered. The following order for the suffix flags in the file name applies: enable authentication proxy rights, CTI application use, and call park retrieval.
Chapter 4 Working with Users Adding Users Note Step 9 You must specify PIN and Password values, either on the CSV file or during file insertion in BAT. • User Locale—Choose the language and country set that you want to associate with this user. Your choice determines which cultural-dependent attributes exist for this user and which language displays in the Cisco CallManager user windows and phones. • User Device Profile—Enter the user device profile for this user and device.
Chapter 4 Working with Users Updating Users Updating Users You can use BAT to update user information to the Cisco CallManager database/Lightweight Directory Access Protocol (LDAP) Directory in batches, rather than individually. To update users to the Cisco CallManager database/LDAP Directory in bulk, you must perform these steps: 1. Create a comma separated values (CSV) file to define individual values for each user that you want to update.
Chapter 4 Working with Users Updating Users For instructions on creating the CSV file, see • Creating a CSV File for Updating Users Using BAT.xlt, page 4-13 (recommended method) • Creating a Text-Based CSV File for Updating Users, page 4-15 Creating a CSV File for Updating Users Using BAT.xlt Use this procedure to create the CSV file for bulk-updating users. BAT uses the information that you provide here to update users to the Cisco CallManager database. Procedure Step 1 The BAT.
Chapter 4 Working with Users Updating Users • In the Department field, enter the department number for the user whose profile you are updating. This optional field can contain as many as 50 characters. • In the User Device Profile field, enter the user device profile for this user and device. This optional field can contain as many as 50 characters. The User Device Profile must exist in Cisco CallManager Administration for the Cisco CallManager database to accept this record.
Chapter 4 Working with Users Updating Users Using a floppy disk or a mapped network drive, copy the CSV file from C:\XLSDataFiles\ to the C:\BATFiles\Users\Update Users folder on the server that is running the publisher database for Cisco CallManager. For information on how to read the exported CSV file, click the link to View Sample File in the Insert Users window in BAT (Configure > Users). Creating a Text-Based CSV File for Updating Users If you do not use the BAT.
Chapter 4 Working with Users Updating Users Step 3 Save the file to C:\BATFiles\Users\Update Users on the publisher server. Note For BAT inserts, you cannot use CSV files to update users that are saved anywhere but C:\BATFiles\Users\Update Users\ on the server that is running the publisher database for Cisco CallManager. Tips for Creating a Text-Based CSV File The following example format shows the field length and string types followed by an example of a CSV file for users.
Chapter 4 Working with Users Updating Users Example Enter your preferred language first, followed by the country. Use the following three examples as a guide: English United States, French France, German Germany Example You do not have to supply information for the optional fields, if only the mandatory fields are completed. If you have stored the optional fields previously in the DC directory, leaving them blank here will reset the values to blank.
Chapter 4 Working with Users Updating Users For example, if you entered “#” in the Value for fields to be ignored, a CSV file like the following example tells BAT to keep the Manager field the same as the one that was previously entered in the DC directory but to overwrite User Device Profile and User Locale for this user in the DC directory and set them to blank. userid,#,department,,,123456789012, Updating Users to Cisco CallManager Use this procedure to bulk-update users to Cisco CallManager.
Chapter 4 Working with Users Updating Users Step 6 (Optional) If you want all users that are added in this transaction to be able to log on to a phone on behalf of someone else, check the Enable Authentication Proxy Rights check box. Users with authentication proxy rights enabled represent “super users” or “admin users” who act as the single point of authentication through which all users connect for extension mobility.
Chapter 4 Working with Users Deleting Users Reenter the PIN in the Confirm PIN field. Step 12 In the User Locale drop-down list box, choose the language and country set that you want to associate with this user. Your choice determines which cultural-dependent attributes exist for this user and which language displays in the Cisco CallManager user windows and phones. The values that you entered for User Locale in the CSV file will override the User Locale values that you specify in the user interface.
Chapter 4 Working with Users Deleting Users from Cisco CallManager Deleting Users from Cisco CallManager Use this procedure to bulk-delete users from Cisco CallManager. Procedure Step 1 Start BAT. (See Starting BAT, page 1-3.) Step 2 Choose Configure > Users. The Insert Users window displays. Step 3 In the right corner of the window, click Delete Users. The Delete Users window displays. To locate the users that you want to delete, define the filter.
Chapter 4 Working with Users Deleting Users from Cisco CallManager A message displays that advises you of approximately how long it will take to delete the records in the Cisco CallManager database. You can cancel the transaction or click OK to continue. Step 10 When the transaction completes, check the Status message. BAT displays a status completed or failed message.
