EasyPopulate 4.0 Support Thread

[Dashizna]

how do you import items and have easy populate 4 make the categories for them. it trys to import them and it says
SKIPPED! - Model: 18200 - No category provided for this new product
SKIPPED! - Model: 18201 - No category provided for this new product
SKIPPED! - Model: 18202 - No category provided for this new product
SKIPPED! - Model: 18203 - No category provided for this new product
SKIPPED! - Model: 18204 - No category provided for this new product
SKIPPED! - Model: 18205 - No category provided for this new product
SKIPPED! - Model: 18240 - No category provided for this new product
SKIPPED! - Model: 18241 - No category provided for this new product
SKIPPED! - Model: 18242 - No category provided for this new product
SKIPPED! - Model: 18243 - No category provided for this new product
SKIPPED! - Model: 18244 - No category provided for this new product
SKIPPED! - Model: 18245 - No category provided for this new product
SKIPPED! - Model: 18248 - No category provided for this new product
SKIPPED! - Model: 18249 - No category provided for this new product

please let me know what im doing wrong thanks

[chadderuski]

how do you import items and have easy populate 4 make the categories for them. it trys to import them and it says

SKIPPED! - Model: 18249 - No category provided for this new product

please let me know what im doing wrong thanks

Hi Dashizna,

You should read the first posts in this thread for more detailed info, but you must provide a category name in the v_categories_name_1 column.

This error means you left it blank.

[Dashizna]

Hi Dashizna,

You should read the first posts in this thread for more detailed info, but you must provide a category name in the v_categories_name_1 column.

This error means you left it blank.

haha my bad helps when you have the head line there when you upload the file.

[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.

[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