Import Pedigree


Suppose I have the following germplasm to import into my BMS:

Lines 1 and 3 come from the same cross, some of the parents are in the BMS, some are not. I want to import the new lines and connect them to their cross histories, creating the crosses first if necessary.

Import the lines

Use germlasm import in the usual way to import the lines from this template.

Select existing germplasm whenever found. The lines are added and the CROSS string is inserted in the CROSS column.

However the cross string has not been parsed and the entries have unknown pedigree. For example:

Import the Parents

Extract all the unique parents from the CROSS column of the NewLines21 template and add them into a new template:

Import this template:

Three of the lines were found, and the fourth, New1234, was added.

Make the crosses

Create a crossing nursery with the imported parent list.

Make the distinct crosses found in the CROSS column of the NewLine21 import template. There are only two in this exmple.


There is a lot of scope here to use other crossing tools. For example if the parent list is long, and the same prents are used many times then it is more convenient to use a crossing template to establish the required set of crosses. The excel feature VLOOKUP can be used to fill the Female and Male plot numbers in the template.

Update the imported lines with their cross histories

From the Germplasm Manager choose Import germplasm updates from the action menu:

Download the germplasm update template and fill the GID column with the GIDs of the lines from list NewLines21 and the PROGENITOR 1 column with the GIDs of the crosses from list CrossesForNewLines21:

Again there is lots of scope to use VLOOKUP to fill this template from the observations sheets of the exported lists NewLines21 and CrossesForNewLines21.

Selelect Import germplasm updates from the action menu of the germplasm manager again and browse to the above template file:

Click Import. You should get a success message and have the germplasm list filtered to the new lines.

Click on the new lines to see their pedigrees: