Re: [Dhis2-devs] New app - League tables

[Johan Ivar Sæbø]

Dear list,

We would be interested to hear if anyone has looked at or used the 
league table app yet. The developers are finishing their Masters thesis 
these days, and would appreciate any feedback that they could 
incorporate in their discussions or plans for future development.


Thanks,
Johan

On 31.03.2016 16:10, Johan Ivar Sæbø wrote:

Dear list,

a new app for DHIS2, League Tables, is available here:
https://bitbucket.org/tronerud/league-table-application

League Tables is a web-application customized to create, edit and view
league tables. It's strictly an analytic tool generating output data,
from DHIS2. League tables allow you to rank any organizational units
against a set of indicators you choose. Different weight towards the
total can be given to the individual indicators selected.

Go to the link for more information, screenshots, downloadable .zip, and
code.

The app is also availble on the demo server here:
https://play.dhis2.org/demo/api/apps/leagueTableApp/index.html#/tables

It has been piloted in Malawi, and we are grateful for any additional
feedback for further improvements. It will be available in DHIS2 app
store soon. The app was developed by Kristoffer Adam Tronerud and Martin
Theodor Vasbotten.

Regards,
Kristoffer, Martin, and Johan





___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Restoring backup

[Johan Ivar Sæbø]

Hi Ifeany,

I forward this to the developer list, which is a good place to direct 
such issues. You should create an account and join the list here:

https://launchpad.net/~dhis2-devs

I leave it to someone with more expertise to help with the backup 
restoration.

Johan

On 18.05.2016 19:57, Dr. Ifeanyi Okoye wrote:

Hello Johan,
I hope you are doing well.

I need some technical help with DHIS2 and looking for someone to talk to.

I created a db backup file in plain format using pgAdmin for Windows 
(PostgreSQL 9.4). I am trying to restore the backup file to a Postgre db in 
Ubuntu with psql but it is just not working. Says it cannot read file.

Who can I talk to to help with this. Been driving us nuts all day.

My colleague can give some more insight into this.

Looking forward to hearing from you.

Ifeanyi Okoye MB;BS, M.Inf.Sc | Strategic Information Manager
Strategic Information Unit, US Department of Defense-Walter Reed Program Nigeria
Embassy of the United States of America, Plot 1075 Diplomatic Drive, CBD, 
Abuja, Nigeria
Work: +234-9-461-4000 Ext 4560 | Mobile: +234-805-519-2251 | Email: 
iok...@wrp-n.org
www.hivresearch.org, www.wrp-n.org





___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Switching between data entry formats

[Johan Ivar Sæbø]

Hi,

if I remember correctly, it used to be possible to switch between 
default, section, and custom data entry form while in the data entry 
app. I can't see that this is possible now. Is there a way to do this, 
without affecting all users? Or better, to switch between two custom forms?


Our case is a rather complicated custom (official) form, where we want 
to explore other ways of displaying this for users. The point is that we 
need to keep the official form, and only test alternative layouts for 
specific users. An alternative could be to make another data set with 
the same data elements, but this is messy. Any thoughts, or similar 
experiences?


Johan

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] disappearing apps on demo?

[Johan Ivar Sæbø]

Hi,

how are apps managed on the demo(s)? I've been using the league table 
app on the stable demo for experimentation for some time, but now it is 
suddenly gone. I see there are many more apps on the snapshot demo, but 
not including the league table app


Johan

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] disappearing apps on demo?

[Johan Ivar Sæbø]

On 21.03.2016 14:48, Mark Polak wrote:

I'm not really sure how they are "managed" but someone might simply just
have uninstalled it?

The admin/district user has right to install/uninstall apps. So it's not
a very stable place to store stuff ;)


Is this very smart? Just logged in with admin/district now, and I can 
only see 6 apps (dashboard, gis, pivot, visualizer, mobile light and 
mobile smartphone). Almost everything has been removed since yesterday. 
Isn't this were we showcase DHIS2 to potential users?


Johan

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] New app - League tables

[Johan Ivar Sæbø]

Dear list,

a new app for DHIS2, League Tables, is available here:
https://bitbucket.org/tronerud/league-table-application

League Tables is a web-application customized to create, edit and view 
league tables. It's strictly an analytic tool generating output data, 
from DHIS2. League tables allow you to rank any organizational units 
against a set of indicators you choose. Different weight towards the 
total can be given to the individual indicators selected.


Go to the link for more information, screenshots, downloadable .zip, and 
code.


