EasyPopulate 4.0 Support Thread

Thanks chadderuski, I'll get with Bluehost and see if they can change that for me.

Mike_B1

Mike_B1:

Thanks chadderuski, I'll get with Bluehost and see if they can change that for me.

Mike_B1

Mike, this isn't a Bluehost issue, it's your local router's DNS server IP's. Do you have Comcast? Did you change your name servers at some point in the past? I was using OpenDNS in the past because it was faster than comcast, but switched to google's when OpenDNS started to have serious issues of late.

-chadd

I'm using Cox. I'll look for another DNS to work from.

Thanks.

Is it possible to have v_products_id included in the export?

Thanks,
Joe

Joe,

It should be possible - see chadderuski's post here:

http://www.zen-cart.com/forum/showpost.php?p=1093839&postcount=47

I've just done this for another field today and it works perfectly.

poetryjoe:

Is it possible to have v_products_id included in the export?

Thanks,
Joe

Hey Joe!

Just keep one thing in mind... while you can do this for exporting the products, there is no logic on the import side for dealing with v_products_id.

-chadd

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 :)

woody80uk:

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

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 :)

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!

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

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

chadderuski:

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

https://www.prommart.com
https://www.fashion-mart.biz

SPH:

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

https://www.prommart.com
https://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.

Thanks Chadd, looks like there is light at the end of the tunnel. This a lot of hair I have just saved from not pulling it out with frustration! Thanks for your help. I noticed the ^ when i checked in the downloaded csv file. Looks like I need to play about with my database a fair bit now its changed. Its a bit of a paiin keep typing ^ for each next category, looks like ill have to add my columns together in excel each with a ^ not as simple and quick for me now im afraid compared to the old version. Thanks for the info it at least will get my new products on the site.

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

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.

woody80uk:

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 :p

-chadd

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.

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.

How did you delete your "bad data" ??? If you did it from within the Admin categories manager, it ALSO deletes all your images requiring your to once again FTP them to your server.

-chadd

chadderuski:

How did you delete your "bad data" ??? If you did it from within the Admin categories manager, it ALSO deletes all your images requiring your to once again FTP them to your server.

Dang, I don't remember that happening before V1.5. Thanks!