Skip to content
This repository has been archived by the owner on Nov 19, 2020. It is now read-only.

Uploads

Jump to bottom
Jasdeep Madan edited this page Nov 14, 2013 · 1 revision

Reference Data

Following is the list of reference data required in the system as part of openLMIS set up

Programs

This list indicates all programs supported by the system. Each country can define their own set of programs supported.

SAMPLE DATA
Program DisplayOrder
HIV 1
Essential Medicines 2
ARV 3

Product Form

This list indicates all possible forms products are available in and each country can define their own list.Each product should be mapped to one of the forms defined in country list. Display order defines country preference in the order they should be displayed in the system.

SAMPLE DATA
ProductFormText DisplayOrder
Tablet 1
Capsule 2
Bottle 3
Vial 4
Satchet 15
Device 16

Dosage Units

Each product has smallest unit in which it cam be expressed. Each country can define their own list and then each product should be mapped to one of the forms defined in country list. Display order defines country preference in the order they should be displayed in the system.

SAMPLE DATA
DosageUnitsText DisplayOrder
mg 1
ml 2
each 3

Geographic Zone in countries

Each Country will have their own GeoPolitical levels and Geographic Zones. This Can be defined and each Facility can be mapped to a geographic zone defined in the system.

Facility Types

Each country will have its own level of facilities operating in the country. This list provides all type of facilities operating in the country and each facility in the system will be mapped to a facility type.

SAMPLE DATA
FacilityTypeName FacilityTypeDescription DisplayOrder
Health Center Multi-program clinic 1
District Office Management Office, no programs 7
Community Health Worker Mobile worker based out of health center 2
Satellite Facility Temporary service delivery point 6
Provincial Office Management Office, no programs 8
District Hospital Community Hospital 3

Facility Operated by

Each country can have set of organization operating facilities. This list is the name of those Organizations and each facility in the system will be mapped to it. Display order defines country preference in the order they should be displayed in the system

SAMPLE DATA
FacilityOperator DisplayOrder
MoH 1
NGO 2
Private 4
FBO 3
#### Products Data

Upload Products

Prerequisite for products Upload
  • Product Form
  • Dosage Unit
File format with sample data
  • File should be comma (,) separated CSV file.
  • Column headers should be maintained as provided in template.
  • If any data value contains comma(,) use double quotes to define that value. Example: Description = “Aspirin,300mg”
  • Mandatory columns listed below are must in the file
  • Following Fields cant be Negative or Zero: Doses Per dispensing Unit and Pack Size (Yet to be Implemented)
  • Download template (This will be link to download the template)
Mandatory fields for a product file:
  • ProductCode
  • ProductPrimaryName
  • PackSize
  • ProductIsActive
  • ProductIsFullSupply
  • IsATracerProduct
  • PackRoundingThreshold
  • CanRoundToZero
Download csv file from given link

https://raw.github.com/OpenLMIS/open-lmis/master/test-data/csv/products.csv

Upload Product Cost

Prerequisite for products to program mapping Upload
  • Products
  • Programs
File format with sample data
  • File should be comma (,) separated CSV file.
  • Column headers should be maintained as provided in template.
  • If any data value contains comma(,) use double quotes to define that value. Example: Description = “Aspirin,300mg”
  • Mandatory columns listed below are must in the file
  • File has a duplicate record entry (product and program combination) , Update the existing record
  • Following Fields cant be Negative : Price per pack , Price per dosage unit
  • Download template (This will be link to download the template)
Mandatory fields for a Product Cost file:
  • Product Code
  • Program Code
  • Price per pack
Please download the csv from the link below

https://github.com/OpenLMIS/open-lmis/blob/master/test-data/csv/Product_Cost.csv

Upload Product to Product Mapping

Prerequisite for products to program mapping Upload
  • Products
  • Programs
File format with sample data
  • File should be comma (,) separated CSV file.
  • Column headers should be maintained as provided in template.
  • If any data value contains comma(,) use double quotes to define that value. Example: Description = “Aspirin,300mg”
  • Mandatory columns listed below are must in the file
  • Following Fields cant be Negative or Zero: Doses per month (Yet to be Implemented)
  • Download template (This will be link to download the template)
Mandatory fields for a product file:
  • Product Code
  • Program Code
  • IsActive
  • Doses per month
Please download the csv from the link below

