Re: [Dhis2-devs] Dashboard Development

2018-03-12 Thread Alex Tumwesigye
Hi Olaleke,

We have done some dashboard apps which supports a dhis2 master facility.
Highly customizable.

Please visit https://dhis2.jsi.com/dhis2mfr

If it interests you, you can reach me.

Alex

On Monday, March 12, 2018, J. Paul Mutali  wrote:

> Hi Leke,
>
> you can get more information on how to create an app with DHIS by
> enrolling to this DHIS2 Web Apps Development course: https://training.
> dhis2.org/course/view.php?id=91
>
>
> But for a quick one as others suggested you can try the dashboard app in
> 2.29 or the Interactive web portal app from the App Store.
>
> Hope that will be helpful.
>
>
>
> On Sun, Mar 11, 2018 at 11:42 PM, Olaleke Seweje 
> wrote:
>
>> Hi All,
>>
>>
>> I have just started using DHIS and I want to develop a dashboard based on
>> DHIS2 data, something like https://data.pepfar.net/. Notice that the
>> dashboard does not have the usual DHIS look and feel.
>>
>>
>> I have been told that DHIS has a built in facility for doing this but I
>> have not come across it in the DHIS documentation or any training materials.
>>
>>
>> I need advise on how I can go about this please. Any helpful
>> documentation or training materials that can help with this will be
>> appreciated as well.
>>
>>
>> Thanks all.
>>
>>
>> --
>> Regards,
>> Leke Seweje
>>
>> ___
>> 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
>>
>>
>
> *-*
>
> *JEAN PAUL MUTALI*
>
> HISP Rwanda
>
> KG 113 St, Kigali- Rwanda
>
>
>
>

-- 
Alex Tumwesigye

Kampala
Uganda
+256 774149 775, + 256 759 800161
Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems -
DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant


"I don't want to be anything other than what I have been - one tree hill "
___
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] URGENT: Data capture and Maintenance org units Access

2018-03-12 Thread Ocaya Stephen
Hi Georgi, The other workable option where U dont have direct access to
database is use the DHIS2 WebAPI

Georgi, Since the account is a superuser, you could use the WebAPI to
create a new Superuser and allocate to the Main parent orgunit using the
payloads below:-


For this to work properly (currently) you need to generate an ID
(/api/system/id) and then modify the payload like this:

{
  "id": "generated-id",
  "firstName": "John",
  "surname": "Doe",
  "email": "john...@mail.com",
  "userCredentials": {
"userInfo": { "id": "generated-id" },
"username": "johndoe",
"password": "your-password-123",
"userRoles": [ {
  "id": "Euq3XfEIEbx"
} ]
  },
  "organisationUnits": [ {
"id": "ImspTQPwCqd"
  } ],
  "userGroups": [ {
"id": "vAvEltyXGbD"
  } ]
}

generated-id should be generated using /api/system/id (WebAPI)

Then, Use Curl to Create the user. Once done, Login and Update your account
as usual using users App

curl -X POST -u user:pass -d @u.json -H "Content-Type:
application/json" http://server/api/24/users





On Mon, Mar 12, 2018 at 8:47 PM, Knut Staring  wrote:

