Skip to the content
Menu

Electronic data

The Signet Beefbreeder service has the facility to accept data in an electronic format. Supplying data in this format enables results to be uploaded directly to the database, reducing operator error and enabling results to be processed faster.

This approach is particularly useful for larger herds and those with their own on-farm software.

The following files can be submitted to Signet

 

File specification for sending cattle records to Signet in an electronic format (Version 10. 17th November 2020)

1). Animal Records (to include new calves born)

For data to be uploaded it needs to be supplied in the exact format shown overleaf. There are 30 fields in total, but only 10 are compulsory and many fields (such as ET recipient or Breed) will have a standard replicated entry.

These notes assume records will be sent using an Excel spreadsheet or csv file.

User notes:

  • All UK born animals born since 1st January 2000 must have a UK ear number. Older cattle and imported animals can be entered with a herdbook number.
  • Sire and dam identities need to match Signet records exactly – extra or missing, spaces or dashes within ear number fields will cause records to be rejected.
  • If you need to check the Signet recognised UK number or Herdbook Number for a sire or dam known to Signet, please check it using “Quick Search” on the Signet website www.signetdata.con
  • Sires and dams must be no more than 16 years older than their progeny
  • Sires and dams must be at least 200 days older than their progeny
  • Although Prefixes and Names of up to 50 characters can be used, long IDs should be avoided as they may create reporting problems
  • Owner and Breeder Herdmark is the numeric part of the holding identifier in the UK number. For herd “UK 123123” the herdmark will be “123123”.
  • Breed Name and Breed Code – use exact Signet recognised breed name (see table)
  • Where a sire or dam is not known to Signet, the parent’s details should be supplied as a separate record. This approach allows multi-generational pedigrees to be uploaded.
  • The Constituent Breed/Sixteenths of Breed column can be left blank and these will be assigned based on the parents breed make up. If Breed 16ths are assigned, the four sixteenths of breed boxes must equal 16.

File specification for animal records

The list shows the exact field name to be used, followed by any notes relating to the expected content.

 

Exact Field Name Data to go into the field
UKMINISTRYTAG UK Ministry Tag must be in format: UK 123456/123456
HERDBOOKNUMBER Society herdbook number. Must be between 1 and 15 characters.
SEX M, F or C
DATEOFBIRTH Must be in format: DD/MM/YYYY or DDMMYYYY or DD-MM-YYYY
PREFIX Anything between 0 and 50 characters. For unknown leave blank.
NAME  Anything between 0 and 50 characters. For unknown leave blank. 
BIRTHWEIGHTTACT_KG Actual birth weight. Values between 10-95kg
STATUS LIVE, DEAD or SOLD
EOCALVING (SCORE FOR CALVING EASE) Unknown or 1,2,3,4 or 5
SERVICEID NATURAL, ARTIFICIAL INSEMINATION, EMBRYO TRANSFER, UNKNOWN
BIRTHTYPEID SINGLE or TWIN
TWINSEX M, F (or blank)
GESTATIONLENGTH_DAYS Values in range of 250 - 300 (Unknown, leave blank)
OWNER HERDMARK Herd number within UK Number. For UK 123456, enter "123456"
BREEDER HERDMARK Herd number within UK Number. For UK 123456, enter "123456"
BREED Breed Name
EAR_NUMBER_OF_DAM Either UK number or Herdbook number. For unknown put "-"
EAR_NUMBER_OF_SIRE Either UK number or Herdbook number. For unknown put "-"
FERTILISED_OVUM_TRANSFER Y or N
EAR_NUMBER_OF_RECIPIENT_DAM Either UK number or Herdbook number. (Blank if not relevant)
FOSTERED Y, N, A, U - Where Y=Yes to a known cow, provide details, N=No, A=Artificially Reared, U=Fostered onto an unknown cow
EAR_NUMBER_OF_FOSTER_DAM Either UK number or Herdbook number. (Blank if not relevant)
CONSTITUENT_BREED_ONE Breed code; Example SU, BA, LR etc (or leave blank)
SIXTEENTHSOFBREED_ONE Number 1-16 (or blank)
CONSTITUENT_BREED_TWO Breed code; Example SU, BA, LR etc (or leave blank)
SIXTEENTHSOFBREED_TWO Number 1-16 (or blank)
CONSTITUENT_BREED_THREE Breed code; Example SU, BA, LR etc (or leave blank)
SIXTEENTHSOFBREED_THREE Number 1-16 (or blank)
CONSTITUENT_BREED_FOUR Breed code; Example SU, BA, LR etc (or leave blank)
SIXTEENTHSOFBREED_FOUR Number 1-16 (or blank)

 

2). Weight Records

Signet clients can export weights directly to Signet. Signet requests the raw weights collected on the day, not weights that have been adjusted to 100, 200, 300 days etc.

User notes:

  • All weight records must be reported against a UK ear number.
  • UK ear numbers need to match Signet records exactly – extra or missing spaces or dashes within the UK ear number field will cause records to be rejected.
  • Weight should be measured in kilogrammes – to the nearest whole number
  • Each animal weight record must be assigned to a management group.
  • Only one weight record per animal can be uploaded at a time (but the Signet team can sub-divide the file if needed).

 

Exact Field Name  Data to go into the field
UKMINISTRYTAG UK Ministry Tag must be in format: UK 123456/123456
CATTLE WEIGHT Weight in kg
WEIGHT DATE Must be in format: DD/MM/YYYY or DD-MM-YYYY. Must be between 14 and 700 days after the animals date of birth
MANAGEMENT GROUP Value must be one of 221, 222, 223, 224, 225, 226, 441, 442, 443, 451, 452, 453, 461, 462. Click here for details
SCROTAL CIRUMFERENCE Value in mm. Bulls only.
ANIMAL STATUS LIVE, DEAD or SOLD

 

3). Census data

Recording census data couldn't be easier - just provide a two column file listing the UK Ministry Tag for the cattle that have died or been sold and note their new status in the second column.

Exact Field Name  Data to go into the field
UKMINISTRYTAG UK Ministry Tag must be in format: UK 123456/123456
ANIMAL STATUS LIVE, DEAD or SOLD