Someone who's familiar with miva database

[netking]

Hi,

I have a database of products and I need to find someone who's familiar with transferring / writing sql query for transferring data from our db to the miva database.

I looked over the database schema for miva and it seems to RDBMS so just adding records to the miva products table won't be enough -- we might have to create records in other tables too.

Version: newest

thanks

[Bruce - PhosphorMedia]

Have you checked the Custom Product Fields feature in through the Merchant Admin.

[netking]

Well adding a field is easy enough but adding an entire record is something else especially on a relational database.

[Nerd Boy Inc]

Dear NetKing,

You may not be able to do an exact transfer.

If you can contact me off forum with more information I might be able to point you in the right direction.

[TipPro]

It is definitely possible but inserting records directly into the MM5+ mySQL db has its downside. MM5+ keeps an internal record for insert ids. So if you insert records on your own you will not be incrementing this internal record, which is ok until you try to use MM5+'s API to add a new record. Using MM5+'s API to insert a record will most likely fail since the insert id may already exist in the mySQL DB.

[TipPro]

Just a quick edit to my above post... there is a table called StoreKeys that hold the insert ids. As long as you keep this table updated with the most recent insert ids that you manually inserted into the mySQL table, everything should be ok when using the MM5+ API. *figuring you are also inserting and updating any other related necessary records throughout the db