[cisco-voip] AXL (XML) ADMIN TOOLKIT using insert

[Thorsten.Mayr at barclayscapital.com]

Got it fixed. Silly syntax error that made me screw up the entire statement in the xml file... For any future references attached the correct file...
Insert is supported and the correct statement for the xml file is:

                <sql update="insert into .......






From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Mayr, Thorsten: IT (LDN)
Sent: Tuesday, September 07, 2010 2:30 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] AXL (XML) ADMIN TOOLKIT using insert

Has anybody used xml files with insert statements rather update or select statements?

e.g.: content of an query.xml file

--------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!--DTD generated by XMLSPY v5 rel. 4 U (http://www.xmlspy.com)-->
<!DOCTYPE data [
                <!ELEMENT data (sql+)>
                <!ELEMENT sql EMPTY>
                <!ATTLIST sql
                query CDATA #IMPLIED
                                update CDATA #IMPLIED
>
]>
<data>
                <sql update="update numplan set fkcallingsearchspace_sharedlineappear = '01055b38-e985-1313-dd74-e4d72a8365bd' where dnorpattern = '11111'"/>
</data>
----------------------------------------

Instead of the above "update" ... I'd like to send an "insert"
The table in question: "telecastersubscribedservice"


Any ideas or ideally examples much appreciated.

Thanks
T

(cucm version 6.1.2 flavour with a broken BULK update for the ip phone service)
Upgrade to 7 will happen but need to subscribe a "few" phones to the ip phone service on multiple 6.x cluster before...

_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer<http://www.barcap.com/emaildisclaimer>. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100908/74effba4/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: lab_telecast2.xml
Type: text/xml
Size: 589 bytes
Desc: lab_telecast2.xml
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100908/74effba4/attachment.xml>