> Ok...and you cannot just revert to the dump? Or the dump has the same
> problem?
>
> In any case, since you have a dump which you can experiment with (pls note
> that I have not tested this procedure thoroughly, and you might get more
> than one answer if you have more than one root or more than one superuser):
>
> In any case, you should be able to do this in three steps - first finding
> the root OU and then your user:
>
> 1) SELECT organisationunitid, name FROM organisationunit where parentid is
> null; LET'S SAY THE ANSWER IS 18
> 2) SELECT userid from userrole where name='Superuser'; LET'S SAY THE
> ANSWER IS 32
>
> Given those values, you should be able to do this:
>
> 3) UPDATE usermembership SET organisationunitid = 18 WHERE userinfoid = 32;
>
> On Mon, Mar 12, 2018 at 6:21 PM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
>
>> We got a database dump.
>>
>>
>>
>> *From:* Knut Staring [mailto:knu...@gmail.com]
>> *Sent:* Monday, March 12, 2018 7:07 PM
>> *To:* Georgi Chakarov 
>> *Cc:* DHIS 2 developers ; DHIS 2 Users
>> list 
>> *Subject:* Re: [Dhis2-devs] URGENT: Data capture and Maintenance org
>> units Access
>>
>>
>>
>> Do you have direct access to the database?
>>
>>
>>
>> On Mon, Mar 12, 2018, 17:47 Georgi Chakarov 
>> wrote:
>>
>> Hello all,
>>
>>
>>
>> For some testing purpose, I gave my superuser access to ONE org unit at
>> the lowest level. Now, I and (*all other users*) see only this org unit
>> for all data entry and maintenance apps, which is a bit strange.
>>
>> Does anyone know how do I regain access to the entire org unit tree again?
>>
>>
>>
>>
>>
>>
>>
>>
>> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104
>> <(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation, 720
>> Bathurst Street, Toronto Canada M5S 2R4
>> 
>> | *You may unsubscribe from receiving commercial electronic messages
>> from LogicalOutcomes by emailing **i...@logicaloutcomes.net*
>> 
>>
>>
>>
>> ___
>> 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
>>
>>
>
>
> --
> Knut Staring
>
> Department of Information, Evidence and Research
> World Health Organization, Geneva, Switzerland
> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
> Skype: knutstar
>
> ___
> 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
>
>


-- 
--
*Stephen Ocaya*
Tel: +256 393 217 892 | Mob: +256774558980
www.stephocay.com
SkypeID: stephocay
___
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] URGENT: Data capture and Maintenance org units Access

2018-03-12 Thread Knut Staring
Ok...and you cannot just revert to the dump? Or the dump has the same
problem?

In any case, since you have a dump which you can experiment with (pls note
that I have not tested this procedure thoroughly, and you might get more
than one answer if you have more than one root or more than one superuser):

In any case, you should be able to do this in three steps - first finding
the root OU and then your user:

1) SELECT organisationunitid, name FROM organisationunit where parentid is
null; LET'S SAY THE ANSWER IS 18
2) SELECT userid from userrole where name='Superuser'; LET'S SAY THE ANSWER
IS 32

Given those values, you should be able to do this:

3) UPDATE usermembership SET organisationunitid = 18 WHERE userinfoid = 32;

On Mon, Mar 12, 2018 at 6:21 PM, Georgi Chakarov  wrote:

> We got a database dump.
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* Monday, March 12, 2018 7:07 PM
> *To:* Georgi Chakarov 
> *Cc:* DHIS 2 developers ; DHIS 2 Users
> list 
> *Subject:* Re: [Dhis2-devs] URGENT: Data capture and Maintenance org
> units Access
>
>
>
> Do you have direct access to the database?
>
>
>
> On Mon, Mar 12, 2018, 17:47 Georgi Chakarov 
> wrote:
>
> Hello all,
>
>
>
> For some testing purpose, I gave my superuser access to ONE org unit at
> the lowest level. Now, I and (*all other users*) see only this org unit
> for all data entry and maintenance apps, which is a bit strange.
>
> Does anyone know how do I regain access to the entire org unit tree again?
>
>
>
>
>
>
>
>
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104
> <(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation, 720
> Bathurst Street, Toronto Canada M5S 2R4
> 
> | *You may unsubscribe from receiving commercial electronic messages from
> LogicalOutcomes by emailing **i...@logicaloutcomes.net*
> 
>
>
>
> ___
> 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
>
>


-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
<+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
Skype: knutstar
___
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] URGENT: Data capture and Maintenance org units Access

2018-03-12 Thread Georgi Chakarov
We got a database dump.

From: Knut Staring [mailto:knu...@gmail.com]
Sent: Monday, March 12, 2018 7:07 PM
To: Georgi Chakarov 
Cc: DHIS 2 developers ; DHIS 2 Users list 

Subject: Re: [Dhis2-devs] URGENT: Data capture and Maintenance org units Access

Do you have direct access to the database?

On Mon, Mar 12, 2018, 17:47 Georgi Chakarov 
> wrote:
Hello all,

For some testing purpose, I gave my superuser access to ONE org unit at the 
lowest level. Now, I and (all other users) see only this org unit for all data 
entry and maintenance apps, which is a bit strange.
Does anyone know how do I regain access to the entire org unit tree again?


[cid:image003.png@01D3BA32.86CFC1D0]


Georgi Chakarov, CIA | 
geo...@logicaloutcomes.net | +1-647-478-5634 
x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, 
Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial 
electronic messages from LogicalOutcomes by emailing 
i...@logicaloutcomes.net

___
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] URGENT: Data capture and Maintenance org units Access

