Bulk adding lines to VG224 FXS ports

Unanswered Question
Nov 19th, 2008
User Badges:

Hi All,


I have a serious problem that I need your help on.


I have 60 VG224's to add to a Call Manager 6.1 cluster along with the associated line information for each of the FXS ports. I have managed to create a VG224 template which creates and BAT file to create the gateways and ports but how do you add the lines to each port.


Can someone tell me how I can do this using BAT.


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
alijames Thu, 11/20/2008 - 05:08
User Badges:
  • Bronze, 100 points or more

You need to add a column for 'PORT DIRECTORY NUMBER' to your BAT file. The Headers I use are :

DOMAIN NAME DESCRIPTION PORT DESCRIPTION PORT DIRECTORY NUMBER SLOT SUBUNIT PORT NUMBER DEVICE POOL LINE CSS VOICE MAIL PROFILE ALERTING NAME ALERTING NAME ASCII LINE DESCRIPTION ASCII DISPLAY DISPLAY


Everything else, I set in the Template.


Hope this helps.


Alistair


r.robins Thu, 11/20/2008 - 05:12
User Badges:

Alistair,


Thanks for the response and soory to sound dumb, but which tab are you creating this in within BAT. Can you send a copy of BAT 6.1 with this already set so I can see what you mean.


Regards

alijames Thu, 11/20/2008 - 05:19
User Badges:
  • Bronze, 100 points or more

Hi,


I gave up trying to use the BAT.xlt file.


I create a CSV file with the above headers in the 1st row, then populate for each port on each row.


Note, there are MANY bugs in the 6.1 BAT import for VG224s, so for it to work, the following conditions need to be true.


1. The gateway must not already exist in CUCM. Delete it 1st if necessary.


2. All ports must have a PORT DIRECTORY NUMBER assigned, otherwise they are not added correctly. I use dummy numbers for any currently unassigned ports, then delete them afterwards.


Hope this helps,


Alistair


alijames Thu, 11/20/2008 - 06:00
User Badges:
  • Bronze, 100 points or more

Also, I have been assured that the BAT for gateways will be much improved in CUCM 7.


Cheers,


Alistair

dconstantino Thu, 11/20/2008 - 06:22
User Badges:

Guys I agree just setting up a CSV is much easier than the BAT tool in 6.1x I have run into the same problem with BAT on the versions.


It is bad enough that I have to continue to learn a new solution or feature every couple of months now we are still troubleshooting BAT issues that have been around since I started working on this stuff. CCM 2.4 1999


I thought after ten years I could start learning other products and moving into other areas but I can barley keep up with UCM,UCCX, CUPS and gateways.



I hope a lot is fixed in 7.01 if it ever starts shipping without engaging my channel rep.

r.robins Thu, 11/20/2008 - 06:50
User Badges:

Gents thanks for your input.


I created a CSV file as below.


DOMAIN NAME, DESCRIPTION, PORT DESCRIPTION, PORT DIRECTORY NUMBER, SLOT, SUBUNIT, PORT NUMBER, DEVICE POOL, LINE, CSS,

DRX-VG224-121,testgateway,port0,7676,2,0,0,DRAX_STANDARD_DEVICE_POOL,1,Drax_Unrestricted_CSS,

DRX-VG224-121,testgateway,port1,7677,2,0,1,DRAX_STANDARD_DEVICE_POOL,1,Drax_Unrestricted_CSS,



Import the file and then add a gateway with VG224 Template and CSV file.


The add gatteway job fails and I get error:-


Insert Gateways


Begin Time : 11/20/2008 14:43:29


Failure Details :


Domain Name Error Code Error Description


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


1(Record Number 1) 2004 LINE is blank.


Result Summary :


INSERT for 0 Gateway passed.


INSERT for 1 Gateway failed.


End Time : 11/20/2008 14:43:29


Any Ideas.

alijames Thu, 11/20/2008 - 07:58
User Badges:
  • Bronze, 100 points or more

Hi,


The 'LINE CSS' is one column header, and you should not have the trailing comma, or the '1'.


ie


DRAX_STANDARD_DEVICE_POOL,1,Drax_Unrestricted_CSS,


Should be


DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS


Also make sure there is no blank line after the second row.


Cheers,


Alistair

r.robins Thu, 11/20/2008 - 10:26
User Badges:

I have finally got the file to create the gateway now, however it still fails to add the extension numbers to Line 1 on the FXS ports 0 through to 23.


Is this possible ?


File used was as below:


DOMAIN NAME,DESCRIPTION,PORT DIRECTORY NUMBER,SLOT,SUBUNIT,PORT NUMBER,PORT DESCRIPTION,DEVICE POOL,LINE CSS

