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

[Pavan K]

minor typo. corrected below
table name in the select should be "enduser" not "end user"

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


On Thu, Aug 15, 2013 at 10:37 PM, Pavan K <pav.ccie at gmail.com> wrote:

> 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
>>
>>


-- 
- Pavan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130815/e4c9634a/attachment.html>