The 'Container Specimens' template is used to update the specimen barcodes by specifying the location of the specimens.
Steps to import CSV
Navigate to the ‘Collection Protocols’ list view page, click on 'More' → 'Biospecimen Data'.
Select 'Container Specimens' from the 'Select Records Type' dropdown and click on 'Download 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 to 'Import status' to check the status of the import job.
Sample CSV
Data Dictionary
Column Name | Datatype | Mandatory? (Update) | Description | Validations |
|---|---|---|---|---|
Location#Container Name | String | Depends | Storage Container Name | Mandatory if 'Location#Container Barcode' column is blank. |
Location#Container Barcode | String | Depends | Storage Container Barcode | Mandatory if 'Location#Container Name' column is blank. |
Location#Row | String | Depends | Specimen Position in Column | Mandatory if the box in which the specimen is stored has 'Row and Column' position labeling. |
Location#Column | String | Depends | Specimen position in Row | Mandatory if the box in which the specimen is stored has 'Row and Column' position labeling. |
Location#Position | String | Depends | Specimen stored in linear position | Mandatory if the box in which the specimen is stored has 'Linear' position labeling. |
Specimen#Barcode | String | Yes | Specimen barcode |
Use '##set_to_blank##' if you want to blank out the specimen barcode