Guriddo » sushukka's Replies

sushukka

Guriddo

Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)

Author

Replies

November 23, 2016 at 1:30 am in reply to: Combining multiple JSON feeds #125694

sushukka

Participant

Hello,
Hehe, now it’s working.
Managed to find something out by myself. The postdata.length did only return undefined as the object array has not that attribute. Playing around somewhile I found this:

for(var keys = Object.keys(postdata), i = 0, end = keys.length; i &lt; end; i++) {
	var key = keys<em class="d4pbbc-italic"></em>; 
  	value = postdata[key];

for(var keys = Object.keys(postdata), i = 0, end = keys.length; i < end; i++) {

var key = keys<em class="d4pbbc-italic"></em>;

value = postdata[key];

And the rest was just trivial stuff. There is still a small nuance left: the customer number which is used as the key and sorting on the grid doesn’t somehow understand numbers over 10. Now it goes like 1, 10, 11, 12, 2, 3, 4… Does JqGrid somehow treat it like a string and not a number?

November 21, 2016 at 11:58 pm in reply to: Combining multiple JSON feeds #125690

sushukka

Participant

Hello,
Thanks again! 🙂 Finally I got the data reading work correctly. It went just as you wrote above.

Next and last step is to make the update/add working and there is a little problem to be solved. The postdata object you mentioned before includes the whole updated row just as it should be. The thing is that I have to restructure the data for the actual post function and change some information etc. As the time is getting short I just structure a string including all the data/modifications and pass it to the JSON post address. I just cannot find out how to extract the data out of the postdata objest. It shows all the data when I print it to console. Console.log(postdata):

Object
	LGICUS01OperationResponse.ca.ca_customer_num: &quot;10&quot;
	LGICUS01OperationResponse.ca.ca_dob: &quot;02.12.1938&quot;
	LGICUS01OperationResponse.ca.ca_email_address: &quot;&quot;
	LGICUS01OperationResponse.ca.ca_first_name: &quot;Susan&quot;
	LGICUS01OperationResponse.ca.ca_house_name: &quot;sdfadf&quot;
	LGICUS01OperationResponse.ca.ca_house_num: &quot;68&quot;
	LGICUS01OperationResponse.ca.ca_last_name: &quot;Stranks&quot;
	LGICUS01OperationResponse.ca.ca_phone_home: &quot;0207 845845&quot;
	LGICUS01OperationResponse.ca.ca_phone_mobile: &quot;&quot;
	LGICUS01OperationResponse.ca.ca_policies: &quot;&quot;
	LGICUS01OperationResponse.ca.ca_policy_data: &quot;&quot;
	LGICUS01OperationResponse.ca.ca_postcode: &quot;W1A4WW&quot;
	LGICUS01OperationResponse.ca.ca_request_id: &quot;01ICUS&quot;
	LGICUS01OperationResponse.ca.ca_return_code: &quot;0&quot;

Object

LGICUS01OperationResponse.ca.ca_customer_num: "10"

LGICUS01OperationResponse.ca.ca_dob: "02.12.1938"

LGICUS01OperationResponse.ca.ca_email_address: ""

LGICUS01OperationResponse.ca.ca_first_name: "Susan"

LGICUS01OperationResponse.ca.ca_house_name: "sdfadf"

LGICUS01OperationResponse.ca.ca_house_num: "68"

LGICUS01OperationResponse.ca.ca_last_name: "Stranks"

LGICUS01OperationResponse.ca.ca_phone_home: "0207 845845"

LGICUS01OperationResponse.ca.ca_phone_mobile: ""

LGICUS01OperationResponse.ca.ca_policies: ""

LGICUS01OperationResponse.ca.ca_policy_data: ""

LGICUS01OperationResponse.ca.ca_postcode: "W1A4WW"

LGICUS01OperationResponse.ca.ca_request_id: "01ICUS"

LGICUS01OperationResponse.ca.ca_return_code: "0"

I can use JSON.stringify to the whole object, but that’s pretty much useless. Need to find some way to pinpoint the actual data elements in the object, but how? For example: “console.log(postdata.LGICUS01OperationResponse.ca.ca_house_name);” don’t work. Probably something trivial I just don’t understand again…

November 17, 2016 at 12:33 pm in reply to: Combining multiple JSON feeds #125670

sushukka

Participant

Thanks again. Need to praise your good product/service to others too. 🙂
The overlapping initGrid function call was just my stupid mistake. Changed the first one now to dataToGrid(). This program would otherwise be in a good shape, but I have still problems with the colmodel mapping function with the actual data. The problem lies here:

console.log(myjson);
        	console.log(&quot;List length:&quot;+myjson.length);
        	console.log(myjson[1].LGICUS01OperationResponse.ca.ca_phone_mobile);
            $(&quot;#jqGrid&quot;).jqGrid({
                //url: &#039;jqgrid_testdata_2.json&#039;,
                //datatype: &quot;local&quot;,
                data: myjson,
				// we set the changes to be made at client side using predefined word clientArray
                editurl: &#039;clientArray&#039;,
                datatype: &quot;json&quot;,
                colModel: [
                    {
						label: &#039;Customer Num.&#039;,
                        name: &#039;ca_customer_num&#039;,
						jsonmap: &#039;LGICUS01OperationResponse.ca.ca_customer_num&#039;,
                        width: 75,
						key: true,
						editable: true,
						editrules : { required: true}
                    },

console.log(myjson);

console.log("List length:"+myjson.length);

console.log(myjson[1].LGICUS01OperationResponse.ca.ca_phone_mobile);

$("#jqGrid").jqGrid({

//url: 'jqgrid_testdata_2.json',

//datatype: "local",

data: myjson,

// we set the changes to be made at client side using predefined word clientArray

editurl: 'clientArray',

datatype: "json",

colModel: [

{

label: 'Customer Num.',

jsonmap: 'LGICUS01OperationResponse.ca.ca_customer_num',

width: 75,

key: true,

editable: true,

editrules : { required: true}

The console.log lines gives the right information before the jqGrid function, but some of the jqGrid functions keywords are probably wrong because it cannot read the data. Here is the console output of the problem:

jqgrid_test2.html:80 [1: Object, 2: Object, 3: Object, 4: Object, 5: Object, 6: Object, 7: Object, 8: Object, 9: Object, 10: Object]
jqgrid_test2.html:81 List length:11
jqgrid_test2.html:82 07799 123456
jquery.jqGrid.min.js:41 Uncaught TypeError: Cannot read property &#039;ca_customer_num&#039; of undefined(…)

jqgrid_test2.html:80 [1: Object, 2: Object, 3: Object, 4: Object, 5: Object, 6: Object, 7: Object, 8: Object, 9: Object, 10: Object]

jqgrid_test2.html:81 List length:11

jqgrid_test2.html:82 07799 123456

jquery.jqGrid.min.js:41 Uncaught TypeError: Cannot read property 'ca_customer_num' of undefined(…)

I can traverse the objects in console like this:
Myjson_console_output Myjson_console_log

I have tried different keywords, read your wiki etc, but with no success. Basically there are no ‘”rows”:[‘ keyword there but just plain json objects in an object array. Otherwise the data should look like in the example you sent earlier.

November 16, 2016 at 6:46 pm in reply to: Combining multiple JSON feeds #125668

sushukka

Participant

Superb!
Very good example, thanks! 🙂
This works very well if no updates(add/edit) needed. However, update feature is crucial in this program. I have managed to build the read/collate functionality so that all the json urls are now read to an object array. The objects looks like I wrote before so eg. myjson[1] has following json object inside it:

{
  &quot;LGICUS01OperationResponse&quot;: {
    &quot;ca&quot;: {
      &quot;ca_phone_mobile&quot;: &quot;123&quot;,
      &quot;ca_request_id&quot;: &quot;01ICUS&quot;,
      &quot;ca_return_code&quot;: 0,
      &quot;ca_dob&quot;: &quot;30.09.1965&quot;,
      &quot;ca_last_name&quot;: &quot;Tracey&quot;,
      &quot;ca_num_policies&quot;: 0,
      &quot;ca_phone_home&quot;: &quot;&quot;,
      &quot;ca_email_address&quot;: &quot;REFROOM@TBHOLDINGS.COM&quot;,
      &quot;ca_house_name&quot;: &quot;Tracey Island&quot;,
      &quot;ca_policy_data&quot;: &quot;&quot;,
      &quot;ca_customer_num&quot;: 2,
      &quot;ca_first_name&quot;: &quot;Scott&quot;,
      &quot;ca_house_num&quot;: &quot;&quot;,
      &quot;ca_postcode&quot;: &quot;TB14TV&quot;
    }
  }
}

{

"LGICUS01OperationResponse": {

"ca": {

"ca_phone_mobile": "123",

"ca_request_id": "01ICUS",

"ca_return_code": 0,

"ca_dob": "30.09.1965",

"ca_last_name": "Tracey",

"ca_num_policies": 0,

"ca_phone_home": "",

"ca_email_address": "REFROOM@TBHOLDINGS.COM",

"ca_house_name": "Tracey Island",

"ca_policy_data": "",

"ca_customer_num": 2,

"ca_first_name": "Scott",

"ca_house_num": "",

"ca_postcode": "TB14TV"

}

The unique key is the “ca_customer_num” as you had in the example. The problem is that I have to reconstruct the array somehow if I want to add the ‘{ “rows”:[‘ etc. I have concatenated a simple String variable to have all the data, but I think that’s just a dead end.

My question is that would it be possible to use that json array as a local source like you have in: http://www.guriddo.net/demo/guriddojs/loading_data/array/index.html
When you get an edit/add/delete action jqgrid would update the local array (addRow, editRow, delRow functions), but I would add my own function call which could use “rowkey” variable to identify the object in the array and do the actual update to the server. Here is the full code (I have tried to play with the datatype, data… keywords, but with no success):

&lt;!DOCTYPE html&gt;

&lt;html lang=&quot;en&quot;&gt;
&lt;head&gt;
    &lt;!-- The jQuery library is a prerequisite for all jqSuite products --&gt;
    &lt;script type=&quot;text/ecmascript&quot; src=&quot;/js/jquery.js&quot;&gt;&lt;/script&gt; 
    &lt;!-- This is the Javascript file of jqGrid --&gt;   
    &lt;script type=&quot;text/ecmascript&quot; src=&quot;/js/jquery.jqGrid.min.js&quot;&gt;&lt;/script&gt;
    &lt;!-- This is the localization file of the grid controlling messages, labels, etc.
    &lt;!-- We support more than 40 localizations --&gt;
    &lt;script type=&quot;text/ecmascript&quot; src=&quot;/js/grid.locale-en.js&quot;&gt;&lt;/script&gt;
     &lt;!-- The Context Menu 3rd party plugin that we are using  --&gt;
    &lt;script type=&quot;text/ecmascript&quot; src=&quot;/js/jquery.contextmenu.js&quot;&gt;&lt;/script&gt;
    &lt;!-- A link to a jQuery UI ThemeRoller theme, more than 22 built-in and many more custom --&gt;
    &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; media=&quot;screen&quot; href=&quot;/css/jquery-1.12.1/jquery-ui.css&quot; /&gt;
    &lt;!-- The link to the CSS that the grid needs --&gt;
    &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; media=&quot;screen&quot; href=&quot;/css/jqgrid/ui.jqgrid.css&quot; /&gt;
    &lt;meta charset=&quot;utf-8&quot; /&gt;
    &lt;title&gt;jqGrid Loading Data - JSON&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
    &lt;table id=&quot;jqGrid&quot;&gt;&lt;/table&gt;
    &lt;div id=&quot;jqGridPager&quot;&gt;&lt;/div&gt;
    
    &lt;div class=&quot;contextMenu&quot; id=&quot;contextMenu&quot; style=&quot;display:none; width:400px;&quot;&gt;
        &lt;ul style=&quot;width: 400px; font-size: 65%;&quot;&gt;
            &lt;li id=&quot;add&quot;&gt;
                &lt;span class=&quot;ui-icon ui-icon-plus&quot; style=&quot;float:left&quot;&gt;&lt;/span&gt;
                &lt;span style=&quot;font-size:130%; font-family:Verdana&quot;&gt;Add Row&lt;/span&gt;
            &lt;/li&gt;
            &lt;li id=&quot;edit&quot;&gt;
                &lt;span class=&quot;ui-icon ui-icon-pencil&quot; style=&quot;float:left&quot;&gt;&lt;/span&gt;
                &lt;span style=&quot;font-size:130%; font-family:Verdana&quot;&gt;Edit Row&lt;/span&gt;
            &lt;/li&gt;                
            &lt;li id=&quot;del&quot;&gt;
                &lt;span class=&quot;ui-icon ui-icon-trash&quot; style=&quot;float:left&quot;&gt;&lt;/span&gt;
                &lt;span style=&quot;font-size:130%; font-family:Verdana&quot;&gt;Delete Row&lt;/span&gt;
            &lt;/li&gt;                
        &lt;/ul&gt;
    &lt;/div&gt;
    
&lt;script type=&quot;text/javascript&quot;&gt; 
var myjson = [];
var myjsonStr = &#039;{&quot;rows&quot;:[&#039;;
var total = 10;
var elements = 0;

$(document).ready(function () {
	for (i = 1; i &lt;= total ; i++) {
	    getCurrentJson(i);
	  }

	  function allDone() {
	    console.log(myjson);
	    myjsonStr = myjsonStr+&quot;]}&quot;;
	    //console.log(&quot;List length:&quot;+myjson.length);
	    //console.log(myjson[1].LGICUS01OperationResponse.ca.ca_phone_mobile);
	    initGrid();
	  }

	  function getCurrentJson(current){
	    $.ajax({ 
	      dataType: &quot;json&quot;,
	      url: &quot;http://192.49.208.193:9081/ci/c/&quot;+current,
	      success: function(data){
	        myjson[current] = data;
	        myjsonStr = myjsonStr+JSON.stringify(data)+&quot;,&quot;;
	        elements++;
	        if (data.LGICUS01OperationResponse.ca.ca_last_name == &quot;&quot; || elements == total) {
	        	console.log(&quot;List ended. Total of:&quot;+elements); 
	        	allDone();
	        }
	      }
	    }); 
	  }
	 
        //$(document).ready(function () {
       function initGrid() {
        	//console.log(myjsonStr);
        	//console.log(&quot;List length:&quot;+myjson.length);
        	//console.log(myjson[1].LGICUS01OperationResponse.ca.ca_phone_mobile);
            $(&quot;#jqGrid&quot;).jqGrid({
                //url: &#039;jqgrid_testdata_2.json&#039;,
                //datatype: &quot;local&quot;,
                data: myjson,
				// we set the changes to be made at client side using predefined word clientArray
                editurl: &#039;clientArray&#039;,
                datatype: &quot;json&quot;,
                colModel: [
                    {
						label: &#039;Customer Num.&#039;,
                        name: &#039;ca_customer_num&#039;,
						jsonmap: &#039;LGICUS01OperationResponse.ca.ca_customer_num&#039;,
                        width: 75,
						key: true,
						editable: true,
						editrules : { required: true}
                    },
                    {
						label: &#039;First Name&#039;,
						jsonmap: &#039;LGICUS01OperationResponse.ca.ca_first_name&#039;,
                        name: &#039;ca_first_name&#039;,
                        width: 140,
                        editable: true // must set editable to true if you want to make the field editable
                    },
                    {
						label : &#039;Last Name&#039;,
						jsonmap: &#039;LGICUS01OperationResponse.ca.ca_last_name&#039;,
                        name: &#039;ca_last_name&#039;,
                        width: 100,
                        editable: true
                    },
                    {
						label: &#039;Email&#039;,
						jsonmap: &#039;LGICUS01OperationResponse.ca.ca_email_address&#039;,
                        name: &#039;ca_email_address&#039;,
                        width: 80,
                        editable: true
                    },
                    {
						label: &#039;Mobile Phone&#039;,
						jsonmap: &#039;LGICUS01OperationResponse.ca.ca_phone_mobile&#039;,
                        name: &#039;ca_phone_mobile&#039;,
                        width: 140,
                        editable: true
                    }
                ],
				sortname: &#039;ca_customer_num&#039;,
				sortorder : &#039;asc&#039;,
                width: 780,
                height: 200,
                rowNum: 150,
                pager: &quot;#jqGridPager&quot;,
                gridComplete: initGrid
            });

        };
        
});
function initGrid() {
    $(&quot;.jqgrow&quot;, &quot;#jqGrid&quot;).contextMenu(&#039;contextMenu&#039;, {
        bindings: {
            &#039;edit&#039;: function (t) {
                editRow();
            },
            &#039;add&#039;: function (t) {
                addRow();
            },
            &#039;del&#039;: function (t) {
                delRow();
            }
        },
        onContextMenu: function (event, menu) {
            var rowId = $(event.target).parent(&quot;tr&quot;).attr(&quot;id&quot;)
            var grid = $(&quot;#jqGrid&quot;);
            grid.setSelection(rowId);

            return true;
        }
    });

    function addRow() {
        var grid = $(&quot;#jqGrid&quot;);
        grid.editGridRow(&quot;new&quot;, { closeAfterAdd: true});
    }

    function editRow() {
        var grid = $(&quot;#jqGrid&quot;);
        var rowKey = grid.getGridParam(&quot;selrow&quot;);
        if (rowKey) {
            grid.editGridRow(rowKey, {closeAfterEdit: true});
        }
        else {
            alert(&quot;No rows are selected&quot;);
        }
    }

    function delRow() {
        var grid = $(&quot;#jqGrid&quot;);
        var rowKey = grid.getGridParam(&quot;selrow&quot;);
        if (rowKey) {
            grid.delGridRow(rowKey);
        }
        else {
            alert(&quot;No rows are selected&quot;);
        }
    }
}

 &lt;/script&gt;
    
&lt;/body&gt;
&lt;/html&gt;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

<!DOCTYPE html>

<head>

<!-- This is the localization file of the grid controlling messages, labels, etc.

<title>jqGrid Loading Data - JSON</title>

</head>

<body>

</li>

</li>

<span style="font-size:130%; font-family:Verdana">Delete Row</span>

</li>

</ul>

</div>

var myjson = [];

var myjsonStr = '{"rows":[';

var total = 10;

var elements = 0;

$(document).ready(function () {

for (i = 1; i <= total ; i++) {

getCurrentJson(i);

}

function allDone() {

console.log(myjson);

myjsonStr = myjsonStr+"]}";

//console.log("List length:"+myjson.length);

//console.log(myjson[1].LGICUS01OperationResponse.ca.ca_phone_mobile);

initGrid();

}

function getCurrentJson(current){

$.ajax({

dataType: "json",

url: "http://192.49.208.193:9081/ci/c/"+current,

success: function(data){

myjson[current] = data;

myjsonStr = myjsonStr+JSON.stringify(data)+",";

elements++;

if (data.LGICUS01OperationResponse.ca.ca_last_name == "" || elements == total) {

console.log("List ended. Total of:"+elements);

allDone();

}

});

}

//$(document).ready(function () {

function initGrid() {

//console.log(myjsonStr);

//console.log("List length:"+myjson.length);

//console.log(myjson[1].LGICUS01OperationResponse.ca.ca_phone_mobile);

$("#jqGrid").jqGrid({

//url: 'jqgrid_testdata_2.json',

//datatype: "local",

data: myjson,

// we set the changes to be made at client side using predefined word clientArray

editurl: 'clientArray',

datatype: "json",

colModel: [

{

label: 'Customer Num.',

jsonmap: 'LGICUS01OperationResponse.ca.ca_customer_num',

width: 75,

key: true,

editable: true,

editrules : { required: true}

{

label: 'First Name',

jsonmap: 'LGICUS01OperationResponse.ca.ca_first_name',

width: 140,

editable: true // must set editable to true if you want to make the field editable

{

label : 'Last Name',

jsonmap: 'LGICUS01OperationResponse.ca.ca_last_name',

width: 100,

editable: true

{

label: 'Email',

jsonmap: 'LGICUS01OperationResponse.ca.ca_email_address',

width: 80,

editable: true

{

label: 'Mobile Phone',

jsonmap: 'LGICUS01OperationResponse.ca.ca_phone_mobile',

width: 140,

editable: true

}

sortname: 'ca_customer_num',

sortorder : 'asc',

width: 780,

height: 200,

rowNum: 150,

pager: "#jqGridPager",

gridComplete: initGrid

});

};

});

function initGrid() {

$(".jqgrow", "#jqGrid").contextMenu('contextMenu', {

bindings: {

'edit': function (t) {

editRow();

'add': function (t) {

addRow();

'del': function (t) {

delRow();

}

onContextMenu: function (event, menu) {

var rowId = $(event.target).parent("tr").attr("id")

var grid = $("#jqGrid");

grid.setSelection(rowId);

return true;

}

});

function addRow() {

var grid = $("#jqGrid");

grid.editGridRow("new", { closeAfterAdd: true});

}

function editRow() {

var grid = $("#jqGrid");

var rowKey = grid.getGridParam("selrow");

if (rowKey) {

grid.editGridRow(rowKey, {closeAfterEdit: true});

}

else {

alert("No rows are selected");

}

function delRow() {

var grid = $("#jqGrid");

var rowKey = grid.getGridParam("selrow");

if (rowKey) {

grid.delGridRow(rowKey);

}

else {

alert("No rows are selected");

}

</script>

</body>

</html>

November 15, 2016 at 1:21 am in reply to: Combining multiple JSON feeds #125660

sushukka

Participant

Seems that after some minutes/threshold you cannot edit the posts anymore. Anyway, the last “span, pre, page, span” mess was caused when copied this text from the wiki page and changed from visual to text mode in editing:

jsonReader : {
      root:&quot;invdata&quot;,
      page: &quot;currpage&quot;,
      total: &quot;totalpages&quot;,
      records: &quot;totalrecords&quot;,
      repeatitems: false,
      id: &quot;0&quot;
   },

jsonReader : {

root:"invdata",

page: "currpage",

total: "totalpages",

records: "totalrecords",

repeatitems: false,

id: "0"

November 15, 2016 at 1:08 am in reply to: Combining multiple JSON feeds #125657

sushukka

Participant

Hello,

I have now managed to get the data to an object array. There are currently 10 entries in myjson[] and every entry looks like this:

{
  &quot;LGICUS01OperationResponse&quot;: {
    &quot;ca&quot;: {
      &quot;ca_phone_mobile&quot;: &quot;123&quot;,
      &quot;ca_request_id&quot;: &quot;01ICUS&quot;,
      &quot;ca_return_code&quot;: 0,
      &quot;ca_dob&quot;: &quot;30.09.1965&quot;,
      &quot;ca_last_name&quot;: &quot;Tracey&quot;,
      &quot;ca_num_policies&quot;: 0,
      &quot;ca_phone_home&quot;: &quot;&quot;,
      &quot;ca_email_address&quot;: &quot;REFROOM@TBHOLDINGS.COM&quot;,
      &quot;ca_house_name&quot;: &quot;Tracey Island&quot;,
      &quot;ca_policy_data&quot;: &quot;&quot;,
      &quot;ca_customer_num&quot;: 2,
      &quot;ca_first_name&quot;: &quot;Scott&quot;,
      &quot;ca_house_num&quot;: &quot;&quot;,
      &quot;ca_postcode&quot;: &quot;TB14TV&quot;
    }
  }
}

{

"LGICUS01OperationResponse": {

"ca": {

"ca_phone_mobile": "123",

"ca_request_id": "01ICUS",

"ca_return_code": 0,

"ca_dob": "30.09.1965",

"ca_last_name": "Tracey",

"ca_num_policies": 0,

"ca_phone_home": "",

"ca_email_address": "REFROOM@TBHOLDINGS.COM",

"ca_house_name": "Tracey Island",

"ca_policy_data": "",

"ca_customer_num": 2,

"ca_first_name": "Scott",

"ca_house_num": "",

"ca_postcode": "TB14TV"

}

I can print the information from the array like this:
console.log(myjson[1].LGICUS01OperationResponse.ca.ca_phone_mobile);

I read the wiki page many times you sent, but I have still problems to find out what kind of keywords should I use to read the actual data from these objects. Should I continue postprocessing the array and cleaning LGICUSo1OperationReposense and ca prefixes away so that I would end having an array including like in the examples:

{
 &quot;rows&quot;: [

    {ca_first_name: &quot;Davy&quot;, ca_last_name: &quot;Crocket&quot;...}

    {ca_first_name: &quot;Tom&quot;, ca_last_name: &quot;Sawyer&quot;...}

    ...

 ]
}

{

"rows": [

{ca_first_name: "Davy", ca_last_name: "Crocket"...}

{ca_first_name: "Tom", ca_last_name: "Sawyer"...}

...

]

}

Now I’m trying to get this working with the “Dialogs: Context Menu triggers Edit/Add/Delete” example you have. I have only changed the following in the example:

        $(document).ready(function () {
            $(&quot;#jqGrid&quot;).jqGrid({
                url: &#039;http://192.49.208.193:9081/ci/c/1&#039;,
				// we set the changes to be made at client side using predefined word clientArray
                editurl: &#039;clientArray&#039;,
                datatype: &quot;json&quot;,´
                colModel: [
                    {
						label: &#039;Customer Num.&#039;,
                        name: &#039;ca_customer_num&#039;,
                        width: 75,
						key: true,
						editable: true,
						editrules : { required: true}
                    },
                    {
						label: &#039;First Name&#039;,
                        name: &#039;ca_first_name&#039;,
                        width: 140,
                        editable: true // must set editable to true if you want to make the field editable
                    },
                    {
						label : &#039;Last Name&#039;,
                        name: &#039;ca_last_name&#039;,
                        width: 100,
                        editable: true
                    },
                    {
						label: &#039;Email&#039;,
                        name: &#039;ca_email_address&#039;,
                        width: 80,
                        editable: true
                    },
                    {
						label: &#039;Mobile Phone&#039;,
                        name: &#039;ca_phone_mobile&#039;,
                        width: 140,
                        editable: true
                    }
                ],
				sortname: &#039;ca_customer_num&#039;,
				sortorder : &#039;asc&#039;,
                width: 780,
                height: 200,
                rowNum: 150,
                pager: &quot;#jqGridPager&quot;,
                gridComplete: initGrid
            });

        });

$(document).ready(function () {

$("#jqGrid").jqGrid({

url: 'http://192.49.208.193:9081/ci/c/1',

// we set the changes to be made at client side using predefined word clientArray

editurl: 'clientArray',

datatype: "json",´

colModel: [

{

label: 'Customer Num.',

width: 75,

key: true,

editable: true,

editrules : { required: true}

{

label: 'First Name',

width: 140,

editable: true // must set editable to true if you want to make the field editable

{

label : 'Last Name',

width: 100,

editable: true

{

label: 'Email',

width: 80,

editable: true

{

label: 'Mobile Phone',

width: 140,

editable: true

}

sortname: 'ca_customer_num',

sortorder : 'asc',

width: 780,

height: 200,

rowNum: 150,

pager: "#jqGridPager",

gridComplete: initGrid

});

Also I have tried to put jsonreader parameters after the colModel[]:

<pre class=”code javascript”><span class=”me1″>jsonReader</span> <span class=”sy0″>:</span> <span class=”br0″>{</span>
root<span class=”sy0″>:</span><span class=”st0″>”invdata”</span><span class=”sy0″>,</span>
page<span class=”sy0″>:</span> <span class=”st0″>”currpage”</span><span class=”sy0″>,</span>
total<span class=”sy0″>:</span> <span class=”st0″>”totalpages”</span><span class=”sy0″>,</span>
records<span class=”sy0″>:</span> <span class=”st0″>”totalrecords”</span><span class=”sy0″>,</span>
repeatitems<span class=”sy0″>:</span> <span class=”kw2″>false</span><span class=”sy0″>,</span>
id<span class=”sy0″>:</span> <span class=”st0″>”0″</span>
<span class=”br0″>}</span><span class=”sy0″>,</span>

But they probably conflict somehow with the example parameters or just are not compatible with the data. Any hints to proceed would be greatly appreciated. 🙂

This reply was modified 9 years, 7 months ago by sushukka.
This reply was modified 9 years, 7 months ago by sushukka.

Author

Replies

Viewing 6 replies - 1 through 6 (of 6 total)