[cisco-voip] VG224 Upload

Wed Apr 1 07:33:00 EDT 2009

You could use SQL queries from the server cli.  something like the following
would move all of the DNs in your staging partition to the production
partition.

run sql update dnorparttern set fkpartition = ( select pkid from partition
where name = 'Production PT') where fkpartition = (select pkid from
partition where name = 'Staging PT')

This is off the top of my head so the syntax might not be 100% Search CCO
for the CallManager data dictionary for complete details on the db
structure.

Another option might be to delete the gateways and reimport them using a
different partition in the template when you are ready to go live.  this
would only work if you cut each gateway as a whole since you cannot import
partial VGs.

Otherwise I think your only option is to limber up your mouse clicking
finger and do them one by one.

On Mon, Mar 30, 2009 at 7:36 AM, Webber, Bill <Bill.Webber at tri-c.edu> wrote:

>  So what do we do since we’re running MGCP?
>
>
>
> Thanks,
>
>
>
>
>
>  Bill Webber
>
> 2900 Community College Avenue
>
> MSS-500
>
> Cleveland, OH 44115
>
> 216-987-4372
>
>
>
>
>
>   ------------------------------
>
> *From:* Kris Seraphine [mailto:baryonyx5 at gmail.com]
> *Sent:* Saturday, March 28, 2009 11:18 AM
> *To:* Lelio Fulgenzi
> *Cc:* Webber, Bill; cisco-voip voyp list
>
> *Subject:* Re: [cisco-voip] VG224 Upload
>
>
>
> For SCCP VG224 ports the Domain Name field should be the gateway name
> (SKIGW+last 10 of MAC).
>
> Be aware that there are some bugs in CM 6.1 concerning BAT and VG224's.
> For one, if you have shared lines on any VG ports, the subsequent ports with
> the same DN will import but the DN will not be assigned to the line.  This
> will log an error in the BAT log saying something like 'iscallable flag
> cannot be set'
>
> I recommend importing into a temporary partition as stated below.  For SCCP
> VG ports, when the time comes to put them into production you can use BAT
> (add/update lines) to move the DNs to your production partition.  This won't
> work for MGCP ports however.
>
>
>  On Fri, Mar 27, 2009 at 1:07 PM, Lelio Fulgenzi <lelio at uoguelph.ca>
> wrote:
>
> Replying to the list for mutual benefit and additional comment.....
>
> I'm not sure what the domain name field is for. That might be for MGCP
> registration which needs hostname + domain name matching in order to
> register. SCCP doesn't need that.
>
> You can forward the extension to the Nortel, if your route patterns and
> gateways are setup properly. This allows a user to unforward their phone.
>
> However, consider bulk loading in a temporary partition, then moving them
> to a dialable partition.
>
>
>
> ----- Original Message -----
> From: "Bill Webber" <Bill.Webber at tri-c.edu>
>
> To: "Lelio Fulgenzi" <lelio at uoguelph.ca>
> Sent: Friday, March 27, 2009 11:56:26 AM GMT -05:00 US/Canada Eastern
> Subject: RE: [cisco-voip] VG224 Upload
>
> Thanks.  I’m new to this so I’m not sure where to find the Domain Name to
> copy into the Domain Name field.  Also we since we’re moving from Nortel to
> Cisco we need to make sure the phone numbers still ring on Nortel phones
> until we cut over so we use #xxxx (4 digit phone extension) for call forward
> all.  Is it possible to do this using the bat file or do we need to manually
> change each port or???
>
>
>
> Thanks,
>
>
>
>  Bill Webber
>
> 2900 Community College Avenue
>
> MSS-500
>
> Cleveland, OH 44115
>
> 216-987-4372
>
>
>
>
>   ------------------------------
>
> *From:* Lelio Fulgenzi [mailto:lelio at uoguelph.ca]
> *Sent:* Friday, March 27, 2009 11:39 AM
> *To:* Webber, Bill
> *Cc:* cisco-voip at puck.nether.net
> *Subject:* Re: [cisco-voip] VG224 Upload
>
>
>
> I believe CUCM 6 has bulk load for VG224. Check out the bulk load template
> for confirmation.
>
> ---
> Lelio Fulgenzi, B.A.
> Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
> (519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> "Bad grammar makes me [sic]" - Tshirt
>
>
> ----- Original Message -----
> From: "Bill Webber" <Bill.Webber at tri-c.edu>
> To: cisco-voip at puck.nether.net
> Sent: Friday, March 27, 2009 11:21:58 AM GMT -05:00 US/Canada Eastern
> Subject: [cisco-voip] VG224 Upload
>
> We have hundreds of analog devices that need to be “input” to CallManager
> (6.1.2.1002-1).  These are of course VG224’s.  Is there a way to “bulk load”
> the port information via a CSV file.  Right now we’re manually inputting the
> information.
>
>
>
> Thanks,
>
>
>
> Bill Webber
>
>
>
>
> _______________________________________________ cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>
>
> --
> kris seraphine
>

-- 
kris seraphine
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090401/eb21f347/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 2846 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090401/eb21f347/attachment.jpe>