EasyPopulate 4.0 Support Thread

HI, my first post here, so if this is covered already please say.
I have an export csv file from Litecommerce, it exposrts category setup separated with slashes, as one field.

in other words, I get one csv field with the categories separated by slashes
topcat1/subcat1/subcat2

rather than the separately delimited category names that easypopulate expects.

if its not already solved, can anyone direct me to the easypopulate code that reads the csv data category fields, so I could possibly
split the incoming litecommerce data format above, with the slashes, into [for instance] the 3 separate fields which easypopulate would expect
for the above example.

i can do php
thanks

hareslade:

HI, my first post here, so if this is covered already please say.
I have an export csv file from Litecommerce, it exposrts category setup separated with slashes, as one field.

in other words, I get one csv field with the categories separated by slashes
topcat1/subcat1/subcat2

rather than the separately delimited category names that easypopulate expects.

if its not already solved, can anyone direct me to the easypopulate code that reads the csv data category fields, so I could possibly
split the incoming litecommerce data format above, with the slashes, into [for instance] the 3 separate fields which easypopulate would expect
for the above example.

i can do php
thanks
Don't know if addressed earlier, but the file in your admin directory ending with import processes the information obtained by the sql query in the functions file found in admin/functions/extra_functions.

May want to create a new file name prefix to process your osfiles and in parallel a new sql query section to handle the situation you have. This way won't break the existing code.

hareslade:

HI, my first post here, so if this is covered already please say.
I have an export csv file from Litecommerce, it exposrts category setup separated with slashes, as one field.

in other words, I get one csv field with the categories separated by slashes
topcat1/subcat1/subcat2

rather than the separately delimited category names that easypopulate expects.

if its not already solved, can anyone direct me to the easypopulate code that reads the csv data category fields, so I could possibly
split the incoming litecommerce data format above, with the slashes, into [for instance] the 3 separate fields which easypopulate would expect
for the above example.

i can do php
thanks

Actually, it would be much easier if you simply did a search/replace on "/" and replaced with "^"

NOTE: My version of EP uses ONE column for the category path. This is a large change from other versions. This was done to support multiple languages.

so: v_categories_name_1 refers to LANGUAGE 1, and v_categories_name_2 refers to LANGUAGE 2, not a subcategory.

Hope that helps.

-chadd

chadderuski:

Actually, it would be much easier if you simply did a search/replace on "/" and replaced with "^"

NOTE: My version of EP uses ONE column for the category path.

-chadd

Thanks chadd and other... thats a relief i can use carets in the csv file then! nice one.

hareslade:

Thanks chadd and other... thats a relief i can use carets in the csv file then! nice one.

Though my contribution may. Have been significantly smaller, hopefully you realize that if you have more than the one file to worry about, that you could implement the swap of the / for ^ in the code on that one field using a new import section. Being partial to ZenCart, not only would that added functionality help others convert to ZenCart, but it would save you from having to remember or make note of what was done to bring the file(s)/filetype(s) into ZenCart. :)
Good luck!

Hi chadd
I've got the ^ separator split now, ep4 imports category correctly, ......but the max length of the ep4 categories field is 32, can I manually make that field longer in the db without messing anything up?

And is there a limitation in your EP4 code otherwise, that limits that categories names total length to 32, before its split?
thanks

hareslade:

Hi chadd
I've got the ^ separator split now, ep4 imports category correctly, ......but the max length of the ep4 categories field is 32, can I manually make that field longer in the db without messing anything up?

thanks

Only answering what I have an answer for: regarding the field length, it is not an EP4 setting, just something that has been made viewable to help the "admin". Regarding modifying the length check the following thread found by a google search:

http://www.zen-cart.com/showthread.php?99351-category-name-max-length

hareslade:

And is there a limitation in your EP4 code otherwise, that limits that categories names total length to 32, before its split?
thanks

If I had my guess based on the flexibility that has been incorporated thus far into EP4, is that if the import programming cuts off data, it would be to the limit of the current database setting and not some arbitrary value, and would be such that each cat^subcat would be such, not the entire string length or it "waits" for the receiving database to perform the chop. Chadd probably can provide that type of info off the top of his head, while I'd have to look into the code to confirm or deny that, though in writing import functionality I don't recall coming across any such limiter.

