Mailing List Archive

Quoting Superior Sites (mailinglist@superiorsites.net):
> I've just installed interchange with the construct demo and it is running
> fine, but i can't seem to figure out how to clean out the tables. We are
> just using the tab delimited files for now and i've deleted all the
> inventory but i still have stuff showing up under new items and sale items.
> How do i fix this?
>

Edit products/merchandising.txt and remove all but the first line.

--
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>

Friends don't let friends use Outlook. -- Bob Blaylock

This worked on all of the db files except the pricing table. When i try and
delete something from there it refuses to delete them, and when i delete
them from pricing.txt it doesn't seem to make any difference even when i
tell it to apply changes. What is different about this file and how do i
fix it?

Bobby "Nanoburn" Brown, Jr.
bobby@superiorsites.net
sysadmin@superiorsites.net



----- Original Message -----
From: "Mike Heins" <mikeh@minivend.com>
To: <interchange-users@lists.akopia.com>
Sent: Wednesday, January 10, 2001 11:14 AM
Subject: Re: [ic] how to clean out construct?


> Quoting Superior Sites (mailinglist@superiorsites.net):
> > I've just installed interchange with the construct demo and it is
running
> > fine, but i can't seem to figure out how to clean out the tables. We
are
> > just using the tab delimited files for now and i've deleted all the
> > inventory but i still have stuff showing up under new items and sale
items.
> > How do i fix this?
> >
>
> Edit products/merchandising.txt and remove all but the first line.
>
> --
> Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
> phone +1.513.523.7621 fax 7501 <heins@akopia.com>
>
> Friends don't let friends use Outlook. -- Bob Blaylock
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users

On Wed, Jan 10, 2001 at 12:14:55PM -0500, Mike Heins wrote:

> > fine, but i can't seem to figure out how to clean out the tables. We are
>
> Edit products/merchandising.txt and remove all but the first line.

What do you do if you're using MySQL?

2
Regards, /|/|
/ | (MSquared)
--
___________________________________________
M Squared <msquared@digitalwizards.com.au>
Product development
Digital Wizards
http://www.digitalwizards.com.au

On Thu, Jan 11, 2001 at 05:23:45PM +0800, msquared wrote:
> On Wed, Jan 10, 2001 at 12:14:55PM -0500, Mike Heins wrote:
>
> > > fine, but i can't seem to figure out how to clean out the tables. We are
> >
> > Edit products/merchandising.txt and remove all but the first line.
>
> What do you do if you're using MySQL?

Simply remove the products/merchandising.sql file, and restart
the interchange server. This will cause interchange to drop the
merchandising SQL table and recreate it importing the data from the
products/merchandising.txt file. If the .txt file has no data, then the
SQL table will also have no data.


--
-Spencer
spencer@mediabang.com
Please direct all of your YES/NO questions to 8ball@mylamewebsite.com

On Thu, Jan 11, 2001 at 11:45:25AM -0700, Spencer wrote:

> > What do you do if you're using MySQL?
>
> Simply remove the products/merchandising.sql file,

Would it be better to either:

* drop the table using MySQL commands

or:

* at least stop the MySQL server before deleting the .sql file?

Also, what about indices, if you delete the file yourself?


> and restart
> the interchange server. This will cause interchange to drop the
> merchandising SQL table and recreate it importing the data from the
> products/merchandising.txt file. If the .txt file has no data, then the
> SQL table will also have no data.

Cool! Yeah, I'm not particularly familiar with how and where from
Interchange imports its data for the tables when you create a new catalog.

2
Regards, /|/|
/ | (MSquared)
--
___________________________________________
M Squared <msquared@digitalwizards.com.au>
Product development
Digital Wizards
http://www.digitalwizards.com.au