2018-03-12 Thread Knut Staring
Do you have direct access to the database?

On Mon, Mar 12, 2018, 17:47 Georgi Chakarov 
wrote:

> Hello all,
>
>
>
> For some testing purpose, I gave my superuser access to ONE org unit at
> the lowest level. Now, I and (*all other users*) see only this org unit
> for all data entry and maintenance apps, which is a bit strange.
>
> Does anyone know how do I regain access to the entire org unit tree again?
>
>
>
>
>
>
>
>
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x
> 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst
> Street, Toronto Canada M5S 2R4 | *You may unsubscribe from receiving
> commercial electronic messages from LogicalOutcomes by emailing *
> *i...@logicaloutcomes.net* 
>
>
> ___
> 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


[Dhis2-devs] URGENT: Data capture and Maintenance org units Access

2018-03-12 Thread Georgi Chakarov
Hello all,

For some testing purpose, I gave my superuser access to ONE org unit at the 
lowest level. Now, I and (all other users) see only this org unit for all data 
entry and maintenance apps, which is a bit strange.
Does anyone know how do I regain access to the entire org unit tree again?


[cid:image003.png@01D3BA32.86CFC1D0]


Georgi Chakarov, CIA | 
geo...@logicaloutcomes.net | +1-647-478-5634 
x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, 
Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial 
electronic messages from LogicalOutcomes by emailing 
i...@logicaloutcomes.net

___
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] Dashboard Development

2018-03-12 Thread J. Paul Mutali
Hi Leke,

you can get more information on how to create an app with DHIS by enrolling
to this DHIS2 Web Apps Development course:
https://training.dhis2.org/course/view.php?id=91


But for a quick one as others suggested you can try the dashboard app in
2.29 or the Interactive web portal app from the App Store.

Hope that will be helpful.



On Sun, Mar 11, 2018 at 11:42 PM, Olaleke Seweje 
wrote:

> Hi All,
>
>
> I have just started using DHIS and I want to develop a dashboard based on
> DHIS2 data, something like https://data.pepfar.net/. Notice that the
> dashboard does not have the usual DHIS look and feel.
>
>
> I have been told that DHIS has a built in facility for doing this but I
> have not come across it in the DHIS documentation or any training materials.
>
>
> I need advise on how I can go about this please. Any helpful documentation
> or training materials that can help with this will be appreciated as well.
>
>
> Thanks all.
>
>
> --
> Regards,
> Leke Seweje
>
> ___
> 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
>
>

*-*

*JEAN PAUL MUTALI*

HISP Rwanda

KG 113 St, Kigali- Rwanda
___
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] Dashboard Development

2018-03-12 Thread Calle Hedberg
Hi,

PEPFAR is using DHIS2 as their database platform. BUT they are also using a
lot of other tools on top of that for analysis, reporting, and display.

DHIS 2.29, released last week, has some significant improvements to what
had become a somewhat stale/static dashboard design - I would check that
out before considering apps and the like (lots of work to develop those)

Regards
Calle

On 12 March 2018 at 08:47, Edouard Lavaud  wrote:

> Hi Leke-Seweje,
>
>
> To my knowledge, pepfar is not using DHIS2 (are they??).
> If you want to change the look of the dashboards, I see three
> possibilities, ranked from easiest to hardest:
>
>- You create a DHIS2 app
>. In that
>case you only do some front-end development and use the API
> to
>manipulate the data.
>- You create the entire website (front and back end) and use the API
> to
>manipulate the data.
>- You "fork " DHIS2 and create
>your own layout. Note that then you would have to merge back all the new
>bugs fix and features.
>
> If not already done, I would advise to first get a dashboard with the
> already existing DHIS2 layout before thinking to switch to a new one.
>
>
> Best,
>
>
> Edouard
>
> PS: Myself still a newbie with DHIS2. Maybe some other people in this list
> have better advices.
>
> 2018-03-11 23:42 GMT+02:00 Olaleke Seweje :
>
>> Hi All,
>>
>>
>> I have just started using DHIS and I want to develop a dashboard based on
>> DHIS2 data, something like https://data.pepfar.net/. Notice that the
>> dashboard does not have the usual DHIS look and feel.
>>
>>
>> I have been told that DHIS has a built in facility for doing this but I
>> have not come across it in the DHIS documentation or any training materials.
>>
>>
>> I need advise on how I can go about this please. Any helpful
>> documentation or training materials that can help with this will be
>> appreciated as well.
>>
>>
>> Thanks all.
>>
>>
>> --
>> Regards,
>> Leke Seweje
>>
>> ___
>> 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
>>
>>
>
>
> --
> *Edouard Lavaud, *
>
>
>
> *MSc in Health Policy, Planning & FinancingMEng in
> TelecommunicationUniversity Diploma in ICT for Health*
> *Email:* edouard.lav...@gmail.com
> *Mobile:* 0033 6 7210 23 59
>
>
> ___
> 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
>
>