mc12345678:

If I had my guess based on the flexibility that has been incorporated thus far into EP4, is that if the import programming cuts off data, it would be to the limit of the current database setting and not some arbitrary value, and would be such that each cat^subcat would be such, not the entire string length or it "waits" for the receiving database to perform the chop. Chadd probably can provide that type of info off the top of his head, while I'd have to look into the code to confirm or deny that, though in writing import functionality I don't recall coming across any such limiter.

Btw, I apologize that my response may seem curt or rude, I absolutely had no intention in it being so. I was rereading and thinking about it and could see how it might be interpreted as such.

Btw, congrats on getting the formatting to support the import formatting. That much closer to a totally zen experience. :)

chadd and other !
I am exporting from litecommerce cart, get the csv category string with / instead of ^.
I've successfully modified the code around lines 685 of easypopulate_4_import.php
as
$categories_delimiter = "/"; // add this to configuration variables
// get all defined categories
foreach ($langcode as $key => $lang) {
// iso-8859-1
// $categories_names_array[$lang['id']] = explode($categories_delimiter,$items[$filelayout['v_categories_name_'.$lang['id']]]);
// utf-8 ^
//jph mod separator x2f is / in hex asc
$categories_names_array[$lang['id']] = mb_split('\x2f',$items[$filelayout['v_categories_name_'.$lang['id']]]);

This imports fine now, categories work, now can have the zencart experience with Litecommerce v2.1 data. Hope this helps someone else with an old litecommerce setup, because import into X-cart [their modern version] is a limited option. btw haven't imported more than one product at a time yet into zencart, but I don't foresee any probs. THansk so much for this EP4 version!

hareslade:

Hi chadd
I've got the ^ separator split now, ep4 imports category correctly, ......but the max length of the ep4 categories field is 32, can I manually make that field longer in the db without messing anything up?

And is there a limitation in your EP4 code otherwise, that limits that categories names total length to 32, before its split?
thanks

If you adjust the categories name length via phpMyAdmin and alter the length, EP4 will see that and adjust accordingly.

There is error catching code in EP4 in regards to category name lengths that will prevent a product from being created if a category name exceeds that supported by the database ... not having this would result in bad things :p

-chadd

hareslade:

chadd and other !
I am exporting from litecommerce cart, get the csv category string with / instead of ^.
I've successfully modified the code around lines 685 of easypopulate_4_import.php
as
$categories_delimiter = "/"; // add this to configuration variables
// get all defined categories
foreach ($langcode as $key => $lang) {
// iso-8859-1
// $categories_names_array[$lang['id']] = explode($categories_delimiter,$items[$filelayout['v_categories_name_'.$lang['id']]]);
// utf-8 ^
//jph mod separator x2f is / in hex asc
$categories_names_array[$lang['id']] = mb_split('\x2f',$items[$filelayout['v_categories_name_'.$lang['id']]]);

This imports fine now, categories work, now can have the zencart experience with Litecommerce v2.1 data. Hope this helps someone else with an old litecommerce setup, because import into X-cart [their modern version] is a limited option. btw haven't imported more than one product at a time yet into zencart, but I don't foresee any probs. THansk so much for this EP4 version!

I see you looked at this closely enough to use the hex code for "/" ... as you can see in the code, I had/have plans to make this configurable,
but not easy to ask "new" users for the hex code :p

Hi, please tell me why I have no option to install EP in my admin!!

I don't even know which version of EP I have uploaded. It was at the top of http://www.zen-cart.com/downloads.php?do=file&id=868 page and it says "This is an update to Langers version". I put the tempEP folder in the public html folder and maintained directory structure for the admin files. I also ran the install_sql script in admin. Why do I not see anything in admin please - neither in Tools nor Configuration. Therefore, I have no option to install EP.

help please!

i forgot to say that my zencart version is 1.5

bodkin77:

Hi, please tell me why I have no option to install EP in my admin!!

I don't even know which version of EP I have uploaded. It was at the top of http://www.zen-cart.com/downloads.php?do=file&id=868 page and it says "This is an update to Langers version". I put the tempEP folder in the public html folder and maintained directory structure for the admin files. I also ran the install_sql script in admin. Why do I not see anything in admin please - neither in Tools nor Configuration. Therefore, I have no option to install EP.

help please!

So if you had downloaded the plugin from the URL provided, then the applicable help forum is: http://www.zen-cart.com/showthread.php?34970-Easy-Populate-1-2-5-4-support

That is a different version of Easy Populate than what is covered by this support forum. Assistance on installation of that product (Easy Populate 1.2.5.4) should be directed there.

The version applicable to this forum has not yet been posted to Zen-Cart as it is still relatively a beta (test) product though is planning to post an updated version to Zen-Cart.

Hello, I just installed this and have it up and running, but I downloaded a file so that I could make sure I've added certain attributes to certain items. I noticed that the attribute default order is different than what I set it to in Admin. Can someone explain why or how this works? I have 100s of charms, and I group them by type (sports, animals, food, etc...) I try to set each type to a specific number to making adding in new items easier. For example, my animals are 500, all animal charms are 500 so that they default into the same group but alphabetically. Hope that makes sense, but when I look at file, they are given a specific number not all the same one. Can I keep using the same number for uploading? Thanks!

LilleyPadGifts:

Hello, I just installed this and have it up and running, but I downloaded a file so that I could make sure I've added certain attributes to certain items. I noticed that the attribute default order is different than what I set it to in Admin. Can someone explain why or how this works? I have 100s of charms, and I group them by type (sports, animals, food, etc...) I try to set each type to a specific number to making adding in new items easier. For example, my animals are 500, all animal charms are 500 so that they default into the same group but alphabetically. Hope that makes sense, but when I look at file, they are given a specific number not all the same one. Can I keep using the same number for uploading? Thanks!

If you could give a little more information it would help to answer your question.
Which type of file did you download (Basic product, detlailed product,, basic attribute, detailed attribute, etc.)?
The unique number that you are talking about 500 for animal charms, in what field do you usually type that numberr? (Is it in the modelname, the sort order, etc...)?
In the file you mentioned that there is a different number for each item, if you go to the top of the file for that column, what is the name at the top of the column? (Data field name)
The sort order was mentioned, could you explain the concern more? Is the information listed in your file not sorted in the order desired, is the data not correct to allow sorting, etc?

Regarding this plugin, when downloading a file it provides what is in the database. It does not make new infromation in the downloaded file, so the numbers and other information seen already exists in your database that way. When uploading a new file, some new information is created just like it would be if the item(s) were entered from the admin panel.

Probably the one important part about using this tool for populating the database is that it requires a different model entry for each item otherwise the wrong item may get updated when uploading new information.

I think by answering the above questions more people will be able to help answer your questions. :)

Aack! Some EP4 functionality seem to have pooped out on me!

Earlier today, I used it to upload a group of 10 prods to my site, worked like a charm. I subsequently uploaded "price breaks" for all of the same products, some data failed to go in.

When I originally uploaded the products (successfully), I had inserted a random price of 1. When I inserted the "price break" file, it appeared to go in correctly. My generic prices were all replaced with the correct price. And "v_products_discount_type" (2) appeared to go in because all of the products had the price break chart show up.

However, none of the price break data worked. The price break chart that shows up on the product page is blank.

I took a few shots of my admin page, cobbled them together into a single image so you can see all my settings and the reported result of my import. And I will attach the OpenOffice file so you can see it.

Please... can someone help me to get EP4 back on track?

Thanks,
Mike

+++++++++++
I was unable to attach my OpenOffice file. I don't think it was my file format, so I guess that doesn't matter. But maybe it is my column headers?

Here they are:
v_products_model v_status v_products_price v_products_discount_type v_products_discount_type_from v_discount_qty_1 v_discount_price_1 v_discount_qty_2 v_discount_price_2 v_discount_qty_3 v_discount_price_3

I will answer those questions later because I have since tried to upload a file of products only to receive the "No model field in Record. This line was not imported." when, in fact, I have model numbers in there. I researched it on here, but what someone suggested about copying to a new file only the columns that have info, did not work for me...and most other postings are in regards to a different version of EP. I have followed everything to a T.... and tried multiple times but no luck. HELP!

Bump!

Can somebody please take a look at my post above? If you pm me your paypal email, I'd love to buy you some coffee for helping me out!