Creating a Pedigree File
|
output file
|
Cow
Number
|
Barn name
|
SireID
|
Maternal
Grandsire
ID
|
DamID
|
Dam
Name
|
Maternal
Maternal
Grandsire
ID
|
Lactation
Number
|
Cattle
Breed
|
|
|
FILEOUT
|
ID
|
BNAME
|
SID
|
MGSID
|
DID
|
DNAME
|
MMGSID
|
LACT
|
CBRD
|
ForClause \1AC
|
|
Placeholder
|
|
%33.
|
%19.
|
%19.
|
%17.
|
%33.
|
%19.
|
|
%33.
|
|
Email
the file you create to All West/Select Sires
Creating a Cull File
|
output file
|
Cow
Number
|
Barn name
|
Lactation
Number
|
Cull
Date
|
|
|
FILEOUT
|
ID
|
BNAME
|
LACT
|
ARDAT
|
ForClause \2ACB
|
|
Placeholder
|
|
%33.
|
|
%18.
|
|
Description
for Exporting Dairy Comp 305 Data to SMS
Introduction
This document is based on using the latest Windows version
of Dairy Comp 305. The ideas and methods presented here
may or may not work with DOS versions of the program or
earlier Windows versions.
Definitions
Item
Items are the various “pieces”
of information about an individual animal. Examples are:
ID, birth data, Sire, Dam, Fresh Date, Days in Milk, etc.
Each item has a distinct name abbreviation to designate
that item. Item names (abbreviations ) can vary from one
herd to the next. Not all items exist in all herds.
Event
"EVENT" refers to something that has occurred
to the animal. Examples of EVENTS include FRESH, BRED, PREG,
MAST and DA.
Command
Commands are instructions you enter on the “Command
Line” to perform a desired function.
Any information entered into Dairy Comp, whether selected
from a menu or entered at the command mode, is passed through
a "command parser" which interprets what you entered
and executes the necessary parts of the program to perform
that function.
You can get to the Command prompt by pressing ESC, or clicking
on the Command entry box.
Command Structure
Commands generally have the following format:
“Verb” “Item List” “For clause”
“By clause” “Switches”
“Verb” indicates the function that is to
be performed.
“Item list” indicates the items to be provided.
“For clause” indicates what group of animals
should be selected.
“By clause” indicates the sorted order
of the results.
“Switches” indicate special features of
how the data should be presented
Commands can be all upper or all lower case or a mixture
of both.
An example command could be the following:
Show ID SID DID LACT For PEN=1 By LACT \E
Where “Show” is the Verb,
“ID SID DID LACT” is the item list
“For PEN=1” is the For clause
“By LACT” is the By clause
“\E” is the Switch
Date Formats
Dairy Comp 305 allows three types of separators for formatting
dates: Periods, Slashes, and dashes. Therefore, each of
these is recognized as August 7, 2003:
8.7.3
8.07.03
8.7.2003
8-7-3
8-07-03
8/7/03
8/07/2003
Since the dashes are used for other purposes within Dairy
Comp 305 such blanks, ranges, negative numbers, users are
encouraged to use the period as the date separator of choice.
Exporting
Data
At the present time, the SMS program is capable of
accepting two types of data from Dairy Comp 305: Pedigree
information, and Cull cows. The pedigree information can
be used to either generate SMS II records or to update the
Pedigree data for existing cows.
The SMS program is expecting the file to have specific items
in a specific order. This necessitates some rigid rules
on the commands you enter and how you enter them. There
is some flexibility on how you select the group of animals
you want, but not on the order of the data sent to the file(s).
Items Exported
As mentioned above in the definition of “item”,
not all items exist in all herds and items can be renamed
by the dairyman. Item names used in commands must match
those used by the dairy. If a dairy does not use an item
that we require for the SMS program, you must still save/make
a place for that item using a “place holder” (to
be discussed later).
The charts below show the “standard” item names
needed by the SMS program. Since each dairy can rename or
eliminate items from the basic installation of Dairy Comp
305, you may need to determine the actual items used by
a dairy and their names. You can use the following steps
to show a list of items used by a particular installation.
On the Command line, enter: ALTER
Then choose the following options: 2 Items
6 Display/Print “All” item definitions
Use the displayed list to verify that the items needed below
exist and the actual name used for each item. For needed
items that don’t exist, you will need to use the respective
place holder instead of that particular item.
Pedigree Information items
The following items are required to be in the pedigree information
file in the order shown here:
|
output file
|
Cow
Number
|
Barn name
|
SireID
|
Maternal
Grandsire
ID
|
DamID
|
Dam
Name
|
Maternal
Maternal
Grandsire
ID
|
Lactation
Number
|
Cattle
Breed
|
|
|
FILEOUT
|
ID
|
BNAME
|
SID
|
MGSID
|
DID
|
DNAME
|
MMGSID
|
LACT
|
CBRD
|
ForClause \1AC
|
|
Placeholder
|
|
%33.
|
%19.
|
%19.
|
%17.
|
%33.
|
%19.
|
|
%33.
|
|
Cull Data Items
The following items are required to be in the Culls file
in the order shown here:
|
output file
|
Cow
Number
|
Barn name
|
Lactation
Number
|
Cull
Date
|
|
|
FILEOUT
|
ID
|
BNAME
|
LACT
|
ARDAT
|
ForClause \2ACB
|
|
Placeholder
|
|
%33.
|
|
%18.
|
|
Creating “Culls” File
This section will describe the “Fileout” (Export)
command to be used to create the culls file.
Cull cows represent the cows from an existing SMS herd that
have left the herd since your last SMS visit. Therefore,
we need to know the date of the last SMS visit so we can
use that date as part of out Dairy Comp 305 fileout command.
Here is a sample fileout command for creating a “Culls”
file:
FILEOUT ID BNAME LACT ARDAT ForClause \2ACB
Note: You must supply a proper ForClause and always follow
the “ForClause” with the following switch: \2ACB
The first line shows all of the items we are trying to obtain
for the SMS program. The second line shows the “place
holders” for the fields above them Use the corresponding
“place holder” for an item when a dairy does not
use that item. For example, use the following command for
a herd that does not use BNAME (barn name):
FILEOUT ID %33. LACT ARDAT ForClause \1AC
The are only other thing that you should or may need to
change on this command is the “For clause”. The
date will obviously change for each situation. Or, you may
wish to use some entirely different criteria for selecting
the Culls.
Here are some samples that could be used as the ForClause
in the above commands:
1. All animals that have left the herd on or since 5/01/03
FOR ARDAT>=5.1.3
2. All cows that have left the herd since 3/31/03
FOR ARDAT>3.31.3 LACT>=1
3. All animals from pen 2 that have left the herd since
6/01/03
FOR ARDAT>=6.1.3 PEN=2
Creating “Pedigree Information”
File
This section will describe the “Fileout” (Export)
command to be used to create the pedigree information diskette
file.
As mentioned above, the pedigree information can be used
for two different purposes. First, to create SMS II evaluation
records. Second, to update pedigree data for existing cows.
How you want to use the data, will be the driving force
in how you formulate the “For clause”. If the
data will be used for SMS II, you probably just want a specific
group of cows or heifers. If the data will be used for updating
pedigree data, then you may want to select the entire herd
or just those fresh since a certain date.
Here is a sample fileout command for creating a “Pedigree”
file:
FILEOUT ID BNAME SID MGSID DID DNAME MMGSID LACT CBRD
ForClause \1AC
Note: You must supply a proper ForClause and always follow
the “ForClause” with the following switch: \1AC
The first line shows all of the items we are trying to obtain
for the SMS program. The second line shows the “place
holders” for the fields above them Use the corresponding
“place holder” for an item when a dairy does not
use that item. For example, use the following command for
a herd that does not use BNAME (barn name), DNAME (dam Name),
and MMGSID (Mat Mat Gr Sire):
FILEOUT ID %33. SID MGSID DID %33. %19. LACT CBRD ForClause
\1AC
Here are some samples that could be used as the ForClause
in the above commands:
1. All cows fresh on or since 5/01/03
FOR FDAT>=5.1.3
2. All first lactation cows fresh on or since 4/01/03
FOR FDAT>=4.1.3 LACT=1
3. All heifers that have not been bred
FOR LACT=0 TBRD =0
4. All unbred heifers born after 6/01/02
FOR LACT=0 TBRD=0 BDAT>6.1.2
Common Items that may be useful
Here are some of the more common items that will be used
in either the item lists, or the For clauses:
Item Description
AGE Age in months
ARDAT Archive Date (Date Out)
BDAT Birth Date
BNAME Barn Name
CBRD Cattle Breed
DID Dam Identification
FDAT Fresh Date
ID Animal’s Identification
LACT Lactation number
MGSID Maternal Grandsire
PEN Pen or String
RC Reproductive Code (1-7)
SID Sire Identification
TBRD Times Bred
TODAY Today’s Date
Email the file you create
to All West/Select Sires
