EasyPopulate 4.0 Support Thread

[heteromorphic]

The default for product description appears to be "text" which is 65K characters. Unless your descriptions are very long, look for problems in your import file.

The length of most fields are changed in the database.

I changed it in the admin section and it didn't make any difference on what imported. Can you direct me to the paths? Thanks!

[VideoStan]

I changed it in the admin section and it didn't make any difference on what imported. Can you direct me to the paths? Thanks!

I suspect you changed it in the admin -> configuration -> product listing section. That only affects the product listing description, not the individual product display.

I don't think, in any event, that this is an EP issue. I have very long descriptions and have made no description setup changes. I think you may have some code in your upload file that results in cutting it off.

Paste a full one into a product definition through admin. Does that one work?

[heteromorphic]

Yes, I think you are right! Is the import corrupted if quotes are used? (i.e. "word")?

[VideoStan]

Yes, I think you are right! Is the import corrupted if quotes are used? (i.e. "word")?

Download a sample and look at it with a text editor.

The headings are not in quotes, all other fields are. What I suspect is that your description includes quotes other than those around the entire field.

[chadderuski]

Hi All!

First let me say that I'm sorry I haven't responded to any of the recent posts. I haven't been getting my notifications for some reason!

[Serious]

After downloading a fullep spreadsheet I noticed some headings that are new, as compared to previous EP spreadsheets.
v_metatags_products_name_status
v_metatags_title_status
v_metatags_model_status
v_metatags_price_status
v_metatags_title_tagline_status
v_metatags_title_1
v_metatags_keywords_1
v_metatags_description_1


all of the _status fields contained a 0
the remainder were blank

So educate me here. What should the status be for new products that I want to add to my site?
Can I use the v_metatags_title_1, v_metatags_keywords_1, v_metatags_description_1 fields to add metatag info instead of doing it manually through the Admin area?

[chadderuski]

After downloading a fullep spreadsheet I noticed some headings that are new, as compared to previous EP spreadsheets.
v_metatags_products_name_status
v_metatags_title_status
v_metatags_model_status
v_metatags_price_status
v_metatags_title_tagline_status
v_metatags_title_1
v_metatags_keywords_1
v_metatags_description_1


all of the _status fields contained a 0
the remainder were blank

So educate me here. What should the status be for new products that I want to add to my site?
Can I use the v_metatags_title_1, v_metatags_keywords_1, v_metatags_description_1 fields to add metatag info instead of doing it manually through the Admin area?

The _status columns are either 0=off or 1=on and the others are text entries. How you use these is up to you. Configure meta tags for a product from within the admin, then export so you have a template of what to set the status's to.

These column are used to populate your metatag information. I think Phazie was the original contributor of this code.

Not that there is an option in Configuration -> Easy Populate 4 to turn off the meta tag field to reduce your export file size for when you aren't working on meta tags.

-chadd

[Serious]

Another guy having a problem with product descriptions.

I went to Admin/Configuration/All Listings/Display Product Description and changed the value from 150 to 900. No change.

Descriptions still getting cut off.

[chadderuski]

Another guy having a problem with product descriptions.

I went to Admin/Configuration/All Listings/Display Product Description and changed the value from 150 to 900. No change.

Descriptions still getting cut off.

I'm going to need to see the .csv file you are using. Can you attached the portion that you know contains the problem description?

Like I said above, I've only seen this when three is a "funky" character in the product descriptions that breaks the csv layout.
Are you using OpenOffice to export the CSV?

Thanks.

[chadderuski]

Yes, I think you are right! Is the import corrupted if quotes are used? (i.e. "word")?

No, not with normal quotes. HOWEVER, on some UTF-8 systems "Character 0x92" can cause odd problems. You should have under your Configure -> Easy Populate 4 "Convert Character 0x92" set to 1.

I have seen this odd character cause truncating of descriptions. Be sure you are using the correct character set for your store and have support in your database.

Also, if you use Open Office when you export your CSV, you will properly encapsulate your text fields. This will allow you to use double and single quotes in your descriptions, and it will not break the import. Open Office will also let you select your target character encoding on export. Excel won't. Depending on the version of Excel you use, I cannot guarantee what works with what version.

-chadd