The app is also availble on the demo server here:
https://play.dhis2.org/demo/api/apps/leagueTableApp/index.html#/tables

It has been piloted in Malawi, and we are grateful for any additional 
feedback for further improvements. It will be available in DHIS2 app 
store soon. The app was developed by Kristoffer Adam Tronerud and Martin 
Theodor Vasbotten.


Regards,
Kristoffer, Martin, and Johan



___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Common requirements for Logistics Management Systems

[Johan Ivar Sæbø]

This document by PATH has a good list of requirements that might be 
reviewed by those working with logistics systems

http://www.path.org/publications/detail.php?i=1865

"This document focuses on a method for producing descriptions, models, 
and figures that accurately represent the views and needs of global 
health professionals. The document can be used by global health 
practitioners to inform software development related to health systems"


Johan

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] HL7 in Botswana

[Johan Ivar Sæbø]

Crizelle,

just for curiosity, is this somehow linked to the old eBHRIMS 
(eBotswanaHIVResponseInfoMngtSystem or something like that) from a few 
years back? It was a local company that was hired by UNAIDS to develop 
such a switchboard, as it was also called then, between CRIS2 and 
DHIS1.4. It was an early stab at interoperability, where the switchboard 
allowed you to navigate between DHIS data entry screens and CRIS 
reports, helping you with the few steps of export/import. Would be 
interesting to hear if this was developed further, or if it has 
influenced the decision to make a new switchboard.


Regards,
Johan

On Wed, 16 Feb 2011 21:30:10 +, Bob Jolliffe 
 wrote:

HL7 is for patient data so we shouldn't need to interface directly
with it.  Possibly they are considering building an aggregation 
filter
in Mirth to produce something like SDMX from the patient data.   
Don't

know.  I am not there to negotiate.

But you need to negotiate hard (on your side of the fence) to ensure
that what comes out of this magic box will be suitable for dhis2
consumption.  That is the way with these kind of switches .. in the
end they are proxies for human negotiation :-)  Much like telephone
switches between phone operators for that matter.

Regards
Bob

On 16 February 2011 21:22, Crizelle Nel  
wrote:

Hi everyone,

In Botswana they are discussing developing a software tool (MIRTH) 
to act as
a switchboard between all health systems. For example if you want to 
export
data from their patient-based system (IPMS) to the DHIS 2 for 
example, you

would use the MIRTH interface to do it. It essentially acts as a
post-office, simply passing the data between different systems.

They would like to use HL7 for MIRTH.

Have any of you done something similar in other countries?

Has anyone used HL7 before?
--
Regards,
Crizelle Nel
Health Information Systems Programme (HISP) Software Development 
Team


Email:  crizelle...@gmail.com
Cell:     084 580 3342
Fax:     0866 509 502
Web:    http://www.hisp.org/



___
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp




___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] HL7 in Botswana

[Johan Ivar Sæbø]

On Thu, 17 Feb 2011 09:53:06 +0200, "Merritt, Scott A." 
 wrote:

Thanks for this Crizelle. In particular, the vision in Botswana is to
have DHIS serve as the repository and visualization tool of record 
for

health data for the foreseeable future. But, as electronic tools roll
out, it would be nice to eliminate the need for data re-entry from
these systems, while allowing for manual entry from the programs and
locations that are not yet electronic. At the same point, as the 
tools
change, we would prefer to have a single common interface via Mirth 
to

DHIS as opposed to creating interfaces for iHRIS, all of our EMR
tools, DisaLab, ETR.net, …. Is anything similar happening elsewhere?
If not, can someone help explain why not?


Dumela,

Regarding a switchboard, I'm not too sure about what's going on around, 
but in slide 13 og this presentation:

http://www.healthunbound.org/sites/default/files/Jorn%20Braa%20-%20HIS%20architecture.pptx

you will find how it is currently envisioned (and implemented) in West 
Africa and other places. DHIS2 serves as a repository and visualization 
tool, and you have the option to either enter data directly, if the 
source is on paper, or to import it. OpenMRS and iHRIS are already 
SDMX-HD compliant, so they can aggregate and send the required data to 
DHIS2 (functionality for importing the definitions from DHIS2 in 
OpenMRS, so it knows what and how to export it is also there). More is 
underway, the logistics system OpenLMIS might implement SDMX-HD soon, 
and I know people behind a lab-system were active in a workshop on the 
standard. So the idea is then that DHIS2 can handle both electronic 
interoperability, and manual data entry, and that manual data entry can 
be phased out whenever some electronic system that supports SDMX-HD is 
in place, just like you're aiming for in Botswana.