https://raw.github.com/OpenLMIS/open-lmis/master/test-data/csv/Program%20Product.csv

Upload Product to Facility Type Mapping

Prerequisite for products to Facility type mapping Upload
  • Facility type
  • Products
  • Programs
  • Products to program mapping
File format with sample data
  • File should be comma (,) separated CSV file.
  • Column headers should be maintained as provided in template.
  • If any data value contains comma(,) use double quotes to define that value. Example: Description = “Aspirin,300mg”
  • Mandatory columns listed below are must in the file
  • Following Fields cant be Negative or Zero: Max Months of stock (Yet to be Implemented)
  • Download template (This will be link to download the template)
Mandatory fields for a product file:
  • Product Code
  • Program Code
  • Facility Type code
  • Max Months of Stock
Please download the csv from the link below

https://github.com/OpenLMIS/open-lmis/blob/master/test-data/csv/Facility%20Type%20To%20Product%20Mapping.csv

Facilities Data

Upload Geographic Zones

Upload Facility

Prerequisite for Facility Upload
  • Facility Type
  • Geographic Zone
  • Facility Operated By
File format with sample data
  • File should be comma (,) separated CSV file.
  • Column headers should be maintained as provided in template.
  • If any data value contains comma(,) use double quotes to define that value. Example: Description = “Aspirin,300mg”
  • Mandatory columns listed below are must in the file
  • Download template (This will be link to download the template)
Mandatory fields for a Facility file:
  • FacilityCode
  • FacilityName
  • GeographicZoneID
  • FacilityTypeID
  • FacilityIsSDP
  • IsActive
  • FacilityGoLiveDate
  • Data Reportable
Download sample csv file from link below

https://raw.github.com/OpenLMIS/open-lmis/master/test-data/csv/facilities.csv

Upload Faciltiy to Program Mapping

Prerequisite for facility to program mapping Upload
  • Facility
  • Program
File format with sample data
  • File should be comma (,) separated CSV file.
  • Column headers should be maintained as provided in template.
  • If any data value contains comma(,) use double quotes to define that value. Example: Description = “Aspirin,300mg”
  • Mandatory columns listed below are must in the file
  • Download template (This will be link to download the template)
Mandatory fields for a product file:
  • Facility Code
  • Program Code
  • Program Is Active
Download sample csv file from link below

https://raw.github.com/OpenLMIS/open-lmis/master/test-data/csv/Program%20Supported%20By%20Facilities.csv

Upload Requisition Groups

Requisition Group Setup comprises of Five Uploads listed in order of upload to be followed
  • Supervisory Nodes Definition
  • Requisition Groups Definition
  • Requisition Group members
  • Requisition Group supported programs and Schedule
  • Supply Lines
Prerequisite for Requisition Group Upload
  • Facilities
  • Program
  • Schedule
File format with sample data
  • File should be comma (,) separated CSV file.
  • Column headers should be maintained as provided in template.
  • If any data value contains comma(,) use double quotes to define that value. Example: Description = “Aspirin,300mg”
  • Mandatory columns listed below are must in the file
  • Download template (This will be link to download the template)
Mandatory fields for Supervisory Nodes Definition file:
  • Supervisory Node Code
  • Name of Node
Mandatory fields for Requisition Groups Definition file:
  • RG Code
  • Name of RG
  • Supervisory Node
Mandatory fields for Requisition Group members file:
  • RG Code
  • Member (Facility Code)
Mandatory fields for Requisition Group supported programs and Schedule file:
  • RG Code
  • Program (Program Code)
  • Schedule
Mandatory fields for Supply Lines file:
  • Supervising Node
  • Program (Program Code)
  • Facility (Facility code)
Download sample csvs from links below:

Users Data

Upload Users

Prerequisite for Users Upload

None

File format with sample data
  • File should be comma (,) separated CSV file.
  • Column headers should be maintained as provided in template.
  • If any data value contains comma(,) use double quotes to define that value. Example: Description = “Aspirin,300mg”
  • Mandatory columns listed below are must in the file
  • Download template (This will be link to download the template)
Mandatory fields for a user file:
  • User Name
  • Password
  • First Name
  • Last Name
  • Email
Download csv file from given link

https://raw.github.com/OpenLMIS/open-lmis/master/test-data/csv/Users.csv

Sample CSVs

https://github.com/OpenLMIS/open-lmis/tree/master/test-data/csv

Clone this wiki locally