VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 Bulk Import of csv with commas in Description
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jmccann
VP-ASP New User

United Kingdom
131 Posts

Posted - October 03 2006 :  05:32:35  Show Profile  Visit jmccann's Homepage  Reply with Quote
Hi,

I have been given CSV file to be used for the bulk import of Products. However, the problem I have is that the description uses commas (,) within the text. I use Excel to produce the formatted output, but can only get a csv file file which gets thrown out of alignment becuse of the embedded commas. I dont want to change the comma within product descrption as it improves readability.

Can anyone suggest a way to use excel to keep comas and to output an import file that VPASP can use?

regards,

jim mccann

devshb
Senior Member

United Kingdom
1898 Posts

Posted - October 03 2006 :  05:57:38  Show Profile  Visit devshb's Homepage  Reply with Quote
vpasp imports can use any separator, so if you save your file as one that's separated by another character (say, "{", instead of a comma) and then use that when importing as your delimiter, it should be ok.

another possibility is to save it as a tab-separated file, and tweak the import asp to be able to cope with a tab delimiter, see the link below which explains how to do it (free!) :

http://www.bigyellowzone.com/support/issue_view.asp?ID=442&CATE=8

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons

Edited by - devshb on October 03 2006 06:21:19
Go to Top of Page

bmw000
VP-ASP New User

137 Posts

Posted - October 03 2006 :  19:55:31  Show Profile  Visit bmw000's Homepage  Reply with Quote
I would have to say the tab-separated is the way to go. I almost never have a problem importing tab-separated files.

Brian Weber
Variety Solutions, LLC
http://www.varietysolutions.com
Go to Top of Page

rustytec
VP-ASP New User

Australia
113 Posts

Posted - October 05 2006 :  08:23:57  Show Profile  Reply with Quote
hi,

Vpasp can also import it using a | separator.

I've used it and it also works very well.

Just for info.

cheers

rustytec
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000