easy populate product description format & create complete

[george_usa]

help 1:
i've beening reading through many posts here as to easy populate and especially on the product description, but am not able to find straight answer to my problem.

im using easy populate v1.2.5.4, zen cart v1.3.9h, in my product description in html, there're <br />, but the easy populate downloaded file does not have the <br />, so when i uploaded the file, the product description became one paragraph.

i saw easy populate has sample file for complete download tab-delimited .txt to edit, there're <br />. but why my download has no <br /> at all.

could anyone kindly help to advise what's correct way to download? so that the product description format is kept.

help 2:
when i clicked "Create Complete tab-delimited .txt file in temp dir (Attributes Not Included) ", it says "FULL-EP.....txt successfully exported. the file is ready for download in your /temp-mine directory" (i changed to temp-mine). but when i checked the directory, there's no files at all. im new to this, i might have done something wrong somewhere. any advise is highly appreciated.

[kobra]

Check the wiki for an article on how to use easy populate

Link above right

[george_usa]

help1:
id been reading article on http://www.zen-cart.com/wiki/index.php/Easy_Populate, but didn't get the answer to my <br /> problem in product description. do you mean other page i can refer to? or maybe i just didn't realise there's answer already in the page i went through. your advice is appreciated.

help2:
sorry, i'm not sure what you meant. there's no file created under /temp-mine when clicking on those 5 Create files in easy populate. the /temp-mine does exist, and message says file is successfully export. but there's just no file in the /temp-mine. i've been searching in forum, but didn't get luck to see this issue, maybe it's my own problem. any advice is appreciated.

[kobra]

I do not use EP, just know that there is a wiki article on it

[george_usa]

i just tried class template to see if the <br /> line break in html for the product description can be kept, the result is that the issue persists.

is it default setting for keeping the <br /> in the easy populate downloaded file?

any advice is appreciated.

[george_usa]

i've been struggling on the two issues, the issue 2 that the EP file is not created is finally worked out that it's due to executing it in another language admin panel. when i switched back to english admin panel, the EP file is created in /temp.

for the <br /> to display in downloaded EP file for product description, i tried to set configuration in easy populatin in admin panel, and uncommented few lines in config file, it doesn't help at all. is there anyone here who can kindly offer a hint to resolve?!

does text editor to view the EP file matter?

any advice is appreciated.

[JimmyV]

I don't use that version any more but I do use the EZ Pop 1.3.9 and nearly all my descriptions contain html and it is retained on down and upload. I really don't remember it ever being an issue on 1.2 but maybe I was not using such tags back then.

Might I suggest you try the above listed you can always remove it and reinstall your current version.

[george_usa]

with easy pop 1.3.9 installed, (i didn't install "installgrouppricingcolumnsalt_sql" as im not sure if i'll need it), i can get ez pop file generated, still in english admin panel, not in other languge admin panel. however, the ez pop file generated is blank, no entries in it at all, only field name.

there was an error msg as below when generating the ez pop file.

Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer.

here is the ep_debug_log.txt, looks like it is, confirmation is welcome.
=======================================================
MySQL error 1054: Unknown column 'p.products_group_a_price' 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_group_a_price as v_products_group_a_price,
p.products_group_b_price as v_products_group_b_price,
p.products_group_c_price as v_products_group_c_price,
p.products_group_d_price as v_products_group_d_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 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.products_group_a_price' 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_group_a_price as v_products_group_a_price,
p.products_group_b_price as v_products_group_b_price,
p.products_group_c_price as v_products_group_c_price,
p.products_group_d_price as v_products_group_d_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 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.products_group_a_price' 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_group_a_price as v_products_group_a_price,
p.products_group_b_price as v_products_group_b_price,
p.products_group_c_price as v_products_group_c_price,
p.products_group_d_price as v_products_group_d_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 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

==========================================================


is this blank ez pop file and the error msg above related to not installing the "installgrouppricingcolumnsalt_sql"?

i'm new to this, wondering how to do this "installgrouppricingcolumnsalt_sql" install? is it admin/Tool/Install SQL Patches/upload file?

appreciate your advice.

[JimmyV]

Yes I wrote that extra sql file so that if you don't have the GP mod installed you can still get the added functionality of the more robust EZ Pop.

If you install the script the error "should" disappear. If you continue to have issue you are welcome to PM me.

Read the install instructions as you may have missed other important steps. I know nobody reads instructions anymore but they do help sometimes :)

Enjoy!

[kobra]

MySQL error 1054

What versions

php
mysql
Zencart