Exporting the data from grid into CSV or Excel

Suite and Optimus Suite 5
#1

We are facing problems with the grids which has many rows when we use

var csv = grid.serializeToCSV()

system is hanging and giving an error message as following

" A Script on this page is causing Internet Explorer to run slowly. If it continues to run, your computer may become unresponsive. Do u want to abort the script?



Does anyone have used grid.serializeToCSV() to export the data from large girds ? If so can u please suggest us where we are wrong? And do we have anyother methods which export the data from grid?



We are using dhtml version1.4…



Thanks

#2

The mentioned error is not an error, but message of IE, which occurs in case of very long client-side processing. It may occurs when big dataset processed on client side.
Latest version of grid supports more robust logic of CSV serialization, so most probably it will work without such message, but even with latest code, huge datasets can cause the same result.

Tecnhically it is a performance limitation, which can’t be fixed.

#3

I do have this problem with 2000 rows / 26 cols. Is it considered huge datasets? I’m using latest version of Pro DHTMLXSuite.

#4

It not so big for operations in SRND mode , but big enough to cause problems during serialization.
You can try to use attached extension instead of original one, it can operate in SRND mode without row rendering, so it must be much faster than original version ( as draw-back, it will include only original values without extra formating, and will ignore col|row spans during serialization )



dhtmlxgrid_nxml.zip (4.19 KB)