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: 

Animal Notes
  • Required: Animal ID
  • Required: Note Date
  • Downloadable template - Notes
Animals
  • Required: Animal ID
  • Required: Status
  • Required: Animal Type
  • Required: Sex
  • Recommended: Birth Date
  • Downloadable template - New Animals
Value List:
  • 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
Breeding Soundness Exam
Value List:
  • Classification: Pass, Fail, Deferred
Breeding
  • Required: Animal ID
  • Required: Breeding Date
  • Required: Breeding Method
  • Downloadable template - Breeding
Value List:
  • 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

Heat Tracking

  • Required: Animal ID
  • Required: Heat Date
  • Downloadable template - Heat Tracking
Embryos
  • Required: Animal ID
  • Required: Collection Date
  • Downloadable template - Embryos
Value List: 
  • Grade: 1, 2, 3, 4
  • Stages: 1, 2, 3, 4, 5, 6, 7, 8, 9
  • Sex: Bull, Heifer
  • Status: Available, Used, Sold, Unavailable
EPDs
Value List: 
  • Status: Actual Act, Interim Int, PE (or Pedigree Estimate), BKS (or Backsolution)
  • Contact CattleMax
Equipment
  • Required: Name, Status
  • Contact CattleMax
Value List: 
  • Status: Active, Sold, Inactive
Expenses
  • Required: Item 
  • Required: Purchase  Date
  • Downloadloadable template - Expenses
Income
  • Required: Item
  • Required: Earn Date
  • Downloadable template - Income
Measurements (for importing weights, etc)

To add additional fields such as contemporary group, use the Bulk Fill process and choose Category and type in Birth, Weaning, or Yearling.

Pregnancy Checks
Value List:
  • Check Method: Palpation, Ultrasound, Observation, Blood, Urine
  • Result: Pregnant, Open, Recheck
  • Ultrasound Sex: Bull, Heifer
Rainfall
  • 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]
Semen
  • Required: Animal ID
  • Downloadable template - Semen
Value List:
  • Sex: Bull, Heifer
Treatments
  • Required: Treatment Date, Medication
  • Downloadable template - Treatments
Value List:
  • 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)
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us