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 |
|