Rob Huffman Sat, 07/19/2008 - 16:14
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Hi Chad,


This is not supported in "older" CCM Versions;


CSCeg88823


Symptom:

BAT does not support adding VG224 ports in bulk


Conditions:

This is for all version of BAT and all current version of Callmanager 3.x, 4.x, 5.x



It is now supported in CCM 6.x


http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/bat/6_0_1/t08gwins.html#wp1345635


Hope this helps!

Rob

alijames Tue, 07/22/2008 - 07:48
User Badges:
  • Bronze, 100 points or more

Hi Chad,


I've got BAT working fine with VG224s on CUCM 6.1.


My current issues I have so far are:


1. Bug ID CSCso4934, with DNs that already appear in CUCM.


2. Can't seem to find how to imitate the tickbox for forward to voicemail in BAT. All the options I have tried either don't work, or throw an error...


Cheers,


Alistair




Chad Stachowicz Tue, 07/22/2008 - 07:55
User Badges:
  • Silver, 250 points or more

Alistair, I believe that this needs to be done in the BAT Template. The actual BAT.xlt doesnt allow for box checking..


Chad

alijames Tue, 07/22/2008 - 07:59
User Badges:
  • Bronze, 100 points or more

Chad,


I'm not using the BAT.xlt. Not exactly easy to use!!


I create my own CSV file. Currently hand edited, but web based scripts are in development...


Also, one of our guys is looking at using SOAP to provision them as well, as this then eliminates the need to log into the publisher every time!!


Cheers,


Alistair






Chad Stachowicz Sat, 08/30/2008 - 21:55
User Badges:
  • Silver, 250 points or more

VG224 SCCP seems broken in 6.1.2. It will create the gateway but not the ports.. I am getting the newest ES published to me right now to see if it fixes BAT :)


Chad

dom_rozzi Wed, 04/01/2009 - 13:09
User Badges:

Chad, did the ES seems to fix BAT? Also, I've been able to create the .csv file using BAT6.1.1 successfully, but I still cannot get it to import correctly. My problem seems to be in the template. Have you had to configure each port in the template?

Ayodeji Okanlawon Tue, 07/22/2008 - 08:29
User Badges:
  • Super Bronze, 10000 points or more
  • Cisco Designated VIP,

    2017 IP Telephony

Rob,


Again to the rescue! +5 points for this..


Chad,


I dont believe your 4 points appreciated rob enough, for this life saving information!..So I have helped you.:)

Hi Rob,


thanks for the link :)


I am having trouble importing SCCP vg224's. (I am running 6.1.3)


When i export the csv file from the bat when doing SCCP the export works fine

but when i look at the file, the first column is labeled DOMAIN Name, instead of the MAC address required by SCCP


so when i try and validate the file it says DOMAIN Name not supported.

(trying to match against a VGC phone template, is that what i should be matching it too?)


Am i using the wrong template in call manager? can i just change the heading in the .csv file (what would the correct heading be?)


Thanks for any help, i have a project coming up where i will need to create 100 vg224's


Ken

dom_rozzi Thu, 05/28/2009 - 07:08
User Badges:

Ken,

I found the following headers to be successful for bulk add of VG224 ports:

DOMAIN NAME,DESCRIPTION,SLOT,SUBUNIT,PORT DIRECTORY NUMBER,PORT NUMBER,PORT DESCRIPTION,CSS,DEVICE POOL,LOCATION,PHONE TEMPLATE,SECURITY PROFILE,DEVICE MOBILITY MODE,PARTITION,ALERTING NAME,ALERTING NAME ASCII,DISPLAY,ASCII DISPLAY,EXTERNAL PHONE NUMBER MASK,FORWARD ALL CSS,SECONDARY CSS FOR FORWARD ALL,FORWARD BUSY INTERNAL CSS,FORWARD BUSY EXTERNAL CSS,FORWARD NO ANSWER INTERNAL CSS,FORWARD NO ANSWER EXTERNAL CSS,FORWARD NO COVERAGE INTERNAL CSS,FORWARD NO COVERAGE EXTERNAL CSS,FORWARD ON CTI FAILURE CSS,FORWARD UNREGISTERED INTERNAL CSS,FORWARD UNREGISTERED EXTERNAL CSS


Of course you may not want to do all the CSS fields. I just made sure the Domain Name was in the following format: SKIGW.


Good luck,

Dom

dom_rozzi Thu, 05/28/2009 - 15:48
User Badges:

Ken,


Those headers will work for SCCP installation. The Domain Name is SKIGW and the MAC address of the VG224. When you set up the slot,subunit and port, it defines the "AN<10 from MAC>4XX" Device Name that you see in CCM. The key is that you need to have port 0 set up with a line set up in your template. Your import file will overwrite port 0, but without it, no records are written.


dom_rozzi Thu, 05/28/2009 - 17:23
User Badges:

