EasyPopulate 4.0 Support Thread

[Hasher]

hey cj

With downloading the 'Detailed Products Attributes' it seems to have most fields i use.

Im not sure how the zencart database works but in phpmyadmin I can see a table called 'products_attributes_download` which has 3 fields which I do use:

products_attributes_filename - name of media to d/l and sub folder eg /folder_sub/test.zip . This one seems important one your missing

products_attributes_maxdays and products_attributes_maxcount , These normal fill out to defaults in the attributes admin screen but may need to be added if doing thru the database directly


I think its fine doing a separate Product and attributes import file but Im wondering how your going to match Product description and attributes lines . Assign a products ID or match line for line.

Hope this helps :-)

Paul

[chadderuski]

hey cj

With downloading the 'Detailed Products Attributes' it seems to have most fields i use.

Im not sure how the zencart database works but in phpmyadmin I can see a table called 'products_attributes_download` which has 3 fields which I do use:

products_attributes_filename - name of media to d/l and sub folder eg /folder_sub/test.zip . This one seems important one your missing

products_attributes_maxdays and products_attributes_maxcount , These normal fill out to defaults in the attributes admin screen but may need to be added if doing thru the database directly


I think its fine doing a separate Product and attributes import file but Im wondering how your going to match Product description and attributes lines . Assign a products ID or match line for line.

Hope this helps :-)

Paul

Hi,

Please note that the attributes downloads links in EP are what I'm using to examine and understand the data's structure. There is no corresponding import of these fields - yet! Yes, there is ANOTHER table 'products_attributes_download' in addition to the products_attributes, products_options, products_options_names, products_options_type, and products_options_values_to_products_options.

These all work together to do your attributes! Now I'm sure the original designers of the attributes features understood them inside out, but I'm reverse engineering my understanding and their relationships so it's been... complex. Additionally, translating this into a functional way to creating/modify/update at import has been a real challenge. I'm on the right track, but it will take some dedicated time to complete this.

Langer had originally attempted to solve this by including every column for every combination of options names and values. If you had 30 attributes with 5 options each that'd be 150 columns. Not what I considered a practical solution.

My solution drastically simplifies the process. If you look at the sample Attrib-EP.csv file you'll see what I mean. Adding the other columns with be easier once I have the BASIC import <> export working correctly. I need to first make the BASIC export match my import file where the product, attribute type, option name, and option values export on line line.

I don't want to promise a solution date, but I will be working on this!

[Hasher]

Thanks cf , understand what your trying to do now much better :-)

[stepgr]

Hi All,
I have a fresh install of latest version (1,5) on which I've installed EP4. I have imported some products from an oscommerce shop
and I'm trying to move products from one category to another and I get this warning messages in the proccess :

WARNING! - Model: .... - Products name: ".................΄΄" exceeds max. length: 64
SKIPPED! - Model: ..... - Category name: ".................." exceeds max. length: 32

can I change the setting for max length somehow ?

thanks in advance

[stepgr]

on second review it has something to do with utf8 categories and product names because none of the above categories or products exceeds the given length (the category is 22 chars and the size in the database is 32 so the length is not the problem). Perhaps someone expert in php can enlighten us?

[chadderuski]

on second review it has something to do with utf8 categories and product names because none of the above categories or products exceeds the given length (the category is 22 chars and the size in the database is 32 so the length is not the problem). Perhaps someone expert in php can enlighten us?

I have not come across this issue myself and have tested on both 1.5 (UTF8), and 1.39h with/without UTF8. How are you creating your CSV file?

[spid3r1987]

very much appreciate this mod, brilliant

[stepgr]

I have not come across this issue myself and have tested on both 1.5 (UTF8), and 1.39h with/without UTF8. How are you creating your CSV file?

from within EP4 I produce a Complete products (with meta tags) and
then I edit the file in libre office and I only change the category
of some products.

[firstcapitalfirearms]

How do I go about exporting a product in ZC to EP so I can see the fields and such for template. I am new and have no idea.

Thanks
Mark

[DrByte]

Isn't there an "export" link or pulldown right on the front of the EP page in your admin?