Easy Populate and Excel data handling

[schoolboy]

You will have problems if you try to embed <script> type components where line breaks are relevant. Better to use standard html referencing in your markup, and to put style declarations and js scripts into their respective files/folders elsewhere.

[swamyg1]

I don't suppose there is any way to add other html in the description field? For example, I want to add a bullet list <ul> with <li>'s... is this even remotely possible?

[schoolboy]

I don't suppose there is any way to add other html in the description field? For example, I want to add a bullet list <ul> with <li>'s... is this even remotely possible?

Most BASIC html tags will work, so <ul><li>...</li></ul> will be OK... written in a single line, eg:

<p><b>Product Features</b></p><ul><li>Child friendly</li><li>Cheap to run</li><li>Highly accurate</li><li>User serviceable</li></ul>

Will result in:

Product Features

• Child friendly
• Cheap to run
• Highly accurate
• User serviceable

[phazei]

I just made a CSV version of Easy Populate which can handle all you're talking about. soft returns and pretty formatting in description boxes will work just fine. I posted it on page 209 of the Easy Populate support thread:
http://www.zen-cart.com/forum/showthread.php?p=665610

[notageek]

I found that I can place song lists into single cells in Excel (cell selected, Format, Alignment, Text Control, Wrap Text, OK; alt-enter to begin new lines within cell).

This only works when each product is listed on a single line for each product entry into Easy Populate, so it is done without carriage returns.

The description includes a list of titles, numbered using the <ol> ordered list HTML command.

When the HTML ordered list did not display numbers on the product screen in the Zen Cart, I tried to fix the code by just editing the individual product, but have been unable to make the numbers show in the cart. However, in the product edit preview, the numbers do show for the ordered list.

On the theory that maybe a new line is needed for the <ol> command, I tried adding carriage returns after and before the <ol> and adding the <br /> after and before, in the product editing screen, without success.

Does someone know how to make the numbers appear in an html ordered list inside a product description, either by a coding process in Excel itself, or once it is in the Zen Cart, through the editing screen?

[notageek]

As I had no replies, I asked the ordered list question above on the forum for the Zencart_Zen template, and received a solution under Post #160 from Clyde Jones.

Rather than being an Excel matter, it turned out to be a CSS code addition to my template's style sheet that was needed, seen here:

http://www.zen-cart.com/forum/showth...767#post920767

Much appreciation goes to Clyde Jones.

Notageek