Import Trial Design

This option is identical to Import Trial Design of Only One Trial but it allows to bulk import trial design of one or more trials at once. This option is useful to bulk import trial design of more than one trial (specially historical data) and to import trial design for composite samples.

This option does not validate trial design of the trials using their trial design parameters.

Since this options is comparatively slower, Import Trial Design of Only One Trial is recommended.

• Select Import Trial Design of ONLY ONE Trial option in the Import Trial Design Wizard.
• Click here for an illustration of basic Import Wizard.

Illustrative snapshot:

1. If the source file has TrialAcronym column name, then Katmandoo ignore the SiteName + SiteYear + TrialTypeName + TrialNumber columns
2. If the source file does not have TrialAcronym column name then these column names are used to find trial in the database.
3. Unit Position Virtual Columns
4. Treatment Virtual Columns
5. Selected worksheet of the source file that contains the trial design.
6. Tick it if the Selected worksheet of the source file has raw data as well.
7. Tick it to generate unit positions using Unit Position Virtual Columns.
8. Tick it to generate treatments using Treatment Virtual Columns.
9. Click it to select the file generated by DiGGer
10. Genotype Name. Click here for more information on finding matching genotype name.

• Select Import Trial Design using DiGGer output file option in the Import Trial Design Wizard.

Important Note: The column names that are used by DiGGer must be mapped with the column/virtual column name using alias in order to use DiGGer output file to import trial design. Click here for more information.   Click here for an illustration of basic Import Wizard.

Illustrative snapshot:

1. When Import Trial Design using DiGGer output option is selected, the import wizard is initialised to import trial design using DiGGer output file.
2. Click it to select the file generated by DiGGer
3. Tick it to save treatment while importing trial design. Treatment Virtual Column must exist before any treatment can be saved into database.
4. Tick it to save Unit Position while importing trial design. Unit Position Virtual Column must exist before any unit position can be saved into database.
5. When the source file is selected, the columns that are in the source file are mapped with the columns in the database.

How does the import process work?

• It uses file name to find Trial since the file name is the trial acronym.
• Prefix DiGGer_ with the column name (eg ID, ENTRY etc) to find matching Column Alias or Virtual Column Alias.
• Once the alias is found, it can then map the column name of DiGGer output file with the column name used in the database.
• It uses the virtual columns to generate unit positions and treatments and save them if they already do not exist.
• It uses Genotype name only to find genotypes but if database has two genotype names with different Genus +/- Selection history then the file must be modified so that each genotypes are uniquely identified.

Import wizard finds Genotype Name in following  order:

1. If Genus Name, Selection History and Genotype Name columns are available in the source file, then it uses those columns to find genotype in the database.
2. If Genus Name and Genotype Name columns are available in the source file, then it uses those columns to find genotype in the database.
3. If Genotype Name is the only column available in the source file, then it uses the column to find genotype in the database.

For case 2 and 3, its possible that there are more than one matched records in the database. In that case, the source must be modified to provide additional information to uniquely identifies each genotype.

In case the genotype is not found using the above 1, 2 and 3 steps, Katmandoo then uses Genotype Alias to find genotype name.

If the genotype is not found then the importing process is terminated asking user to enter the genotype in the database.