[ic] options table mysql

[Kerry Blalock]

> 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
Used tab, removing the " in bottom box. Same as I did with porducts.txt
which imported ok. Unfortunately, I'm not a programer, so doing it with
perl would get me in more hot water than manual.
I guess I just do not understand how the information is being stored in
the spreadsheet. With the products.txt file, each record is on single
line, while in the options.txt, it seems to generate additional rows for
the added option.