To access the Import Animals feature, click on the Animals menu option to display the screen below.
The Import animals button enables you to bulk upload multiple animal records to the system from a CSV template.
Select the Import Animal button and when the Import Animal screen is displayed, select the Protocol from the list to which the animals will be imported. The following screen is displayed.
First, you must select the Protocol to which the animals will belong and be added to. This will enable the system to check if the number of animals being added is within, or exceeds the maximum allowed under the protocol.
Ensure that the date format selected here corresponds to the Date format entered in the csv file
To import animals, first you must download the CSV template, which you can do by clicking on the
icon, top right of your screen.
This will download the animal-bulk-import.csv file to your local computer – usually to your Download
folder.
You can open the file from your browser by clicking on the arrow next to the file name to show the options below
Import animal CSV fields and values
The following table explains the fields that the CSV provides for you to complete. The values that must be present in the CSV file to successfully load are indicated with an M and *. All the other values can be updated on the individual record at a later time.
|
Field name |
Explanation |
|
|
*Species |
Must be either "Mouse" or "Rat" |
|
|
*Sex |
Must be "Male" or "Female" or “Unknown” |
|
|
*Date of birth |
Must enter in the same format as selected. |
|
|
Date of death |
Leave blank if alive (Mandatory-If dead) |
|
|
Reason for death |
Leave blank if alive (Mandatory-If dead) |
|
|
Record as adverse death |
Must be True or False if animal is dead |
|
|
Health status |
Up to 100 alphanumeric characters |
|
|
Strain |
Must be a nominated item from the available strain list for the environment |
|
|
Line |
Must be up to 195 alphanumeric characters |
|
|
*Genetic status |
Must be "Genetically modified" or "Non-genetically modified" |
|
|
Genotype |
Must be a nominated item from the available genotype list for the environment |
|
|
Phenotype |
Must be a nominated item from the available phenotype list for the environment |
|
|
Supplier name |
Name of the organization that supplied the animal |
|
|
Visual ID method |
Must be the same as one of the configured visual identity items |
|
|
Visual ID provider |
Mandatory- if Visual ID method is entered (Must be the same as one of the configured visual identity items) |
|
|
Visual ID location |
Mandatory- if Visual ID method is entered (Must be the same as one of the configured visual identity items) |
|
|
Visual ID value |
Mandatory- if Visual ID method is entered |
|
|
Visual ID ink color |
Mandatory- if Visual ID method is entered (Must be the same as one of the configured visual identity items) |
|
|
Date of Visual ID |
Mandatory- if Visual ID method is entered |
|
|
Record Visual ID as Primary |
Must be True or False |
|
|
RFID |
non-visual ID |
|
|
RFID date |
Date when the animal was tagged |
|
|
Supplier ID |
Must be up to 424 alphanumeric characters |
|
|
Supplier ID date |
Date when the supplier ID was provided |
|
Import animal records
Browse for the completed CSV file to be imported by either clicking icon or by dragging and dropping the completed CSV file.
Click the 
icon to import the animal records. After a successful import, animals imported along with the status of the import will be displayed.
