Easy populate tutorial

[LRS]

How adept are you with mysql?

Enough to be a danger to myself and all bystanders.

Am I asking for trouble with My Populate CSV?

[kobra]

Well I use navicat
But one must understand the DB indexing or can make a real mess of things

[schoolboy]

I use EP 1.2.5.4 on ZC 1.3.9h and have no problems. I also have content-rich product descriptions - some with a lot of HTML.

I have found that if the TXT file is error-free, then EP works a treat. The big problem is that MS-Excel (and to some extent OpenOffice) do NOT save a spreadsheet as 100% clean unformatted text.

What I now do (that seems to help check the integrity of the TXT file) is:

Create the spreadsheet file in MS-Excel, or OpenOffice.

While still in excel, HIGHLIGHT all data and <ctrl+c> (copy) it.

Then <ctrl+v> (paste) it into a blank file in Emerald Editor (you can use any good Plain Text Editor).

This seems to retain the integrity of the data - even if there are large amounts of HTML in the description field.

One caveat... MS-Excel has a cut-off point with the quantity of text/data in a cell. I generally open my EP files in OpenOffice.