Skip to content. | Skip to navigation

Personal tools

You are here: Home / old-DaRWIN / Help and Manuals / Specimen Import Help

Specimen Import Help

How to import Specimens in DaRWIN with xls Template
   
 

View the video

 

View the Manual (PDF)

Import XLS template

 

Notes

  1. Only "UnitID" is mandatory
  2. The order of the fields is free
  3. Keep the column name
  4. It is also possible to provide several storage places (see "syntax if multiple" column).

In this case all the fields having values must have the same amount of elements ([elem1|elem2|elem3]). Null value are in this form :[elem1|elem2|] (3rd element is empty)

Description of Fields

Description

  Available fields Note Syntax if multiple (example)
1
UnitID
Mandatory field  
2
additionalID
   
3
datasetName
Collection  
4
KindOfUnit
Default value "specimen", but eventually parts like "heads", "skeleton", "voucher", "DNA"" [alcohol|crane|skin]
5
TypeStatus
   
6
totalNumber
   
7
maleNumber
   
8
femaleNumber
   
9
CollectedBy
   
10
SamplingCode
Code of the sampling locality  
11
Country
   
12
LocalityText
   

Taxonomy

  Available fields Note Syntax if multiple (example)
13
FullScientificName
Can be the only provided taxomical information if the taxonomy is already in Darwin)  
14
Family
   
15
Order
   
16
Class
   
17
Phylum
   
19
IdentifiedBy
   
19
IdentificationYear
   

Sampling Location

  Available fields Note Syntax if multiple (example)
20
LatitudeDecimal
If empty and at least "LatitudeDMSDegrees" provided, it will be automatically calculated  
21
LatitudeDMSDegrees
   
22
LatitudeDMSMinutes
   
23
LatitudeDMSSeconds
   
24
LatitudeDMS_N_S
"N" if North, "S" if South  
25
LatitudeText
   
26
LongitudeDecimal
If empty and at least "LongitudeDMSDegrees" provided, it will be automatically calculated  
27
LongitudeDMSDegrees
   
28
LongitudeDMSMinutes
   
29
LongitudeDMSSeconds
   
30
LongitudeDMS_W_E
"W" if North, "E" if South  
31
LongitudeText
   

Sampling date

  Available fields Note Syntax if multiple (example)
32
CollectionStartDay
   
33
CollectionStartMonth
   
34
CollectionStartYear
   

Associated

  Available fields Note Syntax if multiple (example)
35
associatedUnitInstitution
   
36
associatedUnitCollection
   
37
associatedUnitID
   
38
associationType
   

Storage

  Available fields Note Syntax if multiple (example)
39
storage:Localisation
   
40
storage:Institution
  [RMCA|RBINS|MNHN]
41
storage:Building
  [CAPA|Collection_tower|entomolgie]
42
storage:Floor
  [1|7|8]
43
storage:Room
  [1 R 07|Local 7|Local 8]
44
storage:Row
  [7|810|4]
45
storage:Column
  [Column 7| Column 810|Column 4]
46
storage:Shelf
  [Shelf 7| Shelf 810|Shelf 4]
47
storage:ContainerName
  [ContainerA| ContainerB|ContainerC]
48
storage:ContainerStorage
  [jar|box|compactus]
49
storage:ContainerType
  [alcohol|dry|dry]
50
storage:SubcontainerName
  [SubcontainerA| SubcontainerB|ContainerC]
51
storage:SubcontainerStorage
  [slide|minigrip|thin section]
52
storage:SubcontainerType
  [jar|box|compactus]

Relationship

  Available fields Note Syntax if multiple (example)
53
HostClass
   
54
HostOrder
   
55
HostFamily
   
56
HostRemarks
   
57
HostGenus
   
58
HostFullScientificName
   
59
HostAuthority
   
60
HostCollector
   
61
HostIdentifier
   

Measurements / Properties

  Available fields Note Syntax if multiple (example)
62
Property1
ex: Weight  
63
PropertyValue1
ex: 50 g  
64
Property2
   
65
MeasurementsOfFactValue2
   
66
Property3
   
67
MeasurementsOfFactValue3
   
68
Property4
   
69
MeasurementsOfFactValue4
   
70
Property5
   
71
MeasurementsOfFactValue5
   
72
Property6
   
73
MeasurementsOfFactValue6
   
74
Property7
   
75
MeasurementsOfFactValue7
   
76
Property8
   
77
MeasurementsOfFactValue8
   
78
Property9
   
79
MeasurementsOfFactValue9
   
80
Property10
   
81
MeasurementsOfFactValue10
   
82
Property11
   
83
MeasurementsOfFactValue11
   
84
Property12
   
85
MeasurementsOfFactValue12
   
86
Notes