[ic] Products.txt

Jonathan Clark interchange-users@interchange.redhat.com
Tue Dec 4 04:16:01 2001


> I have a script that writes new products to the products.txt
> automatically.
>
> This file is a TAB delimited file.  To make revisions easier, how
> can I make
> IC read this file with a comma "," or pipe "|" between each value.

You don't say what database you are using. I will assume dbm with its auto
importing.

Have a look at <catroot>/dbconf/default_db/products.dbm - the table
definition file; it looks like this:

Database            products     products.txt      TAB
Database            products     HOT               1
Database            products     INDEX             category:c

Guess where you tell it to be PIPE instead of the default tab delimited. In
addition, see:

http://interchange.redhat.com/cgi-bin/ic/docfly.html?mv_arg=icdatabase03%2e0
2

which is about database definitions. If you are using an alternative
database, there is a similar directory in the dbconf directory corresponding
to your db type.

I would avoid csv unless you can be _absolutely_ sure there are going to be
no commas in your descriptions etc.

have fun.

Jonathan
Webmaint.