External entries in Miva tables

Can someone tell me what the underlying database is for Miva, and if I can
add records to the tables directly with other programming languages? For
example, I would like to be able to add new inventory records directly from
another application.

Kelly

Kelly Hamann mailto:[email protected]
Integrated Business Solutions

Phone:(619)462-7797 1#

External entries in Miva tables



Hi Kelly,

By default, the current version uses dbIII tables, with proprietary indices.
Also supported are ODBC connections on Windows as well as Oracle, and in the
upcoming version MySQL (natively). Merchant4 and earlier versions use dbIII,
or, if you use Copernicus OpenXB, MySQL.

Adding, updating or deleting records in dbIII tables from outside is a bit
tricky. Also, dbIII tables don't enforce referential integrity. You can find
various connectors for most languages, however none of them will update the
indices or ensure that connected records are updated accordingly. So you'd
have to look at the Miva docs whether or not the field that you want to
update is indexed and if it has references to other tables.

If this is not the case (like for instance in the description or image
fields in Merchant), you can update the record, for example through MS
Access and the MS dbIII ODBC-driver.

Another solution is to reindex the tables and pack them after your
manipulations, but I frankly don't recommend this at all. Better is to look
for a clean importing routine (for example via a text file), and let the
Miva app do the rest - this will ensure that you don't miss any reference
and that all indices are up-to-date.

In the case of Merchant, it might be useful to write an import module in
Mivascript that then connects to your inventory database - so basically
going the inverted way than what you were planning.

Markus





-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Kelly Hamann
Sent: Friday, April 29, 2005 5:00 PM
To: [email protected]
Subject: [meu] External entries in Miva tables

Can someone tell me what the underlying database is for Miva, and if I can
add records to the tables directly with other programming languages? For
example, I would like to be able to add new inventory records directly from
another application.

Kelly

Kelly Hamann mailto:[email protected]
Integrated Business Solutions

Phone:(619)462-7797 1#

External entries in Miva tables



If you do decide to give it a shot, you'll find some more info here:
<A HREF ="http://www.miva.com/docs/api/">http://www.miva.com/docs/api/</A>

There's a map to the database relationships here, but it's a bit outdated:
<A HREF ="http://www.miva.com/docs/api/MM1090-01_v3.0.pdf">http://www.miva.com/docs/api/MM1090-01_v3.0.pdf</A>

Should give you a good start though.

On 4/29/05, MvMarkus <[email protected]> wrote:
> Hi Kelly,
>=20
> By default, the current version uses dbIII tables, with proprietary indic=
es.
> Also supported are ODBC connections on Windows as well as Oracle, and in =
the
> upcoming version MySQL (natively). Merchant4 and earlier versions use dbI=
II,
> or, if you use Copernicus OpenXB, MySQL.
>=20
> Adding, updating or deleting records in dbIII tables from outside is a bi=
t
> tricky. Also, dbIII tables don't enforce referential integrity. You can f=
ind
> various connectors for most languages, however none of them will update t=
he
> indices or ensure that connected records are updated accordingly. So you'=
d
> have to look at the Miva docs whether or not the field that you want to
> update is indexed and if it has references to other tables.
>=20
> If this is not the case (like for instance in the description or image
> fields in Merchant), you can update the record, for example through MS
> Access and the MS dbIII ODBC-driver.
>=20
> Another solution is to reindex the tables and pack them after your
> manipulations, but I frankly don't recommend this at all. Better is to lo=
ok
> for a clean importing routine (for example via a text file), and let the
> Miva app do the rest - this will ensure that you don't miss any reference
> and that all indices are up-to-date.
>=20
> In the case of Merchant, it might be useful to write an import module in
> Mivascript that then connects to your inventory database - so basically
> going the inverted way than what you were planning.
>=20
> Markus
>=20
>=20
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Kelly Hamann
> Sent: Friday, April 29, 2005 5:00 PM
> To: [email protected]
> Subject: [meu] External entries in Miva tables
>=20
> Can someone tell me what the underlying database is for Miva, and if I ca=
n
> add records to the tables directly with other programming languages? For
> example, I would like to be able to add new inventory records directly fr=
om
> another application.
>=20
> Kelly
>=20
> Kelly Hamann mailto:[email protected]
> Integrated Business Solutions
>=20
> Phone:(619)462-7797 1#
>=20

External entries in Miva tables



The way I'd do this is have your other application export a text file of
the data you want to put into your mivascript database, then make a
small mivascript to do the importing so you don't mess up all your
indexes and dbt (memo field) files.

Kelly Hamann wrote:
> Can someone tell me what the underlying database is for Miva, and if I can
> add records to the tables directly with other programming languages? For
> example, I would like to be able to add new inventory records directly from
> another application.
>
> Kelly
>
> Kelly Hamann mailto:[email protected]
> Integrated Business Solutions
>
> Phone:(619)462-7797 1#
>
>