You can import Supply items in bulk to add new items or edit the status of existing items.

Note: You can update the items as ‘Expired' ‘Damaged’ or ‘Misplaced' but not “Consumed”. This is because to consume a supply item it has to be linked with a visit or specimen.

Steps to import CSV

Go to Supplies → Select ‘Type’ → Select Supply → Click on 'Import' → Items.
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 the 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update supply.
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	Data type	Mandatory? (Create)	Mandatory? (Update)	Description	Permissible Values	Validations

Column Name	Data type	Mandatory? (Create)	Mandatory? (Update)	Description	Permissible Values
Supply Item ID	Number	No	Yes	Supply Item Identifier
Supply ID	Number	No	No	Supply ID to which this barcode belongs to
Name	String	Yes	No	Supply name to which this barcode belongs to
Barcode	String	Yes	No	Item name
Consumption Date	Date	No	No	If not specified, takes current timestamp
Reason	String	No	No		Expired Damaged Misplaced
Description	String	No	No	The description of item. Eg: why the item is marked as damaged

OpenSpecimen

Supply Items CSV

Steps to import CSV

Sample CSV

Data Dictionary