User can create/Update frozen event of any specimens in bulk through bulk operation, follow below steps to create/update frozen event in bulk:
- Go to the collection protocols list page, click on 'Import' button and select option 'Biospecimen Data' Import OR
- Go to participants list page of the CP, click on 'More' button and select option option 'Biospecimen Data'Import
- Select 'Frozen Event' from 'Select Record Type' specimen's 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, select 'Import Type' as 'Create' to create or 'Update' to update speciemns frozen event
- Click on 'Validate and Import' button
- Refer 'Import status' to check the status of import job
...
Column Name | Datatype | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
|---|---|---|---|---|---|---|
| Record ID | Integer | No | Yes | Used to update an existing form record in the system | Required only when updating. Record ID is system generated ID for every form record. To retrieve record ID, create a query to retrieve form records and include the form ID for the frozen event form in the columns of query results view. | |
| CP Short Title | String | Yes | Yes | Required when unique label per CP setting is enabled. | ||
| Specimen Label | String | Yes | Yes | Specimen label of the specimen for which the frozen event is to be added | Specimen should be existing within the system | |
| Barcode | String | No | No | |||
| Activity Status | String | No | No | Activity status of the record. To remove the existing records for the form add 'Disabled' along with the record ID of the form and import as an update | Active/Disabled | Value should be 'Active' during creation or kept blank in which case it will take default value as 'Active' |
| Method | String | Yes | No | Method used to freeze the sample | ||
| User | String | Yes | No | Email address of the user who froze the samples | ||
| Date and Time | Date and Time | Yes | No | Select the correct date and time format from UI based on the data in the file | ||
| Comments | String | No | No | |||
| Increment Freeze/Thaw Cycles | Integer | No | No | Field used to increment the freeze thaw cycle of the specimen. 0 - no increment, 1 - increment the freeze thaw cycle (Freeze thaw of parent +1) | Default value 0 |
...