From v5.0, you can create distribution protocols requirements in bulk via CSV import.
- Go to home page and click on 'Distribution Protocols' card
- Click on 'Import' button and select option 'Requirements' from the distribution protocols list page
- 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 requirements
- Click on 'Validate and Import' button
- Refer 'Import status' to check the status of import job
Column Name | Data Type | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
---|---|---|---|---|---|---|
Identifier | String | No | Yes | The system generated unique identifier for the requirement | This is used only during edit to update other fields of specimen requirements | |
Specimen Type | String | No | No | Permissible values for specimen class-type | Should be valid value from the list | |
Anatomic Site | String | No | No | Permissible values for anatomic site | Should be valid value from the list | |
Pathology Status#1 | String | No | No | Non-Malignant /Non-Malignant, Diseased /Pre-Malignant /Malignant, Pre-Invasive /Malignant, Invasive /Malignant /Metastatic /Not Specified | Should be valid value from the list | |
Pathology Status#2 | String | No | No | Non-Malignant /Non-Malignant, Diseased /Pre-Malignant /Malignant, Pre-Invasive /Malignant, Invasive /Malignant /Metastatic /Not Specified | Should be valid value from the list | |
Clinical Diagnosis | String | No | No | Should be valid value from the list | ||
Specimen Count | Integer | Yes | No | Number of specimens | ||
Quantity Per Specimen | Double | Yes | No | |||
Comments | String | No | No | |||
Distribution Protocol#Short Title | String | Yes | No | The short title of the DP under which the specimen requirements has to be created | Should be existing within system |