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

Export Raw data (Sample Measurement)

Overview

Raw data (Sample measurements) of one or more trials can be exported to different file format and in most cases they are feed to Statistical Analytical Software. The exported files can be also used to enter raw data and then import back into the database.

Pre-requisite

Click here for more information on pre-requisite.

First Page of Export Raw data Wizard

This wizard can be activated from following two forms:

In the Trial Main Form, use [ Record > Raw data > Export Raw data ]
In the Trial Design Main Form, use [ Record > Raw data > Export Raw data ]

It has following options:

Export EXISTING Raw data data ONLY
Export Raw data of ONLY ONE Trial for DATA ENTRY

The first page of the wizard changes as per the selected option (above) but the second page is same for all the options.

Export Raw data of ONLY ONE Trial for DATA ENTRY

Select Export Raw data of ONLY ONE Trial for DATA ENTRY option in the Export Raw data Wizard.

Illustrative snapshot:

Preparing to export Raw data of Only one trial for data entry (Click it to change its size)

Selected option to export Raw data of only one trial for data entry.
Selected trial to export Raw data for data entry.
Selected instance number
- Instance number can be changed as required in the exported file.
Sample Type for which the raw data will be entered.
- It is used only when the raw data of the selected trial/instance number does not have any data.
- Sample Type can be changed as required in the exported file.

Export EXISTING Raw data data ONLY

Pre-requisite: Selected trials must have raw data for at least one trait.

Select Export EXISTING Raw data data ONLY option in the wizard.

Illustrative snapshot:

First page of Export Raw data of one or more trials (Click it to change its size)

Selected option to export EXISTING Raw data of one or more trials.
Selected trials to export Raw data.
Selected instance number to export existing raw data
Tick this option to exclude Operator and Trait Recorded Date from the exported data.
- Read serious warining before choosing this option.
Tick this option to exclude Sample Type from the exported data.
- It is used only when the raw data of the selected trial/instance number does not have any data.
- Read serious warining before choosing this option.
Enter filial generation to export ancestors of the genotypes that are used in the selected trials.

Sample Type

Following message are applicable only when Export EXISTING Raw data data ONLY option is selected in the Export Raw data Wizard.

Export Raw data Warning

Export Raw data Warning

Above message is to warns for the potential misleading data when Operator, Trait Recorded Date and/or Sample Type are excluded from the exported data.

Second Page of Export Raw data Wizard

Illustrative snapshot:

Second page of Export Raw data Wizard to select Trait (Click it to change its size)

Available Traits can be added into the Included Traits list. Click here for help on working with Dual List.
Raw Datas of only the Included Traits are exported. Click here for help on working with Dual List.
- When Export EXISTING Raw data data ONLY option is selected, these are the traits that have Raw data for the selected trials and intance number selected in the first page.
Click it to start Export Wizard to export Raw data using the selected parameters.
Click it to export raw data and genotype (with ancestors as per selected filial generation in first page) into different worksheet of an Excel file.(This option does not allow to select columns to export data).

Cancel Export Raw data Process

When export process is running, caption of the [ Close ] command button is changed to [ Cancel ]. In that stage, you can click on the [ Cancel ] button to cancel the export process and return to the the wizard. User can make any changes as required and the click on [ Start Export Wizard ] without closing the [ Export Raw data Wizard ].

See Also