For more on this interoperability, there is a nice and short blog here:
http://www.capacityproject.org/hris/blog/index.php/2010/09/his-milestone-reached-health-information-systems-prove-interoperability-success-at-his-unconference-and-training-workshop/

Regards,
Johan



Scott

FROM: Crizelle Nel [mailto:crizelle...@gmail.com]
SENT: Thursday, February 17, 2011 7:07 AM
TO: Knut Staring; Bob Jolliffe; Johan Ivar Sæbø
CC: Merritt, Scott A.; Kabelo Bitsang; Phumzile Khumalo; Chris
Seebregts; dhis2-devs@lists.launchpad.net
SUBJECT: Re: [Dhis2-devs] HL7 in Botswana

Thanks for your responses Bob, Knut and Johan.

I have not yet had the opportunity to properly discuss this
development with anyone (I just had a quick telephone call with Scott
Merrit from BUTUSA earlier in the week).

What I can tell you though is that the Tecnhical Work Group in
Botswana (which comprises of key staff from MoH, Local Government,
I-Tech, BUTUSA and more) is absolutely committed to the DHIS. The
long-term plan in Botswana is to interface all applicable systems
(i.e. IPMS, ETR.Net, iHRIS etc.) with the DHIS so that the DHIS acts
as an integrator.

I have a meeting with Scott this afternoon and just wanted to gather
as much information as possible beforehand.

I'll be sure to obtain answers to the questions you posed and to get
back to you with Scott's responses.

Regards,

Crizelle

On Wed, Feb 16, 2011 at 11:49 PM, Knut Staring  wrote:

This was actually the approach taken by a team in South Africa in 
2008

and early 2009 to link OpenMRS and DHIS2, though I don't think it was
put in production.

Knut

On Wed, Feb 16, 2011 at 10:30 PM, Bob Jolliffe  wrote:

HL7 is for patient data so we shouldn't need to interface directly
with it. Possibly they are considering building an aggregation

filter

in Mirth to produce something like SDMX from the patient data. Don't
know. I am not there to negotiate.

But you need to negotiate hard (on your side of the fence) to ensure
that what comes out of this magic box will be suitable for dhis2
consumption. That is the way with these kind of switches .. in the
end they are proxies for human negotiation :-) Much like telephone
switches between phone operators for that matter.

Regards
Bob

On 16 February 2011 21:22, Crizelle Nel  wrote:

Hi everyone,

In Botswana they are discussing developing a software tool (MIRTH)

to act as

a switchboard between all health systems. For example if you want

to export

data from their patient-based system (IPMS) to the DHIS 2 for

example, you

would use the MIRTH interface to do it. It essentially acts as a
post-office, simply passing the data between different systems.

They would like to use HL7 for MIRTH.

Have any of you done something similar in other countries?

Has anyone used HL7 before?
--
Regards,
Crizelle Nel
Health Information Systems Programme (HISP) Software Development

Team


Email: crizelle...@gmail.com [4]
Cell: 084 580 3342
Fax: 0866 509 502
Web: http://www.hisp.org/ [5]



___
Mailing list: https://launchpad.net/~dhis2-de

Re: [Dhis2-devs] [Dhis2-users] Calculated variables

[Johan Ivar Sæbø]

Roger,

On Wed, 27 Apr 2011 08:22:46 -0400, "Friedman, Roger (CDC/CGH/DGHA) 
(CTR)"  wrote:

OK, we have two more use cases of calculated variables. 

At present certain information is collected by diagnosis from the
inpatient and outpatient clinics.  The malaria information is copied
to the malaria form, along with other information which does have to
be entered.  We want to enter this information only once, from the
diagnosis records, but we want it to show up on the malaria form, we
think it's marginally acceptable to not show totals, but to not show
the malaria people "their" data is bad customer relations.


As I understand the case, this can be done by including the same data 
elements, like "Malaria xyz", in both data sets. This is what we did in 
Sierra Leone, where some forms had an data element overlap of 25%+. Data 
entered in for example "Malaria <1 male" in one form would then show up 
when you opened the data entry screen for the same month and clinic for 
the "twin-form". I believe the same can be done when you have calculated 
data elements. Making a calculated element visible in the data entry 
screen would be possible by assigning it to a cell in a custom form, 
while the sub-elements can be hidden by not assigning them. Using a 
standard form would all the elements visible.



