Prepare file using Microsoft Excel in the same format as the following file - Import Records Template.xlsx

Use the following format rules when populating the data in the Excel file

• Date - Indicates the date that the animal data element and value was recorded for the animal

  • Must be in the following format -dd/mm/yy

  • Must not be prior to year 2006 or exceed current date that import is attempted

• Time - indicates the time that the animal data element and value was recorded for the animal

  • Must be in the following format - hh:mm:ss​

  • Must not exceed 23:59:59

• EID - indicates the EID number assigned to the animal's RFID tag

  • Must be 15 digits long

  • No spaces between digits

• Visual Tag Number - the visual number printed on the Animal's tag

  • Up to 20 characters long​

  • Allows spaces

• VID Year - the year associated with the animal's Visual Tag

  • 9999 (indicates unknown) and years 2007 through 2019​

• Animal Type - Cattle, Deer or Sheep

• Tag Colour - the color of the animal's tag

  • Acceptable values: Black, Blue, Brown, Clear, DarkBlue, DarkGreen,  DarkPink,  DarkPurple, Grey, Green, LightBlue, LightGreen,  LightPink, LightPurple, Orange, Pink, Purple, Red, Salmon, White or Yellow​

• Data Element & Value

  • Click here for a file containing data standards for all data elements and values

Required information for any record:

• Date

• Time

• Either

  • An EID and Animal Type​ OR

  • An EID and unique combination of Visual Tag Number + VID Year + Animal Type

• Data Element Name & Value

• Optional (Tag Colour)

Maximum number of rows per import file: 5,000

Save the worksheet as a Comma Separated Values (.csv) file format with a file name & location on your system you will remember