EasyPopulate 4.0 Support Thread

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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