jQuery Grid Plugin – jqGrid

Thank you very much!
I hope “getRowData” in IE7 is fixed too, because I have to show a demo on 29th Jan and I really need this fix.

Hello,
Sorry it was a typo from me the method is getRowData.
Thank you
Best Regards
Tony

It’s okay,
I met your plugin only few days ago, but I love it from the first glance.

I have interesting ideas how to improve and extend features of JqGrid and do some experiments. If it will success, I’ll share my sources with you

Hello,
Thanks for the plugin, it’s really nice and powerfull,
P.S.: waiting for 3.4 stable 🙂

Thanks again!

Hi there,

FYI, the readme.txt file doesn’t exist in beta2. (I know I said it in the earlier post but this place seems more appropriate…)

Fantastic Work!

Hello Alex,
Thank you very much for this.
The readme is now included into the release.
Tony

Your grid just saved my team’s a$$… thanks man 🙂

I can’t get this to work with latest JQuery UI 3.1. Specifically if I include jquery.ui.all.js, the grid does not display at all.

Any ideas?

@Trevor
I do not known for jQuery UI 3.1 – did you mean jQuery UI 1.6rc5?

@tony
Sorry I mis-stated. I mean JQuery 1.3.1 and jQuery UI 1.6rc5. I downloaded a theme from themeroller. When I included any of the ui. js files, I couldn’t see the grid.

I can confirm that jqGrid has issues with jQuery 1.3.1. Works fine under jQuery 1.2.6, of course.

@Trevor
I’ve included jQuery 1.3-min + jQuery UI 1.6rc5 with themeroller theme successfully to my project.. (with jqGrid 3.4 beta 2)
Check if all of neccessary js was loaded…

Any idea when 3.4 will be released? Will it work well with JQuery 1.3.1. I think most people will be fine if JQuery 1.3.1 is a requirement for the 3.4 jqGrid release.

I am unable to get the number or currency formatters working. Here is code:
script:
colModel :[
…
{name:”price”, formatter:’currency’, index:”price”, width:80, align:’right’},
…
],

grid.locale-en.js is included:
$.jgrid.formatter = {

…
currency : {decimalSeparator:”.”, thousandsSeparator: “,”, decimalPlaces: 0, prefix: “$”, suffix:””, defaulValue: 0},
…
}

BTW Keep up the great work!

Grid import json error:

