Re: Including an existing SQL database into the MiniVend concept

[Dan Busarow <dan@dpcsys.com>]

******    message to minivend-users from Dan Busarow <dan@dpcsys.com>     ******

On Fri, 19 Feb 1999, Bjoern Koester wrote:
> I have fully read the database section of the manual and almost
> everything here in the mailing list, but didn't stumble upon a single
> case in which an already existing database was said to be able to be
> re-used for use in MiniVend. I read that MiniVend needs to populate e.g.
> an mysql-based database itself before being able to using it.

I don't recall reading that anywhere.  It's not true, you can use
an existing database.  Maybe you mis-understood a statement that
MV *can* populate a DB for you.  It's a feature you don't need
to use.

> I was wondering if there is anybody out there who has had any experience
> at all including an already existing database into the MiniVend 3.11
> concept without needing to mess around with the database structure. If
> so, I would be glad to hear from your experiences. If not, I'd be
> honored to hear what Mike Heins has to say about it ;-) Anyway, here's
> my situation:

Works just fine.

> Let it be an mysql database from a different online shopping system with
> a field name of the primary key *other* than "code" to be integrated
> into an already set-up and working MiniVend online shopping system using
> a ASCII-based products database. The mysql database would then still be
> managed by the other shopping system administration, but ordering
> products from the two different databases should also be working by
> using one single shopping cart with the already existing MiniVend store.

You want to have a catalog accessing both a flat table database and
an SQL database?  Never tried that but it *should* work.  As long
as you don't name both products :)

Give it a shot and post specific questions if/when you run into a
problem.

Dan
-- 
 Dan Busarow                                                  949 443 4172
 Dana Point Communications, Inc.                            dan@dpcsys.com
 Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD 0C 82

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list