The clinics keep daily logs of birth control products dispensed, for
which the patients pay at a reduced rate.  This form is turned in
along with the cash receipts, serving as a financial control.  It
needs receipts by item (quantity x price) and total.

I think it would be good enough if the calculated variables were not
stored or aggregated and only existed while the dataset form was 
being

displayed, for input or as a  report.  It would also be reasonable
to limit variables in the calculations to those in the dataset (so in
the malaria case, the variable would be in the dataset, it would not
appear on the form, only the calculated variable equal to its value).

Our users exist in a form-based world, where the form designers do 
not

necessarily think systematically. 


This is very typical, and the change from paper-logic to computer-logic 
is a long process. Subtotals, double entry, and huge tables are typical 
for paper forms. Unfortunately, since paper come in fixed sizes, they 
are populated so that all free space is used. Automatically populating 
different forms by sharing the same data elements was used in Sierra 
Leone as a first step to highlight the possibilities of computer-based 
data entry and storage, and has since led to a certain degree of 
harmonization of the forms.


Regards,
Johan

 Where we can make a closer

correspondence between the form and data entry/printing, we add to
their comfort with the system.  While I may think the forms they are
using are don't make informatic sense, and that differences in
rendering call for different strategies on screens than on paper, I
can't impose these changes on them.  Cross-foot totals do contribute
to accuracy in manual forms, they don't in computer forms; double
entry accounting contributes to accuracy in manual bookkeeping, it
doesn't in computer bookkeeping; but the habits of generations don't
change in a day.



___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] User manual + Help contents

[Johan Ivar Sæbø]

Lars,
I am to meet a technical writer on tuesday to discuss terms of
references for documentation. HMN will pay. Why dont you come? There
are some issues we should sort out, like "FOSS" design, so we can
easily add things ourselves later, and of course some thinking about
how we can keep track of versions in different languages.
Johan

Lars Helge Øverland wrote:

Hi,
  
there has been lots of talk about from various people why we should
have and need a user manual. Yet no action has been taken, except from
the Indian team who has made a good document which could be used as a
starting point for a "global" manual. 
  
Is there anyone out there that feel like contributing and actually do
some work here? Don't worry to much about formats, sharing etc, we can
simply start with a word / odf document and put it in launchpad. I am
happy to help out here.
  
Also, we do have a easy-help solution in place in DHIS 2 which needs to
be populated with meaningful and informative help messages. If anyone
feel like contributing I will help with the details.
  
cheers,
  
Lars
  
  

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp
  





___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] User manual + Help contents

[Johan Ivar Sæbø]

Bob Jolliffe wrote:

  Hi Johan

2009/5/1 Johan Ivar Sæbø :
  
  
Lars,
I am to meet a technical writer on tuesday to discuss terms of references
for documentation. HMN will pay. Why dont you come? There are some issues we
should sort out, like "FOSS" design,

  
  
I think we should agree in principle on an appropriate copyright
licence prior to engaging writers - given the need for translation et
al, I would suggest that a creative-commons attribution only licence
would be appropriate.

  

These are the things I would like to discuss, but of which I know very
little. Anyway, though HMN is willing to pay to improve the product
they're using in Sierra Leone, they don't want to own the
documentation. So any advice on licence we can put on it, which I guess
will be on the same entity as the software (U. of Oslo), will be
appreciated.


  I guess the other issue you are touching on is "source code" ... what
do you proposes?

  

It must be written on some open platform, and if the output is a pdf
(maybe generated from some wiki-like tool), we should also have the
plain text and be able to do whatever we want with it (change
screenshots, text, etc etc)
Johan



  Regards
Bob

  
  
so we can easily add things ourselves
later, and of course some thinking about how we can keep track of versions
in different languages.
Johan

Lars Helge Øverland wrote:

Hi,

there has been lots of talk about from various people why we should have and
need a user manual. Yet no action has been taken, except from the Indian
team who has made a good document which could be used as a starting point
for a "global" manual.

Is there anyone out there that feel like contributing and actually do some
work here? Don't worry to much about formats, sharing etc, we can simply
start with a word / odf document and put it in launchpad. I am happy to help
out here.

Also, we do have a easy-help solution in place in DHIS 2 which needs to be
populated with meaningful and informative help messages. If anyone feel like
contributing I will help with the details.

cheers,

Lars


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



  





