Add Individual Livestock - CSV Import

AgriWebb allows you to add new animals into your AgriWebb by importing a CSV file.

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 you are working in an excel spreadsheet (.xlsx) > Save As > File Format > CSV (Comma-delimited) (.csv) to convert your sheet to a CSV file ready to upload into AgriWebb.

To import animals into AgriWebb, upload your own CSV file via the importer.

Follow along with the steps in the article or the video below.

For more videos like this, navigate to the AgriWebb Academy.

TIPS Before Importing Animals

• Have you setup your Enterprises & Management Groups?

• Your CSV can only contain either Sheep or Cattle.

• We suggest having a seperate CSV for each different Age Class group ie. Cows and Steers in seperate CSV files.

• Read this article and download the AgriWebb Example CSV File before importing to ensure you have the required information for your animals to complete the import.

• Customers located in the United States download the AgriWebb US Animal Example CSV File

Understanding the CSV to match AgriWebb Importing

A CSV can only contain either Sheep or Cattle. The best way to import animals is to have a separate CSV for each Age Class to make it easier when importing.

If exported and downloaded straight from your Indicator hardware it will be a CSV file.

We suggest filling in the template in Excel and then export the document as a CSV file to import into AgriWebb.

Mandatory Fields required when importing new animals (Indicated by * within the example file)

Recommended Fields to include when importing new animals (Indicated by ^ within the example file)

Use Row 1 for your column headings. Ensure there are no additional rows with headings or text.

Electronic ID^

^Recommended field

Electronic ID is a unique identifier. This field only accepts a 15 digit number, suggesting the RFID number of the NLIS ear 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.

Example:

This field can be changed by Importing Animal Updates from CSV.

Visual ID^

^Recommended field

Visual ID is a unique identifier. We suggest using the Visual ID for the number on animals coloured ear management tag. This can be easily read and the animal identified in the paddock to then Search by VID within AgriWebb.

Example:

This field can be changed by Importing Animal Updates from CSV.

Breed*

*Required field

The breed name must match the name in the below table.

If within your CSV animals are all the same breed, we suggest leaving column blank in CSV and select 'Use Manual Value' when mapping imported columns to select from the dropdown list of breeds that appear.

This field can be changed by Importing Animal Updates from CSV.

Sex*

*Required field

It is recommended within your CSV all animals are the same sex. You can leave the column blank in CSV and select 'Use Manual Value' when mapping imported columns to select from the dropdown option that appears.

If the animal is imported as the wrong sex, to update animal sex > select animal from individual animal list > Actions > Edit details > Change sex

Location^

^Recommended field

Location is the name of the paddock mapped on your AgriWebb farm map. You can also import animals into AgriWebb but not allocate them to a paddock on your farm map.

Example:

You can also assign the location after the animal is imported into AgriWebb, by creating a 'Move' record.

Livestock > Individuals > Add Records > Create Record > Move

This field can be changed by Importing Animal Updates from CSV.

Date of Birth*

*Required field

Date of Birth (dd/mm/yyyy) for an animal is a required field. If you dont know the specific date of birth, use the birth year and estimate start of lambing/calving period.

The date of birth is required to determine the Age Class of the animal.

Example:

This field can be changed by Importing Animal Updates from CSV.

Has Offspring^

^Recommended field

Indicates Yes or No that an animal has had offspring to determine the correct age class without tracking the offspring through birth records.

This field can be changed by Importing Animal Updates from CSV.

Birth Date Accuracy

Birth date accuracy can be viewed against the animal on the Individual animal list.

This field can be changed by Importing Animal Updates from CSV.

Weaned*

*Required field

Required to determine the age class of the animal.

This field can be changed by Importing Animal Updates from CSV.

Date on Farm^

^Recommended field

If the Date on Farm (dd/mm/yyyy) is not specified it will default to the animal's Date of Birth.

Example:

Date on Farm can only by updated by selecting the animal > History > Find the Date on Farm record > Review > Change the date

If multiple animals have wrong the Date on Farm on import, contact the Farm Success Team to help update.

Fertility^

^Recommended field

This field is important when importing Steers or Wether. To ensure the Age Class of these individuals is not added as Bulls or Rams, select Neutered within the Fertility column.

This field can be changed by Importing Animal Updates from CSV.

Tag Colour

This field can be changed by Importing Animal Updates from CSV.

Name | Tattoo | Brand

Free text fields

Example:

This field can be changed by Importing Animal Updates from CSV.

Weight^

^Recommended field

Animals last recorded live weight in Kilograms (kg).

Example:

If you choose not to import animal weight now, you can simply add after importing the animal.

Livestock > Individuals> Add Records > Import Weights from CSV

Last Weighed Date^

^Recommended field

The date (dd/mm/yyyy) the animal was last weighed.

Note: If a CSV of weights is downloaded from your indicator, ensure you remove the time stamp out of the date column (eg. 16/05/2022 09:51:08).

Example:

SIRE

Animals parentage.

If the Sire is in your AgriWebb it will hyperlink the parentage by matching the Sire Visual ID or Sire Electronic ID.

Example:

This field can be changed by Importing Animal Updates from CSV.

DAM

Animals parentage.

If the Dam is in your AgriWebb it will hyperlink the parentage by matching the Dam Visual ID or Dam Electronic ID.

Example:

This field can be changed by Importing Animal Updates from CSV.

Management Tag

Free text field.

Example:

This field can be changed by Importing Animal Updates from CSV BUT it does not replace existing Management Tag, will cumulate the Management Tag.

To delete or remove > select animal > History > Find Tagging record > Review > Edit Management tag field.

Management Group^

^Recommended field

A Management Group defines similar animals that are managed in the same way within an Enterprise.

Management groups must be created prior to being able to assign animals to a management group on import. How to setup Enterprises and Management Groups.

Example:

To assign or change an animal to a Management Group once imported, you can simply go to Livestock > Individuals> Add Records > Create Records > Set Management Group.

How to Import your CSV file into AgriWebb

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 new animals from CSV.

Choose Sheep or Cattle

On the Import CSV page, choose Start in the bottom right corner.

Select Upload from computer or drag and drop your csv file into the box.

A successful upload of CSV will take you directly to Map Import Columns page.

How to Map the Columns in CSV to Import

TIP When first importing, open up your CSV file on your computer so you can

reference/compare the columns.

We will automatically attempt to identify the columns headings in your CSV and match them with the AgriWebb fields. Incase the columns dont map correctly or we dont recognise, you can review the mapping and make changes.

The required fields for importing are Breed, Birthdate, Sex and Weaning status.

Note: There are may other fields outlined above that may also be required to accurately import the animals correctly. For further information on how the Age Class of animals is calculated see Livestock Age Classes.

For each animal property you wish to import that has not been automatically mapped or is not within your CSV, you can choose one of the following input methods.

Bottom right select Next

Select Preview to view the animal data to be imported.

If all the columns look correct you can select Complete Import to create your animals. You will be returned to the individuals animal list to view and create records against the animal.

Fixing Errors

If we are unable to identify any values in your CSV column 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.

Duplicate EIDs / VIDs

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.

Conflicting EIDs / VIDs

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.

Now your animals are imported into AgriWebb, you can begin creating records against the animals history ie. Purchase record, Treatments etc.

Helpful Articles

Creating Records (Individuals)

Record Templates (Individuals)

Live Session - Add Animals