External: Germplasm template v1.0
- Kristen Lind |
- 8 steps |
- 17 seconds
Skills required
This training module assumes that you know how to create a program and manage that program and users in DeltaBreed. To review previous training modules head to the [main training page](https://scribehow.com/shared/External_v09_Beta_DeltaBreed_Training_Module__ofVnXMjZQce-CFUaDWnc8g)and review System Administration and Program Administration.
Things to remember
**GID:** This is a unique system assigned germplasm identifier for your program. It increases sequentially each time you add germplasm to your program.
**Entry number:** Refers to the order of the germplasm in the single entry that you are importing. You can input those numbers into your document before you upload if you want to add pedigree information of germplasm that isn't already in the system. If you leave entry number blank, the system will assign using sequential numbers for that data import (ie: 1, 2, 3, 4...) based on the row order.
Learning targets
Using the germplasm template is paramount to uploading germplasm into DeltaBreed. In this section, training materials are focused on understanding the following:
- Using the readme, breeding method, and data tabs within the template.
- Required versus optional data to include in order to successfully upload germplasm into DeltaBreed.
Get the template
1
In the "Import Data" screen click on the "germplasm" tab and then the "download the germplasm import template" button. Open the file.
Readme Tab
2
In the template, there are three tabs. In the "Readme" tab, it gives the user the name of the germplasm details that are included in the data tab, their description and whether they are required for successful upload of data into DeltaBreed.
\
\*Note that for an initial germplasm upload, only Germplasm Name, Breeding Method, and Source are required. GID is a system assigned value and will be matched to your germplasm when it is imported.
3
If there is a "yes, if" in the required column, you will need to check the description to see when that specific detail should be included for successful import. \
For germplasm, including the GID is only required if you are appending germplasm details; including adding pedigree information.
More About Germplasm Template Columns
4
GID: Germplasm IDs are auto-incrementing numbers assigned by the system. **Required if appending existing germplasm.**
Name: User defined germplasm name. **Required**
Breeding Method: DeltaBreed has over 60 predefined breeding methods which can be found in the "breeding methods" tab in the readme file. (More on breeding methods below.) **Required**
Source: Free text description of germplasm origin. If there is an external UID present, assumed to be the source associated with the External UID. **Required**
Female Parent GID and Male Parent GID (two separate columns): GIDs are sequential numbers assigned to every database entry. You can find GIDs associated with existing germplasm via Germplasm Management and in Germplasm List export files. To import offspring of existing database entries, you must identify the parent by GID. **These columns are optional and can be added at a later date.**
Entry Number: Entry number refers to the order of germplasm in the import list (1, 2, 3, ...n). If no entry number is specified in the import germplasm list, the database will assign entry number upon import. **Optional**
Female Parent Entry No and Male Parent Entry No: To import offspring with progenitors de novo (not yer in the database), specify the parent by entry number. **Optional**
External UID: Historical or externally managed data can be imported with external UIDs. Upon import all database entries will be assigned UUIDs and GIDs. Once in the system, only UUIDs or GIDs are considered truly unique germplasm identifiers. **Optional**
Synonyms: List of germplasm synonyms separated by semicolons (;). **Optional**
Breeding Methods Tab
5
Breeding Methods is also found on the germplasm template in the second tab.
6
There are many breeding methods that are already predefined in DeltaBreed. However, if your breeding program needs to add a breeding method, that can be done through [program administration](https://scribehow.com/page/External_Program_Administration_v10__KcYMmR1VRD-R6dRTvfFHjA). If you want to upload germplasm using a new breeding method, you must add that to your program before you attempt to upload germplasm using that method in this template. Please note that the new breeding method will not show up on the germplasm template, but you will be able to use either the full name or abbreviation to upload germplasm into DeltaBreed.
For each breeding method, there is an assumed genetic diversity. The breeding method will either be derivative (-), generative (+), or maintenance (0). When filing out the germplasm template, you can use either the BI name or the code in your data set for breeding method.
Data Tab
Before you begin, note that the germplasm template is saved within DeltaBreed with a "text" format and when you download the template from DeltaBreed that format will continue.
This will cause alerts when you use numbers within the template. Do not worry. Ignore the warnings as this text format is the most helpful and accurate way to have the template saved so that Excel does not change the date format in other templates.
7
Entering data for your germplasm is done on the "data" tab which is the third tab in this template.
8
Once in the data tab, you are ready to use the template to organize your germplasm data for upload into DeltaBreed.
Remember that the first time you upload germplasm, you will not include the GIDs because that is a DeltaBreed system assigned value and will be added to your germplasm information once it is uploaded and validated.
\*\*You do need to include the name, breeding method, and source. Any other information is optional to include when uploading.
Breeding Insight recommends adding any known parental and pedigree connections upon the first data import. This can be done during the first upload of germplasm to DeltaBreed by using the entry number of the pedigree connections or can be added through GIDs of parental germplasm already in the system. Both of these processes are discussed in a separate section of this training.
\*For germplasm names, do not use the delimiter "/". This will throw an error upon upload.
For any non-required columns, leave blank. Use of "na", "NA", "-", or other characters will cause an error upon upload in optional columns.
