Import New Animals (Animal Import Purchased)
This import allows you to easily create newly purchased animals. Note this import is currently in Beta.
File Example:
Columns in Yellow are Mandatory, Green columns are optional, but must be left in the file header. The header may contain one or two rows.
Dates: Flexible (MM/DD/YYYY) (YYYY/MM/DD) (DD/MM/YYYY) There must be a minimum of 15 animals in the file for date detection to be recognized. If you are adding less than 15 animals see: Create a New Animal
File Name: No requirements
Supported File Types: .CSV, .XLS, .XLSX
File Definition:
| Column | Mandatory? | Notes | Examples |
ID | Yes | The ID of the animal (Commonly known as the Eartag or visual ID) | Eartag, Visual ID |
REG NUMBER | No | The registration ID of the animal | Official government number |
EID | No | The EID of the animal (Commonly known as the RFID or electronic number) | RFID, electronic number |
BIRTHDATE | Yes | The animal's date of birth | |
PEN | Yes | The animal's current Pen/Group (If unknown put 0) | |
SEX | Yes | The animal's sex (F, Female, M, Male) | |
| BREED | No | The animal's breed (HO, JE, Holstein, Jersey, etc) | |
DAM ID | No | The animal's DAM ID (Dam's eartag or registration ID) | |
SIRE | No | The animal's SIRE (The animal's father) | |
| MGSIR | No | The animal's Maternal Grand Sire (Mom's father) | |
FRESH DATE | No | The animal's last known freshen date | |
LACT | No | The animal's current lactation number (Integers only) | |
LAST BRED DATE | No | The animal's most recent service date | |
SERVICE SIRE | No | The sire associated with animal's most recent service | |
CDAT or REPRO STATUS | No | Conception Date or current Repro Status | |
DRY OFF DATE | No | Date of the last dry off. Only use if the animal is currently Dry | |
DNB Date or REPRO STATUS | No | Last DNB Date or current Repro Status | |
CULL DATE | No | Date of the animal was culled | Sold Date, Death Date, etc |
PURCHASED DATE | No | Date of purchase or entered herd | |
WEIGHT DATE | No | Date of last weight | |
WEIGHT | No | Last weight (integers only) | 500, 1000, etc |
STATUS DATE | Yes | If not sure, use animal's birth date | |
LAST ABORTION DATE | No | Date of last abortion |
Import:
You will not receive any notification that the import has completed, or if any errors were detected.
See file template attached below!