jQuery Grid Plugin - jqGrid - Topic: Invalid Json when using exporting a Grid with events defined http://www.trirand.com/blog/?page_id=393/help/invalid-json-when-using-exporting-a-grid-with-events-defined Simple:Press Version 5.7.5.3 john on Invalid Json when using exporting a Grid with events defined http://www.trirand.com/blog/?page_id=393/help/invalid-json-when-using-exporting-a-grid-with-events-defined#p23395 Help http://www.trirand.com/blog/?page_id=393/help/invalid-json-when-using-exporting-a-grid-with-events-defined#p23395 i should add, i use firebug to show me the layout of the json data being sent to the server. then for each event i note the name of the event and the name of the following event in the JSON and replace it as shown in the java sample.

]]> Mon, 30 May 2011 17:37:27 +0300 john on Invalid Json when using exporting a Grid with events defined http://www.trirand.com/blog/?page_id=393/help/invalid-json-when-using-exporting-a-grid-with-events-defined#p23394 Help http://www.trirand.com/blog/?page_id=393/help/invalid-json-when-using-exporting-a-grid-with-events-defined#p23394 No, i had to work arround it. when i save the grid i have to first edit it in the java service code to remove all events before saving it to the database.

The code i use to do that is as follows

public void saveGrid(String grid, String user, String report) {

System.out.println(">>>GridServiceImpl.saveGrid");

// strip out all grid events (e.g. onSelectRow, onPaging, gridComplete

int i = grid.indexOf("onSelectRow");

int j = grid.indexOf("onSortCol") - 1;

grid = grid.substring(0, i) + "onSelectRow\":null," + grid.substring(j) ;

i = grid.indexOf("onPaging");

j = grid.indexOf("onSelectAll") - 1;

grid = grid.substring(0, i) + "onPaging\":null," + grid.substring(j) ;

i = grid.indexOf("gridComplete");

j = grid.indexOf("loadError") - 1;

grid = grid.substring(0, i) + "gridComplete\":null," + grid.substring(j) ;

System.out.println(grid);

try {

Model.perform("saveGrid", new Object[] {user, report, grid });

} catch (Exception e) {

e.printStackTrace();

}

}

 Then in my javascript i reload the events after the jqGridImport function

jQuery('#tableReport').jqGrid('setGridParam', { 'onPaging':function(btn){

$("#tableReport").appendPostData({refresh:false});

var vSelectedIds;

vSelectedIds = $("#tableReport").getGridParam('selarrrow');

$("#tableReport").appendPostData({ticked:vSelectedIds});

}});

hope that helps.

john 

]]> Mon, 30 May 2011 17:34:15 +0300 rui.isidro@gmail.com on Invalid Json when using exporting a Grid with events defined http://www.trirand.com/blog/?page_id=393/help/invalid-json-when-using-exporting-a-grid-with-events-defined#p23391 Help http://www.trirand.com/blog/?page_id=393/help/invalid-json-when-using-exporting-a-grid-with-events-defined#p23391 Did you find any other solution? I'm also having problems with this. I have a few events attached to a grid and I whant to export the grid, but I always get errors with JSON because of the deveined event handler functions.

]]> Mon, 30 May 2011 16:43:20 +0300 john on Invalid Json when using exporting a Grid with events defined http://www.trirand.com/blog/?page_id=393/help/invalid-json-when-using-exporting-a-grid-with-events-defined#p20640 Help http://www.trirand.com/blog/?page_id=393/help/invalid-json-when-using-exporting-a-grid-with-events-defined#p20640 i have a grid which has actions defined for the onPaging, onSelectRow and gridComplete events

When i use the jqGridExport function to export the grid to the server it seems to work OK, but when i run the JSON that it creates through JSONLint it says the JSON is invalid for these actions.

My jqGridExport command is:

var jsonGrid = jQuery("#tableReport").jqGridExport({exptype: "jsonstring", root: "tableReport"});

$.post("/SOA/Grid.soa", {grid: jsonGrid, report: "today"});

The code for my onSelectRow event is:

        onSelectRow: function(id){
            if(id && id!==lastRow){
                $("#tableReport").saveRow(lastRow, false);
                $("#tableReport").editRow(id,true);
                lastRow=id;
            }
        }

The JSON created is:

       …..
        "beforeSelectRow": null,
        "onSelectRow": function (id) {
            if (id && id !== lastRow) {
                $("#tableReport").saveRow(lastRow,
                false); $("#tableReport").editRow(id,
                true); lastRow = id;
            }
        },
        "onSortCol": null,
       …….

The JSONLint message is: 'syntax error, unexpeted TINVALID at line nnn'

Just a thought, could it be because i am in Belgium? i know that in some applications i need to use semicolons as value delimiters in lists

i have resolved this by making my Server code strip out the event methods. Then in my jqGridImport call i re-add them.

]]> Wed, 03 Nov 2010 11:42:30 +0200