___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Bug 370791] [NEW] orgunitname uniqueness should only be among siblings

[Johan Ivar Sæbø]

While it might not be necessary to use a prefix, it is GOOD PRACTICE.
For one not living in the databasee world, I usually encounter the OU
names in reports, or pivot tables. In a pivot table, filtering a pivot
field is hopeless with duplicates instead of prefixes...

Suppose you want to list a few facilities, and that the district they
are in contain other facilities you don't want to see. This is quite a
common situation. Then you would have to filter the "facility" field,
which will show ALL facilities, thus your list might look like this
(also quite typical, in for instance Sierra Leone)

...
Red Cross Clinic
Red Cross Clinic
Red Cross Clinic
...

instead of
...
BO Red Cross Clinic
BM Red Cross Clinic
WA Red Cross Clinic
...

Just my five cents.. If you're making a H1N1 A (well, I will still call
it swine flu) database covering the whole world, maybe a postfix would
be better, if it turns out to be a long string...also easier for sorting
Johan


Jason Pickering wrote:

  Hi Ola,

I am sitting here with Knut, and I am going to support him on this
one. :) The actual "real" relationship should be as Knut states. There
are many Pickens Counties in the USA, but only one in Georgia (my home
town).

The prefix method has been implemented in Zambia, but I would regard
this as very messy as well, particularly since it does not actually
reflect the actual name of the orgunit. I would really regard this
more of a kludge than anything else. In the reports that I have
created in Zambia, we have trimmed out the two characters, as they
make the reports messy.



  
  
Orgunit hierarchy is not referenced from the data values so the
proposed change would easily cause problems when dealing with the data.


  
  
What does this mean? Every value is referenced to an orgunitid ?

In my opinion, we should try and model the actual physical world.
Generally, there are never duplicates of an orgunit within a
particular parent. There are Oslo's in both Norway and Peru, but they
are unique within their own hierarchy. The constraint should be that
for any given parentid, the names of orgunits should be unique. I am
not sure why this will result in a messy database, but at the present,
the database and its constraints simply do not reflect reality.

Regards,
Jason

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp
>From - Sat
  





___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] update regarding documentation

[Johan Ivar Sæbø]

Hello all,
I've now discussed a possible contract (paid by HMN) with a technical 
writer here in Geneva. In addition to being very impressed by the 
flexibility of DHIS and the reasoning behind it, he expressed interest 
in working with this. I will now follow up internally here in HMN, but 
want to keep you updated on the progress.


We discussed if not a wiki-approach would be appropriate, where defining 
the structure (based on ToC) of the manual would be first step. He could 
then work on his preferred platform (word), and it could then be fed 
into different sections. For this, we would have a good framework for a) 
several languages (just do like wikipedia), and b) open, easy for us to 
add more stuff ourselves later.


There are supposed to be some tools for converting wikipages to pdf 
docs, which would be very useful if we go for this solution. Then, with 
a click of a button, you would get the manual based on the latest wiki 
content. We already have plenty of wikis to use for this purpose


Any comments appreciated.
Johan

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Improving min/max functionality

[Johan Ivar Sæbø]

Ola Hodne Titlestad wrote:
Hi,
I've added a new blueprint here:
  https://blueprints.launchpad.net/dhis2/+spec/improve-minmax-value-functionality
  
-which is about improving the min/max validation functionality. The
current solution is very basic and not sufficient in many ways. Here
are my thoughts on how to improve this. We can use this list for
discussion and then update the blueprint when we settle on something
concrete. 
  
This is what I wrote in the blueprint:
  
A few improvements are needed to the min/max value functionality:
  1) Generation of min/max values should be available from the data
administration module
Currently you need to generate min/max ranges for each orgunit/dataset
combination one by one in the data entry module. Sometimes you want to
generate ranges for all orgunits and datasets at once and then data
entry is not the place for this. In Data Administration we can add a
new menu heading called "Min/MAx validation" and in there we can allow
min/max generation for any combination of orgunit/dataset, and easily
allow all combinations to be selected. Maybe also a good idea to
include a "from" and "to" field to indicate which periods to use as the
basis for the generation, e.g. from 2008-01-01 to 2008-12-31 would
indicate that all 12 months of 2008 will be used if the dataset has
monthly period type, or the 4 quarters of 2008 will be used if
quarterly dataset etc.

