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:

Electronic ID

951000307592800

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:

Visual ID

210

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.

Cattle

Cattle cont..

Sheep

Aberdeen Angus

Lim x Sim

1st Cross

Aberdeen Angus Cross

Limousin

2nd Cross

Africander

Limousin Cross

Aberdale

Angler Rotvieh

Lincoln Red

Abro Damline

Angler Rotvieh Cross

Lincoln Red Cross

Aussiedown

Angus

Longhorn

Australian White

Angus Lowline

Longhorn (Texas)

Avranchin

Angus x

Longhorn Cross

Balwen Welsh Mountain

Angus x Limousin

Lowline

Beltex

Angus x Wagyu

Luing

Beulah Speckled Face

Ankole

Luing Cross

Black Baldy

Armoricaine

Maine Anjou

Black Welsh Mountain

Armoricaine Cross

Maine Anjou Cross

Blackface

Aubrac

Malkekorthorn

Bluefaced Leicester

Australian Friesian Sahiwal

Malkekorthorn Cross

Boer Goats

Australian Illawarra Shorthorn

Mandalong Special

Bond

Australian Lowline

Marchigiana

Border Leicester

Australian Milking Zebu

Marchigiana Cross

Bowmont

Australian Red

Mesopotamian

Brecknock Hill Cheviot

Australis South Devon/Angus

Meuse Rhine Issel

British Bleu De Maine

Ayrshire

Meuse Rhine Issel Cross

British Charolais

Ayrshire Cross

Milking Short Horn

British Gotland

Ayshire

Milking Shorthorn

British Icelandic

Baltata Romaneasca

Mixed

British Inra 401

Barzona (Composite)

Muese-Rhine-Issel

British Milk Sheep

Bazadaise

Murray Grey

British Rouge De L'Ouest

Bazadaise Cross

Murray Grey Cross

British Texel

Beef Shorthorn

Murray Grey x Angus

British Vendeen

Beef Shorthorn Cross

Nelore

Cambridge

Beefalo

Normande

Castlemilk Moorit

Beefmaker

Normande Cross

Charmoise

Beefmaster

Northern Dairy Shorthorn

Clun Forest

Belgian Blue

Norwegian Red

Cobb 101

Belmont Red

Norwegian Red Cross

Colbred

Belted Galloway

Old English

Comeback

Belted Galloway Cross

Old English Cross

Composite

Belted Welsh Black

Other

Coopworth

Belted Welsh Black Cross

Other Dairy

Cormo

Bison

Parthenais

Corriedale

Black Angus

Parthenais Cross

Cotentin

Black Simmental

Pere David's deer

Cotswold

Blonde d'Aquitaine

Pie

Crossbred

Blonde d'Aquitaine Cross

Piedmontese

Dalesbred

Blue Albion

Piemontese

Dartmoor (Greyfaced)

Blue Albion Cross

Piemontese Cross

Derbyshire Gritstone

Blue Grey

Pinzgauer

Devon & Cornwall Longwool

Blue Grey Cross

Pinzgauer Cross

Devon Closewool

Boran

Poll Charolais

Dohne

Braford

Poll Devon

Dohne x Terminal

Brahman

Poll Hereford

Dorper

Brahman Cross

Poll Shorthorn

Dorset Down

Brahmousin

Poll Simmental

Dorset Horn

Braler

Red & White Holstein

Dorset x Merino

Brangus

Red Angus

Drysedale

Braunvieh

Red Composite

East Friesian

Bretonne Pie-Noire

Red Poll

Easycare

Bretonne Pie-Noire Cross

Red Poll Cross

Elete Meat Plus

Bristish White

Red Sindhi

Est A Laine Merino

British Blue

Reggiana

Exmoor Horn

British Blue Cross

Reggiana Cross

F1 Awassi X Terminal

British Friesian

Riggit Galloway

Finish Landrace

British Friesian Cross

Riggit Galloway Cross

Gotland Fursheep

British White

River Buffalo

Hampshire Down

British White Cross

Romagnola

Hebridean

Brown Swiss

Romagnola Cross

Herdwick

Brown Swiss Cross

Rotbut

Highlander

Buffalo

Rotebunde

Hill Radnor

Charbray

Rotebunde Cross

Hoachen

Charolais

Rusa deer (Sundar Samba)

Ile De France

Charolais x Angus

Sahiwal

Jacob

Chiangus

Sahiwal-Shorthorn

Kent Halfbred

Chianina

Salers

Kerry Hill

Chianina Cross

Salers Cross

Leicester Longwool

Chillingham

Sambar

Lincoln Longwool

Chillingham Cross

Santa Gertrudis

Llanwenog

Clifford

Shaver Beefblend

Lleyn

Cross Breed Beef

Shetland

Lomond Halfbred

Cross Breed Dairy

Shetland Cross

Lonk

Dairy Cross

Shorthorn

Manx Loghtan

Dairy Shorthorn

Shorthorn x Angus

Masham

Dairy Shorthorn Cross

Sika

Meatlink

Danish Red

