English
Help
    Help Desk
    Support Knowledge Base
    Get support from a local Hub
    Frequently Asked Questions
     
     
Contact us Log in Create an account
  • About Us
    The Integrated Breeding Platform (IBP) provides access to state-of-the-art tools and services to modernise plant breeding programmes around the world... read more
     

    Vision &
    strategy
     Leadership
         team
      IBP Hubs
    worldwide
     
     Partners &
    contributors
      Funding 
    agencies 

    NEWS & EVENTS
    IBP news
    Funding & fellowships
    Job postings
    Events and courses
    GET INVOLVED
    Citing the IBP
    Promotional toolkit
    Contact us
    Frequently Asked Questions (FAQ) about the IBP
     
  • Breeding Management System
    The Breeding Management System (BMS) is a suite of interconnected software tools specifically designed to help breeders manage their day-to-day activities... read more

    First time? Request a trial access to the BMS

    Release notes

    System Requirements
    User manual
    Renew an expired license
     
    CORE APPLICATIONS
    Product Overview                     y Crop information management
    Nursery & trial management
    Statistical analysis
    INTEGRATING MARKERS
    Genotyping Data Manager
    Integrated Breeding Planner
    Integrated SNP Mining & Utilisation
    Molecular Breeding Design Tool?
    OptiMAS: decision-making
    QTL Analysis? with BreedingView
     
    WORK WITH US
    Licences, services and fees          Get local support
    Frequently Asked Questions (FAQ) about the BMS
     
  • BREEDING Services
    Tap into our vast network of partners and service providers to access quality services, concessionary prices, complementary software tools and more. Our product catalogue offers public access to diagnostic markers and genetic resources... read more
    PARTNER SERVICES
    Order genotyping services from LGC
    More genotyping services
    Phenotyping services
    Location & climate maps
    BMS complementary software
    More third-party software
    Hardware options
    IBP PRODUCTS   
    Crop information & genomics
    Trait-linked markers
    KASPar SNP markers
    Germplasm
     
  • TRAINING
    Find training material and activities for an optimal use of the Breeding Management System:
     
    USER MANUAL TUTORIALSVIDEOS e-learningProfessional courses 
     
    Frequently Asked Questions (FAQ) about training
  • Community Resources
    Find people and resources to help you integrate today's best practices in plant breeding:
    Peer communities
    Forums for more than 10 crops
    and technical spaces for
    BMS users and developers
    Crop resource library
    Crop information & genomics, genetic products, publications 
    and archives
     
    BEST PRACTICES

    Phenotyping

    About this website

Training
  • About us
  • Vision & strategy
  • Leadership      team
  • IBP hubs worldwide
  • Partners & contributors
  • Funding  agencies
  • IBP news
  • Funding & fellowships
  • Job postings
  • Events and courses
  • Citing the IBP
  • Promotional toolkit
  • Contact us
  • Frequently asked questions (FAQ) about the IBP
  • Breeding management system
  • Breeding management system (bms)
  • First time? request a trial access to the bms
  • Release notes
  • System requirements
  • User manual
  • Renew an expired license
  • Product overview
  • Crop information management
  • Nursery & trial management
  • Statistical analysis
  • Integrating markers
  • Genotyping data manager
  • Integrated breeding planner
  • Integrated snp mining & utilisation
  • Molecular breeding design tool
  • Optimas: decision-making
  • Qtl analysis? with breedingview
  • Licences, services and fees
  • Get local support
  • Frequently asked questions (FAQ) about the bms
  • Breeding services
  • Order genotyping services from lgc
  • More genotyping services
  • Phenotyping services
  • Location & climate maps
  • Bms complementary software
  • More third-party software
  • Hardware options
  • Crop information & genomics
  • Trait-linked markers
  • Kaspar snp markers
  • Germplasm
  • Training
  • User manual
  • Tutorials
  • Videos
  • E-learning
  • Professional courses
  • Frequently asked questions (FAQ) about training
  • Community resources
  • Peer communities
  • Crop resource library
  • Phenotyping
  • About this website
