How the Spreadsheet Import feature works in CattleMax
We are happy to announce the release of importing spreadsheet data into CattleMax! Spreadsheets can be helpful in collecting records at the working pens and areas without Internet access. In addition, many breed associations and companies (such as feedlots) provide data in spreadsheet format. The data in CattleMax is structured so that the information is organized in an easy-to-find way and to be able to generate helpful reports and worksheets.
A few helpful tips:
CSV file format: The file needs to be in .csv format. If it ends in .xls or .xlsx, you can open it in Excel, and choose the Save As option. In the "File Format" box, choose CSV (Comma Separated Values) only.
Column headings: Column headings are needed and should only be on the first row.
Required entries: These are entries that must accompany the records, either as columns in the spreadsheet or as selections in the Bulk Fill area.
Value List entries: Details for these fields must match entries in this list.
Here are the required fields and value list entries:
- Required: Animal ID
- Required: Note Date
- Downloadable template - Notes
- Required: Animal ID
- Required: Status
- Required: Animal Type
- Required: Sex
- Recommended: Birth Date
- Downloadable template - New Animals
- Animal Type: Bull, Cow, Calf
- Brand Location: LH (or Left Hip), LR (or Left Rib), LS (or Left Shoulder), LT (or Left Thigh), LJ (or Left Jaw), RH (or Right Hip), RR (or Right Rib), RS (or Right Shoulder), RT (or Right Thigh), RJ (or Right Jaw), FB (or Freeze Brand)
- Conception Method: NS (or Natural Service), AI (or Artificial Insemination), ET (or Embryo Transfer)
- Ear Tag Location: LE (or Left Ear), RE (or Right Ear), BE (or Both Ears)
- Horn Status: Horned, Polled, Scurred, Dehorned
- Sex: Bull, Cow, Calf
- Status: Active, Sold, Dead, Reference
- Breeding Status: Pregnant, Open, Exposed
- Required: Animal ID
- Required: Exam Date
- Downloadable template - Breeding Soundness
- Classification: Pass, Fail, Deferred
- Required: Animal ID
- Required: Breeding Date
- Required: Breeding Method
- Downloadable template - Breeding
- Breeding Method: NS (or Natural Service), AI (or Artificial Insemination), ET (or Embryo Transfer)
- Embryo CL Side: Left, Right
Carcass - Harvest
- Required: Animal ID
- Required: Harvest Date
- Downloadable template - Carcass - Harvest
Carcass - Ultrasound
- Required: Animal ID
- Required: Ultrasound Date
- Downloadable template - Carcass - Ultrasound
Heat Tracking
- Required: Animal ID
- Required: Heat Date
- Downloadable template - Heat Tracking
- Required: Animal ID
- Required: Collection Date
- Downloadable template - Embryos
- Grade: 1, 2, 3, 4
- Stages: 1, 2, 3, 4, 5, 6, 7, 8, 9
- Sex: Bull, Heifer
- Status: Available, Used, Sold, Unavailable
- Status: Actual Act, Interim Int, PE (or Pedigree Estimate), BKS (or Backsolution)
- Contact CattleMax
- Required: Name, Status
- Contact CattleMax
- Status: Active, Sold, Inactive
- Required: Item
- Required: Purchase Date
- Downloadloadable template - Expenses
- Required: Item
- Required: Earn Date
- Downloadable template - Income
To add additional fields such as contemporary group, use the Bulk Fill process and choose Category and type in Birth, Weaning, or Yearling.
- Required: Measure Date
- Downloadable template - Measurements (Weights)
- Required: Check Date
- Downloadable template - Pregnancy Checks
- Check Method: Palpation, Ultrasound, Observation, Blood, Urine
- Result: Pregnant, Open, Recheck
- Ultrasound Sex: Bull, Heifer
- Required: Rainfall Date, Rainfall Amount
- Downloadable template - Rainfall but we will have to import the data for you. Please email your completed spreadsheet to [email protected]
- Required: Animal ID
- Downloadable template - Semen
- Sex: Bull, Heifer
- Required: Treatment Date, Medication
- Downloadable template - Treatments
- Route: IM (or Intramuscular), IMM (or Intramammary), IN (or Intranasal), IR (or Intraruminal), IU (or Intrauterine), IV (or Intravenous), IVG (or Intravaginal), OR (or Oral), PO (or Pour On), SQ (or Subcutaneous), TP (or Topical), XX (or Other / Unknown)
- Location: LE (or Left Ear), LEP (or Left Elbow Pocket), LF (or Left Flank), LH (or Left Hip), LLN (or Lower Neft Neck), LRN (or Lower Right Neck), LS (or Left Shoulder), LY (or Left Eye), MTH (or Mouth), NOS (or Nose), RE (or Right Ear), REP (or Right Elbow Pocket), RF (or Right Flank), RH (or Right Hip), RS (or Right Shoulder), RY (or Right EYE), TOP (or Top Line), ULN (or Upper Left Neck), URN (or Upper Right Neck), UBN (or Upper Beck (both sides)), LBN (or Lower Neck (both sides)), BE (or Both Ears), BY (or Both Eyes)