jQuery Grid Plugin - jqGrid - Topic: No Data when reading XML file http://www.trirand.com/blog/?page_id=393/help/no-data-when-reading-xml-file Simple:Press Version 5.7.5.3 tony on No Data when reading XML file http://www.trirand.com/blog/?page_id=393/help/no-data-when-reading-xml-file#p12573 Help http://www.trirand.com/blog/?page_id=393/help/no-data-when-reading-xml-file#p12573 Hello,

Which version of FireFox?

Also maybe you can try to send

response.setContentType(”application/xhtml+xml”);

But I'm not sure if this is the problem.

Regards

Tony

]]> Mon, 30 Nov 2009 12:35:40 +0200 Elan-Noy on No Data when reading XML file http://www.trirand.com/blog/?page_id=393/help/no-data-when-reading-xml-file#p12521 Help http://www.trirand.com/blog/?page_id=393/help/no-data-when-reading-xml-file#p12521 Tony,

Thank you very much for your reply.

This application is a Java application and I am using the -- response.setContentType("text/xml");  -- statement.

I just found out that it works on MS Explorer, but does not work with Mozila, even though I can see that the HTTP response was correct. Any thoughts?

Regards

Elan

]]> Fri, 27 Nov 2009 07:52:41 +0200 tony on No Data when reading XML file http://www.trirand.com/blog/?page_id=393/help/no-data-when-reading-xml-file#p12517 Help http://www.trirand.com/blog/?page_id=393/help/no-data-when-reading-xml-file#p12517 Hello,

If you use PHP use header function before sending the data. Also see the exmples from demo.

Regards

Tony

]]> Fri, 27 Nov 2009 05:18:07 +0200 Elan-Noy on No Data when reading XML file http://www.trirand.com/blog/?page_id=393/help/no-data-when-reading-xml-file#p12473 Help http://www.trirand.com/blog/?page_id=393/help/no-data-when-reading-xml-file#p12473 Hey guys,

I need urget help. I can't see  the data, I think the data and the XML Read are correct. HELP!!!!!!!!!!!

]]> Thu, 26 Nov 2009 10:16:30 +0200 Elan on No Data when reading XML file http://www.trirand.com/blog/?page_id=393/help/no-data-when-reading-xml-file#p12436 Help http://www.trirand.com/blog/?page_id=393/help/no-data-when-reading-xml-file#p12436 Hello,

I am trying to use the JQGrid to display the content of an XML file, however nothing shows up, and there is a message "No Records To View".

My JS code:

            jQuery().ready(function(){
                jQuery("#list1").jqGrid({
                    url: 'helper.jsp',
                    datatype: "xml",                   
                    colModel: [{
                        name: "OrderNumber",
                        index: 'OrderNumber',
                        width: 90
                    }, {
                        name: "OrderDate",
                        index: 'OrderDate',
                        width: 90
                    },{
                        name: "OrderStatus",
                        index: 'OrderStatus',
                        width: 90
                    },  {
                        name: "PurchaseOrderNumber",
                        index: 'PurchaseOrderNumber',
                        width: 80,
                        align: 'right'
                    }, {
                        name: "LegacyOrderNumber",
                        index: 'LegacyOrderNumber',
                        width: 80,
                        align: 'right'
                    }],
                    rowNum: 10,
                    autowidth: true,
                    rowList: [10, 20, 30],
                    pager: jQuery('#pager1'),
                    sortname: 'id',
                    viewrecords: true,
                    sortorder: "desc",
                    caption: "XML Example",
                    xmlReader: {
                        root: "Orders",
                        row: "OrderSummary",
                        page: "gaxml>currentpage",
                        total: "gaxml>totalpages",
                        records: "gaxml>totalrecords",
                        repeatitems: false,
                        id: "RowNum"
                   
                    }
                }).navGrid('#pager1', {
                    edit: false,
                    add: false,
                    del: false
                });
            });

and my XML:

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

