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

---

Tables

CollectionEvent (CollectionEvent)
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionEventID									Database
CollectionDay						11	Split at Pos. Dir. . 1 ⇨		File
CollectionMonth						11	Split at Pos. Dir. . 2 ⇨ Translate Into I 1 II 2 III 3 IV 4 IX 9 V 5 VI 6 VII 7 VIII 8 X 10 XI 11 XII 12		File
CollectionYear						11	Split at Pos. Dir. . 3 ⇨		File
LocalityDescription	?					2			File
+	?			,		3			File
HabitatDescription				ECOL.:		17			File
+						18	Filter Import fixed value: ; If column 17 ≠ And If column 18 ≠		File
+				ASSOC.:		18			File
CountryCache						2	Split at Pos. Dir. , 1 ⇨		File

CollectionEventLocalisation_1 (CollectionEventLocalisation)
Parent: CollectionEvent
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionEventID									Database
LocalisationSystemID									Preset
Location1	?					20			File
Location2	?					19			File
LocationAccuracy						5	Translate Into < 50-100 m		File
LocationNotes				[Ori.val.:	,	7			File
+					]	6			File

CollectionEventLocalisation_7 (CollectionEventLocalisation)
Parent: CollectionEvent
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionEventID									Database
LocalisationSystemID									Preset
Location1	?					4	Replace With m		File

CollectionSpecimen (CollectionSpecimen)
Parent: CollectionEvent
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
CollectionEventID									Database
AccessionNumber	?					0			File
DepositorsAccessionNumber						13			File

CollectionAgent_1 (CollectionAgent)
Parent: CollectionSpecimen
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
CollectorsName	?					12	Split at Pos. Dir. , & 1 ⇨		File

CollectionAgent_2 (CollectionAgent)
Parent: CollectionSpecimen
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
CollectorsName	?					12	Split at Pos. Dir. & , 2 ⇨		File

CollectionAgent_3 (CollectionAgent)
Parent: CollectionSpecimen
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
CollectorsName	?					12	Split at Pos. Dir. , & 3 ⇨		File

CollectionProject_1 (CollectionProject)
Parent: CollectionSpecimen
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
ProjectID	?							909	Interface

CollectionSpecimenPart_1 (CollectionSpecimenPart)
Parent: CollectionSpecimen
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
CollectionID	?							3	Interface
MaterialCategory								dried specimen	Interface
StorageLocation						1			File
SpecimenPartID									Database

IdentificationUnit_1 (IdentificationUnit)
Parent: CollectionSpecimen
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
IdentificationUnitID									Database
LastIdentificationCache						9			File
TaxonomicGroup	?							plant	Interface
UnitDescription						8			File
DisplayOrder								2	Interface

Identification_1_1 (Identification)
Parent: IdentificationUnit_1
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
IdentificationUnitID									Database
TaxonomicName	?					9			File

IdentificationUnitInPart_1_1 (IdentificationUnitInPart)
Parent: IdentificationUnit_1
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
IdentificationUnitID									Database
SpecimenPartID									Database	CollectionSpecimenPart_1
DisplayOrder	?							2	Interface

IdentificationUnit_2 (IdentificationUnit)
Parent: CollectionSpecimen
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
IdentificationUnitID									Database
LastIdentificationCache	?					1			File
TaxonomicGroup								fungus	Interface
RelatedUnitID									ParentTable	IdentificationUnit_1
ColonisedSubstratePart						10			File
DisplayOrder								1	Interface

Identification_2_1 (Identification)
Parent: IdentificationUnit_2
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
IdentificationUnitID									Database
TaxonomicName	?					1			File
TypeStatus						14			File

IdentificationUnitInPart_2_1 (IdentificationUnitInPart)
Parent: IdentificationUnit_2
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
IdentificationUnitID									Database
SpecimenPartID									Database	CollectionSpecimenPart_1
DisplayOrder	?							1	Interface

CollectionSpecimenRelation_1 (CollectionSpecimenRelation)
Parent: CollectionSpecimen
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
RelatedSpecimenURI	?			http://www.ncbi.nlm.nih.gov/nuccore/		16	Split at Pos. Dir. , 1 ⇨		File
RelatedSpecimenDisplayText	?					16	Split at Pos. Dir. , 1 ⇨		File
RelatedSpecimenDescription								GenBank Acc. No	Interface
IsInternalRelationCache								0	Interface

CollectionSpecimenRelation_2 (CollectionSpecimenRelation)
Parent: CollectionSpecimen
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
RelatedSpecimenURI	?			http://www.ncbi.nlm.nih.gov/nuccore/		16	Split at Pos. Dir. , 2 ⇨		File
RelatedSpecimenDisplayText	?					16	Split at Pos. Dir. , 2 ⇨		File
RelatedSpecimenDescription								GenBank Acc. No	Interface
IsInternalRelationCache								0	Interface

CollectionSpecimenRelation_3 (CollectionSpecimenRelation)
Parent: CollectionSpecimen
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
RelatedSpecimenURI	?			http://www.ncbi.nlm.nih.gov/nuccore/		16	Split at Pos. Dir. , 3 ⇨		File
RelatedSpecimenDisplayText	?					16	Split at Pos. Dir. , 3 ⇨		File
RelatedSpecimenDescription								GenBank Acc. No	Interface
IsInternalRelationCache								0	Interface

