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

---

Tables

CollectionEvent (CollectionEvent)
Merge handling: Merge

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionEventID									Database
CollectionDay	?	✔				0	Split at Pos. Dir. . 1 ⇨		File
CollectionMonth	?	✔				0	Split at Pos. Dir. . 2 ⇨		File
CollectionYear	?	✔				0	Split at Pos. Dir. . 3 ⇨		File
LocalityDescription	?	✔				4			File
HabitatDescription	?	✔				6			File

CollectionEventLocalisation_1 (CollectionEventLocalisation)
Parent: CollectionEvent
Merge handling: Merge

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionEventID									Database
LocalisationSystemID									Preset
Location1	?	✔				8	Filter Import content of column in file If column 7 = WGS84		File
Location2	?	✔				9	Filter Import content of column in file If column 7 = WGS84		File
LocationAccuracy	?	✔				10	Filter Import content of column in file If column 7 = WGS84		File

CollectionEventLocalisation_3 (CollectionEventLocalisation)
Parent: CollectionEvent
Merge handling: Merge

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionEventID									Database
LocalisationSystemID									Preset
Location1	?	✔				8	Filter Import content of column in file If column 7 = Gauß-Krüger		File
Location2	?	✔				9	Filter Import content of column in file If column 7 = Gauß-Krüger		File
LocationAccuracy		✔				10	Filter Import content of column in file If column 7 = Gauß-Krüger		File