DRX-VG224-121,Gateway 121,7400,2,0,0,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7401,2,0,1,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7402,2,0,2,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7403,2,0,3,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7404,2,0,4,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7405,2,0,5,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7406,2,0,6,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7407,2,0,7,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7408,2,0,8,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7409,2,0,9,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7410,2,0,10,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7411,2,0,11,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7412,2,0,12,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7413,2,0,13,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7414,2,0,14,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7415,2,0,15,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7416,2,0,16,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7417,2,0,17,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7418,2,0,18,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7419,2,0,19,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7420,2,0,20,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7421,2,0,21,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7422,2,0,22,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS

DRX-VG224-121,Gateway 121,7423,2,0,23,TestPort0,DRAX_STANDARD_DEVICE_POOL,Drax_Unrestricted_CSS



I am beginning to think that this is just not possible.

alijames Thu, 11/20/2008 - 11:40
User Badges:
  • Bronze, 100 points or more

Trust me. It is possible. The documentation is pretty average at best, and it took me a couple of weeks of tinkering to get it to work properly.


I have since added >50 gateways in the last month or so using BAT files with CUCM 6.1.2.


It may be a problem with your gateway template.


Have you got port 0 of the gateway template configured (ie no little yellow ? next to the telephone symbol), and also you need a line template for that port as well, with all the line defaults set?


You don't need to configure the other 23 ports though...


Cheers,


Alistair

r.robins Fri, 11/21/2008 - 00:46
User Badges:

Alistair,


After much testing I have now succeeded.


For anyone else out there, Create a Gateway template with all ports defined as POTS, go into the first port (0) and create a Line template.


Create a csv file as per my previous entry, import to Call Manager.


Insert a new Gateway using the csv file and Gateway template.



alijames Fri, 11/21/2008 - 00:47
User Badges:
  • Bronze, 100 points or more

Excellent. Glad you have it working.


Cheers,


Alistair

hbarrera2 Tue, 12/02/2008 - 13:32
User Badges:

Hi Guy's,


I was just starting to do the bat prep work for loading in 40 vg224's into my CUCM 6.1.2.


I wanted to double check the forums and came across this trail...good info. their is a bug in the BAT 6.1.2 1000(13) tested it myself! So as advised I used 6.1.1 2000(3) older bat sheet and it worked perfect.


I also had my template pre-built with port 0 and the line on port 0 pre-built...worked like a charm!


Thanks guy's

r.robins Tue, 12/02/2008 - 14:03
User Badges:

Glad it was of some help.


Why oh Why can Cisco not produce documentation that covers features like this.


Have now adde 48 of 60 gateways and they all seem to be working so far.

m_jabiyev Sun, 01/17/2010 - 22:15
User Badges:

Hello to everyone,

We have exactly same scenario as in first topic of this discussion: 60 VG224 units and CUCM 7.1. The problem is that we cannot activate more than 10 ports on any gateway using VG224-BAT-sample published here. In same time all 24 ports activating manually from CCM and with no problem. Do you have an idea regarding this issue? Thank you in advance.

Murad

alijames Sun, 01/17/2010 - 23:10
User Badges:
  • Bronze, 100 points or more

Hi,


We have the same here. It is a bug in 7.1(3). See Bug ID CSCtd08748 for the details.


Using MGCP is the workaround, but this is not an option for us, so we have upgraded our development cluster to 7.1(3b)SU1 and I can confirm it does fix the above bug. We will if all goes well, roll this version out to our Production cluster in a few weeks.


Hope this helps,


Alistair

m_jabiyev Mon, 01/25/2010 - 03:22
User Badges:

Hi Alistair,

You've been right about 7.1(3b)SU1 upgrade. After 5-6 days trying we finally got this software and upgraded our CCM. Now we have all 24 analog ports registred and DN assigned correctly. But we cannot activate call forward all feature through bulk tool. Is it another bug or something wrong with our fingers? I attached the CSV file.

Thank you for help.

Murad

Attachment: 
alijames Mon, 01/25/2010 - 08:27
User Badges:
  • Bronze, 100 points or more

Hi,


I remember seeing something about this a while ago, and you need to put in a column for 'Forward All', and leave it blank for unticked, and put a 't' in the row to tick the option.


Hope this helps.


Alistair

m_jabiyev Mon, 01/25/2010 - 22:30
User Badges:

Hi Alistair,

Thank you for reply. Do you remember where you seen this post? We can acutivate this function for each analog port one-by-one but cannot get it work by template. Is this matter where locate the "Forward All" column in the CSV file?


Murad

keongnk Wed, 02/24/2010 - 00:11
User Badges:

Dear Murad, are you managed to solve the VG224 with Call Forward All issue when bulk it using gateway template? I am facing the same problem as well.. I am able to bulk all the line configuration include the CFNA CSS, CFB CSS,.. but not CFA CSS although I already put it in the CSV file. Attached is the CSV file that I bulk it to the CallManager.

Frederick Nielsen Tue, 03/02/2010 - 14:03
User Badges:
  • Bronze, 100 points or more

Alistair, ran into  CSCtd08748 today and your posted helped me.  Thanks!  Not sure why VG224 BAT'ing remains such a problem area.

Actions

This Discussion