Why is my file not importing? It just keeps loading or throws an error.
If you're trying to import a large file (CSV, Excel, or Google Sheet) with several thousand rows and encounter an infinite loading animation or an error message, this usually happens due to WordPress and server execution limits.
How can I import large files into wpDataTables?
You can bypass this limitation by importing the file directly into your database using a tool like phpMyAdmin.
Before importing, make sure:
The first row of your file contains column headers.
The table name does not contain spaces, dots, or special characters (e.g. use
table_1).
Once imported, how do I use it in wpDataTables?
After the table is in your database, you can create a new MySQL Query-based wpDataTable with a query like:SELECT * FROM table_1