Import ET calves

Import ET calves

Animal details can be imported by linking the animal to it's recip dam. It will look for an embryo currently in utero to that recipient.

The CSV file that you will be importing should include the following information:

  • Calf ID/tag
  • Calf Sex
  • Calf Date of Birth (D.O.B.)
  • Recipient Cow (recip)/birthing dam ID
  • Mating type (e.g. ET)

 

To import the information, it will need to be done in 2 steps:

  1. Create animals import.
  2. Add ET info import.

This is because when bringing in mating type, it can only be done for existing animals, not when adding the animals for the first time.

 

Import #1: Create animals import

  1. File > Import Options > Details from Data File
  2. Find and select the CSV file in 'File to import' box
  3. Select a default Obs date (e.g. today's date)
  4. Ensure the 'Add new tags' box is ticked as these will be new animals
  5. Ensure the date format is correct
  6. Match the fields to be imported - should be only animal details:
    1. Tag/ID - Life Data - ID
    2. Sex - Life Data - Sex
    3. D.O.B. - Life Data - Birth Date 
  7. Click OK
  8. Select Yes to confirmation pop-up
  9. Select OK to import complete pop-up

 

To see the animals that were just added/imported:

  • Click Cancel in the import screen
  • Drop down 'Yard Sheets/User List Filter' > Select 'Last Import' 
  • Animals will show up here without ET info (as explained above)

 

Import #2: Add ET info import 

  1. File > Import Options > Details from Data File
  2. Find and select the CSV file in 'File to import' box 
  3. Match the fields to be imported - ID and ET info 
    1. Tag/ID - Life Data - ID
    2. D.O.B. - Date - Observation Date
    3. Recip - Life Data - Recip Dam ID
    4. Mate - Life Data - Mating Type (existing animals) 
  4. Ensure date format is correct to match CSV set-out 
  5. Click OK
  6. Select Yes to confirmation pop-up
  7. Select OK to import complete pop-up

Go in to Last import user list

You may need to refresh this screen.
The ET information should have been added.
Click into an individual animal to check the details have shown up as the image below:



Article #4347

    • Related Articles

    • Adding an ET Calf

      Adding an ET Calf Before adding a new ET animal make sure that you have your ET module set up correctly in Stockbook. For instructions on setting this up please follow this link: Creating an ET program. After your ET module is correctly set up the ET ...

    • Transferring dams and calves in same export

      If someone is trying to export a group of animals to be transferred to another Stockbook, and is getting an error saying the dam eg.0123 is included in this transfer as well. **The dam number below is just an example** Because Stockbook is a ...

    • Importing Embryo Transfer (ET) Data

      Importing ET Data Importing an Embryo Transfer Program Before beginning this process please sync your database and do a local backup as a precaution as this process cannot be undone Please check the CSV file is correctly formatted before attempting ...

    • Creating an ET Program

      Embryo programs consolidate all of the activities associated with a specific embryo recovery - joinings, flushes, freezing and implants. Select the ET Module and Add a new program; Enter Joining Details; Enter Flush Details; Review Embryos. Adding ...

    • Import a CSV File

      Importing a CSV File Importing CSV files allows the user to bring animals and associated data into Stockbook. Before you begin Always take a backup of your Stockbook data before importing CSV files. CSV files can corrupt so it is advisable to create ...