The tutorial describes how to export trial design for data collection and upload phenotypic example data from four locations based on a CIMMYT maize trial. When this tutorial is complete, the example data in the Breeding Management System is available for statistical analysis.
Export Trial for Data Collection
- Select Export Trial Book from Actions menu under the Data collection option.
384 trial entries associated with empty columns of phenotypic data.
- Choose Excel from the list of file formats compatible with different handheld devices. Set data collection order by plot. (Serpentine order options are only available after a field map has been created.) Select Export and choose a location for the file.
- The export file is a single zipped, or compressed, folder containing four Excel workbooks corresponding to each location. Navigate to the compressed folder and open to view the individual files. Open Performance Trial-1_Aqua Fria.xls.
The observation sheet contains empty cells for data collection on 6 traits. Important: The observation sheet exported from the BMS contains a unique PLOT_ID specific to your trial.
Import Example Measurements
- Download example data collected by CIMMYT breeders at each of the four trial locations.
- Copy the PLOT_ID column from the observation sheet you exported from the BMS. Paste PLOT_ID into the example data files. Repeat for all 4 locations. Observations are matched to the database by PLOT_ID.
- Select Import Measurements from the Actions button dropdown menu to import field observations.
- Browse and select to the pre-formatted location 1 data. Select Import. You must save the trial after the import of each location or subsequent imports will overwrite previous data. Repeat for all 4 locations.
- Confirm that the data has been uploaded by reviewing each location from the dropdown menu.
You will receive an error message if the example data is loaded without correct Plot IDs.
The Integrated Breeding Platform (IBP) is jointly funded by: the Bill and Melinda Gates Foundation, the European Commission, United Kingdom's Department for International Development, CGIAR, the Swiss Agency for Development and Cooperation, and the CGIAR Fund Council. Coordinated by the Generation Challenge Program the Integrated Breeding Platform represents a diverse group of partners; including CGIAR Centers, national agricultural research institutes, and universities.
Maize ?demonstration data was provided by Mike Olsen at CIMMYT International Maize and Wheat Improvement Center. These data have been adapted for training purposes. Any misrepresentation of the raw breeding data is the solely the responsibility of the IBP.
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License?