Array CSV

Steps to import CSV

  1. From the navigation menu or ‘Home’ page, go to ‘Arrays’.

  2. Click on ‘Import’ > ‘Arrays’.

     

  3. Select the file to upload. The default data entry template can be downloaded using ‘Download Template’.

  4. Choose the ‘Create’ import type for creating new records and choose ‘Update’ for updating the existing ones.

  5. Input the date-time format. This should match with the ‘Creation Date’ column date format that has been used in the CSV.

  6. Choose the ‘Field Separator’. Valid values are ‘comma’ and ‘semicolon’. Default value is comma ','.

  7. Click on ‘Import’.

Sample CSV

Download

Data Dictionary

Column Name

Datatype

Mandatory

Description

Permissible Values

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

  • NUMERIC

  • LOWER_CASE_ALPHABETS

  • UPPER_CASE_ALPHABETS

  • LOWER_CASE_ROMAN

  • UPPER_CASE_ROMAN

Column Labeling Scheme

Text

Yes

Labeling scheme for columns

  • NUMERIC

  • LOWER_CASE_ALPHABETS

  • UPPER_CASE_ALPHABETS

  • LOWER_CASE_ROMAN

  • UPPER_CASE_ROMAN

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’

  • PENDING

  • COMPLETED

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