Steps to Import CSV
- Go to the collection protocols list page, click on 'Import' button and select option 'Biospecimen Data' OR
- Go to participants list page of the CP under which the derived specimens have to be created/updated, click on 'More' button and select option 'Biospecimen Data'
- Select 'Specimen Derivatives' from 'Select Record Type' dropdown and click on 'Download Template File' to download the template file
- Enter all valid data in the template file as mentioned in the below 'Data Dictionary' table
- Upload the filled template file in 'Input Records File' field
- Click on 'Validate and Import' button
- Refer 'Import status' to check the status of import job
Sample CSV
Data Dictionary
| Added in | Column Name | Datatype | Mandatory? | Description | Permissible Values | Validations |
|---|---|---|---|---|---|---|
| v3.3 | CP Short Title | String | Yes | The collection protocol short title under which specimen is collected | This is mandatory only if specimen labels are not unique across collection protocols. This is a setting user can set in Admin settings. By default labels are unique across the system. | |
| Parent Specimen Label | String | Yes | Should label of a collected parent within the system | |||
| Specimen Label | String | Depends | Needs to be specified when the auto label generation is OFF or 'Manual Inputs Allowed For' is selected | |||
| Barcode | String | No | ||||
| Class | String | No |
| In v3.4, if left blank system will add class based on specimen type in the input | ||
| Type | String | Yes | Permissible Values File | |||
| Collection Status | String | No |
| |||
Pathological Status | No |
| ||||
| Initial Quantity | Double | No | Default Value: Not Specified | |||
| Available Quantity | Double | No | ||||
| v4.2 | Concentration | Double | No | This field applies only to molecular specimens | ||
| Biohazard#1 | String | No | Multiple values can be specified as: Biohazard#1, Biohazard#2, Biohazard#3 and so on |
| Valid value from the list | |
| Created On | Date | No | Select the correct date format from UI based on the data in the file | |||
Freeze/Thaw Cycles | Number | No | Freeze/Thaw Cycle of the derivative | |||
Increment Parent Freeze/Thaw Cycles | Number | No | Number by which parent freeze/thaw cycle is to be incremented | |||
| Close Parent | String | No | options- Yes/No or true/false | Parent specimen should be in collected -collection status | ||
| v5.0 | Comments | String | No | |||
| Location#Container | String | No | Needs to be specified if the specimen is not virtually located |
| ||
| Location#Row | String | No | Position within the container at which the specimen is to be stored. If left blank, the system will allocate next available position. | |||
| Location#Column | String | No | ||||
| v3.4 | Location#Position | Number | No | The single number or linear position labels to identify slots within the container for storing specimen |