How to: Import Raw Data

Common data must be setup before Sub-system specific data can be import.

This page explains how to use a individual data file to import raw data into Katmandoo.

• Step 1 - Import Trial Type
• Step 2 - Fix Trial Acronym Prefix
• Step 3 - Import Trial
• Step 4 - Import Genotype
• Step 5 - Import Trial Design
• Step 6 - Import Raw Data

Click here to read important note on importing data.

Following table list required columns for each import options:

Import Option	Minimum required columns in the source file
Import Trial Type	TrialTypeName
Import Trial	SiteName, SiteYear, TrialType and TrialNumber OR TrialAcronym
Import Genotype	Crop and Genotype
Import Trial Design	SiteName, SiteYear, TrialType, TrialNumber, Genotype, Replicate, Unit Position OR TrialAcronym, Genotype, Replicate, Unit Position
Import Raw Data	SiteName, SiteYear, TrialType, TrialNumber, Genotype, Unit Position, SampleType, actual Trait Name/s OR TrialAcronym, Genotype, Replicate, Unit Position, SampleType, actual Trait Name/s

Use [ Task > Trial > Raw Data > Manage Trial Type ] to activate the Trial Type Main Form. Then use [ Record > Import > Import Trial Type ] to open the Import Trial Type Wizard.

Illustrative snapshot:

1. Select source file to import trial types.
2. This checkbox must be ticked because the source file has repeated Trial Types and we want import unique trial types only. 
   • In the example table, the "S4 Early" is repeated more than once. When this checkbox is ticked, the import wizard will import unique trial types ("S4 Early") ie it will ignore the duplicates.
3. Map column names used in spreadsheet with column name of the database. Click here for the required columns.

Then Click on [ Preview ]  and Click on [ Save Trial Type... ] to save the previewed trial types into database.

The Trial Acronym Prefix must be unque for each trial type in order to bulk import trial from a source file.

1. Unique Trial Type from the Source file which are saved into database.
2. Unique Trial Acronym Prefix of trial type.

Use [ Task > Trial > Raw Data > Manage Trial and Raw Data ] to activate trial navigator.

• Load trial navigator 
• Click on a node in the navigator to load Trial Main Form. 
• Then use [ Record > Import > Import Trial ] to open the Import Trial Wizard.

Illustrative snapshot:

1. Select [ Import Trials ] option (if not selected).
2. Select source file to import trials.
3. This checkbox should be ticked if the source file has repeated Trials and you want to import unique trials only. 
4. Map column names used in spreadsheet with column name of the database. Click here for the required columns.

Then Click on [ Preview ]  and Click on [ Save Trial... ] to save the previewed trials into database.

Following default values are used for the missing data:

Trial Start Date	1/1/SiteYear (eg 1/1/2000)
Trial End Date	31/12/SiteYear (eg 31/12/2000)
Trial Manager	Unknown
Design Type	Unknown
Site Manager (owner)	Unknown

Click here for steps to import genotypes.

Use [ Task > Trial > Raw Data > Manage Trial and Raw Data ] to activate trial navigator.

• Load trial navigator 
• Click on a node in the navigator to load Trial Main Form. 
• Then use [ Record > Import > Import Trial Design ] to open the Import Trial Design Wizard.

Use [ Task > Trial > Raw Data > Manage Trial, Operation and Raw Data ] to activate trial navigator.

• Load trial navigator 
• Click on a node in the navigator to load Trial Main Form. 
• Then use [ Record > Import > Import Raw Data ] to open the Import Raw Data Wizard.