EasyPopulate 4.0 Support Thread

[fairestcape]

Yes, the one MAJOR drawback in using CSV as the file format for Easy Populate, is the enormous potential for errors when content contains commas or quote marks.

EP version 1.2.5.4 used a TAB-DELIMITED system, which is far, far safer and more reliable than CSV - because TABS are not used anywhere in the formatting of the content.

I do not use EP 4 because it is a huge mission to clean up the content, and I have had too many disasters where a single comma (missed in the clean-up) has caused major damage to the site's product data and configuration.

If EP4 created TAB-DELIMITED files, it would be an excellent module.

[chadderuski]

Yes, the one MAJOR drawback in using CSV as the file format for Easy Populate, is the enormous potential for errors when content contains commas or quote marks.

EP version 1.2.5.4 used a TAB-DELIMITED system, which is far, far safer and more reliable than CSV - because TABS are not used anywhere in the formatting of the content.

I do not use EP 4 because it is a huge mission to clean up the content, and I have had too many disasters where a single comma (missed in the clean-up) has caused major damage to the site's product data and configuration.

If EP4 created TAB-DELIMITED files, it would be an excellent module.

Open Office properly encapsulates commas, tabs, single and double quotes. MS Excell seems to do it's own thing which changes from version to version.

There are some complications with utf-8 data and certain odd characters. This usually results when incorrectly opening files of different encodings, especially certain windows encodings.

[Kevin205]

How would you properly format and send

1'6" x 1'9"

through EP4? It is used in v_products_options_values_name_1.

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

[chadderuski]

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

Kevin, you're encoding should be UTF 8 which should match the encoding of your databases.

If you EXPORT your CSV file from OO with the wrong encoding, then import it into a database of some OTHER encoding, you risk getting a lot of "garbage" character in your descriptions, names, etc.

If you are on Zencart 1.5x, you are using UTF 8 unless you did something custom.

-chadd

[Kevin205]

Kevin, you're encoding should be UTF 8 which should match the encoding of your databases.

If you EXPORT your CSV file from OO with the wrong encoding, then import it into a database of some OTHER encoding, you risk getting a lot of "garbage" character in your descriptions, names, etc.

If you are on Zencart 1.5x, you are using UTF 8 unless you did something custom.

-chadd

Hello Chad - I am using UTF-8.