Download & Extend
Taxonomy CSV import/export » Issues

CSV is only partially imported

Posted by hiinphiber on April 23, 2009 at 4:46am
Project:Taxonomy CSV import/export
Version:5.x-1.4
Component:Miscellaneous
Category:support request
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

Hello,

I'm trying to import a CSV file containing 1700 lines for a hierarchical vocabulary consisting of 3 levels. I've got each line formatted in the form, "A,B,C" where C is the child of B, and B is the child of A.

Of the 1700 lines, less than half of them get imported. I've tried changing the commas to semicolons, as well as every combination of settings on the import page. Moreover, one time it imported all but the last couple hundred terms, but all subsequent tries haven't been able to exceed the halfway point.

I've broken up the CSV into smaller files, and still it does not reach the end of the smaller files. Additionally, I never reach an "Import Success" page, after I click "import" the browser attempts to load the /taxonomy/csv page but I end up at /internal_error.html.

I suspect this may be a hosting issue as I'm on shared hosting, and they may be restricting such large queries. Does anyone have any insight or can confirm that this is the case?

Thanks in advance! And keep up the awesome work!

Login or register to post comments

Comments

#1

Posted by Daniel_KM on April 23, 2009 at 8:49am

Hi,

Sorry, I don't know what is the problem but I think like you it's a memory or hosting issue.

To be sure, you can try with a virtual server as xampp and test your file on it. You can try too to remove previous created vocabulary before retrying. On my Drupal 6 install, import of a 2 MB file works fine.

Regards,

Daniel Berthereau
Knowledge manager

#2

Posted by hiinphiber on April 24, 2009 at 8:54am
Status:active» closed (fixed)

Thanks Daniel,

Just as I suspected, it's definitely a hosting issue. I set up a test environment on a spare computer and uploaded the same CSV, the CPU was pegged for quite some time.

So for anyone else who uses shared web hosting and has trouble completely importing their vocabulary, the host is more than likely killing the process for taking up too much processing power.

Thanks again!

nobody click here