Importing DNA Results

Importing DNA Results

Once DNA results have been received they can be imported to Stockbook and stored in the DNA table.

1. Importing DNA results for Parent Verification

Download the .csv file and save it to the computer

There are a few checks to follow before importing DNA results for Parent Verification to Stockbook.
  1. Ensure all Animal Society Identifications (ID's) are in Stockbook as per the DNA results file
  2. Ensure all Sire Society Id's are in Stockbook as per the DNA results file
  3. Ensure all Dam Society Id's are in Stockbook as per the DNA results file
To ensure all society ID's are correct for the Animals tested and the respective sires and dams;
  1. Go to File > Import Options > Details from Data File 
      

  1. The observation date can be today's date in this instance.
  2. To check the Animal Id's are correct align the the Data Type to Society Details and the Stockbook Field to Society ID with the Animal ID and click OK.
  3. Make corrections to ID's if any errors occur.
      
  1. Repeat the same process for the Sire Id.
      
  1. Repeat the same process for the Dam ID.
      

Now that all the animals and their respective society ID's are correct in Stockbook, the DNA results can be imported. 
The Import is a 2 step process
  1. Go to File > Import Options > Details from Data File 
  2. Select the file
  3. The observation date will be the date the results are received

Step 1.     Importing the DNA results for Parent Verification to the main animal screen 

When Importing the results to the main animal screen, the data types and stockbook fields will be as per the following image:- 



Step 2.      Importing the DNA results for Parent Verification to the DNA table

When importing the DNA results to the DNA table, the data types and stockbook fields will be as per the following image:- 



2. Importing the DNA genetic test results

Download the .csv file and save it to the computer

There are a few checks to follow before importing DNA results for Parent Verification to Stockbook.
  1. Ensure all Animal Society Identifications (ID's) are in Stockbook as per the DNA results file
To ensure all society ID's are correct for the Animals tested ;
  1. Go to File > Import Options > Details from Data File 
      

  1. The observation date can be today's date in this instance.
  2. To check the Animal Id's are correct align the the Data Type to Society Details and the Stockbook Field to Society ID with the Animal ID and click OK.
  3. Make corrections to ID's if any errors occur.
      
           
Now that all the animals and their respective society ID's are correct in Stockbook, the DNA genetic test results can be imported. 
The Import is a 2 step process
  1. Go to File > Import Options > Details from Data File 
  2. Select the file
  3. The observation date will be the date the results are received

 1.     Importing the DNA results for Genetic test to the DNA table 

When Importing the DNA results for genetic tests link the data types and stockbook fields as per the following image:-