EasyPopulate 4.0 Support Thread

[jamesjweg]

I have a site running Zencart 1.5.0, I had easypopulate 1.2.5.4 working on it, We wanted some newer features so I installed EP 1.5. Once I got EP 1.5 installed I tried an import and it acted like it ran but was running on a blank file. I tried installing EP 4 and have the same results. When I rolled EP 1.5 back to 1.2.5.4 it just loads a blank page once you click the insert to db button so I went back to 1.5 and 4. I was thinking that I had something wrong import file wise but I created products manually, ran an export with EP 4, deleted the products and imported the same unedited file and had the same results, nothing done and no products created. With both EP 1.5 and EP 4 they have no trouble uploading the file, they just don't import it. I have tried setting the temp folder to 700, 755 and 777 with no change. I am sure I messed up something with the EP 1.5 install, does anyone have an idea what direction I should be looking.

EP 1.5 results


EP 4 results


Thanks, James.

[macnerd]

I have a site running Zencart 1.5.0, I had easypopulate 1.2.5.4 working on it, We wanted some newer features so I installed EP 1.5. Once I got EP 1.5 installed I tried an import and it acted like it ran but was running on a blank file. I tried installing EP 4 and have the same results. When I rolled EP 1.5 back to 1.2.5.4 it just loads a blank page once you click the insert to db button so I went back to 1.5 and 4. I was thinking that I had something wrong import file wise but I created products manually, ran an export with EP 4, deleted the products and imported the same unedited file and had the same results, nothing done and no products created. With both EP 1.5 and EP 4 they have no trouble uploading the file, they just don't import it. I have tried setting the temp folder to 700, 755 and 777 with no change. I am sure I messed up something with the EP 1.5 install, does anyone have an idea what direction I should be looking.

As my brother once said, RTFM!

You have to name the file "Full-EPxxxxxx.csv" or "Attrib-EPxxxx.csv" etc for it to be read to the correct db....

[jamesjweg]

The problem with 1.2.5.4 appears to have been a bad configuration_group_id number in mysql. I manually (via phpmyadmin) pulled ALL of it's entries out of mysql, reinstalled and it works. As for EP 4, I went back and looked at my sample export and realized that the products_model value was missing from the export, it was simply "" but EP did not show an error. When I recreate that now EP 4 reports "No model field in record. This line was not imported" as it should, I have no idea why it was not saying that this morning. This morning it was just reporting like I showed in those screen shots. Ignore my brother's smart-@$$ reply about the file names, I just grabbed the first screen shot I came to when I was posting. Here is one with a correctly named file that was doing the same thing.



I think my other problems with EP 4 might have been due to ignoring the warnings about excel, avoid Micro$ucks, in that case his RTFM comment is valid.

Thanks, James.

[Serious]

On the Admin/tools/ep4 you need to scroll down and find your .csv file and then click on the Import link.

[Serious]

After uploading a new .csv file for some new products I noticed that the metatag symbol on the applicable category pages are still black and not orange (no metatag data).

I've made sure that the v_metatags_products_name_status, v_metatags_title_status, v_metatags_model_status, v_metatags_title_tagline_status fields are all marked as "1".

What am I missing?

[chadderuski]

I think my other problems with EP 4 might have been due to ignoring the warnings about excel, avoid Micro$ucks, in that case his RTFM comment is valid.

Thanks, James.

James,

The big problem with Microsoft Excel is that the different versions 2000 through 2010 all handle csv export "their own way" and on top of that, platforms (win vs mac)
are also different. Also, MS won't let you specify your source data's encoding (say from some supplier) that may be in iso8859-1 but you then need to convert and export as UTF8. Open Office will do this. Open Office will also properly encapsulate your data, not just what it thinks you want encapsulted.

Another stickler is that I am use php's fgetcsv() to read data, and IT has it's own issues... especially when dealing with UTF8 multi-byte languages.

-chadd

[chadderuski]

After uploading a new .csv file for some new products I noticed that the metatag symbol on the applicable category pages are still black and not orange (no metatag data).

I've made sure that the v_metatags_products_name_status, v_metatags_title_status, v_metatags_model_status, v_metatags_title_tagline_status fields are all marked as "1".

What am I missing?

The very best way to ensure that your are creating your metatags correctly is to first complete one properly through the admin, and then export that product. This will help you see the correct mapping.

-chadd

[VBE-1]

If I upload a bunch of random Skus that are not linked to anything via the easypopulate to save time..will it just kick those out as not identified? I have about 23k different skus and am trying to find an easy way to update without doing a lot of excel work. lets say that i am off by about 100-200 products that are not on my site or in zencart what will it do with those skus once i import?

[VideoStan]

If I upload a bunch of random Skus that are not linked to anything via the easypopulate to save time..will it just kick those out as not identified?

"It depends," on whether you do something else that kicks an error - for example, not having a model number. If you have a model number and it matches an item, I assume it will update the sku; if it does not match a model number, it will probably add them as new items.

[sash]

has there been any update to Easy Populate 4.0.19 - Beta 1-28-2012 for uploading attributes ? I have a ton of attributes to put on but can't see a way to do it, over 27.000 attributes is frightning !!!