Bulk adding lines to VG224 FXS ports

Unanswered Question
Nov 19th, 2008

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.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
alijames Thu, 11/20/2008 - 05:08

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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.

Actions

This Discussion