Data Types/Stockbook Field for Import (Details from a Data File)

What can I import in a CSV file and what do I link it to? (Match the fields ...) 

The current Stockbook importing module is setup to import the following, these will show up under Data Type: 

• Life Data
• Weight
• Date
• Trait
• Carcase
• EBV
• Society Details
• Treatment Details
• Joining Details
• Preg Test Details
• ET Flush 
• ET Transfer 
• Location/Group
• General
• Scanning
• Faecal Egg Count 
• Sale Data
• Purchase Details
• Costs
• Extra Carcase Data 
• Sale Catalogue

Once the Data Type has been selected, then the Stockbook Field menu will show more linking options relevant to that particular link type as shown below.

Life Data

• ID
• EID
• Alternate. ID
• Sire ID
• Sire EID
• Sire Society ID
• Dam ID
• Dam EID
• Dam Society ID
• Foster Dam ID
• Recip Dam ID 
• Embryo ID
• Sex
• Birth Date
• Birth Year
• Birth Ease
• No. In Birth
• Breed 1 
• Breed 1%
• Breed 2 
• Breed 2%
• Breed 3
• Breed 3%
• Breed 4 
• Breed 4%
• Breed 5 
• Breed 5% 
• Breed 6 
• Breed 6%
• Alive/Dead
• Genetic Mgt. Grp
• Colour
• DNA Sample No. 
• Horn 
• Name
• Mating Type (existing animals)
• NLIS Id
• Dentition
• Purchase Price ($/hd)
• Vendor PIC
• Flock/Herd

Weight

• Weight
• Weight (Purchase)
• Wt. Perf. Mgt. Grp. 
• Weight Type
• Weight Herd

Date

• Observation Date 
• Last Handled SB Date
• Last Handled SB Live

Trait

This list will always contain the following four Stockbook Fields:

• Trait Code
• Trait Value
• Trait Mgt. Grp.
• Trait Obs. Code
• Trait Comment
• Hair Sample No. (#Score)
• Hair Sample No. (#Mgt.Grp)
• Hair Sample No. (#Obs.Code)
• Hair Sample No. (#Comment)
• PMM Relaibility Score (#Score)
• PMM Relaibility Score (#Mgt.Grp)
• PMM Relaibility Score (#Obs.Code)
• PMM Relaibility Score (#Comment)
• Number Reared (#Measurement)
• Number Reared (#Mgt.Grp)
• Number Reared (#Obs.Code)
• Number Reared (#Comment)
• TSU Sample No. (#Score)
• TSU Sample No. (#Mgt.Grp)
• TSU Sample No. (#Obs.Code)
• TSU Sample No. (#Comment)

And will then list the following for each individual trait you have personally set up in the Setup menu:

• Trait Name(#Measurement / #Index / #Score)
• Trait Name(#Mgt.Grp)
• Trait Name(#Obs.Code)
• Trait Name(#Herd)
• Trait Name(#Comment)

Carcase 

• Body No.
• P8 Fat
• Muscle Score/Butt
• Marbling
• Meat Colour
• Fat Colour
• Texture
• Rib Fat
• EMA
• VIA IMF %
• VIA EMY
• Tenderness
• Ph
• Sale Meat Yield
• Ossification
• MSA Grade
• MSA Index
• Carcase Hot Weight
• Carcase Price (Per Kg)
• Left Hot Weight
• Right Hot Weight
• Left Price
• Right Price
• Left Bruise
• Right Bruise
• Left Grade
• Right Grade
• Dentition
• JAS No.

EBV

This list will contain all EBVs that you have active under the EBV Setup Menu

Society Details

• Society Id.
• Society Tattoo
• Society Horn
• Society Colour
• Left Eye Pigment 
• Right Eye Pigment 

Treatment details

• Product 1
• Product 1 Qty.
• Product 1 Batch No.
• Product 1 Comment
• Product 2
• Product 2 Qty.
• Product 2 Batch No.
• Product 2 Comment
• Product 3
• Product 3 Qty.
• Product 3 Batch No.
• Product 3 Comment
• Product 4
• Product 4 Qty.
• Product 4 Batch No.
• Product 4 Comment

Joining Details

• Join Herd (new join)
• Join Perf.Mgt.Grp. (new join)
• Join Sire (new join)
• Join Type (new join)
• Join Code (new join)
• Join Reference (new join)
• Practitioner (Contact Code Only)
• Join End/Out Date (new join)
• Join Comment (new join)

Preg. Test Details

• PT Result.
• PT Week No.
• PT No. Foetuses Detected
• PT Start Conception Date
• PT Backup Sire
• PT Sire ID

ET Flush 

• Donor
• Sire
• No. Implanted
• No. Frozen
• No. Infertile
• No. Degenerated
• Comment
• Program Name
• Practitioner (Contact Code Only)
• Freeze Method

ET Transfer

• Recip. Dam
• Embryo Id
• Donor Dam
• Sire
• Comment
• No. of Embryos
• Program Name
• Practitioner (Contact Code Only)
• Stage
• Grade/Quality
• Location (Contact Code Only)
• Implant Date
• Flush Ref.
• Synchronisation
• Side

Location/Group

• Mob
• Group
• Paddock (No.)
• Paddock (Name)

General

• Animal Note
• Animal Comment

Scanning

• Scanned EMA
• Scanned EMD
• Scanned EMW
• Scanned Rib Fat
• Scanned Rib Site
• Scanned Rump Fat
• Scanned Marble %
• Scan Perf.Mgt.Grp.
• Scan Obs. Code
• Scan Herd

Faecal Egg Count Data

• WEC
• WEC Strongyle
• WEC Nematodirus
• WEC Homoncus
• Faecal Consistency
• WEC Perf.Mgt.Grp
• WEC Obs. Code
• WEC Flock/Herd

Sale Data

• Price $/hd
• Price c/kg

Purchase Details

• Price $/hd
• Price c/kg
• Vendor PIC
• Vendor Dec.

Costs

• Cost Amount ($)
• Description 
• Date

Extra Carcase Data

• Alpha 1 Field 
• Alpha 2 Field
• Alpha 3 Field
• Alpha 4 Field
• Alpha 5 Field
• Alpha 6 Field
• Alpha 7 Field
• Alpha 8 Field
• Alpha 9 Field
• Alpha 10 Field
• Alpha 11 Field
• Alpha 12 Field
• Number 1 Field
• Number 12 Field
• Number 3 Field
• Number 4 Field
• Number 5 Field
• Number 6 Field
• Number 7 Field
• Number 8 Field
• Number 9 Field
• Number 10 Field
• Number 11 Field
• Number 12 Field

Sale Catalogue

• Sale Catalogue Name
• Sale Catalogue Lot Number
• Sale Catalogue Notes