Not sure which is the best way to do this, but one way could be to have
"Data quality" as an item under maintenance, where you can set ranges,
and also define and keep track of validation rules. Then, the "data
quality" page currently under services could be split, so that you take
the definition-side of it to maintenance, and the report-side of it as
a subitem in the reports menu.

  2) User defined parameters that control how the generation is
done.
Currently the range values are set to 10% lower than the lowest value
and 10% higher than the highest value, which is a very crude method.
This does not take care of outliers that might already be in the system.
any suggestions for a better statistical method for this? And on how to
make it user defined?

Use some factor of standard deviation. That will take care of spread.
+/- 10 % will not work for malaria, for instance, as it fluctuates
naturally over the year, due to rainy season. I don't have here my copy
of the infamous "Statistical concepts and methods" by Bhattacharyya and
Johnson, arguably the most boring book in the world, but this would do
for an explanation: http://en.wikipedia.org/wiki/Standard_deviation.

Then, as I think it is in DHIS 1.4, you can set the factor to calculate
from, for instance 1.5, making the min and max the mean - 1.5 x st.dev
and the mean + 1.5 x st.dev, respectively.


  3) I assume we would like to keep the generate min/max option in
data entry which can be useful for users that do not deal with all, but
just a limited number of orgunits and know that a new round of
generation would correct the min/max ranges. But thsi generation should
then be configured in a setting, especially how many periods to use. So
we could add another property in Data Administration->min/max
validation that defines how many periods to use as basis for the
generation, for monthly, weekly, yearly etc. period types. Do we need
one property per period type? Currently this property is hard-coded to
6 in the source code.
  4) Default min/max range per data element
Normally a min/max range is linked to an orgunit/dataelement
combination, but sometimes, e.g when there is very little data or very
poor data quality in the system it is useful to have a default range
that can be used for all orgunits as a first level of validation to
avoid typos and crazy outliers. These default values need to be set
somewhere, and maybe data set management is the best suited place for
this, at least that is where it is located in DHIS 1.4. Here we need
some functionality to quickly set these ranges, even as quick as
setting the same range for all data elements in a dataset, and then
also the possibility to adjust individual data elements in the data
(set) element list.
In Data entry the procedure will be to first check whether a min/max
range exists for the orgunit/data element (the best option) and if not
then load the default range for the data element (the next best
option), and if nothing is set then leave it blank (the worst option).

I concur. In both Sierra Leone and Botswana, setting ranges for
individual facilities, for all data elements, has just created a lot of
extra work for the districts, which are not really aware of how the
process works. So this has so far been skipped in Sierra Leone. As we
want some kind of warning (colour coding and/or pop-ups), this can
create a great deal of frustration until the ranges are correctly set,
and also there are some wild typos where it looks like people have
fallen asleep on the keyboard, which we want to avoid. It would then
make sense

Re: [Dhis2-devs] [Dhis2-users] DHIS2 as LMIS

[Johan Ivar Sæbø]

Hi,

DHIS can support LMIS in a number of ways. My experience is that there 
are few, if any, specialized LMIS software that fits all needs and 
circumstances, and that DHIS can play a useful role here. Like William 
says, it is possible to use the Tracker module to literally track 
commodities. This is sometimes needed for the supply chain, to make sure 
the right commodities reach the right place, and keep track of 
additional data related to each item (expiry date, driver/vehicle etc). 
However, for most facilities, the main functionality of LMIS is to keep 
a regular inventory, from which you can have either a pull (facilities 
order needed commodities) or push (higher levels determine amount to be 
distributed) system. For this, the regular, routine reporting of DHIS is 
very suitable. I know it is used for both very simple monthly reporting 
of stock-outs (a yes/no question), and a more comprehensive inventory 
list of "start balance", "dispensed", "wasted", "requisition", etc. The 
benefit of using DHIS for this is that is it is online and simple to use 
if users are already familiar with it, and it does not need additional 
infrastructure. This applies to both facility users and those in charge 
of setting up and maintaining the system. At national level warehouses, 
the requirements are typically much wider, such as related to finances, 
distribution management etc, but the available software solutions here 
are both expensive and complex. It is thus common to support an LMIS 
with both a "heavy" warehouse software and a "light" inventory software. 
If DHIS is already established in a country, I would recommend using 
this for the "light" facility reporting, from which the national 
warehouse can get the routine requisitions and keep track of wastage and 
stock-out rates.


Mind that there are many more arguments for and against, and many local 
constellations of systems and organizations. But my short answer would 
be that DHIS is very well suited for facility inventory reporting, from 
which both requisition/ordering and management indicators can be 
derived. With some more information on what is needed, I'm sure we will 
be able to give clearer advice on how to set it up.


