Schedule for import of tab-separated text files into DiversityCollection
Target within DiversityCollection: Specimen
Schedule version: 1Database version: 02.05.64
Lines:2 - 11First line contains column definition:
Encoding:ANSILanguage:US

Tables

CollectionEvent (CollectionEvent)
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionEventIDDatabase
CollectionDay11
Split at Pos.Dir.
.
1
File
CollectionMonth11
Split at Pos.Dir.
.
2
TranslateInto
I1
II2
III3
IV4
IX9
V5
VI6
VII7
VIII8
X10
XI11
XII12
File
CollectionYear11
Split at Pos.Dir.
.
3
File
LocalityDescription?2File
+?, 3File
HabitatDescriptionECOL.: 17File
+18
Filter
Import fixed value: ;
If column 17 ≠
And If column 18 ≠
File
+ASSOC.: 18File
CountryCache2
Split at Pos.Dir.
,
1
File

CollectionEventLocalisation_1 (CollectionEventLocalisation)
Parent: CollectionEvent
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionEventIDDatabase
LocalisationSystemIDPreset
Location1?20File
Location2?19File
LocationAccuracy5
TranslateInto
< 50-100 m
File
LocationNotes[Ori.val.: , 7File
+]6File

CollectionEventLocalisation_7 (CollectionEventLocalisation)
Parent: CollectionEvent
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionEventIDDatabase
LocalisationSystemIDPreset
Location1?4
Replace With
m
File

CollectionSpecimen (CollectionSpecimen)
Parent: CollectionEvent
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
CollectionEventIDDatabase
AccessionNumber?0File
DepositorsAccessionNumber13File

CollectionAgent_1 (CollectionAgent)
Parent: CollectionSpecimen
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
CollectorsName?12
Split at Pos.Dir.
, &
1
File

CollectionAgent_2 (CollectionAgent)
Parent: CollectionSpecimen
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
CollectorsName?12
Split at Pos.Dir.
& ,
2
File

CollectionAgent_3 (CollectionAgent)
Parent: CollectionSpecimen
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
CollectorsName?12
Split at Pos.Dir.
, &
3
File

CollectionProject_1 (CollectionProject)
Parent: CollectionSpecimen
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
ProjectID?909Interface

CollectionSpecimenPart_1 (CollectionSpecimenPart)
Parent: CollectionSpecimen
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
CollectionID?3Interface
MaterialCategorydried specimenInterface
StorageLocation1File
SpecimenPartIDDatabase

IdentificationUnit_1 (IdentificationUnit)
Parent: CollectionSpecimen
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
IdentificationUnitIDDatabase
LastIdentificationCache9File
TaxonomicGroup?plantInterface
UnitDescription8File
DisplayOrder2Interface

Identification_1_1 (Identification)
Parent: IdentificationUnit_1
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
IdentificationUnitIDDatabase
TaxonomicName?9File

IdentificationUnitInPart_1_1 (IdentificationUnitInPart)
Parent: IdentificationUnit_1
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
IdentificationUnitIDDatabase
SpecimenPartIDDatabaseCollectionSpecimenPart_1
DisplayOrder?2Interface

IdentificationUnit_2 (IdentificationUnit)
Parent: CollectionSpecimen
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
IdentificationUnitIDDatabase
LastIdentificationCache?1File
TaxonomicGroupfungusInterface
RelatedUnitIDParentTableIdentificationUnit_1
ColonisedSubstratePart10File
DisplayOrder1Interface

Identification_2_1 (Identification)
Parent: IdentificationUnit_2
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
IdentificationUnitIDDatabase
TaxonomicName?1File
TypeStatus14File

IdentificationUnitInPart_2_1 (IdentificationUnitInPart)
Parent: IdentificationUnit_2
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
IdentificationUnitIDDatabase
SpecimenPartIDDatabaseCollectionSpecimenPart_1
DisplayOrder?1Interface

