[ic] Re-Building products.txt file from MySQL DB

N.E.S.T. Solutions nest_consulting at yahoo.ca
Wed Feb 22 08:49:22 EST 2006

> N.E.S.T. Solutions wrote:
> > Hi list,
> > 
> > I have been forced to re-organize my products table,
> > and I started in MySQL, re-ordering my columns (over 200 of them)
> > 
> > I also re-organized my dbconf/mysql/products.mysql file
> > 
> > My products.txt file is really hard to read/edit cause of the large
> > amount of columns (one item line wraps over 20 lines on the 
> screen). 
> > 
> > Is there a easy way for re-building the products.txt file to
> > match what's in my products table in MySQL?
> Just go into the UI and export the table.
> Bye
> 	Racke

Thanks Racke!

I did stop IC completely before I started the work...

I'm worried that if I start IC with a products.txt file that 
doesn't match the products sql table, will it make a mess when 
it imports the products.txt file?

1)Does it matter the "order" of the columns fields between 
the products.txt file and the products table?

2)Will it import the products.txt file into MySQL if I don't remove 
the products.sql from the %catroot%/products folder?

Thanks again

Martin H.
N.E.S.T. Solutions

More information about the interchange-users mailing list