Home

7160-9001-516 Dairy Plan

1. 1000 REM 1010 REM Main Loop Ask for animal number and info 1020 REM 1030 PRINT 1040 INPUT Enter Animal Number 0 to exit gt C 1050 IF C lt 0 GOTO 2000 1060 INPUT Enter Milk Amount gt M 1070 M M 10 1080 INPUT Enter Percent Fat gt F 1090 F F 100 1100 INPUT Enter Percent Protein gt P 1110 P P 100 1120 INPUT Enter Somatic Cell Count in thousands gt 1130 REM 1140 REM write data value record 1150 REM 1160 PRINT 1 VNO00000 1170 PRINT 1 USING C 1180 PRINT 1 USING M F P 1190 PRINT 1 USING S 1200 GOTO 1000 2000 REM 2010 REM write T and Z records and close file 2020 REM 2030 PRINT 1 TN 2040 PRINT 1 ZN 2050 CLOSE 1 2060 SYSTEM 2 4 A C Language Programming Example The following sample program example c is on the DPDataExchange development disk to show how a c program can make an ADIS file include stdio h main 7160 9001 516 11 2003 12 char date 10 long animal double milk pfat ppro scc FILE outf open ADIS file outf fopen EXAMPLE ADS w Header Definition fprintf outf DH000000000000000800020168124000201575080 n printf Enter Test Date CCYYMMDD gt scanf s date Header Value Record fprintf outf VH000000DD BASIC SAMPLE PROGRAM 8 8s n date Data Definition fprintf outf DN000000002018960600000510104100200
2. 6522 6523 6531 6532 6533 6601 6602 6603 6611 6612 6613 6621 6622 6623 7101 7102 7103 7104 7105 7106 7107 7108 7109 7111 7112 7115 7116 7118 7119 7130 7131 7132 7133 7134 7143 7144 7145 7146 7148 7149 7151 7152 7155 7163 7164 7165 7166 7168 7169 7171 7172 7175 EME LifeMilk LifeFat LifeProt LifeMC LifeFC LifeDC CalfSex Calf1 CalfReg CalfSex2 Calf2 CalfReg2 DC DFC DMC FdType FdName Ratn CFC Recm Rem CFRInt CFU CFA PRem P2Rm CFR FdConsAv RatnYest ConsYest RemP RemPShow RemPNow PTFeed NextFedint Ratn1 CFC1 Recm1 Rem1 CFU1 CFA1 Dem P2Rm1 CFR1 Ratn2 CFC2 Recm2 Rem2 CFU2 CFA2 PRem2 P2Rm2 CFR2 7160 9001 516 11 2003 External Mature Eq calc Lifetime Total Milk Lifetime Total Fat Lifetime Total Protein Lifetime Total Male Calves Lifetime Total Female Calves Lifetime Total Dead Calves Calf Sex Lact First Calf ID Calf Registration Calf Sex Lact Second Calf ID Calf Registration 2nd Lact number dead calves Lact number dead female calv Lact number dead male calves Feed Type Number Name for Feed Feed Ration Current Feed Consumed Recommended Feed Ration Feed Remainder yesterday Current Feed Reached Int Mi Current Feed Unavailable Current Feed Available Feed Remainder Prev Day Feed Remainder 2 days ago Current Feed Remainder Feed Consumed 7 Day Avg Feed Ration Yesterday Feed Consumed Yesterday Feed Remainder Percentage
3. DPDataExchange Does not require colons or status characters and permits comments between request and search records loose interpretation Produces comment records with a colon for DII format or Normal Status for ADIS SDII Requires colons and does not permit comments between request and search records strict interpretation 3 6 3 Varied field widths See Definition Record section 4 3 4 page 21 ADIS Specifies that field widths are to be specified in the data dictionary Implementations are allowed to support non standard widths but are NOT required to do so DII Specifies correct field widths for each public data field DPDataExchange Accepts any field width for both import and export of any field If requested numeric data does not fit in the field the field is question mark or zero filled alphanumeric data is truncated to fit any field width SDII Warns of any non standard field widths 3 6 4 Date and Time Formats See section 4 2 4 page 37 ADIS Specifies 8 digit date formats as CCYYMMDD ie 4 July 1992 is 19920704 Specifies 6 digit time formats as HHMMSS ie 5 30 PM is 173000 DII Specifies 8 digit date formats as CCYYMMDD same as ADIS 7160 9001 516 11 2003 31 Specifies 4 digit time formats as HHMM ie 5 30 PM is 1730 DPDataExchange Will accept 6 or 8 digit date formats 6 digit is YYMMDD ie 920704 Will accept 4 or 6 digit time formats either ADIS or DII However most DAIRYPLAN DP5 data f
4. Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data 4775 4776 4777 4778 4779 4780 4781 4782 4783 4791 4792 4793 4794 4795 4796 4801 5101 5103 5106 5107 5108 5120 5125 5127 5128 5130 5151 5152 5153 5154 5155 5156 5157 5158 5201 5202 5203 5211 6101 6102 6103 6104 6121 6122 6123 6124 6131 6132 CwRobNoAtt CwRobNoBru CwRobNoMilk CwRobRejM1 CwRobRejM2 CwRobQuMis1 CwRobQuMis2 CwRobQuMis3 CwRobQuMis4 IMClusterSet IMFlowMiss1 IMFlowMiss2 IMFlowMiss3 IMFlowMiss4 IMCountSets IMMFlowChk TestMilk TestDim TestDate MPWgt MPDat MPBody MPPedHr MPFIoAv MPFIoMx MPCondA Fat Prot Lact SCC LnSCC Urea Score Urea10 Sample SampBox SampDat IMBarCode PDCalve LactMO IMCntO IMCntE MkAv PTFeed M305 Sum Brd Sum Vet Sum Fed 7160 9001 516 11 2003 Leonardo Do not attach automatically Leonardo Do not Brush automatically Leonardo Do not Milk Leonardo Separate Milk 1 Leonardo Separate Milk 2 Leonardo Missing Quarter Leonardo Missing Quarter Leonardo Missing Quarter Leonardo Missing Quarter Time to set Cluster No Milk Flow from Quarter 1 No Milk Flow from Quarter 2 No Milk Flow from Quarter 3 No Milk Flow from Quarter 4 Count Cluster Set Tries Count Milk Flow Checks Leona Milk Amount in Componen
5. Family Line Breeder Buyer Status Word Body Weight Average Body Weight Weigh Date Body Weight Measurement Date Body Weight Measurement Time Measurement Body Weight Feed Stall Visit Count Feed Stall Visit Count Avera Last Feed Stall Visit Time Total Seconds at Feed Stall Total Minutes at Feed Stall Drink Stall Visit Count Drink Stall Visit Count Aver Total Seconds at Drink Stall Total Minutes at Drink Stall Drinking Speed Drinking Speed Average Drink Speed Deviation Percent Growth per day Daily Growth over Lifetime Lowest Body Weight Recorded Lowest Body Weight Date Lowest Body Weight DIM Average Body Weight this Lact Selection Date Selection Switch 1 Selection Switch 2 Selection Switch 3 Selection Switch 4 Count Times Selected Count Times Selected Selection Count 7 day Avg 58 General General General General General General General General Process Control General Process Control General Process Control Body Measurement Body Measurement Body Measurement General Process Control General Process Control General Process Control General Process Control General Process Control General Process Control General Process Control General Process Control General Process Control General Process Control General Process Control General Process Control General Process Control General Process Control General General General Gener
6. Feed Remainder Percentage Feed Remainder Percentage Now Projected Feed Consumption Next Feed Interval Calc Time Feed Ration Current Feed Consumed Recommended Feed Ration Feed Remainder yesterday Current Feed Unavailable Current Feed Available Feed Remainder Prev Day Feed Remainder 2 days ago Current Feed Remainder Feed Ration Current Feed Consumed Recommended Feed Ration Feed Remainder yesterday Current Feed Unavailable Current Feed Available Feed Remainder Prev Day Feed Remainder 2 days ago Current Feed Remainder 69 General General General General General General Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed 7183 7184 7185 7186 7188 7189 7191 7192 7195 7201 7202 7203 7204 7205 7206 7341 7342 7343 7344 7345 7346 7347 7348 7349 8001 8002 8003 8004 8005 8006 8007 8008 8009 8010 8011 8012 8013 8014 8021 8022 8023 8024 8025 8101 8102 8103 8104 8105 8106 8107 8108 8109 8110 8111 Ratn3 CFC3 Recm3 Rem3 CFU3 CFA3 PRem3 P2Rm3 CFR3 MsFedDat MsFedTim MsVisCt MsVisDu MsRemP MsFedCons MPF1 MPF2 MPF3 MPF4 MPF5 MPF6 MPF
7. If numeric data does not fit in a requested field width a warning appears on the screen and the field is zero filled 7160 9001 516 11 2003 15 3 1 3 HDI files DPDataExchange checks several fields in the header if a file exists which name equals the field value extended with HDI If such a file exists it is automatically loaded and processed For example you can create a HDI file for a special sender organization containing the special define statements necessary for a data transfer with this organization HDI files may contain any records used by DPDataExchange but the usual purpose is to define special field names and options used by the sending organization Follwing header fields have the HDI Automatic Menmonic DAIRYPLAN Item Number ISO Item Number DD 0000 0001 0000 0000 ADED_ISO 0000 1015 0090 0002 ADED_Nat 0000 1016 0090 0009 ADED_Man 0000 1017 0090 0012 Sender 0000 1013 0090 0006 Receiver 0000 1018 0090 0006 3 2 DPDataExchange Options Besides input and output file names you may specify certain options on the command line Options may appear in any order preceded by a dash or slash Options can be set several ways on the command line when DPDataExchange is started or by control records in the file When setting options from within the file the flag control record is the preferred method For example the record f auto 1 errexit 1 will set DPDataExch
8. MilkTimeOK MBM NoErr ATim NolDPerc HIdDt HldTm RstDt RstTm Ill Met Gen GenUseDT Stim MFManTakeOff MFContPulse MFNoFinishSup MFBlockExit MFRinseBetwee MFNoAutoBrush MFRobotTrain MFNoAutoAttac MFNokickoff MFAttenA MFAttenB CFSepMilk CFNoMilk CFNoBrush CFCDatOK CMilkCtrlSet MsPedHr MsPedVI MsPedDat MsPedTim MkpH MkpHAvg MkpHSd MkpHDev MkpHSdD MkpHShow MkpHHigh MkpHLow 7160 9001 516 11 2003 Average Milk from Session Thr Average Milk from Session Fou Average number of milkings pe Difference of last 2 milkings Sum of last 2 milkings Sum of last 3 milkings Minutes between Milkings Last milk time in minutes Minutes since last milking Reached minimum milking inter Minutes between Milkings Average time required ID missing percentage Date to begin using settings Time to begin using settings Date to stop using settings Time to stop using settings Milking Sickness Code Milking Isolation Code Milking General Code Use Dates for General Code Stimulation Time Manual Takeoff continue pulsation No Milk Finish Support Block Exit Gate Rinse Between Milkings No Automatic Brushing Robot Training No Auto Attach No Kick Off Light A Light B Combined Flags Combined Flags Combined Flags Combined Flags Isolate Milk Do Not Milk No Automatic In date range Any Milk Control Flag Set Measurement Activity Hour Measurement Activity Value Activity Measurement Date Activi
9. Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Sire Text Text 9993 q Text Text 5 ANNEX A Using ASCTODII 5 1 Data Conversion Programs If your data is not in ADIS or DII format you must run a data conversion program to make your file compatible with the international standards Contact your Dairy Records Processing Center and ask them if an ADIS or DII format file is available or if they can help you with the conversion Since ADIS has been approved by the International Standards Organization most centers should be willing to work with you on this You have two possible methods to use 1 Many ASCII text files can be converted using the ASCTODII DOS program With this method you just answer some questions concerning the contents of your file and the conversion can be carried out automatically Once ASCTODII has been properly set up you may use it in a batch file to convert similar files in the future 2 If your file is too complex for ASCTODII you may have to actually write a customized computer program to convert your files See section 2 page 9 5 2 Kinds of Files ASCTODII Can Convert ASCTODII will convert many ascii or text files into the DII format which is one of the file types DPDataExchange can read automatically In this case loading your data becomes a two step process First you
10. 32 DAIRYPLA ISO and or DII Code Description DAIRYPLAN DP5 Notes NDDI Taurus DDI Number anor rr ra 6102 TE Lemmer Official Milk Yield EXPORT ONLY This is lactation to date calculated by DPDataExchange by adding up all qualified milk weights in the measurements table It will be quite small unless the measurements tables are enlarged using DPSIZE Current lactation only 6103 IMCNTO Official milking count EXPORT ONLY This is a count of the number of milk weights described above 6104 IMCNTE Error milking count EXPORT ONLY This is the number of milkings in LACTM but not in LACTMO This is an estimate calculated by GE PE E a 5 PdCalve Lactation start date ee stored in the lactation table You can also use ClvDat to import a lactation 6203 900084 LACTM Milk yield lactation to This is DAIRYPLAN DP5 s 00201897 date production estimate It can be manually entered by the user but normally is totaled from automatic milk meters To be seen in DPSingle 7160 9001 516 11 2003 51 Ldim old Lactation Days in milk lactdim 6251 900086 6201 900074 LACTF Fat Lactation to date 6202 900072 LACTP Protein Lactation to date see VPe P z 6303 00280052 M305 Actual 305 day milk yield 6320 Foo Actual 200 day milk yield 6310 Actual 100 day milk yield 6301 un F305 Actual 305 day fat yield 6302 900073 P305 Actual 305 day protein yield 33 Ea 305 day milk yield Projected 305 day fat y
11. 516 11 2003 38 DPDataExchange displays the data on the screen Until Further Notice 1996 In Germany for example ADR20011 For export DPDataExchange fills in appropriate data k 2 Software key or Demo date not yet expired 4 3 2 General Animal Information These items can be imported or exported with only the animal number as the index DAIRYPLA ISO and or DII Code Description DAIRYPLAN DP5 Notes NDDI Taurus DDI Number Number 900070 Herd Specific SAnimal Animal number This or 00201896 Number 2002 must be present for import of all animal data If the value number is not in DAIRYPLAN DP5 a new record will be created 2002 900080 Registration Number Registration Number see 00200065 DPSingle Identification Can be used to index data import of animal data but will NOT create new records if an unknown number is used 900056 reg2 Alternate Registration A 15 Second Registration see Number DPSingle Identification sa S 900096 resp Electronic ID number 00201812 was implant in older respiso ISO responder A 15 versions 00280044 True days in milk K EXPORT ONLY calculated A 15 See DPSingle Identification see DPSingle Identification Responder number See DPSingle Identification Alternate Responder string Breed Letter code Animal Type Sex of animal from last calvi
12. 8 Synchronization Status Data See section 4 4 3 page 29 7160 9001 516 11 2003 32 ADIS Specifies that synchronization data is for 1 initialization of the database or 2 comparison of data bases DII Does not included synchronization data DPDataExchange Asks user if the initialization flag should be set but otherwise treats S status like N 3 6 9 Importing Zero Data See Zero Option section 4 2 3 page 18 ADIS ADIS has special characters defined for non initialized data No special distinction is given to fields with zero values DII No distinction is given to fields with zero values DPDataExchange Zero or space filled fields are ignored unless the Z option is used This prevents DPDataExchange from erasing valid data which was unknown to the sender 3 6 10 Previous Lactation Data ADIS does not specify whether old data should be sent or not DII does not specify whether old data should be sent or not DPDataExchange For export Vet and Breeding data is ignored from prior lactations unless the L option is used For import any data can be loaded according to field specifications 3 6 11 Milk Error Codes See section 4 3 5 page 45 ADIS Does not specify the use of milk error codes DII Error code 2 is for machine estimates code 4 is for duplicate entries DPDataExchange Error code 2 is used correctly when an estimate is available With some DAIRYPLAN DP5 setup options estimates are not ava
13. 89 01 14213 0513 0312 L3 0037 05 10 90 02 15321 0541 0431 L3 0037 06 11 91 03 14312 0432 0531 In this example the file contains three line types L1 L2 and L3 These lines contain farm data general animal data and animal lactation data respectively ASCTODII can convert just one line type at a time therefore a customized batch file is required To convert such a file 1 Run ASCTODII filename SETL1 you are specifying a special setup file SETL1 2 Answer all questions so as to load data from line type L1 using the Data line identification as L1 to separate these lines from the others 3 Do not have ASCTODII create a batch file because you must create your own special batch file 4 Repeat steps 1 3 for each line type specifying a different setup file for each line type you may use any valid filename 5 Finally construct a batch file such as the following This will perform the conversion for each line type separately and run DPDataExchange to load the data ASCTODII filename SETL1 OUTL1 A if errorlevel 1 goto end DPDataExchange OUTL1 DII ASCTODII filename SETL2 OUTL2 A if errorlevel 1 goto end DPDataExchange OUTL2 DII ASCTODII filename SETL3 OUTL3 A if errorlevel 1 goto end DPDataExchange OUTL3 DII end del OUTL1 DII del OUTL2 DII del OUTL3 DII Remark As DPDataExchange is not a DOS program you cannot check error levels with it For more complex data files it may be advisa
14. ClvTime ClvOffC ClvCom2 ClvDatP HtODat HtOTech HtOCost HtOCom HtODiag HtOTime HtOOffC HtOCom2 HtODatP SrvDat SrvTech SrvCost SrvCom SrvDiag SrvTime SrvOffC SrvCom2 SrvDatP PrgDat PrgTech PrgCost PrgCom PrgDiag PrgTime PrgOffC PrgCom2 PrgDatP DryDat DryTech DryCost DryCom DryDiag DryTime DryOffC DryCom2 Vet Comment 2 Vet Action Name BIRTH Vet Action Date BIRTH Vet Action Worker BIRTH Vet Action Cost BIRTH Vet Action Comment 1 BIRTH Vet Action Result BIRTH Vet Action Time of Day BIRTH Vet Official Code Numb BIRTH Vet Comment 2 CALVING Vet Action Date CALVING Vet Action Worker CALVING Vet Action Cost CALVING Vet Action Comment 1 CALVING Vet Action Result CALVING Vet Action Time of Da CALVING Vet Official Code Num CALVING Vet Comment 2 CALVING Future Vet Action Dat HEAT Vet Action Date HEAT Vet Action Worker HEAT Vet Action Cost HEAT Vet Action Comment 1 HEAT Vet Action Result HEAT Vet Action Time of Day HEAT Vet Official Code Numb HEAT Vet Comment 2 HEAT Future Vet Action Date INSEMINATION Vet Action Date INSEMINATION Vet Action Worker INSEMINATION Vet Action Cost Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Act
15. Lactati Average Protein Test this Lac Average SCC Test this Lactati Average Fat Amount this Lacta Average Protein Amount this L Lact Days in Milk Lact Actual 305 Day Fat Lact Actual 305 Day Protein Lact Actual 305 Day Milk Lact 100 Day Milk Total Lact 200 Day Milk Total Lact Actual 365 Day Milk Projected 305 Day Milk Projected 305 Day Fat Projected 305 Day Protein Projected 305 Fat Corrected External 305 milk calc External 305 fat calc External 305 protein calc Annual Milk Production Lact Milk Percent Error Estim Projected 305 milk from 100 Projection Error 100 to 305 Rolling Herd Average Rolling Herd Average Milk Co Rolling Herd Average Days Co Expected to Milk on Date Projected 305 FC Mature Equiv Projected 305 Mature Equiv 68 General General General General General General General General General General General General General General General General General General Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals Lactation Totals 6510 6521
16. Numeric List of Codes ai 55 5 ANNEX A Using ASCTODI coin anna 73 2 1 Data Conversion Program 73 2 2 Kinds of Files ASCTODII Can Convert 73 2 3 Running ASGTOD II sai iii I 74 2 4 Special options using ASCTODI ii 76 6 ANNEX B Release Notes 22 a nie 79 6 1 Release Notes Updating 4 4 DOS DPLINK to 5 018 DPDataExchange 79 7160 9001 516 11 2003 2 1 Using DPDataExchange 1 1 Overview DPDataExchange is WestfaliaSurge s program for connecting DAIRYPLAN DPS to the outside world WestfaliaSurge has long provided data import export capabilities using ascii files But with DPDataExchange data transfers are controlled using either the ADIS or the DII protocol which eliminates much of the hassle of ordinary ascii transfers With DPDataExchange you can easily transfer DAIRYPLAN data to or from any program which also uses the one of these protocols 1 1 1 The DII Protocol First suggested by the U S Milking Machine Manufacturers Council of FIEI in 1989 most major American suppliers of on farm Dairy computers have endorsed this method of data exchange Now several DRP centers and other agencies are testing it as well A DII file contains more than just your data it also contains definition records to precisely define what form the data takes With DII you do not need to spend time matching your software to the sender s program this can all b
17. Test Table see chapter Component and Somatic Cell Test Results Import does not require the I option however with the I option the new test weight will replace the current average milk weight in DAIRYPLAN DP5 used for feed calculations etc The weight will also be added to the Component Test table Any value in TestDim is assumed to refer to the current lactation TestDate may be used to import prior lactations Measured averages code MPWgt etc Data import requires the I option The file send date is assumed unless the MPDat figure is included in the record The weight will be added to the Measured Averages table Reminder braces are NOT part of the ADIS standard Multiple records are preferred Refer to section 3 6 7 Page 32 DAIRYPLA ISO and or DII Code Description Form DAIRYPLAN DP5 Notes NDDI Taurus DDI at Number Number 4221 Base for several DP5 functions like feed calculation etc Is recalculated when new milk weights arrived See in DPSingle Component Tests sheet This accesses the obsolete Component Test Table in DAIRYPLAN DPS for official Test Day milk amounts Import does not require I option however the I option makes DPDataExchange also reset the average milk in 24 hours TestDIM Test Day Days in Milk obsolete 900032 Testdate Date for Test Day obsolete AMDAT 14 E PESI MPWgt Plot Point Mil
18. about the data dictionary items you should also look into the online help file about report codes The items are identified there by their mnemonics A list of available report codes of your current DAIRYPLAN version can always be created by defining a report with columns DD_Number DD_Mnemonic DD_Desc 4 3 1 Basic Setup Information These items are generally used for ADIS header records But they may be used at any time as normal data DAIRYPLA ISO and or DII Code Description DAIRYPLAN DP5 Notes NDDI Taurus DDI Number Number 0001 00000000 ddtype Data Dictionary Type As per the ADIS protocol description this field is required to distinguish between different kinds of data dictionaries DPDataExchange always exports DD This is ignored for data import 1013 900006 sender Sender of the file A24 Forimport 00201681 900008 version Version number of 00201684 sender s software O ISO Data Dictionar 1015 900009 ADED_Nat Version number of the A8 to IN Tee _ 1016 900002 ADED Ma Version number of the A8 n Maufacturer Specific Data Dictionary T ET ET PP 00201575 00201576 m E receiver data 0000 in all cases 1002 options DAIRYPLAN DP5 DPDataExchange exports a purchase options string abcdefghik where a kare 1 or O a data exchange b feed c milk d special Selection e large herd option f DPMobil g Extra1 DPHit in Ger h Extra2 P is Demo 7160 9001
19. and time of milking appear on each record Data Import A date figure must be given IMDIM imdat or DMDIM may be used A new table entry is made if the date time or weight is different than an old entry If IMTIM is used it must appear before IMWT IMTIM is required for automatic recalculation of lactation totals Multiple records are recommended but braces may be used Data export To create multiple records use a search record specifying any of these codes as the search condition Reminder braces are NOT part of the ADIS standard Multiple records are preferred Refer to section 3 6 7 Page 32 DAIRYPLA ISO and or DII Code Description DAIRYPLAN DP5 Notes NDDI Taurus DDI Number Number 4104 900042 IMWt Individual Milk Weight F 4 1 From DSingle Milk 00200488 Measurements table 4102 IMFIg Individual Milk Error Flag 11 Calculated from DAIRYPLAN DP5 error codes according to DII standard O no error 1 manual identification 2 calculated estimate 3 entered by user 4 equipment error 5 incorrect number of milkings for daily totals 4101 900054 IMDat Date for individual milking D8 This or the DIM is required 00201729 for data import of past data 4103 IMDim Days in milk at time of 14 Calculated from the date of individual milking milking in the measurements table This may also be used to synchronize data import of milk weights 7160 9001 516 11 2003 45 4105 I Mim Last Time required to
20. convert the file then you oad it Once you or a professional programmer have made a proper setup for the type of data you wish to load you can create a batch file to accomplish both steps with a single command ASCTODII can convert text files with the following characteristics 1 The text file must be in data column format where each column has the same meaning in every line If your file has various line types see section 2 4 3 page 77 2 Each data column must be either a the exact same size or b separated with a comma semicolon or tab character 3 Data for one animal is on just one line 7160 9001 516 11 2003 73 4 The animal number or registration number appears in every line If your file does not meet these requirements you must write a customized conversion program Refer to section 2 page 9 5 3 Running ASCTODIl The ASCTODII program is included with the normal DAIRYPLAN DP5 CD installation You do not need to install the development disk to follow these instructions 1 Open a DOS box or start it with the Task Bars Execute Command 2 Type ASCTODII filename then Enter A file extension TXT is assumed unless otherwise specified Wildcards ie A PRN may be used You may optionally specify a setup file and an output file as well Refer to section 2 4 1 page 76 3 The first 20 lines of the file will be displayed on the screen along with an overlapping window with some qu
21. ignored by DPDataExchange F Do not confuse this with the lower case f flag record See section 4 3 5 page 25 I Include file this loads another DII file then returns to the original file Include files may be nested up to three levels HDI files are automatically treated as include files when a header record is read This is not a standard DII record but DPDataExchange will recognize it in either file type For this reason both upper and lower case I is accepted I lt status gt lt path filename gt 7160 9001 516 11 2003 24 O Output file name this directs any output into a file with this name This record must appear before any request error or mirror records which are to be sent to the file A single input file can create multiple output files by specifying different files for different requests This is not a standard DII record but DPDataExchange will recognize it in either file type For this reason both upper and lower case O is accepted O lt status gt lt path filename gt T Terminate record This is defined in the ADIS protocol as marking the end of a logical block It is ignored by DPDataExchange TN Z Physical end of file This stops all further processing of the particular physical file being read In the case of an include file or hardware io device processing returns to the higher level file This is not required by DPDataExchange ZN 3 3 5 Manufacturer specific records f Flag contro
22. in DP by art Wee Figs cote 12 As sn Menton III old Milking Illness code As sent to Metatron aa Pe 00201895 Met old Milking Isolation Code 11 metis 4413 Gen old Milking General Code 14 4421 I stim Stimulation Time Me al ae li le ee ef re ae dle de di 4 3 12 Feed Data Caution is advised when transferring feed data because of possible differences in hardware design 7160 9001 516 11 2003 53 Data Import assumes DAIRYPLAN DP5 feed one unless a another feed type is specified in the record or block or b braces are used to repeat blocks of several feed types Data Export use FDTYPE as a search index to get multiple records refering to different feed types It is also possible to use braces to get the feed types in a repeated block on one record Reminder braces are NOT part of the ADIS standard Multiple records are preferred Refer to section 3 6 7 Page 32 DAIRYPLA ISO and or DII Code Description DAIRYPLAN DP5 Notes NDDI Taurus DDI Number Number 7101 900067 FDTYPE Feed Type Identifier This is the feed type number 00201859 1 2 3 or 4 This must be used as an index for proper data import 7102 FDNAME Feed Type Name EXPORT ONLY The name of the feed in the bin number connected to the lowest numbered feed stall available to this 7103 00201828 24 hour feed ration The daily feed ration may be entered directly or calculated by DP see Allocation in DPS
23. mnemonic code system may be used regardless of the file format F Refer to section 4 3 4 page 21 for the programming syntax used to construct identifiers 4 1 Scope of various Data Dictionaries 4 1 1 ADIS Numbers The ADIS protocol allows great flexibility in the use of various data dictionary schemes There are two principal data dictionary systems DD and ID The dairy industry has agreed to use the DD method ID is used more with CAN bus mobile equipment The DAIRYPLAN DPS data dictionary uses own manufacturer specific data item numbers four digits with four leading zeroes As long as matching the DP5 data international ISO numbers see ISO 11788 2 are also implemented six digits beginning with 9 Whenever possible this version of DPDataExchange also implements numbers assigned by the TAURUS standard interface version 2 0 These always consist of two leading zeroes followed by a six digit DD number DD numbers beginning with four zeroes 0000 are manufacturer specific and may be changed to standardized numbers over time Furthermore the TAURUS Standard Interface has not been approved by ISO as of this writing Therefore some of these definitions may change as well However WestfaliaSurge will make every effort to keep item numbers from older versions alive 7160 9001 516 11 2003 35 4 1 2 DII Codes Upper case are publicly defined in the DII Protocol document these can be expected to re
24. need only implement the particular formats needed and ignore the rest 1 1 4 Which protocol to use For customers receiving data from other sources DPDataExchange will automatically switch between ADIS and DII For system developers ADIS should be used whenever possible because of it s international endorsement 1 1 5 Modems diskettes and other hardware The ADIS and DII protocols do not specify any particular physical media You must make arrangements with your Dairy Records Processing Center to either a exchange diskettes by mail in this case you need only know the name of the file to read from the diskette or b exchange the files by modem in this case you must use a communications program Your DRPC may provide this or at least recommend a terminal program as provided by standard Microsoft TM Windows or c exchange the files via Internet e g as a E Mail attachment or Upload Download Ask your DRPC how they deal with it Be aware if you put the text into the E Mail itself the data may be spoilt because of line wrapping 1 1 6 Scheduling monthly data transfers In a fully automated traditional system the following transfers would occur Before Test Day 1 The processing center provides the farm with an ADIS request file for breeding and other information traditionally filled out on barn sheets This file could be mailed on a diskette or sent by modem or Internet 2 The dairyman processes this file
25. or DII Code Description DAIRYPLAN DP5 Notes NDDI Taurus DDI Number Number DMWT Daily Milk Weight S EXPORT ONLY Calculated from individual milk weights in the measurements table according to synchronized start date of whol eherd 4202 DMFLG Daily Milk Weight Error 11 EXPORT ONLY Same error 7160 9001 516 11 2003 47 codes as for individual milk weights or 5 to indicate an incorrect number of milkings Daily Milk Days in Milk Days from calving to synchronized start date see above For import this may be used to set the date for individual milkings Last Actual 24 Hour Milk EXPORT ONLY Calculated Total from individual milk weights in the measurements table Is the 24h value according to the cows actual last milking date 4 3 8 Averages and Test Day Milk Amounts DAIRYPLAN DP5 makes extensive use of a field called average daily milk for feed calculations and other things This field exists one for each animal and can be accessed with code Avmlk DAIRYPLAN DPS also periodically saves this figure in a table for plotting lactation curves the so called Measured Averages Systems with Metatron milk meters automatically recalculate the average daily milk every time a milk weight is received Non Meter systems must use the latest test day yield instead Beginning with version 4 4 DAIRYPLAN DP5 keeps two separate tables for milk Measured Averages actually recorded through o
26. the current version of DAIRYPLAN DP5 Official totals are only useful if Dairy Plan is set to store individual milk weights for an entire lactation Use DPSIZE to increase the milk weight table size as needed Furthermore lactation data is calculated each time a new milk weight arrives and stored in an extra data table to be seen in DPSingle sheet Lactations Data Import the current lactation is assumed unless the lactation start date PDCalve 6101 calving date 00200042 or lactation number LactNo 00002007 is included as an index The calving date is the best index with an exact date prior lactation data can be imported correctly in every case With the lactation number for an index data will be loaded correctly if a the current lactation number is already set correctly and b all calving dates have already been entered for the animal Most lactation data import requires I option Since version 5 020 the use of lactno as index field for import of lactation data is fully supported Data export data from the current lactation is shown unless a the calving date or any of these items is used as a search condition in which case multiple records will be produced for various lactations or b braces are used to make repeated blocks for each lactation In both cases the L option is required Reminder braces are NOT part of the ADIS standard Multiple records are preferred Refer to section 3 6 7 Page
27. this and allow the data file to change the default precision shown in the table Note that DAIRYPLAN DP5 cannot always actually use all the decimal places shown they are sometimes just shown for file compatibility Refer to additional comments under integer fields above 4 2 4 Date Format Both ADIS and DII specify that dates are to be in 8 digit format as CCYYMMDD ie 17 November 1992 is shown as 19921117 DPDataExchange will also accept a six digit format without the century Any other width will produce an error message The precision must be shown as 0 for ADIS files 4 2 5 Time Format ADIS specifies times as six digits showing HHMMSS as in 5 32 59 PM as 173259 ADIS specifies times as four digits showing HHMM as in 1732 DPDataExchange will accept either format Any other length will produce an error The precision must be shown as 0 NOTE DAIRYPLAN DPS does not generally keep times to the second In most cases the number of seconds is ignored For output DPDataExchange will fill the seconds with zeros 4 3 Topical List of Codes First column DAIRYPLAN DP DDI Numbers Only last 4 digits written fill with leading zeroes 7160 9001 516 11 2003 37 Second Column for ISO and or Taurus DDI Number ISO numbers ISO 11788 2 have digit 9 in the 3 place Data created by an RFA report or by ADIS requests is very similar except for the outer appearance of the data format Therefore for a detailed information
28. to separate logical sections of an ADIS file ON This sets the name for an ADIS output file we wish to create with a request a little later SN This sets up a search condition for the request coming up next We want to search for animals with a responder number between 1000 and 2000 We specify item 00900096 with a width of 04 and precision 0 Then we set the low value as 1000 and the high value as 2000 RN Now we make the request We want to know 0090 0070 06 0 the animal number 0090 0096 04 0 the responder number DPDataExchange will make a file containing this information in this format in response to our request ZN This marks the end of the file Any follwing lines would be ignored 7160 9001 516 11 2003 11 2 3 A BASIC Language Programming Example The following sample program example bas is on the DPDataExchange development diskette to show how a BASIC program can make an ADIS file 100 REM Open ADIS File 110 REM 120 OPEN O 1 EXAMPLE ADS 130 REM 140 REM Header Definition Record 150 REM 160 PRINT 1 DH000000000000000800020168124000201575080 170 REM 180 REM Header Value Record with sending date 190 REM 200 INPUT Enter Test Date CCYYMMDD gt D 210 PRINT 220 D RIGHT 00000000 D 8 230 PRINT 1 VH000000DD BASIC SAMPLE PROGRAM 240 REM 250 REM Data Definition Record 260 REM 270 PRINT 1 DN0000000020189606000005101041002000530420020005404200005154050
29. ucost2 2913 ucost3 2921 uword1 User defined words 1 3 A 15 2922 uword2 2923 uword3 2931 i User defined numbers 1 9 W 2932 2939 4 3 14 Formatting Fields These are intended to aid in the readability of DII files They are export only however the usual screen warning message is suppressed during import See also the D option section 3 2 2 page 17 DAIRYPLA ISO and or DII Code Description DAIRYPLAN DP5 Notes NDDI Taurus DDI Number Number spaces 9992 c Comma Creates a left justified column with one comma 9993 q Quotation marks Creates a left justified column with a double quotation mark 4 4 Numeric List of Codes This chart lists all ADIS numbers which DPDataExchange is programmed to recognize For a fuller explanation of the context refer to online help file about report codes and to the sections above For the current data dictionary please view a report with DPList with the columns DD Number DD_Mnemonic DD Desc 7160 9001 516 11 2003 55 All numbers are subject to change in future versions However WestfaliaSurge will make every effort to keep these numbers valid as long as possible DDI number DII code Description Reference DDI DII Code Description Reference Num 1 DD Data Dictionary Type Header 97 Result Previous Summary Result Formula 98 Line Printed Line Number Formula 99 Unknown Used for unknown Fields Formula 100 Text Export Text xyz Formula 101 Constant 0
30. 0 and higher w unrec w no longer supported in version 5 0 and higher I O File Command Records w repeat no longer supported in version 5 0 and higher w eof This exits immediately from DPDataExchange Since 5 0 it does no longer return to the next higher include file level if you are nested in an Include statement w exit This exits immediately from DPDataExchange Process Control Interface Records No longer supported since version 5 0 3 4 Status Characters The ADIS format reguires the use of Status Characters to designate different kinds of data The status character always occupies the second position of each record DII format records are always considered to be of Normal status 7160 9001 516 11 2003 28 3 4 1 H for Header Data ADIS Header lines are intended to provide basic information about the sender and intended receiver of the file They follow the ADIS syntax in other respects the header begins with a definition and is followed by a value line Such lines are not intended to actually send something just to say hello and set up some version info and maybe options DPDataExchange treats definition and data lines with a status H as header data 1 The user is not asked whether header data should be processed DPDataExchange always processes data in a header record without asking 2 Animal data is not allowed If present in a header record Animal data will not be processed The ADIS pro
31. 002 2003 2004 2005 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2021 2022 2023 2024 2025 2026 2027 2028 2030 2031 2091 2101 2102 2103 2104 2105 2106 2107 Sender Version ADED_ISO ADED_Nat ADED_Man Receiver HerdCode Supervis FeedStartTime DairyName LMk Date LMk Time LMk UnknownRe LMk_RepeatlD LFStartDate NumMeters NumFeeders NumGateScales NumParlorSide Cow Reg1 Name TDCDat LHDat LactNo Al NI Sire Dam Bd PurDt Pur Rais Mark Vet Tins Gp PStr Resp Pos AiCost GpCow Notes CRNum Resp4 RespDup Reg11sISO Reg2 AAA Class PlanSir1 PlanSir2 PlanSirP Stat 7160 9001 516 11 2003 Sender Program Manufacturer Text 5 016 ADED version ISO standard ADED version National ADED version manufacturer Sender Program Manufacturer Herd Code Supervisor Code Feed Cycle Start Time Dairy Name Last Milking Date any animal Last Milking Time any animal Last Milking Count unknown r Last Milking Count animals iden Feed Cycle Start Date Milk Meters Total feed stations Number Selection Scale Units Number parlor sides Animal Number Registration number Name Life Data Change Date Left Herd Date Lactation Number Total Al s Needed Al s Sire Dam Breed Herd Entry Purchase Date Purchase Price Cost of Raising Market Value Vet Cost Total Inseminations and Estim Group Number Permanent String Number Responder Num
32. 0530420020005404200005154050 n while 1 ask for animal numbr printf nEnter Animal Number 0 to exit gt scanf ld amp cow if cow lt OL break ask for data printf Enter Milk Amount gt scanf 1f amp milk printf Enter Percent Fat gt scanf 1f amp pfat printf Enter Percent Protein gt scanf 1f amp ppro printf Enter Somatic Cell Count in thousands gt scanf 1 amp scc write data record fprintf outf VN000000 61d 4 0 4 0 4 0 5 0f n cow milk 10 0 pfat 100 0 ppro 100 0 scc write end records fprintf outf TN n fprintf outf ZN n close file fclose outf 2 5 A more complex conversion program The DPDataExchange development disk contains source code for the C program ADR C This is an example of one way to make a relatively complex ASCII to ADIS conversion program This program converts a former data file format ADR Satzarten used in Germany by the LKV Landeskontrollverband To run this program from the command line enter ADR ADR TXT This produces file ADR ADS File ADR ADS differs from the ADIS standard in that it contains value records with different event numbers in mixed up order DPDataExchange can load such files but if another program cannot handle this the S flag can be used to use strict mode In this case ADR will put in a new definition line each
33. 22 bircom2 Often used to describe where calf stays after birth dir Tri cel aa 900028 CLVDAT Calving Date D8 The calving date can also be 00200042 used as an index for data import of past lactations clvtime Calving Time T6 clvoffc Calving Official Code 14 Number citech Calving Technician AS y O civcost CalvingCost_ F8 2 O clvcom Calving Comment A 15 Often used to describe the way of the birth es Be Calving Diagnosis Flag clvcom2 Calving Comment2 A 15 Often used to describe where calf stays after birth ea ss 900055 HTODAT Heat Observation Date 00201743 eee htotech Heat Observation 3 O ARE L I 3133 Ihtocost Heat Observation Cost F82 htocom Heat Observation A15 Fe ee htodiag Heat Observation 11 fe dd eee Sd 3136 Ihtotime Heat Observation Time T6 htooffc Heat Observation Official 14 Pc ee i htocom2 Heat Observation A 15 900030 SRVDAT Service Insemination D8 00200050 Date 3144 900076 srvcom Service Insemination A 15 This is saved in 00200672 or Sire DAIRYPLAN DPS in srvsire comment 1 about the 7160 9001 516 11 2003 42 ia EE il 22 fO insemination O 3142 900095 srvtech Service Technician Ss AS 3143 srvcost Service Cost F 6 2 This includes semen cost and cost of labor 3145 srvdiag Service Result 11 1 service caused pregnancy O service failed eee srvtime Service Time TOS y O 3147 srvof
34. 3 MkpHAlrm Pedo PedoAvg PedoSd PedoDev PedoSdD PedoShow PedoHigh PedoLow PedoAlrm FloAvAvg FloAvSd FloAvDev FloAvSdD FloAvSho FloAvHigh FloAvLow FloAvAlrm FloMxAvg FloMxSd FloMxDev FloMxSdD FloMxSho FloMxHigh FloMxLow FloMxAlrm Cond CondAvg CondSd CondDev CondSdD CondShow Milk Per Hour Alarm Activity 24 Hour Equivalent Activity Average Value Activity Standard Deviation Activity Deviation from Mean Activity Standardized Deviati Activity Deviation Activity Highest Deviation Activity Lowest Deviation Activity Alarm Avg Flow Average Value Avg Flow Standard Deviation Avg Flow Deviation from Mean Avg Flow Standardized Deviati Avg Flow Deviation Average Flow Highest Deviatio Average Flow Lowest Deviation Average Flow Alarm Max Flow Average Value Max Flow Standard Deviation Max Flow Deviation from Mean Max Flow Standardized Deviati Max Flow Deviation Maximum Flow Highest Deviatio Maximum Flow Lowest Deviation Maximum Flow Alarm Conductivity Value Conductivity Average Value Conductivity Standard Deviat Conductivity Deviation from Conductivity Standardized De Conductivity Deviation 64 Analysis General Milking Analysis General Activity Analysis General Activity Analysis General Activity Analysis General Activity Analysis General Activity Analysis General Activity Analysis General Activity Analysis General Activity Analysis G
35. 7 MPF8 MPF9 GroupNum GroupName GroupMkPDay GroupMinMkint GroupLastMilk GroupLastCoun GroupTotalMil GroupTotalDat GroupCount GroupInsem GroupPreg GroupFirstTim GroupLastTime GroupHours GroupAiTot GroupAilndex GroupNonRetCt GroupNonRetRa GroupHadInsem FedTpNum FedTpName FedTpBin FedTpCost FedTpDrink FedTpMaxDay FedTpMaxlnt FedTpMinInt FedTpRoll FedTpintTot FedTplntReg 7160 9001 516 11 2003 Feed Ration Current Feed Consumed Recommended Feed Ration Feed Remainder yesterday Current Feed Unavailable Current Feed Available Feed Remainder Prev Day Feed Remainder 2 days ago Current Feed Remainder Feed Measurement Date Feed Measurement Time Measurement Visit Count Measurement Visit Duration Measurement total remainder Measurement Feed n consume Plot Point Feed One Plot Point Feed Two Plot Point Feed Three Plot Point Feed 4 Plot Point Feed 5 Plot Point Feed 6 Plot Point Feed 7 Plot Point Feed 8 Plot Point Feed 9 Group Number Name for group Number Milkings per Day Minimum Milk Interval Total Milk Last Milking Number of Animals Milked Total Milk Since Start Date Start Date for Total Number Animals in Group Number Animals Inseminated Number Animals Pregnant Time First Animal Milked Time Last Animal Milked Duration of Milking Hours Group Total Al s Group Insemination Index Group non return count preg Group non return rate preg f Number Animals had an inseminati Feed T
36. AttachTim ActMilkGroup MSt Dev Temp ReattachCount ReattachSec DMWt DMFIg DMDim DMWtCal DMCntCal AvMIk AvMIkC AcMIk MilkCh24 MilkCp24 FCM MIkSum AvMikMeth PeakMilk PeakDate PeakDim PeakChg PeakWPC MkOnDate YrMkDate MkDim MilkChg MilkWPC MkLWPC MkDIMEx MkDIMEx1 MkLWPCEx AMIKS1 AMIkS2 7160 9001 516 11 2003 Individual Milk Code Measurement Average Flow Rat Measurement Maximum Flow Rat Individual Milk Duration Seconds until IM ID Time IM ID Date IM Milker Atta IM Milker Atta Measurement Measurement Measurement Measurement Measurement Measurement start of Milk F ch Time ch Date Temperature Conductivity All Conductivity 1 Conductivity 2 Conductivity 3 Conductivity 4 Last Average Flow Rate Last Maximum Flow Rate IM ID Time IM Milker Attach Time Actual Group Milked With Last Milking stall number Deviation from expected milk Temperature IM Reattach Count IM Reattach Pause Seconds Daily Milk Weight Daily Milk DII Error Flag Daily Milk DIM Daily Milk Weight Calendar Daily Milk Calendar Count Average daily milk Average Milk for last n day Last Actual 24 Hour Milk Tota Milk Change Last 24 hours Milk Change Last 24 hours Fat corrected Milk Milk Yield Sum last n days Average Milk Method n Peak Milk Amount Peak Milk Date Peak Milk DIM Milk Average Change Per Day S Weekly Percent Change Since P Estimate Milk On Date Instant Proj
37. DAIRYPLAN DP5 keeps a count of the number of male female and dead calves This is converted into a code as follows O none 1 male 2 female 6621 number of dead calves Export Only sum of dead male and female calves 6622 DFC Number dead heifers born old ria DMC Number dead bulls born old bulldead 4 3 11 Special Milk Meter Data These are all manufacturer specific codes for special research applications Refer to DAIRYPLAN DP5 manuals for details Some codes refer to the most recent milking only the animal number is required for an index Some refer to individual milk weights animal number milk date and time are required as an index For more fields see general list of codes items 4101 4124 All may be imported or exported DAIRYPLA ISO and or DII Code Description DAIRYPLAN DP5 Notes NDDI Taurus DDI Number Number IT ITT 4107 900068 IMStall Milking Stall Metatron 13 This is from individual milk 14112 _ 900062__ IMMxFlow MaximumMikFlow___ F41 __ 4114 IMStartSec Seconds until Begin of 14 PE ee 14119 900043 IMTemp Temperature La Dh ig eee 4137 Mst Last Milking stall number 13 These items are stored 4139 Temp Temperature F4 1 as Last Milking data 4401 ______ hlddt Treated Date hold milk D8 key Milk Data table They 4402 hidtm_ Treated Time hold milk T4 canalsobeset_ 4403 Le Treated Restart Date D8 automatically
38. ExpectedheatDate D8 y O 2312 900021 RCDry Recommened Date to D8 turn dry 7160 9001 516 11 2003 43 3341 900093 SrvCount Number of inseminations a Em 3101 vetdate vet action date These codes allow general 3102 vettech vet action technician veterinary records TE Fe eege 3104 vetcom vet action comment 1 A 15 For export they will show all vet actions entered vetdiag vet diagnosis Note that the official vettime vet action time code number is taken from each individual vetoffc vet action official code animal s records NOT the number default in setup vetcom2 vet action comment 2 3109 vetname vet action name For data import the date is required as always but also the name OR official code is required as described e 3201 vetdatef future vet action date The general purpose future p Ire e DA 13206 vettimef future vet action time T6 work similarly tothe 3207 vetoffcf future vet action official 14 real codes described above ETC er ee 13209 vetnamef future vetactionname A15 future vet actions Se Ef 4 3 4 Sire Information These fields are provided for development purposes only it is likely that new fields will be established in the future for sending complete sire records in data blocks containing only sire information For this version two sets of codes are defined one for service sires and the other for the animal s genetic sire In both cases the data is retrieved
39. Formula 102 Formula Formula Formula 103 Date Date Formula 104 Time Time Formula 105 Number Number Formula 106 YesNo Yes no Formula 111 Max Maximum of Formula 113 Min Minimum of Formula 114 MinNZ Minimum non zero of Formula 115 Avg Average of Formula 116 AvgNZ Average non zero of Formula 118 CountNZ Count non zero of Formula 131 If If Formula 132 Map Map Values Formula 133 TextLength Length of Text Formula 134 TextlsDigits Text is Only Digits Formula 135 TextlsISOReg Text is ISO Registration comp Formula 136 TextHasBlanks Text has empty spaces Formula 901 DD Number Data Dict Number DD 902 DD_Mnemonic Data Dict Mnemonic DD 903 DD Desc Data Dict Description DD 904 DD Width Data Dict Width DD 905 DD IndexDD Data Dict IndexDD DD 906 DD ParentDD Data Dict ParentDD DD 907 DD Priority Data Dict Priority DD 908 DD Precision Data Dict Precision DD 909 DD_UserArea Data Dict User Area DD 910 DD Hidden Data Dict Hidden Code DD 931 DDS_Number Data Sub Number DD 932 DDS_Mnemonic Data Sub Mnemonic DD 933 DDS_Replace Data Sub Original DD DD 1001 Units Units of Measure Header 1002 Options User Options Header 1011 FileDate File Date Header 1012 FileTime File Time Header 7160 9001 516 11 2003 56 1013 1014 1015 1016 1017 1018 1101 1102 1103 1104 1211 1212 1221 1222 1223 1301 1302 1303 1304 2001 2
40. I returns to DOS leaving instructions on the screen as to how you should run DPDataExchange to finish loading the data Refer to section 1 2 page 5 If you press Y ASCTODII will create a batch file for you to make this process easier for you next time around In this case you will be asked for Batch File Name Enter here the name of the command you would like to enter each time you wish to load this data Input Specification Normally this is just the name of the text file you are converting But you may enter something else such as a wildcard like A PRN In this case your batch file will make ASCTODII bring up a directory of files from your floppy disk each time 7160 9001 516 11 2003 75 Automate ASCTODII When you enter Yes the Auto option is used to make the data conversion run without asking you any questions You can always run ASCTODII again yourself if you need to change something Automate DPDataExchange Enter Yes to also run DPDataExchange with the Auto option This will load all of your animal data without asking you any questions This is not recommended unless you are very confident that you have all setup questions exactly right 8 ASCTODII is now finished and exits To actually finish loading this information into DAIRYPLAN DP5 you must now run the DPDataExchange program You can do this either by running DPDataExchange yourself Refer to section 1 2 page 5 Or by entering the name of the batch
41. II data in the file and do any other tasks specified in the file for example create a return file in answer to requests 1 2 2 When DPDataExchange may be run In principle DPDataExchange can be run at any time but to avoid any side effects better you do it between milkings if you have automatic milk meters 1 2 3 Error handling If DPDataExchange detects a problem an error message appears showing the data block which is currently processed Press Stop to abort DPDataExchange or any other key to ignore the error and attempt to continue With the K option DPDataExchange aborts automatically without waiting for you to press a key DPDataExchange will also place comments about the error into the output file DPDataExchange ADS if none other is specified DPDataExchange may also place a fault record into the output file so the sender can respond automatically if the sender has such a capability 1 2 4 Importing animals which are not in DAIRYPLAN DP5 You are warned if a animal you are importing has not been previously entered in DAIRYPLAN DP5 As usual you can answer Yes No No To All to refuse loading or Stop to exit the program Yes To All will automatically load all animals even if they are new to DAIRYPLAN DP5 This allows an entire herd to be easily loaded using DPDataExchange 1 2 5 Generating output files DPDataExchange will respond to any request and search commands in an ADS file by generating a new ADS outpu
42. N DP5 Notes NDDI Taurus DDI Number Number 4501 MsPedHr Pedometer steps per F 5 1 These values come directly old hour from the Activity pedohour Measurements table in 4502 MsPedVI Pedometer counter DPSingle Measurements old reading Until further notice they are Li Kg only S DO ona emang e recording a recording FF Ve Fe Ee Equivalent export only Further 4543 PedoAvg Activity Average Value statistical values see DDI numbers 4544 4550 in 7160 9001 516 11 2003 46 I PedoAlrm Activity Alarm 14 general list of DDI Items ar ae es Dad Sede ili 2125 900039 MsBdyDat Body Weight These values come directly Measurement Date from the Body Weight Measurements table in 2126 900050 MsBdyTim Body Weight DPSingle Measurements Measurement Time Until further notice they are export only 2127 900040 MsBody Measurement Body Weight ERESSE 4 3 7 Daily Milk Totals Daily milk totals refer to the sum of individual milk weights for one 24 hour period A day begins and ends according to the following logic DAIRYPLAN DPS looks at the last milk weight recorded of the animal for synchronized milk amount as with DMWT it looks at the very last milk weight of any animal in the database It determines which milk session she was milked in according to the times entered in the DAIRYPLAN DP5 main milk schedule If the milking is not within a milking time it the next following mil
43. WestfaliaSurge REGISTER 16 Instruction Manual 7160 9001 516 11 2003 DAIRYPLAN DPDataExchange Data Exchange Program for Transferring Information to and from WestfaliaSurge s DAIRYPLAN DP5 System using the ADIS and or DII Protocols ADIS is the Agricultural Data Interchange Syntax given by ISO 11787 The international Data Dictionary is defined in ISO 11788 DII is the Dairy Information Interchange protocol recommended by the Milking Machine Manufacturers Council of the United States of America Printed in F R Germany Table of Contents 7 Using DPDa taExchange a ieri 3 Re EE 3 1 2 R nning DPDataExchange i 3 05 irrita RR E 5 2 Writing a Customized Conversion Program Woman 9 2 1 Development Disk Installation iii 9 22 ne ERT 10 2 3 A BASIC Language Programming Example sans 12 2 4 A C Language Programming Example i 12 2 5 A more complex conversion program i 13 3 DPDataExchange Technical Reference oom mom 15 4 1 Matching Special Fields AAA 15 4 2 DPDataExchange Options aan aah 16 4 3 Command Records sian a Aa 20 4 4 Status Charachers iii 28 4S Event Numbers Lig lea lei oretta tali 30 4 6 Variations from the ADIS and DII standards iii 30 e Br Ko ANTEE te A E Lila iii an 34 4 Data DICtO EE 35 5 1 Scope of various Data Diciionares i 35 RE en EE 36 5 3 Topical List of Codes ae liana os ee ees he Ae ee 37 5 4
44. a table in DAIRYPLAN DP5 It is possible to have multiple entries for all events which creates special problems for DPDataExchange For data import the DATE must be included as an index in any block containing vet related data Information can be loaded in any order and may pertain to the entire lifetime of the animal 7160 9001 516 11 2003 40 If the general codes are used 00003101 00003109 either the name or the official code is also required When the name is used it must exactly match a vet action name already entered into the DP setup in other words already appearing on list Vet Action To Enter in DPVet When an official code number is used it must fall within a default range of values set up for a vet action If the number is in the range of more than one vet action the action with the narrowest range will be used For example suppose DPDataExchange receives the following DN000000COW 4 vetdate 8 vetoffc 4 VN000000 10019931028 412 that is cow 100 vet official code 412 on October 28 1993 Now suppose DAIRYPLAN DP5 was set up with the following vet actions vet action namedefault number number range Illness 400 499 Mastitis 410 419 that is code numbers 400 499 are all illnesses and codes 410 419 are types of Mastitis DPDataExchange would recognize 412 as Mastitis because the range is smaller Now suppose another illness number 437 is Berstromis Desease but is not specifically entered int
45. al General Process Control General Process Control General Process Control General Process Control General Process Control General Process Control Feed Feed 2202 2203 2299 2301 2302 2303 2304 2305 2306 2308 2309 2311 2312 2314 2316 2317 2319 2320 2322 2325 2326 2327 2329 2330 2401 2402 2403 2404 2405 2901 2902 2903 2911 2912 2913 2921 2922 2923 2931 2932 2933 2934 2935 2936 2937 2938 2939 3101 3102 3103 3104 3105 3106 3107 St StDirect RespISO Age AgeM AgeD DIM ExpHeat HT BrDat FiDim DTDry RcDry DYP DTC Due Cl CIMonth AgeClv Opn OpC OpP DyD DyDLast DamReg1 DamName DamBd DamDam DamSire UD1 UD2 UD3 UC1 UC2 UC3 UWord1 UWord2 UWord3 UN1 UN2 UN3 UN4 UNS UN6 UN7 UN8 UNI VetDat VetTech VetCost VetCom VetDiag VetTime VetOffC 7160 9001 516 11 2003 Status Code Status Code ISO Responder Age in years Age in months Age in Days Days In Milk Expected Heat Date Expected days to heat Breeding Date Days in Milk at First Insemin Days Until Dry Recommended Dry Date Days Pregnant Expected Days until Calving Expected Calving date Calving Interval Days Calving Interval Months Age at calving Days Open Days Open DIM for cows not i Days Open DIM for cows not c Days Dry Days Dry Last Lactation Dam s registration number Dam s name Dam s breed Dam s dam Dam s sire User defined Date 1 User defined Da
46. al Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Illness Analysis General Illness Analysis General Conductivity Analysis General Conductivity Analysis Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental 4711 4712 4713 4714 4721 4722 4723 4724 4751 4752 4753 4754 4755 4756 4757 4758 4759 4760 4761 4762 4763 4764 4765 4766 4767 4768 4769 4770 4771 4772 4773 4774 7160 9001 516 11 2003 CwRobTemp1 CwRobTemp2 CwRobTemp3 CwRobTemp4 CwRobFlow1 CwRobFlow2 CwRobFlow3 CwRobFlow4 CwRobCondDur CwRobTeatMiss CwMisattach CwRobFlowMiss CwRobCond1 CwRobCond2 CwRobCond3 CwRobCond4 CwRobCondAvg CwRobCondOK CwRobMReach CwRobFlush CwRobA Tries CwRobMDur1 CwRobMDur2 CwRobMDur3 CwRobMDur4 CwRobATime CwRobBIExit CwRobBHeight CwRobBTime CwRobFamil CwRobMaxDur CwRobMedDur Leonardo Quarter Temperature Leonardo Quarter Temperature Leonardo Quarter Temperature Leonardo Quarter Temperature Leonardo Milk Flow Missing on Quarter Leonardo Milk Flow Missing on Quarter Leonardo Milk Flow Missing on Quarter Leonardo Milk Flow Mi
47. ange int auto mode with automatic exit on error In the future some of these may be adopted by all manufacturers as public options It is also possible to use a Westfalia Command Record of w options AK 3 2 1 Options Controlling User Interaction A f auto 1 Auto mode without asking This will automatically import all animals from all blocks in the file including animals not previously entered in DAIRYPLAN DP5 This must be used with care to prevent accidentally loading the wrong data The user is still warned of possible errors unless E or K is also used K f errexit 1 7160 9001 516 11 2003 16 E Q 3 2 2 Options U S C D Kill program on error with this option DPDataExchange will exit to DOS upon finding any error The PC will sound a warning and the program will terminate with a DOS errorlevel code f errok 1 Errors accepted with this option DPDataExchange will attempt to ignore all errors The error message will be displayed briefly then processing will continue This is designed for unattended remote control systems f auto 0 Query mode this overrides previously set auto answers to again ask for user confirmation Controlling File Format f dii 1 USA or DII mode this option forces DPDataExchange to use the DII protocol in preference to ADIS DPDataExchange can read either ADIS or DII files regardless of this flag setting But this does have the following eff
48. ant within a single file Default setting is on DPDataExchange will always produce multiple records when this is necessary to fulfill specific search requirements See section 4 3 4 page 23 f heifer 1 Abandoned with 5 0 version restrict via search restriction on lactation number f arcmode 1 Archive mode normally DPDataExchange does not include archived animals in searches With this flag set DPDataExchange will search all animals including archive animals f freesrch 1 Free search of daily milk data Abandoned with version 5 0 Use different fields for milk data synchonized to last milk date of whole herd dmwt field for milk of last 24h or milk data for individual animal acmlk actual milk last 24h f general 1 Abandoned General data is repeated with indexed data Normally when exporting vet records or other indexed fields output lines using a non zero index show question marks for any fields with non indexed data for example the group or responder numbers This clearly tells the receiver that the requested data is not known for the date indicated in theory another program might save the group or responder numbers as entered at that time With the G option non indexed fields are always exported f charansi 0 Introduced with version 5 018 7160 9001 516 11 2003 19 Since version 5 018 export and import can use special Characters with ASCII numbers gt 127 in text fields If you want
49. as many data sections or data blocks in the file as you like A request section has a request to get data back out from DAIRYPLAN DP5 to return to the sender Again you may have as many requests as you wish in a single file This is what each line is doing Line 1 Line 2 Line 3 Line 4 Lines 5 14 Line 15 Line 16 Line 17 Line 18 Line 19 DH This is the definition for the file header The event number or entity number is 0 and then data column codes are given as 0000 0000 08 0 for the Data Dictionary Type 0090 0006 24 0 the file sender 0090 0008 08 0 the sender s program version 0090 0003 08 0 the file date 0090 0004 06 0 the file time F refer to section 4 3 4 page 21 for more information on definition records and data column codes VH This is the Value record for the file Header Each data field is filled out according to the item numbers and widths specified CN This is a Comment and has no effect on the data transfer DN This is a Definition of Normal data The 6 digit event number is again zero Then four data columns are defined 0090 0070 06 0 the animal number 0090 0045 12 0 the name 0090 0033 02 0 the group number 0000 2108 02 0 the type of the animal animal sex VN These lines contain data for 10 animals in the column format specified by the definition record TN This is a termination record This is optional but is often used
50. ata to be imported will be displayed on the screen and you will have an opportunity to decide whether it should be loaded You are first asked if you wish to load the data block then each individual animal If the animal numbers are not yet included in the data set you will be asked if you want them to be created Second some animal data will be requested and written to the file SampleAnswer ads Refer to section 1 2 page 5 for basic instructions on running DPDataExchange File SAMPLE ADS from the DPDataExchange development looks like this DH0000000000000008000900006240009000080800090000308000900004060 VH000000DD Westfalia DP5 5 017 20010112102200 CN This is a sample ADIS file for DAIRYPLAN DP5 CN Load Animal Data Animal Number Name Group Type DN00000000900070060009000451200090003302000002108010 7001Suzie 7F 7002Bossie 3F 7003Bessie 3F 7004Leslie 7F 7005Fredrika 9F 7006Cutie 7F 7007Jamie 2F 7008Frizzy 1F 7009Bella 10F 7010Sheri 1F Request Animal Data Animal Number Responder for all Animals with a Responder between 1000 and 2000 into the given Output File SampleAnswer ads SN0000000090009604010002000 RN0000000090007006000900096040 This sample file has three sections The header section must come first in all ADIS files This identifies the sender 7160 9001 516 11 2003 10 A data section has a definition record and value records The 10 value records here have data for ten animals You may place
51. ataExchange is limited in the kinds of data it can delete in this way Remember many DAIRYPLAN DPS data fields can be corrected simply by overwriting them with new data If DPDataExchange is not able to delete the record an error message appears and a fault record is written to the output file This status can be used to delete animals from the system as follows specify definition and value records with D status showing the animal number only DPDataExchange will ask the user to confirm then delete the entire animal record It is also possible to delete veterinary data inseminations calvings birthdates as well as illnesses In this case specify definition and value records with the animal number plus the date of the action are required Other information is ignored Note that the entire vet action record is deleted Westfalia command records can also be used to delete entire animal records Refer to section 4 3 5 1 page 26 3 5 Event Numbers ADIS allows individual records to be associated with an event number For example these event numbers can be used by a particular organization to denote particular actions ie number one is for calvings number 2 is for inseminations etc Event numbers are not used by DPDataExchange to denote any fixed meaning But they will be handled as follows 1 Answers to a request will contain the same event number as the request 2 Event numbers in Value lines must match the D
52. ber Stanchion Barn Position Misc Breeding Costs Group String Animal Animal Notepad dairyplan 5 Record Number Responder Number Animal with Duplicate Respond Registration is ISO format Second Registration Animal Analysis Classification Score Service Sire Choice 1 Service Sire Choice 2 Service Sire for problems Status Word 57 Header Header Header Header Header Header Setup Setup Setup Setup Setup Setup Setup Setup Setup Setup Setup Setup Setup General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General 2108 2109 2110 2112 2113 2114 2115 2121 2122 2123 2125 2126 2127 2131 2132 2133 2134 2135 2141 2142 2144 2145 2147 2148 2149 2160 2161 2162 2163 2164 2165 2180 2181 2182 2183 2184 2190 2191 2192 Typ DamBN LHReas BloodLin Breedr Buyer StatEn Body AvBdy BdWtDate MsBdyDat MsBdyTim MsBody FVC FVCA FVT FVSec FVMin DVC DVCA DVSec DVMin DrSpeed DrSpeedA DrSpeedD Growth LGrowth BodyDown DownDate DownDim BodyAvgL GateD G1 G2 G3 G4 SelCount MsSelCount SelCountAvg 7160 9001 516 11 2003 Animal Type Dam Barn Number Left Herd Reason
53. ble to write a customized conversion program using a programming language such as Basic or C Refer to section 2 page 9 5 4 4 DST File Organization ASCTODII creates a setup file with your answers to the questions This will be used next time you convert a file with the same name The setup file is named DST unless you specify otherwise on the command line This setup file is itself an ASCII file and you may change it with a word processor if necessary ASCTODII responds to DST file records as follows 7160 9001 516 11 2003 78 H Contains header data for the DII file to be produced D Contains a shortened form of the definition record usually without field widths unless you have specified them with a user defined option tis Shows the last line before data text tie Shows the first line after data text t p Shows the data line identification text t w Shows the column widths in the ASCII file not the new DII file t c 1 Tells ASCTODII to use comma delimited format t d n Tells ASCTODII which date format to use All other letters in the first column will be copied into the new DII file This allows you to specify user defined fields and or perform other special functions with DPDataExchange 7160 9001 516 11 2003 79 6 ANNEX B Release Notes 6 1 Release Notes Updating 4 4 DOS DPLINK to 5 020 DPDataExchange 10 11 12 13 14 Import of milk data option I and existence of Metatron i
54. considered unrecognized The width shown is simply the length The precision is meaningless for alpha fields and is not shown on the code tables But be advised that the ADIS standard requires you to show a precision of 0 for alpha fields If DPDataExchange cannot fit alphanumeric data in a character field it is truncated to fit without warning 4 2 2 Numeric Integer Format Codes using an I format in the following tables are numbers without a decimal place These may contain only digits 0 9 space or the or for undefined unrecognized fields 7160 9001 516 11 2003 36 The width shown is the maximum number of digits The precision must be shown as zero for ADIS files NOTE The DII protocol states that numeric fields must be zero filled ie PSTR 2 of 3 must be shown as 03 ADIS allows leading spaces DPDataExchange accepts either and produces output according to the file type If DPDataExchange cannot fit data in a number field it is considered undefined and an error message is issued 4 2 3 Numeric Floating Format Codes using an F format in the following tables are numbers with an assumed decimal place which is not actually in the data file The number of assumed places is shown in the tables ie F 4 2 is a number with 4 digits total assuming two decimal places A data value of 1234 would be interpreted as 12 34 For ADIS files the precision must always be shown with each code DPDataExchange will check
55. cs plansir2 Planned Sire Choice 2 In DPSingle Genetics 2106 plansirp Plannedsireforproblems A15 In DPSingle Genetics 2013__ 900034 purdat Purchase Date _____ DB In DPSingle identification _ 2014 purcst Purchase Price 2 In DPSingle Genetics 2004 TDCDAT Tombstone Data ee Life Data Change Date in date Br Identification 2005 900038 LHDAT Left herddate Leftherd date _ D8 in DPSingle Identification 2110 900081 Ihreas Left herd reason See DPSingle Identification A specific code scheme is j na u not required in DAIRYPLAN DP5 Use a code scheme appropriate for the Data Records Processing Center See DPSingle Identification animal status allowed values none calf bcalf heifr fresh early abort ready open insem preg preg2 dry lead other tbcull cull Is translated for each languages Status Word in English English Names of animal states independant of language in setup None Calf BCalf Heifr Fresh Early Abort Ready Open Bred Preg Preg2 Dry Lead User DNB Cull 2202 900092 Status Code Numerical encoding language independent 0 None 1 Calf 2 BCalf 3 Heifr 4 Fresh 5 Early 6 Abort 7 Ready 8 Open 9 Bred Inseminated 10 Preg 11 Preg2 12 Dry 13 Lead 14 User 15 DNB DoNotBred ToBeCulled 16 Cull i a 4 3 3 Vet and Insemination Data All vet and breeding data is stored in
56. ct 8324 MeterTotDur 8325 MeterRolMEr 8326 MeterRolld 8327 MeterCondFact 8331 MeterAvgMilk 8332 MeterAvgDur 8333 MeterDevPerc 8401 GateNum 8403 GateChip 8411 GateNumDoors 7160 9001 516 11 2003 Total feed dispensed yesterda Total feed dispensed so far Expected days until bin empty Stall Number Transceiver Chip Version Feed Stall Type Number Last Feed Stall Visit Time Feed Type at this Motor Feed Type at this Motor Feed Type at this Motor Feed Type at this Motor Feed Type at this Motor Feed Type at this Motor Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Total dispensed feed today Feed Stall description Stall Number Metatron Type Chip Version Chip Setup Checksum Neuron ID Count No ID Count Manual ID Count Auto ID Count all milk weights ID Percentage last milking Total all milk last milking Total predicted milk Total actual milk for known Duration Total Rolling Avg milk error perce Rolling Avg ID Percentage Conductivity Correction Facto Avg Milk each milking Avg Duration each milking Avg Deviation from exp
57. data value records to be anywhere after the definition Event numbers are used to match the data value record with the corresponding definition This means different kinds of data value records can be in mixed order so long as unique event numbers are used for each definition 7160 9001 516 11 2003 22 E End record This has slightly different meanings for ADIS and DII For ADIS this marks the end of a file for DII this marks the end of a data block In the DII case it shows a count which is compared with the number of records actually read Since DPDataExchange allows new headers at any time an ADIS End record is ignored ADIS style EN DII style E lt count gt lt checksum gt count a 4 digit count of the number of records read in the preceding data block checksum as required for all DII records C Comment record These records contain free text DPDataExchange displays the last comment record containing text while operations proceed C lt text gt S Search record This tells DPDataExchange which animals to list when answering a reguest This also has the effect of forcing DPDataExchange to search through a specific DAIRYPLAN DP5 data table such as the vet records milk measurements plotting averages etc When processing a request record with a specific search DPDataExchange may produce multiple records for one animal if more than one table entry matches the search conditions Refer to specific field descrip
58. ds w command as shown in examples w westfa command F Note DPDataExchange version 2 0 also allowed use of the lower case letter z for control records This is no longer recommended because of potential confusion with the ADIS Z record In the future other methods may be adopted in place of these General Command Records w version X Y Use this command to reduce future compatibility problems A version number x y higher than the actual DPDataExchange program version will produce an error message thus you are assured that customers have version x y or later Also in future versions of DPDataExchange this command is planned to set any changed field names back to the version x y equivalent names w options AK Set DPDataExchange options A and K Any option can be set exactly as on the command line Note the flag control record is generally a preferred method of setting options See section 3 2 page 16 w delete 203 Delete animal number 203 from DAIRYPLAN DP5 In current versions it is not possible to delete animals using the D line status See section 4 4 5 page 30 w delnotch No longer supported since version 5 0 w unlink filename Not yet implemented in version 5 0 or higher This command deletes filename from the disk The purpose is to allow systems to automatically dispose of old files Definition Command Records 7160 9001 516 11 2003 26 w create 00123456 mnen num 1 desc Creates a DPDataExchange field
59. ds Generally these records are more accurate than other test procedures 7160 9001 516 11 2003 7 Therefore for systems with meters DPDataExchange will prevent importing data which can be calculated better with Metatron data These are for example lactation totals and the current daily average milk weight The fields which cannot be imported are marked by a refuse sign in the import dialog However if you wish to load them anyways use the I option For example use the I option to transfer test records maintained before the Metatrons were installed Specific fields which are affected are noted in the field descriptions part of this manual 1 2 9 Importing Projected Milk Totals WestfaliaSurge s DAIRYPLAN DP5 software can make several 305 day milk projections However we recognize that DRP centers can perform more accurate projections Therefore DAIRYPLAN DP5 versions 4 1 and later include a mechanism for overriding the internal projections with projections made by outside sources These can be set by importing M305P F305P P305P and MEQUIV The I option is not required 1 2 10 Importing Individual Milk Weights DPDataExchange allows transferring individual milk weight data to and from DAIRYPLAN DP5 This allows transfer of milk meter data from any manufacturer using the ADIS or DII protocols To import milk weights a individual milking date field must be in the transfer file so DPDataExchange can record the data A mil
60. e done automatically DII also has a more advanced level it is possible for one DII file to ask questions and get properly formatted answers in a second file Again this automates the process of sending information back to your records processing center they can ask for exactly what they need and DPDataExchange can automatically create the required file without need to design reports or any other complex procedure 1 1 2 The ADIS Protocol ADIS is a logical extension of DII plus improvements based on other protocols ADIS was formally accepted by the International Standards Organization DPDataExchange versions 4 2 and 4 3 follow the ISO TC23 SC19 WG2 draft dated September 1991 approved as ISO DIS 11 787 ADIS in 1993 DPDataExchange is compatible with classes A B C and D 1 1 3 Why the ADIS DII Protocols are Necessary In the dairy industry more and more is a need to effectively automate data exchanges Around the world there are hundreds of organizations which may transfer data to or from your farm It would be prohibitively expensive for any company to write separate interface programs for all of them 7160 9001 516 11 2003 3 As the ADIS DII protocols comes into use they provide a way for equipment manufacturers to exchange data with a variety of organizations without special programming ADIS DII allows equipment manufacturers to meet other parties half way DPDataExchange does most of the work other organizations
61. e lifetime ABORT Days in milk for action ABORT Age on vet action date Individual Milk Date Individual Milk DII Error F Individual Milk DIM Individual Milk Weight Last Time required to milk Individual Milk Time Measurement Stall Number Individual Milk Code 61 Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements 4110 4111 4112 4113 4114 4115 4116 4117 4118 4119 4120 4121 4122 4123 4124 4131 4132 4133 4134 4135 4137 4138 4139 4141 4142 4201 4202 4203 4204 4205 4221 4222 4223 4224 4225 4227 4228 4229 4231 4232 4233 4234 4235 4241 4242 4243 4244 4245 4246 4251 4252 4253 4301 4302 IMCodeDesc IMAvFlo IMMxFlo IMDuration IMStartSec IMIDTime IMIDDate IMAttachTime IMAttachDate IMTemp MsCondA MsCond1 MsCond2 MsCond3 MsCond4 AvFlo MxFlo LastIDTime Last
62. ected Herd Averag Average Daily Milk at n DIM Milk Average Change Per Day Milk Weekly Percent Change Milk WPC since lact start Avg Milk on exact DIM Avg Milk on exact DIM 1st la Milk Lact WPC on exact DIM Average Milk from Session One Average Milk from Session Two 62 Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements General Last Milking General Last Milking General Last Milking General Last Milking General Last Milking General Last Milking General Last Milking General Last Milking General Last Milking General Last Milking General General General General General General General General General General General General General General General General General General General General General General General General General General General General General nn 4303 4304 4309 4311 4312 4313 4314 4315 4316 4317 4318 4351 4352 4401 4402 4403 4404 4411 4412 4413 4414 4421 4431 4432 4433 4434 4435 4436 4437 4438 4439 4451 4452 4461 4462 4463 4464 4465 4501 4502 4503 4504 4521 4523 4524 4525 4526 4527 4528 4529 AMIkS3 AMIkS4 AvgNumMilkDay MD2 MS2 MS3 IMinterval MtM MinSinMilk
63. ected m Selection Scale Number gt Chip Version Number of Doors Connected 71 Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Meter Setup Selection Setup Selection Setup Selection Setup 8501 8502 8503 8504 8505 8506 8507 8508 8509 8510 8601 8602 8603 8604 8605 9101 9102 9103 9104 9105 9106 9107 9108 9109 9110 9111 9112 9113 9114 9115 9116 9117 9118 9119 9120 9121 9122 9123 9124 9125 9126 9127 9128 9151 9152 9153 9154 9201 9202 9203 9204 9205 9991 9992 ParSideNum ParSideMets ParSidelD ParSidelDChip ParSideVacTot ParSideVacDat ParSideVacOn ParSideVacOff ParSideVacHou ParSideStartT VetsDesc VetsCost VetsMetls VetsMetCode VetsCode SAlCode SReg SReg2 SName Sb SNote1 SNote2 SVendor SDam SSire SType STank SCost Slnv SSuc SFai SReo Pd Pdm Pdf Pdpf Pdp Pdpp Pdpr Pdt Pdtr Pcve Tpi SNe
64. ects a Running DPDataExchange without specifying a source filename extension will assume DII files rather than ADS b Output files will be created in DII format instead of ADIS f strict 1 Strict mode manufacturer specific control records and data fields are ignored Unrecognized data fields and control records are always ignored so it is normally possible to load data from any source without the S option However if you are having difficulty loading files which were not intended for WestfaliaSurge products try this option f nocheck 1 Checksums omitted with this option checksums are not required for DII input lines and not generated for DII output ADIS lines never use checksums f delim 1 Delimit fields The ADIS and DII standards do NOT separate data fields with commas Use the D option to insert commas between all fields for easier human reading As an alternative to the D option use the special formatting codes in section 5 3 13 page 55 these maintain ADIS DII file compatibility 7160 9001 516 11 2003 17 B f blankfil 1 Blank fill unrecognized fields Normally for a Dll style request an unsupported data field is filled with zeros With this option an unknown field is set to spaces ADIS style output files use the vertical bar for this purpose 3 2 3 Options Controlling Data Import l f init 1 Initialization mode Normally systems with Metatron milk meters should not import milk data
65. ed SSucP SFaiP StVal ASAiCode ASReg1 ASReg2 ASName ASBd s c 7160 9001 516 11 2003 Parlour Side Setup Metatrons on this Side ID Mode for this side Transceiver Chip Version Total Vacuum On Minutes Vacuum Hours Start Date Vacuum On Off Times Vacuum Off Time d Vacuum hours since start Milking Start Time Vacuum On Vet Action Name Cost of Action Milking Isolation Code Milking Sickness Code Default official code number Sire Al Code Number Sire Registration Number Sire Second Registration Sire Name Sire Breed Code Sire Note 1 Sire Note 2 Sire Vendor Sire s Dam Sire s Sire Sire Type Score Sire Tank Canister Sire Straw Ampule Cost Sire Straws on hand Sire Successes number Sire Failures number Sire Semen Reorder Level PD MONEY Value PDM Milk Amount PDF Fat Amount PD F Fat Percent PDP Protein amount PD P Protein percent PD R Production Repeatabili PDT Type Score PDT R Type Repeatability Calving Ease TPI Total Performance Inde Sire reorder have Sire percent success Sire percent failure Sire total straw value Sire Al Code Number Sire Registration Number Sire Second Registration Sire Name Sire Breed Code Text Text 72 Parlor Side Setup Parlor Side Setup Parlor Side Setup Parlor Side Setup Parlor Side Setup Parlor Side Setup Parlor Side Setup Parlor Side Setup Parlor Side Setup Parlor Side Setup Vet Setup Vet Setup Vet Setup Vet Setup Vet Setup
66. efinition 3 With DPDataExchange event numbers may be used to allow Value lines in any order not just immediately following the definition However note that the ADIS protocol states they must be in the correct order so be advised that some other programs may not read such files correctly 4 DII format records are treated as having an event number of zero 3 6 Variations from the ADIS and DII standards 3 6 1 Header Records See section 4 3 4 page 21 7160 9001 516 11 2003 30 ADIS A DH and VH pair must be at the beginning of each ADIS file They are allowed only at the beginning or after an E record DH records must reset the communication parameters DII One H header record must appear at the beginning of the file DPDataExchange Input files may have header records anywhere in the file or they may be omitted Output files always have one header record at the beginning of the file even if several output files are created by a single request file A header will reset all flag settings as at when DPDataExchange was first run to original command line options 3 6 2 Comment Records See section 4 3 4 page 23 ADIS Specifies that comments must have a status code as in CN Comments are permitted anywhere DII The standard does not specify whether a colon is required and whether comments are permitted between request and search records The standard clearly states that a checksum is not required
67. eneral Activity Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Milk Flow Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis 4608 4609 4610 4623 4624 4625 4626 4627 4628 4629 4630 4661 4662 4663 4664 4671 4672 4673 4674 4681 4682 4683 4684 4685 4686 4687 4688 4691 4692 4693 4694 4701 4702 4703 CondHigh CondLow CondAlrm BodyAvg BodySd BodyDev BodySdD BodyShow BodyHigh BodyLow BodyAlrm CondAvgQ1 CondAvgQ2 CondAvgQ3 CondAvgQ4 CondSdDQ1 CondSdDQ2 CondSdDQ3 CondSdDQ4 CondAvgQLow CondAvgQLowNu CondQHigh CondQHighNum CondQDev CondQHigh24 CondQHighNum2 CondQDev24 AlarmCnt AlarmPts MCSDD CondDiff CwRobDate CwRobTime CwRobCoord 7160 9001 516 11 2003 Conductivity Highest Deviati Conductivity Lowest Deviatio Conductivity Alar
68. er requests containing data from several different DAIRYPLAN DP5 tables may produce illogical results See section 4 2 4 page 18 3 6 13 Data Field Order ADIS Fields may be in any order DII A numeric field must be first SDII Data records must begin with a digit 0 9 DPDataExchange DII Style data records must start with a digit or V ADIS style records always begin with V lt status gt lt event number gt Either type can have fields in any order 3 6 14 Maximum Sizes ADIS Minimum 256 byte record size allowance DII No restrictions on sizes DPDataExchange Maximum 512 characters in one record maximum 99 fields in one definition maximum 50 definitions in one file maximum 4 search conditions for one request 3 7 Error Messages lt refer to DAIRYPLAN ERROR NUMBER LIST gt 7160 9001 516 11 2003 34 4 Data Dictionary A Data Dictionary lists items of data which programs recognize as valid In principal the sender and receiver must always agree upon the exact meaning of each piece of data As of this writing a formal ISO proposal for a data dictionary is in the early stages of development There are also several regional standards Therefore it is imperative that sending and receiving parties review all definitions for consistency DPDataExchange can use HDI files to map internally defined numbers to external sources Refer to page 16 With DPDataExchange either the ADIS number system or the DII
69. es directly from a diskette or hard disk subdirectory If you require a data conversion program Enter programname where programname is the complete command needed to load your data Your DRPC or program developer must tell you this command The command may be more than one word or perhaps a batch file Your conversion program may take some time to convert your files and then it will run DPDataExchange with the converted file F for instructions on making data conversions see section 5 page 73 You will be shown data from the file Press the button with the exclamation mark to start the processing A dialog pops up showing the fields to be imported Yes Yes load this information into DAIRYPLAN DP5 You will be asked subesequently for each record line if you want to load the data No No do not load this information continue displaying the next record definition 7160 9001 516 11 2003 5 Yes To All Automatically accept all records if you answer this to a block question all blocks in the file will be loaded without further user intervention If you answer this to load an individual animal only animals in that block will be loaded automatically No To All This block an all data lines for it will not be loaded Stop Exit from the program Note all data imported prior to pressing ESC will stillbe in the file there is no way to undo the import except to restore an old backup 4 DPDataExchange will load any ADIS or D
70. estions Send Organization Enter a six letter abbreviation for the organization which created the data file Send Date Enter the test date for this information the program automatically assumes the file creation date Metric Units Enter yes if the information is in kg no for Ib This also may affect the way calendar dates are entered as described below Date Format Choose one of the following date formats 0 same as 2 with Metric set to Yes otherwise as 1 1 MM DD YY or MMDDYY or MMDDCCYY USA 2 DD MM YY or DDMMYY or MMDDCCYY Europe 3 YY MM DD or YYMMDD or CCYYMMDD ADIS Last line before data Enter the first few words of text in the file just BEFORE the data you wish to actually load Leave blank to start loading at the beginning of the file First line after data Enter the first few words of text in the file just AFTER the last line of data you wish to actually load Leave blank to load through the end of the file NOTE if the start line appears again after the end line ASCTODII will begin converting the data again 7160 9001 516 11 2003 74 Data line identification If each line of data begins with a special word or number enter it here For example if your data file contains several different line record types you may use this to separate one particular line Then run ASCTODII again to get data from another line type etc Comma Delimited Enter Yes if the file uses commas to separa
71. etup information for special header fields Refer to section 4 1 4 page 16 D Definition record this tells DPDataExchange what data is coming This is accomplished by listing Data dictionary codes and field widths ADIS and DII use different methods of presenting these codes DPDataExchange can read either method or a combination The ADIS form requires an event number Then follow for each field the field s DDI number its length two digits and its precision one digit D lt event gt lt DDI no gt lt field length gt lt precision gt DII format must end in semicolon D lt event gt lt DDI no gt lt field length gt lt precision gt DDI no Either the 8 digit data dictionary number from ADIS or the DII mnemonic If the DDI no is not exactly 8 characters the backslash must follow Leading spaces are counted as leading zeroes 7160 9001 516 11 2003 21 field length The length must be included for both ADIS and DII protocols If the field length specification is not exactly 2 digits ie _1 or 01 to 99 a period or comma must follow for DII A leading space is treated as a leading zero precision The number of implied decimal places is required for ADIS but optional for DII It can be only one digit 0 9 If it is not included a comma must follow A DDl no or mnemonic must be specified for each item of data which will be sent Data Dictionary codes in ADIS and DII The DII style is xxx L R Tha
72. f sample programs and files for people interested in writing ADIS file conversion programs These are included in the DPDataExchange Development directory on the DP5 installation CD Copy them into the DAIRYPLAN directory of your PC 2 1 1 System Requirements DPDataExchange requires WestfaliaSurge s DAIRYPLAN DP5 version 5 017 or higher The dairyman must be familiar with the management program prior to using DPDataExchange If automated feeding and milking equipment is installed it must be fully operational for one month before using DPDataExchange Otherwise expecially the re calculation of average data may lead to unpredictable results 2 1 2 Installation NOTE The programs DPDataExchange and ASCTODII are included with the normal DAIRYPLAN DP5 CD You do not need to install more unless you require other special files Copy the entire DPDataExchange development files into the subdirectory with a DAIRYPLAN DP5 demo program 7160 9001 516 11 2003 9 2 2 A Sample ADIS file DPDataExchange is run in the subdirectory containing DAIRYPLAN DP5 Either you specify the transfer file name on the command line or you open the file after calling DPDatExchange The ADS extension is assumed by default EXAMPLE Type DPDataExchange SAMPLE then Enter in a DOS Box opened on the DAIRYPLAN directory DPDataExchange will read file SAMPLE ADS Press the Button with the exclamation mark to start processing the file The d
73. f the U and other flag settings Records with a colon in the second position or beginning with a digit are assumed to be in the DII format All other records are always assumed to be in ADIS format ADIS and DII records may be intermixed in the same file 3 3 4 ADIS and DII Public records Record descriptions are shown in ADIS form However all records can be processed using either the ADIS or DII conventions as described above unless otherwise noted H Header record tells the receiver basic information about the sender This is defined in the DII protocol only ADIS does not define a header record instead special item numbers are used to transfer similar data with an H status But DPDataExchange will accept this record in the ADIS format as HHdata where data is the same block of data as the DII header record H lt status gt lt manufacturer gt lt version gt lt herd gt lt date gt lt units gt lt supervisor gt manufacturer 6 character abbreviation of sender version 4 character version of sender herd 8 character herd code date 8 digit date for file units 2 character either kg or Ib supervisor 4 digit supervisor code may be zero For DPDataExchange header records are optional and may appear anywhere in the file The information is displayed on the screen All options are reset to as at program startup Immediately after loading a header record DPDataExchange checks if to load any HDI files with s
74. fc Service Official Code 14 EN e Fee E EE A5 b Ea eae DEE 3151 900059 PRGDAT Pregnancy Diagnosis Date cow was checked not Ber Date Sa date of insemination 3152 900091 prgtech Pregnancy Diagnosis A3 Technician dC ZZ a i Cost Poco me AS i Comment Diagnosis O not pregnant F 8 2 11 3156 prgtime Pregnancy Check Time Ire 3157 prgoffc Pregnancy Check Official 14 3158 Prgcom2 Pregnancy Check A15 lr aa ee ee ee 3161 900044 DRYDAT Dry Treatment Date SE 3162 dryech Drytechnician Lan __ 3163 dryoost DryCost Ee 3164 drycom DryComment TANS __ 3165 drydiag Dry Diagnosis LI ee 3166 drytime Dry Time T6 3167 dryoffc Dry Official Code Number 14 3168 drycom2 Dry Check Comment 2 A15 3171 abtdat Abortion Date D8 3172 abttech Abortion Technician Ia 3173 abtcost AbortionCost ____ F82 3174 abtcom Abortion Comment A15 13175 Jabtdiag Abortion Diagnosis 1 13176 labttime AbortionTime rei ee Li Number 3178 abtcom2 _ Abortion Comment 2 la Cor di isso SEE 3129 CLVDATP Projected Calving Date These are entered as Future vet actions in DP Ng Eat not normally used 3139 HTODATP Projected Heat Date D8 y O 3149 SRVDATP Projected Planned Service Insemination eg ra AA 3159 PRGDATP Projected Planned O Pregnancy Check e O 3169 DRYDATP Projected Planned Dry 2305 900049 ExpHeat
75. feMc LifeFc This tells DPDataExchange to treat any reference to 123456 as the formula LifeMc LifeFc Parenthesis are not always necessary but recommended for formula usage The example here calculates the number of living calves from the number of living male and living female calves w define Event NewCode ExistingCode This is a variation of the define command which defines a code to be used only for a particular event number It is allowed to define multiple interpretations of NewCode for various event numbers This is called an Event Scope Definition As an example consider this file w define myfield name w define 1234 myfield resp w define 4321 myfield avmlk RN cow myfield RN001234 cow myfield RN004321 cow myfield 7160 9001 516 11 2003 27 The first define creates a global definition which applies to any event number for which you do not create an event specific definition The first request would list the animal number and the name the second request the animal and responder numbers the third the animal number and average milk amount w decimal PFAT 1 no longer supported in version 5 0 and higher w undef xxx Undefine DPDataExchange field symbol xxx either ADIS number or DII code With version 5 0 or higher until further notice the field remains undefined until DPDataExchange is restarted even if several different ADIS files are to be processed w defrec X f no longer supported in version 5
76. file you made in step 6 after changing its call of old DPLink exe to DPDataExchange exe 5 4 Special options u 5 4 1 Command Line Options The general command form is A Available options are sing ASCTODII SCTODII textfile setupfile outputfile options A This option may be used to automatically skip the setup questions The conversion is performed immediately using a previously defined setup file After conversion the program exits D This option makes ASC TODII ask for the Send Test Date even in automatic mode This allows date sensitive material to be transferred automatically with just one question to be answered B Batch mode bypasses the procedure to make a new batch file K This option will force ASCTODII to exit on errors 7160 9001 516 11 2003 76 5 4 2 Specifying the width and precision If you select user defined as the field name for a column you are asked to specify the code yourself Any DII or ADIS code may be entered It may be the same as a standard item or your own Be advised however that DPDataExchange will not recognize other codes without special preparation Refer to section 3 1 page 15 for information on how to create your own special fields in DAIRYPLAN DP5 and DPDataExchange After the code you may optionally enter the output column width by using a backslash To specify the precision use a period followed by the number of implied decimal places The same precision mus
77. from DAIRYPLAN DP5 s sire file by looking up the appropriate animal according to the animal s records The Sire access mode entered in DAIRYPLAN DP5 determines what method is used to look up the data name ai code registration etc All items are Export Only in this version DAIRYPLA ISO and or DII Code Description DAIRYPLAN DP5 Notes NDDI Taurus DDI Number Number TU UE i antre information entered 9102 ssregl Service Sire Registration A 15 in DAIRYPLAN DP5 s Sire Number One functions for the animal entered as the cow s mt TA Number Two DPSingle Genetics i E rare E ST recently bred to the 9105 ssbd Service Sire Breed Code A1 cow unless an earlier breeding is known to have caused the pregnancy Use the code SRVSIRE to see the data used as an index for codes 7160 9001 516 11 2003 44 See 8 re information entered in 9202 asreg1 Animal Sire Registration A 15 DAIRYPLAN DP5 s Sire Number One functions for the animal entered as the cow s sire Number Two the data used as an 9205 asbd Animal Sire breed code index for these codes 4 3 5 Individual Milk Weights Individual milk weight data refers to a single milking normally from Metatron milk meters Itis possible to manually enter milk weights from the parlor or from the computer but in both cases a flag is set to assist in recording official test data Multiple records may be used to send or receive historical data so long as both the date
78. her way Reminder braces are NOT part of the ADIS standard Multiple records are preferred Refer to section 3 6 7 Page 32 DAIRYPLA ISO and or DII Code Description DAIRYPLAN DP5 Notes NDDI Taurus DDI Number Number re 5151 900077 Fat Percent Fat Test F 5 2 All entries stored in the 00200053 old PI 3 a eg in 5152 900031 Prot old Percent Protein Test F 5 2 Component Test Table Lie Ja JL 5153 900048 Lact old Percent Lactose Test F 5 2 see the DPSingle sheet Import requires TestDate 15 F 4 1 4 5157 __ Score Body Condition Score Trail BZ ee asini assi EEE RS 5154 900047 Scc Actual Somatic Cell Count Both of these codes actually old in thousands use the same data field SCCACT within DAIRYPLAN e DP5 Use one or the other but not both 5155 900023 LNSCC Linear Somatic Cell Count EE FE A S 5201 900025 Sample Bottle Number Only the most recent sample bottle 5202 900024 sampbox Sample Bottle Box 14 information is saved in Number DAIRYPLAN DP5 5203 sampdat Sample Bottle entry date The entry date can be used to see if the number was correctly entered E Ss a ae E E e 5211 IMBarcode A 10 10digit Barcode composed from 3 fields in individual milk weights export only fr a _ _ IG 7160 9001 516 11 2003 50 4 3 10 Lactation Milk Totals Lactation data can be calculated from the milk weights stored in dividual milk weights this is called Official lactation data Note With
79. his would return as zero Default setting is on M f multrec 1 Multiple record output 7160 9001 516 11 2003 18 H R F G When processing a request record normally several records of one animal will be exported If you want only the last action to be exported switch off the multrec option Then only one record is produced per animal with the most recent data available If there is a search condition in front of the request always multiple records will be exported if available With this option switched on DPDataExchange may create multiple records for one animal even without a specific search record However there is one side effect all vet data in the output record reflects the search index used to find the valid data This is to insure for example that SRVSIRE will match the SRVDAT for multiple breedings Occasionally this can cause unexpected results if the requested data record has vet data of several types For example if the second breeding meets the search and preg test dates are also requested in the same output record the preg test shown will also be the second preg test for the cow Of course in all cases the data will be accurate it is the output sequence which may be affected In light of this it is best to use requests with data relating to a single event For example do not mix calving and insemination data in the same request record Remember you can make as many different requests as you w
80. ield 6401 F305P sheet Lactations Use braces or search with CLVDAT to access past lactations See DPSingle sheet Lactations This is the number of days included in total to date calculations IMPORT REQUIRES I OPTION These are recalculated daily as milk weights are recorded IMPORT REQUIRES I OPTION These are DAIRYPLAN DP5 s best estimates of milk meter data These fields the number of DIM indicated IMPORT REQUIRES I OPTION ESSE For export These are DAIRYPLAN DP5 s projections unless actual figures are known 6402 P305P Projected 305 day protein yield 6500 FCME old Vue Projected mature equivalent fat corrected milk yield equivalent milk yield External mature e milk yield External 305 Milk M305E Gg Calculation F305E External 305 Fat al External 305 Protein Calculation nm old calfid 900097 ara 6505 6510 ID number of calf Registration number of calf pt ID number of second twin calf Calf2 old calfid2 For import these are saved as an external estimate which will override DAIRYPLAN DP5 s own estimates unless the actual figure is known In DAIRYPLAN DP5 calf data is saved in the lactation records CalfReg2 Registration number of ee HE d second twin calf rr 900037 calfsex calfsex2 sex of calf 6611 sex of second twin calf 7160 9001 516 11 2003 52
81. ields do not save time in seconds 3 6 5 Requests for unsupported fields ADIS Specifies that unsupported fields should be filled with vertical bars as in DII The DII standard does not specify how programs should respond to requests for unsupported data fields DPDataExchange Fills all ADIS files with vertical bars For DII files an unsupported field is filled with zeros by default but with the B option fields can be blank space filled 3 6 6 Multiple Search Conditions see section 4 3 4 page 23 ADIS Specifies that multiple search conditions may be specified on one record or with multiple records DII Does not allow multiple search conditions DPDataExchange Requires multiple records for multiple search conditions See explanation in section 4 3 4 page 24 3 6 7 Brace Use See Definition Record section 4 3 4 page 21 ADIS Does not allow brace use for repeated blocks must send multiple records instead DII Specifies brace use but does not specify which fields may have multiple values and does not address nesting DPDataExchange Allows braces to send receive multiple values wherever possible Also allows multiple records When a request or definition specifies more values than DPDataExchange can handle the field is treated as unknown Nested braces are significant for individual milk weight data only SDII Shows brace index number for up to 99 items at one level or 9 items at two nested levels 3 6
82. ilable In such cases an error code of 4 is used for any incorrect daily totals For individual weights a zero milk weight with error code 2 is reported 3 6 12 Scope of Searches see section 4 3 4 page 23 7160 9001 516 11 2003 33 The problem What should happen if there are events both before and after the upper limit search date And what about animals meeting the search limits more than once For example suppose there is a search for cows bred between Jan 1 and Jan 31 What should happen to the cow bred Jan 15 and Feb 6 What about the cow bred Jan 5 and Jan 27 ADIS The protocol document states that searches will be handled in an implementation dependent manner Multiple records can be issued when appropriate DII The standard says a single field refers to the most recent event by default it does not address the issue of previous events and searches For multiple events repeated fields may be used by specifying related items in a block with braces DPDataExchange DPDataExchange will search all vet and milk records for any search on vet or milk data so long as a search record is used to indicate which table to search Multiple records may be produced for one animal if more than one event matches the search criterion With the M option DPDataExchange will also produce multiple records without a specific search In this case DPDataExchange analyses the data requested and guesses which data tables may be appropriate Howev
83. ingle u CFC Current Feed Consumed old sheet Feed FDCONS 7105 Recm Recommended Feed old fdrec Ration 7115 NCFERo F7 3 7106 900063 Rem Feed Remainder F7 3 Feed Remainder from the 00201831 old last completed day fdrem Day ago DEE Yesterday 7119 900061 Ate yesterday lr e N e i WEE E E For data import this takes effect at the next hourly interval Amount eaten today For import this is saved as the Recommended feed for 24 hours in DPSingle sheet Feed These entries take effect after the user confirms them by running the Edit feed amounts for all animals function 4 3 13 User defined fields 7160 9001 516 11 2003 54 These can be find in DPSingle sheet User Defined and may be used for any purpose both for import and export Items are generally accessed by entering a DII report code in DAIRYPLAN DP5 or by using the special w create command record They can also be changed in DPSetup Herd managment Uder defined Data However these codes can be used as long as another has not been defined for the field As soon as you enter an ADIS number or DII Code name to replace any of these items the numbers and codes below will not function DAIRYPLAN DPS Notes DAIRYPLA ISO and or DII Code Description NDDI Taurus DDI Number Number 2901 udat1 User defined dates 1 3 2902 udat2 2903 udat3 2911 ucost1 User defined costs 1 3 F 8 2 2912
84. ion Vet Action Vet Action Vet Action INSEMINATION Vet Action Comment Vet Action 1 INSEMINATION Vet Action Result Vet Action INSEMINATION Vet Action Time of D Vet Action INSEMINATION Vet Official Code Nu Vet Action INSEMINATION Vet Comment 2 Vet Action INSEMINATION Future Vet Action Da Vet Action PREG Vet Action Date PREG Vet Action Worker PREG Vet Action Cost PREG Vet Action Comment 1 PREG Vet Action Result PREG Vet Action Time of D PREG Vet Official Code Nu PREG Vet Comment 2 PREG Future Vet Action Da DRY Vet Action Date DRY Vet Action Worker DRY Vet Action Cost DRY Vet Action Comment DRY Vet Action Result DRY Vet Action Time of DRY Vet Official Code DRY Vet Comment 2 60 Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action 3169 3171 3172 3173 3174 3175 3176 3177 3178 3201 3206 3207 3209 3300 3301 3302 3303 3304 3311 3312 3313 3314 3321 3322 3323 3324 3331 3332 3333 3334 3341 3342 3343 3344 3351 3352 3353 3354 3361 3362 3363 3364 3371 3372 3373 3374 4101 4102 4103 4104 4105 4106 4107 4109 DryDatP AbtDat AbtTech AbtCost AbtCom AbtDiag AbtTime AbtOffC AbtCom2 VetDateF VetTimeF VetOffCF VetNameF VetFut VetCount VetCntLf VetDim VetAge BirCount BirCntLf BirDim BirAge ClvCount ClvCntLf C
85. k Weight F 4 1 These access the old from measured Measured Averages table MAMwt averages for true average milk Measured average milk amounts IMPORT old date REQUIRES I OPTION MAMDat LI Fr Weight Activity per Hour Average Flow Rate Measured Averages Maximum Flow Rate MPCondA Measured Averages Conductivity All Quarters Wu w CH 7160 9001 516 11 2003 49 4 3 9 Component and Somatic Cell Test Results Test Sample Numbers Fat Protein and Somatic Cell Count test results are treated much like Test Day milk weights DAIRYPLAN DP5 saves test results in the Component Test table Data import the table entry is made immediately on data import Data Import of historical data requires that the date be known used as an index This must be code TestDat Normally the test day milk amount is also loaded at the same time Multiple records or braces may be used to import multiple values Manually entered test data by the test components entry sheet will be stored in the same table Data Export all data records of the table will be shown Sample data like bottle and box number come up in 1 field per animal See DPSingle sheet Last Milking There are somem new fields prepared stored with individual milk weights IMBarcode composed from 3 user defined fields in an individual milk weight This data is automatically filled by DPLeonardo and cannot be imported in any ot
86. k weight received from DPDataExchange is treated exactly like a milk weight directly from a Metatron meter This means new averages and lactation totals will be calculated as described in the DAIRYPLAN DP5 user manual as long as a The time IMTim is specified b The date and time are later than the last known entry In difference to version 4 4 it is no longer necessary to specify at least 1 Metatron milk meter in the Parlor Setup Import is not possible without the I option Totals and avmlk will be recalculated always if imported date later than the last known entry 1 2 11 Using TDCDAT and LHDAT to control enrollments These special data fields are maintained by DAIRYPLAN DPS software to facilitate proper enrollment in external databases The TDC Date Tombstone Data Changed is changed in DAIRYPLAN DP5 each time the user enters a new animal or sire or changes the sire dam or registration numbers The LH Date Left herd is set when the user removes an animal from the active herd 7160 9001 516 11 2003 8 2 Writing a Customized Conversion Program This section is for professional computer programmers desiring to write an ADIS or DII format file conversion utility program Many files do not need customized programming Follow these instructions only as a last resort First try the ASCTODII program See section 5 page 73 2 1 Development SampleFiles Installation WestfaliaSurge has assembled a set o
87. king time is taken into account The 24 hour period then extends to the end time for the milk session determined above DMWT and related codes report milk amounts recorded up to 24 hours before this time With this definition of 24 hour milk it is theoretically possible to have an extra or missing milk weight if the milking times are irregular If there is an error in the number of milkings for a animal an error flag of 5 is reported with code DMFIg Otherwise the flag represents the highest numbered flag for any individual milking included in the sum Remember it is always possible to get the individual milking data with other codes For synchronized milk amount DMWT the first or only number reported for each animal is by default the same calendar date for every animal in the herd Use other codes like ACMLK to retrieve it animal specific The F option which made DMWT work like the new field ACMLK is no longer available since version 5 0 When multiple records or braces are used for multiple values the data blocks are always synchronized so that adjacent blocks are one day apart even if no data is available for some days Systems without Metatron milk meters always return zero All Items are EXPORT ONLY Multiple records may be issued if any of these items are used in a search record Reminder braces are NOT part ofthe ADIS standard Multiple records are preferred Refer to section 3 6 7 Page 32 DAIRYPLA ISO and
88. l General Milk Measurements Lactation Totals Lactation Totals Lactation Totals Lactation Totals General General General General General General 6138 6139 6141 6142 6148 6149 6150 6161 6162 6171 6172 6173 6174 6175 6176 6177 6178 6179 6201 6202 6203 6210 6211 6212 6216 6231 6232 6233 6241 6242 6251 6301 6302 6303 6310 6320 6325 6400 6401 6402 6403 6410 6411 6412 6421 6425 6426 6427 6431 6432 6433 6441 6500 6505 7160 9001 516 11 2003 Sum MC Sum Cst Sum MIk Sum Clf Sum MI Sum iInc Sum FeedT TMilk FTot1 FTot2 FTot3 FTot4 FTot5 FTot6 FTot7 FTot8 FTot9 LactF LactP LactM RTMIk MC FC CalfV FatAvg ProtAvg SccAvg FatAvgA ProtAvgA LDim F305 P305 M305 M100 M200 M365 M305P F305P P305P P305C M305E F305E P305E AnMilk LMErr M305100 MP305100 RHA RHA_Milk RHA_Days ExpToMilk FCME ME Sum of Misc Costs Sum of All Costs Sum of Milk Value Sum of Calf Value Sum of Misc Incomes Sum of All Incomes Sum of Income Expense Lact Total Feed Cost Lact Total Milk Value Lact Total Feed One Lact Total Feed Two Lact Total Feed Three Lactation Total Feed 4 Lactation Total Feed 5 Lactation Total Feed 6 Lactation Total Feed 7 Lactation Total Feed 8 Lactation Total Feed 9 Lact Total Fat Lact Total Protein Lact Total Milk Lact Roughage Total Milk Lact number male calves Lact number female calves Lact Calf Value Average Fat Test this
89. l record This control record can be used to set DPDataExchange options Any number of flags may be set with one record a value of 1 turns the flag on a value of 0 is the default or off action For example f life 1 multi 1 tells DPDataExchange to include lifetime history in multiple records for each animal Refer to section 3 2 page 16 for available flags F Do not confuse this with the upper case ADIS File command See section 4 3 4 page 24 NOTE as of this writing several DII committee members have expressed interest in making this a public record in the future If this occurs some other letter will replace f and some individual symbols will be replaced with upper case public equivalents p Pause record the contents of this record are displayed on the screen and the user is asked to press a key to continue He may also press ESC to exit DPDataExchange m Mirror record the contents of this record are sent to the output and for DII files a new checksum is calculated This can be used to automatically include comments or command records in the output file x Execute record no longer supported since version 5 0 7160 9001 516 11 2003 25 W Westfalia command record this is used to send specific commands to DPDataExchange as follows As of this writing it is not yet clear what method is best to send hardware commands using the DII protocol These versions of DPDataExchange support two metho
90. lvDim ClvAge HtOCount HtOCntLf HtODim HtOAge SrvCount SrvCntLf SrvDim SrvAge PrgCount PrgCntLf PrgDim PrgAge DryCount DryCntLf DryDim DryAge AbtCount AbtCntLf AbtDim AbtAge IMDat IMFIg IMDim IMWt MTim IMTim IMStall IMCode 7160 9001 516 11 2003 DRY Future Vet Action ABORT Vet Action Date ABORT Vet Action Worker ABORT Vet Action Cost ABORT Vet Action Comment 1 ABORT Vet Action Result ABORT Vet Action Time of Day ABORT Vet Official Code Numbe ABORT Vet Comment 2 Future Vet Action Date Future Vet Action Time Future Vet Action Code Number Future Vet Action Name Is Future Action Count this lactation Count whole lifetime Days in milk for action Age on vet action date BIRTH Count this lactation BIRTH Count whole lifetime BIRTH Days in milk for actio BIRTH Age on vet action date CALVING Count this lactation CALVING Count whole lifetime CALVING Days in milk for acti CALVING Age on vet action dat HEAT Count this lactation HEAT Count whole lifetime HEAT Days in milk for actio HEAT Age on vet action date INSEMINATION Count this lactatio INSEMINATION Count whole lifetim INSEMINATION Days in milk for act INSEMINATION Age on vet action da PREG Count this lactatio PREG Count whole lifetim PREG Days in milk for act PREG Age on vet action da DRY Count this lactat DRY Count whole lifet DRY Days in milk for a DRY Age on vet action ABORT Count this lactation ABORT Count whol
91. m Average Body Weight actual m Body Weight Standard Deviatio Body Weight Deviation from Me Body Weight Standardized Devi Body Weight Deviation Body Weight Highest Deviatio Body Weight Lowest Deviation Body Weight Alarm Conductivity Average Value Conductivity Average Value Conductivity Average Value Conductivity Average Value Conductivity Standardized De Conductivity Standardized De Conductivity Standardized De Conductivity Standardized De Cond Lowest Quarter Average Cond Quarter Number with low Cond Highest Quarter last re Cond Quarter Number highest Cond Quarter deviation perce Cond Highest Quarter last 24 Cond Quarter Number highest Cond Quarter deviation perce Illness Alarm Count Illness Alarm Points Milk plus Conductivity SDD Difference between cond peak Leonardo Milking Date Leonardo Milking Time Leonardo Udder Coordinate 65 General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Weight Analysis General Weight Analysis General Weight Analysis General Weight Analysis General Weight Analysis General Weight Analysis General Weight Analysis General Weight Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis General Conductivity Analysis Gener
92. main the same Lower case items are manufacturer specific and may be changed in future programs 4 1 3 Data Indexing For importing animal data a non zero animal number must be included in each record Some items cannot be imported The registration number may also be used In this case please check before import if all animals have unique registration numbers If the registration number is not unique DPDataExchange sets data only in the first animal found with a matching registration number regardless if the animal is culled or not Many items may allow for more than one entry In such cases DPDataExchange requires an index to know which of the entries you are referring to Generally this is accomplished by setting a date as in the calving date for data about past lactations Unfortunately a secure indexing technique has not yet been proposed for international use The exact details of DPDataExchange s indexing for each data category are found below and must be followed for proper loading of data Importing data with incorrect indexing may cause incorrect loading and possible loss of other data 4 2 Data Format 4 2 1 Alpha Format Codes using an A format may contain any ASCII values 32 255 That is any character or digit is allowed including international and graphic characters Two exceptions any field completely filled with question marks is considered undefined and any field completely filled with vertical bars is
93. milk Clock time not duration 900078 IMTim Time of individual Milking Clock time 00202513 900079 IMDuration Duration of individual Number of minutes required milking to milk the cow 4109 Mode Error Code of the Milking 4120 MsCondA Average Conductivity of 14 all quarters 4121 I MsCond1 Conductivity Quarter 1 4122 __ MsCond2 Conductivity Quarter 2 E i 4123 __ MsCond3 Conductivity Quarter3 l4 4124 MsCond4 Conductivity Quarter 4 4351 ATim Average milk duration DPSingle Last Milking old avimdur re amlks1 Average milk session one F 4 1 These values are calculated from the milk ss e e e 4303 amlks3 Average milk session F 4 1 according to the milking TLR a TT 4304 amlks4 Average milk session four F 4 1 di dr Pe EE Find more Items in the general list of DDI codes 4 3 6 Other Individual Measurements There are Activity measurements Feed remainders and Body Weight measurements Feed data is described in a following chapter To prevent disorder of the DAIRYPLAN system with its technical equipment the values are export only Please note especially for Activity values it is hard to draw conclusions from the raw data entries in the table It is much better to use the statistically processed values derived from the raw data For a detailed description please look into help file of DAIRYPLAN DP5 with description of the report codes DAIRYPLA ISO and or DII Code Description DAIRYPLA
94. n farm hardware and Component Test Test Day Values officially used by a Dairy Records Processing Center Earlier versions of DPDataExchange used AMWT and related codes for either kind of value Version 4 4 and later versions use AMWT for the Test Day values only and use new codes MAMWT for the actual measured values In 5 0 the Windows programs DPDataExchange and DPList do no longer know the code mnemonics Amwt AMDat AMDim they were completely replaced by TestMilk TestDate and TestDim but the DD Item numbers remain MAMWT and MAMDAT are still available but it is better to use the new codes MPWgt and MPDat with same DD Item numbers DPDataExchange can use multiple records or braces to send receive multiple averages from either table for making lactation plots TestDim will return zero for plot points of prior lactations however using TestDat and TestMilk prior lactation data is available Test Day Milk Amounts code TestMilk etc Data import In versions prior to 5 0 the file send date was assumed as test date unless the TestDim or TestDate figure was included in the record Furthermore you could import data for current lactation by specifying the TestDIM field Since 5 0 it is absolutely necessary to specify Testdate 7160 9001 516 11 2003 48 For further fields in the Componet
95. n the DP system Milk Data Import requires option I though no Metatron specified in DPSetup Import Indiv Milking possible even without Metatrons specified corrected chapter 1 2 10 new behavior avmlk recalculation see 1 2 10 Import of lactation data not possible with lactation number as index reimplemented in 5 020 not yet implemented in versions before import required lactation start date or calving date Indexing behavior together with other index fields may have changed slightly PLEASE CHECK CAREFULLY delete record but not with a delete line Deletion of single vet actions also not possible Multrec lifetime Mode in export of data now default on Importing M305P F305P P305P and MEQUIV not yet implemented Command line option U does no longer make DII be the defaults file extension for files loaded or created in the ON line you must specify full file extension If no file extension is given ADISEngine does no longer automatically add the extension ads or dii in case option U has been specified to enforce DII output no longer supported decimal command record general command record Activity Body Wt Raw data import with I but does not mind time e only 1 value per day is written In old times you could import testmilk for actual lactation with index field testDIM This is no longer possible with ADISEngine By default OEM character sets are used in input and output with special cha
96. ng date and bd 900046 typ dry date for dry animals bloodlin Blood or Family line Breed see DPSingle Genetics See DPSingle Genetics Pj ily li Family Line see DPSingle breedr A15 See DPSingle Genetics Animal Analysis Score Animal Analysis see DPSingle Genetics class Classification Score A7 See DPSingle Genetics 15 8 4 14 3 2 3 Genetics 7 7 A A A A A A i A SIRE Animal Sire s Registration A 15 Father of the animal see DPSingle Genetics DAM Animal Dam s A15 Mother of the animal see Registration DPSingle Genetics 900083 DAMReg1 Animal Dam s A15 Mother of the animal Registration retrieved dynamically see DPSingle Genetics damsid Animal Dam s Barn number of the mother DAIRYPLAN DP5 animal see DPSingle Genetics number 2121 900036 Body Body Weight 14 See DPSingle Process 00200278 old Control BDWT 7160 9001 516 11 2003 39 2123 100000079 bawidate _ Date for Body Weight 900033 Permanent String DP s see DPSingle Identification 00200064 Group Secondary String DP s Second group number see permanent string DPSingle Identification was 2111 secstr in older versions 2007 900035 LACTNO Lactation Number Current Lactation Number in DPSingle Lactations Artificial Insemination in DPSingle Lactations Count plansir1 Planned Sire Choice 1 In DPSingle Geneti
97. o DAIRYPLAN DP5 DPDataExchange would use the general Illness vet action because no other vet action is defined for 437 In the case where both the name and official code number appear in the same record the name will take priority if it exactly matches a known name If not it is handled as an official code alone If DPDataExchange cannot match either the name or the official code an error message is issued Multiple values for any item can be send with multiple records for one animal or in repeated blocks using braces so long as the date appears within the brace Reminder braces are NOT part of the ADIS standard Multiple records are preferred Refer to section 3 6 7 Page 32 New information is added to existing records by either a changing an existing entry with the same date or b adding a new entry Triggered Vet Actions DAIRYPLAN DP5 maintains schedules of future planned actions which can be automatically scheduled when certain other actions are entered by the user For example when the user enters an insemination DAIRYPLAN DP5 may automatically schedule a Pregnancy Check 45 days later All such automated scheduling can be set up by each user DPDataExchange can also automatically make such schedules Use the T option to make DPDataExchange automatically adjust the scheduled vet actions according to the new imported data For example with the T option importing an insemination on Jul
98. or all searches DII protocol files require a comma between the DII code and the low and high values The DII protocol does not allow for the maximum number of records DPDataExchange will accept any record with or without commas and with or without a maximum number of records The ADIS September 1991 Working Draft document specifies that more than one search condition can appear on a single record section 15 2 page 15 However in some circumstances it is impossible to distinguish a second search condition from the maximum records specification Therefore DPDataExchange requires that multiple searches conditions must be specified with multiple search records preceding the request record R Request record This makes DPDataExchange produce an output file with data in the specified form The format is exactly the same as for a definition record See section 4 3 4 page 21 above Output will be placed into file DPDataExchange ADS unless otherwise specified DPDataExchange produces one record for each animal in the file unless a search condition is specified as described above R lt event gt lt DDI no gt lt field length gt lt precision gt NOTE ADIS requires that Definition records always have at least one corresponding value record If DPDataExchange cannot find any data to answer a request a value record of question marks is produced F File record This is defined by ADIS to reference a library file These are
99. pure ANSI char sets for input and output files set new flag option CharAnsi to 0 or specify new option j on the command line 3 3 Command Records 3 3 1 ADIS record formats ADIS records lines are in the form TSEEEEEED where R the first character must be a letter specifying the line type S the second character must be a letter specifying the status E the next six characters are usually digits forming the event number oder entity number as it is called in laetr ADIS protocols Line types where the use of event numbers is mandatory are noted below 000000 may be used if event numbers are not needed for the application D the remaining positions in the record depend upon the record type Each record is terminated with a Carriage Return Linefeed sequence as with other ASCII files under MSDOS 3 3 2 DII record formats DII records follow the form R D C where R the first character must be a letter specifying the record type except for data records which must begin with a digit the second character is always a colon except for data records D the remaining positions depend upon the type of record c DII records always end with a checksum Each record is terminated with a Carriage Return Linefeed sequence as with other ASCII files under MSDOS 7160 9001 516 11 2003 20 3 3 3 How DPDataExchange selects between ADIS and DII lines DPDataExchange can read records of either format regardless o
100. r of decimal places Special command records allow redefinition of fields These special records may be in a file being loaded explicitly or with HDI files technique described below 3 1 1 Defining and creating new field names and numbers The command record w define NewName OldName will make DPDataExchange respond to the field descriptor NewName exactly as it is preprogrammed to respond to the OldName field You may use either DD numbers or mnemonics in definitions Also OldName can be an expression including formulas New definitions remain in effect until DPDataExchange resets or exits There are other definition possibilities including event specific definitions Refer to section 4 3 5 2 page 26 For the sake of backwards compatibility it is also possible to specify wN define NewName OldName The command record w create NewNumber NewName Type Decimals Description will make DPDataExchange create a field in the user defined section of DAIRYPLAN DP5 unless it already exists or there is no more room The new field remains in effect unless changed by the user Type can be Number Date Cost or Word Decimals applies only to numbers These entries can also be modified with the DPSetup program 3 1 2 Changing the width DPDataExchange will automatically adjust field widths to whatever width is specified in the definition or request records Character data alpha is truncated to fit whatever width is specified
101. racter with ASCII Number gt 127 If you want to use plain ANSI character sets set option charAnsi 0 or specify CRI option on the command line Command line option trigvet renamed to trigger recalculate triggered vet actions during import of vet actions Report codes for AMwt AMDat AMDim completely replaced by TestMilk TestDate and TestDim but the DD Item numbers remain MAMWT and MAMDAT are still available but it is better to use the new codes MPWgt and MPDat Since version 5 020 the use of lactno as index field for import of lactation data is fully supported 6 2 Release Notes Updating 5 0 to 5 1 DAIRYPLAN C21 7160 9001 516 11 2003 80 Version 5 093 are test versions before final release of DP5 1 or DAIRYPLAN C21 which is the official product name 1 2 Version 5 093 and following can export bull data of multiple inseminations within a lactation Responder and ISO Responder now are only 1 field Therefore you now can use DD numbers 2023 DP 900096 ISO and 201812 Taurus for both Ensure your field length specification is long enough up to 15 characters ISO responder field with DD number 2099 still available 6 3 Release Notes within DAIRYPLAN C21 Versions Event scope definition of new fields see 3 3 5 Manufacturer Specific records define command new option RefMNum suppresses Import of data items with a data item number
102. related information loaded through DPDataExchange will be loaded as follows If the new date matches a date already in the file the new information is loaded as part of the existing vet entry If the new date does not match a new vet entry is created This makes it difficult for DPDataExchange to correct entry errors of vet data the correct information will usually end up creating a separate entry with the incorrect information still in the file For example it is possible to enter two different birth dates with DPDataExchange To correct these problems it is possible to send a deletion record to DPDataExchange for the animal and then re enter the whole animal or the user may manually delete the incorrect information after DPDataExchange finishes Note however that many vet entries have side effects which are difficult to reset on an automatic basis developers are advised to use these capabilities with caution You can also specify the option T or set the flag control record Trigger to create future vet actions for each vet action loaded according to the vet action setup of your system The future vet actions will not be created or changed if the vet action of same date already exists Note The vet event date MUST be included for DPDataExchange to load related vet fields 1 2 8 Importing Milk Summary Data DAIRYPLAN DP5 can be connected to WestfaliaSurge Metatron milk meters to automatically generate milk production recor
103. smaller than 100000 RefMEv suppresses import of whole events entities which have a non zero event number smaller than 100000 Since Version 5 105 bug fixed deletion of animals which already left herd still only the Westfalia command record delete works not the line status delete as defined in ADIS Since version 5 105 Event Scope Definition define a code to be used only for a particular event number It is allowed to define multiple interpretations of NewCode for various event numbers See chapter 3 3 5 Bug fixed deletion of inactive animals deletion with the Westfalia delete record Changed behavior Import of fields filled with spaces or zeros does not overwrite existing values thus same behavior in DPLINK and ADISEngine DPDataExchange If you want these values to be overwritten please set the zero option to 1 in a Westfalia command record 7160 9001 516 11 2003 81 e ia Landtechnik GmbH Werner Habig Stra e 1 D 59302 Oelde 71 60 90011516 ee Fax 49 0 2522 77 24 88 Irit rnet http www westfalia com Produktion und Zentrallager M hlenstra e 17 20 D 58313 Herdecke Tel 49 0 2330 64 0 Fax 49 0 2330 13866 nderungen in Konstruktion und Ausf hrung behalten wir uns in allen F llen vor
104. ssing on Quarter Leonardo Duration Conductivity Measuring Leonardo Teat Missing Leonardo Could not Attach last Milking Leonardo any Milk Flow Missing Leonardo Quarter Conductivity Leonardo Quarter Conductivity Leonardo Quarter Conductivity Leonardo Quarter Conductivity Leonardo Average Quarter Conductivity Leonardo Conductivity Measuring OK Leonardo Reached expected Milk Weight Leonardo Flush after Milking Leonardo Attach Tries Leonardo Milk Duration Quarter Leonardo Milk Duration Quarter Leonardo Milk Duration Quarter Leonardo Milk Duration Quarter Leonardo Attach Time Leonardo Do not Exit Leonardo Brush Height Leonardo Brush Time Leonardo Familiarize Leonardo Maximum Milk Duration Leonardo Medium Milk 66 Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental
105. t Tabl Average Milk DIM Component Test Date Plot Point Milk Weight Milk Plot Point Date Plot Point Body Weight Plot Point Activity per Hour Plot Point Average Flow Rate Plot Point Maximum Flow Rate Plot Point Conductivity All Fat Percent Protein Percent Lactose Percent Somatic Cell Count Somatic Cell Count Urea from Test Table Body Condition Score from Te Urea Factor 10 Sample Bottle Number Sample Box Number Sample Bottle Date Milk Sample Bar Code Lact Start Calving Date Official Lactation Total Milk Official Milk Count Official Milk Error Count Money Value of Ave Milk Projected Total Feed Value Projected 305 FC Milk Value Sum of Breeding Costs Sum of Vet Costs Sum of Feed Costs 67 Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Leonardo Experimental Data Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Milk Measurements Test Components Test Components Test Components Measured Averages Measured Averages Measured Averages Measured Averages Measured Averages Measured Averages Measured Averages Test Components Test Components Test Components Test Components Test Components Test Components Test Components Test Components General Genera
106. t be used for the input and output files unless a decimal place appears in the text file For example if you specify PFAT 3 1 This will interpret all of the following as 3 5 percent fat 035 35 3 5 3 48 The default precision for PFAT is 2 decimal positions If you simply enter PFAT the first two examples would be interpreted as 0 35 The last two would be interpreted correctly Regarding Decimal Places For the DII output file decimal positions are never shown in the data columns they are part of the definition for the column You can set the number of decimal positions yourself or let ASCTODII set this according to the ADIS DII standards For the text file if a period appears in the column this is used regardless of the number of decimal places you specify If a period does not appear in the text file the same number of decimal places is assumed for the text file as for the DII output file If this is not correct you must change it by specifying a different precision using a user defined field name 5 4 3 Converting Files with several different line types It is fairly common to find data files with different line types containing different kinds of information For example consider the following simple text file L1 Joe Dairy 3124589 L2 0028 1H123412 02 08 88 L3 0028 07 12 90 01 12981 0421 0531 L3 0028 08 11 91 02 11312 0451 0621 L2 0037 1H142321 05 11 87 7160 9001 516 11 2003 77 L3 0037 04 08
107. t file with the requested information The output file name is DPDataExchange ADS unless a You specify an output name as the second parameter on the command line Example DPDataExchange A REQMILK A OUTPUT 7160 9001 516 11 2003 6 This will respond to any request commands by generating file OUTPUT ADS on drive A Note that you must specify the floppy drive for both input and output otherwise the hard disk is assumed b Normally an ADIS file is created for output but you can force DPDataExchange to create a DII file by using the U option See section 3 2 2 page 17 c The transfer file may contain an output record a line starting with ON directing output to some other file It is possible for one input file to create multiple files with multiple output commands See section 3 3 5 page 25 1 2 6 DPDataExchange s use of user defined fields DAIRYPLAN DP5 allow extensive use of user defined questions These may be accessed by DPDataExchange to send or receive data which is not part of WestfaliaSurge s standard management program ADIS numbers and or DII mnemonics for transferring this data may be entered by the user or created automatically by special control records in a DII file Refer to section 4 3 5 2 page 26 for details 1 2 7 Importing Vet and Breeding Data DAIRYPLAN DPS saves all vet history in a vet event file including the animal s birth inseminations breedings calvings and treatment information Vet
108. t is a mnemonic followed by a backslash followed by the field width and comma delimited The period followed by the resolution or number of decimal places is not part of the DII standard but DPDataExchange will accept this The ADIS style is DDDDDDDDFFR That is an 8 digit Data Dictionary number followed by a two digit field width followed by a single digit resolution Commas delimiters are not part of the ADIS standard Use of braces The DII protocol allows the use of braces to specify a block of repeated data as in 7 DMDIM 4 DMWT 4 to get the last seven days of milk data DPDataExchange allows this capability for both ADIS and DII file formats though it is not ADIS standard The exact use of braces depends upon the particular data dictionary elements V Value Record ADIS uses the letter V to denote Value lines containing the data according to the definition line above For ADIS these must contain the same event number as the definition record The DII protocol states that data records have no prefix but instead must begin with numeric data However some DII programs use V before all data records DPDataExchange will accept all three forms as data records ADIS V lt status gt lt event no gt lt value gt DII lt value gt also 0k V lt value gt NOTE Both ADIS and DII standards say that data value records must immediately follow the corresponding definition records However DPDataExchange will allow
109. te 2 User defined Date 3 User defined Cost 1 User defined Cost 2 User defined Cost 3 User Defined Word User Defined Word User Defined Word User defined Number 1 User defined Number 2 User defined Number 3 User Defined Number User Defined Number User Defined Number User Defined Number User Defined Number User Defined Number Vet Action Date Vet Action Worker Vet Action Cost Vet Action Comment 1 Vet Action Result Vet Action Time of Day Vet Official Code Number 59 General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action Vet Action 3108 3109 3111 3112 3113 3114 3115 3116 3117 3118 3121 3122 3123 3124 3125 3126 3127 3128 3129 3131 3132 3133 3134 3135 3136 3137 3138 3139 3141 3142 3143 3144 3145 3146 3147 3148 3149 3151 3152 3153 3154 3155 3156 3157 3158 3159 3161 3162 3163 3164 3165 3166 3167 3168 7160 9001 516 11 2003 VetCom2 VetName BirDat BirTech BirCost BirCom BirDiag BirTime BirOffC BirCom2 ClvDat ClvTech ClvCost ClvCom ClvDiag
110. te data columns of varying sizes Enter No if the file does not Note with comma delimited fields every data column must be separated by commas semicolons or tab characters Optionally single or double quotation marks may enclose character data If you do not use comma delimited fields each data column must be the exact same width In all cases commas semicolons tabs and single or double quotation marks cannot be used as data After you have answered all questions you are asked to confirm that the information is correct Press Y to continue Next the data columns will be highlighted one at a time you must supply the DII field specification for each column a First use the left and right arrows to precisely define the column boundary Press Enter when the column area is correctly highlighted b Then a window appears asking you to select the field name from a list Use the up and down arrow keys to find the correct field name for this column If you do not wish to transfer the information in this column select Do Not Transfer If you cannot find the correct field name or if you require special options choose user defined and refer to section 2 4 2 page 77 Now ASCTODII performs the file conversion Each column is converted into a DII field of the proper format Finally ASCTODII asks you if you would like to make a batch file to more easily load this data using DPDataExchange If you press N ASCTODI
111. time the event number changes This makes a much larger output file Note also that the original text file contains only registration numbers rather than animal numbers DPDataExchange can load such files but the animals and their registration numbers must be first entered into DAIRYPLAN DP5 7160 9001 516 11 2003 13 To modify this for your own use you must use a text editor and C compiler to make changes according to your particular situation You will probably need to make the following changes 1 You may need a different technique to distinguish the line types ADR assumes the first two characters of each line are a two digit line type 2 You will certainly need to change the various ITEM and REC structures to reflect the data you are actually using 3 You may need to modify or add the various special data conversion functions for individual data fields ADR uses a technique where each data element is controlled by a structure This structure contains a function pointer to a conversion function which may be called if the conversion is more than a simple text copy 7160 9001 516 11 2003 14 3 DPDataExchange Technical Reference 3 1 Matching Special Fields The ADIS and DII protocols allow great flexibility with manufacturer specific field definitions Occasionally another organization may use a different name or number for a field which DPDataExchange has defined or the field may be defined for a different width or numbe
112. tions for details see section 4 3 page 37 With DPDataExchange up to four 4 search records may be used with a single request Data must match all search conditions logical and ADIS allows multiple search records preceding the related Request record However DII allows only a single search record immediately following the Request record Therefore if DPDataExchange finds a DII style search record immediately following a request these search conditions are used In all other cases searches must precede a request S lt event gt lt DDI no gt lt length gt lt resolution gt lt low val gt lt high val gt lt max records gt DDI no As described above with D records length si resolution low val lower limit must be exact length specified high val upper limit max rec maximum number of records to produce for each animal DPDataExchange Version 5 0 or higher does not yet support the max rec feature 7160 9001 516 11 2003 23 If high val is shown as question marks the search finds the most recent n records where nis max rec If low val is question marks ADIS specifies that the first n records are to be produced However DPDataExchange shows all records ignoring max rec for this search condition and a warning message appears Records are always produced in the newest to oldest order If more than one search record is used DPDataExchange uses the smallest non zero max rec specification f
113. tocol specifies that one header must be at the beginning of a file or following an E record DPDataExchange does not require headers but they can optionally appear anywhere in the file The DII protocol uses a special record type H for this 3 4 2 N for Normal Data Most ADIS lines have this type and are not given any special treatment 3 4 3 S for Synchronization Data ADIS defines a synchronization line as having two possible purposes 1 initialization of the database or 2 comparison of databases between sender and receiver When DPDataExchange encounters a definition line with the S status it asks the user if he would like the initialization flag set see section 4 2 3 page 18 Not yet implemented in version 5 0 In all other respects S status lines are treated like normal lines 3 4 4 F for Faulty Data ADIS allows programs to return error information by sending back lines containing errors These lines use the F status When DPDataExchange encounters a line with F status it shows the line on the screen with the message Line Status Fault The line is not processed as normal data When DPDataExchange encounters any error it will automatically produce a Fault line in the output file so the sender can know that a problem occurred 7160 9001 516 11 2003 29 3 4 5 D for Deletion Data Not yet implemented in 5 0 Please use Westfalia command record delete to remove entire animals DPD
114. ty Measurement Time Milk Per Hour Milk hr Average Value Milk hr Standard Deviation Milk hr Deviation from Mean Milk hr Standardized Deviatio Milk hr Deviation Milk hr Highest Deviation Milk hr Lowest Deviation 63 General General General General General General General General General General General General General General General General General General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control General Milk Control Measurements Activity Measurements Activity Measurements Activity Measurements Activity General Milking Analysis General Milking Analysis General Milking Analysis General Milking Analysis General Milking Analysis General Milking Analysis General Milking Analysis General Milking I s sr s eEe 4530 4541 4543 4544 4545 4546 4547 4548 4549 4550 4563 4564 4565 4566 4567 4568 4569 4570 4583 4584 4585 4586 4587 4588 4589 4590 4601 4603 4604 4605 4606 4607 7160 9001 516 11 200
115. which can be more accurately obtained from the automatic meters Therefore DPDataExchange will normally prevent importing these fields With the I option DPDataExchange will import milk data on any system Z f zero 1 Zeros loaded Normally blank and zero fields are ignored on data import this prevents accidental erasure of data previously entered in DAIRYPLAN DP5 With the Z option all data is loaded even if it is zero For example use this option for loading feed amounts when some animals are not supposed to receive grain T f trigger 1 Triggered Vet Actions Normally DPDataExchange will not adjust future vet actions when importing real vet actions However with this flag set DPDataExchange reschedules all future vet actions after import of a real action just like when the user enters it manually This has no affect on direct import of future vet actions using the special codes for this purpose Remark option was named trigvet in earlier versions DPLINK 3 2 4 Options Controlling Requests for Data Export L f life 0 Lifetime data output If you want only the most recent lactation to be checked for veterinary data ie inseminations switch off this opion is set per default since 5 0 For earlier versions Use the L option to check the animal s lifetime records For example with the L option the code SRVDAT would show last year s breeding for fresh cows Without the L option t
116. with ADIS number 00123456 using DII code mnem with a description desc from a user defined number in DAIRYPLAN DP5 with one implied decimal place The field is not created if it already exists num can be replaced with date cost or word to access user defined dates costs and words respectively Desc is an optional description for the item For compatibility with earlier versions of DPDataExchange the ADIS number may be omitted but this is not recommended The DII mnemonic is always required w define NewCode ExistingCode This tells DPDataExchange to treat any reference to NewCode exactly as ExistingCode Starting with version 5 0 the ExistingCode can be any valid expression either a DD number or a mnemonic including formulas Note that you are not permitted to redefine codes which already exist in DAIRYPLAN nor can you define manufacturer specific codes in the range 0 9999 Also NewCode must be a simple number or mnemonic not an expression Mnemonics must start with a letter A Z and may contain letters or digits These are typically used in HDI files to match field names used by an organization with the field names used in DAIRYPLAN Some examples w define calf clvcom This tells DPDataExchange to treat any reference to calf exactly as clvcom w define 00123456 00201895 This tells DPDataExchange to treat any reference to 123456 exactly as 201895 w define 00123456 Li
117. with DPDataExchange A return file is created automatically All he needs to do is insert the diskette in drive A and enter DPDataExchange name from a DOS prompt or a link specified before The processing center must specify the transfer file name 7160 9001 516 11 2003 4 3 The dairyman sends this return file back to the processing center in time for the center to print barn sheets or whatever materials are needed for test day After Test Day 4 The processing center provides the farm with another ADIS file giving the test results back to DAIRYPLAN Again the dairyman only needs to enter DPDataExchange name again the processing center must tell the dairyman the name of the file to load For Labor Efficient Records steps two and three would occur immediately after milking on test day The request file would include milk test data in addition to breeding data 1 2 Running DPDataExchange 1 2 1 Loading a file from disk Use this procedure when your Dairy Records Processing Center has given you a data diskette prepared for ADIS or DII format Also use this procedure if you have downloaded such a file with a modem or from the Internet If you want to start it with a filename use the Execute Command in the taskbar or call from a DOS box to start DPDataExchange filename where filename is the name of the file your DRPC has given you The filename can include a disk drive name or subdirectory name to read fil
118. y 1 will automatically schedule a pregnancy check for August 15 Alternatively without the T option the import file can set a future pregnancy check action at any time using the future vet codes defined below 7160 9001 516 11 2003 41 In versions 4 4 and lower for data export normally only the most recent event in the current lactation was considered To get multiple records specify a search condition using any veterinary data item Braces may also be used to get several values in one record When requesting multiple values be sure the request does not contain data from different events i e do not include both calving and insemination data on the same record Option L searches the entire lifetime without L just the current lactation is searched In version 5 0 and higher automatically multiple records for whole lifetime are exported without specifying the L and M option Deleting Vet Actions is also possible in older versions Refer to section 3 4 5 page 30 DAIRYPLA ISO and or DII Code Description DAIRYPLAN DP5 Notes NDDI Taurus DDI Number Number Cee ee LI 00201695 3116 birime Birth Time ere dl 3117 biroffc Birth Official Code 14 Bee e Dr D 13112 bitech Birth Technician ASB ef 13113 Ibircost Beet CT 82 3114 900052 bircom Birth Comment A15 Often used to describe the way of the birth ei ci 3115 Birth Diagnosis Flag 11 11 3118 9000
119. ype Number Name for Feed Amount in Bin Feed Cost Kg Feed Type Maximum Feed Per Day Maximum per interval Minimum per interval Feed rollover to next day Intervals per day Regular intervals per day 70 Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Feed Group Data Group Data Group Data Group Data Group Data Group Data Group Data Group Data Group Data Group Data Group Data Group Data Group Data Group Data Group Data Group Data Group Data Group Data Group Data Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup Feed Setup 8112 FedTpYesterda 8121 FedTpToday 8122 FedTpDays 8201 FedStNum 8202 FedStChip 8203 FedStType 8204 FedStLastTime 8221 FedStMot01 8222 FedStMot02 8223 FedStMot03 8224 FedStMot04 8225 FedStMot05 8226 FedStMot06 8230 FedStTotal 8231 FedStType01 8232 FedStType02 8233 FedStType03 8234 FedStType04 8235 FedStType05 8236 FedStType06 8237 FedStType07 8238 FedStType08 8239 FedStType09 8240 FedStType10 8241 FedStType11 8242 FedStType12 8243 FedStType13 8244 FedStType14 8245 FedStType15 8246 FedStType16 8261 FedStDesc 8301 MeterNum 8302 MeterType 8303 MeterChip 8304 MeterChkSum 8305 MeterNeuronID 8311 MeterCtNold 8312 MeterCtManld 8313 MeterCtAutold 8314 MeterCtAII 8315 MeterlDPerc 8321 MeterTotAll 8322 MeterTotPred 8323 MeterTotA

7160-9001-516 Dairy Plan

Contents

Download Pdf Manuals

Related Search

Related Contents