User guide

Step 3
Choose Validate User Device Profiles.
The User Device Profiles Validation window displays.
Step 4
Choose Insert User Device Profiles.
The User Device Profiles Insert Configuration window displays.
Related Topics
Add user device profile file format, on page 307
Create Bulk Administration Tool (BAT) template for user device profiles, on page 296
Create text-based CSV file for user device profile, on page 593
Create user device profile CSV data files using BAT spreadsheet, on page 282
Insert user device profiles for user devices, on page 311
Topics related to user device profiles, on page 293
User device profile file format setup, on page 303
Validate user device profiles, on page 309
Create user device profile CSV data files using BAT spreadsheet
You can create the CSV data file for adding new user device profiles using the BAT spreadsheet. When you
use the BAT spreadsheet to add new user device profiles, you can define the file format within the spreadsheet.
The spreadsheet uses the data file formats to display the fields for the CSV data file.
After you have finished editing all the fields in the BAT spreadsheet, you can export the content to a CSV
formatted data file. The file is saved to C:\XLSDataFiles or to your choice of another existing folder on
your local workstation and is assigned a default filename:
<tabname>-<timestamp>.txt
where <tabname> represents the type of input file that you created, such as phones, and <timestamp> represents
the precise date and time that the file was created.
Procedure
Step 1
Download the BAT.xlt file from the Cisco Unified Communications Manager server.
Step 2
Open the BAT spreadsheet. When prompted, click Enable Macros to use the spreadsheet capabilities.
Step 3
To display the User Device Profiles options, click the User Device Profile tab at the bottom of the spreadsheet.
Step 4
To choose the device and line fields that you can define for each user device profile, click Create File Format.
The Field Selection popup window displays.
Step 5
To choose the device fields, click a device field name in the Device Field box, and then click the arrow to
move the field to the Selected Device Fields box.
A CSV data file must include Device Profile Name and Description; therefore, these fields always remain
selected.
You can select a range of items in the list by holding down the Shift key. To select random field names,
hold down the Ctrl key and click field names.
Tip
Step 6
Click a line field name in the Line Field box and click the arrow to move the field to the Selected Line Fields
box.
Cisco Unified Communications Manager Bulk Administration Guide, Release 9.1(1)
282 OL-28580-01
Add user device profiles
REVIEW DRAFT - CISCO CONFIDENTIAL