Easy Populate 1.2.5.4 support

I've been having a hell of a time trying to format my CSV correctly. I have a feeling it is my version of Excel not formatting correctly.

I've used Easy populate for over a year on osCommerce, but I am having a major headache with this. I've noticed that when you open a file through excel [txt/csv] so you can view it in a way to edit it and pump it back out to re-import, it screws with the format. It looks totally different than what originally came out of EP.

The is the first time I've used EP on my home comp so I know it has to do with my Excel settings. Is there a program that can load a csv file and format it correct for proper importation?

CSV Example [Pre-load] renamed CSV to TXT so I am assuming it left it comma deliminated.

v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_p roducts_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_p roducts_price,v_products_weight,v_date_avail,v_date_added,v_products_quantity,v_ manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v _categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7,v _tax_class_title,v_status,v_metatags_products_name_status,v_metatags_title_statu s,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_statu s,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
"WJ-B2024-E,,""Test wonder"",,,,,,233,12,,""2009-03-24 00:34:02"",10,,""Premium Products"",,,,,,,""Taxable Goods"",1,0,0,0,0,0,,,"


CSV Example [Post Excel] Piece of file I'm trying to add.

v_products_model;v_products_image;v_products_name_1;v_products_description_1;v_p roducts_url_1;v_specials_price;v_specials_date_avail;v_specials_expires_date;v_p roducts_price;v_products_weight;v_date_avail;v_date_added;v_products_quantity;v_ manufacturers_name;v_categories_name_1;v_categories_name_2;v_categories_name_3;v _categories_name_4;v_categories_name_5;v_categories_name_6;v_categories_name_7;v _tax_class_title;v_status;v_metatags_products_name_status;v_metatags_title_statu s;v_metatags_model_status;v_metatags_price_status;v_metatags_title_tagline_statu s;v_metatags_title_1;v_metatags_keywords_1;v_metatags_description_1
WJ-A1011-BLUE;WJ-A1011-BLUE.jpg;"3"" RETANGULAR ALUMINUM DRIVING LIGHT - BLUE";"3"" RETANGULAR ALUMINUM DRIVING LIGHT - BLUE";;;24.03.2009 00:34;;34,51;4;;;10;WinJet;Aftermarket Lighting;Universal Fog Light Kits;;;;;;Taxable Goods;1;;;;;;;;

Looks like it's semi colon deliminated as well as missing quote markes in specific sections. However it is saved as a CSV file. Not sure how to get around this.

Use OpenOffice instead of excel...make sure to add EOREOR
at end of every product entry or EP will not work

Thanks for the quick response, was going nuts. I tried the EOREOR, however thought .5 did not use it.

Thanks for the Open Office recommendation, I'll try that.

No problem..let us know how you get on...
BTW..EP Version 1.2.5.4 is best!!

Quote:

---

Originally Posted by momof2

I did read through as many posts as I could...could someone please direct me to the correct place to download version 1.2.5.4? The link i keep seeing at http://modhole.com is not working...Any help in the right direction would be greatly appreciated. Thanks

---

You can download Easy Populate Version 1.2.5.4 from

http://www.zen-cart.com/archived_con...s/admin-tools/

I can downgrade, not a problem. Curious though, open office seems to work better, but if I open as a semicolon and save as a CSV, it still reads as semicolon delimited instead comma.

Is there a way to force it to save SPECIFICALLY as comma.

Edit: Never mind, think I got it.

http://www.zen-cart.com/wiki/index.php/Easy_Populate
Suggest you read wiki above...

Thanks a bunch misty!

Problem: Have very large descriptions of my products. Aparantly too large for EP v_product_description field.

I go to catagory in admin and go to a product and add addition data that could not be added through EP.

When I do and update, all the additional data I just added is purged and all that remains is the intial short description.

Question: How or can I upload large descriptions with EP?
or If not How do I keep product descriptions in tact when I update with EP.

Any help would be appreciated

Need to clarify: The additional description I discuss is for products.

I promote a vitamin line and there are quite lengthy and detailed ingredient and recommended usage descriptions.

I get some of these from manufacturers and I cut and paste.

Others I have to create, so after a lot of work, I hate to loose them, when I make global price changes and such with EP.

Thanking any of you in advance for any help or solution.