AgriWebb allows you to import CSV files of the individual animals on your farm. The best way to import these animals is to export a separate CSV for each breed to make it easier when importing. Each CSV can only contain either Sheep or Cattle.
What is a CSV File?
A CSV (comma-separated values) is a plain text file. Each row of the text file represents a set of information. Data is represented in a similar way (row by row) but the key thing is that the format of the file is completely different to an excel spreadsheet.
If exported and downloaded from your Indicator it will be a CSV file.
If the file is opened or created as an excel spreadsheet (.xlsx). Follow the steps to Save as a CSV File.
File > Save As > Change the File Format to (.csv)
TIPS Before Importing Animals
Have you setup your Enterprises & Management Groups?
Your CSV can only contain either Sheep or Cattle.
If you don’t have an exported CSV you can download the AgriWebb animal import template file to get started. Fill in the template on Excel with your animals and then export the document as a CSV file to import into AgriWebb.
Understanding the CSV Template
Breed - see how to set up your farm breeds here.
Age Class - see how age classes are managed here.
Date of Birth
For the mature age classes Ewe, Maiden Ewe, Ram, Bull, Steer, Cow, Heifer, and Yearling, you may choose "year" for date of birth or choose "Do not track"; otherwise a "day" or "month" of birth is required.
NOTE: In the UK, a specific DOB is required for government registration purposes.
EID or Visual ID (or both) - Electronic ID is a unique identifier, this field only accepts a 15 digit number, suggesting the RFID number of the NLIS ear tag. Visual ID is a unique identifier and we suggest using the Visual ID for the number on animals coloured ear management tag.
Location - what paddock they're in or going to be in. NOTE: this can be updated later while the animals are still on your account
Last Weighed Date
Date on Farm - If the Date on Farm (dd/mm/yyyy) is not specified it will default to the animal's Date of Birth.
Management Group - see how to set up Management Groups and Enterprises
Tag Colour - see how to create Tagging Records
Sire Visual ID
Dam Visual ID
NOTE: All these records can be changed by Importing Animal Updates from CSV.
Feel free to follow along with the steps in the article or the video below. For more videos like this, navigate to the AgriWebb Academy from mobile or web app.
Upload your CSV
On the Web App, select the Livestock section from the navigation panel on the left
On the Individuals tab at the top of the page, select Add Animal in the top right, and then Import.
Choose sheep or cattle.
On the Import CSV page, choose Start in the bottom left corner.
Select Upload from computer or drag and drop the csv file into the box.
Map the Columns to Import
We will attempt to identify all the columns in your CSV document and match them with AgriWebb animal properties. Incase there are columns we don’t recognise, you can review the mapping and make changes.
The required columns for importing are Breed, Date of Birth, and Age Class. Note: These columns determine the Age Class of the animals and allow AgriWebb to auto age your stock. For further information on how this is calculated see Livestock Age Classes.
For each animal column you wish to import that has not been automatically mapped, you can choose one of the following input methods.
Additional columns can also be imported such as VID, EID, Date on Farm, Tag Colour, Tattoo, Brand, Weight, Last Weighed Date, Dam and Sire EID's and VID's.
Note: EID column only accepts a 15 digit number, suggesting the RFID number of the RFID tag.
An electronic Radio Frequency Identification Device (RFID) has both an NLISID and an RFID number.
An NLIS number is printed on the outside of ear tag, can only be read visually by looking at the number. If you wish to also record this number we suggest placing in the Name column.
An RFID number is assigned to the electronic RFID chip inside a device, can only be read electronically when scanned by a tag reader.
Visual ID is suggested to be used for the coloured ear management tag. This is easily read and animal identified in the paddock to then search within AgriWebb.
If we are unable to identify any values in your CSV you will be able to provide a valid value. This could be due to missing or invalid data in your CSV. In the below example Breed and Last Weighed Date were empty.
Preview and Complete
You will be shown a small preview of your data to be imported. If all the columns look correct you can select Import to create your animals. You will be returned to the animal list to view them.
Review conflicts with existing animals
You will not be able to import any animals in your CSV that have an EID or VID that matches an animal already in AgriWebb. You will be able to review these animals before proceeding with the Import. If the conflict is a mistake you can update your CSV and import it again.
Resolve conflicts within your CSV
As you cannot have duplicate EIDs / VIDs in AgriWebb, we will identify any conflicts in your CSV and you can choose which animals you want to import. If you identify any of the conflicts as errors in your data, you should update your CSV and upload it again.