EasyPopulate 4.0 Support Thread

rosrooster:

this is what it says on my admin page
Database Field Lengths
categories_name:10.666666666667
manufacturers_name:10.666666666667
products_model:10.666666666667
products_name:21.333333333333
but on the database the char limits are much higher than that

I am receiving the same error. On the right side it shows:
Installed Languages
1-en: English
Default Language: 1-English
Internal Character Encoding: UTF-8
DB CharSet: DB_CHARSET

Database Field Lengths
categories_name:10.666666666667
manufacturers_name:10.666666666667
products_model:10.666666666667
products_name:21.333333333333

Running Easy Populate 4.0.20 - Beta 5-20-2012
on Zencart 1.3.8

I do not have a easypopulate2.php file as referenced in a previous post.
How can I increase this limit?

thanks!

Bigjohnjps:

I am receiving the same error. On the right side it shows:
Installed Languages
1-en: English
Default Language: 1-English
Internal Character Encoding: UTF-8
DB CharSet: DB_CHARSET

Database Field Lengths
categories_name:10.666666666667
manufacturers_name:10.666666666667
products_model:10.666666666667
products_name:21.333333333333

Running Easy Populate 4.0.20 - Beta 5-20-2012
on Zencart 1.3.8

I do not have a easypopulate2.php file as referenced in a previous post.
How can I increase this limit?

thanks!

"easypopulate2.php" was posted in error. This file does not exist.

Your problem is that your Database Character Set is not defined, i.e. DB_CHARSET
Since you are on zencart 1.38, I'm assuming that your are using collation: latin1_general_ci

Since EP doen't know what character set is correct, it is assuming UTF8, and dividing your field length by 3 (necessary for multi-byte character encoding).

Open easypopulate_4.php and go to about line 126. You'll see a number of variables with "/3" ... just remove this block of code.

I'll work on a better way to check for collation. I believe this was fixed in 1.39, and 1.5 uses UTF8 by default.
You should consider upgrading ... 1.38 is getting QUITE old.

-chadd

My site uses attributes this way.

Width
24
24
25...
Length
30
31
32.......

Will EP 4.0 support this?

larryweiss:

My site uses attributes this way.

Width
24
24
25...
Length
30
31
32.......

Will EP 4.0 support this?

It would help to see an example on your site. But if you can create the Options Name/Options Values in Zencart, you can also with EP4.

I have a problem importing attributes with prices and weights.

Somewhere, a zero is added, like a string, for the price displays as "0$7.50" and the weight is "00.10"

Not sure if it's me or EP atm, but I know I don't have doubled 0's in my weights, and the prices are just weird.
"
Adding the item to the cart will yield the right price, however.

Microchip:

I have a problem importing attributes with prices and weights.
Somewhere, a zero is added, like a string, for the price displays as "0$7.50" and the weight is "00.10"
Not sure if it's me or EP atm, but I know I don't have doubled 0's in my weights, and the prices are just weird.
Adding the item to the cart will yield the right price, however.

It would help if you could attach your Basic and Detailed attribute files so I can see if I can duplicate on my end.

Also, have you tried to edit the attribute in question from within the Admin interface to see what happens after you save?

chadderuski:

It would help if you could attach your Basic and Detailed attribute files so I can see if I can duplicate on my end.

Also, have you tried to edit the attribute in question from within the Admin interface to see what happens after you save?

If you mean editing/saving attributes after import, yes. It didn't seem to change things.

However, I think I figured this out, but it's kinda obscure. In my original attempt, I just copy/pasted the prices and weights from the one set of attributes to all the others that I was adding prices to.

My latest test I copied all attribute data aside from unique data like product ID, etc., and pasted this into the attribute to be changed, and it worked.

If you still want my attribute files, let me know.

Microchip:

If you mean editing/saving attributes after import, yes. It didn't seem to change things.

However, I think I figured this out, but it's kinda obscure. In my original attempt, I just copy/pasted the prices and weights from the one set of attributes to all the others that I was adding prices to.

My latest test I copied all attribute data aside from unique data like product ID, etc., and pasted this into the attribute to be changed, and it worked.

If you still want my attribute files, let me know.

One this that is important to remember!

The BASIC import can be used to CREATE and MODIFY the options names and options values names attached to a specific product.

But the DETAILED is ONLY used to UPDATE a specific products model, option name, options values name combo. This is why those first columns must remain untouched. The _id's are used to find and update that specific combo. Although not very flexible, this works well and is quick.

I am waiting for feedback on what COMMON additional columns would be useful for the BASIC import, but have not received any feedback on that yet.

I hope this clears things up.

chadderuski:

One this that is important to remember!

The BASIC import can be used to CREATE and MODIFY the options names and options values names attached to a specific product.

But the DETAILED is ONLY used to UPDATE a specific products model, option name, options values name combo. This is why those first columns must remain untouched. The _id's are used to find and update that specific combo. Although not very flexible, this works well and is quick.

I am waiting for feedback on what COMMON additional columns would be useful for the BASIC import, but have not received any feedback on that yet.

I hope this clears things up.

In my case, I was updating the price and weight info, the attributes were already created and assigned to products.

hi there i have installed your EP4 as followed on my zen cart v1.5.

