Home | Using Katmandoo | Quick Start Guide | How-to | Table of ContentsGlossary | See Also | Collapse All

Configuration

Overview

Katmandoo can be configured by modifying following:

.config File

IMPORTANT NOTE: ONLY THE SYSTEM ADMINISTRATION WITH ADVANCED KNOWLEDGE OF CONFIGURATION FILE SHOULD MAKE THE CHANGES IN THE .CONFIG FILE.
 
Configuration file (Katmandoo.exe.config) is stores setting and configuration information. It is an XML file that is used by the executable file (Katmandoo.exe) to obtain the customisation information. It has following sections:

Shadowing System Column Name

Katmandoo can be customised to shadow System Column using KSCMN (Katmandoo System Column Mapping Name) ie while exporting and importing data, Katmandoo will use the Alias of the System Column prefixed as "KSCMN_".

Use [ Record > Update System Column Alias ] in the System Column Main Form. Then just add an alias with KSCMN_ prefixed (ie to shadow SampleEntryNumber as PlotNo, add KSCMN_PlotNo alias). Then save it.

When you export data, you will see PlotNo as the column heading instead of SampleEntryNumber.

Customising Database structure

DDL Script can be used to safely make following changes in database to customised Katmandoo.
  1. Alternate key for Trial Type can be changed to Trial Type Name + Sub-system Id. Katmandoo is designed to handle this alternate key as well as just Trial Type Name as Alternate Key.

    DROP index dbo.TrialType.AlternateKey
    GO
    CREATE unique index AlternateKey on dbo.TrialType (TrialTypeName, SubSystemId) ON 'PRIMARY'
    GO
  2. Weight column in TrialMean table can be changed to allow Null.

    ALTER table dbo.TrialMean alter column Weight decimal(16, 6) null

See Also