Prerequisites

  1. In order to store the aliquots, a dimensionless temporary freezer (Intermediate freezer in this case) is needed to be configured. This can be created using steps specified in Dimensionless Containers.
  2. The user can set a default intermediate-freezer for each site or for a specific collection protocol under this site. This can be configured via a JSON in the OpenSpecimen settings.
  3. If the freezer from input CSV (RackId) is missing, then the system will create a new freezer mentioned in the config JSON file. The importer will show an error 'Freezer to store EasyBlood aliquots not specified' if the freezer is not specified in settings. 

Steps to import CSV


  1. Go to specimen list page of any collection protocol.
  2. Click on 'More' button and select option 'Biospecimen Data'.
  3. Select 'EasyBlood Rescan' under 'Select Records Type' option.
  4. Click on 'Download Template File' to download the template file.



  5. Make sure all the data in the EasyBlood output file has the fields mentioned in the below 'Data Dictionary' table
  6. Upload the file in 'Input Records File' field.
  7. Click on 'Validate and Import' button
  8. Refer 'Import status' to check the status of import job

Sample CSV

Download

Data Dictionary

Column NameDatatype

Mandatory?

DescriptionPermissible Values

Validations

RackIDStringYesThe target freezer container name
This container should exist in OpenSpecimen. If not, a new container would be created under the intermediate freezer.
TPositionIDStringYesThe target container position, ex. A1 (First row, first Column), D5 (Fourth row, fifth column){A,B, .., H} {1,2,3, .., 12}

No other specimen should be present in this position.

CP Short TitleStringYesCollection Protocol Title in which the aliquot is collected
The aliquot must be present under the collection protocol.
TTubeBCStringYesThe label for the aliquot specimen which is to be reallocated
The specimen must exist
EB CodeStringNoThis is the site_prefix. When creating an intermediate freezer the appropriate freezer under this site_prefix would be computed from the JSON config file.
The cp and freezers mentioned in the JSON should be present in OpenSpecimen.