...
From the Germplasm Manager Actions menu, select Import Germplasm. A Germplasm Import form will open and you can download an excel template from that form.
...
The following example shows how to fill a Germplasm Import template with some germplasm information about some new germplasm that is not yet in the database.
Part 1.
...
Names and location
...
Column Effect
A. Entry_NO must be filled with a sequential integer 1,2,3 …
...
H. REFERENCE you can provide text which will be added as a reference new germplasm.
Part 2. Pedigree information and attributes
...
Column Effect
I. CREATION_DATE You can enter the date the germplasm was created, collected or received according to your convention. Format YYYYMMDD.
...
M. You can add attributes for the entries being imported by adding columns with headings obtained from the Passport or Attributes sheets of the Template. If the attribute you want is not there you must add it first through the ontology manager. A column for NOTES has be added by default. Add some notes.
Part 3. – Inventory and unique identifiers
...
Column Effect
N. STORAGE LOCATION ABBR is for the abbreviation of the seed storage location where you will store the seeds associated with this import list. These seed storage location abbreviations are looked up on the Codes sheet. New ones must be entered through the Location Manager.
...
Before Updates
...
After Updates
Before Updates
...
After Updates
Before Updates
...
if the germplasm has inventory
if the germplasm exists in multiple lists
if the germplasm is associated with a nursery or trial
if the germplasm is fixed
if the germplasm has descendants
...
Confirm deletion.
...
The germplasm that was chosen for deletion does not meet the validation criteria. In this case, the germplasm has associated inventory and descendants in the database.
...