jQuery Grid Plugin - jqGridForum

25/11/2009
11:19

Elan

Guest

Guests

1

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'?>

    <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>

26/11/2009
10:16

Elan-Noy

Member

Members

Forum Posts: 6

Member Since:
17/11/2009

Offline

2

Hey guys,

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

27/11/2009
05:18

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

3

Hello,

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

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

27/11/2009
07:52

Elan-Noy

Member

Members

Forum Posts: 6

Member Since:
17/11/2009

Offline

4

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

30/11/2009
12:35

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

5

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

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.