[cisco-voip] AXL/Perl/SOAP newbie help

[Pavan K]

Matthew,

Try the following with a dummy device. Tested on an 8.6(2) box.

=====

admin:run sql update device set fkenduser=(select pkid from end user where
userid ='USERID') where name = 'DEVICENAME' ;

======

-Pavan


On Aug 15, 2013 7:34 PM, "Matthew Loraditch" <
MLoraditch at heliontechnologies.com> wrote:

>  I almost have the perl script working but ill take SQL too if someone
> can point me to the right query. I couldn't use an input file but I could
> make a a command list easily enough
>
> Sent from my iPad
>
> On Aug 15, 2013, at 7:33 PM, "Nate VanMaren" <VanMarenNP at ldschurch.org>
> wrote:
>
>   But why not just do it in SQL, then you can just run it on the CLI****
>
> ** **
>
> *From:* cisco-voip [mailto:cisco-voip-bounces at puck.nether.net<cisco-voip-bounces at puck.nether.net>]
> *On Behalf Of *Florian Kroessbacher
> *Sent:* Thursday, August 15, 2013 12:24 PM
> *To:* Ed Leatherman
> *Cc:* cisco-voip at puck.nether.net
> *Subject:* Re: [cisco-voip] AXL/Perl/SOAP newbie help****
>
> ** **
>
> must it be perl, i think i've one in java****
>
> --
> Florian Kroessbacher
> gmail: florian.kroessbacher at gmail.com****
>
> ** **
>
> On Thu, Aug 15, 2013 at 7:15 PM, Ed Leatherman <ealeatherman at gmail.com>
> wrote:****
>
>  I have a couple that I have hacked up that might at least point in the
> right direction, i'll try and look thru them this afternoon and see if one
> is using updatephone and send you one.****
>
> ** **
>
> On Thu, Aug 15, 2013 at 12:25 PM, Matthew Loraditch <
> MLoraditch at heliontechnologies.com> wrote:****
>
>  All,****
>
> I would like a perl scrip I can run that reads a CSV file with 2 fields
> (device name and owner user id) and then uses the updatephone axl function
> and sets said value on each item from the csv.****
>
> I have the soap request tested and validated, but my programming from
> scratch skills aren’t so hot, and I can’t find an example close enough that
> I could hack it, so I am fumbling around on my own, so if anyone has
> something they would be willing to share,  I would be grateful. Also if you
> go to Live next year there would be beer in it for you!****
>
>  ****
>
>  ****
>
> Matthew G. Loraditch – CCNP-Voice, CCNA-R&S, CCDA
>
> 1965 Greenspring Drive
> Timonium, MD 21093
>
> voice. 410.252.8830
> fax.  410.252.9284
>
> Twitter <http://twitter.com/heliontech>  |  Facebook<http://www.facebook.com/#!/pages/Helion/252157915296>
> | Website <http://www.heliontechnologies.com/>  |  Email Support<support at heliontechnologies.com?subject=Technical%20Support%20Request>
> ****
>
>  ****
>
>  ****
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip****
>
>
>
> ****
>
> ** **
>
> --
> Ed Leatherman****
>
>  ** **
>
>
>
> NOTICE: This email message is for the sole use of the intended
> recipient(s) and may contain confidential and privileged information. Any
> unauthorized review, use, disclosure or distribution is prohibited. If you
> are not the intended recipient, please contact the sender by reply email
> and destroy all copies of the original message.****
>
>   _______________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130815/61aa0e17/attachment.html>