The 'Container Specimens' template is used to update the specimen barcodes by specifying the location of the specimens. This is useful if you are using flat bed or box scanners where you get output CSV with box barcode, specimen location within the box and specimen barcodes.

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

Download

Data Dictionary

Column Name	Datatype	Mandatory? (Update)	Description	Validations

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

OpenSpecimen

Container Specimens CSV

Steps to import CSV

Sample CSV

Data Dictionary