support
Support > Web Portal Documentation > Records > Import Records > File Prep
File Preparation
-
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