[ic] how to NOT use products.txt

[Corey Gilmore]

On 30 May 2001, Stefan Hornburg (Racke) wrote:

> Corey Gilmore <cfg@dln.uvm.edu> writes:
>
> > I am going crazy here.  IMO, using products.txt seems like a horrible
> > idea, since I have a mysql database.  Say for instance, the first line
> > of my 'products.txt' file looked like
> >
> > sku	desc	icon	image
> >
> > And i wanted to add a field 'small_icon' between icon and image.
> >
> > How would I do this (easily)?  What I want to do is ditch products.txt so
> > that I can just use mysql, and do
> > alter table products add small_icon varchar(64) after icon;
> > to add a new field.
> >
> > What I can't do, is get interchange to recognize this.
> >
> > in catalog.cfg i did
> > NoImport products
> >
> > I added the appropriate
> > Database  products  COLUMN_DEF   "small_icon=VARCHAR(64)"
> > in products.mysql
> >
> > And I changed
> > Database  products  products.txt __SQLDSN__
> > to
> > Database  products  products.mysql __SQLDSN__
> >
> > in products.mysql
> >
> > I restarted interchange, and all seemed well.  BUT, my new column was
> > still not showing up when I edit a product.
>
> This may have another cause. Can you access the column with
> [item-field small_icon] ?
>

Nope.  No errors in error.log either.