jQuery Grid Plugin - jqGrid - Topic: XML parsing help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help Simple:Press Version 5.7.5.3 tony on XML parsing help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30122 Help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30122 Hello,

Zip the file and send it to my mail. Look at the example posted from me. It is quite similar.

Making copy/paste from this editor is not recommended.

Regards

]]> Wed, 22 Jan 2014 22:12:12 +0200 JimC on XML parsing help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30121 Help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30121

This is basically the XML here. You can copy/paste it into a text file. I can parse this with jQuery using this function.  I suppose if I can't get jqGrid to read the XML directly, I can parse the XML and save it into an array and then pass the array to jqGrid but I would much prefer to just have jqGrid directly read the XML. 

 $(data).find('z:row, row').each(function ()        {$("#ows_Country").val($(this).attr('ows_Country'));
 });

XML File:

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soa.....038;hellip;..038;hellip;..&quot; xmlns:xsi="http://www.w3.org/2001/XMLSche.....038;hellip;..038;hellip;..&quot; xmlns:xsd="http://www.w3.org/2001/XMLSche.....038;hellip;..038;hellip;..msResponse xmlns="http://schemas.microsoft.com/s.....038;hellip;..038;hellip;..;listitems xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882' xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882' xmlns:rs='urn:schemas-microsoft-com:rowset' xmlns:z='#RowsetSchema'>

<rs:data ItemCount="1">

<z:row ows_ID='16475' ows_Country='Denmark' ows_Reporting_Month='2012-MAR' ows_SourceID='test parent 1' ows_Created='2013-04-10 13:29:03' ows_Cluster='null' ows_NewOrUpdatedRecord='0' ows_RecordUpdate='0' />

</rs:data>

</listitems></GetListItemsResult></GetListItemsResponse></soap:Body></soap:Envelope>

]]> Wed, 22 Jan 2014 22:06:40 +0200 tony on XML parsing help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30120 Help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30120 Hello,

Please check if the xml file that you have is a VALID XML.

The very simple way to test is to read the same file using only jQuery and not jqGrid.

If you have succes with this, then I'm sure there will be no problems with jqGrid.

If you are lost on this, please zip the file and send it to my mail.

Kind Regards

Tony

]]> Wed, 22 Jan 2014 19:48:18 +0200 JimC on XML parsing help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30119 Help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30119

This is the code I have. It still doesn't work to parse that XML. The xml.txt is just a file saved on the server with the XML code. I am at a lost as to what it missing…. I read through the documentation and it seems like this is the correct way to parse that XML. Do you know of any other sites where someone might be able to assist on this?

jQuery("#listXML").jqGrid({ 

      datatype: "xml",

      url: "http://www.mysite.net/XML.txt";,

      height: 250, 

      colNames: ['ID No', 'Country'], 

      colModel: [ {name: 'id', xmlmap:'[ows_ID]'}, 

  {name: 'country', xmlmap:'[ows_Country]'}

      ], 

      xmlReader: { root: "rs\:data", 

       row: "z\:row",

              repeatitems: false,

                 id: "[ows_ID]"

      },
       multiselect: true, 

       caption: "Test" 

    });

]]> Wed, 22 Jan 2014 18:02:16 +0200 tony on XML parsing help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30117 Help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30117 Hello,

Sorry, but I think that that you have read the docs how to parse attributes in jqGrid. You will need to to use xmlmap and set it like this:

colModel :  [

{name:'Field1', xmlmap : '[Field1]', ...}.

...

]

This is the way that I think it is the best way  to publish full test case - this will save time.

Now here is the demo

Regards

]]> Wed, 22 Jan 2014 16:31:35 +0200 JimC on XML parsing help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30112 Help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30112 Hi Tony, I tried that and it didn't work. My code is :

  xmlReader: {root: "rs\\\\:data",

                      row: "z\\\\:row",

                      repeatitems: false,

                      id: "[ows_ID]"

                     },        

This doesn't parse the xml and shows 0 results. Any other tips for parsing the XML returned from a sharepoint? Thanks!

]]> Tue, 21 Jan 2014 16:08:35 +0200 tony on XML parsing help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30108 Help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30108 Hello,

Parsing with namespaces is a little bit diffrent with jQuery.

I have never thest this, but you will need to add  double esc chars in the jsonReader

By example

...

jsonReader: {

...

root : "rs\\\\\:data",

...

}

Sorry for the changes the editor is buggy. I mean two '\' '\'.

More you can find here

Please let me know if this work for you.

Thank you.

Kind Regards

]]> Mon, 20 Jan 2014 16:00:08 +0200 JimC on XML parsing help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30099 Help http://www.trirand.com/blog/?page_id=393/help/xml-parsing-help#p30099 Hello, I am new to using jqGrid and need help to get the XML data from my sharepoint to show up in jqGrid. I read through the documentation but there wasn't any examples for the XML data that I am faced with. This is the output from my sharepoint when I retrieve data with Javascript AJAX. 

<?xml version="1.0" encoding="utf-8"?>

  <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" mlns:xsd="http://www.w3.org/2001/XMLSchema">

<soap:Body>

<GetListItemsResponse xmlns="http://schemas.microsoft.com/sharepoint/soap/">

<GetListItemsResult>   

<listitems xmlns:z='#RowsetSchema'><listitems xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882' xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882' xmlns:rs='urn:schemas-microsoft-com:rowset' xmlns:z='#RowsetSchema'>

<rs:data ItemCount="2">

<z:row Field1='16475' Field2='John Smith' Field3='Male'>

<z:row Field1='16456' Field2='Jane Doe' Field3='Female'>

</rs:data> </listitems></GetListItemsResult></GetListItemsResponse> </soap:Body></soap:Envelope>      

How do I code the jqGrid xmlReader to read this XML? Please help!

]]> Fri, 17 Jan 2014 19:31:36 +0200