Intern:Import

Import of data in brief:

First column:

Event label in header, followed by the label as defined in the event table. (One event per data set ! A table containing several events can be seperated with the tool Split2Events).

Second and/or third column may contain the third spatial dimension or the time (ID).


 * DEPTH, sediment [m] (1) unit ‚m‘ or ‚cm‘ can be used in the header, depending on the unit of the import data. Automatic conversion during import.
 * DEPTH, water [m] (1619)
 * DEPTH, ice [m] (5059)
 * DISTANCE [cm] (2920) in an object, e.g. coral, tree, shell, nodule
 * ELEVATION [m] (8128) for sample taken on the earth surface, above sea level
 * ALTITUDE [m] (4607) for sample in the air
 * ORDINAL NUMBER (6262) can be used, if no third dimension is given and data should kept in order.

A data set can only have ONE vertical spacial geocode but may also have a time geocode


 * DATE/TIME (1599) for time series or any other time relevant data
 * AGE [kyr] (2205) for a geological time

Any following columns should contain in the header line


 * the parameters full name as defined in PANGAEAs parameter table or
 * the parameters short name or
 * the parameter ID

Ambiguous parameters can be made unique with the unit in brackets attached.

Import routines for campaign and references (e-mail by M. Diepenbroek on 14.10.2004) have slightly changed. Authors or chief scientist are now also recognized by staff IDs. Please, check the corresponding template files on http://www.pangaea.de/curator/ before importing new records. Michael

Import references etc. (mail from M. Diepenbroek on 27.09.2004):

Dear colleagues, In the following some remarks on new and old (confused) subjects:

1. The import routine of references has changed. Please have a look at the InpReference.xls on http://www.pangaea.de/curator/ for further specifications.

2. Since several months authors have to be specified also for data sets. Authors of references are different from authors of references. The import routine helps specifiying these authors according to the following scheme:


 * All PIs of a data set are also listed as authors
 * The first author of the first reference of a data set is also the first author of the data set.

You can add or remove authors from the list or change the order, if you think this better reflects the authorship for the data set. Have in mind to set the order of references accordingly.