CollectionSpecimenRelation_4 (CollectionSpecimenRelation)
Parent: CollectionSpecimen
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
RelatedSpecimenURI	?			http://www.ncbi.nlm.nih.gov/nuccore/		16	Split at Pos. Dir. , 4 ⇨		File
RelatedSpecimenDisplayText	?					16	Split at Pos. Dir. , 4 ⇨		File
RelatedSpecimenDescription								GenBank Acc. No	Interface
IsInternalRelationCache								0	Interface

File columns

	Merge handling of table				Column usage
	Insert	Merge	Update	Attach	Decisive	Key

Pos.	Name	Table	Column	Example	Transformed
0	Acc.No.
	CollectionSpecimen.		AccessionNumber	M-0276410
1	Taxonomische Name
	CollectionSpecimenPart_1.		StorageLocation	Hyalorbilia herbicola Baral, Priou & Perz
	IdentificationUnit_2.		LastIdentificationCache	Hyalorbilia herbicola Baral, Priou & Perz
	Identification_2_1.		TaxonomicName	Hyalorbilia herbicola Baral, Priou & Perz
2	Locality
	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 ⇨
3	Locality
+	CollectionEvent.		LocalityDescription	La Provostaie	, La Provostaie
			Prefix:	,˽
4	alt.
	CollectionEventLocalisation_7.		Location1	˽4 m˽	˽4˽
			Transformations:	Replace With m
5	koord.
	CollectionEventLocalisation_1.		LocationAccuracy	˽˽
			Transformations:	Translate Into < 50-100 m
6	lat
+	CollectionEventLocalisation_1.		LocationNotes	47° 43' 4'' N	˽47° 43' 4'' N]
			Postfix:	]
7	lon
	CollectionEventLocalisation_1.		LocationNotes	˽2° 8' 50'' W
			Prefix:	[Ori.val.:˽
			Postfix:	,˽
8
	IdentificationUnit_1.		UnitDescription	˽stem
9	Wirt
	IdentificationUnit_1.		LastIdentificationCache	Fallopia sachalinensis
	Identification_1_1.		TaxonomicName	Fallopia sachalinensis
10
	IdentificationUnit_2.		ColonisedSubstratePart	˽
11	coll.datum
	CollectionEvent.		CollectionDay	˽12.VI.2008	˽12
			Transformations:	Split at Pos. Dir. . 1 ⇨
	CollectionEvent.		CollectionMonth	˽12.VI.2008	6
			Transformations:	Split at Pos. Dir. . 2 ⇨ Translate Into I 1 II 2 III 3 IV 4 IX 9 V 5 VI 6 VII 7 VIII 8 X 10 XI 11 XII 12
	CollectionEvent.		CollectionYear	˽12.VI.2008	2008
			Transformations:	Split at Pos. Dir. . 3 ⇨
12	Finder
	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 ⇨
13	HB-Nr.
	CollectionSpecimen.		DepositorsAccessionNumber	8880
14
	Identification_2_1.		TypeStatus	holotype
15	andere Herbarien	not imported
16	GenBank
	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 ⇨
17	Vegetation
	CollectionEvent.		HabitatDescription	large stand of Fallopia sachalinensis˽
			Prefix:	ECOL.:˽
18	assoziierte Arten
+	CollectionEvent.		HabitatDescription
			Transformations:	Filter Import fixed value: ; If column 17 ≠ And If column 18 ≠
+	CollectionEvent.		HabitatDescription
			Prefix:	ASSOC.:˽
19	lat (D)
	CollectionEventLocalisation_1.		Location2	47,71777778
20	lon (D)
	CollectionEventLocalisation_1.		Location1	-2,147222222

Interface settings (= For all)

Table	Table alias	Column	Value	Display
CollectionProject	CollectionProject_1	ProjectID	909
CollectionSpecimenPart	CollectionSpecimenPart_1	CollectionID	3
	CollectionSpecimenPart_1	MaterialCategory	dried specimen
CollectionSpecimenRelation	CollectionSpecimenRelation_1	RelatedSpecimenDescription	GenBank Acc. No
	CollectionSpecimenRelation_1	IsInternalRelationCache	0
	CollectionSpecimenRelation_2	RelatedSpecimenDescription	GenBank Acc. No
	CollectionSpecimenRelation_2	IsInternalRelationCache	0
	CollectionSpecimenRelation_3	RelatedSpecimenDescription	GenBank Acc. No
	CollectionSpecimenRelation_3	IsInternalRelationCache	0
	CollectionSpecimenRelation_4	RelatedSpecimenDescription	GenBank Acc. No
	CollectionSpecimenRelation_4	IsInternalRelationCache	0
IdentificationUnit	IdentificationUnit_1	TaxonomicGroup	plant
	IdentificationUnit_1	DisplayOrder	2
	IdentificationUnit_2	TaxonomicGroup	fungus
	IdentificationUnit_2	DisplayOrder	1
IdentificationUnitInPart	IdentificationUnitInPart_1_1	DisplayOrder	2
	IdentificationUnitInPart_2_1	DisplayOrder	1