This page provides information about the terms that can be used when importing records from a spreadsheet into iRecord.
For some types of data, the values in your spreadsheet have to match the values that iRecord is expecting. For instance, the species names can be scientific or English names, but they have to match the names that iRecord uses, which are taken from the UK Species Inventory.
A number of other fields have to match a predefined set of terms, and these are listed below.
Terms for Stage
This field is required, so that your spreadsheet must have a column for Stage, and every row in your spreadsheet of records must include a term for Stage. The term can be given as "Not recorded", but it cannot be left blank. The full list of terms that can be used is:
Stage terms |
---|
Adult |
Cocoon |
Dead |
Egg |
Exuvia |
Flowering |
Fruiting |
Gall |
Immature |
Juvenile |
Larva |
Larval case |
Larval web |
Leaf-mine |
Mature |
Mine |
Mine (vacated) |
Mixed |
Nest |
Not recorded |
Nymph |
Other |
Pupa |
Seedling |
Spawn |
Tadpole |
Teneral |
Vegetative |
Terms for Sex
The field is optional, but is available if needed, with these terms:
Sex terms |
---|
female |
male |
mixed |
not recorded |
Terms for Recorder certainty
Optional, but available with these terms:
Certainty terms |
---|
Certain |
Likely |
Uncertain |
Terms for Observation Type
This allows a recording method to be imported, but note that an alternative is to use "Method (free text)", which can accept any text. Observation Type is optional, but available with these terms:
Observation Type terms |
---|
Actinic moth trap |
Call |
Caught |
Collected |
dung/droppings/frass/pellet, etc. |
Field identification |
Field record |
Field sighting |
Field sign |
Flying |
Fungal gall |
Insect gall |
Leaf mine |
MV light trap |
Nest |
Other |
Other gall |
pitfall trap |
Robinson moth trap |
swept |
trapped in Malaise trap |
trapped in water trap, voucher specimen |
voucher specimen |
voucher specimen, trapped (other) |
Terms for Breeding evidence (birds)
This termlist is based on the BTO codes for breeding evidence, and is only intended for use with bird records. It is optional, and the terms are:
Breeding evidence terms |
---|
<00: Migration, Flying or Summering (M/F/U) |
01: Nesting habitat (H) |
02: Singing male (S) |
03: Pair in suitable habitat (P) |
04: Permanent territory (T) |
05: Courtship and display (D) |
<06: Visiting probable nest site (N) |
07: Agitated behaviour (7) |
08: Brood patch on incubating adult (I) |
09: Nest building (B) |
10: Distraction display (DD) |
11: Used nest or eggshells (11) |
12: Recently fledged (FL) |
13: Occupied nest (ON) |
14: Faecal sac or food (FF) |
15: Nest with eggs (NE) |
16: Nest with young (NY) |
not recorded |
Terms for Identification type
Optional, to provide information on whether an insect specimen was examined.
Identification type terms |
---|
Microscope |
Genitalia |
Terms for Specimen
Optional, to provide information on whether a specimen has been retained.
Specimen terms |
---|
No |
Yes |
Terms for Date Type
These are only required if importing date ranges. Date ranges require three columns in the spreadsheet: date start (dd/mm/yyyy format); date end (dd/mm/yyyy format); and date type, using the terms below:
Date type term | Description | Example date start | Example date end |
---|---|---|---|
D | Date specified to the nearest day. | 16/06/2016 | 16/06/2016 |
DD | Date specified to a number of days. | 16/06/2016 | 18/06/2016 |
O | [This is a capital “O”, not a zero] Date specified to the nearest month (first day of the month to the last day of the month) | 01/06/2016 | 30/06/2016 |
OO | [These are capital “O”s, not zeros] Date specified to a range of months (first day of the start month to the last day of the end month) | 01/06/2016 | 31/07/2016 |
Y | Date specified to the nearest year (first day of the year to the last day of the year) | 01/01/2016 | 31/12/2016 |
YY | Date specified to a range of years. | 01/01/2012 | 31/12/2015 |