Importing milk test results

If you perform regular DIY or ad-hoc milk testing for yield, fat, protein and cell count, the lab results can be uploaded via CSV file

W
Written by Will Rands
Updated over a week ago

Introduction

When your milk test results are available, your milk recording company will be able to provide a data file containing the results for butterfat, protein and somatic cell count.

The lab results are typically emailed to the farm as a file attachment.  This is commonly known as the "Essential Sampling" format. 

The file name is usually "Results.csv" (depending on the settings in your Windows File Explorer, you might not be able to see the "csv" file name extension).

When the file is uploaded, animals are matched on their Freeze Brand number in the FarmWizard herd list.

The fat and protein results in the date file will be percentage figures and these will be converted to kilos using the 24 hour milk yield contained in the file.  If you do not record milk yields, the best representation of the fat and protein data is to use a flat rate yield of 10 litres per cow.  In this situation, please contact the Farm Success Team if you need assistance amending the data file before upload.

Please note: if your herd performs authenticated (assisted) milk recording where the recording technician collects herd event data each month, your results will be made available in the "Datatream" format.  The Datastream file is uploaded via the Dairy Manager > Milk Records > Data Transfer screen.

How to upload the Results file 

If the data file has been sent by email as a file attachment, first save the file to a convenient folder on your computer.

  1. Check that the data file is in the CSV format (not Excel workbook format - .xls or xlsx).  Your milk testing company will be able to confirm this

  2. Go to Herd Manager > Data Import and select the "Raw/Essential Milk Recording Data" option

  3. Enter the date of the milk recording

  4. Click "Choose file" and browse to the folder where the file is saved. Click on the file name and click "Open"

  5. Click the Import selected data button

  6. Once the data has been uploaded and processed, a list of matched (and any unmatched) brand numbers will be displayed

A report showing the test details can now be run from Reports > Milk Records > Test Results.


Did this answer your question?