Frequently Asked Questions (FAQs)

Yes. The current version Katmandoo2.2 has been tested on Windows 2000 SP 4 or later, Windows XP and Windows Vista as well.

Yes. Katmandoo can use either MySQL or SQL Server database to store data.

Please contact Katmandoo Team to obtain installation package for Katmandoo using MySQL.

Following software packages are installed by the Katmandoo installation package if they are not already installed in the computer.

• Microsoft .NET Framework 2.0 Service Pack 1 (x86)
• Microsoft Data Access Component 2.8
• DiGGer (dks.dll) (provided with installation package)

SQL Server 2000 Database:

• Please contact Katmandoo team for customised installation package for your SQL Server 2000 database.

MySQL Database:

• MySQL Server 5.1 (Release Candidate)
• Connector/Net 5.1 (contact Katmandoo Team to obtain the version that was used to in Katmandoo) 

SQL Server 2005 Database:

• Please contact Katmandoo Team for customised installation package for your SQL Server 2005 database.
• Important note: If drive (harddisk where Katmandoo database is located) is compressed, then untick "compress contents to save disk space" using [ Properties ] of the .mdf and .ldf file. Please contact Katmandoo Team if you need help.

Please note Microsoft Excel 97 or later should be installed in the computer so that export / import features of Katmandoo can be used. To generate labels, it is recommended to use mail-merge feature of Microsoft Word 2003 or later which is not installaed by the Katmandoo installation package.

Yes. But you need to install "2007 Office System Driver: Data Connectivity Components". Please click [ here ] to download the installation package. Once the file is downloaded to your computer, please run it to install so that you can use Excel 2007 to export/import data.

How to export in Excel 2007?
1. In the Export wizard, click on [ Change Export filename ] button to open Save Dialog box where you can select [ Excel 2007 (for Data Entry)] in [ File Type ].
2. Then click on [ Save] to return to Export Wizard. Then Click on [ Export ].

 Please note that the  extension of the file is "xlsm" ie "Excel 2007 file with Macro enabled".

How to import using an Excel 2007 source file?
1. Select [ Change Source file ] in the Import wizard to open Dialog box where you can select [ Excel 2007 (with Macro) ] or [ Excel 2007 (without Macro) ].
2. Select the file and following normal procedures to import data.

File Name	Description
Katmandoo2.GUI.exe	The main executable file of Katmandoo which is started when clicked in its icon.
Katmandoo2.GUI.exe.config	The configuration file of Katmandoo. This XML based file can be modified to make changes that applies to all the sub-systems of Katmandoo.
Katmandoo2.CommonGUI.dll	The Graphical User Interface for Katmandoo.
Katmandoo2.BE.dll	The data tables that are used in Katmandoo are defined in this component.
Katmandoo2.BF.dll	This component handles security and validation of every data before passing them to Data Access Component.
Katmandoo2.DA.dll	This is the only component that interacts with database server (SQL Server 2000/MSDE or MySQL), Excel and Katmandoo2.EA.exe.
Katmandoo2.EA.exe	This is the only component that interacts with external applications such as DiGGer, MySQL, Statistical Software.
Katmandoo2.GCC.dll	This components provides customised controls (such as datagrid, multi-column combobox etc) to Katmandoo2.CommonGUI.dll.
Katmandoo2.SF.dll	This component contains the utilities that are used in all the components of Katmandoo.
Katmandoo2.UP.dll	This component manage data for the Katmandoo2.CommonGUI.dll only.
dks.dll	DiGGer dll file that is used by Katmandoo2.EA.exe

IT IS STRONGLY RECOMMENDED TO MAKE BACKUP OF ANY DATABASE BEFORE DELETING.

Follow the steps below to delete a SQL Server database (suppose KatmandooDemo):

1. User must detach the database KatmandooDemo from its database server.
2. Then delete the KatmandooDemo.mdf and KatmandooDemo_log.ldf from the database folder (eg C:\Program Files\Katmandoo\Database).

For MySQL, please use MySQL Administrator to delete the database.

Click here for step-by-step instruction.

When user login, Katmandoo quickly checks whether the schema of the selected database (in the Login Form) should be upgraded or not. If it needs to be upgraded, then user must login as [ dba ] with valid password to upgrade schema of the database.. Otherwise you will not be able to login into Katmandoo.

To upgrade another database or to re-run upgrade task on already upgraded database, please click here to find detail instructions.

Comptact all the Katmandoo databases using [ Tools > Database > Compact Database ] to fix this issue.

Setup Forms are used to add a single record using form in Katmandoo where as the import wizards are used to import records from an source file.

Setup Forms can be used to add any data in the database where as Katmandoo has limited import wizards.
For example, system users can not be imported using a source file. The user must be added using the User Setup Form.

You should contact system administrator of Katmandoo to reset your password.

Click here for step-by-step instruction to reset [ dba ] password.

1. Login to Katmandoo using your user name and password.
2. Use [ Tools > Change my Password ] to change password.