| Author |
 Topic  |
|
|
jmccann
VP-CART New User
United Kingdom
131 Posts |
 Posted - October 03 2006 : 05:32:35
|
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
1904 Posts |
Posted - October 03 2006 : 05:57:38
|
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 |
 |
|
|
bmw000
VP-CART New User
137 Posts |
Posted - October 03 2006 : 19:55:31
|
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 |
|
|
|
rustytec
VP-CART New User
Australia
113 Posts |
Posted - October 05 2006 : 08:23:57
|
hi,
Vpasp can also import it using a | separator.
I've used it and it also works very well.
Just for info.
cheers
rustytec
|
|
|
| |
Topic |
|
All Forums
Bulk Import of csv with commas in Description
New Topic
Printer Friendly
TrustGuard - PCI Security Scanner
