[ic] options table mysql

[Geoff Sternecker]

On Wednesday 28 May 2003 04:52 am, Kerry Blalock wrote:
> I setup options on about a 100 sku. ver 4.8.5 I needed to correct a word
> in severa of these items, so I downloaded the options.txt file into
> openoffice and made the corrections. I then imported this file back to
> mysql, and lost all but the first color name in the options setup.
> However, the combinations still exist in most and show in the cart.
> 
> Question: Is the above procedure the correct method to make shuch
> corrections?
> When viewing the spreadsheet, I notice that all but the first color is
> sitting in the first column instead of the o_value column. Other pieces of
> information also seem to be offline.
> 
> I have read the options table doc, and searched my ic mail and cannot find
> information on this problem.
> 
> Is there a way to get the information back without editing each sku?


Check your formatting, since you used OpenOffice, you probably lost your tab 
spacing. I often use emacs, or nedit to do the editing. If you do not want to 
do it manually, I would use perl.. 

-- 
Geoff Sternecker