[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] how to NOT use products.txt
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)
