Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com
Specimen Derivative CSV
- Kruti Nandu (Unlicensed)
- asawari (Unlicensed)
- Shraddha Ranpise (Deactivated)
Owned by Kruti Nandu (Unlicensed)
Steps to Import CSV
- Go to the collection protocols list page, click on the 'Import' button, and select option 'Biospecimen Data' OR
- Go to the participants list page of the CP under which the derived specimens have to be created/updated, click on the 'More' button, and select the option 'Biospecimen Data'.
- Select 'Specimen Derivatives' from the '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 'Data Dictionary' table below.
- Upload the filled template file in the 'Input Records File' field.
- Click on the 'Validate and Import' button.
- Refer 'Import status' to check the status of the import job.
Sample CSV
Data Dictionary
Column Name | Datatype | Mandatory? | Description | Permissible Values | Validations |
|---|---|---|---|---|---|
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 users 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 | Mandatory when the auto label generation is OFF or 'Manual Inputs Allowed For' is selected. | ||
| Barcode | String | No | |||
| Class | String | No |
| If left blank system will add class based on specimen type in the input. | |
| Type | String | Yes | Permissible Values File | Field not applicable to the aliquot as aliquot type would always be same as that of parent | |
| Collection Status | String | No |
| ||
Pathological Status | No |
| |||
| Initial Quantity | Double | No | Default Value: Not Specified | ||
| Available Quantity | Double | No | |||
| 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 | |
| Comments | String | No | |||
| Location#Container | String | No | It 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 the next available position. | ||
| Location#Column | String | No | |||
Location#Position | Number | No | The single number or linear position labels to identify slots within the container for storing specimen |
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com