[cisco-voip] CM Admin AXL - question about updatePhone/Lines

[Ed Leatherman]

Thanks for that Wes, confirms what I was thinking. SQL is definitely
how i'm going with this, so I don't magically un-assign any DNs by
mistake.

I've got this mostly coded up in perl to pull in a CSV file generated
by an export from bulk admin, and do the SQL necessary to update the
e164mask (only if its blank). I just need to read up on how to push a
restart through to the phone once the update happens.



On Tue, Oct 11, 2011 at 1:20 PM, Wes Sisk <wsisk at cisco.com> wrote:
> searching around I found this:
>
> "AXL can remove line when there is following requests:-
> 1.       removePhone
>
> 2.       updatePhone (When phone is added with new line. And old line
> which was associated with the phone previously was not mentioned in  the
> request then the old line will not get associate with phone)."
>
> sounds like a nuance of updatephone.
>
> I agree with others that direct SQL may be the easier approach, even if you have to push that SQL statement through AXL due to special character limitation at the CLI. But then I'm an SQL guy previously.
>
> devicenumplanmap table.
>
> /wes
>
>
> On Oct 11, 2011, at 8:23 AM, Ed Leatherman wrote:
>
> Good morning,
>
> I am working on a script to update line appearances on phones to
> properly set the external phone number mask on each appearance on the
> system where it is not currently set.
>
> This is the first time i've worked with the AXL Admin interfaces, so
> this is probably a very simple question.
>
> I've noticed so far that when I send an update for a line appearance
> on a phone that has multiple lines configured, it will properly update
> the line i've specified but it will un-associate the other lines from
> the phone. . for example
> <updatePhone>
>                                       <name>SEP88F0778994A1</name>
>                                       <lines>
>                                               <line>
>                                                       <index>1</index>
>                                                       <dirn>
>
> <pattern>52003</pattern>
>
> <routePartitionName>DP_WVU_Phones</routePartitionName>
>                                                       </dirn>
>
> <e164Mask>3042952003</e164Mask>
>                                               </line>
>                                       </lines>
> </updatePhone>
>
> This correctly sets e164 mask on the line appearance, but any other
> appearances are removed from the phone. I suspect to make this work
> correctly, I must also specify all the other line appearances, even if
> i'm not going to make any changes to them, is this accurate? I will
> try it this later today, would appreciate confirmation though. Any
> options I can specify to avoid that?
>
> I'm thinking this may be more simply done with a SQL query or two if
> I'm going to have to explicitly list every line appearance.
>
> Thanks!
>
> --
> Ed Leatherman
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>



-- 
Ed Leatherman