I have just tried to import the table manually but the page times out. The table has over 20,000 rows. Is the plugin having a tough time with a table this size?
Hi,
thanks for your question, and sorry for the trouble.
What import format are you using here? Excel, CSV, or HTML?
For an Excel file, 20,000 rows could indeed be a problem, but for CSV, it should work. Can you maybe try saving the table to a CSV file in Excel and try again?
Regards,
Tobias
The file that I am importing is a CSV file. I have 2 issues:
1. What is the correct setting for the file location if it is stored on the local server for the Auto Import Extension?
2. The file has over 20,000 rows and the page times out on import and then display. Is there a way to not load the entire file on the page but show the data on demand as the user goes to the next page?
Thank you,
Ed S
Hi,
ok, then you could maybe take a look at increasing the PHP memory limit on the server, and the maximum script execution time.
The correct setting for the location depends on your server. It will be the local server path to that file. TablePress will suggest the first part of the path (in the regular import section for a file from the server). You will have to complete that with the subfolder and file name, as visible usually in your FTP program, for example.
Loading just parts of the file is not possible, sorry. TablePress can only work with full files.
Regards,
Tobias