This template is used when specimen label auto-generation is on for aliquots. Refer 'Label Configuration' to set label format to auto-generate specimen labels.
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 aliquot specimens have to be created/updated, click on the 'More' button and select the option 'Biospecimen Data.'
- Select 'Specimen Aliquots' 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 below 'Data Dictionary' table
- 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 import job
Sample CSV
Data Dictionary
Column Name | Datatype | Mandatory? (Create) | Description | Permissible Values | Validations |
|---|---|---|---|---|---|
| CP Short Title | String | No | The collection protocol short title under which specimens have to be created | This is mandatory only if specimen labels are not unique across collection protocols. | |
| Parent Specimen Label | String | Yes | The specimen should exist within the system | ||
| Quantity per Aliquot | Double | Yes, if parent quantity is not specified or the number of aliquots is not specified | If not specified, it divides the entire parent specimen available quantity into equal amounts amongst all the aliquots | ||
| Number of Aliquots | Integer | Yes, if parent quantity is not specified or quantity per aliquot is not specified | When left blank, the number of aliquots=(parent quantity/quantity per aliquots) | ||
| Container | String | No | It needs to be specified if the specimen is not virtually located |
| |
| Start Row | String or Integer | No | Datatype depending on the row labeling scheme (Numbers, Alphabets Upper Case, Alphabet Lower Case, Roman Upper Case, Roman Lower Case) | Position within the container at which the specimen is to be stored. If left blank, the system will allocate the next available position. | |
| Start Column | String or Integer | No | Datatype depending on the column labeling scheme (Numbers, Alphabets Upper Case, Alphabet Lower Case, Roman Upper Case, Roman Lower Case) | ||
| Start Position | Number | No | The single number or linear position labels to identify slots within the container for storing specimen | ||
| 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 aliquot | ||
| 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 | |
| Specimen Additional Fields#Media Volume | Number | No | |||
| Specimen Additional Fields#Cell Viability (%) | Number | No |