MmDbDOC - truXoft Data Doctor and Miva Database Editor
MmDbDOC is a tool for testing and repairing corrupted databases and database indexes. It allows you to remove duplicate records from any Merchant or non-Merchant database quickly and without downloading or importing them, directly through the Miva Merchant Admin web interface. There are three different ways of the duplicate records repair:
- manual selection - you can select which of the duplicate records you keep, and remove the remaining one(s)
- manual editing - you can edit the duplicates so that you keep several or all of them in the database but change the unique identifier field(s) so that the duplicate key in the index is avoided
- fully automated - MmDbDOC will automatically remove all duplicate records from the selected database, keeping always the first found record in the duplicate set
MmDbDOC can be also used for viewing databases. This feature is invaluable for quick database verification, for retrieving data not accessible through Miva Merchant Admin (i.e. customer passwords, module settings, basket data, affiliate data, ...). Please note: We recommend viewing the raw databases containing sensitive data (passwords, email addresses, payment data) in secure mode only (SSL / https).
The PRO version includes a full featured database editor for modifying any Miva Merchant or 3rd party database tables. Fields may be quickly modified without downloading or exporting any data. New records may be added or old ones deleted. You can duplicate whole blocks of records with a simple click and edit them afterwards.
Main Features
| version | DEMO | Standard | PRO |
| Merchant databases | yes | yes | yes |
| 3rd party databases | yes | yes | yes |
| database list | limited | yes | yes |
| database information | yes | yes | yes |
| index expression retrieval | yes | yes | yes |
| dupe locator | yes | yes | yes |
| database browser | limited | yes | yes |
| database viewer | limited | yes | yes |
| manual duplicates repair | no | yes | yes |
| editing duplicate records | no | yes | yes |
| automated repair | no | yes | yes |
| index error parser | no | yes | yes |
| editing records | no | no | yes |
| deleting records | no | no | yes |
| adding/cloning records | no | no | yes |
| database packing | no | no | yes |
Please note: truXoft Ultra Batch is required for the full functionality of the standard or PRO versions. The free version of Ultra Batch that comes with MmDbDOC, allows you to see maximally up to three records at a time.
Support
truXoft offers limited free support within 30 days after the purchase of the module. Issues not included in the free support:
- Information about the structure of Miva Merchant databases
- Information about individual database tables or the database fields
- Information about relations between individual Miva Merchant database tables
- Help with repairing or editing of databases
- Any other issues not directly related to MmDbDOC
Important note: The database editor in the PRO version was designed for advanced users who understand the basic structure of Miva Merchant databases. MmDbDOC allows you to edit the raw data, but makes no verification of the data you added, modified or removed. If multiple tables are in a relation, it is the user who has to insure to edit all related tables appropriately to avoid breaking the cross table links. Unqualified editing of the databases may corrupt the store. We highly recommend backing up the entire domain and store data before removing duplicate records (repair) or before editing the databases. truXoft bears absolutely no liability in case of loss of data, corrupted databases or a broken Miva Merchant store. If any such case should occur, please restore the original data from the backup.
After repairing or editing any database, you have to pack both domain and store data in Admin!
Instructions
Installation instrucitons may be found in the readme.txt included in the distribution package. After registering your license key, in Ultra Batch (Xadmin) screen in the main frame of Miva Merchant Admin, click on the tab "databases", select the mode "database list" and click the OK button. Ultra Batch will show you the list of all pre-defined databases.
If a corrupted database with duplicate records is detected, the "Repair" button appears right in the line of the concerned database. By clicking it, you access the repair interface and see the first found set of duplicate records.
You can either:
- select the record you want to keep (click "KEEP Selected"),
- or edit the records to avoid the duplicate key (edit the fields with light blue background so that the resulting key is different at each record) and click the button "Keep multiple"
- or let MmDbDOC repair the database unattended (click "Automated Repair")
In case of manual repair, as described above in 1) and 2), you have to repeat the operation with each duplicate set individually. Normally, you should use the default mode of Ultra Batch hiding deleted records - select "standard" in the first small dropdown box in the right part of the Ultra Batch control panel. In case you use the mode "all", you'll have to navigate through the duplicate sets with the help of the navigation buttons right below the Ultra Batch control panel.
The navigation buttons can be used also when you want to preview all duplicate sets before starting to repair them. Please note that the filter expression (top left) and pagination (top right) of Ultra Batch have influence on the MmDbDOC output. When low numbers are selected in the pagination in sake of faster page loads, use the navigation buttons to proceed to the next page. It applies also for the database list, not only for the repair and edit interface of MmDbDOC.
Before starting to repair or edit databases with MmDbDOC, it is recommended to put the store into maintenance mode. Use the first button (the lock) in the Ultra Batch panel to close and re-open the store. We also highly recommend to back up the entire Miva Data directory containing the databases, before performing any operation on the data with MmDbDOC.
If you experience a runtime error in the store front or Admin, where the message speaks about a database index, copy the message, and after opening the mode "parse error" in the "databases" tab of Ultra Batch, paste the error into the displayed field. MmDbDOC will look up the databases and launch the repair interface.
In case you need to repair a database not listed, you can select the "3rd party dB" mode and enter the database and index paths manually to start the repair function.
Database viewer (demo and standard versions), or the database editor (PRO version) can be launched by clicking the requested database alias in the database list.
IMPORTANT: after repairing or editing any database, you have to pack both domain and store data in Admin!
Compatibility
- Any UI (MMUI, OUI, KCUI,...)
- Miva Merchant v4.14 or higher
- Miva Empresa v4.07 or higher
- MSIE 6 recommended for the Administration interface of truXoft modules
- Compatibility with OpenXB stores was not yet tested