CollectionSpecimenRelation_1 (CollectionSpecimenRelation)
Parent: CollectionSpecimen
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
RelatedSpecimenURI?http://www.ncbi.nlm.nih.gov/nuccore/16
Split at Pos.Dir.
,
1
File
RelatedSpecimenDisplayText?16
Split at Pos.Dir.
,
1
File
RelatedSpecimenDescriptionGenBank Acc. No Interface
IsInternalRelationCache0Interface

CollectionSpecimenRelation_2 (CollectionSpecimenRelation)
Parent: CollectionSpecimen
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
RelatedSpecimenURI?http://www.ncbi.nlm.nih.gov/nuccore/16
Split at Pos.Dir.
,
2
File
RelatedSpecimenDisplayText?16
Split at Pos.Dir.
,
2
File
RelatedSpecimenDescriptionGenBank Acc. No Interface
IsInternalRelationCache0Interface

CollectionSpecimenRelation_3 (CollectionSpecimenRelation)
Parent: CollectionSpecimen
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
RelatedSpecimenURI?http://www.ncbi.nlm.nih.gov/nuccore/16
Split at Pos.Dir.
,
3
File
RelatedSpecimenDisplayText?16
Split at Pos.Dir.
,
3
File
RelatedSpecimenDescriptionGenBank Acc. No Interface
IsInternalRelationCache0Interface

CollectionSpecimenRelation_4 (CollectionSpecimenRelation)
Parent: CollectionSpecimen
Merge handling: Insert
Column in table?KeyCopyPrePostFile pos.TransformationsValueSourceTable
CollectionSpecimenIDDatabase
RelatedSpecimenURI?http://www.ncbi.nlm.nih.gov/nuccore/16
Split at Pos.Dir.
,
4
File
RelatedSpecimenDisplayText?16
Split at Pos.Dir.
,
4
File
RelatedSpecimenDescriptionGenBank Acc. No Interface
IsInternalRelationCache0Interface


File columns
Merge handling of tableColumn usage
InsertMergeUpdateAttachDecisiveKey

