I just bought you WPdataTables, and I'm very satisfied. I imported csv and xls files, no problem, today i wanted to import a csv file with 1,600,000 lines, and i have error messages. Is it limited by the maximum number of lines to import? Thank you in advance for your answer. Sorry for my English. Christophe Brida
Don't apologize for your English - it is quite good.
This format will work only up to a certain limit (no exact limit, but 3000-5000 cells is a good example). If you have a larger file, the page load time will increase. For large data sets it makes sense to import the data to MySQL, you can use “Create a table by importing data from data source” option to do this.
The plugin simply cannot handle that much data if it's not coming straight from the database.
You cannot import a file that big through wpDataTables (WordPress), but instead you have to open PHPMyAdmin (your database), and import it straight in the database:
Since this is a CSV file, make sure to check this:
So, the first line of the file become table headers.
Once imported, you can use the first option when creating the table and create it using an SQL query, like this;
SELECT * FROM your_table
Unfortunately, you cannot import multiple files in the same table. Again, you'd be able to do this via PHPMyAdmin, importing another file (with the same contents) to the table you just created.
Hello,
I just bought you WPdataTables, and I'm very satisfied.
I imported csv and xls files, no problem,
today i wanted to import a csv file with 1,600,000 lines, and i have error messages.
Is it limited by the maximum number of lines to import?
Thank you in advance for your answer.
Sorry for my English.
Christophe Brida
Hello Christophe.
Thank you for your purchase.
Don't apologize for your English - it is quite good.
This format will work only up to a certain limit (no exact limit, but 3000-5000 cells is a good example). If you have a larger file, the page load time will increase. For large data sets it makes sense to import the data to MySQL, you can use “Create a table by importing data from data source” option to do this.
The plugin simply cannot handle that much data if it's not coming straight from the database.
Best regards.
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
Hello Aleksandar,
thank you for your reply
That's what I did,
but I have the following message, both in CSV and in XLS:
"There was an error while trying to generate the table! error 0"
Can we import multiple files into the same table?
I want to incorporate them in MySQL
Thank you in advance
Christophe Brida
Hi again Christophe.
I believe we don't understand each other here.
You cannot import a file that big through wpDataTables (WordPress), but instead you have to open PHPMyAdmin (your database), and import it straight in the database:
Since this is a CSV file, make sure to check this:
So, the first line of the file become table headers.
Once imported, you can use the first option when creating the table and create it using an SQL query, like this;
Unfortunately, you cannot import multiple files in the same table. Again, you'd be able to do this via PHPMyAdmin, importing another file (with the same contents) to the table you just created.
Best regards.
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
Okay ;-)
Sorry I did not understand
Thank you
I'm going to try
Have a good day
Christophe