When creating your own CSV file to be used by Cisco Unified Communications Manager BAT,
which three rules do you need to follow? (Choose three.)
A.
Do not enter blank lines; otherwise, errors occur during the insert transaction.
B.
Edit the Excel macro for each separate Unified Communications Manager BAT transaction.
C.
Use a separate line for each data record.
D.
Separate each data field with a comma and include comma separators for blank fields.
E.
Disable Excel macros after adding data and prior to the CSV file upload to the Unified
Communications Manager BAT service.
Explanation:
Cisco Unified Communications Manager Bulk Administration Guide
Release 8.6(1), page-588.
Step 1 Open a text editor (such as Microsoft Notepad) or any application that allows you to export
or create a CSV file.
Step 2 Use a separate line to enter the values for each phone, IP telephony device, or user
combination that you want to add to Cisco Unified Communications Manager. You must create
separate CSV files for each type of device. Keep in mind the following rules when you create the
CSV data file.
• Always include comma separators, even if a field is blank.
• Specify the user ID if the phone is to be associated to a user.
• Directory Number fields are optional only when you are creating the CSV file for use with a BAT
template that has no lines. If lines are configured on the BAT phone template, you must supply
directory numbers in the CSV file for each device.
• An error occurs when you insert a CSV file with blank lines.
• While saving your CSV file, choose to save it as ‘UTF-8’ encoded. In Notepad, you can select
encoding as ‘UTF-8’ from the Encoding dropdown.
Step 3 Upload the CSV file to the first node of Cisco Unified Communications Manager.