Grid export for large amount of data

[aniolekxParticipant]

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)

[aniolekxParticipant]

Should I ask this question through premium support?

[HristoParticipant]

Hello aniolekx,

The exportdata method of the jqxGrid works on the Server-Side but also you could determine which records to be exported.
On the other hand, the exportview method (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:
https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/dataimport.htm?light

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.htmlelements.com/docs/data-exporter/

Best Regards,
Hristo Hristov

jQWidgets team
https://www.jqwidgets.com

[aniolekxParticipant]

I am using jQuery grid, not smart html elements, so how I can export grid data without sending it back from grid to server?

[HristoParticipant]

Hello aniolekx,

You could use the exportview method where it happens on the Client-Side.
Please, take a look at this demo.

Best Regards,
Hristo Hristov

jQWidgets team
https://www.jqwidgets.com

[aniolekxParticipant]

Thanks Hristo,

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” ?

[aniolekxParticipant]

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 widgets

[aniolekxParticipant]

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?

[HristoParticipant]

Hello aniolekx,

It is a new method.
Please, check the references from the mentioned demo.

Best Regards,
Hristo Hristov

jQWidgets team
https://www.jqwidgets.com

[aniolekxParticipant]

but do you have example for that method with over 1 million rows?

[HristoParticipant]

Hello aniolekx,

Thank you for your interest.
It depends on what kind of exporting format do you use (the PDF format is the heaviest one).

Best Regards,
Hristo Hristov

jQWidgets team
https://www.jqwidgets.com

[aniolekxParticipant]

just to excel, I do not use others

[HristoParticipant]

Hello aniolekx,

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).

Best Regards,
Hristo Hristov

jQWidgets team
https://www.jqwidgets.com

[Author]

Posts