Transfering Test Days and Prev Lacts Between Cowfiles

EXEC\101 can be used to transfer page 4 and page 5 date between cowfiles. This can sometimes be useful when the data become lost or corrupted but are available in a backup file.

History

• 09 Mar 2010 - support \Q which moves dams page 5's to calves (within cowfile)

Switch Summary

A[R|W][P|T]  Auto Mode Standard Files :
                 P = Prevs
                 T = Test days
                 R = Read
                 W = Write    (ARP does not yet work)
               reads/writes CowFMask\HERDCODE.CSV

EXEC\101ATW writes (creates) a standard test day file HERDCODE.CSV.

EXEC\101ATR reads a standard test day file HERDCODE.CSV.

Sorry but the \A does notyet work for prev lacts, just test days.

Transferring Test days (Page 4)

This replaces the previous method of using the EVENTS command and saving the file. That method had problems with compatibility between files, as well as international formatting issues. Now you can write and read a "standard" test day file. This standard file also properly supports test day CAR codes, test day Pen and test day MUN. Archive files are NOT used in this operation. Existing test days are cleared when new ones come in (I think) - it's not a merge. (I think).

The standard file option requires a program dated on/after Aug 04 2006

- EXEC\101
- - Test days
- - - Write Standard Test Day file

Enter filename or select default of HERDCODE.CSV in cowfile dir Log on to destination cowfile and use "Read Standard Test Day File" to bring them in.

Reading external test day files using a variable command (incomplete)

An optional condition list can be used ("EXEC\101 FOR PEN=5", or "EXEC\101 FOR ID=1234")

Example :

EXEC\101KC MILK:4 PCTF:5 PCTP:6 305ME:8 SCC:10

This example assumes a comma delimited file, MILK is in CSV field 4, PCTF is in 5, 305ME is in field 8, etc... ID must always be first and test date second (I think). We recommend however using standard formats.

Transferring Prev lacts (Page 5)

'''EXEC\101'''
- Write prevs to file
LOGON to the other file
- - Read prevs from file

This is not yet automated with \A.

Transferring Dam Prev lacts to Calves

We now have a way to move the prev lacts (page 5 records) from the dams to the calves. Normally this is done in FRESH but for various reasons (moving heifers between cowfiles) sometimes the recors get lost. It also allows updating calf records with newer dam data.

To do this use the command

EXEC\101Q  [FOR]

This matches all the calves (limited to the condition list if there is one) and updates them with their dam's page 5's. This of course is limited to calves whose dams can be found, also the dams must have an FDAT or prev lact FDAT that matches the calve's birth date. It takes an optional condition list (used to select the calves0 but it is not really needed. Only LACT=0 animals get updated regardless of condition list.

This change requires a version dated 09 March 2010 or later.