Table Of Contents
Working with Users
Adding Users
Creating the CSV File for Users
Using the User Tab in BAT.xlt
Creating an Optional CSV Text File for Users
Adding Users to Cisco CallManager
Adding User/Device Combinations
Creating the CSV File for User/Device Combinations
Using the Phone-User Tab in BAT.xlt
Creating an Optional CSV Text File for Users/Devices
Adding User Combinations to Cisco CallManager
Working with Users
BAT allows you to add users to Cisco CallManager, and associate users to phones or CTI ports.
Adding Users
You can add multiple users to the Cisco CallManager database/Cisco AVVID IP Telephony directory using the following procedures.
Note During the adding users procedure, use the default password abcd in the CallManager Log On screen.
Related Topics
•Using TAPS, page 6-65
•TAPS for End Users, page 6-68
•Creating the CSV File for Users
•Adding Users to Cisco CallManager
•Adding User/Device Combinations
Creating the CSV File for Users
To add users into Cisco CallManager, you must create a CSV file by completing the BAT.xlt file.
Using the User Tab in BAT.xlt
Follow this procedure to add multiple users.
Procedure
Step 1 On the Publisher database server, click C:\CiscoWebs\BAT\ExcelTemplate and double-click BAT.xlt.
Step 2 Click Enable Macros when prompted.
Step 3 Select the Users sheet tab.
Step 4 Complete all mandatory fields and any relevant optional fields. Each column heading specifies the length of the field.
Step 5 Select the CTI Port - Users tab to create a CSV data file to associate CTI ports to users.
Note The system treats blank rows in the spreadsheet as "End of File" and discards subsequent records.
Step 6 Click the Add Devices button to enter additional MAC addresses that will be associated to a new user.
Step 7 Click Export to BAT Format to transfer the data from the BAT Excel spreadsheet into a CSV file.
CSV String Formats for Users
The following example format shows the field length and string types followed by an example of a CSV file for users.
First Name (String[50] MANDATORY),Last Name (String[50] MANDATORY),User Id (String[30] MANDATORY),Manager (String[30] OPTIONAL), MAC Address1 (String[12] OPTIONAL),Directory Number (String[50] OPTIONAL)MAC Address2 (String[12] OPTIONAL)
Example
John,Smith,johns,Daviss,1231123245AB,9725557154
The actual file does not contain field names (displayed in the first line). You must specify delimiters even if a field is blank. Refer to the following example and sample CSV record when creating a CSV file.
Example
If the Manager for a user is blank
John,Smith,johns,,1231123245AB,9725557154,12345677AC22
The Manager is the UserID of an existing user in the Cisco AVVID IP Telephony directory.
Example
A user can control more than one device. You can add MAC addresses of additional devices at the end of the record.
If the user controls only one device, a sample record can be
John,Smith,johns,Daviss,1231123245AB,9725557154,12345677AC22
If the user controls three devices, a sample record can be
John,Smith,johns,Daviss,1231123245AB,9725557154,12345677AC22,1143487AB
345
Creating an Optional CSV Text File for Users
If you do not use the BAT.xlt for data input when adding users, follow this optional procedure to create lines of ASCII text with values separated by commas.
Note Cisco recommends that you use the BAT.xlt file to input data because data validation is performed on that file.
Procedure
To create a CSV text file for users, perform the following steps:
Step 1 Open a text editor or any application that allows you to export or create a CSV file.
Step 2 Enter the following values for each user you want to add to Cisco CallManager:
First Name,Last Name,User ID,Manager,MAC Address1,Directory
Number,MAC Address2
You must enter the Name, User ID, and MAC address. You can leave other fields empty, but you must include the comma separators.
You can associate any number of existing devices to a new user by entering the MAC address of all the devices separated by a comma at the end of the record.
Step 3 Save the file to C:\BATFiles\Users\ on the server running the Publisher database.
Note You cannot use CSV files saved anywhere else for BAT inserts.
Adding Users to Cisco CallManager
Follow this procedure to add batches of users to Cisco CallManager.
Before You Begin
You must create a CSV file before you add a batch of users to Cisco CallManager.
Procedure
To add users, perform the following procedure.
Step 1 Click Configure > Users.
The Insert Users page displays.
Step 2 In the File Name field, select the name of the Users Template you created for this type of bulk transaction.
Step 3 (Optional) A check box provided on this page allows you to Enable CTI usage. Select the Enable CTI Application Use check box to enable CTI usage in the Cisco AVVID IP Telephony directory.
Step 4 Click Insert.
Step 5 Click View Log File to view the results.
Note After the users are added to Cisco CallManager, the application generates a log file indicating the number of records added and the number of records failed, including an error code. For more information on log files, see Chapter 7, "Troubleshooting BAT and TAPS".
Adding User/Device Combinations
You can add combinations of multiple phones and users or CTI ports and users to the Cisco CallManager database using the following procedures.
Related Topics
•Creating CSV Files for Phones and CTI Ports
•Creating the CSV File for Users
•Adding Phones to Cisco CallManager
•Adding Users to Cisco CallManager
Creating the CSV File for User/Device Combinations
To add phone and user combinations or CTI port and user combinations into the Cisco CallManager, you must create a CSV file.
Related Topics
•Using the Phone-User Tab in BAT.xlt
•CSV String Formats for Phone and User Combinations
Using the Phone-User Tab in BAT.xlt
Follow this procedure to quickly import batches of phone and user combinations.
Procedure
Step 1 On the Publisher database server, click C:\CiscoWebs\BAT\ExcelTemplate and double-click BAT.xlt.
Step 2 When prompted, click Enable Macros.
Step 3 Click the Phones-Users sheet tab.
Step 4 Complete all mandatory fields and any relevant optional fields. Each column heading specifies the length of the field.
Step 5 Click the CTI Port - Users tab to create a CSV file to associate CTI ports to new users.
Note The system treats blank rows in the spreadsheet as "End of File" and discards subsequent records.
Step 6 Enter the number of lines in the Number of Phone Lines box that equals the number of directory numbers.
Step 7 Select the Create Dummy MAC Address check box to use the dummy MAC address option.
You must enter the MAC address or use the dummy MAC address option (the MAC address updates when a phone is plugged in).
Step 8 Click Export to BAT Format to transfer the data from the BAT Excel spreadsheet into a CSV file.
CSV String Formats for Phone and User Combinations
The following example format shows the field length and string types followed by an example of a CSV file for phones and users.
First Name (String[50] MANDATORY),Last Name (String[50] MANDATORY),User ID (String[30] MANDATORY),Manager (String[30] OPTIONAL),MAC Address (String[12] MANDATORY),Description (String[50] OPTIONAL),Location (String[50] OPTIONAL),Directory Number (String[50] MANDATORY),Display (String[30] OPTIONAL),Forward Busy Destination (String[50] OPTIONAL),Call Pickup Group (String[50/50] OPTIONAL)
Note For the Manager, use the UserID of an existing user in the USER Directory.
Example
John,Smith,johns,Daviss,1231123245AB,SEP1231123245AB,Dallas,9725557154
,9725557154,9725557172,9725557121/TollByPass
The actual file does not contain field names (displayed in the first line). You must specify delimiters even if a field is blank. Specify Call Pickup Group either as a Directory Number or as Directory Number/Route Partition Name, if a Route Partition restricts the access to the call pickup group.
Refer to the following examples and sample CSV records when creating CSV files.
Examples
If the description for a phone is blank
John,Smith,johns,Daviss,1231123245AB,,Dallas,9725557154,9725557154,972
5557172,9725557121/TollByPass
If the selected phone template supports a maximum of six lines and no active line is required
John,Smith,johns,Daviss,1231123245AB,SEP1231123245AB,Dallas
If no active line is required and the description is also blank
John,Smith,johns,Daviss,1231123245AB,SEP1231123245AB,
If two active lines are required
John,Smith,johns,Daviss,1231123245AB,SEP1231123245AB,Dallas,9725557154
,9725557154,9725557172,9725557121/TollByPass,9725557155,9725557155,972
5557133,9725557112/TollByPass
Note For the MAC address, enter MAC address values or check the option for creating dummy MAC addresses.
If the option for a dummy MAC address is checked
John,Smith,johns,Daviss,1231123245AB,,Dallas,9725557154,9725557154,972
5557172,9725557121/TollByPass
Creating an Optional CSV Text File for Users/Devices
If you do not use the BAT.xlt for data input for phones and users, follow this optional procedure to create lines of ASCII text with values separated by commas.
Tips Use the BAT.xlt file to input data because data validation is performed on that file.
Procedure
Step 1 Open a text editor or any application that allows you to export or create a CSV file.
Step 2 Using a separate line for each phone, enter the following values for each phone and user combination you want to add to Cisco CallManager:
First Name,Last Name,User ID,Manager,MAC
Address,Description,Location,Directory Number,Display,Forward Busy
Destination,Call Pickup Group
You must enter the Name, User ID, and MAC address or use the dummy MAC address option on the Insert Phones\Users page (the MAC address updates when a phone is plugged in). You may leave other fields empty, but you must include the comma separators.
If the dummy MAC address option is checked, the following example shows a sample CSV record:
John,Smith,johns,Daviss,,SEP1231123245AB,9725557154
Step 3 Save the file to C:\BATFiles\PhonesUsers\ on the server running the Publisher for Cisco CallManager.
Note You cannot use CSV files saved anywhere else for BAT inserts.
Adding User Combinations to Cisco CallManager
Follow this procedure to add phone and user combinations or CTI port and user combinations to Cisco CallManager.
Before You Begin
You must create a CSV file before you add user combinations to Cisco CallManager.
Procedure
Step 1 Click Configure > Phones/Users.
The Insert Phones/Users page displays.
Step 2 In the File Name field, select the name of the template you created for this type of bulk transaction.
Step 3 In the Phone Template Name field, select the phone template you created for this type of bulk transaction.
Step 4 (Optional) Select the Create Dummy MAC Address box to use the dummy MAC address option.
Step 5 (Optional) Select the Enable CTI Application Use check box to enable CTI usage in the Cisco AVVID IP Telephony directory.
Step 6 Click Insert.
Step 7 Click View Log File to view the results.
Note After the users are added to Cisco CallManager, BAT generates a log file indicating the number of records added and the number of records failed, including an error code. For more information on log files, see Troubleshooting BAT and TAPS.
Related Topics
Creating the CSV File for User/Device Combinations