CollectionEventLocalisation_5 (CollectionEventLocalisation)
Parent: CollectionEvent
Merge handling: Merge

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionEventID									Database
LocalisationSystemID									Preset
Location1	?	✔				5	Split at Pos. Dir. [ 1 ⇨		File
Location2		✔		http://tnt.diversityworkbench.de/Gazetteer2/		5	Split at Pos. Dir. [ 2 ⇨ Split at Pos. Dir. ] 2 ⇦		File

CollectionEventLocalisation_6 (CollectionEventLocalisation)
Parent: CollectionEvent
Merge handling: Merge

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionEventID									Database
LocalisationSystemID									Preset
Location1	?	✔				1			File
Location2	?	✔				2			File

CollectionEventLocalisation_7 (CollectionEventLocalisation)
Parent: CollectionEvent
Merge handling: Merge

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionEventID									Database
LocalisationSystemID									Preset
Location1	?	✔				11	Split at Pos. Dir. - 1 ⇨		File
Location2		✔				11	Split at Pos. Dir. - 2 ⇨		File

CollectionSpecimen (CollectionSpecimen)
Parent: CollectionEvent
Merge handling: Merge

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
CollectionEventID									Database
InternalNotes	?	✔				0			File
+						1			File
+						2			File
+						3			File
+						4			File
+						5			File
+						6			File
+						7			File
+						8			File
+						9			File
+						10			File
+						11			File

CollectionAgent_1 (CollectionAgent)
Parent: CollectionSpecimen
Merge handling: Merge

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

CollectionAgent_2 (CollectionAgent)
Parent: CollectionSpecimen
Merge handling: Merge

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

CollectionAgent_3 (CollectionAgent)
Parent: CollectionSpecimen
Merge handling: Merge

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

CollectionAgent_4 (CollectionAgent)
Parent: CollectionSpecimen
Merge handling: Merge

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

CollectionAgent_5 (CollectionAgent)
Parent: CollectionSpecimen
Merge handling: Merge

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

CollectionProject_1 (CollectionProject)
Parent: CollectionSpecimen
Merge handling: Merge

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

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						14		plant	Interface
TaxonomicGroup	?							plant	Interface
OnlyObserved								1	Interface
NumberOfUnits						19			File
Notes				Belegart:		17			File
+						18	Filter Import fixed value: | If column 18 ≠ Or If column 21 ≠ Or If column 22 ≠ Or If column 17 ≠		File
+				Belegnr.:		18			File
+						21	Filter Import fixed value: | If column 17 ≠ Or If column 18 ≠ Or If column 21 ≠ Or If column 22 ≠		File
+				Fläche:	m²	21			File
+						22	Filter Import fixed value: | If column 17 ≠ Or If column 18 ≠ Or If column 21 ≠ Or If column 22 ≠		File
+				Anmerkungen:		22			File
RetrievalType								human observation	Interface
NumberOfUnitsModifier						20			File

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
IdentificationSequence								1	Interface
TaxonomicName	?					14			File
Notes								Taxon original	Interface

Identification_1_2 (Identification)
Parent: IdentificationUnit_1
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
IdentificationUnitID									Database
IdentificationSequence								2	Interface
TaxonomicName	?					14			File
Notes								Taxon Taxref	Interface

Identification_1_3 (Identification)
Parent: IdentificationUnit_1
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
IdentificationUnitID									Database
IdentificationSequence								3	Interface
TaxonomicName	?					12	Split at Pos. Dir. | 1 ⇨		File
NameURI				http://tnt.diversityworkbench.de/TaxonNames_Plants/		12	Split at Pos. Dir. [ 2 ⇨ Split at Pos. Dir. ] 2 ⇦		File
Notes								Taxon Taxref	Interface

IdentificationUnitAnalysis_1_1 (IdentificationUnitAnalysis)
Parent: IdentificationUnit_1
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
IdentificationUnitID									Database
AnalysisID								2	Interface
AnalysisNumber								1	Interface
AnalysisResult	?					15			File

IdentificationUnitAnalysis_1_2 (IdentificationUnitAnalysis)
Parent: IdentificationUnit_1
Merge handling: Insert

Column in table	?	Key	Copy	Pre	Post	File pos.	Transformations	Value	Source	Table
CollectionSpecimenID									Database
IdentificationUnitID									Database
AnalysisID								11	Interface
AnalysisNumber								1	Interface
AnalysisResult	?					16			File

Protocol

Responsible:	mweiss
Date:	Friday, February 16, 2018, 2:39:21 PM
Server:	development.diversityworkbench.de
Database:	DiversityCollection_ArchiveTest
Lines total:	9
Lines imported:	9

File columns

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

Pos.	Name	Table	Column	Example	Transformed
0	Datum
	CollectionEvent.		CollectionDay	17.06.2017	17
			Transformations:	Split at Pos. Dir. . 1 ⇨
	CollectionEvent.		CollectionMonth	17.06.2017	06
			Transformations:	Split at Pos. Dir. . 2 ⇨
	CollectionEvent.		CollectionYear	17.06.2017	2017
			Transformations:	Split at Pos. Dir. . 3 ⇨
	CollectionSpecimen.		InternalNotes	17.06.2017
1	TK
	CollectionEventLocalisation_6.		Location1	8430
+	CollectionSpecimen.		InternalNotes	8430
2	QQQ
	CollectionEventLocalisation_6.		Location2	4
+	CollectionSpecimen.		InternalNotes	4
3	Kartierer
+	CollectionSpecimen.		InternalNotes	Dr. Zehm, Andreas
	CollectionAgent_1.		CollectorsName	Dr. Zehm, Andreas
			Transformations:	Split at Pos. Dir. ; 1 ⇨
	CollectionAgent_2.		CollectorsName	Dr. Zehm, Andreas
			Transformations:	Split at Pos. Dir. ; 2 ⇨
	CollectionAgent_3.		CollectorsName	Dr. Zehm, Andreas
			Transformations:	Split at Pos. Dir. ; 3 ⇨
	CollectionAgent_4.		CollectorsName	Dr. Zehm, Andreas
			Transformations:	Split at Pos. Dir. ; 4 ⇨
	CollectionAgent_5.		CollectorsName	Dr. Zehm, Andreas
			Transformations:	Split at Pos. Dir. ; 5 ⇨
4	Fundort
	CollectionEvent.		LocalityDescription	Zwischen Ahornsattel und Hoher Strau�berg
+	CollectionSpecimen.		InternalNotes	Zwischen Ahornsattel und Hoher Strau�berg
5	Verwaltungseinheit
	CollectionEventLocalisation_5.		Location1	Ostallg�u (Landkreis) [1167791]	Ostallg�u (Landkreis)˽
			Transformations:	Split at Pos. Dir. [ 1 ⇨
	CollectionEventLocalisation_5.		Location2	Ostallg�u (Landkreis) [1167791]	http://tnt.diversityworkbench.de/Gazetteer2/1167791
			Prefix:	http://tnt.diversityworkbench.de/Gazetteer2/
			Transformations:	Split at Pos. Dir. [ 2 ⇨ Split at Pos. Dir. ] 2 ⇦
+	CollectionSpecimen.		InternalNotes	Ostallg�u (Landkreis) [1167791]
6	Standort
	CollectionEvent.		HabitatDescription	Staudenfluren, alpine Rasen bis Schuttfluren
+	CollectionSpecimen.		InternalNotes	Staudenfluren, alpine Rasen bis Schuttfluren
7	Koordinatensystem (UTM, WGS84, Gau�-Kr�ger)
+	CollectionSpecimen.		InternalNotes
8	L�nge (Rechtswet/Longitude)
	CollectionEventLocalisation_1.		Location1
			Transformations:	Filter Import content of column in file If column 7 = WGS84
	CollectionEventLocalisation_3.		Location1
			Transformations:	Filter Import content of column in file If column 7 = Gauß-Krüger
+	CollectionSpecimen.		InternalNotes
9	Breite (Hochwert/ Latitude)
	CollectionEventLocalisation_1.		Location2
			Transformations:	Filter Import content of column in file If column 7 = WGS84
	CollectionEventLocalisation_3.		Location2
			Transformations:	Filter Import content of column in file If column 7 = Gauß-Krüger
+	CollectionSpecimen.		InternalNotes
10	U [m]
	CollectionEventLocalisation_1.		LocationAccuracy
			Transformations:	Filter Import content of column in file If column 7 = WGS84
	CollectionEventLocalisation_3.		LocationAccuracy
			Transformations:	Filter Import content of column in file If column 7 = Gauß-Krüger
+	CollectionSpecimen.		InternalNotes
11	H�he [m � NN]
	CollectionEventLocalisation_7.		Location1	1700-1930	1700
			Transformations:	Split at Pos. Dir. - 1 ⇨
	CollectionEventLocalisation_7.		Location2	1700-1930	1930
			Transformations:	Split at Pos. Dir. - 2 ⇨
+	CollectionSpecimen.		InternalNotes	1700-1930
12	Sippenname nach Liste
	Identification_1_3.		TaxonomicName	Acer pseudoplatanus | [15]	Acer pseudoplatanus
			Transformations:	Split at Pos. Dir. | 1 ⇨
	Identification_1_3.		NameURI	Acer pseudoplatanus | [15]	http://tnt.diversityworkbench.de/TaxonNames_Plants/15
			Prefix:	http://tnt.diversityworkbench.de/TaxonNames_Plants/
			Transformations:	Split at Pos. Dir. [ 2 ⇨ Split at Pos. Dir. ] 2 ⇦
13	Sippenname gek�rzt (bitte in diese Spalte nichts eintragen, sie wird automatisch bef�llt)	not imported
14	Sippenname frei
	IdentificationUnit_1.		LastIdentificationCache
	Identification_1_1.		TaxonomicName
	Identification_1_2.		TaxonomicName
15	Status
	IdentificationUnitAnalysis_1_1.		AnalysisResult	I
16	Status_neu
	IdentificationUnitAnalysis_1_2.		AnalysisResult
17	Belegart
	IdentificationUnit_1.		Notes
			Prefix:	Belegart:˽
18	Belegnr.
+	IdentificationUnit_1.		Notes
			Transformations:	Filter Import fixed value: | If column 18 ≠ Or If column 21 ≠ Or If column 22 ≠ Or If column 17 ≠
+	IdentificationUnit_1.		Notes
			Prefix:	Belegnr.:˽
19	Anzahl
	IdentificationUnit_1.		NumberOfUnits
20	Bezugseinheit
	IdentificationUnit_1.		NumberOfUnitsModifier
21	Fl�che [m�]
+	IdentificationUnit_1.		Notes
			Transformations:	Filter Import fixed value: | If column 17 ≠ Or If column 18 ≠ Or If column 21 ≠ Or If column 22 ≠
+	IdentificationUnit_1.		Notes
			Prefix:	Fläche:˽
			Postfix:	˽m²
22	Anmerkungen
+	IdentificationUnit_1.		Notes
			Transformations:	Filter Import fixed value: | If column 17 ≠ Or If column 18 ≠ Or If column 21 ≠ Or If column 22 ≠
+	IdentificationUnit_1.		Notes
			Prefix:	Anmerkungen:˽
23	Daten�bertragung	not imported
24	ID DWB	not imported
25	korrigiert nach Daten�bertragung	not imported

Interface settings (= For all)

Table	Table alias	Column	Value	Display
CollectionProject	CollectionProject_1	ProjectID	1282	_Test
Identification	Identification_1_1	IdentificationSequence	1
	Identification_1_1	Notes	Taxon original
	Identification_1_2	IdentificationSequence	2
	Identification_1_2	Notes	Taxon Taxref
	Identification_1_3	IdentificationSequence	3
	Identification_1_3	Notes	Taxon Taxref
IdentificationUnit	IdentificationUnit_1	LastIdentificationCache	plant
	IdentificationUnit_1	TaxonomicGroup	plant	plant
	IdentificationUnit_1	OnlyObserved	1
	IdentificationUnit_1	RetrievalType	human observation	human observation
IdentificationUnitAnalysis	IdentificationUnitAnalysis_1_1	AnalysisID	2	Floristischer Status
	IdentificationUnitAnalysis_1_1	AnalysisNumber	1
	IdentificationUnitAnalysis_1_2	AnalysisID	11
	IdentificationUnitAnalysis_1_2	AnalysisNumber	1