EasyPopulate 4.0 Support Thread

philip937:

is there a way to set the 'display only' etc feilds on the attributes? not a problem if not as they are all the same so I can just run an sql query to do it in bulk. just wondered?

also notice that the sort orders don't adopt my defaults on the attributes, all set to 0?

but that said there is a admin function that can do that somewhere right?

Are you looking to display and explanation for a product's attribute? For example Product Material: Plastic. The plastic part which displays text only can be set and defined by Option Name Manger>Option Type, Read Only? That displays text, for that attribute.

Downloaded Easy Populate CSV
Why would this be happening?
Everything fine but when I try to Upload the EPFile the revised changes back into the admin panel I am getting a time out issue?

Kevin205:

Are you looking to display and explanation for a product's attribute? For example Product Material: Plastic. The plastic part which displays text only can be set and defined by Option Name Manger>Option Type, Read Only? That displays text, for that attribute.

Sorry not sure I follow what's you've said here.

philip937:

Sorry not sure I follow what's you've said here.

What do you mean and what are you trying to display?

philip937:

is there a way to set the 'display only' etc feilds on the attributes?[/COLOR] not a problem if not as they are all the same so I can just run an sql query to do it in bulk. just wondered?

also notice that the sort orders don't adopt my defaults on the attributes, all set to 0?

but that said there is a admin function that can do that somewhere right?

haredo:

Downloaded Easy Populate CSV
Why would this be happening?
Everything fine but when I try to Upload the EPFile the revised changes back into the admin panel I am getting a time out issue?

Can you confirm which version of EP you are using? This thread is for EasyPopulate 4.0 ... which shows in the title and tool pages as 'Easy Populate 4' ...

Chad,
Sorry I posted in the wrong support thread ....

Hello Chad – What is the best way and what do you recommend, when it comes to merging prices for price by attributes?

When you have the following scenario:
Product A is priced by size attribute

Product Name > Size Attribute Name > Size Attribute Price
Product A > Size 1 > $5.00
Product A > Size 2 > $10.00
Product A > Size 3 > $20.00
Product A > Size 4 > $30.00

Obviously you would have to first import all attributes for different products, to table using via ** Basic Products Attributes (basic single-line**), but how do you add / merge prices to Detailed Products Attributes (detailed multi-line) to update their corresponding prices

Is there a method that you use?

While trying to import attribute size, with values similar to 1'-8" x 3'-7", via Attrib-Basic-EP_02_Size_OO.csv, I am getting the following error. Data is prepared in Excel (.xls). I have tried both excel .csv and Open Office .csv. Both produce similar errors. Any ideas?

How else can this formatted?

How many records can be in a .csv file?

I am getting the following errors:

MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" x 3'-7"'' at line 10
When executing:
SELECT
a.products_options_id,
a.products_options_values_id,
b.products_options_values_id,
b.products_options_values_name
FROM zen_products_options_values_to_products_options as a, zen_products_options_values as b
WHERE
a.products_options_id = '1' AND
a.products_options_values_id = b.products_options_values_id AND
b.products_options_values_name = '1'-8" x 3'-7"'
MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" x 3'-7"',
'1')' at line 9
When executing:
INSERT INTO zen_products_options_values
(products_options_values_id,
language_id,
products_options_values_name,
products_options_values_sort_order)
VALUES (
'108',
'1',
'1'-8" x 3'-7"',
'1')
MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" x 3'-7"'' at line 10
When executing:
SELECT
a.products_options_id,
a.products_options_values_id,
b.products_options_values_id,
b.products_options_values_name
FROM zen_products_options_values_to_products_options as a, zen_products_options_values as b
WHERE
a.products_options_id = '1' AND
a.products_options_values_id = b.products_options_values_id AND
b.products_options_values_name = '1'-8" x 3'-7"'
MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" x 3'-7"'' at line 10
When executing:
SELECT
a.products_options_id,
a.products_options_values_id,
b.products_options_values_id,
b.products_options_values_name
FROM zen_products_options_values_to_products_options as a, zen_products_options_values as b
WHERE
a.products_options_id = '1' AND
a.products_options_values_id = b.products_options_values_id AND
b.products_options_values_name = '1'-8" x 3'-7"'

