I am trying to make a table for my website. I am trying to import an xls file with 162 000 rows. It gives an error (server busy) It will only import 16218 rows. I have tried converting it to CSV but I get the same error.
Are you trying to create a table linked to the Excel file or by importing the file? If you're linking to the file, it will not work with that many rows, so you will need to import it.
A file this big may not be able to be uploaded depending on your server settings, so you can try increasing these in your php.ini file:
If that also doesn't work, my suggestion is to upload the file directly in your database, and then create an SQL Query-based table from the imported file.
I am trying to make a table for my website. I am trying to import an xls file with 162 000 rows. It gives an error (server busy) It will only import 16218 rows. I have tried converting it to CSV but I get the same error.
Hello Danie
Thank you for your purchase.
Are you trying to create a table linked to the Excel file or by importing the file? If you're linking to the file, it will not work with that many rows, so you will need to import it.
A file this big may not be able to be uploaded depending on your server settings, so you can try increasing these in your php.ini file:
If that also doesn't work, my suggestion is to upload the file directly in your database, and then create an SQL Query-based table from the imported file.
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