Zen Cart Logo
Forums / All Other Contributions/Addons / Easy Populate CSV trouble

Easy Populate CSV trouble

Locked

Views: 1,030

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
23 Mar 2009, 5:29 PM
#1
froldao avatar

froldao

New Zenner

Join Date:
Nov 2007
Posts:
40
Plugin Contributions:
0

Easy Populate CSV trouble

I installed Easy Populate 1255. It runs perfectly.

However, when I download the CSV from my store and import it to Excel, I see that, since I have html in some products, for instance "color: rgb(51,51,153)", when Excel imports the CSV it breaks my html because of the commas...

Is there a way to use EP without this problem ocurring? Can EP export a tab delimited CSV?

23 Mar 2009, 6:05 PM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Easy Populate CSV trouble

Looks like you've installed Easy Populate CSV - a recently-developed "modification" to EP Standard 1.2.5.5, by user "phazei".

CSV means what it says "comma separated values", so you can't have a tab-delimited file in csv - it does not make logical sense.

You have a couple of options:

  1. Give your colours hex values, not rgb.
  2. Try encasing text in double quote marks ("text strings here"). (Not sure if this will work).
  3. Abandon EP CSV and load up the conventional 1.2.5.5 module. (This works with tab-delimited files). you should not need to uninstall the csv module - just overwrite the EP files. Also, no need to worry about the database because csv uses same SQL as EP standard.)
23 Mar 2009, 6:48 PM
#3
froldao avatar

froldao

New Zenner

Join Date:
Nov 2007
Posts:
40
Plugin Contributions:
0

Re: Easy Populate CSV trouble

Thanks, I installed the conventional 1.2.5.5 version and it's working fine.