|
Home > Archive > Voice over IP Cisco > October 2006 > Updating e164Mask (was: Lines in UpdatePhone)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Updating e164Mask (was: Lines in UpdatePhone)
|
|
| Nathan Reeves 2006-10-26, 1:11 pm |
| I recently had to do the same and like you found the UpdatePhone
command was the one that could complete the task. That said, I never
really managed to get this working properly. Not saying that
UpdatePhone was broken, just that I didn't have the time to run
through and write up a script to run the command. The biggest pain
was having to call up the current phone settings and then using the
details, re-create the XML to pass to UpdatePhone to update the
E164Mask. I'm not sure cisco could have made it any harder to make a
somewhat simple change.
In the end I just ended up doing searches via AXL for each Line UUID,
and then constructed SQL strings to update the E164Mask which I
executed in Query Analyser on the Pub. I initially tried to use the
ExecuteSQL command to run the SQL update command, but found pretty
quickly that the ExecuteSQL is only built for select queries and not
Update Queries. A new AXL command has apparently been added to 5.0
which allows for update SQL to be executed against the DB. This isn't
available in 4.X AFAIK.
I'm not sure this helps you much, but you should be able to execute
SQL in Query Analyser to update the mask. Usual caveats apply if
you're touching the DB; make sure you have a backup, and try the
commands out in a lab env. beforehand etc.
Cheers
Nathan
| |
| Dennis Ploeger 2006-10-26, 1:11 pm |
| Hi!
> In the end I just ended up doing searches via AXL for each Line UUID,
> and then constructed SQL strings to update the E164Mask which I
> executed in Query Analyser on the Pub.
Hmm.. I tried that, but it didn't work. I've posted the update-command
like this:
update devicenumplanmap set e164Mask=3D'23818744650' where
pkid=3D'{79627b9d-c6c8-154d-9221-4f8cd0755b17}'
That came back without an error, but without changing something, too. I
still had the same e164Mask at that phone..
What did I do wrong?
Thanks.
Kind regards,
Dennis Ploeger
-- =
Dennis Pl=F6ger
Administrator Internet Services
HeLi NET
Telekommunikation GmbH & Co. KG
**Achtung! Neue Anschrift!**
Hafenstrasse 80-82 - 59067 Hamm
Tel. 02381 / 874-4602
Fax 02381 / 874-4650
dennis.ploeger@helinet.de
OpenPGP Key ID: 0x4081184E
keyserver: subkeys.pgp.net
Key fingerprint =3D 9181 1775 8931 7F0B B8E7 D536 82A8 32E0 4081 184E
|
|
|
|
|