chadderuski:

If you use open office and use: FILE > SAVE AS > Text CSV (.csv)

Open Office will encapsulate it as:

"1'6"" x 1'9"""

You don't need to do anything special.

-chadd

This is how it's saved:
Field delimiter: '
Text delimiter: ""

While importing the following:

v_products_model,v_products_options_type,v_products_options_name_1,v_products_options_values_name_1
1-GREEN-TOM,2,Size:,"1'-8"" x 3'-7"""
1-GREEN-TOM,2,Size:,"2'-3"" x 3'-6"""
1-GREEN-TOM,2,Size:,"2'-3"" x 1'-6"""
1-GREEN-TOM,2,Size:,"3'-11"" x 3'-7"""
1-GREEN-TOM,2,Size:,"1'-3"" x 3'-6"""
1-GREEN-TOM,2,Size:,"4'-7"" x 2'-6"""
1-GREEN-TOM,2,Size:,"3'-10"" x 3'-10"""
1-GREEN-TOM,2,Size:,"3'-6"" x 2'"

I am getting also getting the following warning right after the import on top of the admin page.
Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

Finished Processing Import File

Updated records: 6
New Imported records: 1
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 2855256
Memory Peak: 2911048
Execution Time: 0.1918740272522 seconds.

I look at it the .csv file with "Notepad++", and there are no tabs in the file / records.

1'-8" x 3'-7"

Sorry for multiple posts, I keep on getting kicked out.

I can import without any errors, only if the cell is formatted as shown in my previous post (#971).

But it really looks ugly, when you are adding size attributes to other products through admin, and you are choosing among 100s of similar looking sizes.

ps. I also tried using OO to export the .csv using Unicode (UTF-8) character set. I get the same errors.

Kevin205:

Sorry for multiple posts, I keep on getting kicked out.

I can import without any errors, only if the cell is formatted as shown in my previous post (#971).

But it really looks ugly, when you are adding size attributes to other products through admin, and you are choosing among 100s of similar looking sizes.

ps. I also tried using OO to export the .csv using Unicode (UTF-8) character set. I get the same errors.

Kevin,

I think the problem you are having is that you are not using BASIC single and double quotes, but "smart" quotes.

have you tried setting EP to convert smart quotes to standard quotes?

Also, Excel and be a REAL B**CH about quotes, so you need to look through your preferences to ensure it's NOT using smart quotes.

-chadd

Kevin205:

1'-8" x 3'-7"

Also, when you come across these type of issues, it make ALL the difference in the world when you zip and attached the problem file.

Also, look at how zencart interpreted your character codes in the quote .... these are standard characters... also be sure you have in your EP4 settings to conver chr(92) to standard single quote....

Chad - Thanks for the reply.

How do you distinguish between BASIC single and double quotes and "smart" quotes?

As I mentioned when I look at the .csv in Notepad++, it looks like ' and "" basic to me.

chadderuski:

Also, when you come across these type of issues, it make ALL the difference in the world when you zip and attached the problem file.

Also, look at how zencart interpreted your character codes in the quote .... these are standard characters... also be sure you have in your EP4 settings to conver chr(92) to standard single quote....

I will try your suggestions this evening and will inform you. Thank you.

I sent you a pm.

Kevin205:

1'-8" x 3'-7"

Hey Kevin,
I believe I know what is going on here. Will see if I can fix it without breaking the attribute importing code :p

I'll let you know when I believe I have it working...

-chadd

Kevin,

Attached is a replacement easypopulate_4_attrib.php file. Give this a try.

Note that you should set Configuration -> Easy Populate 4 :: Convert Curly Quotes to 1 - Replace with Basic Characters

I tested your file and it imported correctly. I have not tested the advanced attribute import yet, but this should get you on track.

-chadd

Kevin,

The detailed attribute import should be fine since it does not modify the options_name or options_values_name

That file MAY not work for you. I've been making a lot of changes to EP of late and you may have to wait for me to update github...

-chadd