CSV Import Issue – Too Big?

Resolved claing
(@claing)

6 years, 7 months ago

Hello,

I’m testing out Tablepress as a possible solution for an online inventory catalog for our company. We are exporting a .csv file of our product database, uploading to our web server by FTP, then using the Auto Import Tables feature to update the catalog throughout the day. All has been going well until a recent update (and increase) of the database/.csv file.

Issue: The .csv file no longer uploads into Table Press. Eiter via the auto import tables feature, or as a manual file upload function. All attempts result in an error – “The data for the import is invalid.”

One big change from the last successful upload is that the database (.csv file) had just doubled in size (from 4000 items to 8000), still the file size itself is <1MB. Is there a limit to the size of the imported .csv?

Thanks in advance –

Viewing 9 replies - 1 through 9 (of 9 total)

Plugin Author Tobias Bäthge
(@tobiasbg)

6 years, 7 months ago

Hi,

thanks for your post, and sorry for the trouble.

Normally, the file and table size don’t matter too much, in a CSV file, at least for the manual import.
Can you maybe email me the CSV file (the address is in the plugin’s main file “tablepress.php”), so that I can check if there’s anything unusual in it?

Regards,
Tobias

Thread Starter claing
(@claing)

6 years, 7 months ago

Hi Tobias,

I appreciate you looking into the file. It has been sent to your email listed in tablepress.php. Thanks in advance!

Plugin Author Tobias Bäthge
(@tobiasbg)

6 years, 7 months ago

Hi,

thanks! I have received your email and will take a look as soon as I find some time!

Regards,
Tobias

Thread Starter claing
(@claing)

6 years, 6 months ago

Tobias,

We are still troubleshooting this issue. I was able to successfully import the .csv file in question via a locally hosted copy of the website in a test environment I created on my machine using XAMPP, after a few server adjustments related to max file size and time limits.

Unfortunately, my web host is still not able to correct the issue in the live site on their end. I’ve provided them the list of server adjustments I’ve made. They are also wondering if there may be some sort of a ‘debug mode’ or better way they can troubleshoot the “The data for the import is invalid” error that table press is throwing?
Plugin Author Tobias Bäthge
(@tobiasbg)

6 years, 6 months ago
Hi,

sorry to hear that you are still having problems 🙁

Unfortunately, there’s no direct debug mode, so that the best approach is to add “check points” in the code, e.g. via output of certain variables during the import request. For that, I usually add something like
```
var_dump( $table );
exit();
```
(with whatever variable I’m interested in) in the code.

My guess here is that TablePress does only get an “empty” file passed, because some server check or software blocked the request or deleted the uploaded file too early.

Regards,
Tobias
Thread Starter claing
(@claing)

6 years, 6 months ago

Thanks Tobias,

On my localhost server the answer seemed to be changing the ‘max_allowed_packet’ from 1M to 1024M (or anything in between) in the localhost server’s php.ini file. Unfortunately this was already set to 16M on our live site’s web host server.

I agree with you, and do believe it’s a server check, limitation, or other software blocking the request. I’ll pass this on to my web host team and see what they might find.

Thanks again,
Christopher

Plugin Author Tobias Bäthge
(@tobiasbg)

6 years, 6 months ago

Hi,

thanks! I hope that they can fix this!

Regards,
Tobias

Thread Starter claing
(@claing)

6 years, 6 months ago

My web host team was able to make the adjustment needed on their end. We’re back in business!

Plugin Author Tobias Bäthge
(@tobiasbg)

6 years, 6 months ago

Hi,

that’s great news! Thanks for the confirmation!

Best wishes,
Tobias

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘CSV Import Issue – Too Big?’ is closed to new replies.