Fatal error when importing table from CSV file

Hi,

thanks for your post, and sorry for the trouble.

I’m afraid to disappoint you, but that table is simply too big for TablePress to handle. It was not designed with tables like this in mind. For such large files (which probably represent a database table), you’ll have to look into custom solutions, e.g. based on PHP/mySQL. To then make use of the JS features that TablePress has, you could add the DataTables JS library from https://datatables.net/ manually.
Sorry for not having better news here.

Regards,
Tobias

Thanks TobiasBg

Will JS features that TablePress has solve my issue? if yes how to add it? or use it.

Many thanks

Hi,

the JS features (like those on the TablePress Demo page at https://tablepress.org/demo/ )by itself will not solve this, but they can enhance the user experience for your visitors, depending on what you want to do with your table.
Those features are coming from the external DataTables JS library, so you’ll have to check its documentation (see the link above) for instructions on how to add it to a table that is created with a custom PHP/mySQL solution.
TablePress can not help you with such large tables, unfortunately.

Regards,
Tobias

Hi Tobias,

hmmm, What I can conclude that there is no wp plugin can manage large tables?

Best,

Firas

Hi Firas,

no, probably not. At least I don’t know one.

The reason why there’s no such plugin probably is that requirements for such large tables vary from user to user, so that modifications would be necessary anyways. Thus, there not a big difference to just implementing everything directly and specifically to the table in question.

Best wishes,
Tobias

What is the maximum file size for TablePress?

I am getting the following error – my file size is 741KB

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /home4/ionscorp/public_html/wp-content/plugins/tablepress/classes/class-import.php on line 428

Hi,

thanks for your question, and sorry for the trouble.

Errors during the import are not really caused by the file size of an imported file, but more by the memory that is required by the PHP process when processing the import. This highly depends on the size of the table (rows and columns) and the import format.
Can you therefore please post some more information on that? Also, does this happen when you use other import formats?

Regards,
Tobias

Hi TobiasBg,

Is there an option to edit and adjust tables from frontend?

Best,

Hi,

thanks for your question, and sorry for the trouble.

Unfortunately, I have bad news though. It is not possible to edit tables from the frontend, and it most likely won’t be in the future. The reason for this is that this would bring very complex issues with it, that affect the core internals of how the table data is saved. Therefore, tables can only be edited on the “Edit” screen in the admin area.
I hope that TablePress is still useful for you.

Regards,
Tobias

Sure it is a great plugin. thank you for developing it.
I want to view zero results in table since it is a private data, once a person type his name records appear.

Also is there a plugin that add drop-down box so that if someone select a option (table page) and click go will forward to that table page.

Thank you,

Hi,

for the first thing, you can use this approach:
Something like this is possible with this Premium Extension for TablePress: https://tablepress.org/extensions/datatables-inverted-filter/
However, using that is a little bit more complicated than for other extensions. First, install and activate it like a regular WordPress plugin. Then, you’ll need to modify the PHP file of the Extension. In line 22, the array needs to be filled with the slugs of all pages that you want to use this function on. The “slug” is the last part of the URL of a page.

I’m not aware of a solution for the second thing. This is not really something that TablePress can offer, as it depends on the structure of your site and where tables are embedded. You will have to find a custom HTML/JavaScript solution for this.

Regards,
Tobias

Hi TobiasBg and thanks for the help, I didn’t get, what will this do? I have installed the extension and nothing happen?

Best,

Hi,

it will hide the table initially and then only show records once the visitors starts typing (Note that this is not preventing a visitor from getting all data. As the data is still in the page, it is possible to get all of it (with a little bit of extra effort.)

To use this, install and activate this Extension. Then make the changes to the Extension’s PHP file that are mentioned above.

Regards,
Tobias