To add user device profiles to the Cisco Unified Communications Manager database in bulk, use this procedure.
Procedure
Step 1 
Choose Bulk Administration > User Device Profiles > User Device Profile Template.
The Find and List UDP Templates window displays. See the "Creating a Cisco Unified Communications Manager Bulk Administration (BAT) Template for User Device Profiles" section on page 35-2 for information about configuring UDP templates.
Step 2 Create the CSV data file by following the steps for one of these options.
a. BAT Spreadsheet option
Open the BAT spreadsheet and create the CSV data file. See the "Using the BAT Spreadsheet to Create User Device Profile CSV Data Files" section.
b. Text Editor option
–Choose Create UDP File Format.
The UDP File Format Query window displays. See the "Configuring User Device Profile File Formats" section on page 36-1 for information about configuring file formats for CSV data file.
–Use a text editor and create the CSV data file for user device profiles that follows the file format that you want to use. For more information about creating a text-based CSV file, see "Creating a Text-Based CSV File for User Device Profile" section on page A-9
–Choose Add File Format.
The Add File Format Configuration window displays. See the "Adding a File Format" section on page 37-1 for information about file formats.
Step 3 Choose Validate User Device Profiles.
The User Device Profiles Validation window displays. See the "Validating User Device Profiles" section on page 38-1 for information about validating user device profile records.
Step 4 Choose Insert User Device Profiles.
The User Device Profiles Insert Configuration window displays. See the "Inserting User Device Profiles for User Devices" section on page 39-1 for information about inserting user device profile records into the Cisco Unified Communications Manager database.
Additional Topics
See the "Related Topics" section.
Using the BAT Spreadsheet to Create User Device Profile CSV Data Files
When you are adding new user device profiles, you can use the BAT spreadsheet. You can define the file format within the spreadsheet, and the spreadsheet uses the data file formats to display the fields for the CSV data file.
For information about locating and using the BAT spreadsheet, see the "Using the BAT Spreadsheet for Gathering Data" section on page 1-8.
To create the CSV data file by using the BAT spreadsheet for adding new user device profiles, use the following procedure.
Procedure
Step 1 Download the BAT.xlt file from the Cisco Unified Communications Manager server. See the "Downloading a File" section on page 2-2.
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.
Tip 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.
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.
Tip You can change the order of the items in the Selected Line and Device boxes. Choose an item and use the up arrow to move the field closer to the beginning of the list or chose the down arrow to move the item to the end of the list.
Step 7 To modify the CSV data file format, click Create. A message asks whether you want to overwrite the existing CSV format.
Step 8 Click OK. New columns for the selected fields display in the BAT spreadsheet in the order that you specified.
Step 9 To locate the Number of Phone Lines box, scroll to the right. The number of lines that you specify here must not exceed the number of lines that are configured in the BAT template or an error will result when you insert the CSV data file and UDP template.
Step 10 You must enter the number of speed-dial buttons in the Number of Speed Dials box. After you enter the number, columns display for each speed-dial number.
Note Do not exceed the number of speed dials that are configured in the User Device Profile template, or an error will result when you insert the CSV data file and UDP template.
Step 11 Enter data for an individual user device profile on each line in the spreadsheet. Complete all mandatory fields and any relevant optional fields. Each column heading specifies the length of the field and whether it is required or optional. See Table 34-1 for descriptions of the fields in the BAT spreadsheet.
Step 12 To transfer the data from the BAT Excel spreadsheet into a CSV formatted data file, click Export to BAT Format.
The system saves the file to C:\XLSDataFiles\ or to your choice of another existing folder on your local workstation. The filename is
where
Upload the CSV file to Cisco Unified Communications Manager server using the "Uploading a File" section on page 2-3.
you can refer to this link below, for further information
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/bat/7_0_1/t07udpov.html
