VirtueMart Developer Portal
About  
 
   
   
[BUG-116]  -  CSV File upload
Tags:   No tags associated yet.
All Tags...
Go Back
  0  
 Tracker:  Bug  Priority:  High  Status:  Closed
 Resolution:  Won't fix  Owner:  --  Severity:  --
 Submitted by:  soeren_nb Oct 14 2005 15:45  Assigned to:  --  Modified by:  soeren_nb Jan 10 2008 16:11
 Category:  --  Platform:  --  OP-SYS:  --
 Version:  --  Joomla! Version:  --  Browser Version:  --
 Fixed in Version:  --
Description:
1) Have a perfect CSV upload template, but when the upload finishes the product table is empty, and there are new categories.

2) Use standard product export, and try to import the same file will produce the same result.

Win XP (all SP) Mambo 4.5.2.1 mp 1.2 stable-pl3 UltraEdit32 (for csv generation)

Clean install of mp.

Details:
Comments (11)
Attachments (0)
Associations (0)
SCM Commits (0)
All (11)

Submitted Comment
soeren_nb
Mar 31 2006 06:52
Please see the thread I started here, it kinda relates/overlaps with what this task is requesting...http://virtuemart.net/index.php?option=com_smf&Itemid=71&?topic=16953.msg37507;topicseen#msg37507

soeren, have you already started development of this fix?
soeren_nb
Feb 07 2006 22:27
BTW, I have read every post,tutorial, and hint regarding this. nothing has worked (and i'm very apprehensive about mucking with the php code
soeren_nb
Feb 07 2006 22:26
I have the same problem. I started a thread where I put as much info as I know how (for debugging), but i'm not that experienced. I have had no luck in even getting responses in the forum, but I hope this helps anyway:

http://virtuemart.net/index.php?option=com_smf&Itemid=71&topic=13212.0
soeren_nb
Feb 04 2006 01:12
CSV upload is VERY sensitive. Only way I was able to get it to work at all is to fill in ALL fields with data. Don't leave anything out. Use " and '. I'm uploading a program to the forum tonight that will help generate csv data. The only thing thats NOT working on it is image paths and I'm still working on that. Its supposed to work the way it is, but so far no luck.
soeren_nb
Jan 14 2006 01:06
Nah! I've just got rid of ALL none alphanumeric chars in the descs, but still no joy!
soeren_nb
Jan 13 2006 23:52
i had the same problem.
after turning on the debug mode i saw there is (in my case) a database insert problem.
i looked through all my descriptions and changed every ' in a \\'
after that all worked fine for me. :)
soeren_nb
Dec 13 2005 09:39
same problem here...and to be honest I have been struggling with CSV upload since the last two weeks...with poor progress.

Finally I desparately try to upload the example file (in the documentation tab)....result was better as products were
added to the store...but the "category path" was still missing.

Any help would be appreciated.

Thanks
soeren_nb
Dec 04 2005 23:07
Me too!
I have 2937 products... Not doing it one by one! :-)
Changed from ZenCart to this.! I have installed this on another site where I manually entered 10 products! It's brilliant! Please fix this one! I don't wanna go back to ZenCart!
Doug
soeren_nb
Oct 18 2005 11:49
I have this same problem. I've tried it with , as the delimiter, with ; as the delimiter, and with and without quotes for the separator. php-shop categories are created, but no products.

Is it possible to use a tab delimited file? That would be very convenient.
soeren_nb
Oct 14 2005 16:17
I have the same problem, Did an export using the standard details, copied one line. Didn't change the format but created a one line file with :

"Code","Title","Description","a.png","b.png","0.0000","pounds","0.0000","0.0000","0.0000","inches","0","-3600","N","0","Name","1.99000","Software","1","3","0","Code","","","",""

Uploaded that file and got
Line 1: No product_name,
CSV file sent.
soeren_nb
Oct 14 2005 15:51
Too few details.
What delimiter + separator charcater do you use?
Do the product details contain quotes?