Importing Embryo Transfer (ET) Data

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 the import.  For information on how to do this please follow the below steps:

Step 1. Sorting the Spreadsheet

The whole Spreadsheet needs to be sorted by;
  1. DONOR DAM. 
  2. SIRE

Step 2. Add two columns to Spreadsheet

Two columns need to be inserted titled Embryo ID and No. of Embryo’s
  1. In the No. of Embryo’s column enter the value 1 in each row
  2. Create an Embryo ID Associated with the ET program name
    1. Program name eg. XXXX
    2. Embryo ID made up of PROGRAMNAME_DONORDAM.EMBRYO#(Start at 01)
                                    eg. XXXX_A12.01
                                          XXXX_A12.02

Step 3. Save the CSV file and close

Step 4. Go into Stockbook and create the ET Program eg. XXXX

  1. Select the date - Generally the flush date
  2. Do you want to add details for this program now? select No

Step 5. Go to Import options > Details from data file > Select File       

  1. Check that the RECIP cows are on file
  2. Check that the DONOR DAMS are on file
  3. Check that the SIRES are on file
  4. Once all Animals are on file you can proceed with the first import.

First import is setting up the Flush Details 

  1. Import details from Data File > Select CSV file 
  2. Dam will be ET flush – Donor 
  3. Sire will be ET flush – Sire 
  4. No. Embryos  will be ET flush – No. Frozen 
  5. Go to ET details Tab in the import and select ET program or create if not already created and check the Auto Create Embryo ID box 
  6. Enter default observation date - Flush Date
  7. Proceed with Import 
  8. Go to ET module within Stockbook and Check the details have come through and the status should be FROZEN.

Second import is setting up the Transfer Details

  1. Import details from Data File > Select CSV File 
  2. Recipient Dam will be ET Transfer – Recip Dam 
  3. Embryo ID will be ET Transfer – Embryo ID 
  4. Scanned date/time will be Date - Observation date or select correct date in Default Date 
  5. Go to ET details tab in import screen and select ET program XXXX.
    DO NOT CHECK AUTO CREATE EMBRYO ID.
     
    Proceed with import 
  6. Go to ET module and check that details have come through, should be In IN UTERO 
  7. Go to Last import and check that the cows are all joined etc


Article ID 4466

    • Related Articles

    • Embryo Backup

      Embryo Backup or Transfer is useful if you may wish to backup Embryos you are selling or buying from another Stockbook user. Embryos and their details can be transferred to another Stockbook user electronically. If you have: sold embryos to a breeder ...

    • 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 ...

    • 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 ...

    • Data Types and Stockbook Fields

      Data Types and Stockbook Fields When importing a CSV file to Stockbook the CSV file headings will need to be linked to Data Types and Stockbook Fields. The following is a list of Data Types and associated Stockbook fields available: Data Type: Life ...

    • Sire/Dam Not in List

      Finding an animal in Sire/Dam List: Step 1: Click on the Add Animal button at the bottom of the Animals screen. Step 2: Click in the Sire field to get the list. You will need to follow this link to: Change minimum breeding age of the animal. Article ...