Hello Ameet.

Thank you for your purchase.

For tables with server-side processing, only the visible rows will be exported to any format. If you want the entire table to be exported (or copied to a clipboard), you need to choose the “Show All” feature in the “show … entries” block, and then do the export.

With this in mind, I don't know how the plugin is behaving in this way on your end. Since you have over 1 million records, that table is server-side by default. And export tools are able to export only the content displayed on the page. For instance if you set the table to only show 10 rows per page, even without applying the filters, it should print or export only those 10 rows.

Also, if you enable filtering, it should only be able to print the filtered data; so I don't know how you got the plugin to export everything.

I followed this page: http://darkdata.bc.edu/market-data/ and I was able to only print what was displayed on the page. Filters are not visible, however, only search. So, when I search for an entry (for instance "nice") it shows 10 out of some 50.000+ entries, and when I try to print or export, it only prints the 10 entries visible on the page.

Can you please double-check and verify?

Also, can you tell me what format are you trying to export the table to?

Best regards.

Hello again Ameet.

I know what you mean; for a table that big it can be expected that it'll break if you decide to show all entries.

Unfortunately, exporting everything from a table that's not showing all rows on a page is not possible with the plugin's built in features.

However, for something like this, I invite you to take a look at Report Builder. You can create a template for your table where you'd add variables (${mycolumn.all}) which fetch all data from the table and export it to either an Excel file or a Word file.

After the report has been created, you will have a shortcode, which you can add to your page, and have the users download the report by using that shortcode.

Please go through the documentation, as it is explained how to create templates, there are a lot of examples here which you can use to generate your own template.

For any other questions, we're here to help.

Best regards.

You are welcome Ameet.

If you have any more issues or questions feel free to open a new ticket, we will gladly help.

Best regards.