EasyPopulate 4.0 Support Thread

[chadderuski]

How would you properly format and send

1'6" x 1'9"

through EP4? It is used in v_products_options_values_name_1.

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

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

[Kevin205]

1'-8" x 3'-7"

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

[chadderuski]

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]

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]

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

[Kevin205]

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.

[Kevin205]

I sent you a pm.