From v5.0, you can create distribution protocols requirements in bulk via CSV import.

Steps to import CSV

Expand...

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

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		Non-Malignant Non-Malignant, Diseased Pre-Malignant Malignant, Pre-Invasive Malignant, Invasive Malignant Metastatic Not Specified Clinically normal	Should be a 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 Clinically normal	Should be a valid value from the list
Clinical Diagnosis	String	No	No		Permissible Values File - SNOMED Permissible Values File - ICD 10	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
Activity Status(Added in v7.0)	String	No	No	Activity status of DP requirements	Active/Disabled	Value "Disabled" is used to delete the DP requirements.
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