Pos.NameTableColumnExampleTransformed
0Acc.No.
CollectionSpecimen. AccessionNumberM-0276410
1Taxonomische Name
CollectionSpecimenPart_1. StorageLocationHyalorbilia herbicola Baral, Priou & Perz
IdentificationUnit_2. LastIdentificationCacheHyalorbilia herbicola Baral, Priou & Perz
Identification_2_1. TaxonomicNameHyalorbilia herbicola Baral, Priou & Perz
2Locality
CollectionEvent. LocalityDescription˽France, Bretagne, dépt. Morbihan, Bretagne, 5.3 km S of La Gacilly, 2 km N of St.-Vincent-sur-Oust
CollectionEvent. CountryCache˽France, Bretagne, dépt. Morbihan, Bretagne, 5.3 km S of La Gacilly, 2 km N of St.-Vincent-sur-Oust˽France
Transformations:
Split at Pos.Dir.
,
1
3Locality
+CollectionEvent. LocalityDescription La Provostaie, La Provostaie
Prefix:
4alt.
CollectionEventLocalisation_7. Location1˽4 m˽˽4˽
Transformations:
Replace With
m
5koord.
CollectionEventLocalisation_1. LocationAccuracy˽˽
Transformations:
TranslateInto
< 50-100 m
6lat
+CollectionEventLocalisation_1. LocationNotes 47° 43' 4'' N˽47° 43' 4'' N]
Postfix:]
7lon
CollectionEventLocalisation_1. LocationNotes˽2° 8' 50'' W
Prefix:[Ori.val.:˽
Postfix:
8
IdentificationUnit_1. UnitDescription˽stem
9Wirt
IdentificationUnit_1. LastIdentificationCacheFallopia sachalinensis
Identification_1_1. TaxonomicNameFallopia sachalinensis
10
IdentificationUnit_2. ColonisedSubstratePart˽
11coll.datum
CollectionEvent. CollectionDay˽12.VI.2008˽12
Transformations:
Split at Pos.Dir.
.
1
CollectionEvent. CollectionMonth˽12.VI.20086
Transformations:
Split at Pos.Dir.
.
2
TranslateInto
I1
II2
III3
IV4
IX9
V5
VI6
VII7
VIII8
X10
XI11
XII12
CollectionEvent. CollectionYear˽12.VI.20082008
Transformations:
Split at Pos.Dir.
.
3
12Finder
CollectionAgent_1. CollectorsName˽J.P. Priou
Transformations:
Split at Pos.Dir.
, &
1
CollectionAgent_2. CollectorsName˽J.P. Priou
Transformations:
Split at Pos.Dir.
& ,
2
CollectionAgent_3. CollectorsName˽J.P. Priou
Transformations:
Split at Pos.Dir.
, &
3
13HB-Nr.
CollectionSpecimen. DepositorsAccessionNumber8880
14
Identification_2_1. TypeStatusholotype
15andere Herbariennot imported
16GenBank
CollectionSpecimenRelation_1. RelatedSpecimenURI
Prefix:http://www.ncbi.nlm.nih.gov/nuccore/
Transformations:
Split at Pos.Dir.
,
1
CollectionSpecimenRelation_1. RelatedSpecimenDisplayText
Transformations:
Split at Pos.Dir.
,
1
CollectionSpecimenRelation_2. RelatedSpecimenURI
Prefix:http://www.ncbi.nlm.nih.gov/nuccore/
Transformations:
Split at Pos.Dir.
,
2
CollectionSpecimenRelation_2. RelatedSpecimenDisplayText
Transformations:
Split at Pos.Dir.
,
2
CollectionSpecimenRelation_3. RelatedSpecimenURI
Prefix:http://www.ncbi.nlm.nih.gov/nuccore/
Transformations:
Split at Pos.Dir.
,
3
CollectionSpecimenRelation_3. RelatedSpecimenDisplayText
Transformations:
Split at Pos.Dir.
,
3
CollectionSpecimenRelation_4. RelatedSpecimenURI
Prefix:http://www.ncbi.nlm.nih.gov/nuccore/
Transformations:
Split at Pos.Dir.
,
4
CollectionSpecimenRelation_4. RelatedSpecimenDisplayText
Transformations:
Split at Pos.Dir.
,
4
17Vegetation
CollectionEvent. HabitatDescriptionlarge stand of Fallopia sachalinensis˽
Prefix:ECOL.:˽
18assoziierte Arten
+CollectionEvent. HabitatDescription
Transformations:
Filter
Import fixed value: ;
If column 17 ≠
And If column 18 ≠
+CollectionEvent. HabitatDescription
Prefix:ASSOC.:˽
19lat (D)
CollectionEventLocalisation_1. Location247,71777778
20lon (D)
CollectionEventLocalisation_1. Location1-2,147222222

Interface settings (= For all)
TableTable aliasColumnValueDisplay
CollectionProjectCollectionProject_1ProjectID909
CollectionSpecimenPartCollectionSpecimenPart_1CollectionID3
CollectionSpecimenPart_1MaterialCategorydried specimen
CollectionSpecimenRelationCollectionSpecimenRelation_1RelatedSpecimenDescriptionGenBank Acc. No
CollectionSpecimenRelation_1IsInternalRelationCache0
CollectionSpecimenRelation_2RelatedSpecimenDescriptionGenBank Acc. No
CollectionSpecimenRelation_2IsInternalRelationCache0
CollectionSpecimenRelation_3RelatedSpecimenDescriptionGenBank Acc. No
CollectionSpecimenRelation_3IsInternalRelationCache0
CollectionSpecimenRelation_4RelatedSpecimenDescriptionGenBank Acc. No
CollectionSpecimenRelation_4IsInternalRelationCache0
IdentificationUnitIdentificationUnit_1TaxonomicGroupplant
IdentificationUnit_1DisplayOrder2
IdentificationUnit_2TaxonomicGroupfungus
IdentificationUnit_2DisplayOrder1
IdentificationUnitInPartIdentificationUnitInPart_1_1DisplayOrder2
IdentificationUnitInPart_2_1DisplayOrder1