// xml works fine
var strxml=jQuery(“#navgrid”).jqGridExport({exptype:”xmlstring”});
// but json give error
var strjson=jQuery(“#navgrid”).jqGridExport({exptype:”jsonstring”})
Firebug console:
too much recursion
[Break on this error] v = stringify(arg[i]);

-jukka-

GridImport bug ?
If I do import and then add some methods to the grid, those set not work, but if make those later, those works.

jQuery(document).ready(function(){
jQuery(“#navgrid”).jqGridImport({imptype:”json”,
impurl:”someurl”,
mtype: “GET”,
impData: {},
jsonGrid: {
config: “grid”
}
});
// setup toolbar for search fields
jQuery(“#t_navgrid”).height(25).hide().filterGrid(“navgrid”,{gridModel:true,gridToolbar:true});

// navbar buttons
jQuery(“#navgrid”).navGrid(‘#pagernav’,
{}, //options
{height:280,reloadAfterSubmit:false}, // edit options
{height:280,reloadAfterSubmit:false}, // add options
{reloadAfterSubmit:false}, // del options
{} // search options
);

});

This Import is so nice – thanks. This give excellent properties to create veryveryvery dynamic system.

-jukka-

Min/max button method. If you have set
jQuery(”#t_navgrid”).height(25).hide().filterGrid(”navgrid”,{gridModel:true,gridToolbar:true});

and after that click min and max the grid, toolbar will be visible.

@kshfi

If I add timer before jqGridImport
setInterval(“MyInit()”, 300);

and MyInit do those rest of init, then it works. (navGrid, toolbar)

-jukka-

Any word on the demo that shows using TreeGrid with the adjacency list model? The application I’m (hoping) to use this on stores data in adjacency-list format, and while I think I can force into a nested set model, I’d rather go the adjacency-list route if at all possible.

Any updates on the release date for 3.4?

Thanks a lot!

I’m facing some issues.

1. I have a subgrid. Here is what I did, expand the subgrid and then sort the parent grid (by clicking on a column header) and things get messed up. If I click on the parent column header again, I think it gets into an infinite loop and the browser crashes.

2. Sort/everything works fine if I collapse the subgrid

Also , would it be possible for you to attach a grid.pack.js for the 3.4beta 2 as well – if its not too much work?
It helps us run some performance tests.

thanks!

@Matt
I will describe this detailed in the docs
@Kurt
If the docs are ready it will be this Sunday.

Regards
Tony

@kggrid

I am using grid as subgrid and did not encounter that issue with jqGrid release 3.4, jQuery 1.3 and IE-8 or FireFox 305

Hi there! I am new to jqGrid and would like to know how to capture the data on the page (teste.php) that i set using editurl. I must let you know that im trying to edit a row. I could do it but it gets removed only in the table, not in the server. That’s what i want to do.

Hope anyone can help 🙂

Thanks

Tony, I am using jqgrid 3.4 beta 2 with ASP.NET with datatype xml to load around 2500 rows and 20 columns. The table seems to take around 24 seconds to render. I have not yet tried to do the same using JSON, but is there a reason why the rendering takes long. I was not sure if this was an expected behavior due to number of rows, but I certainly believe that datatype JSON will be faster. I will appreciate if someone could share their implementation of JSON in .NET with me.

@vkapoor
My experience is that with ASP.NET not the rendering of the grid is the time killer but the the time it takes the server to bring the data (so the AJAX request). I asume you are using MS SQL Server wich is pretty slow for this task.
You could use the firebug extension for firefox that shows you the requests that are made to the server, and also the time it take for the request to be completed.

I’ve made an experiment.. I used the same DB table with 1 million rows on ASP.NET with MS SQL and jqGrid and (for comparison) on a MySQL server with PHP and jqGrid

With MS SQL and ASP.NET it took ~241ms to load a page of 10 entries with jqGrid while with MySQL it took 15-20ms… So more than 10 times faster. But.. that is a very basic example. Of coure MS SQL makes up with functionality (it could be a little faster though :p)

But anyways.. 24 second is A LOT. Make shure you optimize your database, indexes etc.. i don’t think that jqGrid is the problem here

Good luck

Great work, but i think is time to start with “cleanup”. This grid use jQuery framework and i dont now why dont use jquery ui… dialog, draggable, sortable, theme etc… Is very hard to catch all of bugs or customize grid exactly for project 🙁 (multisearch with hide/show columns is almost impossible. Table grid on 100% screen width too) Include jquery ui could help to improve functionality..
And strange behaviour with column width.. you used bad table model.
Is better use one default table with section and create toolbars and footers within. Columns stretch then will fork fine..
Now with make headache to fit grid on screen, multisearch and other..
But very good work! Thank you for grid!

@dizzyC Thanks for your response. I did not use the JSON approach here and instead return the data as xml, using a web service to retrieve data. I will test out the same using JSON since that will skip out the parsing logic, but I am positive that the data is returned much faster and the rendering takes perdominant time. I will however appreciate if you could share your example with me.

@vkapoor
I also wanted to mention that I donot have paging enabled in the grid. So the entire tables loads all 2500 rows at once.

@kshfi
I have the same problem with jqGridExport as jsonstring. The firebug console say: “InternalError: too much recursion “. Any idea to correct this problem??

@kshfi
@Chico
There is a important note about this in the readme.txt.
Please first read them first.
Thank you
Tony

@tony
Thank’s Tony. You are right. The important note in the readme.txt say: “IMPORTANT NOTE
When using the jqGridImport the pager …..” but I’m using jqGridExport and I was not thinking that could be the same problem.

Great work with the plugin
Regards

Hello,
Thank you very much for this. Yes it is my bad. I will correct this in the documentation too.
Regards
Tony

In my tests I attempt to load >= 2000 rows (15 columns) dynamically generated using jsonstring as datatype. It still takes around 15 seconds to load the table in IE. However, the same table loads in < 5 seconds in firefox. Is there some other approach that I should take. Will the jqGridImport function provide me any other advantage. Any help will be highly appreciated since I have been on this for a day now.
Thank you in advance

@vkapoor
I am trying with JSON (same scenario as yours) but seems like addJSONData does not work. Grid is empty… no error no warninig.

is no one else having this issue of large dataset taking time to render on IE?

Tony:

When you integrated with the latest UI with themeroller, did you get it to work with those themes? If so, what did you do?

Can’t wait for the final 3.4.
I’m going to try this version.
Will post any bugs encountered.

Hello,

Is there any possibility to integrate fckeditor(or tinymce or jwysiwyg) with JGrid(for add/edit option)?

Thank you

Still no word on the release date for v3.4??

Thanks.

@vkapoor
I have never try with 2000+ records. But I have make some tests 300-350 records. They show me that FF is 2-4 faster than IE. I think that the problem is in the nature of IE and how the ajax goes with it.

@Rogers
The work is stil in progres (60% done) and will be done at middle of march. The next release will have significant changes in apperance.

@dani
Look in to the forums. I think there was a such example.

@Kurt
I just published the 3.4 release.

Regards
Tony

@tony
Does anyone have a simple example of this implementaion written in asp they can share. I have a MSSQL server with log data and I am trying to use Visual Studio to create a site that displays the data using jquery/jqGrid.

I have the same issue as @kshfi. The problem for me is you can’t set grid parameters until the grid has initialized, or you get errors.

Putting in a timer, e.g., setTimeout(“MyInit()”, 300) works, but this is not great as you don’t really know how long things will take.

I would really like to set an event function to fire on “gridComplete”. But how do you do this if the grid itself is being initialized by an xml file via jqGridImport?

Thanks!

Hi,

I am using jqgrid in our project as it meets most of our requirements.
I am using client side jqgrid. so I used datatype:’clientside’.

I added the navgrid too to do add/delete/edit operations using forms.

In all browsers it is working fine except in IE. I am currently using IE7.

The issue is when I click on Add Icon, the form appears, but the background greying section also appears as expected. but All the data will go below(not behind) the grey section. And it looks so absurd.

Can any one please let me know the solution.

Thanks in advance.

Phani

ie, the overlay is getting displayed, but the data that has to be displayed behind is getting displayed below.. ie below the screen visible area!!

@vkapoor and DizzyC
I need help to use jqGrid with asp.net (vb language), would you want to help me to give a little example for using that, please it will save my day …
thanks before
best regard

seira

@vkapoor
On jqgrid rendering slowly in IE. I agree that you should check that the data is being delivered to the browser quickly (use Fiddler or similar), I imagine it is as you have identified the rendering as the bottle neck.

I’m currently working a project where we are having similar issues with the speed at which the grids render. I am an analyst (not a developer) on this project and am surprised by how poorly performing jqgrid is for large grids. Did you get to the bottom of this issue and find a way to get it to perform better whilst still displaying a large number of records? I would interested to hear how you solved this, if at all.

The approaches that the developers are taking at the moment are compromises, not solutions, as follows: Make one server call and load one json object. Then have a grid with pagination that loads smaller sets of this data. Avoid nested grids and subgrids as this seems to have a higher overhead. Avoid multiple grids. If you need to view data in subgrids, lazy load them on demand when the subgrid is expanded. Avoid nesting too many controls including ability to edit the data (editable grids are apparently worse than view only ones) Maybe see the link below for some ideas.

http://forum.achievo.org/forum/viewtopic.php?p=50221, see further links within back to this site for examples.
http://trirand.com/jqgrid/jqgrid.html

However best of all would be if someone knows how to make jqgrid perform acceptably well for large grids in IE6 or IE7.

Is it possible to use post method in AJAX request by the Grid ? Because codeigniter doesn’t accept GET method by default.