I have a sql query which returns around 16,000 records. I want to do an xls export of the query, so I am trying to do "Show All entries", but the plugin becomes non responsive and times out.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
For tables with server-side processing only the visible rows will be exported to any format. This means that if you want the whole table to be exported you would need to choose “Show All” feature , but if you have large amount of data that can cause plugin freeze because plugin need more time to display data. My suggestion is to make VIEW in phpmyadmin and then export data from that table like csv file that can be converted to excel.
I have a sql query which returns around 16,000 records. I want to do an xls export of the query, so I am trying to do "Show All entries", but the plugin becomes non responsive and times out.
Can you please assist?
Hi Kristin,
Thank you for your purchase.
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
For tables with server-side processing only the visible rows will be exported to any format. This means that if you want the whole table to be exported you would need to choose “Show All” feature , but if you have large amount of data that can cause plugin freeze because plugin need more time to display data. My suggestion is to make VIEW in phpmyadmin and then export data from that table like csv file that can be converted to excel.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables