Steps to import CSV
From the navigation menu or ‘Home’ page, go to ‘Arrays’.
Click on ‘Import’ > ‘Arrays’.
Select the file to upload. The default data entry template can be downloaded using ‘Download Template’.
Choose the ‘Create’ import type for creating new records and choose ‘Update’ for updating the existing ones.
Input the date-time format. This should match with the ‘Creation Date’ column date format that has been used in the CSV.
Choose the ‘Field Separator’. Valid values are ‘comma’ and ‘semicolon’. Default value is comma ','.
Click on ‘Import’.
Sample CSV
Data Dictionary
Column Name | Datatype | Mandatory | Description | Permissible Values |
|---|---|---|---|---|
Name | Text | Yes | Name of the array | |
Length (mm) | Number | No | Length of the array | |
Width (mm) | Number | No | Width of the array | |
Thickness (mm) | Number | No | Thickness of the array | |
Rows | Number | Yes | Number of rows in the array | |
Columns | Number | Yes | Number of columns in the array | |
Row Labeling Scheme | Text | Yes | Labeling scheme for rows |
|
Column Labeling Scheme | Text | Yes | Labeling scheme for columns |
|
Core Diameter (mm) | Number | Yes | Diameter of the core in mm | |
Creation Date | Datetime | Yes | Date when the array was created | |
Quality | Text | No | Quality of the array | |
Status | Text | Yes | Status of the array whether it is ‘Draft’ or ‘Complete’ |
|
Comments | Text | No | Additional Details regarding the array | |
Created By#Email Address | Text | No | Email address of the user who is creating arrays | |
Checked By#Email Address | Text | No | Email address of the user who has checked arrays | |
Cores Detail#Row | Text | Yes | Row of the core in which specimen is added | |
Cores Details#Column | Text | Yes | Column of the core in which specimen is added | |
Cores Detail#Specimen#CP Short Title | Text | Yes | Collection protocol short title where the specimen is present | |
Cores Detail#Specimen#Specimen Label | Text | Yes | Specimen label of the specimen present in the core |