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 'Import' button and select option 'Biospecimen Data' OR
- Go to participants list page of the CP under which the aliquot specimens have to be created/updated, click on 'More' button and select option 'Biospecimen Data'
- Select 'Specimen Aliquots' 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
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 | Specimen should be existing within the system | ||
| Quantity per Aliquot | Double | Yes if parent quantity not specified or number of aliquots 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 not specified or quantity per aliquot not specified | When left blank the number of aliquots=(parent quantity/quantity per aliquots) | ||
| Container | String | No | 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 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 |