Intern:Editorial/Import Datasets

Import datasets from data files.

Data file types
You can import three different types of files:


 * Datamatrix with configuration options in the column headers
 * Metaheader (JSON) without data matrix
 * Datamatrix with metaheader

The metaheader is compatible with 4D's settings files.

Configuration in Column Headers

 * Parameter:
 * specify by name, e.g. Calcium
 * name with unit in square brackets, e.g. Calcium [mg/kg]
 * specify by id, e.g. 515173

Add further configuration with // directive followed by special character


 * Comment (*), e.g. //*Some comment here
 * Method ID ($), e.g. //$125
 * Format (%), e.g. //%0.00
 * PI/Staffs ID (!), e.g. //!100
 * Terminology ID (#), e.g. //#20

Placeholder
You can use placeholders in the import file


 * %filename%
 * %event%

to dynamically insert information into the fields


 * Title
 * Filename
 * Abstract
 * AlternativeTitle
 * Comment
 * CommentInternal
 * EventLabel

Example Settings File / Metaheader
// METAHEADER - 2024-03-05T12:29:43 - Data set ID 13 {  "Issue" : "PDI-100", "Title" : "Radiosonde importmatrix-bsrn measurements from station Southern Great Plains (2017-09)", "ParentID" : 78, "CollectionTypeID" : 4, "PublicationDate" : "2024-02-26T16:46:56", "ExportFilename" : "BIL_radiosonde_2017-09 PS1001-1", "EventIDs" : [ 2 ], "EventLabel" : "PS100", "Authors" : [ { "ID" : 143, "InstitutionID" : 0, "Institution2ID" : 0 } ],  "ReferenceIDs" : [ { "ID" : 38176, "RelationTypeID" : 12 } ],  "PANGAEADataReferenceIDs" : [ { "ID" : 1, "RelationTypeID" : 12 } ],  "ParameterIDs" : [ { "ID" : 1599, "PI_ID" : 143, "MethodID" : 5041, "Format" : "yyyy-MM-dd'T'HH:mm" } ],  "ProjectIDs" : [ 10 ], "AwardIDs" : [ 10001, 4 ], "LicenseID" : 21, "TopologicTypeID" : 8, "KeywordIDs" : [ 100001 ], "StatusID" : -2, "CurationLevelID" : 20, "ProcessingLevelID" : 20, "LoginID" : 3, "DateTimeMoratorium" : "2024-03-31T00:00:00", "Abstract" : "Abstract text ...", "DataSetComment" : "Launches may be at irregular time intervals. The radiosonde measurements from station Southern Great Plains are used for Billings and E13", "SourceID" : 10001, "UserIDs" : [ 1 ], "SpecialAttributes": [ { "TermID": 51418, "Name": "Sensor URI", "Value": "LINK" } ] } // METAHEADER END