Adding DNA Samples into Stockbook

Adding DNA Samples into Stockbook

There are multiple ways of getting your DNA samples into Stockbook.

Option 1. Sample entry via Stockbook Live Entry

Option 1a. Manually typing the samples into Live Entry.

  1. Open Live Entry  

  1. Choose a template you will be using on the day.
  2. Click Start Live Entry


  1. Possibly, your template will not have the required fields to collect DNA data.
    1. To collect DNA data against each animal, follow these steps to edit your data entry template
    2. Select Setup
    3. Select Data Entry Template 

  1. From the Available Options locate DNA
    1. Double click on the DNA field heading, or click the " + " to expand out the sub-options, and use the arrows to move the sub fields (Sample ID and Sample Type) to Selected Options.
    2. Click OK

  1. The template will now show the fields you added.

  1. Click Save Layout to save any changes made.
  2. Now bring the first animal through
    1. Type in the DNA # and choose the Sample Type 
      1. Note: The Sample Type will be remembered by Live Entry once the first animal is saved

    1. Fill in all other relevant data for the session
    2. Click Save (F5)
  1. Locate the Animal in Stockbook
    1. Click on the DNA window link


  1. A new window will appear and you should be able to observe the collected DNA data including
    1. Date of collection
    2. Sample ID
    3. Sample Type 

Option 1b. Using a Barcode Scanner to Collect the Samples into Live Entry.

  1. Open Live Entry  with the barcode scanner connected

  1. Choose a template you will be using on the day.
  2. Click Start Live Entry


  1. Possibly, your template will not have the required fields to collect DNA data.
    1. To collect DNA data against each animal, follow these steps to edit your data entry template
    2. Select Setup
    3. Select Data Entry Template 

  1. From the Available Options locate DNA
    1. Double click on the DNA field heading, or click the " + " to expand out the sub-options, and use the arrows to move the sub fields (Sample ID and Sample Type) to Selected Options.
    2. Click OK

  1. The template will now show the fields you added.

  1. Click Save Layout to save any changes made.
  2. Now bring the first animal through
    1. Scan in the DNA # using the QR code on the end of the TSU or Hair Card and choose the Sample Type 
      1. Note: The Sample Type will be remembered by Live Entry once the first animal is saved

    1. Fill in all other relevant data for the session
    2. Click Save (F5)
  1. Locate the Animal in Stockbook
    1. Click on the DNA window link


  1. A new window will appear and you should be able to observe the collected DNA data including
    1. Date of collection
    2. Sample ID
    3. Sample Type 

Option 2. Master CSV import of DNA samples

This option is in reference to when you purchase animals with DNA samples, or the DNA samples were linked to the animals EID/RFID as a pack from a supplier. 
  1. Open the file with the animal DNA samples.
    1. The File at a minimum should have a link to the animals VID or EID
      2. If the sample is linked to the animal's EID/RFID the sample number should be the EID/RFID without the space.
    2. The columns should contain, the animal ID, Sample ID and Sample Type.

    1. Once you have confirmed the data is in the correct format save the file as a CSV and close the file. 
  1. Open Stockbook
  2. Take a backup of Stockbook
  3. Go to File
  4. Select Import Options
  5. Select Details from Datafile 

  1. In Step 1. Find the file to import using the browse function

  1. Move to Step 3. Choose a Default Obs Date.
    1. We would suggest making the Default Obs Date the same as the date the samples were collected.

  1. In Step 4. line up the data as shown below
    1. Visual ID
      1. Data Type = Life Data
      2. Stockbook Field = ID
    2. Sample ID
      1. Data Type = DNA Samples
      2. Stockbook Field = Sample ID
    3. Sample Type
      1. Data Type = DNA Samples
      2. Stockbook Field = Sample Type

  1. Now click OK
  2. Follow the prompts, if you get errors open the error file and investigate.
    1. If the errors don't make sense, please call Support on 1800 624 688.
  3. Close the import window
  4. Open the Animals screen
  5. Using the Last Import user list, make sure that the DNA samples have been assigned to the DNA 

  1. Select one of the animals 
  2. Click on the DNA window link
    1. A new window will appear and you should be able to observe the collected DNA data including
      1. Date of collection
      2. Sample ID
      3. Sample Type 


    • Related Articles

    • Stockbook® DNA tab

      What is the Stockbook® DNA tab? Each animal in Stockbook® has a DNA tab associated with it. This tab is the central location for all of the DNA data linked to that animal. The DNA data can include sample information, test requests and test ...

    • Adding DNA Samples into Stockbook

      There are multiple ways of getting your DNA samples into Stockbook. Option 1. Sample entry via Stockbook Live Entry Option 1a. Manually typing the samples into Live Entry. Open Live Entry Choose a template you will be using on the day. Click Start ...

    • DNA Cross Reference

      Adding a DNA cross reference to an animal: In addition to all the usual methods of locating animals via the Current Animal Listing, Stockbook also allows another option for you to search for animals by Electronic ID (EID) tag number (either via a ...

    • Submitting a DNA Test Request to your Breed Society or DNA Testing Provider

      Step 1. Select the applicable animals Select the animals in the animal list that you wish to perform the DNA test request for. Step 2 . Select the export criteria. Select File > Export Options > DNA Test Request Form Step 3 . Fill out the form as ...

    • Display DNA Results like Defects or any Custom Data on Animal List and in Animal Details

      Be careful when changing or using these fields . Ensure you do not already have data stored in the field. Renaming the field may cause confusion if there is already some data in it. We also suggest leaving the NLIS/NAIT field exactly as it is because ...