it shows in the admin menu - thats fine
it shows importing and exporting files listed - fine
but each time i export "Complete Products (with Metatags)"
and ad new products to the list in the same way as the rest of the products in the table
and import it (saved as a .csv) through open Office

it says it was imported fine (green highlight on top of admin)
but when i look in phpMyAdmin or the zen cart store, its not updated :/

any reasons for this?

kind regards and thank you for developing such a system :)

all the best for future updates/ upgrades

oj226:

it says it was imported fine (green highlight on top of admin)
but when i look in phpMyAdmin or the zen cart store, its not updated :/

any reasons for this?

Please either attach or PM me your data file, or a portion there of.
You are clicking on Import after Uploading the file?

-chadd

Width
24
24
25...
Length
30
31
32.......> chadderuski:

It would help to see an example on your site. But if you can create the Options Name/Options Values in Zencart, you can also with EP4.

Sure. A relevant page is:

http://www.sofabed-mattress dot com/sleeper-sofa-bed-mattresses/premium-sofabedmattress.htm

Announcment: New version 4.0.21 posted to github

https://github.com/chaddro/EasyPopulate-4.0

Fixes in this version:

• products_type on import bug
• admin security error when using admin profiles in v1.5
• new way of checking database collation... to fix mult-byte issues when UTF8 is not used.

Getting close to submitting to zencart team! Thanks again to everyone for testing and your feedback!

-chadd

Hi Chadderuski

Thanks for the great work. I installed the version 4.0.21 and compared with the Easy Populate CSV 1.2.5.7 that I am using. The "custom field", a function in the Easy Populate CSV 1.2.5.7, are very useful. If possible, hope you can add this function to the EP4.

SU35

su35:

Hi Chadderuski

Thanks for the great work. I installed the version 4.0.21 and compared with the Easy Populate CSV 1.2.5.7 that I am using. The "custom field", a function in the Easy Populate CSV 1.2.5.7, are very useful. If possible, hope you can add this function to the EP4.

SU35

I agree I need to add "custom fields" , "Cost" (my cost) and "Warehouse" (where I get the item from) to my spreadsheets in a hidden field but not sure how to do it.

sorry again for so many questions and THANK YOU for the quick responses.

Hi Shopsfm and su35,

I will look into it. However, my version makes adding your own custom fields rather easy. A good "how-to" was posted earlier in this thread. You can add your own fields for the products database in something like 15 minutes work.

I'll see where I am at in my list of to-do's. If 4.0.21 goes well, I'll want to submit to the zencart team and exit beta.
That takes priority. I also need to flesh out the docs... something along the lines of what Schoolboy did for 1.2.5.4.

I appreciate the feed back. Keep it coming!

-chadd

I think I found how to add database custom fields
http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread/page5
http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread/page21
hopefully this works.

shopsfm:

I think I found how to add database custom fields
http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread/page5
http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread/page21
hopefully this works.

Yep, Igi2011 did a great job laying it all out in post 205. Just note that the line numbers have changed.
Also, if you follow the formula and add your fields as a "mod", you will be able to easily patch them into newer releases.

I will look into the custom fields of Easy Populate CSV 1.2.5.7 when time permits. A lot of the current work I've done may actually make that easy to do... we'll see.

-chadd

:frusty:
did not work
followed post 205
Here is what I did.. Trying to impout a hidded field "Cost"

easypopulate_4.php

line 102
$ep_supported_mods['Cost'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_Cost');

easypopulate_4_import.php

line 30
if ($ep_supported_mods['Cost'] == true) { // Cost - chadd
$default_these[] = 'v_products_Cost';
line 322
if ($ep_supported_mods['Cost'] == true) { // Cost- chadd
$sql .= 'p.products_cost as v_products_Cost,';
line 936
if ($ep_supported_mods['Cost'] == true) { // Cost
$query .= "products_Cost = '".addslashes($v_products_Cost)."',";

line 1025
if ($ep_supported_mods['Cost'] == true) { // Cost
$query .= "products_Cost = '".addslashes($v_products_Cost)."',";

easypopulate_4_functions.php

line 79
if ($ep_supported_mods['Cost'] == true) { // Cost
$filelayout[] = 'v_products_Cost';

line 160
if ($ep_supported_mods['Cost'] == true) { // Cost
$filelayout_sql .= 'p.products_Cost as v_products_Cost,';

any help or link to a tutorial would be greatly appriciated.

chadderuski:

One this that is important to remember!

The BASIC import can be used to CREATE and MODIFY the options names and options values names attached to a specific product.

But the DETAILED is ONLY used to UPDATE a specific products model, option name, options values name combo. This is why those first columns must remain untouched. The _id's are used to find and update that specific combo. Although not very flexible, this works well and is quick.

I am waiting for feedback on what COMMON additional columns would be useful for the BASIC import, but have not received any feedback on that yet.

I hope this clears things up.

Chadd,

ZC 1.5, this product:
http://www.webdivision.prommart.com/zencart-demo/index.php?main_page=product_info&cPath=65_66&products_id=191

We think we know how your Basic Attributes work.

But we probably really need the Detailed Attributes sheet to do our V-Lookup thing off of the column headings I mentioned some months ago.

I guess my question is: Can I use the Detailed Attributes sheet to ADD another color to this product? If so, how.

I tried and think that I am stuck on column A...v_products_attributes_id

I tried adding what should be the next number in order, but didn't work.

Thanks.

Steve