Import DHIA Test Results

Import DHIA Test Results

For processed testing, PAGs and Johnes results, you can ask your DHIA testing processor to send the files direct to BoviSync and have the results automatically imported. If they have any questions, your tester can request information by email us at: support@bovisync.com

For non-processed milk testing, you can use these instructions (or if you received the processed test result file instead of it being automatically imported) to import the CSV, DNL, PRT, MLK or 310 test result file formats.
  1. Click on Setup, then Import
  2. Select DHIA Monthly Test from the list of imports
  3. Click on Continue
  4. Drag and drop the file onto the Choose file button, or click on the 'Choose File' button and select the file you want to import
  5. After you select the file, a date box will appear. Select the test date and then click ‘Import’.
In order to import a DHIA file, you must have a herd code in BoviSync.  To learn more about herd codes see: Herd Code in BoviSync
Select Import and then DHIA Monthly Test
Select the DHIA test file, then pick the date, and click import.


Example of a .CSV File: Please note the 'herdcode' must be the name of the file. (ie: 35289053.csv)


The milk column cannot contain empty values.  If a null value is detected in the milk column the import will fail. 

If column detection fails to determine the correct columns, you must import the file with headings in the first row.
These are the heading(s) that are supported:

Heading         Supported alternatives
ID                   animal, cow, cowid, CTL, earid, eartag, eart, dhi comp number, ID
Milk                dmilk, milk, mlk, yield, weight, wt
Fat                  %fat, butterfat, fat, fat%, pctf, pctfat
Protein           %pro, pctprot, pctprot pctprotein, prot, prot%, protein, protien
SCC                cell count, SCC, somatic cell
Pen                 grp, group, group number, pen, tstring

You must save the files as a .CSV and the file name must be the herdcode of the farm. 

*You can also import just milk weights by animal. To do this just use a file that has ID and Milk Weights.



 

      
 You must save the file as a .CSV otherwise, the import will fail.

Please note that at least 85% of the rows have to contain valid values. In the case of the milk column the threshold is 99%.









    • Related Articles

    • Import Lab Results (PAGs) - DNO File Only

      This article is how to import as well as creating a .DNO file. This is a standard file for importing preg check results for PAGs.  Written Instructions: If you already have a .DNO file and only need instructions on importing skip to step #4 1. Open ...
    • Create a Test Day file based on Parlor Data

      This article will walk you through how to create a DHIA Test Day file based on parlor data from BoviSync.  You must have an active parlor interface which records daily milk weights into BoviSync for this to work.  Step 1:  Open this report in ...
    • DHIA Herd History Request

      How to Request DHI History in BoviSync: Written Instructions: 1. Click 'Setup' and click 'Herd Settings' 2. 'Click the 'Settings' Tab 3. Enter your DHI Herd Code, Access Code, and Testing Lab. 4. Click 'Request Herd History Import' 5. You will be ...
    • Automate Mastatest Milk Culture Results into BoviSync

      Background Milk culture results from Mastatest can now be automatically imported into Bovisync. This import can complete milk culture chores and create milk culture events. The instructions below will explain how to set-up this automatic import. ...
    • Import Milk Culture Results - DNQ files

      Background This guide will walk you through how to import Milk Culture results with the DNQ file extension. This import can complete milk culture chores and create milk culture events. File Creation The file should have the following set-up. It's ...