[cisco-voip] CCM dial peer changes.

[Matthew Saskin]

I guess I should put a disclaimer on some of my comments.
Please don't do this outside a lab unless you are very very sure of what 
you're doing or don't mind staying up all night restoring a system ;)

-matt

Wes Sisk wrote:
> danger - CM4.x and earlier does not do data validation at the database 
> level.  data is only validated via admin and axl interfaces.
>
> net result to you:  the system does not protect itself from dangerous 
> changes performed via direct SQL update.  it allows you to 
> insert/modify data that can have dire consequences.  While this is 
> possible, it is dangerous and is not user friendly.  Always take a 
> backup and be prepared to restore from backup when performing any 
> direct database update.
>
> /wes
>
> Matthew Saskin wrote:
>> Look in the CCM03xx database at the NumPlan table:
>> calling number mask = CallingPartyTransformationMask field
>> can't think (off the top of my head) of what you're referring to by the 
>> use phone check box.
>>
>> -matt
>>
>> Jim McBurnett wrote:
>>   
>>> The calling number mask and the use phone check box.
>>>
>>> I should have said- CCM Route patterns…
>>>
>>> For some reason I have a bad habit to call route patterns dial peers..
>>>
>>> Jim
>>>
>>> * From: * Lelio Fulgenzi [mailto:lelio at uoguelph.ca]
>>> *Sent:* Thursday, February 14, 2008 7:47 PM
>>> *To:* Jim McBurnett; Cisco Voice
>>> *Subject:* Re: [cisco-voip] CCM dial peer changes.
>>>
>>> what sort of changes do you have to make? i would probably use 
>>> something like awk to input the configs and output them with the 
>>> appropriate changes.
>>>
>>>     ----- Original Message -----
>>>
>>>     * From: * Jim McBurnett <mailto:jim at tgasolutions.com>
>>>
>>>     * To: * Cisco Voice <mailto:cisco-voip at puck.nether.net>
>>>
>>>     * Sent: * Thursday, February 14, 2008 7:39 PM
>>>
>>>     * Subject: * [cisco-voip] CCM dial peer changes.
>>>
>>>     Hey folks,
>>>
>>>     I need to make changes to about 110 out of about 200 dial peers.
>>>
>>>     Does anyone have a means to make the same change to them easily?
>>>
>>>     I have poked around in SQL2000 but it just is not making sense…
>>>
>>>     Someone on the list had a link or a tool but I can’t find it now…
>>>
>>>     Ideas?
>>>
>>>     Thanks,
>>>
>>>     Jim
>>>
>>>     _______________________________________________
>>>     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
>>>   
>>>     
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>