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

Import Raw data (Sample Measurement)

Overview

Raw data (Sample measurements) are imported from the source file into database using the Import Raw data Wizard.

Click here to import raw data using output file generated by KollecTrait.

Important Note:

Pre-requisite

Click here for more information on pre-requisite and following are the additional requirements.

First Page of Import Raw data Wizard

This wizard can be activated from following two forms: It has following options:
The first page of the import wizard changes as per the selected option (above) but the second page is same for all the options.

Note: Click here to import raw data using output file generated by KollecTrait.

Import NEW Raw data ONLY of one or more trials

Illustrative snapshot:
First page of Import Raw data of one or more trials (Click it to change its size)
  1. Selected option to import new raw data of one or more trials.
  2. If Excel file is selected, then select worksheet of the source file that contains the trial design with raw data.
  3. On this selected option (1), the import wizard can import raw data for only one Sample Type which must be selected before the import process can starts.
  4. Trait Name suffixed with Trait Instance Number (Grain_Yield_Raw is the trait and 1 is the instance number in the snapshot).
  5. Mapped Trait Name used in the database
  6. Instance number separated from trait name

Import Raw data of ONLY ONE Trial

Illustrative snapshot:
First page of Import Raw data of only one trial (Click it to change its size)
  1. Selected option to import raw data of ONLY ONE Trial.
  2. If Excel file is selected, then select worksheet of the source file that contains the trial design with raw data.
  3. If the source file is being used to update existing raw data in the database, then tick this option.
  4. If the source file has only new raw data, then tick this option.
  5. Sample Type column in the source file (one of the pre-requisite).
  6. Since the Instance number is suffixed with trait name (5), Instance number is mapped (7) in the Trait Name Mapping datagrid. So, even when the Instance number is mapped in Column Name mapping datagrid, the mapping will be removed before the  import process starts. Click here for the Instance Number Message.
  7. Trait Name suffixed with Trait Instance Number (Grain_Yield_Raw is the trait and 1 is the instance number in the snapshot).

Message

Instance Number

Instance Number Message - Import Raw data

Sample Type

Following message are applicable only when Import NEW Raw data ONLY of one or more trials option is selected in the Import Raw data Wizard.

Sample Type Message - Import Raw data

Sample Type Alert - Import Raw data

Second (Preview) Page of Import Raw data Wizard

The default order of columns displayed can be changed by editing the column list of the Misc Group TrialUnitSetupDataGrid.
Illustrative snapshot:
Second (Preview) page of Import Raw data Wizard (Click it to change its size)
  1. SourceFileRowIndex: Use it to find the row in the source file.
  2. Raw data (4) is displayed for this selected row.
  3. Unit Position Text: Though the design factors are displayed in a single column, it will be splitted into columns when exporting data.
  4. Raw data is displayed for the selected row (2) in the preview datagrid.

See Also