Switch branches/tags
Nothing to show
Find file History
Wolferl Add files via upload
Update of import schema.
Latest commit 42c916a Mar 3, 2017

README.md

This import schema provides the possibility of importing files generated with the DiversityImageInspector into DiversityCollection. For more information about the DiversityImageInspector please visit

http://diversityworkbench.net/Portal/DiversityImageInspector

The import table includes the following information:

  • Date and time
  • Coordinates
  • Altitude
  • Author
  • Unit code

Any other information that is not included in the defined columns should be added to the free columns at the right side of the table. The import schema should be modified in order to import this addition.

This import schema was created based on the original organization of the data. For a further successful use of this schema, please note that the interface settings e.g. ProjectID should be adapted to your installation, as well as other settings like prefixes, postfixes, splitters or filters.



File columns
Pos.NameTableColumnExampleTransformed
0Import File Namenot imported
1Create Date
CollectionEvent. CollectionDay2015:09:11 08:59:0811
Transformations:
Split at Pos.Dir.
:_
3
CollectionEvent. CollectionMonth2015:09:11 08:59:0809
Transformations:
Split at Pos.Dir.
:
2
CollectionEvent. CollectionYear2015:09:11 08:59:082015
Transformations:
Split at Pos.Dir.
:
1
CollectionEvent. CollectionTime2015:09:11 08:59:0808:59:08
Transformations:
Split at Pos.Dir.
_
2
2Author
CollectionAgent_1. CollectorsName
3GPS Latitude
CollectionEventLocalisation_1. LocationNotes"0 deg 30' 29.28"" S"
Prefix:[Ori.val.: Lat.:
4GPS Latitude (decimal)
CollectionEventLocalisation_1. Location2-0.50813333
5GPS Longitude
+CollectionEventLocalisation_1. LocationNotes"34 deg 10' 8.86"" E"˽Long.: "34 deg 10' 8.86"" E" ]
Prefix:˽Long.:˽
Postfix:˽]
6GPS Longitude (decimal)
CollectionEventLocalisation_1. Location134.16912778
7GPS Altitude
CollectionEventLocalisation_7. Location11180 m Above Sea Level1180
Transformations:
Split at Pos.Dir.
m
1
CollectionEventLocalisation_7. LocationNotes1180 m Above Sea Level
Prefix:[Ori.val.:˽
Postfix:]
8Unit Code
CollectionSpecimen. ExternalIdentifierTEST-e34b8737
9Renamed Image Filenot imported
10UUID 1
CollectionEvent. CollectorsEventNumber
CollectionSpecimen. AccessionNumber
11not imported
12not imported

Interface settings (= For all)
TableTable aliasColumnValueDisplay
CollectionEventLocalisationCollectionEventLocalisation_1RecordingMethodGPS digital camera
CollectionProjectCollectionProject_1ProjectID1132-