BAT with 6.1.2

Unanswered Question
Jul 8th, 2008

Hello,

I am trying to insert phone records in unified communications manager 6.1.2 using BAT. First I downloaded the bat.xlt template and then constructed the .CSV file, with single line. I uploaded the file to CCM and then tried associating with a custom file format. Am getting an error while associating with the file format "cisco.ccm.bps.common.BPSException: nullBAT Exception : AddFileFormat::setFileFormatCSV: File already has the format"

I moved ahead and tried to validate the phones with the phone template I created but am getting an error message "2001 CSV contains more number of lines than are supported by the phone template"

I initially created the phone template with 2 lines and then tried with single line but still get the same error.

I have this problem too.
1 vote
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Ayodeji oladipo... Tue, 07/08/2008 - 03:09

Amith,

Here are the steps you need to follow to use BAT..

1. use your bat.xlt file to create your csv file. Make sure that the number of lines you select is less than or equals to the number of line on your phone template.

2. Save the file to a location.

Make sure that when you open the file with notepad, there is no blanks between the first line and the last line....This is how to test this...Put your cursor on the first line of your file, then press ctrl&end (key pads on your pc). This should take you to the last letter/number/xter on your file..it should not go to the next line after your last xter. If it does, place your cursor on the last xter and press delete for a while till al the blanks are deleted and then try the test again

3. Go to CCMadmin page>Bulk Administration>Upload/download files>

4. In the file fiels, use the browse menu to select the file you created earlier

5. In the select target field, select either phones/users (depending on what you want)

6.in the select xmision type, choose insert phones..specific details...click save

7. You can validate the phones to be sure your phone template and csv file are okay.

To validate go to CCMadmin>>BAT>phones>validate..

once your validation is good..you should be okay...(sometimes I get error validationg and I still import succesfully)

8. Finally to complete your BAT process..go to CCMadmin>BAT>phones>insert>select insert specific details> then choose your csv file and phone template.

Let me knw how this goes

select your csv file

Amith Kumar Tue, 07/08/2008 - 03:38

hello,

First of all thank you for your detailed steps. I follwed the same exact steps (now I made sure that there is no leading spaces in the text file). I get stuck while validating the phones. Am attaching the the phone template I am using for validation. Also below is the error message I am seeing

"2001 CSV contains more number of lines than are supported by the phone template.

Result Summary :

VALIDATE for 0 PHONE passed.

VALIDATE for 320 PHONE failed.

End Time : 07/08/2008 16:59:57

And while add the file format I am getting the following error

Add Phone File Format

Begin Time : 07/08/2008 17:04:22

End Time : 07/08/2008 17:04:22

Adding File Format to the CSV File : BatNewPhones.txt

The job of adding the File Format is :Failure

Failure Details :

----------------------------------------------------

cisco.ccm.bps.common.BPSException: nullBAT Exception : AddFileFormat::setFileFormatCSV: File already has the format.

Please see if this helps

Ayodeji oladipo... Tue, 07/08/2008 - 03:42

you dont need to add the file format. The file format is already a csv file.

That step is used if you are not using the bat.xlt file.

Dont add the file format, you noticed I did not put that step in the steps I sent to you.

There is nothing attached here. Attach the phone template again

Amith Kumar Tue, 07/08/2008 - 04:12

Yes I tried creating another template and tried but no luck. I dont think I can upload this CSV file but lemme check.

Amith Kumar Thu, 07/10/2008 - 01:39

Hi all,

I got this working. I had missied adding the line template inside the phone template.

Thanks for your help.

Cheers

Amith

Actions

This Discussion