From v5.0, you can create distribution protocols requirements in bulk via CSV import.
Steps to import CSV
- 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 'Data Dictionary' 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
Sample CSV
Data Dictionary
| Column Name | Data Type | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
|---|---|---|---|---|---|---|
| Identifier | String | No | Yes | The system generated a 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 a valid value from the list | |
| Anatomic Site | String | No | No | Permissible values for anatomic site | Should be a valid value from the list | |
| Pathology Status#1 | String | No | No |
| Should be a valid value from the list | |
| Pathology Status#2 | String | No | No |
| Should be a valid value from the list | |
| Clinical Diagnosis | String | No | No | Should be a valid value from the list | ||
| Specimen Count | Integer | Yes | No | Number of specimens | ||
| Quantity Per Specimen | Double | Yes | No | |||
| Cost | Integer | No | No | Cost of the specimen | ||
| 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 the system |