You will need to import this as a gateway. I think it's OK to have the geteway in place (it's been a while). You need to have an entry for ports 0-23 in the import. The Domain Name is the same in each entry, the description, subunit and CSS fields would be the same, your DN , alerting/display names and ports would be different. I think the hardest part was setting up the SCCP analog phone template that the import utilizes. You have to do that through the Insert Gateway template area. Create your gateway template and from within the gateway template is where you'll be able to create your analog phone template on port 0. Once you have this, your import will go smooth.

panjwani80 Sun, 06/14/2009 - 22:11
User Badges:

Hi Guys,


i am having nightmares too adding VG224 SCCP to CUCM 6.1.2 using BAT.


1) I have created a gateway template named "0024CEF12F" (10 characters of MAC address)


2) setup first port 2/0/0 with device template named "AN0024CEF12F400" and line template named "224lines"


3) tried to create CSV file using BAT.xlt under VG224 tab. The first field is "MAC address/Device Name" which only seems to accept 10 character MAC address.


4) Also gave it shot using following text CSV file but got error messages


DOMAIN NAME,DESCRIPTION,PORT DIRECTORY NUMBER,SLOT,SUBUNIT,PORT NUMBER,PORT DESCRIPTION

0024CEF12F,test port 1,1001,2,0,0,test fax 1

0024CEF12F,test port 2,1002,2,0,1,test fax 2

0024CEF12F,test port 2,1003,2,0,2,test fax 3


**********************************

lang.StringIndexOutOfBoundsException: String index out of range: 15


Could not insert new row - duplicate value in a UNIQUE INDEX column.


lang.StringIndexOutOfBoundsException: String index out of range: 15


Could not insert new row - duplicate value in a UNIQUE INDEX column.


lang.StringIndexOutOfBoundsException: String index out of range: 15


Could not insert new row - duplicate value in a UNIQUE INDEX column.






Result Summary :



INSERT for 0 Gateway passed.


INSERT for 3 Gateway failed.

********************************


so looks like it is trying to add 3 gateways as oppose to 1 gateway with 3 lines???


Any help would be highly appreciated!


Thanks

alijames Sun, 06/14/2009 - 22:44
User Badges:
  • Bronze, 100 points or more

Hi,


From your sample csv:


Not sure about the template name, but I would probably avoid using any part of the MAC address in the template.


The Domain Name field needs to be of the form :

SKIGWxxxxxxxxxx, where xxxxxxxxxx is the LAST 10 characters of the MAC address.


Also, I have found that the directory number needs to be unique, and not already existing in CallManager prior to the Gateway insert.


Finally, I found that I had to populate all 24 ports with a Directory Number, or the BAT insert would fail. (I have a dummy range which I use to fill in the blanks, and then just delete them afterwards.)


Hope this helps.


Alistair

panjwani80 Sun, 06/14/2009 - 23:43
User Badges:

Alistair, thanks for your quick response.


I have followed your recommendation but same error message


so i have change the name of BAT template


changed Domain name to SKIGWXXXXXXXXXX and configured all 24 ports


it appears that BAT is trying to add 24 gateways rather than 1 gateway with 24 ports?? i would really appreciate if you can advise brief step by step process of adding VG224 itself and the 24 ports to it.


Many Thanks

Aamir

alijames Mon, 06/15/2009 - 00:48
User Badges:
  • Bronze, 100 points or more

Hi Aamir,


Attached is a sample csv file which I have just tried on my system and it works fine. You could always use this as a template.


Cheers,


Alistair





panjwani80 Mon, 06/15/2009 - 17:11
User Badges:

Thanks Alistair your csv file just works for me as well :) 5 points for that!



Tommer Catlin Tue, 08/18/2009 - 11:07
User Badges:
  • Green, 3000 points or more

I am at a total lose here on how to do this. I cant figure out why it's so hard for Cisco to put in an easy way to import VG224s into the CUCM as SCCP. If the go in as MGCP, we cant bulk edit the ports. If we use SCCP, we cant bulk import with CSV files because there is not a phone template for the device. But the device "Analog Phone" shows up after you manually build out the phone.


So what is short answer to build out the VG224 through bulk?


Do I need to create the Gateway template and configure all ports on the device, then create a csv file for import for it with the lines?


Or is there another way?

Tommer Catlin Tue, 08/18/2009 - 11:12
User Badges:
  • Green, 3000 points or more

Alistair -


Do I need to create a gateway template first?

Tommer Catlin Tue, 08/18/2009 - 11:34
User Badges:
  • Green, 3000 points or more

I created my gateway SCCP, then I created only one port on the gateway. Used your template, copy paste and uploaded. Ran it and it inserted fine.


I sure was doing it backwards. I tried every combination. (import/exports, BAT, etc)


Anyways... thanks!

Actions

This Discussion