Sample Files

This page contains links to example files that will assist with both learning and getting started using KDSmart and KDXplore. As a resource, you can use these files as templates for replacing with your own data (trials, traits or tags) which can then be imported into KDSmart or KDXplore.

Tip

  • In KDSmart your own terminology may be used to define plot, column and row - See Settings from the KDSmart Home Screen or Menu.
  • From these sample files, choose one most similar to your trial’s organisation, e.g. using col and row, block IDs, sub-plots, etc.
  • The sample files can be used as templates by editing and substituting your own data.
  • To save CSV files you may need to right click the link and choose Save Linked Content As….

Column and Row Trial

This example file contains a Column and Row Trial.

For this type of trial, the combination of column and row is unique for every plot in the trial.

To download KDSXsample1_Normal_Trial_X_Y.csv select the following link:

http://www.kddart.org/public/KDSXsample1_Normal_Trial_X_Y.csv

KDSmart Column and Row Trial Example (select to zoom)

Traits File

To download the traits example file KDSXsample3_wheat-traits.csv select the following link:

http://www.kddart.org/public/KDSXsample3_wheat-traits.csv

Trait attributes that can be loaded in the file are described in the following table:

Trait Attributes - CSV Column Headings and Descriptions
Attribute
(CSV Column Name)
Description
TraitName Must be unique and short for display in the Scoring Screen where space is limited on smaller devices (i.e. phones).
TraitAlias An alternative trait name, useful when the trait name is too long for the screen.
TraitDescription This is an optional longer explanation of the trait to assist in data entry.
TraitDataType

Constrains permitted values of traits. Types available are:

  • CATEGORICAL;
  • DATE;
  • ELAPSED_DAYS;
  • INTEGER:
  • DECIMAL; or
  • TEXT (default).

For more details refer to Trait Data Types in the traits topic.

TraitUnit An arbitrary term for the unit of the trait to assist with what value to enter when scoring (e.g. measurements in millimetres or centimetres).
TraitValidation The validation rule optionally restricts the values being entered. The nature of the rule is dependent upon the selection of data type.
Barcode Used to identify the trait when using a barcode scanner for scoring.

More information about Traits can be found on the Traits help page.

Note

Traits loaded from CSV without a defined datatype will default to TEXT.


Tags File

The following is a tags example file containing a tag and description.

To download the file KDSXsample2_tags.csv select the following link:

http://www.kddart.org/public/KDSXsample2_tags.csv

An additional tags example is provided below Trial Containing Sub-Plot Tags which contains sub-plot data tags.

The following table shows the required and optional headings for a CSV file.

Tag Attributes - CSV Column Headings and Descriptions
Heading Alternatives Mandatory Description
Label TagLabel, Comment Yes Name of the tag e.g. BD for bird damage
Description TagDescription, Desc, CommentDescription Yes Tag description
DatabaseLabelId LabelId, Id No Useful for cross-reference to the originating database


Plot Id Trial

In this example, Plot ID is unique for every plot in the trial. To download the file KDSXsample4_demo_trial_plot_id.csv select the following link:

http://www.kddart.org/public/KDSXsample4_demo_trial_plot_id.csv

KDSmart Plot Id Trial Example (select to zoom)


Block Trial

A Block Trial is where the combination of block, column, row is unique for every plot within the trial. To download the file KDSXsample5_Block_Plots_Right.csv select the following link:

http://www.kddart.org/public/KDSXsample5_Block_Plots_Right.csv

KDSmart Block Trial Example (select to zoom)


Excel Workbook Example Format

If you are creating CSV files for import into KDSmart the following Excel workbook may be useful:

To download the file KDSmart_CSV_Import_Format.xlsx select the following link:

http://www.kddart.org/public/KDSmart_CSV_Import_Format.xlsx


Sub-Plot Data Examples

The following examples illustrate different ways of importing sub-plot data.


Trial With Sub-Plot Data For a Particular Sub-Plot

Trial with sub-plot data for a particular sub-plot.

The first three plots in this example file have values for the trait Plant_Height for sub-plot 2.

To download the file KDSXsample6_Specimen_Value_particular_subplot.csv select the following link:

http://www.kddart.org/public/KDSXsample6_Specimen_Value_particular_subplot.csv


Trial with Sub-Plot Data For a Particular Sub-Plot and Trait Instance

This example file contains the first three plots with values for:

  • The trait Plant_Height: Instances 1 and 2; and
  • Sub-plots 1 and 2.

To download the file KDSXsample7_Specimen_value_particular_subplot_and_instance.csv select the following link:

http://www.kddart.org/public/KDSXsample7_Specimen_value_particular_subplot_and_instance.csv


Trial with Sub-Plot Data For All Sub-Plots

The trial has a number of sub-plots specified by sub-plot count and contains data for every sub-plot. This example file contains the first three plots with values for:

  • The trait Plant_Height: Instances 1 and 2; and
  • All sub-plots.

To download the file KDSXsample8_Specimen_Count_and_data_for_every_subplot.csv select the following link:

http://www.kddart.org/public/KDSXsample8_Specimen_Count_and_data_for_every_subplot.csv


Trial Containing Sub-Plot Tags

This example trial illustrates importing tags to the sub-plot level.

  • This feature is only available from version 3.0.
  • If a new tag is being created with this trial import it will not have a description. If this is an issue, import (i.e. create) the tags first by importing using a tag definition file (see above Tags File).
  • This trial has no traits.
  • To import, at the import window the tags, be sure to select Import As > Trait for Plot for the Tags#1, Tags#2 and Tags#* rows in the import window.

This is a trial example file containing some sub-plot tags:

To download the file KDSXsample9_wheat-with-data.csv select the following link:

http://www.kddart.org/public/KDSXsample9_wheat-with-data.csv