Interchange Developer Resource


[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date ][Interchange by thread ]

[ic] Problems importing Textfiles



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
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users


Search for: Match: Format: Sort by: