Quote Originally Posted by aozhaver View Post
I GOT IT TO WORK!!! partially would require more testing...
IN ONE WORD: OPEN OFFICE!!!! Dont use excel it will NEVER work!!!
Micropoop
One word of warning using OpenOffice. When you export your csv/txt file be sure to "edit filter settings" to ensure you are exporting in the correct character set.
OpenOffice will (from my experience) default to UTF, but most English stores are ISO 8859-1 which I also think is zencart's defaults. This is one of those things that excel likes to botch.

This issue is most evident if you have TM (c) (R) and other symbols in your code (rather than the html equivalents).

Also, OO does a better job at the csv/txt export because it properly encapsulates all data.

-cj