jQuery UI Widgets › Forums › Grid › Grid export for large amount of data
This topic contains 12 replies, has 2 voices, and was last updated by Hristo 2 years, 7 months ago.
October 22, 2020 at 1:02 pm Grid export for large amount of data #113421
Is it possible to export grid data without sending data form grid to server?
for large grids like over 300k rows (lots of columns) this export do not work.
users have to wait over 10 minutes to download the data.
Can we have export without sending data back from client to server?
What I would like to have on export is just a simple request from grid with all requested filters, and then server can return this data directly (no data upload back to server)October 23, 2020 at 12:38 pm Grid export for large amount of data #113433
Should I ask this question through premium support?October 23, 2020 at 12:47 pm Grid export for large amount of data #113434
exportdatamethod of the jqxGrid works on the Server-Side but also you could determine which records to be exported.
On the other hand, the
exportviewmethod (new one) works on the Client-Side but you could check it because some formats could take a lot of the browser’s memory (as PDF file format).
Please, take a look at this demo:
Also, I would like to mention that we have a plug-in for exporting that could be used separately.
Please, take a look at this page:
https://www.jqwidgets.comOctober 25, 2020 at 7:04 am Grid export for large amount of data #113439
I am using jQuery grid, not smart html elements, so how I can export grid data without sending it back from grid to server?October 26, 2020 at 12:27 pm Grid export for large amount of data #113441
You could use the
exportviewmethod where it happens on the Client-Side.
Please, take a look at this demo.
https://www.jqwidgets.comOctober 27, 2020 at 8:02 am Grid export for large amount of data #113449
Could you tell me where in documentation is this method described?
I have checked: https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-api.htm
and there is nothing about it
Should I switch from jquery grid to smart element grid, which one is “better” ?October 27, 2020 at 3:37 pm Grid export for large amount of data #113455
anyway when I am trying to use export view method I am getting such error:
error TypeError: n.jqx.dataAdapter.DataExporter is not a constructor _exportData http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:64 exportview http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:64 invoke http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:365 jqxWidgetProxy http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:365 yK+z/</</e.jqx.jqxWidget/e.fn[r]/< http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:365 each http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:124 each http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:124 r http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:365 exportGrid http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:139 exportGrid http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:358 click http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:358 Ve http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:328 i http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:328 _wrapper http://127.0.0.1:8000/build/vue_components.8b81c7b6.js:328 vue_components.8b81c7b6.js:139:9310
I am using latest version of jqx widgetsOctober 27, 2020 at 6:57 pm Grid export for large amount of data #113456
ok I have managed to make it work, few imports were missing, anyway this exportview do not work for over 300k rows (file was over 200mb) I was able to download file, but content was incorrect.
Do you have better solution or demo for grids with over million rows where export works?October 28, 2020 at 1:44 pm Grid export for large amount of data #113460
It is a new method.
Please, check the references from the mentioned demo.
https://www.jqwidgets.comOctober 28, 2020 at 3:57 pm Grid export for large amount of data #113466
but do you have example for that method with over 1 million rows?October 29, 2020 at 1:43 pm Grid export for large amount of data #113478
Thank you for your interest.
It depends on what kind of exporting format do you use (the PDF format is the heaviest one).
https://www.jqwidgets.comOctober 29, 2020 at 5:48 pm Grid export for large amount of data #113479
just to excel, I do not use othersOctober 30, 2020 at 1:55 pm Grid export for large amount of data #113484
We will discuss this.
Meanwhile, I would like to suggest you try to export to the CSV format (which is possible for import in Excel).
You must be logged in to reply to this topic.