-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***
___
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] Dashboard Development

2018-03-12 Thread Edouard Lavaud
Hi Leke-Seweje,


To my knowledge, pepfar is not using DHIS2 (are they??).
If you want to change the look of the dashboards, I see three
possibilities, ranked from easiest to hardest:

   - You create a DHIS2 app
   . In that
   case you only do some front-end development and use the API
    to
   manipulate the data.
   - You create the entire website (front and back end) and use the API
    to
   manipulate the data.
   - You "fork " DHIS2 and create your
   own layout. Note that then you would have to merge back all the new bugs
   fix and features.

If not already done, I would advise to first get a dashboard with the
already existing DHIS2 layout before thinking to switch to a new one.


Best,


Edouard

PS: Myself still a newbie with DHIS2. Maybe some other people in this list
have better advices.

2018-03-11 23:42 GMT+02:00 Olaleke Seweje :

> Hi All,
>
>
> I have just started using DHIS and I want to develop a dashboard based on
> DHIS2 data, something like https://data.pepfar.net/. Notice that the
> dashboard does not have the usual DHIS look and feel.
>
>
> I have been told that DHIS has a built in facility for doing this but I
> have not come across it in the DHIS documentation or any training materials.
>
>
> I need advise on how I can go about this please. Any helpful documentation
> or training materials that can help with this will be appreciated as well.
>
>
> Thanks all.
>
>
> --
> Regards,
> Leke Seweje
>
> ___
> 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
>
>


-- 
*Edouard Lavaud, *



*MSc in Health Policy, Planning & FinancingMEng in
TelecommunicationUniversity Diploma in ICT for Health*
*Email:* edouard.lav...@gmail.com
*Mobile:* 0033 6 7210 23 59
___
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] [Dhis2-users] Custom colors for pivot and charts

2018-03-12 Thread Prosper BT
Dear Bernard,

This is not supported yet, but planned, check jira issue

   1. DHIS2-147 


Prosper Behumbiize, MPH
DHIS2 Implementation Adviser| HISP Uganda
pros...@hispuganda.org  | pros...@dhis2.org | Skype:
prospertb

On Thu, Mar 1, 2018 at 5:10 PM, Bernard Sadaka (IM Advisor) <
lib@pu-ami.org> wrote:

> Hello All,
>
> Is it possible to customize the color of the pivot table rows as well as
> the charts?
>
> What I would like to achieve is provide pivot table and charts that match
> colors: e.g. the target data in blue and the actual data in green both in
> the pivot rows/columns as well as in the chart.
>
> Advice appreciated.
>
>
>
> All the best,
>
> Bernard
>
>
>
> [image: cid:image002.png@01D36F50.572585A0]
>
> *Bernard Sadaka*
>
> *Information Management Advisor*
>
> Première Urgence - Aide Médicale Internationale
>
> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
>
> Ain el Remmaneh, Beirut, Lebanon
>
> *E-mail:* lib@pu-ami.org
>
> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>
> *Skype:* imapuami
>
> *Website:* https://www.pu-ami.org
>
>
>
>
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_4788535999172519507_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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] [Dhis2-users] Hiding an element in an Option-Tracker Capture.

2018-03-12 Thread Prosper BT
Dear Stanley,

This is not supported now, its been a feature requested by many and its on
the to do list.

Check

   1. DHIS2-431  and see if it
   addresses you use-case.
   2.
  1. Regards


Prosper Behumbiize, MPH
DHIS2 Implementation Adviser| HISP Uganda
pros...@hispuganda.org  | pros...@dhis2.org | Skype:
prospertb

On Fri, Mar 2, 2018 at 2:26 PM, Stanley Kalyati  wrote:

> Does anyone know how to hide an element in an Option? I.e If one selects
> Male as gender in an Option,the in another Option, anything option related
> to Females should disappear or hide.
>
> Any ideas?
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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