[ic] how to NOT use products.txt

[Stefan Hornburg Racke]

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] ?

Ciao
        Racke

-- 
Master of Swiss Web 2001: http://www.zweifel.ch/

For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)