...
- It would be great to confirm a number of things related to the Data Sources page. (Doing so may potentially take a while.)
We decided to start using Jira to tack our tracks, much like we do with VR's other projects.
- Review the status of Action Items assigned at past meetings.
Discussion Items
Data Sources - SELV
OpenLMIS treats "Sarampo" and "Sarampo 2 MSD" as two separate antigens. It really shouldn't though - they both refer to an antigen called "MR" (which stands for Measles and Rubella.) Although the SELV+ Dashboard currently references "Sarampo," it should instead just list "MR" (which, again, should represent a combination of OpenLMIS' "Sarampo" and "Sarampo 2 MSD".
The existing Excel dashboard includes the province of “Inhambane” on the Dados_Stock sheet. This is an experimental province which does not exist in OpenLMIS, and which need not exist in future versions of the SELV+ dashboard until it's introduced into OpenLMIS.
OpenLMIS invites users to enter "Number of Stockout Days." Why, then, do most of the rows in Excel's Indicator List related to SELV say "SELV will give us the stocks. A separately calculation will be necessary to determine stock out?" We discussed that this may be because the MoH potentially wants to define 1 "stockout" event within the SELV+ Dashboard as 5 consecutive days without stock. Is this different from what users are entering into OpenLMIS, though? Depending on how people use this field in OpenLMIS, and because OpenLMIS exclusively collects data with a monthly level of granularity, it may not be possible to produce statistics that are congruent with the MoH's definition of stockout. We need to better understand what they want, and Dércio Duvane will help us.
Data Sources - DHIS2
We have no need to directly access the DHIS-2 database. Instead, we should be able to pull the data we need from their public API using the same set of credentials they've already given us (and which appear on the /wiki/spaces/SELVDashboard/pages/365756559 page. Nevertheless, to avoid any surprises, Dércio Duvane will potentially let the MoH know that we plan to use their API. He'll emphasize, though, that we'd only reading data - and that we're certainly not accessing their database directly.
Craig Appl (Unlicensed) is currently blocked. He needs to determine exactly how we should retrieve data from the DHIS2 API. To do so, however, he needs to understand exactly what data we're currently pulling from the system. To convey this, Craig needs annotated screenshots of the DHIS-2 user interface which depict where users currently go to extract data from the system. Please indicate along with the screenshots 1) What you're clicking, 2) What report the system subsequently returns, and 3) exactly how the fields within the DHIS-2 report relate to the raw-data columns within the existing SELV dashboard. Dércio Duvane will help provide this info and will ask for clarification about the request if need be.
Data Sources - HSS Funds
...
If we do decide to rely on pulling images, we hope to avoid the performance penalty of HTTP requests to NexLeaf by retrieving the images as part of the data-ingestion process. The images would thus essentially be cached within the local database. Clay Crosby (Unlicensed) and the Ona team think this approach would probably work.
Finally, the section of the indicators list shown below would benefit from elaboration. Dércio Duvane will thus review and update it.
Data Sources - Trimestrial Reports
...
- Dércio Duvane will clarify how stockout days should be handled.
- Dércio Duvane will get Craig Appl (Unlicensed) the guidance he needs about DHIS-2.
- Dércio Duvane will let the MoH know that we'd like the "HSS Funds" to be presented as a CSV file delivered via an email attachment.
- Dércio Duvane will present the options and tradeoffs we face regarding NexLeaf to Timoteo Chaluco (Unlicensed) and Vidya. He'll let us know whether they prefer the use of automated (but limited) images or, instead, manual data entry as implemented in the current version of the dashboard.
- Dércio Duvane will determine what the data source is for RED/REC
- Dércio Duvane will clarify cell G:31 of the indicator list.