Export data do not work for large record

[scadaParticipant]

hi,
I use of below code for Export xls file:
$("#jqxgrid").jqxGrid('exportdata', 'xls', 'jqxGrid');
but this code do not work for large record(for example:1000 record),
explorer return this :

Request Entity Too Large
The requested resource
/subfolder1/export_server/save-file.php
does not allow request data with POST requests, or the amount of data provided in the request exceeds the capacity limit.
Apache Server at jquerygrid.net Port 80

explorer is in hang for larger records!
how must i solve this problem?

thanks&regards

[Peter StoevKeymaster]

Hi scada,

The restriction is by us. If you want to export larger entities, you have to upload save-file.php on your server and make the exportdata work with it by passing your server url’s as parameter. The file comes with Developer & Enterprise licenses.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[arunkumar.rcParticipant]

@Peter : I have Enterprise licenses,

1. How to I get access to save-file.php
2. Do you have the complete step by step procedure (“to upload save-file.php on our server and make the exportdata work with it by passing your server url’s as parameter”)

[Peter StoevKeymaster]

Hi arunkumar.rc,

The file is included in the source code download package. Uploading is simply copying the file to your server. Then you just have to update the exportdata method call in your code and point the URL to the location where the file is hosted.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[arunkumar.rcParticipant]

Thank you Peter !

I was able to get hold of this file.

I am hosting my application in tomcat server which is not able to run this PHP file. I thought of exporting the data to local variable and handle it further, but it looks like exporting to local variable feature is available only to jqxGrid and not for jqxTreeGrid. Is that true ? Please let me know if you have suggestion for my situation.

[arunkumar.rcParticipant]

@Peter :

I came up with different solution to by pass save-file.php . Just curious to know exporting to local variable feature is available to jqxTreeGrid or not. Please let me know. Thanks

[NeoxoneParticipant]

@Peter :
Can we use Blob and createObjectURL to export data？

[Author]

Posts