How to prepare a CSV file for registering animals
This file can be used to upload animal registration information to the NAIT system.
Your CSV file will need to include all of the column headings, in the correct order. This includes headings for optional columns you are leaving blank.
| Column | Heading | Format |
|---|---|---|
| A | Date Of Birth | Date information must be in a recognisable format, e.g. dd/mm/yyyy, dd/mm/yyyy hh:mm:ss, yyyy-mm-dd etc. |
| Please note any time component will not be stored in the database. | ||
| The date must be on or before the current date. If you do not know the animal's date of birth you can enter 'unknown', although this will mean the animal does not have lifetime traceability. | ||
| B | NAIT Number Of Birthplace | Must be a valid NAIT number. If you do not know the NAIT number of the animal's birthplace you can enter 'unknown', although this will mean the animal does not have lifetime traceability. |
| C | NAIT Number At First Registration | Must be a valid NAIT number. |
| D | Animal Type | Cattle = C |
| Deer = D If you are registering deer you will also need to complete column J. | ||
| E | NAIT RFID | This is the unique 16 character code that relates to the NAIT tag. This information is provided by tag manufacturers or can be read with a scanner. It does not have to be provided if a NAIT Visual ID is provided. Examples that will be accepted include: · 00000 0 982 000196588496 · 942 000002422333 · 982 000161531687 · 0982000190869343 · 0982 000190869343 |
| F | NAIT Visual Tag Number | This is the information printed on the outside of the tag. It does not have to be provided if a NAIT RFID is provided. Find out how to correctly enter NAIT Visual IDs |
| G | External Record ID | You can choose to enter a reference number of your own, e.g. 1, 2, 3, 4. This will make it easier for you to identify which record (row of your spreadsheet) is incorrect if you make a mistake in your CSV. |
| H | Production Type | Dairy = D |
| Beef = B | ||
| Venison = VE | ||
| Velvet = VT | ||
| Trophy = TR | ||
| I | Gender | Male = M |
| Female = F | ||
| J | Species Type | You must enter this field if the animal type is deer. Leave this blank for cattle. |
| European red deer = RD | ||
| Elk (Wapiti) = EK | ||
| Sambar = SM | ||
| Rusa deer (Sundar Samba) = RU | ||
| Pere David's deer = PD | ||
| European Fallow deer = FD | ||
| White-tailed deer = WT | ||
| Sika = SK | ||
| Mesopotamian = MS | ||
| K | Breed | You must enter this field if the animal type is cattle. Leave this blank for deer. |
| Friesian = FR | ||
| Jersey = JE | ||
| Dairy Cross = DC | ||
| Ayrshire = AS | ||
| Milking Short Horn = SH | ||
| Buffalo = BU | ||
| Other = OT | ||
| L | Breed Other Description | Applies to Cattle only. Cannot be entered where Animal Type is Deer. A short description of the breed when breed ‘Other’ has been specified. |
| M | Age Months | Applies to Cattle only. Cannot be entered where Animal Type is Deer. The age of the animal in months. If Age Years is also specified, the Age Months will be added to Age Years. |
| N | Age Years | Applies to Cattle only. Cannot be entered where Animal Type is Deer. The age of the animal in years. |
| O - Q | Other Animal Identifiers | This can be anything you use to identify an animal, e.g. a visual panel tag, a management tag or a name. |
| R | Import Date | If present, must be in a recognisable format as per date of birth. It must be on or before the current date, and after the birth date. Must be entered if an import country is specified. Must not be entered if no import country is specified. |
| S | Import Country Of Origin | Must be a valid ISO country code. Must be entered if an import date is specified. Must not be entered if no import date is specified. |
| T - X | Livestock Characteristics Type 1 - 5 | Can only be updated by an authorised user. To add details for a cloned or genetically modified animal, please call the NAIT Contact Centre on 0800 624 843. |