Simbrah

Merino

Danish Red Cross

Simford

Merino/Border Leicester 1X

Devon

Simindicus

Merino/Poll Dorset 1X

Devon Red

Simmental

Merino/White Suffolk 1X

Devon Red Cross

Simmental Grey

North Country Cheviot

Dexter

Simmental x Angus

North of England Mule

Dexter Cross

South Devon

North Ronaldsay

Droughtmaster

South Devon Cross

Oldenburg

Droughtmaster x

Speckle Park

Orkney

Durham

Speckle Park

Oxford Down

Dwarf Zebu

Speckle Park Cross

Poll Dorset

East Finnish Brown

Stabiliser

Poll Merino

East Finnish Brown Cross

Stabiliser Cross

Polwarth

Elk (Wapiti)

Station

Portland

English Park

Sussex

Primera

English Park Cross`

Sussex Cross

Romney

Estonian Red

Swamp Buffalo

Rough Fell

Estonian Red Cross

Swedish Red

Roussin

European Fallow deer

Swedish Red & White

Ryeland

European red deer

Swedish Red & White Cross

SAMM

Flekvieh

Swedish Red Cross

Scotch Halfbred

Flekvieh Cross

Swedish Red Polled

Scotch Mule

Friesian

Swiss Braunvich

Scottish Greyface

Friesian (Holstein)

Swiss Braunvich Cross

Shetland

Frisona Espagola

Swiss Grey

Shetland-Cheviot

Frisona Espagola Cross

Swiss Grey Cross

Shropshire

Galloway

Swiss Orig Braunvieh

Soay

Galloway (including Belted

Swiss Orig Braunvieh Cross

South Country Cheviot

Galloway Cross

Tarantaise

South Wales Mountain

Gasconne

Tarantaise- Tarina

Southdown

Gasconne Crpss

Tarantaise- Tarina Cross

St Kilda

Gayal

Thai (Native)

Stud Poll Boonoke

Gelbvieh

Tuli

Stud Sires

Gelbvieh Cross

Tyrone Black

Suffolk

Gloucester

Tyrone Black Cross

Swaledale

Gloucester Cross

Ultrablack

Teeswater

Greyman

Unknown

Texel

Groninger Blaarkop

Valdostana Nera

Texel x Merino

Groninger Blaarkop Cross

Valdostana Nera Cross

Vendeen

Guernsey

Vaynol

Welsh Halfbred

Guernsey Cross

Vaynol Cross

Welsh Hill Speckled Face

Hayes Converter

Wagyu

Welsh Mountain-Badger Face

Hereford

Wagyu Cross

Welsh Mountain-Hill Flock

Hereford Cross

Water Buffalo

Welsh Mountain-Pedigree

Hereford x Friesian

Watuzi

Welsh Mule

Hereford x Santa Gertrudis

Welsh Black

Wenslydale

Highland

Welsh Black Cross

Westphalian

Highland Cross

Welsh White

White Dorper

Holstein

Welsh White Cross

White Faced Dartmoor

Holstein Cross

Whitbred Shorthorn

White Faced Woodland

Holstein Friesian

Whitbred Shorthorn Cross

White Suffolk

Holstein Friesian Cross

White Galloway

White Suffolk x Corriedale

Irish Moiled

White Galloway Cross

Wiltshire Horn

Irish Moiled Cross

White Park

XB

Jersey

White Park Cross

Zwartbles

Jersey Cross

White-tailed deer

Kerry

Yak

Kerry Cross

Zebu

LeanBos

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.

Sex

Male

Female

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:

Location

W- Bottle Tree

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:

Date of Birth

01/08/2021

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.

Has Offspring

Yes

Age Class = Cow or Ewe

No

Age Class = Heifer or Maiden Ewe

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.

Birth Date Accuracy

Accurate

Estimate

Unknown

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

Weaned*

*Required field

Required to determine the age class of the animal.

Weaned

Yes

No

Age Class = Calf or Lamb if Date of Birth within last 12 months.

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

20/04/2022

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.

Fertility

Fertile

Infertile

Neutered

Required if age class of Male animal from Bull/ Ram > Steer/ Wether.

Unknown

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

Tag Colour

Tag Colours

MLA Tag Colour by Year

Black

2008

2016

White

2009

2017

Orange

2010

2018

Green

2011

2019

Purple

2012

2020

Yellow

2013

2021

Red

2014

2022

Blue

2015

2023

Pink

Brown

None

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

Name | Tattoo | Brand

Free text fields

Example:

Name

Tattoo

Brand

Richie

YQ

YQ312

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

Weight^

^Recommended field

Animals last recorded live weight in Kilograms (kg).

Example:

Weight

500

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:

Last Weighed Date

20/04/2022

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:

Sire Visual ID

Sire EID

Sire Name

A123

982123731797246

Rex

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:

Dam Visual ID

Dam EID

B456

926074235206023

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

Management Tag

Free text field.

Example:

Management Tag

Poddy Calf

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:

Management Group

PTIC Cows

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

Did this answer your question?