I have been uploading a few csv files into tw, the first two were rather small and beyond a few hiccups worked well. I then tried to import a larger csv file (about 11MB), this file when I click upload pauses for about 1-2 secs, then the page refreshes and nothing appears to happen. The file didn't upload, I don't see any system error messages, and I didn't get any messages spit out from tw. It is very possible it is my data or the size causing the issues (started trying the dev module to get batch handling, still didn't help). Any idea on how to go about tracking this down?

Thx.

Comments

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Status: Active » Postponed (maintainer needs more info)

I just tried a 91MB file, that worked fine for me, so it's not a general bug in Table Wizard. A couple of suggestions:

  1. Check your PHP configuration at /admin/reports/status/php - specifically upload_max_filesize and post_max_size - are they both more than 11MB?
  2. If they appear to be configured large enough, check your PHP log and see if there are any errors there.
jmather’s picture

jmather commented

Ok, thanks for that, had a new test server and I hadn't tweaked any of the php settings much so they were still hovering at the 2M levels ;)

That got it uploaded.

jmather’s picture

jmather commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Closing, will open if I run into any further issues. thanx.

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Title: CSV Import fails with no error » Document PHP settings for importing large files
Component: tw_import_delimited » Documentation
Assigned: Unassigned » mikeryan
Category: support » task
Status: Closed (fixed) » Active

Reopening as a documentation task - I thought that the desirability of bumping up the PHP settings had been documented somewhere, but apparently not...

Thanks.

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Status: Active » Fixed

Documented in README.txt.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.