<gaxml>
 <currentpage>1</currentpage>
    <totalpages>10</totalpages>
    <totalrecords>20</totalrecords>

 <Orders>

    <OrderSummary>
   <RowNum>1</RowNum>
      <OrderNumber>220742</OrderNumber>
      <LegacyOrderNumber>4308396</LegacyOrderNumber>
      <OrderDate>2009-11-13 10:30:00.0</OrderDate>
      <OrderStatus>CANCELLED</OrderStatus>
      <PurchaseOrderNumber>TEST - DANNA</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>2</RowNum>
      <OrderNumber>220509</OrderNumber>
      <LegacyOrderNumber>4308262</LegacyOrderNumber>
      <OrderDate>2009-11-13 09:25:00.0</OrderDate>
      <OrderStatus>CANCELLED</OrderStatus>
      <PurchaseOrderNumber>TEST - DANNA</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>3</RowNum>
      <OrderNumber>220428</OrderNumber>
      <LegacyOrderNumber>4308249</LegacyOrderNumber>
      <OrderDate>2009-11-13 09:10:00.0</OrderDate>
      <OrderStatus>CANCELLED</OrderStatus>
      <PurchaseOrderNumber>TEST - D ANNA</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>4</RowNum>
      <OrderNumber>220157</OrderNumber>
      <LegacyOrderNumber>OE_ORDER_HEADERS_ALL5501381</LegacyOrderNumber>
      <OrderDate>2009-11-13 06:49:43.0</OrderDate>
      <OrderStatus>CLOSED</OrderStatus>
      <PurchaseOrderNumber>SHEIRICH, MICHAEL</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>5</RowNum>
      <OrderNumber>219689</OrderNumber>
      <LegacyOrderNumber>4307053</LegacyOrderNumber>
      <OrderDate>2009-11-12 17:02:00.0</OrderDate>
      <OrderStatus>CANCELLED</OrderStatus>
      <PurchaseOrderNumber>TEST - DANNA</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>6</RowNum>
      <OrderNumber>219706</OrderNumber>
      <LegacyOrderNumber></LegacyOrderNumber>
      <OrderDate>2009-11-12 16:38:13.0</OrderDate>
      <OrderStatus>CANCELLED</OrderStatus>
      <PurchaseOrderNumber>TEST - DANNA</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>7</RowNum>
      <OrderNumber>219558</OrderNumber>
      <LegacyOrderNumber></LegacyOrderNumber>
      <OrderDate>2009-11-12 15:42:00.0</OrderDate>
      <OrderStatus>ENTERED</OrderStatus>
      <PurchaseOrderNumber>QUOTE 09-300-195</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>8</RowNum>
      <OrderNumber>219555</OrderNumber>
      <LegacyOrderNumber></LegacyOrderNumber>
      <OrderDate>2009-11-12 15:40:12.0</OrderDate>
      <OrderStatus>CLOSED</OrderStatus>
      <PurchaseOrderNumber>GREG DAVIS</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>9</RowNum>
      <OrderNumber>219518</OrderNumber>
      <LegacyOrderNumber></LegacyOrderNumber>
      <OrderDate>2009-11-12 15:30:55.0</OrderDate>
      <OrderStatus>ENTERED</OrderStatus>
      <PurchaseOrderNumber>QUOTE 09-300-196</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>10</RowNum>
      <OrderNumber>219474</OrderNumber>
      <LegacyOrderNumber></LegacyOrderNumber>
      <OrderDate>2009-11-12 15:17:18.0</OrderDate>
      <OrderStatus>ENTERED</OrderStatus>
      <PurchaseOrderNumber>QUOTE 09-300-197</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>11</RowNum>
      <OrderNumber>219471</OrderNumber>
      <LegacyOrderNumber></LegacyOrderNumber>
      <OrderDate>2009-11-12 15:16:38.0</OrderDate>
      <OrderStatus>ENTERED</OrderStatus>
      <PurchaseOrderNumber>BID 2-09-0822</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>12</RowNum>
      <OrderNumber>219188</OrderNumber>
      <LegacyOrderNumber></LegacyOrderNumber>
      <OrderDate>2009-11-12 14:06:16.0</OrderDate>
      <OrderStatus>CLOSED</OrderStatus>
      <PurchaseOrderNumber>APPROVAL 1</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>13</RowNum>
      <OrderNumber>218571</OrderNumber>
      <LegacyOrderNumber>OE_ORDER_HEADERS_ALL5499672</LegacyOrderNumber>
      <OrderDate>2009-11-12 11:11:04.0</OrderDate>
      <OrderStatus>CLOSED</OrderStatus>
      <PurchaseOrderNumber>MILBROOK, JOHN</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>14</RowNum>
      <OrderNumber>217211</OrderNumber>
      <LegacyOrderNumber>4304768</LegacyOrderNumber>
      <OrderDate>2009-11-11 16:41:00.0</OrderDate>
      <OrderStatus>CANCELLED</OrderStatus>
      <PurchaseOrderNumber>TEST - DANNA FISHER</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>15</RowNum>
      <OrderNumber>215806</OrderNumber>
      <LegacyOrderNumber>4303893</LegacyOrderNumber>
      <OrderDate>2009-11-11 10:22:00.0</OrderDate>
      <OrderStatus>CLOSED</OrderStatus>
      <PurchaseOrderNumber>GRAYSON, RONALD</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>16</RowNum>
      <OrderNumber>214239</OrderNumber>
      <LegacyOrderNumber></LegacyOrderNumber>
      <OrderDate>2009-11-10 14:55:36.0</OrderDate>
      <OrderStatus>BOOKED</OrderStatus>
      <PurchaseOrderNumber>OBRADOVAC, DAMIR</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>17</RowNum>
      <OrderNumber>213029</OrderNumber>
      <LegacyOrderNumber></LegacyOrderNumber>
      <OrderDate>2009-11-10 09:40:48.0</OrderDate>
      <OrderStatus>CLOSED</OrderStatus>
      <PurchaseOrderNumber>T. WILLIAMS NAMETAG</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>18</RowNum>
      <OrderNumber>212917</OrderNumber>
      <LegacyOrderNumber></LegacyOrderNumber>
      <OrderDate>2009-11-10 09:18:24.0</OrderDate>
      <OrderStatus>BOOKED</OrderStatus>
      <PurchaseOrderNumber>WILLIAMS, THOMAS</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>19</RowNum>
      <OrderNumber>212687</OrderNumber>
      <LegacyOrderNumber></LegacyOrderNumber>
      <OrderDate>2009-11-10 08:16:10.0</OrderDate>
      <OrderStatus>CLOSED</OrderStatus>
      <PurchaseOrderNumber>EMBREY, CHRISTOPHER</PurchaseOrderNumber>
    </OrderSummary>
           
    <OrderSummary>
   <RowNum>20</RowNum>
      <OrderNumber>212670</OrderNumber>
      <LegacyOrderNumber></LegacyOrderNumber>
      <OrderDate>2009-11-10 08:12:04.0</OrderDate>
      <OrderStatus>BOOKED</OrderStatus>
      <PurchaseOrderNumber>DEAPOLIS, DOMINIC</PurchaseOrderNumber>
    </OrderSummary>
           
 <SearchDetails>
  <Page>1</Page>
     <RowStart>1</RowStart>
     <RowEnd>20</RowEnd>
     <TotalCounts>2558</TotalCounts>
 </SearchDetails>
  </Orders>
</gaxml>

]]> Wed, 25 Nov 2009 11:19:14 +0200