Hi all, I've been using WPdatatables for awhile now and have several of the add-ons as well. My problem is I have a large excel file, about 400,000 lines long that I'm trying to upload into WPdatatables but I keep getting a server error (timing out, etc). My intent is to use the server-side processing whenever I get this uploaded.
Can you let me know if there is something I should be doping with a large file?
I don't believe your hosting provider will allow you to increase the details in your php.ini file so you would be able to upload a file with 400.000 lines
My advice would be to save that file as CSV, and then to go to your database via phpMyAdmin, and import the file there. It will create a new database table which you can pull with SQL query in wpDataTables.
Also - a piece of advice - that imported table will be named something like "TABLE 123". Rename it to "TABLE123" or something else, just without spaces. That will avoid filtering/search/sorting issues in the SQL query based table later on.
Hi all, I've been using WPdatatables for awhile now and have several of the add-ons as well. My problem is I have a large excel file, about 400,000 lines long that I'm trying to upload into WPdatatables but I keep getting a server error (timing out, etc). My intent is to use the server-side processing whenever I get this uploaded.
Can you let me know if there is something I should be doping with a large file?
Thanks a lot.
Tony
Hello Tony
I don't believe your hosting provider will allow you to increase the details in your php.ini file so you would be able to upload a file with 400.000 lines
My advice would be to save that file as CSV, and then to go to your database via phpMyAdmin, and import the file there. It will create a new database table which you can pull with SQL query in wpDataTables.
Also - a piece of advice - that imported table will be named something like "TABLE 123". Rename it to "TABLE123" or something else, just without spaces. That will avoid filtering/search/sorting issues in the SQL query based table later on.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables