jQuery Grid Plugin - jqGrid - Topic: Can't get jqgrid to read json data http://www.trirand.com/blog/?page_id=393/help/cant-get-jqgrid-to-read-json-data Simple:Press Version 5.7.5.3 jgalak on Can't get jqgrid to read json data http://www.trirand.com/blog/?page_id=393/help/cant-get-jqgrid-to-read-json-data#p29403 Help http://www.trirand.com/blog/?page_id=393/help/cant-get-jqgrid-to-read-json-data#p29403 Thank you!

I thought it was something stupid... Sigh...

]]> Tue, 27 Aug 2013 04:41:06 +0300 tony on Can't get jqgrid to read json data http://www.trirand.com/blog/?page_id=393/help/cant-get-jqgrid-to-read-json-data#p29393 Help http://www.trirand.com/blog/?page_id=393/help/cant-get-jqgrid-to-read-json-data#p29393 Hello,

You have a typo in grid parameters:

Change

dataype: "json", to

datatype: "json",

Regards

]]> Mon, 26 Aug 2013 08:27:04 +0300 jgalak on Can't get jqgrid to read json data http://www.trirand.com/blog/?page_id=393/help/cant-get-jqgrid-to-read-json-data#p29392 Help http://www.trirand.com/blog/?page_id=393/help/cant-get-jqgrid-to-read-json-data#p29392 If it's easier, you can hit the page "live".  The grid is here: http://173.2.2.155:2222/phils/jq

]]> Sun, 25 Aug 2013 22:28:22 +0300 jgalak on Can't get jqgrid to read json data http://www.trirand.com/blog/?page_id=393/help/cant-get-jqgrid-to-read-json-data#p29391 Help http://www.trirand.com/blog/?page_id=393/help/cant-get-jqgrid-to-read-json-data#p29391 Still struggling to learn jqgrid, not sure why I'm having so much trouble.  Got it working in one instance, and totally not working in another, though the code seems to be almost identical.  Here's the code:



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"&gt;
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <title>My First Grid</title>

    <link rel="stylesheet" type="text/css" media="screen" href="http://192.168.1.70/phils/jsgr.....custom.css" />
    <link rel="stylesheet" type="text/css" media="screen" href="http://192.168.1.70/phils/jsgr.....jqgrid.css" />

    <style>
        html, body {
            margin: 0;
            padding: 0;
            font-size: 75%;
        }
    </style>

    <script src="http://192.168.1.70/phils/jsgr.....9.0.min.js" type="text/javascript"></script>
    <script src="http://192.168.1.70/phils/jsgr.....cale-en.js" type="text/javascript"></script>
    <script src="http://192.168.1.70/phils/jsgr.....rid.min.js" type="text/javascript"></script>

    
    <script type="text/javascript">
        $(function()
        {
            $("#list").jqGrid(
                {
                    url: "http://192.168.1.70/phils/js&quot;,
                    altRows: true,
                    deepempty: true,
                    autowidth: true,
                    ignoreCase: true,
                    dataype: "json",
                    mtype: "GET",
                    jsonReader :
                    {root: "rows",
page: "page",
total: "total",
records: "records",
repeatitems: false,
cell: "",
id: "0",
}                    ,

                    colNames:  ["Username", "E-Mail"],
                    colModel:  [{ name: "username"}, 
{ name: "email"}],
                    pager: "#pager",
                    rowNum: 20,
                    rowList: [20, 50, 100],
                    sortname: "name",
                    sortorder: "asc",
                    viewrecords: true,
                    gridview: true,
                    autoencode: true,
                    caption: "My first grid"
                });
        });
    </script>

</head>
<body>
    <table id="list"><tr><td></td></tr></table>
    <div id="pager"></div>

</body>
</html>






Here's the JSON (as reformatted by JSONLint):






{
    "total": 1,
    "page": 1,
    "records": 2,
    "rows": [
        {
            "id": 6,
            "username": "jgalak",
            "email": "test1@test2",
            "password": "123",
            "confirmation_code": "123",
            "confirmed": 1,
            "created_at": "2013-07-05 22:06:32",
            "updated_at": "2013-07-05 22:06:32",
            "SCA_Name": "",
            "First_Name": "",
            "Last_Name": "",
            "Book_Areas": "",
            "Local_Office_Name": "",
            "Book_Notes": "",
            "Voice_Notes": "",
            "Personal_Office_Name": "",
            "Brigantia_Office_Name": "",
            "Laurel_Office_Name": "",
            "Address1": "",
            "Address2": "",
            "City": "",
            "ZIP": "",
            "Country": "",
            "Membership_Expire": "0000-00-00",
            "Membership_Number": "",
            "deleted_at": null,
            "Local_Flag": 0,
            "Brigantia_Office_Flag": 0,
            "Laurel_Office_Flag": 0,
            "Local_Office_Branch": 0,
            "Residence_Branch": 0,
            "Name_Exp": 0,
            "Armory_Exp": 0,
            "Field_Exp": 0,
            "Court_Exp": 0,
            "Chancery_Exp": 0
        },
        {
            "id": 7,
            "username": "test1",
            "email": "test@test1",
            "password": "312",
            "confirmation_code": "123",
            "confirmed": 1,
            "created_at": "2013-07-19 16:22:18",
            "updated_at": "2013-07-19 16:22:18",
            "SCA_Name": "Test",
            "First_Name": "Test",
            "Last_Name": "Test",
            "Book_Areas": "",
            "Local_Office_Name": "",
            "Book_Notes": "",
            "Voice_Notes": "",
            "Personal_Office_Name": "",
            "Brigantia_Office_Name": "",
            "Laurel_Office_Name": "",
            "Address1": "",
            "Address2": "",
            "City": "",
            "ZIP": "",
            "Country": "",
            "Membership_Expire": "0000-00-00",
            "Membership_Number": "",
            "deleted_at": "2013-07-19 16:22:18",
            "Local_Flag": 0,
            "Brigantia_Office_Flag": 0,
            "Laurel_Office_Flag": 0,
            "Local_Office_Branch": 0,
            "Residence_Branch": 0,
            "Name_Exp": 0,
            "Armory_Exp": 0,
            "Field_Exp": 0,
            "Court_Exp": 0,
            "Chancery_Exp": 0
        }
    ]
}


I am trying to use the data model from "http://www.trirand.com/jqgridwiki/doku.php?id=wiki:retrieving_data#json_data" where "cell" is set to "" (no separate cell sub array), and pull out only certain columns.


Web console just says "not well formed", but Firebug confirms it's a json response.


I'm sure I'm missing something obvious, pleas help.

]]>
        	        	Sun, 25 Aug 2013 21:50:28 +0300