Leave a comment at the end of this page or email contact@krishagni.com
Supply CSV
Steps to import CSV
Go to Supplies → on the ‘Types’ list view click on ‘Import’ → Supplies.
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
Data Dictionary
Column Name | Data type | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
|---|---|---|---|---|---|---|
Supply ID | Number | No | No | System generated unique number for every supply | ||
Name | String | No | Yes | If not specified system generates a unique number for the supply |
| |
Procurement Date | Date | Yes | No | The date when the supplies are brought or the supply is set |
| |
Expiry Date | Date | Yes | No | The date when supply will expire |
| |
Procured Quantity | Number | No | No | The used number of items in supply. This applies to non-barcoded supply items. |
| |
Available Quantity | Number | No | No | The available number of items in supply. This applies to non-barcoded supply items. |
| |
Description | String | No | No | Comments or details related to supply |
|
|
Type#Supply Type ID | Number | Yes | No | System auto-generated unique number for every type under which the supply is created |
|
|
Type#Name | String | No
| No | Name of type under which the supply is created |
|
|
Vendor#Name | String | Yes | No |
|
| This should be valid vendor name from the Vendors. Refer to Vendors and Locations |
Site#Name | String | No | No | The site where the supplies are stored. Ensure that supply site is included in the collection protocol site, or else the system will not allow to consume the item. |
|
|
Location#Name | String | No | No | Location within the site where the supplies are kept. E.g. cupboard, drawer. |
| Refer to Vendors and Locations |
Allowed CP#1#Short Title | String | No | No | One ore more collection protocols for which this supply is procured for. You can consume the items only from allowed collection protocol. |
|
Leave a comment at the end of this page or email contact@krishagni.com