EasyPopulate 4.0 Support Thread

[chadderuski]

Im having trouble with the Easypopulate 4, Ive uploaded csv file and looks like its uploading but theres no new products when I click through the site. Ive just had my site updated to ZC 1.5 and now had EP4 put on. Any ideas I can forward on to the Web guy.

Zen Cart 1.5.0

Database Patch Level: 1.5.0

v1.5.0 [2012-03-20 05:24:28] (Version Update 1.3.9->1.5.0)
v1.3.9h [2012-03-20 05:24:27] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2010-02-25 16:43:13] (Fresh Installation)

PHP Version 5.2.17

Dont know if thats any use to anyone :)

Hi Woody,
Did you use OpenOffice to export your CSV file? Excel does not work well for export CSV files, and they don't import correctly with EP4 - something I'll try to address in the future.
Did you do a Full import, and if so, what were the ouput stats at the bottom?

-chaddro

[woody80uk]

Hi, I just use Microsoft excel and save as csv file as the old EP. I clicked on "Choose file (under Upload EP file)" then chose relevant csv file then clicked upload. I got the counter showing uploading ...% up to 100% at the very bottom of the screen then at the top left the green bar showing "File Uploaded successfully" with the name of the csv file. Any help you can give would be much appreciated. Ive got a huge product list needs uploading, bit like a sitting duck at the mo, dont fancy spending 25 years putting them on 1 by 1 :)

[woody80uk]

I think I may have found the problem, I have downloaded from the site and the layout differs on the EP4 csv than my old EP csv file. There is no option for category_1, category_2, category_3 and so on, on the new one where I need this for my listings. For example, I sell inks so it would be Category_1 = Ink Cartridge, Category_2 = Epson Ink, Category_3 = Epson R285 ink and then on to the product.

New EP4 layout as below:

v_products_model
v_products_image
v_products_name_1
v_products_description_1
v_products_url_1
v_specials_price
v_specials_date_avail
v_specials_expires_date
v_products_price
v_products_weight
v_product_is_call
v_products_sort_order
v_products_quantity_order_min
v_products_quantity_order_units
v_date_avail
v_date_added
v_products_quantity
v_manufacturers_name
v_categories_name_1
v_tax_class_title v_status
v_metatags_products_name_status
v_metatags_title_status
v_metatags_model_status
v_metatags_price_status
v_metatags_title_tagline_status
v_metatags_title_1
v_metatags_keywords_1
v_metatags_description_1

Old EP layout on next page!

[woody80uk]

Old EP layout:


v_products_model
v_products_image
v_products_name_1
v_products_description_1
v_products_url_1
v_specials_price
v_specials_date_avail
v_specials_expires_date
v_products_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_status
v_metatags_model_status
v_metatags_price_status
v_metatags_title_tagline_status
v_metatags_title_1
v_metatags_keywords_1
v_metatags_description_1

[chadderuski]

Ah, you didn't say you were using export from old EP.

First off, you need to use OpenOffice to export your CSV. Read the first couple posts in this thread over carefully. Excel will not work correctly.

Second. You first UPLOAD a file, then IMPORT from the link to the right of the file name.

I go into most all of this in the first several posts. Categories done very differently in EP4 since I have mulit-lingual capable category import.

v_categories_1 is for english .... categories names are concatenated with the ^ (caret) So If you have two categories like Barware -> Scoops, you would enter them like "Barware^Scoops"

I hope that helps.

-chadd

[woody80uk]

Ah, you didn't say you were using export from old EP.

First off, you need to use OpenOffice to export your CSV. Read the first couple posts in this thread over carefully. Excel will not work correctly.

Second. You first UPLOAD a file, then IMPORT from the link to the right of the file name.

I go into most all of this in the first several posts. Categories done very differently in EP4 since I have mulit-lingual capable category import.

v_categories_1 is for english .... categories names are concatenated with the ^ (caret) So If you have two categories like Barware -> Scoops, you would enter them like "Barware^Scoops"

I hope that helps.

-chadd

I have uploaded without open office and it seems fine (Now I have read the instructions on what to do) :) Ive just used Excel 2003 saved as comma delimited csv.

[chadderuski]

I have uploaded without open office and it seems fine (Now I have read the instructions on what to do) :) Ive just used Excel 2003 saved as comma delimited csv.

If you are converting your category columns from EP 1.2.5.4, you can simply add a new column, then use the concatenate function in excel.

Something like this: =concatenate(A34,"^",B34,"^",C34,"^",D34,"^",E34)

Now insert a new column named v_categories_1 and copy the concatenated column, but paste-special and select "values". This will paste the character data.

Now you will combine all your combined categories, but will also give you some doubled ^^ (or more) for the empty column entries. Hilight your v_categories_1 column and do a search for ^^ and replace with ^. I haven't done this for a while, but you may also have to trim the last column.

Now, better than doing the above.... Install EP4 on your old store (you can have both versions installed without issue) and do your export with EP4 and all the problems you are having are pretty much solved

-chadd

[micmed]

First of all I have to say that this mod is awesomely fast and a pleasure to work with. Having said that I am having an issue.

My first attempt at uploading I used the same column format as earlier EP's. All looked good and normal except of course it only created the first category and ignored v_categories_name_2 etc. I reread the notes and this thread and changed to the category1^category2^category3 format. This fixed the categories but now none of my images work. They worked before I changed the categories format and that was the only change I made.

I have tried both OO and Excel with no difference.

[SPH]

Hi Woody,
Did you use OpenOffice to export your CSV file? Excel does not work well for export CSV files, and they don't import correctly with EP4 - something I'll try to address in the future.
Did you do a Full import, and if so, what were the ouput stats at the bottom?

-chaddro

I've been using your EP4 since our email exchange some time ago; using in conjunction with my former EP which allows me to add fields and do attributes the way we're used to. EP4 is my go-to version, especially since it lets me work on specific categories.

Anyway, I haven't had OpenOffice for few years now and have not noticed a problem with excel. Maybe I will?

sph

www.prommart.com
www.fashion-mart.biz

[chadderuski]

I've been using your EP4 since our email exchange some time ago; using in conjunction with my former EP which allows me to add fields and do attributes the way we're used to. EP4 is my go-to version, especially since it lets me work on specific categories.

Anyway, I haven't had OpenOffice for few years now and have not noticed a problem with excel. Maybe I will?

sph

www.prommart.com
www.fashion-mart.biz

That's some good news. Which version of excel are you using and which csv export? I have not had the time to test ALL the versions/platforms to ensure compatibility.