[ic] Problems importing Textfiles

Tobias Henle interchange-users@interchange.redhat.com
Fri Aug 17 08:16:01 2001


Hello,
i was using textfiles for my cat table and now i want to change it into
an pgsql database. i have done everything written in the interchange
documentation but it wont work.
my configfile looks like that:

Database  cat  cat.txt      
Database  cat  DSN          __SQLDSN__
ifdef SQLUSER  
Database  cat  USER         __SQLUSER__
endif 
ifdef SQLPASS  
Database  cat  PASS         __SQLPASS__
endif 
Database  cat  COLUMN_DEF   "code=varchar(20) NOT NULL PRIMARY KEY"
Database  cat  COLUMN_DEF   "sel=varchar(64) DEFAULT '' NOT NULL"
Database  cat  COLUMN_DEF   "name=varchar(64) DEFAULT '' NOT NULL"
Database  cat  COLUMN_DEF   "sort=varchar(4) DEFAULT 'ZZ' NOT NULL"
Database  cat  COLUMN_DEF   "display_type=varchar(128)"
Database  cat  COLUMN_DEF   "link_type=varchar(128)"
Database  cat  COLUMN_DEF   "selector=varchar(128)"

everything works fine (the shop too) but it is not imported to the
database!!! 
it seems like i am to stupid to do it, is there any standart mistake???
i don't know if this matters but the cat tabel dosen't exist in the
interchange database.

sorry but the documentation is not very helpfull with this problem.

thanks

-toby