Regards,
Johan


On 17.06.2015 12:01, Ouango william wrote:

Hi Gerald,
What I’m saying is that DHIS2 is an optimized a data reporting tool , 
it can be used to track inventory of some drugs through its tracker 
module, but it is not optimized if you want to manage all your drugs. 
You can use it to track some drugs stocks but not a very large amount 
of products and you can’t know your stock intantly,
Regarding medication management (For exemple these operation like 
selling directly products to persons for example, making a stock 
transfer to another facility, making inventory and adjustment of your 
inventory... ), it is difficult to do in my opinion.
The alternative you have, is just to use software optimized on drugs 
stock managements and then make a bridge with DHIS2. In BURKINA FASO, 
we use a software named CHANNEL2 to manage our drugs and DHIS2 for 
reporting,aggregating data, making chart or using pivot module. Our 
team is working on a solution to brige easily the two software.


William N. D. OUANGO
Analyste Programmeur
  DSITS


(00226) 79 33 83 84
72 00 31 22
66 85 28 18




Le Mercredi 17 juin 2015 8h36, gerald thomas  a 
écrit :



Dear all,
I am interested in the topic and I can't read or speak French. Please 
can someone translate.

Regards,
Gerald
On 17 Jun 2015 08:34, "Ouango william" > wrote:


Bonjour Narodar,
 je vois que tu as des questions sur DHIS2, pour ce qui concerne
tes questions, saches que DHIS2 est d'abord un outil de rapportage
des données, il peut être utilisé pour le suivi des stocks de
certains produits à travers son module tracker, mais ce n'est pas
optimisé. Tu peux l'utiliser pour le suivi des produits traceurs
par exemple mais pas d'une très grande quantité de produits,
Pour ce qui concerne la gestion des médicaments (achat vente au
client par exemple, transfert de stock, inventaire et ajustement
de stock...), il est difficile de le faire à mon avis.
L'alternative que tu as, c'est tout simplement l'utilisation de
logiciels de gestions de stock des médicaments et la mise en place
d'un pont qui permette de les mettre sur DHIS2 (Exemple gestion de
stock = CHANNEL, Outil d'aide à la décision=DHIS2) et tu les relie
de sorte à ce que les données de CHANNEL alimentent directement la
base de données de DHIS2. Ainsi, tu verra  la puissance de DHIS2.

William N. D. OUANGO
Analyste Programmeur
  DSITS


(00226) 79 33 83 84
72 00 31 22
66 85 28 18




Le Mercredi 17 juin 2015 8h26, Ouango william
mailto:williamoua...@yahoo.fr>> a écrit :


Bonjour Narodar,

Re: [Dhis2-devs] [Dhis2-users] DHIS2 as LMIS

[Johan Ivar Sæbø]

Hi Lamin,

I know they have been working on SMS reporting on out of stock in 
Nigeria, but not sure if alerts are part of it. Maybe someone from 
Nigeria can add more about what they are doing? I think it would be 
interesting for a lot of people on the list.


Johan

On 20.06.2015 00:15, Lamin Jawara wrote:

Hi Johan,

This is great in tracking LMIS commodities using DHIS, Is it also
possible to have an sms alert if you are out of stock using the tracker ?

Regards,
*Lamin B. Jawara *
*Ministry of Health & Social Welfare
Tel: +220 9907404 / 7229017
Email: lbjaw...@yahoo.com <mailto:lbjaw...@yahoo.com>*
*Web: http://lbjawara.wordpress.com <http://lbjawara.wordpress.com/>*



On Friday, June 19, 2015 11:40 AM, Johan Ivar Sæbø 
wrote:


Hi,

DHIS can support LMIS in a number of ways. My experience is that there
are few, if any, specialized LMIS software that fits all needs and
circumstances, and that DHIS can play a useful role here. Like William
says, it is possible to use the Tracker module to literally track
commodities. This is sometimes needed for the supply chain, to make sure
the right commodities reach the right place, and keep track of
additional data related to each item (expiry date, driver/vehicle etc).
However, for most facilities, the main functionality of LMIS is to keep
a regular inventory, from which you can have either a pull (facilities
order needed commodities) or push (higher levels determine amount to be
distributed) system. For this, the regular, routine reporting of DHIS is
very suitable. I know it is used for both very simple monthly reporting
of stock-outs (a yes/no question), and a more comprehensive inventory
list of "start balance", "dispensed", "wasted", "requisition", etc. The
benefit of using DHIS for this is that is it is online and simple to use
if users are already familiar with it, and it does not need additional
infrastructure. This applies to both facility users and those in charge
of setting up and maintaining the system. At national level warehouses,
the requirements are typically much wider, such as related to finances,
distribution management etc, but the available software solutions here
are both expensive and complex. It is thus common to support an LMIS
with both a "heavy" warehouse software and a "light" inventory software.
If DHIS is already established in a country, I would recommend using
this for the "light" facility reporting, from which the national
warehouse can get the routine requisitions and keep track of wastage and
stock-out rates.

