Problem with Export to Excel when 100 records in Grid.

[ajayetw2009Participant]

Hi Sir,

When i export from excel in jqxgrid then i got error 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

what should i do for resolving this.

Thank in Advance

Thanks and regards,

Ajay k.

[Peter StoevKeymaster]

Hi Ajay k.,

The save-file.php hosted on our server is for demo purposes. It does not allow more than 2MB files for export.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[keithd@derwentdata.comParticipant]

I have the same problem, Peter S

your answer states their is and upper limit and offers no solutions
is it a case of finding another tool?

[Peter StoevKeymaster]

Hi keithd,

The solution is to host that file on your own server, if you have a jQWidgets Developer or Enterprise license. On our server, the limit is 2MB as the file is hosted there only for demo purposes.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[neongParticipant]

I have same problem. Yes. I had the enterprise license. But don’t know how to made it work. Can you please describe more how to do it? I try to change the http://jqwidgets.com/export_server/save-file.php to my on server but can’t work. Thanks.

[neongParticipant]

I changed to $(‘#jqxTable’).jqxDataTable(‘exportData’, ‘xls’, ‘jqxDataTable’, true, null, true, “../PHPExport/save-file.php”); still appear the same error.

At chrome, debug error was POST http://jquerygrid.net/export_server/save-file.php 413 (Request Entity Too Large).

[Peter StoevKeymaster]

Hi neong,

The problem is that you missed the fact that you need to upload save-file.php on your server and update your exportdata method calls to use your save-file.php instead of ours which is restricted. We don’t allow large entities to be exported through our website, because the file there is hosted for evaluation purposes only.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[neongParticipant]

Thanks, Peter. I was managed to do it.

[revilo7Participant]

Hello;
I am getting to know jqwidgets controls and may use on a website for a client. Using test data we already exceed the 2MB limitation.

Is it possible to host the export on my server using a Basic Website License?

[a.nasriParticipant]

Hello Peter,
I have the same problem with my data and i’m using an entreprise licence but I didn’t know how to upload save-file.php into my server. Could you please give me more details to resolve this issue.

Thanks in advance and regards,
Ali Nasri

[Peter StoevKeymaster]

Hi,

You should upload it to your server i.e copy it from the download folder and paste it on your server.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[a.nasriParticipant]

Hi Peter,
I did it but still have no changes. Have i miss something else?

Best Regards.
Ali Nasri

[Peter StoevKeymaster]

If you have the file on your server, then set the serverURL to it when you call exportdata. Details: http://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-api.htm

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[medkacParticipant]

Hi,

I have the same problem with my data and i’m using an entreprise licence, i seted the serverURL to “http://localhost:4200/src/PHPExport/save-file.php” in the exportdata method, but when i execute it i have this error message: Cannot POST /src/PHPExport/save-file.php.

Please can you help me to find my error. Thank you.

Best Regards,
Mohamed Kacem

[jlarueParticipant]

Also having this issue and could use a little more help than ‘upload the php file to your sever’.

I have a developer license and I’m running ASP.NET MVC. Do I need to install PHP on my web server to make this work? Is there an ASP.NET equivalent of the export code I can host in a controller action? Do I need to setup my project to server a static file? Do I need to setup a stand alone project to host a single file to serve up exports?

Please don’t just paste a link to a canned demo or tell me to upload save-file.php to my server. Some kind of documentation or step by step instruction would be really helpful.

[Author]

Posts