Get the BMS Trait-Linked Markers Germplasm

  • ▸ Get Started
    • Introduction
      • Desktop Installation & Login
        • Germplasm & Geneaology
          • Launch BMS
            • File Directories
            • ▸ Breeding Activities
              • Manage Germplasm
                • Manage Inventory
                  • Manage Nurseries
                    • Manage Trials
                      • Make Labels
                        • Make Field Map
                        • ▸ Information Management
                          • Import Germplasm
                            • Group Germplasm
                              • Manage Genotype Data
                                • Browse Studies
                                  • Head to Head Query
                                    • Manage Ontology
                                      • Import Datasets
                                      • ▸ Statistical Analyses
                                        • Install Breeding View
                                          • Single Site Analysis
                                            • Multi-Site Analysis
                                            • ▸ Program Administration
                                              • Manage Program Settings
                                              • e-modules
                                                • How-to videos (BMS Desktop)
                                                  • Professional courses

                                                    Data Import Tool

                                                    BMS 7.0-8.0 Manual

                                                    • Overview
                                                    • Data Import Wizard
                                                      • Map Excel Column Headers to Database Ontology
                                                      • Excel File Format for Import Wizard
                                                    • Import Fieldbook Format
                                                    • Related Materials

                                                    Overview

                                                    The data import tool allows users to upload historical field observations from Excel files into the Breeding Management System. The Data Import Wizard is the most flexible way to import historical data from trials and nurseries.  Importing from Fieldbook formatted Excel files is the simplest way to import, but only useful if you have perfectly formatted BMS v4 generated Fieldbook files. Historic terms need to be mapped to the BMS ontology. Assuming that variables are consistently defined and spelled in historical datasets, the BMS "remembers" past mapping to ease historical data upload.

                                                    Data Import Wizard

                                                    Select the Data Import Wizard, and choose an excel file to import. The rice example (.xls) illustrated here can be replicated within a rice program. See below for file format details. Specify the observation sheet containing the phenotypic data within the Excel file. If the file only has one sheet of data there will be only one observation sheet option.

                                                    Select the appropriate row of column headings and Close.

                                                    Enter a Study Name, Title, and Type. Select Next. Expect to wait a few seconds for initial mapping to complete.

                                                    ?

                                                    Map Excel Column Headers to Database Ontology

                                                    The BMS will attempt to map the Excel sheet column headers to their corresponding database terms. Carefully review mapped selections, highlighted in blue, to ensure that ontology term chosen by the system truly matches the meaning and measurement of the imported data.


                                                    In this example, the BMS has mapped 7 of the 10 columns of data. These 7 will need to be carefully reviewed, and the 3 unmapped columns of data will need to be manually matched to the database ontology.

                                                    Review the details of the suggested matches by selecting the Re-Map icon. Search for alternative matches if the scale or method for the selected match is different than the actual experimental design. Obtain the details of an alternative variable name by highlighting and selecting.



                                                    If the alternative term is an actual match, select Apply Mapping. If a match is not found, select Add a Standard Variable, which takes you to the Ontology Manager.



                                                    If the alternative term is an actual match, select Apply Mapping. The change will be reflected on the main screen. 

                                                    Drag and Drop selected Un-Mapped terms to their appropriate group: Trial Environment, Germplasm Entry, or Variate.


                                                    In this example, the Un-Mapped term, Name, describes germplasm entries and should be included with the Germplasm Entry group on the right. Days to Flower and Height are variates (phenotypic observations).

                                                    Apply mapping to the un-mapped terms by manually searching for the appropriate term.



                                                    Select Save Mapping when mapping is complete or if the user will complete mapping at a later time.



                                                    When mapping is complete, select Confirm Header Mapping.



                                                    Ontology mapping is complete. Import the project data by selecting continue or return to the upload page to add more sheets of data to the trial.



                                                    Select the first row of data and import the observations. The phenotypic observations for this trial are now saved in the program database.

                                                    The phenotypic observations for this trial are now saved in the program database.

                                                    Excel File Format for Import Wizard

                                                    Only one sheet of observation data can be read at a time. Three columns of descriptive data are required to import phenotypic observations: TRIAL_INSTANCE, ENTRY_NO, and GID.  However you will probably also want to include additional descriptive data. If you plan to complete a single site phenotypic analysis you will need to include replication (REP). You will probably also want to import a column of germplasm names that are meaningful to your program to ease the interpretation of results.

                                                    • Trial instance is a numerical identification of an individual experiment within a multisite or multiyear trial. For example, data from a single site or nursery will all have the same trial instance value.
                                                    • Entry number is a digit unique to each entry. For example, a trial containing three replicates of 50 accessions, will have the entry numbers 1-50 replicated three times.
                                                    • GID: Full database integration requires that every germplasm have a GID. Without GIDs, the imported phenotypic data will not relate to phenotypic data outside of this trial or to other database information, like genotype and pedigrees. You must match germplasm to GIDs in the database, possibly necessitating an initial germplasm import.


                                                    This data import sheet (.xls) contains the required entry number and trial instance columns, but also contains additional descriptive information: germplasm name, GID, plot number, and replication. This sheet also contains four columns of phenotypic data: heading date, yield, days to flower, and plant height.

                                                    Import Fieldbook Format

                                                    Excel files exported from BMS v4 nurseries and trials are perfectly formatted for import into the BMS, with the possible exception of germplasm designation and GID. Germplasm must first be matched to or assigned GIDs in the database, possibly necessitating germplasm import.

                                                    • Select a Fieldbook formatted Excel file and Submit.



                                                    Fieldbook file import is complete.  Additional files can be uploaded by returning to the upload page.

                                                    Related Materials

                                                    Maize: Import Trial Data
                                                    Manual: Manage Ontology

                                                    Page published on: October 25, 2016 3:25pm
                                                    Back to top

                                                    You will need to register for a CyVerse account to benefit from the full range of IBP resources: here's why.

                                                      Learn more  |  Take a tour of CyVerse/iPlant

                                                        Publications  |  BMS Tutorials  |  Communities  |  FAQ  |  Privacy Notice

                                                    Intellectual property & trademarks are copyrighted with their respective owners. Login authentication provided by CyVerse.

                                                    Select language:

                                                    English French Chinese

                                                    Download the BMS

                                                    Please log in with your CyVerse username and password:

                                                    Account not found!

                                                    Forgotten your password? Request a Password Reset.

                                                    Don't have login credentials? Obtain a username and password from CyVerse (formerly iPlant Collaborative), our registration management gateway. Learn more about our partnership with CyVerse.

                                                    Language Conflict