Mind that there are many more arguments for and against, and many local
constellations of systems and organizations. But my short answer would
be that DHIS is very well suited for facility inventory reporting, from
which both requisition/ordering and management indicators can be
derived. With some more information on what is needed, I'm sure we will
be able to give clearer advice on how to set it up.

Regards,
Johan


On 17.06.2015 12:01, Ouango william wrote:
Hi Gerald,
What I’m saying is that DHIS2 is an optimized a data reporting tool , it
can be used to track inventory of some drugs through its tracker module,
but it is not optimized if you want to manage all your drugs. You can
use it to track some drugs stocks but not a very large amount of
products and you can’t know your stock intantly,
Regarding medication management (For exemple these operation like
selling directly products to persons for example, making a stock
transfer to another facility, making inventory and adjustment of your
inventory... ), it is difficult to do in my opinion.
The alternative you have, is just to use software optimized on drugs
stock managements and then make a bridge with DHIS2. In BURKINA FASO, we
use a software named CHANNEL2 to manage our drugs and DHIS2 for
reporting,aggregating data, making chart or using pivot module. Our team
is working on a solution to brige easily the two software.

William N. D. OUANGO
Analyste Programmeur
   DSITS


(00226) 79 33 83 84
 72 00 31 22
 66 85 28 18




Le Mercredi 17 juin 2015 8h36, gerald thomas 
<mailto:gerald17...@gmail.com> a écrit :


Dear all,
I am interested in the topic and I can't read or speak French. Please
can someone translate.
Regards,
Gerald
On 17 Jun 2015 08:34, "Ouango william" mailto:williamoua...@yahoo.fr>> wrote:

Bonjour Narodar,
  je vois que tu as des questions sur DHIS2, pour ce qui concerne
tes questions, saches que DHIS2 est d'abord un outil de rapportage
des données, il peut être utilisé pour le suivi des stocks de
certains produits à travers son module tracker, mais ce n'est pas
optimisé. Tu peux l'utiliser pour le suivi des produits traceurs par
exemple mais pas d'une très grande quantité de produits,
Pour ce qui concerne la gestion des médic

Re: [Dhis2-devs] Exporting Indicators from the DHIS 2 Demo to my Instance

[Johan Ivar Sæbø]

Hi Gerald,

For making formulae with constants, you can just enter these figures in 
the texbox "Formula" in the numerator and denominator boxes of the 
indicators.


More here, info on constants at the bottom:

https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html

I would not put something like expected pregnancies as a constant 
though, but rather as a data element. Then the indicator using that data 
element in the formula would be valid for all organization units you 
have the number of expected pregnancies for. If you only have the 
national figure, it would still be better to make a data element rather 
than a constant, as you would get missing figures for districts or lower 
rather than very wrong indicator values. Typically you would have a 
"population figures" dataset with such figures (age group populations, 
expected pregnancies, etc), set for annual data "collection" (in most 
cases meaning calculation based on previous estimates/census and growth 
rates).


Johan


On 27.10.2015 12:48, gerald thomas wrote:

Dear All,
How can I insert "Constant" for indicator calculation. For example
Expected Pregnancies = 243 951 in the Demo Instance or Pi

On 10/27/15, gerald thomas  wrote:

Dear All,
I am finding it hard to create indicators on my local instance because
when i did pivot there is no output. Is there any way i can export and
import indicators from the Demo instance to my local instance.

Please help.

--
Regards,

Gerald







___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Getting timeliness rates?

[Johan Ivar Sæbø]

Hi,

we are working on a league table/scorecard app, and manage to get 
indicators and completeness rates into it. However, users also want to 
be able to use the timeliness rates. We don't see them in the pivot 
tables either, so not much help in looking at how that is done there. 
How can we get this information?


Johan

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp