Imports failed

Hi,

thanks for your post, and sorry for the trouble.

Can you please provide some more details here? What’s the exact error message that you are getting? Can you provide the URL and/or file that you are trying to import (if you want, you can email that to me, the address is on https://tablepress.org/impressum/ ). Thanks!

Regards,
Tobias

Hi Tobias,

I stumbled about this thread because I also noticed import failures and want to share my findings here.

When importing the same CSV like always (with the “manual import” tab), I got the error message “Fehler: Der Import ist fehlgeschlagen.” (German for “Error: The import has failed”) without any details (even not in the browser’s developer console).

Investigating further, I noticed that the error occurs when I try adding a part of a html code. E.g. this CSV does not work:

“aa”;”aa”;”<a href=”;”aa”;”aa”

while this works fine:

“aa”;”aa”;”<a xhref=”;”aa”;”aa”

Maybe it is due to a security feature? But adding the html code via the regular edit page works fine as it always did.

Hope this helps,
Stefan

• This reply was modified 2 years, 2 months ago by stedaho.

Hi Stefan,

thanks for your post, and sorry for the trouble.

Yes, this indicates that this is related to a security check — however, TablePress does not have such checks for hyperlinks like in your example during the import. (It would otherwise also not allow adding these when editing a table.)

My assumption therefore is that some security or firewall software on your server (“mod_security” for the Apache webserver software, or similar) is actually already blocking the uploaded file before it reaches WordPress/TablePress. TablePress then only receives an empty file, which it can’t import.

So, here, I can only recommend to investigate this at the server level, I’m afraid, maybe together with the support team of your web host company. They might be able to find out more about this in the server’s error log files and can then hopefully relax the configuration of that security software.

Regards,
Tobias

Hi Tobias,

thank you for your quick response! Inspired by your reply I tried adding the CSV snipped via file upload – and it works perfectly fine! Just the direct import via “Manuelle Eingabe” (manual input) doesn’t work.

Can you confirm that the import of my “<a href” snippet works fine on your testing environment?

Regards,
Stefan

BTW: I like the new table editor interface!

Hi,

good to hear that you found a solution for now!

I just tested again with your snippet and found an edge case that I’ll look into a bit more as soon as possible. It might be that this is not a server configuration thing, but that the format detection for the “Manual Input” is having trouble here.

I’ll report back as soon as I find something!

Regards,
Tobias

Hi Tobias,

just to follow up: After upgrading to TablePress 2.0.1 with the improved import error messages, I get the following error when importing my non-working snippet from above:

Fehler: Der Import ist fehlgeschlagen.

Fehlercode: table_import_phpspreadsheet_failed [Exception: Unable to identify a reader for this file]

It looks like it could be an issue with the new format auto detect feature (in version 1 I had to select “CSV” manually). Is there a way to force using the CSV parser?

I wish you all the best for 2023,
Stefan

Hi Stefan,

Happy New Year to you as well!

Yes, this is what I have found as well. For some reason this only happens when there is valid HTML code in the cells though. I’ll investigate this more!

Forcing a format is not possible currently, but I’ll look into ways to maybe allow that again, as an option.

Best wishes,
Tobias

Hi Tobias,

I just want to confirm that the issue is solved in TablePress 2.0.3! Thanks a lot for your support!

Best regards,
Stefan

Hi Stefan,

great! Thanks a lot for the confirmation!

Best wishes,
Tobias