When creating your own CSV file to be used by Cisco Unified Communications Manager BAT,

87
Cisco 642-447 Exam
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:
Reference : Cisco Unified Communications Manager Bulk Administration Guide Release 8.6(1), page-588.

Incorrect answer: B

Explanation :
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.