KonaKart includes a data integrity checking utility that can be used to check and optionally repair your data. The data integrity checker can be called directly using the KonaKart Admin API or indirectly by using one of the scripts provided.
The KonaKart data integrity checker is designed to be extended over time but currently covers the checking of Customer Groups, Order Status, Miscellaneous Items, Product, Manufacturer and Category Data Integrity only.
The KonaKart data shouldn't become corrupted under normal usage but if data is added to the KonaKart database through channels that don't preserve the integrity (such as via SQL commands) the database can lose its integrity. The purpose of the Data Integrity Checking utilities is to fix the data to restore it to a form that KonaKart can use. A common example of when the KonaKart database loses integrity is when languages are added to the system but records are not added for those languages to all KonaKart objects that must have a row for each language (for example for Order Status Names and Products).
The scripts are provided in the Business and Enterprise Editions of KonaKart.
Open a command shell in the utils/dataIntegrity directory that can be found immediately under your KonaKart installation directory. You can find out the arguments that are required for running the utility by entering a "-?" as your argument as follows:
C:\KonaKart\utils\dataIntegrity>checkDataIntegrity.bat -?
==================================================================================================
Check the Integrity of the KonaKart Database
==================================================================================================
Usage: DataIntegrityChecker
-a n - data area where n is:
0 = All
1 = Customer Groups
2 = Order Statuses
3 = Misc Item Types
4 = Products
5 = Categories
6 = Manufacturers
7 = Tags
8 = Tag Groups
9 = Content
10 = Content Types
-u username - username
-p password - password
[-s storeId] - storeId
[-r] - attempt repair - default is false
[-e (0|1|2)] - engine mode
[-c] - shared customers - default is not shared
[-ps] - shared products - default is not shared
[-cs] - shared categories - default is not shared
[-ae adminengine classname] - default is com.konakartadmin.bl.KKAdmin
[-cu custom] - custom option for DI Checker
[-?] - shows this usage information
To run the data integrity checker just to check the integrity of the data, but not attempt to fix it, run it without the "-r" parameter. For example (lines have been broken up to show the output more clearly):
C:\KonaKart\utils\dataIntegrity>
checkDataIntegrity.bat -a 1 -u admin@konakart.com -p princess -e 2
==================================================================================================
Check the Integrity of the KonaKart Database
==================================================================================================
11-Sep 10:48:56 WARN (AdminDataIntegrityMgr.java:checkCustomerGroups:142)
CustomerGroup record missing for Retail pt (id 1) language 5
To run the data integrity checker and attempt to fix any data integrity problems that are discovered, run it with the "-r" parameter. For example (lines have been broken up to show the output more clearly):
C:\KonaKart\utils\dataIntegrity>
checkDataIntegrity.bat -a 1 -u admin@konakart.com -p princess -e 2 -r
==================================================================================================
Check the Integrity of the KonaKart Database
==================================================================================================
11-Sep 10:51:46 WARN (AdminDataIntegrityMgr.java:checkCustomerGroups:142)
CustomerGroup record missing for Retail pt (id 1) language 5
11-Sep 10:51:46 WARN (AdminDataIntegrityMgr.java:checkCustomerGroups:155)
CustomerGroup record added for: Retail pt (id 1) language 5