You can create aliquot specimens in bulk through bulk operation, follow below steps to create aliquot specimens in bulk:
- Go to the collection protocols list page, click on 'Import' button and select option 'ImportBiospecimen Data' OR
- Go to participants list page of the CP whose aliquot specimens has to be created, click on 'More' button and select option option 'Biospecimen Data'Import
- 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 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
| Note |
|---|
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. |
Column Name | Datatype | Mandatory? (Create) | Description | Permissible Values | Validations |
|---|---|---|---|---|---|
| CP Short Title | String | No | 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 | 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 labelling 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, system will allocate next available position. | |
| Start Column | String or Integer | No | Datatype depending on the column labelling scheme (Numbers, Alphabets Upper Case, Alphabet Lower Case, Roman Upper Case, Roman Lower Case) | ||
| Start Position | Number | No | single number or linear position labels to identify slots within 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 |
...