EasyPopulate 4.0 Support Thread

[Kevin205]

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.

[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?

[philip937]

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.

[Kevin205]

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

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

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?

[chadderuski]

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' ...

[haredo]

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

[Kevin205]

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?

[Kevin205]

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"'

[Kevin205]

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: ""

[Kevin205]

While importing the following:

v_products_model,v_products_options_type,v_products_options_name_1,v_products_op tions_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.