DrAnax Posted June 24, 2013 Share Posted June 24, 2013 (edited) I have been struggling for the past four hours with the following problem. I'm trying to import a product via CSV, and the problem is that one of my product features has a colon ( : ), for example feature name: Artist feature value: various: christmas collection Normally the CSV should look like Name;Features product name;feature1:featurevalue1:featurepos1,feature2:featurevalue2:featurepos2 I tried several, such as "product name","feature1":"feature:value1":"featurepos1" product name,feature1:feature::value1:featurepos1 product name,"""feature1"":""feature:value1"":""featurepos1""" but nothing works. How can I import a product, who's feature's value contains a colon? Thanks Edited June 25, 2013 by DrAnax (see edit history) Link to comment Share on other sites More sharing options...
Buds Posted June 25, 2013 Share Posted June 25, 2013 I don't know what program you are using to configure your csv files, but assuming it's like excel or notepad++, you can do a "find and replace all" command the change the colon to something else, like a dash for instance. -Bud Link to comment Share on other sites More sharing options...
DrAnax Posted June 25, 2013 Author Share Posted June 25, 2013 (edited) I don't know what program you are using to configure your csv files, but assuming it's like excel or notepad++, you can do a "find and replace all" command the change the colon to something else, like a dash for instance. -Bud Thanks for the suggestion. I could do that, but then I would have to go to each product and change the feature's value back to what it was. So, this is a workaround rather than a solution. Thanks though Edited June 25, 2013 by DrAnax (see edit history) Link to comment Share on other sites More sharing options...
Frank1957 Posted October 7, 2013 Share Posted October 7, 2013 Did you every resolve this problem with colons in features data, I am having the same problem. Link to comment Share on other sites More sharing options...
DrAnax Posted October 11, 2013 Author Share Posted October 11, 2013 Did you every resolve this problem with colons in features data, I am having the same problem. Sadly I did not. I ended up changing the data from the database manager (phpMyAdmin) Link to comment Share on other sites More sharing options...
Frank1957 Posted October 12, 2013 Share Posted October 12, 2013 Neither did I. Thanks for the reply. Link to comment Share on other sites More sharing options...
MEG Venture Posted December 17, 2013 Share Posted December 17, 2013 Please see my post here: http://www.prestashop.com/forums/topic/281094-features-problem-after-import-csv-pre-defined-value-repeatduplicate-prestashop-156/?p=1497779 Link to comment Share on other sites More sharing options...
Recommended Posts