This page provides short answers to frequently asked questions about using the program.
User must Disable User Account Control (UAC) to install DairyWIN
Note: Disabling UAC will lead to a less secure system.
For best security policy we recommend Enabling UAC after Installing DairyWIN.
Disable UAC
1. In Start menu click on Run menu, type MSCONFIG and hit enter
2. Click on the Tools tab. Scroll down till you find "Disable UAC" . Click on that line.
3. Press the Launch button.
4. A CMD window will open. When the command is done, you can close the window.
5. Close MSCONFIG. You need to reboot the computer for changes to apply.
Enable UAC (After Installing DairyWIN)
1. In Start menu click on Run menu, type MSCONFIG and hit enter
2. Click on the Tools tab. Scroll down till you find "Enable UAC" . Click on that line.
3. Press the Launch button.
4. A CMD window will open. When the command is done, you can close the window.
5. Close MSCONFIG. You need to reboot the computer for changes to apply.
You can populate your DairyWIN database with animals using a download file (a text files with *.txt extension). The file format read by DairyWIN is shown below. There should be one record per animal, with each record comprised of the following fields:
Each value in the record should be separated by a semi-colon. If a value is unknown, its semi-colon must be still be included. The first six rows of a typical download file would be as follows:
UKV865435723;1258;1/4/1994;Daisy-1;"FFFF";UKV865412234;UKV865401243;;;;CULLED;28/9/1999;COW;3;YES;LACT;CALVED;;;
UKV865401357;1261;1/4/1994;Daisy-2;"FFJJ";UKV865412234;UKV865400222;;;;CULLED;29/12/2000;COW;;NO;UNKNWN;UNKNWN;;;
UKV865401234;4865;3/4/1994;Daisy-3;"FFFF";UKV865412234;UKV865404456;;;;;;COW;2;NO;LACT;PREG;28/8/1998;UKV865412934;
UKV865402322;4870;5/5/1994;Daisy-4;"FFFF";UKV865412234;UKV865401234;;;;;;COW;2;NO;DRY;EMPTY;;;
UKV865400357;4873;7/5/1994;Daisy-5;"JJJJ";UKV865418884;UKV865401444;;;;;;COW;2;NO;DRY;SERVED;;;
UKV865403257;4879;9/4/1994;Daisy-7;"FFFF";UKV865412234;UKV865403434;;;;CULLED;17/4/2001;COW;;NO;DRY;UNKNWN;;;
Why do we use semi-colon separators (in preference to comma separators)? In some parts of the world, commas are used as the decimal point separator (e.g. 22.2 is written 22;2). Semi-colon separators allow users to download animal details using commas as decimal point separators.
Use this spreadsheet as a template for creating an animal download file. Once you have populated this spreadsheet with data remove the first row (containing the column names) and save the file in *.csv (comma delimited) format. Open the file in MS NotePAD (or something similar) and use the search and replace option (Ctl-H is the shortcut) to change the comma seperators into semi-colons. Save the file with a *.txt extension. The file is now ready to download into DairyWIN. From the menu bar see / DATA / CREATE ANIMALS.
Make sure that the system time setting on your Palm Pilot is the same as that on your computer. The Windows operating system will automatically adjust the system time for daylight saving, whereas the Palm OS does not. If the system time on your Palm Pilot is earlier than the system time on your computer, you will get an error when you try to import CowPAD events back into DairyWIN.
See ANIMAL REPORTS / GUIDES / DUE TO CALVE SUMMARY. Enter the date range that you are interested in. Enter whether or not you are going to include cows that have not returned as being in-calf by clicking on the 'IN CALF CRITERIA' box and entering the appropriate details. Select how you want the data displayed: either as cows due to calve each week, or cows due to calve each month. Finally, select how you want the cow identifiers sorted: either by due date or in cow number order. Click on RUN to process the report. Sample output is shown below.
See ANIMAL REPORTS / GUIDES / DRYING OFF. Enter the dry off date range you are interested in. Set the dry off criteria by clicking on the OPTIONS button. Place a tick in the 'TO MEET THE REQUIRED DRY SPELL BEFORE CALVING OF x DAYS' and enter the number '45' in the space provided. Set any other criteria in the same way, while you are at it. Click on RUN to process the report.
The DRY OFF selection options will be remembered by the program, so they shouldn't need to be altered again. Always not a bad idea to check them quickly before you run the report again.
See / EDIT / GENERAL OPTIONS / REPORT SETTINGS. Select the radio button titled 'NONE' listed under the section 'LINE SHADING'.
See / ANIMAL REPORTS / VETERINARY VISIT / VISIT SHEET. Enter the proposed date of the visit. This date must be after today. Set the vet visit selection criteria by clicking on the SETUP button. Place a tick in the 'PREG DIAGNOSIS' box and enter the minimum number of days since last service for pregnancy testing (if your vet is a crack preg tester, you can make this 35 days, otherwise 40 - 45 days would be a sensible value). Click on RUN to process the report. Sample output is shown below.
See / ANIMAL REPORTS / HISTORIES / ANIMAL DETAILS LIST. Click on the GROUP button and select MULTIPLE SELECT as the group type. Click on ADD to create a new multiple selection definition. Click on 'Category A - items independent of dates used in report' and select the variable BIRTH DATE. Enter the birth date range for your 2000-born heifers. For seasonally calving dairy herds in southern Australia, the date range 1 July 2000 to 30 November 2000 would be a sensible birth date range to enter. Click the ADD TO QUERY BUTTON and re-name the selection identifier from 'DEFINITION 1' to '2000-born heifers', as shown in Figure 3. Click on RUN to process the report.
Once the report has processed, you can sort the heifers in order of Production Index (lowest to highest or highest to lowest).
I'll assume the term 'carry over cows' means cows that calved in 2000, did not conceive in the 2000 mating season and were milked through to join the herd in the 2001 season.
Step 1. Find out who the carry over cows were. See / ANIMAL REPORTS / HISTORIES / CALVING LIST BY COW. Click on RUN to process the report and then sort the report on calving date, as shown in Figure 4. Make sure that these are really the carry overs, and not just cows that you've forgotten to remove from the DairyWIN database! Make a note of these animals.
Step 2. Create a management code called 'CARRY OVER'. See / EDIT / CODEBOOK. Under 'SYSTEM CODES' right-click on the header 'MANAGEMENT EVENTS' and select ADD NEW CODE. Enter the text 'Carry over' as the code. Close the codebook.
Step 3. Assign the 'CARRY OVER' management code to the cows that were carried over. See / DATA ENTRY / ANIMAL BATCH DATA ENTRY. Think carefully about when the we're going to apply this management event - really it should be when we decided to carry the animals over. Lets say 31 May 2001 would be reasonable (dry off of the 2000 milking season). Have the code terminate the next time these animals calve by placing a tick in the 'INSERT END DATE AT NEXT CALVING' tick box. Click on SAVE to process the batch data entry.
Step 4. Run a report - comparing cows with the CARRY OVER managment code with the rest of the herd. For arguments sake, lets compare how the two groups performed at the first herd test in the 2001 milking season. See / ANIMAL REPORTS / ANIMAL PRODUCTION / SINGLE HERD TEST. Select a herd test date and select CODE ANALYSIS as the analysis type. Click ADD to create a new code analysis table, give it a name (CARRY OVERS); click ADD to create a new group within that table, give it a name (again, CARRY OVERS), and select 'ANY' as the match. Click OK twice to return to the SINGLE HERD TEST REPORT setup form. Click on RUN to process the report. The single herd test report will summarise milk volume, miksolids, milk value and cell count for the two two groups: the carry over cows and the rest of the herd.
Single-click on any existing shortcut on the Windows desktop, click the right mouse button and select COPY. Click anywhere on the Windows desktop, click on the right mouse button and select PASTE. You'll now have a copy of the existing shortcut. We now want to edit this shortcut so DairyWIN will start when it is clicked. Right-click on the short cut and select PROPERTIES. In the TARGET box, enter the following (copy and paste this line of code from this web page to avoid making mistakes):
"C:\Program Files\Access 97 Runtime\msaccess.exe" /excl /runtime /profile "DairyWIN" /wrkgrp "C:\Program Files\DairyWIN\System.mdw" "C:\Program Files\DairyWIN\DairyMAN.MDB"
In the START IN box, enter the following: "C:\Program Files\Access 97 Runtime". In the SHORTCUT KEY box enter None and in the RUN box enter Normal window.
Click on OK to finish. This will return you to the Windows desktop. To finish, edit the name of the shortcut to 'DairyWIN'.
See / ANIMAL REPORTS / CUSTOMISED HISTORIES. Create a new customised history with the variables COW NUMBER, LACTATION STATUS, and DRY OFF DATE. Use STOCK CLASS: ADULT COW and LACTATIONS: MOST RECENT.
Click on RUN to process the report - this will list the lactation status for all cows in the herd. If they have been dried off, (i.e. lactation status = 'DRY') then the dry off date will be listed.
If you only want the dry cows listed on this report, restrict the GROUP selection. Click on the GROUP button and select MULTIPLE SELECT as the GROUP TYPE. Click on the ADD button to create a new multiple selection definition (change the name from 'definition 1' to something meaningful - say 'dry cows'). Select 'LACTATION STATUS' from the drop-down list (under 'Category B'), tick the DRY tick box and click the ADD TO QUERY button to include it in the selection definition. Click on OK twice to return to the customised history setup form. Click on RUN to process the report.
You'll now have a list of cows that are currently dry and the dates on which they were dried off.
See / ANIMAL REPORTS / CUSTOMISED HISTORIES. Create a new customised history with the variables COW NUMBER, BIRTH DATE, and BREED. If you just wanted to list the breed details for calves and mated heifers, click on the GROUP button and select the STOCK CLASS: CALF and MATED HEIFER options. If you wanted to include adults, select STOCK CLASS: ADULT COW. Click on RUN to process the report.
If you want to know the average daily weight change for a group of animals weighed on two dates, see / ANIMAL REPORTS / WEIGHT AND CONDITION SCORE / REPORTS. Enter the appropriate date range, check the WEIGHT radio button and select DATE as the analysis type. This report will list the number weighed on each 'weigh' date' and the average bodyweight recorded. The average daily weight change is also provided. See / ANIMAL REPORTS / WEIGHT AND CONDITION SCORE / GRAPHS to show this information graphically.
I'm a bit uncomfortable with this report because 'averages' tend to hide outliers (extreme values). Another option is to list the weight change recorded for individual animals. See / ANIMAL REPORTS / HISTORIES / WEIGHT AND CONDITION. Enter the date range (as before) and click RUN. This report will list every animal weighed on the dates specified and will also list the weight change recorded. Problem: the report doesn't quote daily weight change. Solution: look at the report in print preview mode, then click on the 
button to export the results to a spreadsheet (e.g. MS Excel). Within the spreadsheet you can calculate daily weight change and plot the data in a more informative way (I feel) as a scatter plot. As a scatter plot, outliers (heifers losing excessive weight) are easily detected.
May cause the following errors
1) Error # 3052
2) Error # 3034
3) The internal indexes of farm datafile are inconsistent. DairyWIN will attempt to rebuild the indexes.
These errors maybe solve by updating value of Jet 3.5 MaxLocksPerFile from 9500 to 15000.
-= FIXED =-
1. Click the Start button, and then click Run.
2. In the Open box, type regedit.
3. Locate the HKEY_LOCAL_MACHINE registry folder.
4. Expand the HKEY_LOCAL_MACHINE folder until you locate the folder SOFTWARE\Microsoft\Jet\3.5\Engines\Jet 3.5.
5. Double-click the Jet 3.5 folder to view its contents.
6. Select the MaxLocksPerFile entry; on the Edit menu, click Modify.
7. In the Edit DWORD Value dialog box, select Decimal and increase the number in the Value Data box to 15000.
8. Click OK to save the MaxLocksPerFile setting.
9. Quit the Registry Editor.
Or download zip file and unzip the file & run Registry file ( MaxLocksPerFile_15000.reg )
32,767 limitation in DairyWIN for input data from .104 file.
Quick work around, is to make multi .104 files.
each file must have less than 32000 records.
1) Make backup
2) In Notepad and open
copy and paste the first 30,000 rows of data into new text file and save as (temp1.txt) in same directory as
copy and paste the next 30,000 rows of data into new text.file and save as (temp2.txt) in same directory as
etc .....
until there are no more records left.
3) rename
4) Input temp file into DairyWIN ( repeat the process until all temp file have been inputted.)
Rename temp file to
Open DairyWIN and run downloads forms.
Close DairyWIN.
Rename
Solution - To Stop error occuring , make sure 'Change Update Date' is set to today Date before importing any animal details.
