Intern:Import

Workflow for the import of data with the 4D client.

single data set

 * First column: Event label as header, followed below by the label as defined in the 4D event table.
 * Next columns may contain the third spatial dimension (e.g. DEPTH, sediment) or the time (DATE/TIME) with ID/parameter name in header line; for options see geocode.
 * The following data columns should contain in the header line
 * the parameters full name as defined in the parameter table followed by a blank and the unit in bracket [] or
 * the parameters short name followed by a blank and the unit in bracket [] or
 * the parameter ID

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





Save your table as a tab-delimited textfile (*.txt). In 4D, you can import your textfile clicking on Import > Data. The import window opens, allowing you to select your file by clicking on Open. After selecting your textfile you add Author(s), Reference(s) and Project(s) by clicking in the respective field. Be sure to also change the Title and to check the publication year. If no reference for certain data sets is given (and not to be expected), use the field Source to define the source of the data. Source is relational to the institution table.

In the tab Config you can choose/change the PI and the methods and add a parameter-specific comment as follows:
 * tick the Edit in list box
 * mark the respective cells in the PI/Method-column and click on Choices
 * a new window appears where you can choose the PI/Method by double-clicking or clicking on Select
 * if you want to add a parameter-specific comment just click into the respective cell in the Comment-column and insert the text
 * you can also change the format of the cells (Format column) e.g. by adding digits (#0.00 instead of #0) or removing them (#0.0 instead of #0.000)

Lastly, in the tab Details you can add an Export filename, a data set Comment or the Abstract. If a single data set is a supplement to an article (Status supplementary data in the Basics tab), an abstract has to be provided. In this case the Export filename should be in the format Author_Year, 1stAuthor-2ndAuthor_Year or Author-etal_Year.

Before clicking on the Import button, you can change the ID of your data set. Old data sets can thus be replaced by new versions, meaning: after opening the import file with the new version, an already existing data set can be replaced by exchanging the ID of the new version with the ID of the old data set (the one which needs to be replaced). If you don't want to replace an old data set just click on the Import button without changing the ID.

After this whole process, please always check the metadata and the data table you just imported by clicking on Open URL.

Import of data sets with special characters (öäüß) does not work with Macintosh 4D-clients due to an ODBC driver problem.

several data sets (Massenimport)
Rainer please add workflow

Recipies for the import of various data types



 * Vertical sediment profile
 * Geological Age
 * Sediment seismic
 * Reflection seismic
 * Echo sounder
 * Bathymetry
 * Mooring
 * Pollen
 * CTD