Import implant information from CSV file

Import implant information from CSV file

This import is only for advanced users for bulk updating implant event.  If you have errors you will need to import a new file to update or manually fix the events you updated.  If you have a lot of events to update, please try with a small portion first to test you are doing it correctly.  There is no way to undo the import and recover past information, and we can only offer minimal support of this import.

This guide will walk through the process of importing a CSV file to update implant events. These implant events may have been created in the barn or elsewhere.

Be aware: Any breedings that occur exactly 7 days prior to an imported implant for that animal will be converted to an implant.

First, you will need to create a CSV file which the implant event information. Carefully read these requirements in order to prevent errors from occurring.

Implant CSV file requirements:
  • Headers in the first row of the CSV file need to be (the headers are not case sensitive)
    • animal, date, dam, sire, source, grade, stage, extra1, extra2, extra3, note
  • Accepted values for each field:
    • Animal - Registered ID, EID, Eartag (we strongly recommend using Registered ID to identify the correct animal in the event of duplicate eartags)
    • Date - date of implant event (MM/DD/YYYY) (MM/DD/YY)
    • Dam - EID, Registered ID, Eartag (we strongly recommend using registered ID or EID)
    • Sire - NAAB codes
    • Source - Fresh, Frozen or Vitrified are acceptable values
    • Grade - 1 to 5 are acceptable values
    • Stage - 2 to 9 are acceptable values
    • Extra 1 - alphanumeric text
    • Extra 2 - alphanumeric text
    • Extra 3 - alphanumeric text
    • Note - alphanumeric text
  • Only animal and date are required to import a file
  • File must be a comma delimited file (csv)

Example file:

Make sure the animals you are importing have implant events. If they do not have an implant event the import will fail for those animals but you will receive an email notifying why the import failed.

Once you have a CSV file that meets all of the requirements and you have implant events for the animals you are ready to import implant information. Start by going to Setup --> Import. Select Embryo Implant Update.

Next, choose your file. Click the Choose File button, navigate to the file and click open. When you are ready to import click Import.

You will need to enter your email and password, then click Import to start the upload.

It may take 1-2 hours for the implant information to show up in BoviSync depending on the size of the file.

If you have not seen it the information after 15 minutes check your email. You will receive an error message with a file which you can download. The file will show you why each event did not get imported. Fix the errors and follow the steps again to import the implant information. In the example below there are no implants for these animals on these days. I need to correct the dates in the file to match the implant events in BoviSync.

Implant event after a successful import.

Some important notes:
  • You can import a file as many times as you would like in the event that you make a mistake.
  • Import can happen at the ownerhsip farm or the farm that the animal is located at. 
    • If your ownership farm contains many animal it will cause the import to take lornger
  • If you update a sire there is a note with the previous sire and the date the sire was changed that is appended to the implant event note. (See example image below)
  • If a sire does not exist in BoviSync this import process will create a sire, even sires that are not actual sires.
  • Only values provided in the file will be uploaded (blank data will not overwrite existing data if imported).
  • Duplicated Registered IDs, EIDs or Eartags will cause the import to fail to find the implant or animals in the file

    • Related Articles

    • Import Genomic Information into BoviSync

      This guide will walk through the process of importing genomic information into BoviSync. This import type can be used to import files from: CDC, Jegen, Neogen or Zoetis. Each of the files has requirements for the first several columns of the report. ...
    • Implant Setup BoviSync

      Protocol Setup Copy Protocol from BoviSync global farm: Implant off Heat Synch Protocol Setup for Recipients If using a synch program to prepare the recipient animals, copy the sync protocol you are using from your farm or the BoviSync farm. Replace ...
    • Animal Pedigree Update Imports

      There are now two different types of imports that you can use to update animal pedigrees. The imports are: API ID Animal Pedigree Update Eartag Animal Pedigree Update This article will walk through using both options. We recommend that you double ...
    • Import PTA information into BoviSync

      This article will walk through the process of importing and reporting on specific PTA information in BoviSync. Preparing the File for Import Currently the PTA items which you can report on from an animal report are: PTA Cow Conception Rate PTA ...
    • Formatting EID numbers in .CSV file formats

      When opening a .CSV file in Microsoft Excel, EID numbers are automatically formatted to be rounded. For the file to import correctly, without errors, you must format the EID values to eliminate the decimal places.  Written Instructions: 1. Open the ...