[cisco-voip] Changing directory numbers in bulk

[Beck, Christopher]

I am building a 7.1 callmanager cluster parallel to our existing 4.2.3 cluster as part of an upgrade.  I started from a clean DMA.

I am attempting to bring a couple sites inline with our dialplan standard, which involves changing existing 4 digit DNs to 10 digit DNs.  There are about 1500 affected directory numbers, so I don't really want to do it by hand. <grin>

I have been looking at the AXL SQL TOOLKIT.  I can get it to respond correctly to SELECT statements with the affected DNs, so I know the where logic is correct.  But, when I change to the update <table> set <directory number> statement, I get a syntax error.

The query in question is as follows.

<sql query="update numplan set numplan.dnorpattern = '3124364541' from numplan,routepartition where numplan.dnorpattern = '4541' and routepartition.name = 'CW-DN' and numplan.fkroutepartition = routepartition.pkid"/>


Is what I am trying possible?  Is the database permission such that a specific user is required for execution?  (I am using administrator account.)

Any help is appreciated.

Thanks!


Chris Beck
IT Lead - Voice Technologies
USG Corporation
+13124364541 (office)
+13127305524 (Mobile)
+13126724541 (FAX)
+18478599677 (FINDME)
cbeck at usg.com



Confidentiality Notice: This email is intended for the sole use of the intended recipient(s) and may contain confidential, proprietary or privileged information. If you are not the intended recipient, you are notified that any use, review, dissemination, copying or action taken based on this message or its attachments, if any, is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy or delete all copies of the original message and any attachments. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090717/baaab0ba/attachment.html>