Goals/Scope
eLMIS needs to send data related to RMNCH products and LLIN to DHIS2.
Status in eLMIS: In eLMIS.
Status in OpenLMIS: Not Implemented
Priority: High priority for Tanzania
Background
The RMNCH program and Malaria program want to see eLMIS logistics data triangulated with service statistics-related data separately collected in DHIS2 through custom dashboards created in DHIS2.
This interface requires additional configurations at both end, described in the user stories.
Assumptions
User Stories
# | Title | User Story | Label | Importance | Notes |
---|---|---|---|---|---|
1 | Compare facility list with DHIS2 | As a user, I need to be able to user the compare facility lists from EPICOR and DHIS2 at the initial stage of the interface implementation and create a common list so that facility lists can be synced for NGO and some private facilities that are in DHIS2. | Tanzania eLMIS DHIS2 interface | Must have | eLMIS uses the facility list from EPICOR for those facilities who are supplied by MSD warehouses. DHIS2 maintain their own facility list. |
2 | Compare product list with DHIS2 for RMNCH and Malaria products | As a user, I need a way to compare product lists between DHIS2 and eLMIS so that product codes and products are matched between the systems. | Tanzania eLMIS DHIS2 interface | Must have | |
3 | Import facility list csv file | As an administrator, I need to be able to import a facility list csv file so that the facilities in DHIS2 that are supplied by MSD are available. | Tanzania eLMIS DHIS2 interface | Must have | From DHIS2 obtain data element ids for each facility through a CSV export file. DHIS2 can produce a list of facility that are supplied by MSD. This list will contains the data element ids for each facility. This list is being imported and maintained in separate tables. |
4 | Import product list CSV file into eLMIS | As an adminsitrator I need to be able to import a product list from DHIS2 for products in the RMNCH and Malaria program so that products for these programs are available. | Tanzania eLMIS DHIS2 interface | Must have | Gap document noted this needs to be maintained in a separate table. |
5 | Generate XML file for feed into DHIS2 | As an administrator I need a process for generating an XML file to send to DHIS2 so that I can export to DHIS2. | Tanzania eLMIS DHIS2 interface | Must have | This is currently a server side script in Tanzania. |
6 | Obtain URL for data submission from DHIS2 | As an administrator I need information from DHIS2 so that I can submit data with the curl tool. DHIS2 requires: site address/URL, form submission location locational to be included on the URL, user id, and password. | Tanzania eLMIS DHIS2 interface | Must have | DHIS2 expects data to be submitted through “curl” utility. DHIS2 will provide these information. |
7 | Automate the data feed routine | As an administrator, I need to be able to automate monthly data submission so that user intervention is not required for this to happen consistently each month. | Tanzania eLMIS DHIS2 interface | Must have | This is done through server side scripting. |
Diagrams
Facilities list
Product list
Data items list
<dataValueSet xmlns="http://dhis2.org/schema/dxf/2.0" >
<dataValue orgUnit="Lo423ozVkFw" dataElement="ndLcCJP1R5n" period="201607" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="ndLcCJP1R5n" period="201608" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="ndLcCJP1R5n" period="201609" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="m6oXxb5XAUn" period="201607" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="m6oXxb5XAUn" period="201608" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="m6oXxb5XAUn" period="201609" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="DZKHCq8f3NQ" period="201607" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="DZKHCq8f3NQ" period="201608" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="DZKHCq8f3NQ" period="201609" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="EpNzl1xg26I" period="201607" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="EpNzl1xg26I" period="201608" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="EpNzl1xg26I" period="201609" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="JmxXYzhJMA6" period="201607" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="JmxXYzhJMA6" period="201608" value="0"/>
<dataValue orgUnit="Lo423ozVkFw" dataElement="JmxXYzhJMA6" period="201609" value="0"/>
…
…
</dataValueSet>
Sample XML file
Dependencies
Description | Link |
---|---|
Open Questions
Below is a list of questions to be addressed as a result of this requirements document:
# | Question | Outcome | Status |
---|---|---|---|
1 | A District Consumption Comparison report is mentioned elsewhere in the gap analysis document. Is this also a Tanzania gap? "Displays consumption comparison across multiple districts. The comparison is represented by % i.e. total consumption of district x/total consumption of all districts * 100." | Yes, It is a gap in Tanzania | |
2 | For Tanzania user stories: review/update the users and "so thats". | ||
3 |