SharePoint Integration

Re: Update \ Insert items to SharePoint List problem!

Clay Fox — Fri, 14 Dec 2007 21:25:15 GMT

Any code goes on abutton or in several other points.

You can access the script page via a button's properties or from tools - form code.

Re: Update \ Insert items to SharePoint List problem!

srinivasan — Wed, 05 Dec 2007 19:58:11 GMT

Could you please let me know, where you have included the javascript in Infopath. i was trying to that but could not find a way. Please help me. Its urgent.

Re: Update \ Insert items to SharePoint List problem!

Matt Faus — Sun, 29 Jul 2007 16:51:35 GMT

I am very sorry for the mistake, I should really do my research first!

Did you ever figure out a solution to your problem?

Re: Update \ Insert items to SharePoint List problem!

liorlankril — Sun, 29 Jul 2007 03:55:04 GMT

Hi Matt:

It's not Arabic... it's Hebrew (I am from Israel)!!

Re: Update \ Insert items to SharePoint List problem!

Matt Faus — Fri, 27 Jul 2007 11:54:34 GMT

Hi,

That's cool that you are using ~~arabic~~ hebrew symbols in your URL - my uncultured eyes have never seen that!

I don't know exactly the problem, but I'm sure you would have to augment the UPDATE method with some kind of ID so that SharePoint knows which row you are trying to update. Omitting this ID (you don't need it for a NEW command, anyway) makes SharePoint throw an exception that it disregards.

Update \ Insert items to SharePoint List problem!

liorlankril — Thu, 26 Jul 2007 12:55:07 GMT

I use this code to Insert new item to a sharepint List in an InfoPath form code (javascript):

var xmlDoc = "";
xmlDoc += "<Batch>";
       xmlDoc += "<Method ID='1' Cmd='New'>";
       xmlDoc += "<Field Name='Title'>" + idNode.text +"</Field>";
       xmlDoc += "<Field Name='FirstName'>" + fnNode.text +"</Field>";
       xmlDoc += "<Field Name='LastName'>" + lnNode.text +"</Field>";
       xmlDoc += "<Field Name='Job'>" + jobNode.text +"</Field>";
       xmlDoc += "<Field Name='CarNumber'>" + cnNode.text +"</Field>";
       xmlDoc += "<Field Name='CarType'>" + ctNode.text +"</Field>";
       xmlDoc += "<Field Name='CarColor'>" + ccNode.text +"</Field>";
       xmlDoc += "<Field Name='Notes'>" + notesNode.text +"</Field>";
       xmlDoc += "</Method>";
       xmlDoc += "</Batch>";

soapRequest += "<?xml version='1.0' encoding='utf-8'?>";
   soapRequest += "<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'>";
        soapRequest += " <soap:Body>";
        soapRequest += "    <UpdateListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'>";
        soapRequest += "      <listName>" + strListName +"</listName>"; //Change here the name of the list to update
        soapRequest += "      <updates>" + xmlDoc + "</updates>"; //Just specify your Batch xml variable created before
        soapRequest += "    </UpdateListItems>";
        soapRequest += " </soap:Body>";
        soapRequest += "</soap:Envelope>";

var xmlHttpRequest = new ActiveXObject("MSXML2.XMLHTTP.5.0");

         //Send datas to Sharepoint. Here we're specifying headers. Content-Length is not mandatory.
        xmlHttpRequest.open("POST", "http://teutza/C5/דף ראשי/_vti_bin/Lists.asmx", false); //Just specify here the complete address of the list service
        xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
        xmlHttpRequest.setRequestHeader("Content-Length",1);
        xmlHttpRequest.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/sharepoint/soap/UpdateListItems");
        xmlHttpRequest.send(soapRequest);

This code work well and Insert new record to the SP List.

The problem is that I dont know how to use this code to Update exist record in the list, In the xmlDoc defintion I change:

xmlDoc += "<Method ID='1' Cmd='New'>"; to be xmlDoc += "<Method ID='1' Cmd='Update'>";

But nothing happen!!!!

What should I do?????