Forums / All Other Contributions/Addons / Downloading easy populate csv and it's blank?

Downloading easy populate csv and it's blank?

Views: 1,243

Results 1 to 3 of 3
18 Jul 2012, 2:07 AM
#1
kezerb avatar

kezerb

New Zenner

Join Date:
Sep 2008
Posts:
46
Plugin Contributions:
0

Downloading easy populate csv and it's blank?

Hi guys,
I'm about to give up, I can't find any help and I don't know what to do.
I'm trying to download a .csv of my currently uploaded products so I can upgrade to easy populate 4.0 (I can't remember which one I currently have but the last update I did was Easypopulate csv by citychou) and it's coming up blank.

These links allow me to download some data though so I have no idea why the first one won't let me?
Download Model/Price/Qty .csv file to edit
Download Model/Price/Qty/Last Modified/Status .csv file to edit
Download Model/Category .csv file to edit
Download Froogle tab-delimited .txt file
Download Model/Attributes .csv file

Zencart version 1.5 btw

ETA: I got an error log when I tried to download the complete csv to my temp file. Here it is.

MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
SELECT
p.products_id as v_products_id,
p.products_model as v_products_model,
p.products_image as v_products_image,
p.products_price as v_products_price,
p.products_weight as v_products_weight,
p.products_last_modified as v_last_modified,
p.products_date_added as v_date_added,
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.manufacturers_id as v_manufacturers_id,
subc.categories_id as v_categories_id,
p.products_status as v_status,
p.metatags_title_status as v_metatags_title_status,
p.metatags_products_name_status as v_metatags_products_name_status,
p.metatags_model_status as v_metatags_model_status,
p.metatags_price_status as v_metatags_price_status,
p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS FROM
products as p,
categories as subc,
products_to_categories as ptoc
WHERE
p.products_id = ptoc.products_id AND
ptoc.categories_id = subc.categories_id

MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
SELECT
p.products_id as v_products_id,
p.products_model as v_products_model,
p.products_image as v_products_image,
p.products_price as v_products_price,
p.products_weight as v_products_weight,
p.products_last_modified as v_last_modified,
p.products_date_added as v_date_added,
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.manufacturers_id as v_manufacturers_id,
subc.categories_id as v_categories_id,
p.products_status as v_status,
p.metatags_title_status as v_metatags_title_status,
p.metatags_products_name_status as v_metatags_products_name_status,
p.metatags_model_status as v_metatags_model_status,
p.metatags_price_status as v_metatags_price_status,
p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS FROM
products as p,
categories as subc,
products_to_categories as ptoc
WHERE
p.products_id = ptoc.products_id AND
ptoc.categories_id = subc.categories_id

MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
SELECT
p.products_id as v_products_id,
p.products_model as v_products_model,
p.products_image as v_products_image,
p.products_price as v_products_price,
p.products_weight as v_products_weight,
p.products_last_modified as v_last_modified,
p.products_date_added as v_date_added,
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.manufacturers_id as v_manufacturers_id,
subc.categories_id as v_categories_id,
p.products_status as v_status,
p.metatags_title_status as v_metatags_title_status,
p.metatags_products_name_status as v_metatags_products_name_status,
p.metatags_model_status as v_metatags_model_status,
p.metatags_price_status as v_metatags_price_status,
p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS FROM
products as p,
categories as subc,
products_to_categories as ptoc
WHERE
p.products_id = ptoc.products_id AND
ptoc.categories_id = subc.categories_id

19 Sep 2012, 2:44 PM
#2
john_1 avatar

john_1

New Zenner

Join Date:
Sep 2012
Posts:
2
Plugin Contributions:
0

Re: Downloading easy populate csv and it's blank?

I commented out the following lines in the easypopulate.php file and I do not got around this issue:
Note: *** I do not use customer fields. ****
This can be found if you search other versions of easypopulate on this site...

$custom_fields == FALSE;
/* if(strlen(EASYPOPULATE_CONFIG_CUSTOM_FIELDS) > 0)
{
$custom_fields = explode(',',EASYPOPULATE_CONFIG_CUSTOM_FIELDS);
}
*/

10 Oct 2012, 6:42 PM
#3
retched avatar

retched

Totally Zenned

Join Date:
Jun 2007
Location:
Bronx, New York, United States
Posts:
949
Plugin Contributions:
3

Re: Downloading easy populate csv and it's blank?

John...:

I commented out the following lines in the easypopulate.php file and I do not got around this issue:
Note: *** I do not use customer fields. ****
This can be found if you search other versions of easypopulate on this site...

$custom_fields == FALSE;
/* if(strlen(EASYPOPULATE_CONFIG_CUSTOM_FIELDS) > 0)
{
$custom_fields = explode(',',EASYPOPULATE_CONFIG_CUSTOM_FIELDS);
}
*/

Even better, you could use the actual installer built into EasyPopulate (easypopulate.php?install) and not the install.sql file provided with the new version.

OR

use the following code:

INSERT INTO configuration VALUES
('', 'Custom Products Fields', 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS', '', 'Enter a comma seperated list of fields to be automatically added to import/export file(ie: products_length, products_width). Please make sure field exists in PRODUCTS table.', '31' , '10', NULL, now(), NULL, NULL);