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

[Matthew Loraditch]

Thanks this works.

I would still like to get my perl script working as I got pretty close. If anyone is interested in checking it out: http://developer.cisco.com/web/axl-developer/forums/-/message_boards/message/18319906?p_p_auth=5ptu1Uxi





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<mailto:support at heliontechnologies.com?subject=Technical%20Support%20Request>


From: Pavan K [mailto:pav.ccie at gmail.com]
Sent: Thursday, August 15, 2013 11:40 PM
To: Matthew Loraditch
Cc: cisco-voip at puck.nether.net; Nate VanMaren
Subject: Re: [cisco-voip] AXL/Perl/SOAP newbie help

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<mailto: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<mailto: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<mailto: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] On Behalf Of Florian Kroessbacher
Sent: Thursday, August 15, 2013 12:24 PM
To: Ed Leatherman
Cc: cisco-voip at puck.nether.net<mailto: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<mailto:florian.kroessbacher at gmail.com>


On Thu, Aug 15, 2013 at 7:15 PM, Ed Leatherman <ealeatherman at gmail.com<mailto: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<mailto: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<tel:410.252.8830>
fax.  410.252.9284<tel:410.252.9284>

Twitter<http://twitter.com/heliontech>  |  Facebook<http://www.facebook.com/#!/pages/Helion/252157915296>  | Website<http://www.heliontechnologies.com/>  |  Email Support<mailto:support at heliontechnologies.com?subject=Technical%20Support%20Request>



_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto: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<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto: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/20130816/57730b6a/attachment.html>