[Dhis2-users] Pruning the OU hierarchy

[Knut Staring]

Hi everyone,

Are there some easy ways of pruning an OrgUnit tree?

Basically, I have a number of countries with varying numbers of subnational
levels, but am only interested in one of the countries. I guess in previous
DHIS2 versions I could have done a detailed metadata export. What would be
a quick way to prune now?

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

Re: [Dhis2-users] Pruning the OU hierarchy

[Knut Staring]

Works nicely (I first mistakenly used organisationunitid instead of uid),
except that the following part should be updated (I just removed it):

EXECUTE 'DELETE FROM programstageinstance_outboundsms WHERE
programstageinstanceid IN (SELECT programstageinstanceid FROM
programstageinstance WHERE organisationunitid = $1 OR programinstanceid IN
(SELECT programinstanceid FROM programinstance WHERE organisationunitid =
$1 OR trackedentityinstanceid IN (SELECT trackedentityinstanceid FROM
trackedentityinstance WHERE organisationunitid = $1))) '
USING organisationunitid;

On Tue, Dec 5, 2017 at 1:21 PM, Knut Staring <knu...@gmail.com> wrote:

> Thanks!
>
>
> On Tue, Dec 5, 2017 at 1:15 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Try this
>>
>> https://github.com/dhis2/dhis2-utils/blob/master/resources/
>> sql/delete_orgunittree_with_data.sql
>>
>> which will prune an entire branch of the orgunit tree.
>>
>> Regards,
>> Jason
>>
>>
>> On Tue, Dec 5, 2017 at 9:07 AM, Knut Staring <knu...@gmail.com> wrote:
>>
>>> Hi everyone,
>>>
>>> Are there some easy ways of pruning an OrgUnit tree?
>>>
>>> Basically, I have a number of countries with varying numbers of
>>> subnational levels, but am only interested in one of the countries. I guess
>>> in previous DHIS2 versions I could have done a detailed metadata export.
>>> What would be a quick way to prune now?
>>>
>>> Knut
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>
>
>
>
> --
> 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
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Stack trace with empty 2.28 database

[Knut Staring]

I replaced with 2.27 war and got the same message actually. Though not sure
how it affects the system, several things do seem to work fine.

On Tue, Dec 5, 2017 at 10:53 AM, Morten Olav Hansen <mor...@dhis2.org>
wrote:

> Hi Knut
>
> I'm not really sure, could you try and download a dhis2 2.28 war file and
> replace the one in webapps/dhis? (just unzip it), maybe the war file is
> corrupt.. if it is, i will update the live package
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Tue, Dec 5, 2017 at 12:07 PM, Knut Staring <knu...@gmail.com> wrote:
>
>> Just starting up with a blank database with dhis-live I get the following
>> errors in the log. Any ideas?
>>
>> --
>> 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-users
>> Post to     : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Pivot table not updated

[Knut Staring]

What about the Tomcat log and the browser console?

Knut

On Wed, Dec 13, 2017 at 9:57 AM, Sunakshi Chagti <sunakshicha...@gmail.com>
wrote:

> Yes Morten I am creating a JIRA Issue for that and issue number is
> DHIS2-2615 <https://jira.dhis2.org/browse/DHIS2-2615>
>
>
>
>
> Regards,
> Sunakshi
> Junior Software Developer
> HISP INDIA
>
>
>
> On Wed, Dec 13, 2017 at 12:43 PM, Morten Olav Hansen <mor...@dhis2.org>
> wrote:
>
>> Hi Sunakshi
>>
>> There must be something in the web console or in the tomcat console? did
>> you create a JIRA issue for it? (2.25 is a bit old now, but maybe Jan can
>> have a look at it)
>>
>> --
>> Morten Olav Hansen
>> Senior Engineer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Wed, Dec 13, 2017 at 1:21 PM, Sunakshi Chagti <
>> sunakshicha...@gmail.com> wrote:
>>
>>> Hi All
>>>
>>> This is a gentle reminder. Please help with this. Pivot tables are not
>>> working in 2.25 instance.
>>>
>>>
>>>
>>>
>>> Regards,
>>> Sunakshi
>>> Junior Software Developer
>>> HISP INDIA
>>>
>>>
>>>
>>> On Wed, Dec 6, 2017 at 12:29 PM, Sunakshi Chagti <
>>> sunakshicha...@gmail.com> wrote:
>>>
>>>> Hi All,
>>>>
>>>> I am using 2.25 war file and facing an issue with pivot table update.
>>>> After clicking on update button there is no response for that and also
>>>> there is no error in console.
>>>> Here i am sharing details of the instance.
>>>>
>>>> Build Revision : 2db4ef1
>>>> Build date : 2017-12-05 06:47
>>>>
>>>>
>>>>
>>>> Regards,
>>>> Sunakshi
>>>> Junior Software Developer
>>>> HISP INDIA
>>>>
>>>>
>>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] In DHIS 2.28 Issues with organisation unit selection in tracker capture

[Knut Staring]

Hi Thierry,

Do you also see this in the online demo?

Sometimes with user interface issues like this, clearing your browser cache
can help:
https://www.dhis2.org/tutorials/how-to-really-clear-browser-cache

Knut

On Tue, Dec 19, 2017 at 2:28 AM, Thierry Octave <thierry_oct...@dai.com>
wrote:

> Hi all,
>
>
>
> In DHIS 2.28, I have created a data element called “Institution” for
> tracker and I set the value type to “Organisation Unit”. But, when I go to
> the tracker capture and click on the field institution to select
> oraganisation unit, I was unable to select organization units.
>
>
>
> The popup was there with the list of organization unit, but when click on
> the select button, nothing appeared in the institution field.
>
>
>
> Please let me know how you can help.
>
>
>
> Thanks
>
>
>
> Thierry
> The DAI email disclaimer can be found at
> http://www.dai.com/disclaimer.
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] In DHIS 2.28 Issues with organisation unit selection in tracker capture

[Knut Staring]

If you see the same problem in the demo, pls report as a JIRA issue.

Cheers,
Knut

On Tue, Dec 19, 2017 at 3:37 PM, Thierry Octave <thierry_oct...@dai.com>
wrote:

> Hi Knut,
>
>
>
> I’m going to check on the online demo to see. I do clear my cache but the
> problem persist.
>
>
>
> Thierry
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* Tuesday, December 19, 2017 9:13 AM
> *To:* Thierry Octave <thierry_oct...@dai.com>
> *Cc:* dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] In DHIS 2.28 Issues with organisation unit
> selection in tracker capture
>
>
>
> Hi Thierry,
>
>
>
> Do you also see this in the online demo?
>
>
>
> Sometimes with user interface issues like this, clearing your browser
> cache can help:
>
> https://www.dhis2.org/tutorials/how-to-really-clear-browser-cache
> <https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dhis2.org%2Ftutorials%2Fhow-to-really-clear-browser-cache=01%7C01%7CThierry_Octave%40dai.com%7C993277b1a00a4ad963e608d546eacb3d%7C7107113de20b4c20a4ce553cabbf686d%7C0=h0xUAFNHCYRN5td2X5jCtnOxfx%2Bkncmhg%2BorYx0unxQ%3D=0>
>
>
>
> Knut
>
>
>
> On Tue, Dec 19, 2017 at 2:28 AM, Thierry Octave <thierry_oct...@dai.com>
> wrote:
>
> Hi all,
>
>
>
> In DHIS 2.28, I have created a data element called “Institution” for
> tracker and I set the value type to “Organisation Unit”. But, when I go to
> the tracker capture and click on the field institution to select
> oraganisation unit, I was unable to select organization units.
>
>
>
> The popup was there with the list of organization unit, but when click on
> the select button, nothing appeared in the institution field.
>
>
>
> Please let me know how you can help.
>
>
>
> Thanks
>
>
>
> Thierry
>
> The DAI email disclaimer can be found at
> http://www.dai.com/disclaimer.
> <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dai.com%2Fdisclaimer.=01%7C01%7CThierry_Octave%40dai.com%7C993277b1a00a4ad963e608d546eacb3d%7C7107113de20b4c20a4ce553cabbf686d%7C0=On5fUeY2VJGI1hiXk2zuO3MEvRBm2ZBsNxpDifZSxQE%3D=0>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> <https://na01.safelinks.protection.outlook.com/?url=https:%2F%2Flaunchpad.net%2F~dhis2-users=01%7C01%7CThierry_Octave%40dai.com%7C993277b1a00a4ad963e608d546eacb3d%7C7107113de20b4c20a4ce553cabbf686d%7C0=6P4S7arh7GAizu6ljwHBhOQ9cxgB1rWK6ikZox5LnSk%3D=0>
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> <https://na01.safelinks.protection.outlook.com/?url=https:%2F%2Flaunchpad.net%2F~dhis2-users=01%7C01%7CThierry_Octave%40dai.com%7C993277b1a00a4ad963e608d546eacb3d%7C7107113de20b4c20a4ce553cabbf686d%7C0=6P4S7arh7GAizu6ljwHBhOQ9cxgB1rWK6ikZox5LnSk%3D=0>
> More help   : https://help.launchpad.net/ListHelp
> <https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fhelp.launchpad.net%2FListHelp=01%7C01%7CThierry_Octave%40dai.com%7C993277b1a00a4ad963e608d546eacb3d%7C7107113de20b4c20a4ce553cabbf686d%7C0=3RbWvRZO66toPyQdr7Dl6iymPUGs6yrV4Huxewmu%2BZM%3D=0>
>
>
>
>
>
> --
>
> 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
> The DAI email disclaimer can be found at
> http://www.dai.com/disclaimer.
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data visualisation is not working

[Knut Staring]

Any error messages in the browser console or in the server log?

On Thu, Dec 14, 2017 at 8:53 AM, Jean de Dieu Anoubissi <
jd.anoubi...@gmail.com> wrote:

> Hi Knut
> The upgrade have been made by the Bao System team which is hosting our
> system
>
>
> 2017-12-14 8:45 GMT+01:00 Knut Staring <knu...@gmail.com>:
>
>> Did you upgrade step by step running all the script and test every
>> version? At which point did This issue arise?
>>
>> On Dec 14, 2017 8:40 AM, "Jean de Dieu Anoubissi" <jd.anoubi...@gmail.com>
>> wrote:
>>
>>> Hil all,
>>>
>>> Is anyone have ever experience this issue?
>>> We upgraded our instance from 2.20 to 2.27 :80e598f
>>> since then we cannot create chart with data visualizer anymore
>>> thanks
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data visualisation is not working

[Knut Staring]

Did you upgrade step by step running all the script and test every version?
At which point did This issue arise?

On Dec 14, 2017 8:40 AM, "Jean de Dieu Anoubissi" 
wrote:

> Hil all,
>
> Is anyone have ever experience this issue?
> We upgraded our instance from 2.20 to 2.27 :80e598f
> since then we cannot create chart with data visualizer anymore
> thanks
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] organization unit tree won't display

[Knut Staring]

Hi,

Have you linked your user (presumably "admin"?) to an organisation unit?

Knut

On Tue, Dec 19, 2017 at 9:59 PM, Mohamed Elkhou <oelk...@gmail.com> wrote:

> Dear All,
>
> I am using a DHIS2 live 2.28 local installation.
>
> When trying to create an ‘organization unit group' or a dataset the
> organization unit tree won't display,  it says instead "Determining your
> root organization unit".
>
> How do I get the organization unit tree to display?
>
>
>
> Please help
>
> Many thanks
>
> Mohamed
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Error when exporting metadata throuhg metadata export

[Knut Staring]

Hello Vunda,

Whenever you get a 500 Internal Server Error, you have too look at (and
probrobably share) your Tomcat server log, which should contain more
interesting error messages.

Regards,
Knut


On Fri, Nov 17, 2017 at 1:57 PM, vunda limbe <vunda...@gmail.com> wrote:

> Hi Everybody,
>
> When I try to export meta data in both json or xml, I'm getting this
> message: "
>
> {"httpStatus":"Internal Server Error","httpStatusCode":500,"status":"ERROR"}
>
> Could someone tell me how to fix this? Alternativly, someone can give me a 
> script in order to export dataelement, COC, CO and Dataset using Web Api.
>
> Your help is welcome.
>
> Thanks.
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DataSet having Period Type 'Daily'

[Knut Staring]

Hi there, please open your browser console (Developer Tools) and look for
errors and report them here.

Regards,
Knut

On Fri, Nov 10, 2017 at 2:12 PM, <rab...@pace-tech.com> wrote:

> hello,
>
> I am having a problem to save dataset having period type
>   "Daily". Kindly tell me how can i save it?
> Thank You.
>
> Regards:
> Rabbia Naz
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Error when exporting metadata throuhg metadata export

[Knut Staring]

Hi Vunda,

Look for a file called catalina.out, probably in your logs folder under
Tomcat.

Knut

On Tue, Nov 21, 2017 at 5:25 PM, vunda limbe <vunda...@gmail.com> wrote:

> Hi ramon,
>
> I only find this in my tomcat folder
>
> On Tue, Nov 21, 2017 at 11:47 AM, Ramón José Jiménez Pomareta <
> dh...@pomareta.ch> wrote:
>
>> in your logs there's only the OK saying DHIS2 started. Try to get the log
>> at the time of the error (tail -f while reproducing the error)
>>
>> 2017-11-21 10:37 GMT+01:00 vunda limbe <vunda...@gmail.com>:
>>
>>> Hi Knut,
>>>
>>> Attached the logs.
>>>
>>> Thanks.
>>>
>>> On Fri, Nov 17, 2017 at 2:37 PM, Knut Staring <knu...@gmail.com> wrote:
>>>
>>>> Hello Vunda,
>>>>
>>>> Whenever you get a 500 Internal Server Error, you have too look at
>>>> (and probrobably share) your Tomcat server log, which should contain more
>>>> interesting error messages.
>>>>
>>>> Regards,
>>>> Knut
>>>>
>>>>
>>>> On Fri, Nov 17, 2017 at 1:57 PM, vunda limbe <vunda...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi Everybody,
>>>>>
>>>>> When I try to export meta data in both json or xml, I'm getting this
>>>>> message: "
>>>>>
>>>>> {"httpStatus":"Internal Server 
>>>>> Error","httpStatusCode":500,"status":"ERROR"}
>>>>>
>>>>> Could someone tell me how to fix this? Alternativly, someone can give me 
>>>>> a script in order to export dataelement, COC, CO and Dataset using Web 
>>>>> Api.
>>>>>
>>>>> Your help is welcome.
>>>>>
>>>>> Thanks.
>>>>>
>>>>>
>>>>> ___
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to : dhis2-users@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Knut Staring
>>>> Dept. of Informatics, University of Oslo
>>>> Norway: +4791880522 <+47%20918%2080%20522>
>>>> Skype: knutstar
>>>> http://dhis2.org
>>>>
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> 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
Mobile 1: +33 6 4434 2931
Mobile 2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] how to set the default gis app map 's center?

[Knut Staring]

I suppose a JIRA request could be filed to include this as a (global?)
setting.

Knut

On Tue, Nov 21, 2017 at 12:41 PM, Jan Henrik Øverland <j...@dhis2.org> wrote:

> Hi, there's currently no way to set a default map center.
>
> Jan
>
> On 21 November 2017 at 03:56, 林晓东 <lin...@126.com> wrote:
>
>> Hi,all,
>>
>>  I want to know  how to set the default map center of gis app.
>>
>>   Thanks.
>>
>>
>>
>>
>> --
>> 此致
>>
>> easy
>>
>> 莫愁前路无知己，天下谁人不识君。
>>
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jan Henrik Øverland
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org <https://www.dhis2.org/>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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
Mobile 1: +33 6 4434 2931
Mobile 2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Permissions to see everything in Reports module EXCEPT for Analytics

[Knut Staring]

Thanks Nick - not being triggered is good, though very confusing as there
is no message...

On Wed, Nov 1, 2017 at 7:24 PM, Shurajit Dutta <shurajitdu...@gmail.com>
wrote:

> Hi all
>
> Please see the following:
> https://jira.dhis2.org/browse/DHIS2-2079
>
> Seems it is a known issue. At least analytics is not triggered unless
> they actually have permission.
>
> Nick
>
> On Mon, Oct 30, 2017 at 2:44 PM, Laura E. Lincks <
> laura.lin...@icap.columbia.edu> wrote:
>
>> I thought so too... but I have a role that can See Report Module... I did
>> not assign it the Administer data mart authority... Yet that role still has
>> access to Analytics. I ran Analytics and thought maybe it wasn't truly
>> functional. It never spit out details of the process but it did show a
>> "Start..." message.
>> I could have sworn I've logged into instances where I see Reports without
>> Analytics. Seems I can log in to DATIM Reports Module and also see
>> Analytics option. I didn't execute for fear that I could do damage.
>>
>> *Laura E. Lincks*
>> Database Manager/Developer
>> ICAP - Columbia University
>> Mailman School of Public Health
>> 60 Haven Ave, Floor B1
>> <https://maps.google.com/?q=60+Haven+Ave,+Floor+B1+New+York,+NY+10032=gmail=g>
>> New York, NY 10032
>> <https://maps.google.com/?q=60+Haven+Ave,+Floor+B1+New+York,+NY+10032=gmail=g>
>> Tel: 212 304 7132 <(212)%20304-7132>
>>
>> On Mon, Oct 30, 2017 at 1:26 PM, Knut Staring <knu...@gmail.com> wrote:
>>
>>> HmI think it was that way, though it does not seem to be the case
>>> anymore?
>>>
>>> On Mon, Oct 30, 2017 at 6:21 PM, Knut Staring <knu...@gmail.com> wrote:
>>>
>>>> Hi Laura,
>>>>
>>>> This has in fact been done in the online demo.
>>>>
>>>> I *think* you just have to remove the "Administer data mart" authority
>>>> from the user role.
>>>>
>>>> Best,
>>>> Knut
>>>>
>>>>
>>>> On Mon, Oct 30, 2017 at 4:47 PM, Laura E. Lincks <
>>>> laura.lin...@icap.columbia.edu> wrote:
>>>>
>>>>> ​​Version:
>>>>> 2.27
>>>>>
>>>>> Build revision:
>>>>> 0a49a22
>>>>>
>>>>> Is there a way to create a User role which has access to the *Reports
>>>>> Module* for everything EXCEPT access to run Analytics?
>>>>>
>>>>> *Laura E. Lincks*
>>>>> Database Manager/Developer
>>>>> ICAP - Columbia University
>>>>> Mailman School of Public Health
>>>>> 60 Haven Ave, Floor B1
>>>>> <https://maps.google.com/?q=60+Haven+Ave,+Floor+B1+New+York,+NY+10032=gmail=g>
>>>>> New York, NY 10032
>>>>> <https://maps.google.com/?q=60+Haven+Ave,+Floor+B1+New+York,+NY+10032=gmail=g>
>>>>> Tel: 212 304 7132 <(212)%20304-7132>
>>>>>
>>>>> ___
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to : dhis2-users@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Knut Staring
>>>> Dept. of Informatics, University of Oslo
>>>> Norway: +4791880522 <+47%20918%2080%20522>
>>>> Skype: knutstar
>>>> http://dhis2.org
>>>>
>>>
>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> Norway: +4791880522 <+47%20918%2080%20522>
>>> Skype: knutstar
>>> http://dhis2.org
>>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Shurajit Dutta
> Health Information Consultant
>



-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] DHIS 2, PostgreSQL only

[Knut Staring]

Good decision. I assume this means H2 will also no longer be a fallback? So
dhis2 live will also require PG?

Knut



On Nov 9, 2017 3:32 PM, "Lars Helge Øverland"  wrote:

> Hi all,
>
> after gathering feedback from the community we have decided to support
> PostgreSQL only as database platform for DHIS 2 starting from version 2.29
> (i.e. the next release).
>
> This will allow us to utilize some of the sophisticated features specific
> to PostgreSQL in order to make a better system. As example, this will help
> us to improve the analytics and data import/export functionality.
>
> The minimum version required will be PostgreSQL version 9.0. We do however
> recommend migrating to PostgreSQL 10 as it provides performance
> improvements and new features which may be utilized in near-future DHIS 2
> releases.
>
> best regards,
>
> Lars
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [WISCENTDs] User role > Authorities

[Knut Staring]

I unfortunately don't think the documentation around authorities is
adequate at the moment.

It is also interesting that a couple of organisations have seen the need to
develop their own user management apps

There has been some discussion on the need to create some standard metadata
packages with typical user roles. There are of course some user roles in
the online demo and in the Trainingland databases, but we could package
them nicely for easy import to a new  instance.

Knut

On Wed, Nov 8, 2017 at 3:31 PM, Edward Robinson <
erobin...@projectbalance.com> wrote:

> Given the sheer number of authorities, I think this kind of documentation
> would be super helpful.  I’d love to know if something like this exists.
>
> Ed
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+erobinson=
> projectbalance@lists.launchpad.net] *On Behalf Of *GROUT, Lise
> *Sent:* Wednesday, 08 November 2017 10:39 AM
> *To:* Dhis2 Users <dhis2-users@lists.launchpad.net>
> *Cc:* RAMON JOSE JIMENEZ POMARETA <rjime...@who.int>
> *Subject:* [Dhis2-users] [WISCENTDs] User role > Authorities
>
>
>
> Dear all,
>
>
>
> Is there a place where we could find clear description of each authorities
> available to create user roles?
>
>
>
> Best
>
> lise
>
>
>
> Dr. Lise Grout
>
> *Epidemiologist*
>
>
>
> *World Health Organization*
>
> *Department of Neglected Tropical Diseases (HTM/NTD/IDM)*
> *Innovative and Intensified Disease Management Unit*
> *20, Avenue Appia; CH-1211 Geneva 27*
> *Tel. **+41 22 791 2341 <+41%2022%20791%2023%2041>*
>
> *Mobile +41 79 290 68 61 <+41%2079%20290%2068%2061>*
>
> *Skype: tigrouveto*
>
> http://www.who.int/neglected_diseases
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522 <+47%20918%2080%20522>
Skype: knutstar
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Dashboard Not Showing Up

[Knut Staring]

Hi,  you have to go to Reports and run Analytics first

On Nov 8, 2017 7:45 PM, "Oladiran, Olakunle Francis" 
wrote:

>
> Hello Experts,
>
> I trust  you are well. I am trying to create a dashboard on DHIS2 but the
> charts are not showing. It keeps showing 'No Data to Display'(please see
> the image below).
> My question is what is the minimum datasets required for the charts to
> show up? Please note that I have checked the indicators properly. Kindly
> give me any pointers to fix it.
>
> Thanks,
> Kunle
>
>
>
>
> [image: Inline image 2]
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Data Set Issue

[Knut Staring]

Right - so you could have two options, either use the Chiefdom to
differentiate though they all just use the same name. However, you may
require some special analytics for this.

The other way would be to add the name of each chiefdom at the end of the
identical school names to make them not identical.

Knut

On Thu, Dec 7, 2017 at 8:45 AM, gerald thomas <gerald17...@gmail.com> wrote:

> Dear Knut,
>
> Yes. Chiefdom will be my OU for this data collection.
>
>
> On 12/7/17, Knut Staring <knu...@gmail.com> wrote:
> > Hi Gerald, I assume you will be using the Chiefdom as the OrgUnit for
> this
> > data collection?
> >
> > Regards,
> > Knut
> >
> > On Tue, Dec 5, 2017 at 8:19 PM, gerald thomas <gerald17...@gmail.com>
> > wrote:
> >
> >> Dear Knut,
> >> Thanks very much for your help but i have one more question; I have 31
> >> schools of which 4 of them have the same name (RC Junior Sec School)
> >> but of different chiefdoms. Can i do a single attributecategory RC
> >> Junior Sec School and assigned it to the various chiefdoms? Will the
> >> schools data save separately with reference to their respective
> >> chiefdoms or should i create attributecategory for each RC Junior Sec
> >> School label with its chiefdom?
> >>
> >> On 12/4/17, gerald thomas <gerald17...@gmail.com> wrote:
> >> > Dear Knut,
> >> > Thanks for the note, I will try to explore this option.
> >> >
> >> > On Mon, 4 Dec 2017 at 18:46, Knut Staring <knu...@gmail.com> wrote:
> >> >
> >> >> I think you could use attributeoptioncombos for this instead of
> >> >> categories:
> >> >
> >> >> https://docs.dhis2.org/2.22/en/user/html/ch05s07.html
> >> >
> >> >> Knut
> >> >
> >> >> On Mon, Dec 4, 2017 at 11:33 PM, gerald thomas <
> gerald17...@gmail.com>
> >> >> wrote:
> >> >
> >> >>> Dear all,
> >> >>> Thanks for your help.
> >> >>> I am was only using two schools for explanation purposes. But the
> >> >>> scenario is much more complex. I have 32 schools of which the
> >> >>> partners
> >> >>> didn’t want us to use them on their current hierarchy; so we decided
> >> >>> to
> >> >>>
> >> >>> use
> >> >>> each school as a DataSet but that didn’t work either. The idea of
> >> >>> attributes came up before but i am sure it doesn’t work with
> category
> >> >>> combinations.
> >> >>> Please what is the best option
> >> >
> >> >>> On Mon, 4 Dec 2017 at 18:12, Dennis Banga <dennisba...@gmail.com>
> >> wrote:
> >> >
> >> >>>> Hi Gerald,
> >> >
> >> >>>> A data set is just a container for the data elements, hence the
> >> >>>> behavior. Utilize attrubutes for the RC and LC schools instead.
> >> >>>> Kindly see the documentation here
> >> >>>> <https://docs.dhis2.org/master/en/user/html/dhis2_
> >> user_manual_en_full.html#use_category_combo_for_data_set>
> >> >
> >> >
> >> >>>> Regards,
> >> >>>> Dennis
> >> >
> >> >>>> On 4 December 2017 at 19:46, gerald thomas <gerald17...@gmail.com>
> >> >>>> wrote:
> >> >
> >> >>>>> Dear All,
> >> >>>>> I am having two different DataSets by the name of RC School and LC
> >> >>>>> School sharing the same data elements and category combination.
> >> During
> >> >>>>> data entry when I entered information on the RC School DataSet it
> >> >>>>> saves but when i switched to LC School the information of RC
> School
> >> >>>>> DataSet is present of LC School and whatever changes done on LC
> >> School
> >> >>>>> DataSet will automatically reflect on RC School DataSet.
> >> >
> >> >>>>> Please can anyone help.
> >> >
> >> >
> >> >>>>> --
> >> >>>>> Regards,
> >> >
> >> >>>>> Gerald
> >> >
> >> >>>>> ___
> >> >>>>> Mailing list: https://launchpad.net/~dhi

Re: [Dhis2-users] [Dhis2-devs] Data Set Issue

[Knut Staring]

Hi Gerald, I assume you will be using the Chiefdom as the OrgUnit for this
data collection?

Regards,
Knut

On Tue, Dec 5, 2017 at 8:19 PM, gerald thomas <gerald17...@gmail.com> wrote:

> Dear Knut,
> Thanks very much for your help but i have one more question; I have 31
> schools of which 4 of them have the same name (RC Junior Sec School)
> but of different chiefdoms. Can i do a single attributecategory RC
> Junior Sec School and assigned it to the various chiefdoms? Will the
> schools data save separately with reference to their respective
> chiefdoms or should i create attributecategory for each RC Junior Sec
> School label with its chiefdom?
>
> On 12/4/17, gerald thomas <gerald17...@gmail.com> wrote:
> > Dear Knut,
> > Thanks for the note, I will try to explore this option.
> >
> > On Mon, 4 Dec 2017 at 18:46, Knut Staring <knu...@gmail.com> wrote:
> >
> >> I think you could use attributeoptioncombos for this instead of
> >> categories:
> >
> >> https://docs.dhis2.org/2.22/en/user/html/ch05s07.html
> >
> >> Knut
> >
> >> On Mon, Dec 4, 2017 at 11:33 PM, gerald thomas <gerald17...@gmail.com>
> >> wrote:
> >
> >>> Dear all,
> >>> Thanks for your help.
> >>> I am was only using two schools for explanation purposes. But the
> >>> scenario is much more complex. I have 32 schools of which the partners
> >>> didn’t want us to use them on their current hierarchy; so we decided to
> >>>
> >>> use
> >>> each school as a DataSet but that didn’t work either. The idea of
> >>> attributes came up before but i am sure it doesn’t work with category
> >>> combinations.
> >>> Please what is the best option
> >
> >>> On Mon, 4 Dec 2017 at 18:12, Dennis Banga <dennisba...@gmail.com>
> wrote:
> >
> >>>> Hi Gerald,
> >
> >>>> A data set is just a container for the data elements, hence the
> >>>> behavior. Utilize attrubutes for the RC and LC schools instead.
> >>>> Kindly see the documentation here
> >>>> <https://docs.dhis2.org/master/en/user/html/dhis2_
> user_manual_en_full.html#use_category_combo_for_data_set>
> >
> >
> >>>> Regards,
> >>>> Dennis
> >
> >>>> On 4 December 2017 at 19:46, gerald thomas <gerald17...@gmail.com>
> >>>> wrote:
> >
> >>>>> Dear All,
> >>>>> I am having two different DataSets by the name of RC School and LC
> >>>>> School sharing the same data elements and category combination.
> During
> >>>>> data entry when I entered information on the RC School DataSet it
> >>>>> saves but when i switched to LC School the information of RC School
> >>>>> DataSet is present of LC School and whatever changes done on LC
> School
> >>>>> DataSet will automatically reflect on RC School DataSet.
> >
> >>>>> Please can anyone help.
> >
> >
> >>>>> --
> >>>>> Regards,
> >
> >>>>> Gerald
> >
> >>>>> ___
> >>>>> Mailing list: https://launchpad.net/~dhis2-devs
> >>>>> Post to : dhis2-d...@lists.launchpad.net
> >>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
> >>>>> More help   : https://help.launchpad.net/ListHelp
> >
> >>>> --
> >>> Regards,
> >
> >>> Gerald
> >
> >>> ___
> >>> Mailing list: https://launchpad.net/~dhis2-devs
> >>> Post to : dhis2-d...@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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
> >> Skype: knutstar
> >
> > --
> > Regards,
> >
> > Gerald
> >
>
>
> --
> Regards,
>
> Gerald
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Skinning no longer working?

[Knut Staring]

Trying to select a different style under System settings -> Appearance,
selecting a different style seems to have no effect in the online demo?

-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS2 - Importing GIS Coordinates for Organization unit

[Knut Staring]

Omer: Points or polygons? Do you see the coordinates in your
organisationunit table?

On Thu, Oct 26, 2017 at 9:50 AM, Omer Butt <omerbutt2...@gmail.com> wrote:

> Hi,
>
> I have successfully Completed the process of importing polygon coordinates
> for GIS App.
>
> Steps Done.
>
> 1. Download Shape file of my country
> 2. Convert Shape file to GML
> 3. Import GML to DHIS 2.
>
> Below Image is shown. But cannot update coordinates. Also not shown in GIS
> App.
> Why lat long not updated to organization unit. ??
> Whats going wrong ?
>
> Kindly Guide.
>
>
> Thanks.
>
> [image: Inline image 1]
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS 2

[Knut Staring]

https://docs.dhis2.org/2.26/en/user/html/gis_creating_setup.html

On Wed, Oct 25, 2017 at 8:28 AM, Knut Staring <knu...@gmail.com> wrote:

> Search the docs for ogr2ogr
>
> On Oct 25, 2017 8:27 AM, "Knut Staring" <knu...@gmail.com> wrote:
>
>> You first need Shapefiles. You can often get those from gadm.org
>>
>> On Oct 25, 2017 5:25 AM, "Omer Butt" <omerbutt2...@gmail.com> wrote:
>>
>>> Hi,
>>> I have read it from Documentation.
>>>
>>> It might be more efficient to import coordinates later as a batch job
>>> for all organization units using the *Import-Export* app. You also use
>>> the *Import-Export* app to create polygons. A polygon is an
>>> organization unit that represent an administrative boundary.
>>>
>>> can you please guide me how to create it ?
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS 2

[Knut Staring]

You first need Shapefiles. You can often get those from gadm.org

On Oct 25, 2017 5:25 AM, "Omer Butt"  wrote:

> Hi,
> I have read it from Documentation.
>
> It might be more efficient to import coordinates later as a batch job for
> all organization units using the *Import-Export* app. You also use the
> *Import-Export* app to create polygons. A polygon is an organization unit
> that represent an administrative boundary.
>
> can you please guide me how to create it ?
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS 2

[Knut Staring]

Search the docs for ogr2ogr

On Oct 25, 2017 8:27 AM, "Knut Staring" <knu...@gmail.com> wrote:

> You first need Shapefiles. You can often get those from gadm.org
>
> On Oct 25, 2017 5:25 AM, "Omer Butt" <omerbutt2...@gmail.com> wrote:
>
>> Hi,
>> I have read it from Documentation.
>>
>> It might be more efficient to import coordinates later as a batch job for
>> all organization units using the *Import-Export* app. You also use the
>> *Import-Export* app to create polygons. A polygon is an organization
>> unit that represent an administrative boundary.
>>
>> can you please guide me how to create it ?
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Permissions to see everything in Reports module EXCEPT for Analytics

[Knut Staring]

HmI think it was that way, though it does not seem to be the case
anymore?

On Mon, Oct 30, 2017 at 6:21 PM, Knut Staring <knu...@gmail.com> wrote:

> Hi Laura,
>
> This has in fact been done in the online demo.
>
> I *think* you just have to remove the "Administer data mart" authority
> from the user role.
>
> Best,
> Knut
>
>
> On Mon, Oct 30, 2017 at 4:47 PM, Laura E. Lincks <
> laura.lin...@icap.columbia.edu> wrote:
>
>> ​​Version:
>> 2.27
>>
>> Build revision:
>> 0a49a22
>>
>> Is there a way to create a User role which has access to the *Reports
>> Module* for everything EXCEPT access to run Analytics?
>>
>> *Laura E. Lincks*
>> Database Manager/Developer
>> ICAP - Columbia University
>> Mailman School of Public Health
>> 60 Haven Ave, Floor B1
>> New York, NY 10032
>> Tel: 212 304 7132 <(212)%20304-7132>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522 <+47%20918%2080%20522>
> Skype: knutstar
> http://dhis2.org
>



-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Permissions to see everything in Reports module EXCEPT for Analytics

[Knut Staring]

Hi Laura,

This has in fact been done in the online demo.

I *think* you just have to remove the "Administer data mart" authority from
the user role.

Best,
Knut


On Mon, Oct 30, 2017 at 4:47 PM, Laura E. Lincks <
laura.lin...@icap.columbia.edu> wrote:

> ​​Version:
> 2.27
>
> Build revision:
> 0a49a22
>
> Is there a way to create a User role which has access to the *Reports
> Module* for everything EXCEPT access to run Analytics?
>
> *Laura E. Lincks*
> Database Manager/Developer
> ICAP - Columbia University
> Mailman School of Public Health
> 60 Haven Ave, Floor B1
> New York, NY 10032
> Tel: 212 304 7132 <(212)%20304-7132>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] apps not showing

[Knut Staring]

Hi,

Could you ask them to try Firefox in Private mode?
https://www.online-tech-tips.com/computer-tips/firefox-private-browsing/

Knut

On Fri, May 4, 2018 at 10:17 AM, Thomas Lavreys <thomaslavr...@gmail.com>
wrote:

> Dear,
>
>
>
> One of our clinics in Cameroon (rural, weak internet connection), cannot
> see the ‘Apps’ and ‘Username’ options at the top right when logged in. When
> I logged in on their account in Brussels, there was no issue.
>
> They used Firefox (picture is an older example, but there were similar
> issues on internet explorer as well), as they have no other options on our
> server.
>
>
>
> Instance info:
>
>
>
> API Web:
>
> Parcourir ici
>
> Utilisateur actuel:
>
> ekamche
>
> Version:
>
> 2.23
>
> Version:
>
> 22983
>
> Date de création:
>
> 2016-06-02 17:46
>
> Jasper reports version:
>
> 6.1.0
>
> Agent utilisateur:
>
> Mozilla/5.0 (Windows NT 6.1; WOW64; rv:55.0) Gecko/20100101
> Firefox/55.0
>
> Date du serveur:
>
> 2018-05-04 10:14
>
> Dernière génération des tables analytiques:
>
> 2018-05-04 00:00
>
> Durée depuis dernière création des tables analytiques:
>
> 10 h, 14 m, 16 s
>
> Dernier runtime tables analytiques:
>
> 25 s
>
> Variable d'environnement:
>
> DHIS2_HOME
>
>
>
> [image: Images intégrées 2]
>
>
>
> Do you know if this issue has been seen before, and what the solution
> might be?
>
>
>
> Thank you in advance!
>
>
>
> Kind regards,
>
>
>
> *Thomas Lavreys**, MSc, PgC Trop Med*
>
> *Medical Coordinator Sustainability Department SOCFINCO*
>
> *Maisha Consulting bvba*
>
>
>
> *Tel Socfin:+32-25-080050*
>
> *Tel Maisha: +32-16-850242*
>
> *Cell phone:  +32-474-717641*
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Analytics error after upgrade to 2.29

[Knut Staring]

Still not sure why this error arose, but *fixed it" by deleting
completenessregistrations from before 2015:

delete from completedatasetregistration where periodid in (select periodid
from period where startdate <'2015-01-01')

On Tue, May 8, 2018 at 7:43 PM, Knut Staring <knu...@gmail.com> wrote:

> There seems to be a problem with year (it is trying to insert 2015 in a
> table that requires 2014). Does anyone have an insight into why this
> happens?
>
> Caused by: org.postgresql.util.PSQLException: ERROR: new row for relation
> "analytics_completeness_temp_2014" violates check constraint
> "analytics_completeness_temp_2014_yearly_check"
>   Detail: Failing row contains (null, null, null, null, XbBIPEpxTue,
> XbBIPEpxTue, aRxa6o8GqZN, HfVjCurKxh2, t0J75eHKxz5, xLWuQq3DjOR,
> iZNVvlnVxm6, ELzS3pnwJyh, null, null, null, null, null, null, null, 2015W1,
> null, null, null, null, 2015BiW0, 201501, 201501B, 2015Q1, 2015S1,
> 2014AprilS2, 2015, 2014April, 2014July, 2014Oct, t, zJrL4HQqYmD,
> 2015-01-06).
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] The visual chart download as png picture/pdf , all chinese word is crazy.

[Knut Staring]

Thanks, Easy. Please create a JIRA bug issue for this.

Regards,
Knut

2018-05-14 9:56 GMT+02:00 林晓东 <lin...@126.com>:

> Dear all,
>   just as fellow:
> Thanks.
>
>
>
>
> --
> 此致
>
>林晓东
>
> 莫愁前路无知己，天下谁人不识君。
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data not showing up in Pivot Table

[Knut Staring]

And then look at your Tomcat log for any errors as you run analytics.

On Mon, May 14, 2018 at 8:59 AM, Olaleke Seweje <sewejeolal...@gmail.com>
wrote:

> Okay, let me do that and see.
>
> On Mon, May 14, 2018 at 7:45 AM, Stanley Kalyati <skaly...@gmail.com>
> wrote:
>
>> No that is not normal.Try to reboot the system and re run the processes.
>>
>> On Mon, May 14, 2018, 08:41 Olaleke Seweje <sewejeolal...@gmail.com>
>> wrote:
>>
>>> I am running it now but it's been going on for about 5 mins. For only
>>> one form filled just once, should that be normal?
>>>
>>> On Mon, May 14, 2018 at 7:29 AM, Timothy Kiyemba <tkiye...@gmail.com>
>>> wrote:
>>>
>>>> run analytics
>>>>
>>>> On Mon, May 14, 2018 at 9:04 AM, Olaleke Seweje <
>>>> sewejeolal...@gmail.com> wrote:
>>>>
>>>>> Hello all,
>>>>> I have just created my first DHIS data set, entered data for data
>>>>> elements for the set and completed the form successfully. However, when I
>>>>> go to the Pivot Table app to check, the data does not show up.
>>>>>
>>>>> I have selected same organization units and period as I selected while
>>>>> filling the form.
>>>>>
>>>>> Please is there something I need to do to make the data show up?
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Leke Seweje
>>>>>
>>>>> ___
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to : dhis2-users@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> Regards,
>>> Leke Seweje
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>
>
> --
> Regards,
> Leke Seweje
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data not showing up in Pivot Table

[Knut Staring]

https://docs.dhis2.org/2.23/en/user/html/ch33.html

On Mon, May 14, 2018 at 8:04 AM, Olaleke Seweje <sewejeolal...@gmail.com>
wrote:

> Hello all,
> I have just created my first DHIS data set, entered data for data elements
> for the set and completed the form successfully. However, when I go to the
> Pivot Table app to check, the data does not show up.
>
> I have selected same organization units and period as I selected while
> filling the form.
>
> Please is there something I need to do to make the data show up?
>
> --
> Regards,
> Leke Seweje
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Combo field data not showing in report

[Knut Staring]

Hello, you can check if this issue is still there with the latest build of
2.25 or with newer versions here:
https://play.dhis2.org/

I would recommend that you consider upgrading in any case.

Regards,
Knut



On Wed, May 9, 2018 at 3:01 PM, Shams-ur-Rehman <shams.s...@akhsp.org>
wrote:

> Dear All,
>
>
>
> We are using dhis2 2.25 version, having an issue of combo field data like
> we used code 1 for Male and 2 for female in the combo field once data entry
> done in reporting section only shows data of the code instead of Male and
> Female data.
>
>
>
>
>
> Regards
>
> *Shams *
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Trouble running Analytics for 2.29

[Knut Staring]

Hi all,

Wondering if anyone has a tip for what is going wrong on my serer. I just
tested running Analytics in 2.29 with the same db on my laptop and there
were no issues, but everytime I try to do this on the server, it gives me
the following:

 INFO  2018-05-10 08:06:51,987 [Level: INFO, category: ANALYTICS_TABLE,
time: Thu May 10 08:06:51 UTC 2018, message: Applying aggregation levels]
(InMemoryNotifier.java [taskScheduler-14])
* INFO  2018-05-10 08:07:10,890 Vacuumed tables
(DefaultAnalyticsTableService.java [taskScheduler-14])
* INFO  2018-05-10 08:07:10,890 Applied aggregation levels: 00:01:54.496
(Clock.java [taskScheduler-14])
* INFO  2018-05-10 08:07:10,890 [Level: INFO, category: ANALYTICS_TABLE,
time: Thu May 10 08:07:10 UTC 2018, message: Creating indexes]
(InMemoryNotifier.java [taskScheduler-14])
* INFO  2018-05-10 08:07:10,891 No of analytics table indexes: 204
(DefaultAnalyticsTableService.java [taskScheduler-14])
May 10, 2018 8:07:25 AM org.postgresql.core.v3.ConnectionFactoryImpl log
WARNING: SQLException occurred while connecting to localhost:5432
org.postgresql.util.PSQLException: FATAL: the database system is in
recovery mode
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:452)
at org.postgresql.Driver.connect(Driver.java:254)
at
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
at
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
at
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
at
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

May 10, 2018 8:07:25 AM org.postgresql.Driver connect
SEVERE: Connection error:
org.postgresql.util.PSQLException: FATAL: the database system is in
recovery mode
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:452)
at org.postgresql.Driver.connect(Driver.java:254)
at
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
at
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
at
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
at
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

May 10, 2018 8:07:25 AM org.postgresql.core.v3.ConnectionFactoryImpl log
WARNING: SQLException occurred while connecting to localhost:5432
org.postgresql.util.PSQLException: FATAL: the database system is in
recovery mode
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at 

Re: [Dhis2-users] Missing browser based mobile client (Smart phone version) app on DHIS2 version 2.29

[Knut Staring]

Dear Pomi Daniel,

Please send queries to the DHIS 2 Users list <
dhis2-users@lists.launchpad.net>

I assume you are referring to this module:
https://play.dhis2.org/2.28/mobile/index

This module seems to have been deliberately removed in 2.29 - I will leave
it to the developers to explain why.

Knut

On Thu, May 10, 2018 at 8:51 AM, pomi daniel <pomi...@gmail.com> wrote:

> How can I install the missing browser based mobile client (Smart phone
> version) app on DHIS2 version 2.29?
> --
> This message was sent from Launchpad by
> pomi daniel (https://launchpad.net/~pomi144)
> using the "Contact this team's admins" link on the DHIS 2 Users team page
> (https://launchpad.net/~dhis2-users).
> For more information see
> https://help.launchpad.net/YourAccount/ContactingPeople
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Trouble running Analytics for 2.29

[Knut Staring]

Thanks Bob, I will try, but where is the postgresql log file in your setup
(with dhis2-tools)?

The strange thing is that everything else works up until the last part of
aggregation. In other words, I can do this again and again,

Knut

On Thu, May 10, 2018 at 6:19 PM, Bob Jolliffe <bobjolli...@gmail.com> wrote:

> Your database has popped 
>
> To find out why take a look in the postgresql log file around the same
> time.
>
> On Thu, 10 May 2018, 13:51 Knut Staring, <knu...@gmail.com> wrote:
>
>> Hi all,
>>
>> Wondering if anyone has a tip for what is going wrong on my serer. I just
>> tested running Analytics in 2.29 with the same db on my laptop and there
>> were no issues, but everytime I try to do this on the server, it gives me
>> the following:
>>
>>  INFO  2018-05-10 08:06:51,987 [Level: INFO, category: ANALYTICS_TABLE,
>> time: Thu May 10 08:06:51 UTC 2018, message: Applying aggregation levels]
>> (InMemoryNotifier.java [taskScheduler-14])
>> * INFO  2018-05-10 08:07:10,890 Vacuumed tables
>> (DefaultAnalyticsTableService.java [taskScheduler-14])
>> * INFO  2018-05-10 08:07:10,890 Applied aggregation levels: 00:01:54.496
>> (Clock.java [taskScheduler-14])
>> * INFO  2018-05-10 08:07:10,890 [Level: INFO, category: ANALYTICS_TABLE,
>> time: Thu May 10 08:07:10 UTC 2018, message: Creating indexes]
>> (InMemoryNotifier.java [taskScheduler-14])
>> * INFO  2018-05-10 08:07:10,891 No of analytics table indexes: 204
>> (DefaultAnalyticsTableService.java [taskScheduler-14])
>> May 10, 2018 8:07:25 AM org.postgresql.core.v3.ConnectionFactoryImpl log
>> WARNING: SQLException occurred while connecting to localhost:5432
>> org.postgresql.util.PSQLException: FATAL: the database system is in
>> recovery mode
>> at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(
>> ConnectionFactoryImpl.java:475)
>> at org.postgresql.core.v3.ConnectionFactoryImpl.
>> openConnectionImpl(ConnectionFactoryImpl.java:207)
>> at org.postgresql.core.ConnectionFactory.openConnection(
>> ConnectionFactory.java:49)
>> at org.postgresql.jdbc.PgConnection.(PgConnection.java:195)
>> at org.postgresql.Driver.makeConnection(Driver.java:452)
>> at org.postgresql.Driver.connect(Driver.java:254)
>> at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(
>> DriverManagerDataSource.java:175)
>> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
>> at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$
>> 1PooledConnectionResourcePoolManager.acquireResource(
>> C3P0PooledConnectionPool.java:203)
>> at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(
>> BasicResourcePool.java:1138)
>> at com.mchange.v2.resourcepool.BasicResourcePool.
>> doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(
>> BasicResourcePool.java:1125)
>> at com.mchange.v2.resourcepool.BasicResourcePool.access$700(
>> BasicResourcePool.java:44)
>> at com.mchange.v2.resourcepool.BasicResourcePool$
>> ScatteredAcquireTask.run(BasicResourcePool.java:1870)
>> at com.mchange.v2.async.ThreadPoolAsynchronousRunner$
>> PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
>>
>> May 10, 2018 8:07:25 AM org.postgresql.Driver connect
>> SEVERE: Connection error:
>> org.postgresql.util.PSQLException: FATAL: the database system is in
>> recovery mode
>> at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(
>> ConnectionFactoryImpl.java:475)
>> at org.postgresql.core.v3.ConnectionFactoryImpl.
>> openConnectionImpl(ConnectionFactoryImpl.java:207)
>> at org.postgresql.core.ConnectionFactory.openConnection(
>> ConnectionFactory.java:49)
>> at org.postgresql.jdbc.PgConnection.(PgConnection.java:195)
>> at org.postgresql.Driver.makeConnection(Driver.java:452)
>> at org.postgresql.Driver.connect(Driver.java:254)
>> at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(
>> DriverManagerDataSource.java:175)
>> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
>> at com.mchange.v2.c3p0.impl.C3P0Po

Re: [Dhis2-users] Trouble running Analytics for 2.29

[Knut Staring]

Enclosing parts of the log - I see a hint  to increase max_wal_size

And also these lines:

2018-05-11 07:03:59 UTC [16449-2] LOG:  server process (PID 18016) was
terminated by signal 9: Killed
2018-05-11 07:03:59 UTC [16449-3] DETAIL:  Failed process was running:
create index "in_uidlevel4_ax_2015_r7jVa" on analytics_temp_2015
("uidlevel4")


On Fri, May 11, 2018 at 1:57 AM, Bob Jolliffe <bobjolli...@gmail.com> wrote:

> It will most likely be a memory issue which gets exhausted at the same
> place each time. The log should be in standard place of
> /var/log/postgreswl/ etc. Not really anything to do with tools.
>
> On Thu, 10 May 2018, 22:00 Knut Staring, <knu...@gmail.com> wrote:
>
>> Thanks Bob, I will try, but where is the postgresql log file in your
>> setup (with dhis2-tools)?
>>
>> The strange thing is that everything else works up until the last part of
>> aggregation. In other words, I can do this again and again,
>>
>> Knut
>>
>> On Thu, May 10, 2018 at 6:19 PM, Bob Jolliffe <bobjolli...@gmail.com>
>> wrote:
>>
>>> Your database has popped 
>>>
>>> To find out why take a look in the postgresql log file around the same
>>> time.
>>>
>>> On Thu, 10 May 2018, 13:51 Knut Staring, <knu...@gmail.com> wrote:
>>>
>>>> Hi all,
>>>>
>>>> Wondering if anyone has a tip for what is going wrong on my serer. I
>>>> just tested running Analytics in 2.29 with the same db on my laptop and
>>>> there were no issues, but everytime I try to do this on the server, it
>>>> gives me the following:
>>>>
>>>>  INFO  2018-05-10 08:06:51,987 [Level: INFO, category: ANALYTICS_TABLE,
>>>> time: Thu May 10 08:06:51 UTC 2018, message: Applying aggregation levels]
>>>> (InMemoryNotifier.java [taskScheduler-14])
>>>> * INFO  2018-05-10 08:07:10,890 Vacuumed tables
>>>> (DefaultAnalyticsTableService.java [taskScheduler-14])
>>>> * INFO  2018-05-10 08:07:10,890 Applied aggregation levels:
>>>> 00:01:54.496 (Clock.java [taskScheduler-14])
>>>> * INFO  2018-05-10 08:07:10,890 [Level: INFO, category:
>>>> ANALYTICS_TABLE, time: Thu May 10 08:07:10 UTC 2018, message: Creating
>>>> indexes] (InMemoryNotifier.java [taskScheduler-14])
>>>> * INFO  2018-05-10 08:07:10,891 No of analytics table indexes: 204
>>>> (DefaultAnalyticsTableService.java [taskScheduler-14])
>>>> May 10, 2018 8:07:25 AM org.postgresql.core.v3.ConnectionFactoryImpl
>>>> log
>>>> WARNING: SQLException occurred while connecting to localhost:5432
>>>> org.postgresql.util.PSQLException: FATAL: the database system is in
>>>> recovery mode
>>>> at org.postgresql.core.v3.ConnectionFactoryImpl.
>>>> doAuthentication(ConnectionFactoryImpl.java:475)
>>>> at org.postgresql.core.v3.ConnectionFactoryImpl.
>>>> openConnectionImpl(ConnectionFactoryImpl.java:207)
>>>> at org.postgresql.core.ConnectionFactory.openConnection(
>>>> ConnectionFactory.java:49)
>>>> at org.postgresql.jdbc.PgConnection.(
>>>> PgConnection.java:195)
>>>> at org.postgresql.Driver.makeConnection(Driver.java:452)
>>>> at org.postgresql.Driver.connect(Driver.java:254)
>>>> at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(
>>>> DriverManagerDataSource.java:175)
>>>> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>>>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>>> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>>>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
>>>> at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$
>>>> 1PooledConnectionResourcePoolManager.acquireResource(
>>>> C3P0PooledConnectionPool.java:203)
>>>> at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(
>>>> BasicResourcePool.java:1138)
>>>> at com.mchange.v2.resourcepool.BasicResourcePool.
>>>> doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(
>>>> BasicResourcePool.java:1125)
>>>> at com.mchange.v2.resourcepool.BasicResourcePool.access$700(
>>>> BasicResourcePool.java:44)
>>>> at com.mchange.v2.resourcepool.BasicResourcePool$
>>>> ScatteredAcquireTask.run(BasicResourcePool.java:1870)
>>>> at com.mchange.v2.a

Re: [Dhis2-users] How can I access dhis2

[Knut Staring]

Some additional information here:
https://www.dhis2.org/hosting

On Fri, May 11, 2018 at 8:24 AM, Morten Olav Hansen <mor...@dhis2.org>
wrote:

> Hi
>
> That depends on what system you are installing it on (windows, linux,
> etc..) but we have some general notes in our implementation guide, please
> have a look
>
> https://docs.dhis2.org/master/en/implementer/html/dhis2_
> implementation_guide.html
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Fri, May 11, 2018 at 11:00 AM, 노성채 <coramdeo@gmail.com> wrote:
>
>> Thank you for your explanation.
>>
>>
>> Now I can access demo site,
>>
>> and could you explain how to make our own server?
>>
>> is there guide for that?
>>
>>
>>
>>
>> Thank you for you kindness
>>
>>
>>
>> Regards
>>
>> Daniel Noh.
>>
>>
>>
>> 2018-05-11 3:59 GMT+02:00 John Lewis <johnlewis.h...@gmail.com>:
>>
>>> Hi ,
>>> I guess you went to http://dhis.org/ Not https://www.dhis2.org/.
>>> Dhis2 is the official site and it is free and open.
>>> John
>>>
>>> On Fri, May 11, 2018 at 08:53, Morten Olav Hansen <mor...@dhis2.org>
>>> wrote:
>>>
>>>> Hi there
>>>>
>>>> Which DHIS2 instance are you talking about? if you are talking about
>>>> our demo servers, they can be accessed by the user admin/district (
>>>> https://play.dhis2.org/2.29).
>>>>
>>>> Other than that, you will need to contact the administrator of your
>>>> instance (I'm not sure what you mean by donated, I hope nobody made you pay
>>>> to use DHIS2)
>>>>
>>>> --
>>>> Morten Olav Hansen
>>>> Senior Engineer, DHIS 2
>>>> University of Oslo
>>>> http://www.dhis2.org
>>>>
>>>> On Fri, May 11, 2018 at 4:23 AM, 노성채 <coramdeo@gmail.com> wrote:
>>>>
>>>>> Hello. All
>>>>>
>>>>> I'd like to use dhis2, but even I made account, when I try to login, I
>>>>> can't access
>>>>> (Even I donated ..)
>>>>>
>>>>>
>>>>> Dose anyone know? How I can login?
>>>>>
>>>>>
>>>>> Please let me know...
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> *Seonghchae NOH *
>>>>> Project Manager
>>>>> Good Neighbors International (Malawi)
>>>>> P.O.Box 30721, Lilongwe 3, Malawi
>>>>> Phone  265-(0)993-672 894
>>>>> Email   coramde...@gni.kr <s...@gni.kr> / coramdeo@gmail.com
>>>>> <sue.gnmal...@gmail.com>
>>>>>
>>>>> GNI is an NGO in General Consultative Status with UN ECOSOC.
>>>>>
>>>>>
>>>>>
>>>>> ___
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to : dhis2-users@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-users@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>
>>
>>
>> --
>> *Seonghchae NOH *
>> Project Manager
>> Good Neighbors International (Malawi)
>> P.O.Box 30721, Lilongwe 3, Malawi
>> Phone  265-(0)993-672 894
>> Email   coramde...@gni.kr <s...@gni.kr> / coramdeo@gmail.com
>> <sue.gnmal...@gmail.com>
>>
>> GNI is an NGO in General Consultative Status with UN ECOSOC.
>>
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Analytics error after upgrade to 2.29

[Knut Staring]

There seems to be a problem with year (it is trying to insert 2015 in a
table that requires 2014). Does anyone have an insight into why this
happens?

Caused by: org.postgresql.util.PSQLException: ERROR: new row for relation
"analytics_completeness_temp_2014" violates check constraint
"analytics_completeness_temp_2014_yearly_check"
  Detail: Failing row contains (null, null, null, null, XbBIPEpxTue,
XbBIPEpxTue, aRxa6o8GqZN, HfVjCurKxh2, t0J75eHKxz5, xLWuQq3DjOR,
iZNVvlnVxm6, ELzS3pnwJyh, null, null, null, null, null, null, null, 2015W1,
null, null, null, null, 2015BiW0, 201501, 201501B, 2015Q1, 2015S1,
2014AprilS2, 2015, 2014April, 2014July, 2014Oct, t, zJrL4HQqYmD,
2015-01-06).
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Unable to load dataelements to create indicators

[Knut Staring]

Hi Allan,

Could you try to clean your browser cache, or use another browser?

Do you see any errors in your server log? Are you using DHIS2 Live?

Knut

On Tue, May 15, 2018 at 2:51 PM, Allan Makunku <amaku...@gmail.com> wrote:

> Hi
>
> Am trying to create indicators for my dhis2 instance but the problem is
> that my dataelements cannot load under edit numerator/denominator section
> in the Indicator feature.
>
> I am using dhis2 live 2.29 with PostgreSQL in the windows environment. Is
> there any thing i can do to get over this. I have alread posted this
> question on the mailing list and awaiting for response.
>
> Regards
>
> Allan
>
>


-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Tracker Capture User roles

[Knut Staring]

If that is the case also on the online demo, please file a JIRA bug.

Knut

On Wed, May 16, 2018 at 12:55 PM, Alex Tumwesigye <atumwesi...@gmail.com>
wrote:

> Hi Prosper,
> They dont work.
> I did setup one and tried to get authorities from old versions. But it
> does not work.
> Alex
>
> On Wednesday, May 16, 2018, Prosper BT <ptb3...@gmail.com> wrote:
>
>> Dear Carlos,
>>
>> Did you add the authority "Add/update tracked entity data value" you can
>> also check the online demo of all authorities assigned to a tracker capture
>> role
>>
>> https://play.dhis2.org/2.29/dhis-web-maintenance-user/showUp
>> dateRoleForm.action?id=1150443
>>
>> Regards
>>
>>
>> Prosper Behumbiize, MPH
>> DHIS2 Implementation Adviser| HISP Uganda
>> pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | Skype:
>> prospertb
>>
>> On Wed, May 16, 2018 at 1:21 AM, Carlos Nyembwe <nyem...@gmail.com>
>> wrote:
>>
>>> Hi All,
>>>
>>> I set up a tracker program but, I don't know exactly which user roles is
>>> usefull for tracker capture.
>>>
>>> I tried many but, Look the message I get:
>>>
>>>
>>>
>>>
>>>
>>> What can I put as user roles?
>>>
>>> Regards
>>>
>>> Carlos
>>> DRC
>>>
>>> --
>>> *Carlos Nyembwe*
>>> *I'm just a Computer Scientist*
>>>
>>> *Skype: carloscnk1*
>>> *Cell: (+243)813166381*
>>> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | 
>>> **Linkedin
>>> <http://www.linkedin.com/in/carloscnk> | Facebook
>>> <https://www.facebook.com/carloscnksys> | Twitter
>>> <https://twitter.com/Carlos_CNK> |*
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
> --
> 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-d...@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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] ERRORS

[Knut Staring]

Hi Alex,

No idea really (and could not see the image you included), but could it be
that you have some funny characters like ' or " etc in some of your orgunit
names? Normally this should not be an issue (it should be catered for),
just something to quickly look for perhaps.

Knut

On Sun, Mar 4, 2018 at 12:35 PM, Alex Macharia <amacha...@gmail.com> wrote:

> Dear dhis2-users,
>
> I have encountered a problem with my local instance and would like your
> assistance into solving this issue. Am not able to use dataentry tables
> reason being that when I select from the Organisation tree on the left, it
> is not updating/reflecting on the right as is supposed to for me to access
> the datasets
>
> and hence do the data entry itself.
>
>
>
> What might be the issue with my local instance? I have also found these
> syntax errors from the page source.
>
>
> “Uncaught SyntaxError: missing ) after argument list
>
> entry.js?_rev=bcf0b5c:24
>
> Uncaught TypeError: Cannot set property 'updateDataElementTotals' of
> undefined
>
> at entry.js?_rev=bcf0b5c:24history.js:229
>
> Uncaught TypeError: Cannot set property 'insertCommentOptionSet' of
> undefined
>
> at history.js:229
> entry.fileresource.js:150
>
> Uncaught SyntaxError: Unexpected identifier   index.action:206
>
> Uncaught ReferenceError: organisationUnitSelected is not definedat
> index.action:206”
>
>
>
> I have deployed DHIS2 version 2.28 on Postgresql 9.6.
>
>
>
> All my datasets have been assigned to organisation units.
>
>
>
> This is a snippet of how it looks after selecting orgunit by name.
>
>
>
> --
> ALEX MACHARIA
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data Not Showing up on Pivot for basic queries

[Knut Staring]

Are you using the same database with 2.29 as with 2.28? Did you run the SQL
upgrade script?

Knut

On Fri, May 18, 2018 at 6:43 PM, Olaleke Seweje <sewejeolal...@gmail.com>
wrote:

> Hi all,
> So I have a DHIS2 deploy that i am just setting up with tables and charts.
> When I create data set and enter data, no matter what I do, the data does
> not show on the analysis tools for data, period and org unit selection.
>
> Interestingly, when I attach a category combination with the data set and
> select the combo in addition to data, period,  org unit, i get data. Though
> the data seems incorrect. Still looking into that.
>
> I have run Analytics export severally, waited 24 hours, cleared
> application and browser caches, checked on a new browser, etc. still no
> data. I am using DHIS 2.29 and I have checked on Chrome, Safari and Firefox.
>
> I tried same set up on DHIS 2.28 that I had and it worked at once.
>
> Does anyone have ideas on this pls? Is this an issue with DHIS 2.29 or is
> there something I need to check??
>
> Thanks
>
>
> --
> Regards,
> Leke Seweje
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs]Error while deleting a data element

[Knut Staring]

I don't know what the issue would be, but have you checked that there is
nothing in the datavalue table with this dataelementid?

Knut

On Wed, Jun 6, 2018 at 12:14 PM Preeti Ajgaonkar 
wrote:

> Hi,
>
> I am receiving a *504-Gateway-Timeout* exception whenever I try to delete
> any of the data elements in DHIS 2.27. The DELETE
> https://hmis-qa.ehealthunit.org/api/27/dataElements/a6a1a84029f call runs
> for a long time and finally fails with the above error in console and 
> '*undefined
> was not deleted*' error in the UI. There is no error in the server log as
> well. Could anyone help me know how to get this issue resolved?
>
> --
> Thanks
> Preeti Ajgaonkar
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Week number

[Knut Staring]

Hi Nada, they are supposed to be ISO, so please give details about how you
saw they seemed not to be:
https://docs.dhis2.org/2.23/en/user/html/ch03s04.html

On Mon, Jun 11, 2018 at 8:51 AM Nada Ghosn  wrote:

> Good morning,
> I realized today that week numbers used by dhis2 are not the ISO ones.
> I will be thankful if you can advice on how to display weeks using the ISO
> weeks (ISO 8601).
> Sincerely
> Nada
>
> --
> Nada Ghosn, MD
> Head, Epidemiology Surveillance Program (Esumoh)
> Ministry of Public Health
> Beirut, Museum square
> Lebanon
> Tel +961.1.614194
> Fax +961.1.610920
> Email esumoh...@gmail.com, esu...@moph.gov.lb
> Website www.moph.gov.lb
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Analytics error in 2.29

[Knut Staring]

Perhaps you could try with the latest build of 2.29, in case this is
related to a bug that was recently fixed:
https://jira.dhis2.org/browse/DHIS2-3844

Knut

On Mon, Jun 11, 2018 at 9:49 AM Barnabas Akumba 
wrote:

> Hello All,
>
> I've been having some issues with Analytics since I upgraded from 2.28 to
> 2.29.
> The scheduled Analytics which is supposed to run at 12:00 midnight always
> fails with the following error (Screen shot):
>
>
> I've always had to drop the analytics table manually using the CASCADE
> option and afterwards have to re-run analytics and it works.
> Has any one experienced this? How can it be solved?
>
> Regards
> --
>
> Barnabas AKUMBA
>
> *Mobile:* +2348036195778
> *Skype:* barnabas.akumba
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Short name as a system setting

[Knut Staring]

There is a lot of value in being able to select "short names" for
analytical outputs like charts and tables, but currently this is a system
setting, i.e. you have to make the decision for EVERYTHING. Would it not
make more sense to specify this PER FAVORITE? And should CODE be a third
option?

To make it a slightly wider discussion, to what extent are people actually
using short names for?

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

Re: [Dhis2-users] [Dhis2-devs] Tracker Capture App not working in DHIS 2.29

[Knut Staring]

The answer is yes.

On Thu, Jun 14, 2018, 2:45 PM Kumar Shahdeo 
wrote:

> Hi All,
>
> I did a migration of DHIS2 from version 2.27 -> 2.28 -> 2.29.
> The tracker capture app is not loading properly and is throwing console
> error
>
> "*TypeError: Cannot read property 'id' of undefined*
> *at n.$scope.hasProgramTetAccess (home-controller.js:264*)"
>
> I find that the object store 'trackedEntityTypes' has no data in indexed
> DB.
> I have cleared all the browser cache and have tried opening DHIS in
> multiple browsers. I am getting same error every time.
> It was an incremental upgrade and I have not used the upgrade script
> provided by DHIS.
> What can be the possible reason behind this?
> Do I need to use upgrade script even if I do an incremental upgrade?
>
> --
> Kumar Gaurav Nath Shahdeo
> Developer
> Email gaura...@thoughtworks.com
> Telephone +91 9160688935
> [image: ThoughtWorks]
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] User manuals translation?

[Knut Staring]

I guess it is mainly the DHIS2 special vocabulary and the screenshot that
are missing from here
<https://translate.google.com/translate?sl=en=fr=y=_t=en=UTF-8=https%3A%2F%2Fdocs.dhis2.org%2Fmaster%2Fen%2Fuser%2Fhtml%2Fdhis2_user_manual_en.html=>

Knut

On Wed, Jun 13, 2018 at 10:30 AM Martin Van Aken 
wrote:

> Thanks, I understand the effort needed and most technical profile I know
> can read english, so I suppose this is both huge and difficult to priorise.
> A sort of "stupid" id - could we not start by putting the whole manual (or
> the various XML parts) through google translate as a basis, and accept
> contributions from that point? I tested it, it is surprinsingly good.
>
> Martin
>
> On Wed, Jun 13, 2018 at 8:16 AM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Martin,
>> Unfortunately, that version of the manual is extremely out of date and
>> incomplete. It has not been updated in a number of years.
>>
>> The translation process is currently a community driven one, with limited
>> support from the core team. The core team maintains a translation server (
>> https://translate.dhis2.org) for the software.
>>
>> Community contributions would certainly be welcome and if there are
>> specific questions about how to get started, please let me know.
>>
>> Regards,
>> Jason
>>
>>
>> On Wed, Jun 13, 2018 at 7:53 AM Martin Van Aken 
>> wrote:
>>
>>> Hi,
>>> Some of our users are French speaking, and while I know the interface is
>>> translated, are some of the doc (user or even implementer manual) available
>>> in French somewhere?
>>>
>>> I though not then found a GitHub repo here:
>>> https://github.com/dhis2/dhis2-docs-fr but I'm unsure about the status
>>> (one year old is not that bad if needed).
>>>
>>> Is there a goal to drive such an effort, possibly community driven?
>>>
>>> Martin
>>> --
>>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>>
>>> Mobile : +32 486 899 652
>>>
>>> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken>
>>> Call me on Skype : vanakenm
>>> Hang out with me : mar...@joyouscoding.com
>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>>> Company website : www.joyouscoding.com
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049
>>
>
>
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken>
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Error while opening Tracker capture in DHIS2.29

[Knut Staring]

You did do the intermediate upgrade to 2.28?

On Thu, May 31, 2018 at 9:42 AM Kumar Shahdeo 
wrote:

> HI Dhis2 Users/Devs
>
> I have recently migrated from DHIS 2.27 to DHIS 2.29. I ran the upgrade
> script provided by DHIS for 2.29 upgrade on my existing 2.27 DB.
> I am able to run DHIS 2.29, However, I am getting some issues with tracker
> capture app.
> I am getting this error on console when I open tracker capture app :
>
>
> *" Cannot set property 'programTrackedEntityAttribute' of undefined " *
>
> Can you please point me to what is issue with this ?
>
> --
> Kumar Gaurav Nath Shahdeo
> Developer
> Email gaura...@thoughtworks.com
> Telephone +91 9160688935 <+91+9160688935>
> [image: ThoughtWorks]
> <http://www.thoughtworks.com/?utm_campaign=kumar-gaurav%20nath%20shahdeo-signature_medium=email_source=thoughtworks-email-signature-generator>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Error while opening Tracker capture in DHIS2.29

[Knut Staring]

That could be a possible source of your problem then

On Thu, May 31, 2018, 10:49 AM Kumar Shahdeo 
wrote:

> No I have not done an intermediate upgrade to 2.28. I used the upgrade
> script in existing 2.27 db that I had to move directly to 2.29
>
> On Thu, May 31, 2018 at 1:21 PM, Knut Staring  wrote:
>
>> You did do the intermediate upgrade to 2.28?
>>
>> On Thu, May 31, 2018 at 9:42 AM Kumar Shahdeo 
>> wrote:
>>
>>> HI Dhis2 Users/Devs
>>>
>>> I have recently migrated from DHIS 2.27 to DHIS 2.29. I ran the upgrade
>>> script provided by DHIS for 2.29 upgrade on my existing 2.27 DB.
>>> I am able to run DHIS 2.29, However, I am getting some issues with
>>> tracker capture app.
>>> I am getting this error on console when I open tracker capture app :
>>>
>>>
>>> *" Cannot set property 'programTrackedEntityAttribute' of undefined " *
>>>
>>> Can you please point me to what is issue with this ?
>>>
>>> --
>>> Kumar Gaurav Nath Shahdeo
>>> Developer
>>> Email gaura...@thoughtworks.com
>>> Telephone +91 9160688935 <+91+9160688935>
>>> [image: ThoughtWorks]
>>> <http://www.thoughtworks.com/?utm_campaign=kumar-gaurav%20nath%20shahdeo-signature_medium=email_source=thoughtworks-email-signature-generator>
>>> _______
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
>> Skype: knutstar
>>
>
>
>
> --
> Kumar Gaurav Nath Shahdeo
> Developer
> Email gaura...@thoughtworks.com
> Telephone +91 9160688935 <+91+9160688935>
> [image: ThoughtWorks]
> <http://www.thoughtworks.com/?utm_campaign=kumar-gaurav%20nath%20shahdeo-signature_medium=email_source=thoughtworks-email-signature-generator>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] EPI week(Start Saturday) - display week number in visual

[Knut Staring]

Looks like a bug, can you recreate this on https://play.dhis2.org/2.29 and
file an issue on https://jira.dhis2.org ?

Regards,
Knut

On Sun, Jun 3, 2018 at 10:02 AM Peter D Lubambi  wrote:

> Hi All,
> I am experiencing this problem of display, it displays same week number
> for different weeks in visualization  - anyone else experienced this? How
> do you handle it, it confuses users. see image below
>
>
>
>
> Regards,
>
> Peter Dotto Lubambi,
> Skype: plubambi
> Mobile: +255 786 087 087
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] EPI week(Start Saturday) - display week number in visual

[Knut Staring]

Thanks Nayeem - this possibility is why I recommended he try it on the
latest demo instance.

On Sun, Jun 3, 2018 at 5:47 PM Nayeem Al Mifthah 
wrote:

> Dear Knut and Peter
> This bug has already reported and already solved.
>
> Peter, you may upgrade with latest war file.
>
> *Nayeem Al Mifthah*
> *Health Information Systems Specialist*
> Support to the National HMIS
> MIS, Directorate General of Health Services, Ministry of Health and Family
> Welfare, Bangladesh
> Telephone: +880-2-58816459|Fax: +880-2-58813875|Mobile:
>  +88-01914 030 574
> Email: n.mift...@gmail.com|Skype: nayeem.a.m|   LinkedIn:
> linkedin.com/in/nayeemam
> ​
>
> On Sun, Jun 3, 2018 at 7:21 PM, Knut Staring  wrote:
>
>> Looks like a bug, can you recreate this on https://play.dhis2.org/2.29
>> and file an issue on https://jira.dhis2.org ?
>>
>> Regards,
>> Knut
>>
>> On Sun, Jun 3, 2018 at 10:02 AM Peter D Lubambi 
>> wrote:
>>
>>> Hi All,
>>> I am experiencing this problem of display, it displays same week number
>>> for different weeks in visualization  - anyone else experienced this? How
>>> do you handle it, it confuses users. see image below
>>>
>>>
>>>
>>>
>>> Regards,
>>>
>>> Peter Dotto Lubambi,
>>> Skype: plubambi
>>> Mobile: +255 786 087 087
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
>> Skype: knutstar
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] CAN NOT ADD DATA ELEMENTS TO A DATA SET

[Knut Staring]

Do you see the same problem in the online demo?

On Wed, Jun 6, 2018, 8:55 AM Stanley Kalyati  wrote:

> I am using dhis2 version 2.29.I have just noticed that i can not add new
> data elements to my data set.It keeps telling me that "Could not Save Data
> Set".
>
> Has anyone experienced this? If so what is the cause?
>
> Its urgent.
>
> Thank you
>
> Stanley
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS2 Local Installation.

[Knut Staring]

Just download dhis2-live, unzip and start it with "java -jar dhis2-live.jar"

On Sat, Jun 23, 2018, 9:27 AM Alex Kimeu  wrote:

> Hello...
> Am trying to install DHIS2 locallly on my Ubuntu 17.10 installation. I
> followed the steps outlined in the documentation. However, when I switch
> over to the DHIS2 instance and login, the terminal won't start. Am a newbie.
>
> Kindly assist!
> Regards!
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Fwd: [AeHIN-ORG] Launch of WHO Classification of Digital Health Interventions v1.0

[Knut Staring]

-- Forwarded message --
From: MEHL, Garrett Livingston <me...@who.int>
Date: Wed, Apr 25, 2018 at 12:47 PM
Subject: [AeHIN-ORG] Launch of WHO Classification of Digital Health
Interventions v1.0
To: "aehin-...@listserv.aehin.net" <aehin-...@listserv.aehin.net>
Cc: "ZANDI, Diana" <zan...@who.int>, "SAY, Lale" <s...@who.int>, "TAMRAT,
Tigest" <tamr...@who.int>, "KELLEY, Edward Talbott" <kell...@who.int>


Dear AEHIN Colleagues,


Apologies for the cross posting.


It gives me great pleasure to Announce the Launch of the *World Health
Organization Classification of Digital Health Interventions v1.0*: A shared
language to describe the uses of digital technology for health.


Please find PDF versions of the publication and associated classifications
“poster” here:

http://www.who.int/reproductivehealth/publications/mhealth/
classification-digital-health-interventions/en/


The classification of digital health interventions (DHIs) categorizes the
different ways in which digital and mobile technologies are being used to
support health system needs. Targeted primarily at public health audiences,
this Classification framework aims to promote an accessible and bridging
language between technologists and those in health, to facilitate
discussions and ways of articulating needs, as well as to describe
functionalities represented in digital health system implementations. This
document serves as a prelude to the upcoming WHO Guidelines on Digital
Health Interventions for Health Systems, providing the underlying framework
of units for evidence analysis and synthesis, and upon which formal
recommendations will be made. Furthermore, the classification content
aligns with the structure of the global registry of technology
implementations for health, the Digital Health Atlas —
www.digitalhealthatlas.org — for registering, monitoring, and inventorying
digital solutions and implementations within countries.


The WHO Classifications of Digital Health Interventions v1.0 is the result
of a multi-year process of development and refinement guided by a panel of
global experts, including those from the Health Data Collaborative Digital
Health and Interoperability Working Group. WHO is grateful for their
extensive contributions that led to this release. As this is a versioned
document, we encourage those with recommended improvements and additions,
to please provide feedback to Dr Garrett Mehl (me...@who.int) and Tigest
Tamrat (tamr...@who.int). Periodically, new versions will be released.



We hope the Classifications document brings greater clarity of
understanding among the diversity of stakeholders who contribute to
ensuring the benefits of digital health are for all.


On behalf of staff from the WHO Departments of Reproductive Health and
Research, and Service Delivery and Safety who coordinated the development
of the document, Thank you,


Garrett





___

Garrett Mehl, PhD, MHS

Scientist, Digital Health Research

Department of Reproductive Health and Research, includes

HRP - the UNDP/UNFPA/UNICEF/WHO/World Bank Special Programme of Research in
Human Reproduction

World Health Organization

20 Avenue Appia

Geneva 1211

Switzerland




___
AeHIN-ORG mailing list
aehin-...@listserv.aehin.net
http://listserv.aehin.net/listinfo.cgi/aehin-org-aehin.net




-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Populating data from Excel to DHIS2 Data Entry Web Form with Internet Explorer

[Knut Staring]

Given the widespread knowledge of VBA coupled with the huge trove of legacy
data in Excel and the continued use of Excel for offline data collection,
it could be nice to add an appendix to the documentation with code snippets
to import data directly from Excel to the API, in addition to the R
documentation (munging?).

Perhaps it is something you could be interesting in developing and sharing,
Damasceno?

Cheers,
Knut

On Thu, Oct 26, 2017 at 4:55 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> You may also want to consider just making the HTTP request, instead of
> working with the form itself
>
> https://support.microsoft.com/en-us/help/301102/how-to-make-
> a-get-request-by-using-visual-basic--net-or-visual-basic-2
>
> The DHIS2 dataValue API is documented in here
> <https://docs.dhis2.org/master/en/developer/html/webapi_data_values.html>
> in "Section 1.19.7. Sending, reading and deleting individual data values"
>
> Regards,
> Jason
>
>
> On Thu, Oct 26, 2017 at 4:18 PM, Damasceno Lopes <
> damascenolop...@gmail.com> wrote:
>
>> Hi!
>>
>>
>>
>> I’m trying to populate data from Excel to  DHIS2 Data Entry Web Form
>> using VBA code in Excel with Internet Explorer, the data goes to form but
>> not persisted to database. Anyone already try to do that?
>>
>>
>>
>> The VBA code, tested to fill form in the demo instance:
>>
>>
>>
>> 'Before run this Macro make sure to login into dhis2-demo using Internet
>> Explorer
>>
>> Sub FillInternetForm()
>>
>> Dim IE As Object
>>
>>
>>
>> Set IE = CreateObject("InternetExplorer.Application")
>>
>>
>>
>> IE.Navigate "https://play.dhis2.org/demo/dhis-web-dataentry/index.action;
>>
>> IE.Visible = True
>>
>>
>>
>> While IE.busy
>>
>> DoEvents 'wait until IE is done loading page.
>>
>> Wend
>>
>>
>>
>> 'You have 30 seconds to choose Orgunit, form and period
>>
>> 'Eg. Sierra Leone, Emergency Response, Result
>>
>> Application.Wait Now + TimeValue("00:00:30")
>>
>>
>>
>> 'Populating Data to two first fields
>>
>> IE.document.getElementById("KFnFpbqDqji-bRowv6yZOF2-val").Focus
>>
>> IE.document.getElementById("KFnFpbqDqji-bRowv6yZOF2-val").Value = "20"
>>
>> Application.Wait Now + TimeValue("00:00:02")
>>
>> IE.document.getElementById("zFFb3bar4Ct-bRowv6yZOF2-val").Focus
>>
>> IE.document.getElementById("zFFb3bar4Ct-bRowv6yZOF2-val").Value = "30"
>>
>>
>>
>> End Sub
>>
>>
>>
>> The result:
>>
>>
>>
>>
>>
>> The Data goes to the field but not persisted, the field don’t change
>> color.
>>
>> I appreciate your help if you can provide.
>>
>>
>>
>> Thank you
>>
>> *Damasceno Lopes,  MSc*
>>
>> *Health Information System Officer*
>>
>> Friends in Global Health, Mozambique
>>
>> *+258844626770 <+258%2084%20462%206770>*  | *+258829502145
>> <damasceno.lo...@fgh.org.mz>*
>>
>> [image: FGH]
>>
>>
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46%2076%20414%2070%2049>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Preserving DHIS2 instance (or format for export)?

[Knut Staring]

I think Romain is correct. But if you also have apps, you may want to
preserve a copy of those also.

On Mon, Jan 8, 2018, 16:58 rom...@tohouri.com  wrote:

> I think creating a backup of your database, the dhis2.conf file and your
> war file should be enough to ensure your able to restore it later. If you
> want more maybe you could consider taking a snapshot of your VM.
>
> Hope its helps,
>
> Romain
>
> On Jan 8, 2018, at 10:53, Karen Levin  wrote:
>
> Hello – am wondering if anyone has experiencing with
> preservation/archiving a DHIS2 instance once a project has ended?
>
> When our project ends, hosting cost support will no longer be available
> but we would like to ensure that the data contained in our DHIS2 instance
> remains somehow useable/accessible to others.  Does anyone have experience
> with the best approach to doing this?
>
> Many thanks in advance,
> Karen Levin
> ___
>
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] track activity of specific users?

[Knut Staring]

For the login you can harvest and filter  the Tomcat log.

Knut

On Jan 3, 2018 9:19 PM, "Natalie Tibbels"  wrote:

Hi all,
Is there a way to see which users *log in* to a DHIS2 instance and when?
Also, is there a way to see which users *enter* what data (e.g. register
people in tracker, capture events, etc)?

The metadata does not seem to be capturing this automatically.

~Natalie


---
*Natalie Tibbels, MSPH*
410.370.5048 <(410)%20370-5048> (cell) • natalietib (Skype)
Johns Hopkins Bloomberg School of Public Health
Center for Communication Programs • ccp.jhu.edu





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

Re: [Dhis2-users] [Dhis2-fr] Problem with setting indicator containing OU group

[Knut Staring]

Hi Carlos,

Please share the server log.

Regards,
Knut

On Tue, Jan 9, 2018 at 12:22 PM, Carlos Nyembwe <nyem...@gmail.com> wrote:

> Hi Knut, I did in demo online the same problem
>
> Regards
>
> On Fri, Nov 24, 2017 at 2:48 PM, Knut Staring <knu...@gmail.com> wrote:
>
>> Hello Carlos,
>> Please share the server log.
>>
>> Regards,
>> Knut
>>
>> On Nov 24, 2017 3:45 PM, "Carlos Nyembwe" <nyem...@gmail.com> wrote:
>>
>>> Hi All,
>>>
>>> No solution since now?
>>>
>>> We have big problem with our analysis
>>>
>>> Thanks for your interest
>>>
>>> On Wed, Nov 22, 2017 at 12:16 PM, Knut Staring <knu...@gmail.com> wrote:
>>>
>>>> Hi Carlos,
>>>> When the system seems to take very long, there is usually an error
>>>> message in the server log.
>>>>
>>>> Knut
>>>>
>>>> On Nov 22, 2017 2:07 PM, "Carlos Nyembwe" <nyem...@gmail.com> wrote:
>>>>
>>>>> Hi All,
>>>>>
>>>>> I find something strange in our System and in dhis2 demo on 2.27
>>>>>
>>>>> When I set up a  indicator containing OU group, and in pivot table
>>>>> when I need to display the result, putting OU as raw, the system is 
>>>>> running
>>>>> indefinitly
>>>>>
>>>>> [image: Inline image 1]
>>>>>
>>>>>
>>>>> There is a problem or what?
>>>>>
>>>>> Regards
>>>>>
>>>>> --
>>>>> *Carlos Nyembwe*
>>>>> *I'm just a Computer Scientist*
>>>>>
>>>>> *Skype: carloscnk1*
>>>>> *Cell: (+243)813166381 <+243%20813%20166%20381>*
>>>>> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | 
>>>>> **Linkedin
>>>>> <http://www.linkedin.com/in/carloscnk> | Facebook
>>>>> <https://www.facebook.com/carloscnksys> | Twitter
>>>>> <https://twitter.com/Carlos_CNK> |ega*
>>>>>
>>>>> --
>>>>> Mailing list: https://launchpad.net/~dhis2-fr
>>>>> Post to : dhis2...@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-fr
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>
>>>
>>> --
>>> *Carlos Nyembwe*
>>> *I'm just a Computer Scientist*
>>>
>>> *Skype: carloscnk1*
>>> *Cell: (+243)813166381 <+243%20813%20166%20381>*
>>> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | 
>>> **Linkedin
>>> <http://www.linkedin.com/in/carloscnk> | Facebook
>>> <https://www.facebook.com/carloscnksys> | Twitter
>>> <https://twitter.com/Carlos_CNK> |*
>>>
>>
>
>
> --
> *Carlos Nyembwe*
> *I'm just a Computer Scientist*
>
> *Skype: carloscnk1*
> *Cell: (+243)813166381 <+243%20813%20166%20381>*
> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | 
> **Linkedin
> <http://www.linkedin.com/in/carloscnk> | Facebook
> <https://www.facebook.com/carloscnksys> | Twitter
> <https://twitter.com/Carlos_CNK> |*
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Issue with Maintenance app

[Knut Staring]

Hello Aljosa,

Here is the error message you get, which looks like it has to do with your
server setup - I hope someone else on the list can chime in here:

Mixed Content: The page (maintenance-73664ca02303e………) was loaded over
HTTPS, but requested an insecure XMLHttpRequest endpoint. This request has
been blocked; the content must be served over HTTPS.

Also, I think you have not shared your Tomcat log with us yet?

Regards,
Knut

On Fri, Jan 12, 2018 at 1:45 PM, Aljosa Celebic <aljosa.cele...@lih.lu>
wrote:

> We are you running DHIS2 on a server (actually 2 servers, the tomcat
> server in a DMZ, the postgresql server on the LAN)
>
> Both are linux servers
>
> Yes, using tomcat as indicated in the install guide.
>
>
>
> Thank you.
>
>
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* vendredi 12 janvier 2018 09:12
> *To:* Aljosa Celebic <aljosa.cele...@lih.lu>; DHIS 2 Users list <
> dhis2-users@lists.launchpad.net>
> *Subject:* Re: [Dhis2-users] Issue with Maintenance app
>
>
>
> Hi Aljosa, let me copy this back on the mailing list so others can come
> with suggestions too.
>
>
>
> No this is not normal, you should see all that you have in the other
> screenshot, so there is probably something wrong with your database.
>
>
>
> The next places to check are the browser console and the server log.
>
>
>
> 1) In Chrome, click on Ctrl+Shit+I to open the console window and look for
> error messages in RED.
>
>
>
> 2) For the server, look for catalina.out in the logs folder (are  you
> using Tomcat or DHIS Live?). Operating system?
>
>
>
> Knut
>
>
>
>
>
> On Fri, Jan 12, 2018 at 9:06 AM, Aljosa Celebic <aljosa.cele...@lih.lu>
> wrote:
>
> Hi Knut,
>
>
>
> I tried with Chrome but I have the same problem.
>
>
>
> I also tried "Browser Cache Cleaner" and "Incognito window", this change
> nothing.
>
>
>
> Is it normal that I have nothing in Maintenance app?
>
>
>
> Thanks
>
>
>
> Aljosa
>
>
>
>
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* jeudi 11 janvier 2018 18:41
> *To:* Aljosa Celebic <aljosa.cele...@lih.lu>
>
>
> *Subject:* Re: [Dhis2-users] Issue with Maintenance app
>
>
>
> Can you try with Chrome?
>
>
>
> K
>
>
>
> On Thu, Jan 11, 2018 at 4:33 PM, Aljosa Celebic <aljosa.cele...@lih.lu>
> wrote:
>
> Dear Knut,
>
>
>
> Thank you for your answer.
>
> Version is 2.28., we have installed it a week ago.
>
>
>
> Could you confirm that in all cases, opening the Maintenance I’m supposed
> to see this window, with many sheets, like ALL, CATEGORY, DATA ELEMENTS,
> and so on…. :
>
>
>
> [image: cid:image001.jpg@01D38BAB.65D65490]
>
>
>
> But this is the window that I have :
>
>
>
> [image: cid:image002.jpg@01D38BAB.65D65490]
>
>
>
> I use Mozilla Firefox, I read that Mozilla is recommended.
>
>
>
> Should I still try your previous advice?
>
> Thank you!
>
>
>
> Kind regards.
>
> AC
>
>
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* jeudi 11 janvier 2018 16:16
> *To:* Aljosa Celebic <aljosa.cele...@lih.lu>
> *Cc:* dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Issue with Maintenance app
>
>
>
> Hello Aljosa,
>
>
>
> Try cleaning your browser cache by selecting "Browser Cache Cleaner" from
> the menu. You can also open an Incognito window in Chrome (or are you using
> a different browser?)
>
>
>
> If this does not help, you should take a look at your Chrome browser
> console for any error messages.
>
>
>
> Which version of DHIS2?
>
>
>
> Knut
>
>
>
> On Thu, Jan 11, 2018 at 4:05 PM, Aljosa Celebic <aljosa.cele...@lih.lu>
> wrote:
>
> Hi, When I open Maintenance app I’m supposed to find Data Elements,
> Organisation Unit building tools… but the only thing that appear is
> Metadata group editor.
>
> Have I missed something before starting to create the entry forms for my
> new project?
>
> Thank you for your help. Kind regards.
>
> AC
>
>
>
> Aljosa Celebic
> Data Manager, Competence Center for Methodology and Statistics
>
> *Luxembourg Institute of Health*
> General Management
> 1A-B, rue Thomas Edison,
> <https://maps.google.com/?q=1A-B,+rue+Thomas+Edison,%C2%A0L-1445+Strassen+%0D+Luxembourg=gmail=g>
>  L-1445 Strassen
> <https://maps.google.com/?q=1A-B,+rue+Thomas+Edison,%C2%A0L-1445+Strassen+%0D+Luxembourg=gmail=g>
> Luxembourg
> Tel: +352 26970

[Dhis2-users] Fwd: Issue with Maintenance app

[Knut Staring]

-- Forwarded message --
From: Aljosa Celebic <aljosa.cele...@lih.lu>
Date: Fri, Jan 12, 2018 at 9:30 AM
Subject: RE: [Dhis2-users] Issue with Maintenance app
To: Knut Staring <knu...@gmail.com>


Thank you for copying the message on the mailing list.



To answer your question 1) I have this RED error message :

Mixed Content: The page (maintenance-73664ca02303e………) was loaded over
HTTPS, but requested an insecure XMLHttpRequest endpoint. This request has
been blocked; the content must be served over HTTPS.

For question 2) I will answer you later.



Aljosa



*From:* Knut Staring [mailto:knu...@gmail.com]
*Sent:* vendredi 12 janvier 2018 09:12
*To:* Aljosa Celebic <aljosa.cele...@lih.lu>; DHIS 2 Users list <
dhis2-users@lists.launchpad.net>
*Subject:* Re: [Dhis2-users] Issue with Maintenance app



Hi Aljosa, let me copy this back on the mailing list so others can come
with suggestions too.



No this is not normal, you should see all that you have in the other
screenshot, so there is probably something wrong with your database.



The next places to check are the browser console and the server log.



1) In Chrome, click on Ctrl+Shit+I to open the console window and look for
error messages in RED.



2) For the server, look for catalina.out in the logs folder (are  you using
Tomcat or DHIS Live?). Operating system?



Knut





On Fri, Jan 12, 2018 at 9:06 AM, Aljosa Celebic <aljosa.cele...@lih.lu>
wrote:

Hi Knut,



I tried with Chrome but I have the same problem.



I also tried "Browser Cache Cleaner" and "Incognito window", this change
nothing.



Is it normal that I have nothing in Maintenance app?



Thanks



Aljosa







*From:* Knut Staring [mailto:knu...@gmail.com]
*Sent:* jeudi 11 janvier 2018 18:41
*To:* Aljosa Celebic <aljosa.cele...@lih.lu>


*Subject:* Re: [Dhis2-users] Issue with Maintenance app



Can you try with Chrome?



K



On Thu, Jan 11, 2018 at 4:33 PM, Aljosa Celebic <aljosa.cele...@lih.lu>
wrote:

Dear Knut,



Thank you for your answer.

Version is 2.28., we have installed it a week ago.



Could you confirm that in all cases, opening the Maintenance I’m supposed
to see this window, with many sheets, like ALL, CATEGORY, DATA ELEMENTS,
and so on…. :



[image: cid:image001.jpg@01D38B86.F5060F90]



But this is the window that I have :



[image: cid:image002.jpg@01D38B86.F5060F90]



I use Mozilla Firefox, I read that Mozilla is recommended.



Should I still try your previous advice?

Thank you!



Kind regards.

AC





*From:* Knut Staring [mailto:knu...@gmail.com]
*Sent:* jeudi 11 janvier 2018 16:16
*To:* Aljosa Celebic <aljosa.cele...@lih.lu>
*Cc:* dhis2-users@lists.launchpad.net
*Subject:* Re: [Dhis2-users] Issue with Maintenance app



Hello Aljosa,



Try cleaning your browser cache by selecting "Browser Cache Cleaner" from
the menu. You can also open an Incognito window in Chrome (or are you using
a different browser?)



If this does not help, you should take a look at your Chrome browser
console for any error messages.



Which version of DHIS2?



Knut



On Thu, Jan 11, 2018 at 4:05 PM, Aljosa Celebic <aljosa.cele...@lih.lu>
wrote:

Hi, When I open Maintenance app I’m supposed to find Data Elements,
Organisation Unit building tools… but the only thing that appear is
Metadata group editor.

Have I missed something before starting to create the entry forms for my
new project?

Thank you for your help. Kind regards.

AC



Aljosa Celebic
Data Manager, Competence Center for Methodology and Statistics

*Luxembourg Institute of Health*
General Management
1A-B, rue Thomas Edison,
<https://maps.google.com/?q=1A-B,+rue+Thomas+Edison,%C2%A0L-1445+Strassen+%0D+Luxembourg=gmail=g>
 L-1445 Strassen
<https://maps.google.com/?q=1A-B,+rue+Thomas+Edison,%C2%A0L-1445+Strassen+%0D+Luxembourg=gmail=g>
Luxembourg
Tel: +352 26970-399 <+352%2026%2097%2003%2099>
Fax: +352 26970-719 <+352%2026%2097%2007%2019>
Email: aljosa.cele...@lih.lu
Website: https://www.lih.lu



[image: http://files.lih.lu/outlookSignature/lih_cert.jpg]


Join us on Facebook and follow our activities on Twitter:
https://www.facebook.com/Luxembourg.Institute.of.Health
http://twitter.com/LIH_Luxembourg
aljosa.cele...@lih.lu

This message (including any attachments) is intended for the addressee only
and may contain confidential and/or privileged information and/or
information protected by intellectual property rights. If you have received
this message  by mistake, please notify the sender by return e-mail and
delete this message from your system. You should not use, alter, copy or
distribute this message or disclose its contents to anyone. E-mail
transmission can not be guaranteed to be secure or error free as
information could be intercepted, corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses. Luxembourg Institute of Health shall not
be responsible nor liable for the 

[Dhis2-users] Has metadata import stopped working?

[Knut Staring]

I have tried doing metadata export without sharing from 2.27 and importing
into 2.27, just the OU hierarchy and levels.

Importing into a clean instance gives this:

 INFO  2018-01-11 20:16:06,750 [Level: INFO, category: METADATA_IMPORT,
time: Thu Jan 11 20:16:06 CET 2018, message: (admin) Creating 8 object(s)
of type OrganisationUnitLevel] (InMemoryNotifier.java [taskScheduler-4])
* ERROR 2018-01-11 20:16:07,764 Unexpected error occurred in scheduled
task. (TaskUtils.java [taskScheduler-4])
org.hibernate.TransientObjectException: object references an unsaved
transient instance - save the transient instance before flushing:
org.hisp.dhis.organisationunit.OrganisationUnit
at
org.hibernate.engine.internal.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:279)
at org.hibernate.type.EntityType.getIdentifier(EntityType.java:462)
at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:281)
at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:291)
at org.hibernate.type.TypeHelper.findDirty(TypeHelper.java:322)
at
org.hibernate.persister.entity.AbstractEntityPersister.findDirty(AbstractEntityPersister.java:4204)
at
org.hibernate.event.internal.DefaultFlushEntityEventListener.dirtyCheck(DefaultFlushEntityEventListener.java:528)
at
org.hibernate.event.internal.DefaultFlushEntityEventListener.isUpdateNecessary(DefaultFlushEntityEventListener.java:215)
at
org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:142)
at
org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:216)
at
org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:85)
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:38)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
at
org.hisp.dhis.dbms.HibernateDbmsManager.clearSession(HibernateDbmsManager.java:339)
at
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.commit(DefaultObjectBundleService.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy189.commit(Unknown Source)
at
org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.importMetadata(DefaultMetadataImportService.java:127)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy191.importMetadata(Unknown Source)
at

Re: [Dhis2-users] Issue with Maintenance app

[Knut Staring]

Hi Aljosa, let me copy this back on the mailing list so others can come
with suggestions too.

No this is not normal, you should see all that you have in the other
screenshot, so there is probably something wrong with your database.

The next places to check are the browser console and the server log.

1) In Chrome, click on Ctrl+Shit+I to open the console window and look for
error messages in RED.

2) For the server, look for catalina.out in the logs folder (are  you using
Tomcat or DHIS Live?). Operating system?

Knut


On Fri, Jan 12, 2018 at 9:06 AM, Aljosa Celebic <aljosa.cele...@lih.lu>
wrote:

> Hi Knut,
>
>
>
> I tried with Chrome but I have the same problem.
>
>
>
> I also tried "Browser Cache Cleaner" and "Incognito window", this change
> nothing.
>
>
>
> Is it normal that I have nothing in Maintenance app?
>
>
>
> Thanks
>
>
>
> Aljosa
>
>
>
>
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* jeudi 11 janvier 2018 18:41
> *To:* Aljosa Celebic <aljosa.cele...@lih.lu>
>
> *Subject:* Re: [Dhis2-users] Issue with Maintenance app
>
>
>
> Can you try with Chrome?
>
>
>
> K
>
>
>
> On Thu, Jan 11, 2018 at 4:33 PM, Aljosa Celebic <aljosa.cele...@lih.lu>
> wrote:
>
> Dear Knut,
>
>
>
> Thank you for your answer.
>
> Version is 2.28., we have installed it a week ago.
>
>
>
> Could you confirm that in all cases, opening the Maintenance I’m supposed
> to see this window, with many sheets, like ALL, CATEGORY, DATA ELEMENTS,
> and so on…. :
>
>
>
>
>
> But this is the window that I have :
>
>
>
>
>
> I use Mozilla Firefox, I read that Mozilla is recommended.
>
>
>
> Should I still try your previous advice?
>
> Thank you!
>
>
>
> Kind regards.
>
> AC
>
>
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* jeudi 11 janvier 2018 16:16
> *To:* Aljosa Celebic <aljosa.cele...@lih.lu>
> *Cc:* dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Issue with Maintenance app
>
>
>
> Hello Aljosa,
>
>
>
> Try cleaning your browser cache by selecting "Browser Cache Cleaner" from
> the menu. You can also open an Incognito window in Chrome (or are you using
> a different browser?)
>
>
>
> If this does not help, you should take a look at your Chrome browser
> console for any error messages.
>
>
>
> Which version of DHIS2?
>
>
>
> Knut
>
>
>
> On Thu, Jan 11, 2018 at 4:05 PM, Aljosa Celebic <aljosa.cele...@lih.lu>
> wrote:
>
> Hi, When I open Maintenance app I’m supposed to find Data Elements,
> Organisation Unit building tools… but the only thing that appear is
> Metadata group editor.
>
> Have I missed something before starting to create the entry forms for my
> new project?
>
> Thank you for your help. Kind regards.
>
> AC
>
>
>
> Aljosa Celebic
> Data Manager, Competence Center for Methodology and Statistics
>
> *Luxembourg Institute of Health*
> General Management
> 1A-B, rue Thomas Edison,
> <https://maps.google.com/?q=1A-B,+rue+Thomas+Edison,%C2%A0L-1445+Strassen+%0D+Luxembourg=gmail=g>
>  L-1445 Strassen
> <https://maps.google.com/?q=1A-B,+rue+Thomas+Edison,%C2%A0L-1445+Strassen+%0D+Luxembourg=gmail=g>
> Luxembourg
> Tel: +352 26970-399 <+352%2026%2097%2003%2099>
> Fax: +352 26970-719 <+352%2026%2097%2007%2019>
> Email: aljosa.cele...@lih.lu
> Website: https://www.lih.lu
>
>
>
>
> Join us on Facebook and follow our activities on Twitter:
> https://www.facebook.com/Luxembourg.Institute.of.Health
> http://twitter.com/LIH_Luxembourg
> aljosa.cele...@lih.lu
>
> This message (including any attachments) is intended for the addressee
> only and may contain confidential and/or privileged information and/or
> information protected by intellectual property rights. If you have received
> this message  by mistake, please notify the sender by return e-mail and
> delete this message from your system. You should not use, alter, copy or
> distribute this message or disclose its contents to anyone. E-mail
> transmission can not be guaranteed to be secure or error free as
> information could be intercepted, corrupted, lost, destroyed, arrive late
> or incomplete, or contain viruses. Luxembourg Institute of Health shall not
> be responsible nor liable for the proper and complete transmission of the
> information contained in this communication nor for any delay in its
> receipt or damage to your system.
>
>
> ___
> Mailing list: https://launchpad.net/~dhi

Re: [Dhis2-users] Data elements assignation

[Knut Staring]

Oops, you cannot select by group anymore. However, you can skip step 3) and
4) and rather do the filtering of data elements directly in 5)

On Mon, Jan 29, 2018 at 12:43 PM, Knut Staring <knu...@gmail.com> wrote:

> Hi Mamadou,
>
> I agree with Michael that the most flexible way is to use the web API and
> create a JSON structure (e.g. with MS Excel), in particular
> https://docs.dhis2.org/master/en/developer/html/webapi_
> metadata_crud.html#webapi_adding_removing_objects_collections
>
> However, if you find this too cumbersome, you could do something like this:
>
> 1) Give your dataelements a unique PREFIX to enable you to filter them out
> 2) Import them as CSV
> 3) Create a group for them
> 4) Go to the group editor, filter and select:
> https://play.dhis2.org/2.28/dhis-web-maintenance/#/group-editor
> 5) Create your dataset and filter by the group
>
> The problem with this method is the PREFIX which you may not want to keep..
>
>  Knut
>
>
>
>
>
>
>
> On Sun, Jan 28, 2018 at 1:45 AM, Michael Mwebaze <
> michael.mweb...@gmail.com> wrote:
>
>> Hi Diao,
>>
>> Are you able to use the web api? The section in the developer's manual
>> 'Metadata create, read, update, delete, validate' should be helpful.
>>
>> Regards,
>>
>> Michael
>>
>> On 27 January 2018 at 15:30, Mamadou Diao Diallo <diao_dia...@gn.jsi.com>
>> wrote:
>>
>>> Hi dhis2 devs,
>>> I have to assign many data elements to a data set, so I would like to
>>> automatically do it.
>>>
>>> Is there any possibility to do it, like a csv importation?
>>>
>>> Thank you in advance.
>>>
>>> Best
>>>
>>> Diao
>>>
>>> --
>>> *DIALLO Mamadou Diao Conseiller IT, Specialiste de DHIS 2 **( District
>>> Health Information Software )*
>>>
>>>
>>> *Projet de Renforcement du Système d'Information Sanitaire en Guinée*
>>> *Phone : 623909413 | 662256106*
>>> *Skype : diawwdiallo*
>>> www.jsi.com
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> 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
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Organisation Units repetitive structure

[Knut Staring]

Hi Bernard,

In order to elucidate what is going on, the next places to check are the
browser console and the server log.

1) In Chrome, click on Ctrl+Shit+I to open the console window and look for
error messages in RED.

2) For the server, look for catalina.out in the logs folder (What is your
setup? Tomcat or DHIS Live?. Operating system?)

Regards,
Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) <
lib@pu-ami.org> wrote:

> Hello All,
>
> I’m sending this message to seek your help in solving a problem with
> repetitive organization unit structure in the pivot tables section as well
> as user management and others:
>
> · The same org units are showing under their respective org unit
> and alone multiple times.
>
> · The org units in pivot tables keep trying to load each of their
> data without finishing (attached/bellow a screenshot)
>
> I tried but failed to find a similar bug in the JIRA.
>
> I tried to perform Maintenance, browser cache cleaner, login using
> incognito browsing… nothing worked.
>
> Is there a script or database queries I can run to fix this?
>
>
>
> 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
>
>
>
>
>
>
>
>
>
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=icon>
>  Virus-free.
> www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=link>
> <#m_4487136394328816772_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data elements assignation

[Knut Staring]

Hi Mamadou,

I agree with Michael that the most flexible way is to use the web API and
create a JSON structure (e.g. with MS Excel), in particular
https://docs.dhis2.org/master/en/developer/html/webapi_metadata_crud.html#webapi_adding_removing_objects_collections

However, if you find this too cumbersome, you could do something like this:

1) Give your dataelements a unique PREFIX to enable you to filter them out
2) Import them as CSV
3) Create a group for them
4) Go to the group editor, filter and select:
https://play.dhis2.org/2.28/dhis-web-maintenance/#/group-editor
5) Create your dataset and filter by the group

The problem with this method is the PREFIX which you may not want to keep..

 Knut







On Sun, Jan 28, 2018 at 1:45 AM, Michael Mwebaze <michael.mweb...@gmail.com>
wrote:

> Hi Diao,
>
> Are you able to use the web api? The section in the developer's manual
> 'Metadata create, read, update, delete, validate' should be helpful.
>
> Regards,
>
> Michael
>
> On 27 January 2018 at 15:30, Mamadou Diao Diallo <diao_dia...@gn.jsi.com>
> wrote:
>
>> Hi dhis2 devs,
>> I have to assign many data elements to a data set, so I would like to
>> automatically do it.
>>
>> Is there any possibility to do it, like a csv importation?
>>
>> Thank you in advance.
>>
>> Best
>>
>> Diao
>>
>> --
>> *DIALLO Mamadou Diao Conseiller IT, Specialiste de DHIS 2 **( District
>> Health Information Software )*
>>
>>
>> *Projet de Renforcement du Système d'Information Sanitaire en Guinée*
>> *Phone : 623909413 | 662256106*
>> *Skype : diawwdiallo*
>> www.jsi.com
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Hello DHIS2

[Knut Staring]

Hello Makhate,

Welcome to the list. You can see the archive here:
https://lists.launchpad.net/dhis2-users/

And member list:
https://launchpad.net/~dhis2-users/+members#active

Regards,
Knut

On Mon, Jan 29, 2018 at 2:23 PM, Makhate Makhate <makhatemakh...@gmail.com>
wrote:

> ​Hello Community,
>
> Is this usergroup still active.
>
> Kind regards,
> *Makhate*,
> ICAP Lesotho​
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Program indicators export to another system

[Knut Staring]

Hi Elmarie,

This is an important issue, and I expect others will have a better answer,
but one approach could perhaps be to replace the UID for the Programme
Indicators with the desired data element UID. I suppose that would have to
be done either directly in the database or through the API, but if it were
to be a recommended way to link databases it should also be possibly to do
this kind of mapping through the user interface

Knut

On Thu, Feb 1, 2018 at 4:59 PM, Elmarie Claasen <elma...@hisp.org> wrote:

> Hi all,
>
> Any response to this question?
>
> Regards
>
> Elmarie
>
> On 30 Jan 2018 12:11, "Elmarie Claasen" <elma...@hisp.org> wrote:
>
>> Hi all,
>>
>>
>>
>> We create Programme Indicators and would like to export those to other
>> systems with different data element UIDs than the created Programme
>> Indicator UID.
>>
>> If adding a code to the Programme Indicator which is same as the Data
>> Element code will this allow matching on import?
>>
>>
>>
>> Regards,
>>
>>
>>
>> *Elmarie Claasen*
>>
>> [image: Hisp logo]
>>
>> Project Manager
>>
>> Health Information Systems Program
>>
>> Tel:  041-367 1027
>>
>> Cell: 082 374 2209
>>
>> E-mail: elma...@hisp.org
>>
>> Skype:  elmarie.claasen52
>>
>>
>>
>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
> disclaimer before opening any attachment or taking any other action in
> terms of this electronic transmission.  If you cannot access the
> disclaimer, kindly send an email to disclai...@hisp.org
> <disclai...@hisp.org> and a copy will be provided to you. By replying to
> this e-mail or opening any attachment you agree to be bound by the
> provisions of the disclaimer.*
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Program indicators export to another system

[Knut Staring]

Agree very much on having a GUI/app for mapping.

For example, I am currently setting up an instance with simplified
geometries for the whole world based on GADM - with the hierarchy down to
admin level 1, 2, 3, 4 created based on the shapefiles and using the codes
from GADM for admin1 and admin2

It would then be great to be able to link the GADM orgunits with
names/codes used by existing MoH data collection setups (whether Excel,
Access, DHIS2 or other). Would be good to preserve the mapping for later
also, perhaps as an attribute.

On a side note, I heard that someone created an app which can import such
mapping between a shapefile and an exciting orgunit hierarchy in Excel,
which is also not a bad solution.

Knut

On Mon, Feb 5, 2018 at 11:02 AM, Calle Hedberg <calle.hedb...@gmail.com>
wrote:

> Knut
>
> I did that for IDSR/Malaria in order to "map" local IDSR program
> indicators to the WHO aggregated malaria data elements.
>
> It is, frankly, a painful and "expert" approach to the problem, and in my
> opinion very difficult to maintain.
>
> The presumably simplest solution is to expand the "Data Value Set"
> download option under the pivot table app to incorporate the optional use
> of CODES or NAMES. While some might argue that using the same code or name
> for a Program Indicator as for an aggregated data element is not "purist",
> it should work.
>
> A more sophisticated solution that would be useful for any type of data
> import is to introduce data element and organisationunit "mapping" during
> import - similar functionality has been available in DHIS v1 since time
> immemorial.
>
> Users can then define/store/use two lookup field values: uid (or
> code/name) INCOMING, and uid (or code/name) IMPORTING. So incoming
> uid/code/name will automatically be replaced by the equivalent/correct
> value before the system start POSTing records.
>
> Regards
> Calle
>
> On 1 February 2018 at 18:07, Knut Staring <knu...@gmail.com> wrote:
>
>> Hi Elmarie,
>>
>> This is an important issue, and I expect others will have a better
>> answer, but one approach could perhaps be to replace the UID for the
>> Programme Indicators with the desired data element UID. I suppose that
>> would have to be done either directly in the database or through the API,
>> but if it were to be a recommended way to link databases it should also be
>> possibly to do this kind of mapping through the user interface
>>
>> Knut
>>
>> On Thu, Feb 1, 2018 at 4:59 PM, Elmarie Claasen <elma...@hisp.org> wrote:
>>
>>> Hi all,
>>>
>>> Any response to this question?
>>>
>>> Regards
>>>
>>> Elmarie
>>>
>>> On 30 Jan 2018 12:11, "Elmarie Claasen" <elma...@hisp.org> wrote:
>>>
>>>> Hi all,
>>>>
>>>>
>>>>
>>>> We create Programme Indicators and would like to export those to other
>>>> systems with different data element UIDs than the created Programme
>>>> Indicator UID.
>>>>
>>>> If adding a code to the Programme Indicator which is same as the Data
>>>> Element code will this allow matching on import?
>>>>
>>>>
>>>>
>>>> Regards,
>>>>
>>>>
>>>>
>>>> *Elmarie Claasen*
>>>>
>>>> [image: Hisp logo]
>>>>
>>>> Project Manager
>>>>
>>>> Health Information Systems Program
>>>>
>>>> Tel:  041-367 1027
>>>>
>>>> Cell: 082 374 2209
>>>>
>>>> E-mail: elma...@hisp.org
>>>>
>>>> Skype:  elmarie.claasen52
>>>>
>>>>
>>>>
>>>
>>> *This message and any attachments are subject to a disclaimer published
>>> at http://www.hisp.org/policies.html#comms_disclaimer
>>> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
>>> disclaimer before opening any attachment or taking any other action in
>>> terms of this electronic transmission.  If you cannot access the
>>> disclaimer, kindly send an email to disclai...@hisp.org
>>> <disclai...@hisp.org> and a copy will be provided to you. By replying to
>>> this e-mail or opening any attachment you agree to be bound by the
>>> provisions of the disclaimer.*
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@lists.launchpad.net
>>&

Re: [Dhis2-users] Option sets and data elements

[Knut Staring]

Hi Nada,

Are you collecting the same data at two levels? Is it a type of survey
question regarding the organisational unit?

Perhaps you could have two different data elements linked to different data
sets, which can then in turn be assigned at different levels?

Knut

On Mon, Jan 29, 2018 at 12:11 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Nada,
>
> This sounds like a "cascading drop down". This is not supported directly
> in DHIS2, so you will need to implement your own front-end solution for
> this.
>
> Regards,
> Jason
>
>
> On Sat, Jan 27, 2018 at 9:49 AM, Nada Ghosn <esumoh...@gmail.com> wrote:
>
>> Good morning,
>> Reference is made to tacker/event capture
>> Is it possible to have one data element having different option sets
>> based on specific criteria?
>>
>> Example:
>> data element_province (text)
>> data element_district.
>> Based on the value of the data element_province, the data
>> element_district will show different option sets.
>>
>> Sincerely
>> NG
>>
>> --
>> Nada Ghosn, MD
>> Head, Epidemiology Surveillance Program (Esumoh)
>> Ministry of Public Health
>> Beirut, Museum square
>> Lebanon
>> Tel +961.1.614194 <+961%201%20614%20194>
>> Fax +961.1.610920 <+961%201%20610%20920>
>> Email esumoh...@gmail.com, esu...@moph.gov.lb
>> Website www.moph.gov.lb
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46%2076%20414%2070%2049>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Organisation Units repetitive structure

[Knut Staring]

Hi Bernard,

Sorry, I'm very busy with a series of meetings this week, and also not in
the best position to resolve this, so hoping for others on the list to step
up. Thanks for the detailed explanation of your issue, my guess it is
likely just some small thing with your database. You could perhaps also try
to take a look directly at your organsationunit table in the db and scan
for any anomalies such as 10 digit UIDs or null values (can also be done
through the DHIS2 GUI with an SQL View (under Data Administration).

Knut

On Tue, Jan 30, 2018 at 9:10 AM, Bernard Sadaka (IM Advisor) <
lib@pu-ami.org> wrote:

> Hello Again Knut,
>
> Any news about this issue?
>
> Should I open a ticket for it in Jira? The challenge is I don’t know how
> to replicate this bug.
>
>
>
> Here is what happening with my org units:
>
> *As you can see bellow, all the org units are there duplicated but in a
> scrambled order and not under their respective parent. Add to that when I
> click on one of the values that are supposed to show the underlying org
> units only of the copies will expand and show that.*
>
>
>
> *Is this front end related? Backend? Database related?*
>
>
>
> Here is my org unit structure:
>
>1. Lebanon
>   1. Organisation A
>
>i.  Base
> 1
>
> 1.   PHCC 1
>
> 2.   PHCC 2
>
> 3.   PHCC 3
>
>  ii.  Base
> 2
>
> 1.   PHCC 4
>
> 2.   PHCC 5
>
> 3.   PHCC 6
>
> 4.   PHCC 7
>
>1. Test Org A
>
>i.  Test
> Base 1
>
> 1.   Test PHCC 1
>
> 2.   Test PHCC 2
>
> 3.   Test PHCC 3
>
>  ii.  Test
> Base 2
>
> 1.   Test PHCC 4
>
> 2.   Test PHCC 5
>
> 3.   Test PHCC 6
>
> 4.   Test PHCC 7
>
> 5.   Test PHCC 8
>
>
>
> In some places on my DHIS2 it shows correctly, in other places it shows as
> per the bellow (in DHIS2 sections such as the “pivot tables” and the “data
> output and analytics organization units” under new/edit user section) (the
> pivot tables keep trying to load as mentioned before) :
>
> 1.   Base 1
>
> 1.   PHCC 1
>
> 2.   PHCC 2
>
> 3.   PHCC 3
>
>1. PHCC 1
>2. PHCC 4
>3. PHCC 2
>4. PHCC 3
>5. PHCC 5
>6. PHCC 6
>7. Lebanon
>   1. Organisation A
>
>i.  Base
> 1
>
>  ii.  Base
> 2
>
> 1.   PHCC 4
>
> 2.   PHCC 5
>
> 3.   PHCC 6
>
> 4.   PHCC 7
>
>1. Test Org A
>
>i.  Test
> Base 1
>
> 1.   Test PHCC 1
>
> 2.   Test PHCC 2
>
> 3.   Test PHCC 3
>
>  ii.  Test
> Base 2
>
> 1.   Test PHCC 4
>
> 2.   Test PHCC 5
>
> 3.   Test PHCC 6
>
> 4.   Test PHCC 7
>
> 5.   Test PHCC 8
>
>1. Organisation A
>2. Base 2
>3. PHCC 7
>4. Test Base 1
>5. Test PHCC 1
>6. Test PHCC 4
>7. Test PHCC 2
>8. Test PHCC 5
>9. Test PHCC 6
>10. Test PHCC 7
>11. Test Org A
>12. Test Base 2
>
>
>
> Your help is 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
>
>
>
>
>
> *From:* Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org]
> *Sent:* Monday, January 29, 2018 2:29 PM
> *To:* 'Knut Staring' <knu...@gmail.com>
> *Cc:* 'DHIS 2 Users list' <dhis2-users@lists.launchpad.net>; 'DHIS 2
> developers' <dhis2-d...@lists.launchpad.net>
> *Subject:* RE: [Dhis2-users] Organisation Units repetitive structure
>
>
>
> Thank you Knut,
>
> The console error while at the pivot table and viewing the org units is
> “Cannot read property ‘internalId’ of undefined ” as per the bellow
> screenshot:
>
>
>
> 

Re: [Dhis2-users] [Dhis2-devs] DATA ELEMENTS NOT SHOWING DATA IN PIVOT TABLES

[Knut Staring]

Hi Andrey,

Please report this in JIRA: http://jira.dhis2.org/

Thanks,
Knut

On 2/8/18, Andrey Kolpakov <aakolpa...@gmail.com> wrote:
> Hi, Gerald and Stanley.
>
> I have the same issue, data can not be aggregated. Tried everything
> (regenerate reporting, clear cache).
>
> I've tried it on the official demo server (https://play.dhis2.org/2.27/).
> Version 2.26 works as expected, but not 2.27 and 2.28.
> Here are steps to reproduce:
> https://docs.google.com/document/d/1mRjfBvVfwqjxz9c0JotRIlQMJK4wV5V7qf6wEkskkrc/edit
> <https://docs.google.com/document/d/1mRjfBvVfwqjxz9c0JotRIlQMJK4wV5V7qf6wEkskkrc/edit>
>
> Will be appreciated for any help
>
>> On 6 Feb 2018, at 13:47, gerald thomas <gerald17...@gmail.com> wrote:
>>
>> Stanley,
>> It simply means your data is based on those category combinations that is
>> why you are seeing them. Please share a print screen of that data set
>> whose data elements you pivoting for now.
>>
>> On Tue, Feb 6, 2018 at 12:33 PM, Stanley Kalyati <skaly...@gmail.com
>> <mailto:skaly...@gmail.com>> wrote:
>> Hi Gerald,
>>
>> I have run analytics,i have also gone to data admin and also cleared catch
>> but no results.
>>
>> Only when i add a category combination to the data set,that is when i am
>> able to see data when i run pivot or data visualizer.
>>
>> I cant understand
>>
>> On Tue, Feb 6, 2018 at 1:40 PM, gerald thomas <gerald17...@gmail.com
>> <mailto:gerald17...@gmail.com>> wrote:
>> Stanley,
>> Please run analytics and check your pivot tables again.
>>
>> On Tue, Feb 6, 2018 at 11:11 AM, Stanley Kalyati <skaly...@gmail.com
>> <mailto:skaly...@gmail.com>> wrote:
>> Hi All,
>>
>> I posted something similar sometime two weeks ago.
>>
>> I have data elements whose value type is number and aggregation type is
>> Sum.I created a data set and assigned it to the Organisation unit.
>>
>> I captured data and run analytics.When i run the pivot tables,no data
>> values.
>>
>> However,when i add a Category Combination which is an attribute to the
>> data set,enter data and run pivot tables,data is there.
>>
>> I am confused.
>>
>> Anyone with an idea?
>>
>> Thank you
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-users@lists.launchpad.net
>> <mailto:dhis2-users@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp
>> <https://help.launchpad.net/ListHelp>
>>
>>
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>>
>>
>>
>> --
>> Regards,
>>
>> Gerald
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

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

Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

[Knut Staring]

Hi Abyot,

I am probably just stupid, but why is it complaining about a different
program (ur1Edk5Oe2n) than the one requested in the URL (eBAyeGv0exc) ?

And even after sharing both programs with the administrator group which
admin is a member of, I still get the same?

Knut

On Tue, Feb 6, 2018 at 5:00 PM, Abyot Asalefew Gizaw <ab...@dhis2.org>
wrote:
>
> That is because if the new sharing setting. You need to go and configure
data read and write sharing settings...
>
> The same url should work in 2.28 and lower versions.
>
>
> On Tue, Feb 6, 2018, 16:55 Georgi Chakarov <geo...@logicaloutcomes.net>
wrote:
>>
>> Yes, and I am trying to get all data for all tracked entity instances,
not for a specific one. Any idea?
>>
>>
>>
>> From: Knut Staring [mailto:knu...@gmail.com]
>> Sent: Tuesday, February 6, 2018 5:43 PM
>>
>>
>> To: Georgi Chakarov <geo...@logicaloutcomes.net>
>> Cc: DHIS 2 Developers list <dhis2-d...@lists.launchpad.net>;
dhis2-users@lists.launchpad.net; Michal Debski <
michal.deb...@logicaloutcomes.net>; Wojtek Bak <woj...@logicaloutcomes.net>
>> Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage data
through API
>>
>>
>>
>> I see. I am actually seeing a restriction when trying the example at the
bottom of the page in the manual:
>>
>>
>>
>>
https://docs.dhis2.org/master/en/developer/html/webapi_events.html#webapi_querying_reading_events
>>
>>
>>
>>
https://play.dhis2.org/dev/api/26/events.json?orgUnit=DiszpKrYNg8=eBAyeGv0exc=gfVxE3ALA9m=2014-01-01=2014-12-31
>>
>>
{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"[User
has no read access to program: ur1Edk5Oe2n]"}
>>
>> This is of course not the response you are getting.
>>
>> Knut
>>
>>
>>
>>
>>
>> Virus-free. www.avg.com
>>
>>
>>
>> On Tue, Feb 6, 2018 at 4:11 PM, Georgi Chakarov <
geo...@logicaloutcomes.net> wrote:
>>
>> Hi Knut,
>>
>>
>>
>> I am using a super user account and we don’t have data shared among
users. Maybe the problem is related to the fact that Tracker data does not
get exported in any format from the Import/Export app either. Aggregate
data does, but tracker or event data does not.
>>
>>
>>
>> Georgi
>>
>> From: Knut Staring [mailto:knu...@gmail.com]
>> Sent: Tuesday, February 6, 2018 3:42 PM
>> To: Georgi Chakarov <geo...@logicaloutcomes.net>
>> Cc: DHIS 2 Developers list <dhis2-d...@lists.launchpad.net>;
dhis2-users@lists.launchpad.net; Michal Debski <
michal.deb...@logicaloutcomes.net>; Wojtek Bak <woj...@logicaloutcomes.net>
>> Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage data
through API
>>
>>
>>
>> Just a thought - is the user you are using for the API member of the
user group for which this data has been shared?
>>
>>
>>
>> Knut
>>
>>
>>
>> On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov <
geo...@logicaloutcomes.net> wrote:
>>
>> Hi all,
>>
>>
>>
>> Any thoughts on the below question? Your input is highly needed and
appreciated!
>>
>>
>>
>> Regards,
>>
>> Georgi
>>
>>
>>
>> From: Georgi Chakarov
>> Sent: Monday, February 5, 2018 6:20 PM
>> To: 'DHIS 2 Developers list' <dhis2-d...@lists.launchpad.net>;
dhis2-users@lists.launchpad.net
>> Cc: Michal Debski <michal.deb...@logicaloutcomes.net>; Wojtek Bak <
woj...@logicaloutcomes.net>
>> Subject: Access Tracker capture program stage data through API
>>
>>
>>
>> Hi all,
>>
>>
>>
>> Can anyone tell me what is the query to read all data entered in a
Tracker capture program stage?
>>
>>
>>
>> We have tried this:
>>
>> /api/26/events.json?orgUnit=DiszpKrYNg8=eBAyeGv0exc
>>
>> and other versions like
/api/26/events.json?orgUnit=YuQRtpLP10I=CHILDREN but we get the
result below. Your feedback is highly appreciated!
>>
>>
>>
>>
>>
>>
>>
>> Georgi
>>
>>
>> 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
>>
>>
>>
>>
>> ___
>&

Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

[Knut Staring]

I see. I am actually seeing a restriction when trying the example at the
bottom of the page in the manual:

https://docs.dhis2.org/master/en/developer/html/webapi_events.html#webapi_querying_reading_events

https://play.dhis2.org/dev/api/26/events.json?orgUnit=DiszpKrYNg8=eBAyeGv0exc=gfVxE3ALA9m=2014-01-01=2014-12-31

{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"[User
has no read access to program: ur1Edk5Oe2n]"}

This is of course not the response you are getting.

Knut



<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
Virus-free.
www.avg.com
<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Tue, Feb 6, 2018 at 4:11 PM, Georgi Chakarov <geo...@logicaloutcomes.net>
wrote:

> Hi Knut,
>
>
>
> I am using a super user account and we don’t have data shared among users.
> Maybe the problem is related to the fact that Tracker data does not get
> exported in any format from the Import/Export app either. Aggregate data
> does, but tracker or event data does not.
>
>
>
> Georgi
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* Tuesday, February 6, 2018 3:42 PM
> *To:* Georgi Chakarov <geo...@logicaloutcomes.net>
> *Cc:* DHIS 2 Developers list <dhis2-d...@lists.launchpad.net>;
> dhis2-users@lists.launchpad.net; Michal Debski <michal.debski@
> logicaloutcomes.net>; Wojtek Bak <woj...@logicaloutcomes.net>
> *Subject:* Re: [Dhis2-users] FW: Access Tracker capture program stage
> data through API
>
>
>
> Just a thought - is the user you are using for the API member of the user
> group for which this data has been shared?
>
>
>
> Knut
>
>
>
> On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
>
> Hi all,
>
>
>
> Any thoughts on the below question? Your input is highly needed and
> appreciated!
>
>
>
> Regards,
>
> Georgi
>
>
>
> *From:* Georgi Chakarov
> *Sent:* Monday, February 5, 2018 6:20 PM
> *To:* 'DHIS 2 Developers list' <dhis2-d...@lists.launchpad.net>;
> dhis2-users@lists.launchpad.net
> *Cc:* Michal Debski <michal.deb...@logicaloutcomes.net>; Wojtek Bak <
> woj...@logicaloutcomes.net>
> *Subject:* Access Tracker capture program stage data through API
>
>
>
> Hi all,
>
>
>
> Can anyone tell me what is the query to read all data entered in a Tracker
> capture program stage?
>
>
>
> We have tried this:
>
> */api/26/events.json?orgUnit=DiszpKrYNg8=eBAyeGv0exc *
>
> and other versions like
> */api/26/events.json?orgUnit=YuQRtpLP10I=CHILDREN* but we get the
> result below. Your feedback is highly appreciated!
>
>
>
>
>
>
>
> Georgi
>
>
> 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
> <https://maps.google.com/?q=720+Bathurst+Street,+Toronto+Canada+M5S+2R4=gmail=g>
> | *You may unsubscribe from receiving commercial electronic messages from
> LogicalOutcomes by emailing **i...@logicaloutcomes.net*
> <i...@logicaloutcomes.net>
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

[Knut Staring]

Just a thought - is the user you are using for the API member of the user
group for which this data has been shared?

Knut

On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov <geo...@logicaloutcomes.net>
wrote:

> Hi all,
>
>
>
> Any thoughts on the below question? Your input is highly needed and
> appreciated!
>
>
>
> Regards,
>
> Georgi
>
>
>
> *From:* Georgi Chakarov
> *Sent:* Monday, February 5, 2018 6:20 PM
> *To:* 'DHIS 2 Developers list' <dhis2-d...@lists.launchpad.net>;
> dhis2-users@lists.launchpad.net
> *Cc:* Michal Debski <michal.deb...@logicaloutcomes.net>; Wojtek Bak <
> woj...@logicaloutcomes.net>
> *Subject:* Access Tracker capture program stage data through API
>
>
>
> Hi all,
>
>
>
> Can anyone tell me what is the query to read all data entered in a Tracker
> capture program stage?
>
>
>
> We have tried this:
>
> */api/26/events.json?orgUnit=DiszpKrYNg8=eBAyeGv0exc *
>
> and other versions like
> */api/26/events.json?orgUnit=YuQRtpLP10I=CHILDREN* but we get the
> result below. Your feedback is highly appreciated!
>
>
>
>
>
>
>
> Georgi
>
>
> 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* <i...@logicaloutcomes.net>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Root organisation unit problem.

[Knut Staring]

Hi Khant,

Sending this back to the users list. The message you linked to was me
trying to help Astrid. Not sure if she resolved it.

Try and open Organisation Unit level and click on Save. Or did you import
levels also from SL? Is your problem that you are not able to create groups?

Knut

On Wed, Feb 7, 2018 at 3:26 PM, Khant Mg Mg 
wrote:

> Dear Knut,
> I assign myself (admin user) to root org unit. But that didn't solve the
> problem. I thought you also faced that kind of problem previously. I saw
> that on https://lists.launchpad.net/dhis2-users/msg14162.html.
> If you've solved that problem, can you please share your solution?
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Root organisation unit problem.

[Knut Staring]

Please try and open Organisation Unit level and click on the SAVE button

I assume you have not tried to connect to a Posgresql database?

Knut

On Wed, Feb 7, 2018 at 3:57 PM, Khant Mg Mg <dr.khantmaungma...@gmail.com>
wrote:

> I didn't import anything. I create the first org unit (the root org unit)
> and it shows nothing in level column. I already assigned myself (admin
> user) to the root org unit. The problem still present. In org unit level,
> there is only level1. I didn't touch anything in org unit level.
>
> My problem is that I cannot create org unit group, org unit tree did not
> appear in dataset.
>
> On 7 Feb 2018 9:07 pm, "Knut Staring" <knu...@gmail.com> wrote:
>
> Hi Khant,
>
> Sending this back to the users list. The message you linked to was me
> trying to help Astrid. Not sure if she resolved it.
>
> Try and open Organisation Unit level and click on Save. Or did you import
> levels also from SL? Is your problem that you are not able to create
> groups?
>
> Knut
>
> On Wed, Feb 7, 2018 at 3:26 PM, Khant Mg Mg <dr.khantmaungma...@gmail.com>
> wrote:
>
>> Dear Knut,
>> I assign myself (admin user) to root org unit. But that didn't solve the
>> problem. I thought you also faced that kind of problem previously. I saw
>> that on https://lists.launchpad.net/dhis2-users/msg14162.html.
>> If you've solved that problem, can you please share your solution?
>>
>
>
>


-- 
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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Posting Metadata in dhis2.

[Knut Staring]

aiahnyab...@gmail.com> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>> Dear Jason and Dhis2 Community,
>>>>>>>>
>>>>>>>> I am following your guide on bootstrapping
>>>>>>>> <https://github.com/jason-p-pickering/dhis2-data-munging/blob/master/bootstrap/bootstrap.Rmd>
>>>>>>>>  dhis2 with R while trying to import metadata using the API.
>>>>>>>>
>>>>>>>> I do not understand why my metadata is not imported. Here are my
>>>>>>>> steps, any help will be appreciated.
>>>>>>>>
>>>>>>>>
>>>>>>>> head(org)  name uid   code  parent 
>>>>>>>> shortname
>>>>>>>> 1 Wikithuki Dispensary Bc371uxfYD5  16925 vpiZlB5cdK7  
>>>>>>>> Wikithuki Dispensary
>>>>>>>> 2Gemifa Medical Clinic Z7Lf1n3Fcpi  22907 mEZBjj4fLBT  
>>>>>>>>   Gemifa
>>>>>>>> 3   Olympus Medical Clinic NAbQdHuaJFK  22906 PeEcMfBchbr  
>>>>>>>>  Olympus
>>>>>>>> 4 Masaba Community Health Unit tYwHeLSnHyb 600616 QR2K4k8VKF1  
>>>>>>>>   Masaba CHU
>>>>>>>> 5Gatunga Health Centre cmay4WXRmhA  12034 IcAegRcGuV6 Gatunga 
>>>>>>>> Health Centre
>>>>>>>> 6 Cfw Kimangaru Clinic E52UsoBxJVS  11966 vEAFtHnPDrX  CFW 
>>>>>>>> Kimangaru Clinic
>>>>>>>>  description openingdate closedate comment featuretype  
>>>>>>>> coordinates url
>>>>>>>> 1 NANA   POINT  
>>>>>>>> [37.95263,-0.77819]
>>>>>>>> 2 Clinic  NANANONE 
>>>>>>>> [34.391914,0.059575]
>>>>>>>> 3 Clinic  NANANONE   
>>>>>>>> [34.3994,0.059575]
>>>>>>>> 4 Community Unit  NANANONE   
>>>>>>>> [34.46411,0.19358]
>>>>>>>> 5 NANA   POINT   
>>>>>>>> [37.9423,-0.29656]
>>>>>>>> 6 NANA   POINT  
>>>>>>>> [37.53009,-0.54506]
>>>>>>>>   contactperson address email phonenumber
>>>>>>>> 1NA  NANA  NA
>>>>>>>> 2NA  NANA  NA
>>>>>>>> 3NA  NANA  NA
>>>>>>>> 4NA  NANA  NA
>>>>>>>> 5NA  NANA  NA
>>>>>>>> 6NA  NANA  NA
>>>>>>>>
>>>>>>>>
>>>>>>>> I followed the following steps to prepare my df for import.
>>>>>>>> 1. Removed all the NAs  and columns with entire NAs.
>>>>>>>>
>>>>>>>> head(new_org)  name uid   code  
>>>>>>>> parent shortname
>>>>>>>> 1 Wikithuki Dispensary Bc371uxfYD5  16925 vpiZlB5cdK7  
>>>>>>>> Wikithuki Dispensary
>>>>>>>> 2Gemifa Medical Clinic Z7Lf1n3Fcpi  22907 mEZBjj4fLBT  
>>>>>>>>   Gemifa
>>>>>>>> 3   Olympus Medical Clinic NAbQdHuaJFK  22906 PeEcMfBchbr  
>>>>>>>>  Olympus
>>>>>>>> 4 Masaba Community Health Unit tYwHeLSnHyb 600616 QR2K4k8VKF1  
>>>>>>>>   Masaba CHU
>>>>>>>> 5Gatunga Health Centre cmay4WXRmhA  12034 IcAegRcGuV6 Gatunga 
>>>>>>>> Health Centre
>>>>>>>> 6 Cfw Kimangaru Clinic E52UsoBxJVS  11966 vEAFtHnPDrX  CFW 
>>>>>>>> Kimangaru Clinic
>>>>>>>>  description comment featuretype  coordinates url
>>>>>>>> 1  POINT  [37.95263,-0.77819]
>>>>>>>> 2 ClinicNONE [34.391914,0.059575]
>>>>>>>> 3 ClinicNONE   [34.3994,0.059575]
>>>>>>>> 4 Community UnitNONE   [34.46411,0.19358]
>>>>>>>> 5  POINT   [37.9423,-0.29656]
>>>>>>>> 6  POINT  [37.53009,-0.54506]
>>>>>>>>
>>>>>>>>
>>>>>>>> 3. Then post the data as follows.
>>>>>>>>
>>>>>>>> dest.url <- "http://localhost/dhis/;
>>>>>>>> url <- paste0(dest.url, "api/metadata?importStrategy=C
>>>>>>>> REATE=NONE")
>>>>>>>>   r <- POST(url, authenticate(dest.user, dest.pass),
>>>>>>>> body = toJSON(new_org, auto_unbox = TRUE),
>>>>>>>> content_type_json())
>>>>>>>>   assertthat::assert_that(r$status_code==200)
>>>>>>>>
>>>>>>>> 4. The body looks like.
>>>>>>>>
>>>>>>>> jsonlite::toJSON(me, auto_unbox = TRUE)[{"name":"Wikithuki 
>>>>>>>> Dispensary","uid":"Bc371uxfYD5","code":"16925","parent":"vpiZlB5cdK7","shortname":"Wikithuki
>>>>>>>>  
>>>>>>>> Dispensary","description":"","comment":"","featuretype":"POINT","coordinates":"[37.95263,-0.77819]","url":""},{"name":"Gemifa
>>>>>>>>  Medical 
>>>>>>>> Clinic","uid":"Z7Lf1n3Fcpi","code":"22907","parent":"mEZBjj4fLBT","shortname":"Gemifa","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.391914,0.059575]","url":""},{"name":"Olympus
>>>>>>>>  Medical 
>>>>>>>> Clinic","uid":"NAbQdHuaJFK","code":"22906","parent":"PeEcMfBchbr","shortname":"Olympus","description":"Clinic","comment":"","featuretype":"NONE","coordinates":"[34.3994,0.059575]","url":""},{"name":"Masaba
>>>>>>>>  Community Health 
>>>>>>>> Unit","uid":"tYwHeLSnHyb","code":"600616","parent":"QR2K4k8VKF1","shortname":"Masaba
>>>>>>>>  CHU","description":"Community 
>>>>>>>> Unit","comment":"","featuretype":"NONE","coordinates":"[34.46411,0.19358]","url":""},{"name":"Gatunga
>>>>>>>>  Health 
>>>>>>>> Centre","uid":"cmay4WXRmhA","code":"12034","parent":"IcAegRcGuV6","shortname":"Gatunga
>>>>>>>>  Health 
>>>>>>>> Centre","description":"","comment":"","featuretype":"POINT","coordinates":"[37.9423,-0.29656]","url":""},{"name":"Cfw
>>>>>>>>  Kimangaru 
>>>>>>>> Clinic","uid":"E52UsoBxJVS","code":"11966","parent":"vEAFtHnPDrX","shortname":"CFW
>>>>>>>>  Kimangaru 
>>>>>>>> Clinic","description":"","comment":"","featuretype":"POINT","coordinates":"[37.53009,-0.54506]","url":""}]
>>>>>>>>
>>>>>>>>
>>>>>>>> What could be the problem there? I get status 200 and still it
>>>>>>>> doesn't import.
>>>>>>>>
>>>>>>>>
>>>>>>>> Thank you
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> 
>>>>>>>> 
>>>>>>>> Isaiah Nyabuto
>>>>>>>> +254 729 572 616
>>>>>>>> Bsc. Health Records Management & Informatics, JKUAT.
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Jason P. Pickering
>>>>>>> email: jason.p.picker...@gmail.com
>>>>>>> tel:+46764147049 <076-414%2070%2049>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> 
>>>>>> 
>>>>>> Isaiah Nyabuto
>>>>>> +254 729 572 616
>>>>>> Bsc. Health Records Management & Informatics, JKUAT.
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Jason P. Pickering
>>>>> email: jason.p.picker...@gmail.com
>>>>> tel:+46764147049 <076-414%2070%2049>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> 
>>>> 
>>>> Isaiah Nyabuto
>>>> +254 729 572 616
>>>> Bsc. Health Records Management & Informatics, JKUAT.
>>>>
>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.picker...@gmail.com
>>> tel:+46764147049 <076-414%2070%2049>
>>>
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Posting Metadata in dhis2.

[Knut Staring]

Everything done from the user interface is done through the API, so yes.
The API also gives you more flexibility to filter etc. The manual describes
this.

https://docs.dhis2.org/master/en/developer/html/webapi_metadata_crud.html
https://docs.dhis2.org/master/en/developer/html/webapi_metadata_export.html
https://docs.dhis2.org/master/en/developer/html/webapi_metadata_synchronization.html


On Thu, Feb 15, 2018 at 8:56 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
wrote:

>
> Hi Knut,
>
> Yes. And is it possible to do that APIs?
>
> Thank you.
>
>
> ==
> Isaiah Nyabuto
> +254729572616 <+254%20729%20572616>
> Bsc. Health Records Management and Informatics
>
> On Feb 15, 2018 16:29, "Knut Staring" <knu...@gmail.com> wrote:
>
>> Hi Isaiah,
>>
>> When you say "extract", you mean you want to take metadata from one
>> instance of DHIS2 and import to another one? That can be done through the
>> user interface as described in the user manual:
>> https://docs.dhis2.org/master/en/user/html/import_export.html
>> https://play.dhis2.org/2.28/dhis-web-importexport/index.action
>>
>> You can also load metadata from CSV:
>> https://docs.dhis2.org/master/en/developer/html/webapi_csv_m
>> etadata_import.html
>>
>> On Thu, Feb 15, 2018 at 7:33 AM, Isaiah Nyabuto <isaiahnyab...@gmail.com>
>> wrote:
>>
>>> Hi Jason,
>>>
>>> Thank you. I am going to look into that keenly.
>>> And If I may ask, is there a way I can extract dhis2 metadata that can
>>> be imported directly or with minimal transformations?
>>>
>>> This will be helpful. Thank you.
>>>
>>> ==
>>> Isaiah Nyabuto
>>> +254729572616 <+254%20729%20572616>
>>> Bsc. Health Records Management and Informatics
>>>
>>> On Feb 15, 2018 15:16, "Jason Pickering" <jason.p.picker...@gmail.com>
>>> wrote:
>>>
>>>> Hi Isaiah,
>>>>
>>>> You have
>>>>
>>>>
>>>> "parent":"vpiZlB5cdK7"
>>>>
>>>>
>>>> It should be
>>>>
>>>> parent":{"id":"vpiZlB5cdK7"}}
>>>>
>>>> Be sure your JSON structure is exactly as it should be, otherwise, you
>>>> will get those kinds of errors. Study the example here
>>>> <https://raw.githubusercontent.com/jason-p-pickering/dhis2-data-munging/master/ous/ous.json>
>>>> .
>>>>
>>>> Regards,
>>>> Jason
>>>>
>>>>
>>>>
>>>> On Thu, Feb 15, 2018 at 1:07 PM, Isaiah Nyabuto <
>>>> isaiahnyab...@gmail.com> wrote:
>>>>
>>>>> Thank you for the tip. It still doesn't work.
>>>>> what does this error mean?
>>>>>
>>>>> httr::content(r, "text")
>>>>>
>>>>> [1] "{\"httpStatus\":\"Internal Server Error\",\"httpStatusCode\":500
>>>>> ,\"status\":\"ERROR\",\"message\":\"Can not instantiate value of type
>>>>> [simple type, class org.hisp.dhis.organisationunit.OrganisationUnit]
>>>>> from String value ('It7fWcKbcZX'); no single-String constructor/factory
>>>>> method\\n at [Source: org.apache.catalina.connector.
>>>>> CoyoteInputStream@1efec811; line: 1, column: 73] (through reference
>>>>> chain: org.hisp.dhis.organisationunit.OrganisationUnit[\\\"parent\\\
>>>>> "])\"}"
>>>>>
>>>>> Anyone?
>>>>>
>>>>> Thank you.
>>>>> ==
>>>>> Isaiah Nyabuto
>>>>> +254729572616 <+254%20729%20572616>
>>>>> Bsc. Health Records Management and Informatics
>>>>>
>>>>> On Feb 15, 2018 13:14, "Jason Pickering" <jason.p.picker...@gmail.com>
>>>>> wrote:
>>>>>
>>>>> All of your fields must have exactly the correct names:
>>>>>
>>>>> shortname -> shortName
>>>>> featuretype-> featureType
>>>>>
>>>>> Keep hacking at it! You will get there!
>>>>>
>>>>> Regards,
>>>>> Jason
>>>>>
>>>>>
>>>>> On Thu, Feb 15, 2018 at 11:08 AM, Isaiah Nyabuto <
>>>>> isaiahnyab.

Re: [Dhis2-users] Setting up GIS

[Knut Staring]

Probably not. Do you see the boundary layer in the GIS module?

On Feb 19, 2018 12:01 PM, "Isaiah Nyabuto"  wrote:

> Dear Dhis2 Community,
>
> I imported organisationUnits as (geojson file) with coordinates. Am not
> sure whether I'll need to create gml files inorder to get my gis working.
> I understand that the process documented here
>  requires a different
> set up?
>
> Please advise.
>
> Thank you.
>
>
> --
> 
> 
> Isaiah Nyabuto
> +254 729 572 616
> Bsc. Health Records Management & Informatics, JKUAT.
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Legend for option sets

[Knut Staring]

You can use orgunit groups for different types.

Knut

On Feb 19, 2018 8:40 PM, "Natalie Tibbels"  wrote:

> Hi all,
>
>
>
> Is it possible to color code or label tracked entities in GIS? I am using
> tracker to map community structures (schools, product distribution points,
> CBOs, etc).
>
>
>
> Could I set up a legend set to have the different types of structures show
> up in different colors on the map, based on the option set – so schools in
> green, distribution points in blue, for example. I can only find a way to
> make a continuous legend, rather than colors/icons associated with
> categorical options.
>
>
>
> Could I, in addition, have a certain data element (the name of the
> structure) show up as a label on the map?
>
>
>
> Grateful for any help!
>
>
>
> ~Natalie
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] insufficient memory problem

[Knut Staring]

Dear Gerald,

There does indeed seem to be a problem with RAM, seems like maybe 32-bit
Java is used? However, you definitely do not need as much as 12 Gb RAM to
run a small instance of DHIS2, it should be possible with 2 Gb, and
certainly with 4 Gb.

On Thu, Feb 22, 2018 at 12:38 PM, gerald thomas <gerald17...@gmail.com>
wrote:

> Jalal,
> I am sure there is not enough RAM on your linode VM. Please can you send
> the report of this command 'vmstat -s'. From the manual you sent you need
> at least 12Gb RAM of which 8Gb should be allocated to the PostgresSQL.
>
> On Tue, Feb 20, 2018 at 7:57 PM, Knut Staring <knu...@gmail.com> wrote:
>
>> Also, please redirect this to the list:
>> dhis2-users@lists.launchpad.net
>>
>> On Feb 20, 2018 2:46 PM, "Jalal" <jabdula...@immap.org> wrote:
>>
>>> Dears ,
>>>
>>>
>>>
>>> Please I need your support for the below issue :
>>>
>>>
>>>
>>> I have a hosting on linode 2048 (My Ubuntu 16.04 LTS),and I’m trying to
>>> install DHIS2 through the below link:
>>>
>>>
>>>
>>> https://docs.dhis2.org/2.28/en/implementer/html/install_serv
>>> er_setup.html
>>>
>>>
>>>
>>> but I got the below error: advice please
>>>
>>>
>>>
>>> #
>>>
>>> # There is insufficient memory for the Java Runtime Environment to
>>> continue.
>>>
>>> # Native memory allocation (mmap) failed to map 2796224512 bytes for
>>> committing reserved memory.
>>>
>>> # Possible reasons:
>>>
>>> #   The system is out of physical RAM or swap space
>>>
>>> #   In 32 bit mode, the process size limit was hit
>>>
>>> # Possible solutions:
>>>
>>> #   Reduce memory load on the system
>>>
>>> #   Increase physical memory or swap space
>>>
>>> #   Check if swap backing store is full
>>>
>>> #   Use 64 bit Java on a 64 bit OS
>>>
>>> #   Decrease Java heap size (-Xmx/-Xms)
>>>
>>> #   Decrease number of Java threads
>>>
>>> #   Decrease Java thread stack sizes (-Xss)
>>>
>>> #   Set larger code cache with -XX:ReservedCodeCacheSize=
>>>
>>> # This output file may be truncated or incomplete.
>>>
>>> #
>>>
>>> #  Out of Memory Error (os_linux.cpp:2640), pid=7874,
>>> tid=0x7f5b42495700
>>>
>>> #
>>>
>>> # JRE version:  (8.0_161-b12) (build )
>>>
>>> # Java VM: Java HotSpot(TM) 64-Bit Server VM (25.161-b12 mixed mode
>>> linux-amd64 compressed oops)
>>>
>>> # Failed to write core dump. Core dumps have been disabled. To enable
>>> core dumping, try "ulimit -c unlimited" before starting Java again
>>>
>>> #
>>>
>>>
>>>
>>> ---  T H R E A D  ---
>>>
>>>
>>>
>>> Current thread (0x7f5b3c00a800):  JavaThread "Unknown thread"
>>> [_thread_in_vm, id=7875, stack(0x7f5b42395000,0x7f5b42496000)]
>>>
>>>
>>>
>>> Stack: [0x7f5b42395000,0x7f5b42496000],
>>> sp=0x7f5b42494350,  free space=1020k
>>>
>>> Native frames: (J=compiled Java code, j=interpreted, Vv=VM code,
>>> C=native code)
>>>
>>> V  [libjvm.so+0xacf94a]  VMError::report_and_die()+0x2ba
>>>
>>> V  [libjvm.so+0x50050b]  report_vm_out_of_memory(char const*, int,
>>> unsigned long, VMErrorType, char const*)+0x8b
>>>
>>> V  [libjvm.so+0x92b133]  os::Linux::commit_memory_impl(char*, unsigned
>>> long, bool)+0x103
>>>
>>> V  [libjvm.so+0x92b5c9]  os::pd_commit_memory(char*, unsigned long,
>>> unsigned long, bool)+0x29
>>>
>>> V  [libjvm.so+0x924c0a]  os::commit_memory(char*, unsigned long,
>>> unsigned long, bool)+0x2a
>>>
>>> V  [libjvm.so+0xacb629]  VirtualSpace::expand_by(unsigned long,
>>> bool)+0x199
>>>
>>> V  [libjvm.so+0xacc17e]  VirtualSpace::initialize(ReservedSpace,
>>> unsigned long)+0xee
>>>
>>> V  [libjvm.so+0x5fec11]  CardGeneration::CardGeneration(ReservedSpace,
>>> unsigned long, int, GenRemSet*)+0xf1
>>>
>>> V  [libjvm.so+0xa7225f]  TenuredGeneration::TenuredGeneration(ReservedSpace,
>>> unsigned long, int, GenRemSet*)+0x5f
>>>
>>> V  [libjvm.so+0x5fff19]  GenerationSpec::init(Rese

[Dhis2-users] Problems with 2.27

[Knut Staring]

Hello everyone,

I have restored a 2.27 db but getting a lot of errors when trying to start
DHIS2. Does anyone have any leads on what might be going on?


Caused by: org.postgresql.util.PSQLException: ERROR: column "uid" contains
null values

Caused by: org.postgresql.util.PSQLException: ERROR: column "shortname"
contains null values

Caused by: org.postgresql.util.PSQLException: ERROR: column "skipoffline"
contains null values

Caused by: org.postgresql.util.PSQLException: ERROR: column "repeatable"
contains null values

Caused by: org.postgresql.util.PSQLException: ERROR: column "created"
contains null values

Caused by: org.postgresql.util.PSQLException: ERROR: column "uid" contains
null values

org.postgresql.util.PSQLException: ERROR: column usercreden0_.uid does not
exist

Caused by: org.postgresql.util.PSQLException: ERROR: column "lastupdated"
contains null values
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Problems with 2.27

[Knut Staring]

Sorry, please ignore. I made a stupid  mistake.

On Feb 24, 2018 2:20 PM, "Knut Staring" <knu...@gmail.com> wrote:

> Hello everyone,
>
> I have restored a 2.27 db but getting a lot of errors when trying to start
> DHIS2. Does anyone have any leads on what might be going on?
>
>
> Caused by: org.postgresql.util.PSQLException: ERROR: column "uid"
> contains null values
>
> Caused by: org.postgresql.util.PSQLException: ERROR: column "shortname"
> contains null values
>
> Caused by: org.postgresql.util.PSQLException: ERROR: column "skipoffline"
> contains null values
>
> Caused by: org.postgresql.util.PSQLException: ERROR: column "repeatable"
> contains null values
>
> Caused by: org.postgresql.util.PSQLException: ERROR: column "created"
> contains null values
>
> Caused by: org.postgresql.util.PSQLException: ERROR: column "uid"
> contains null values
>
> org.postgresql.util.PSQLException: ERROR: column usercreden0_.uid does
> not exist
>
> Caused by: org.postgresql.util.PSQLException: ERROR: column "lastupdated"
> contains null values
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] insufficient memory problem

[Knut Staring]

Hi Gerald,

So you are runing Ubuntu on your machine? Perhaps you need to allocate more
resources to Java using this type of setting (though you should adjust the
values down a bit, since you dont have that much memory)

export JAVA_OPTS='-Xmx7500m -Xms4000m'

https://docs.dhis2.org/2.25/en/implementer/html/install_server_setup.html


On Thu, Feb 22, 2018 at 8:34 PM, gerald thomas <gerald17...@gmail.com>
wrote:

> Dear Knut,
> Thanks for your response. Now I have a question which had been disturbing
> me for a long time now. I have a desktop with 4Gb RAM and I used the
> DHIS2-tool method of installation; I am using Postgres 9.5. My instance is
> running OK but the “maintenance app” it showing blank or “pivot table”
> can’t load. On the log file, it is giving insufficient resources error.
> Why?
>
> On Thu, 22 Feb 2018 at 17:36, Knut Staring <knu...@gmail.com> wrote:
>
>> Dear Gerald,
>>
>> There does indeed seem to be a problem with RAM, seems like maybe 32-bit
>> Java is used? However, you definitely do not need as much as 12 Gb RAM to
>> run a small instance of DHIS2, it should be possible with 2 Gb, and
>> certainly with 4 Gb.
>>
>> On Thu, Feb 22, 2018 at 12:38 PM, gerald thomas <gerald17...@gmail.com>
>> wrote:
>>
>>> Jalal,
>>> I am sure there is not enough RAM on your linode VM. Please can you send
>>> the report of this command 'vmstat -s'. From the manual you sent you need
>>> at least 12Gb RAM of which 8Gb should be allocated to the PostgresSQL.
>>>
>>> On Tue, Feb 20, 2018 at 7:57 PM, Knut Staring <knu...@gmail.com> wrote:
>>>
>>>> Also, please redirect this to the list:
>>>> dhis2-users@lists.launchpad.net
>>>>
>>>> On Feb 20, 2018 2:46 PM, "Jalal" <jabdula...@immap.org> wrote:
>>>>
>>>>> Dears ,
>>>>>
>>>>>
>>>>>
>>>>> Please I need your support for the below issue :
>>>>>
>>>>>
>>>>>
>>>>> I have a hosting on linode 2048 (My Ubuntu 16.04 LTS),and I’m trying
>>>>> to install DHIS2 through the below link:
>>>>>
>>>>>
>>>>>
>>>>> https://docs.dhis2.org/2.28/en/implementer/html/install_
>>>>> server_setup.html
>>>>>
>>>>>
>>>>>
>>>>> but I got the below error: advice please
>>>>>
>>>>>
>>>>>
>>>>> #
>>>>>
>>>>> # There is insufficient memory for the Java Runtime Environment to
>>>>> continue.
>>>>>
>>>>> # Native memory allocation (mmap) failed to map 2796224512 bytes for
>>>>> committing reserved memory.
>>>>>
>>>>> # Possible reasons:
>>>>>
>>>>> #   The system is out of physical RAM or swap space
>>>>>
>>>>> #   In 32 bit mode, the process size limit was hit
>>>>>
>>>>> # Possible solutions:
>>>>>
>>>>> #   Reduce memory load on the system
>>>>>
>>>>> #   Increase physical memory or swap space
>>>>>
>>>>> #   Check if swap backing store is full
>>>>>
>>>>> #   Use 64 bit Java on a 64 bit OS
>>>>>
>>>>> #   Decrease Java heap size (-Xmx/-Xms)
>>>>>
>>>>> #   Decrease number of Java threads
>>>>>
>>>>> #   Decrease Java thread stack sizes (-Xss)
>>>>>
>>>>> #   Set larger code cache with -XX:ReservedCodeCacheSize=
>>>>>
>>>>> # This output file may be truncated or incomplete.
>>>>>
>>>>> #
>>>>>
>>>>> #  Out of Memory Error (os_linux.cpp:2640), pid=7874,
>>>>> tid=0x7f5b42495700
>>>>>
>>>>> #
>>>>>
>>>>> # JRE version:  (8.0_161-b12) (build )
>>>>>
>>>>> # Java VM: Java HotSpot(TM) 64-Bit Server VM (25.161-b12 mixed mode
>>>>> linux-amd64 compressed oops)
>>>>>
>>>>> # Failed to write core dump. Core dumps have been disabled. To enable
>>>>> core dumping, try "ulimit -c unlimited" before starting Java again
>>>>>
>>>>> #
>>>>>
>>>>>
>>>>>
>>>>> ---  T H R E A D  ---
>>>>>
&

Re: [Dhis2-users] Setting up GIS

[Knut Staring]

Try opening the orgunit lwvwls and click on Save.

On Feb 20, 2018 12:34 AM, "Isaiah Nyabuto" <isaiahnyab...@gmail.com> wrote:

> Hi Knut,
>
> I can see the boundaries, however I cannot select organisation units below
> certain level say level 2.
>
> On Tue, Feb 20, 2018 at 6:40 AM, Knut Staring <knu...@gmail.com> wrote:
>
>> Probably not. Do you see the boundary layer in the GIS module?
>>
>> On Feb 19, 2018 12:01 PM, "Isaiah Nyabuto" <isaiahnyab...@gmail.com>
>> wrote:
>>
>>> Dear Dhis2 Community,
>>>
>>> I imported organisationUnits as (geojson file) with coordinates. Am not
>>> sure whether I'll need to create gml files inorder to get my gis working.
>>> I understand that the process documented here
>>> <https://docs.dhis2.org/2.22/en/user/html/ch18.html> requires a
>>> different set up?
>>>
>>> Please advise.
>>>
>>> Thank you.
>>>
>>>
>>> --
>>> 
>>> 
>>> Isaiah Nyabuto
>>> +254 729 572 616
>>> Bsc. Health Records Management & Informatics, JKUAT.
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>
>
> --
> 
> 
> Isaiah Nyabuto
> +254 729 572 616
> Bsc. Health Records Management & Informatics, JKUAT.
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] insufficient memory problem

[Knut Staring]

Also, please redirect this to the list:
dhis2-users@lists.launchpad.net

On Feb 20, 2018 2:46 PM, "Jalal"  wrote:

> Dears ,
>
>
>
> Please I need your support for the below issue :
>
>
>
> I have a hosting on linode 2048 (My Ubuntu 16.04 LTS),and I’m trying to
> install DHIS2 through the below link:
>
>
>
> https://docs.dhis2.org/2.28/en/implementer/html/install_server_setup.html
>
>
>
> but I got the below error: advice please
>
>
>
> #
>
> # There is insufficient memory for the Java Runtime Environment to
> continue.
>
> # Native memory allocation (mmap) failed to map 2796224512 bytes for
> committing reserved memory.
>
> # Possible reasons:
>
> #   The system is out of physical RAM or swap space
>
> #   In 32 bit mode, the process size limit was hit
>
> # Possible solutions:
>
> #   Reduce memory load on the system
>
> #   Increase physical memory or swap space
>
> #   Check if swap backing store is full
>
> #   Use 64 bit Java on a 64 bit OS
>
> #   Decrease Java heap size (-Xmx/-Xms)
>
> #   Decrease number of Java threads
>
> #   Decrease Java thread stack sizes (-Xss)
>
> #   Set larger code cache with -XX:ReservedCodeCacheSize=
>
> # This output file may be truncated or incomplete.
>
> #
>
> #  Out of Memory Error (os_linux.cpp:2640), pid=7874,
> tid=0x7f5b42495700
>
> #
>
> # JRE version:  (8.0_161-b12) (build )
>
> # Java VM: Java HotSpot(TM) 64-Bit Server VM (25.161-b12 mixed mode
> linux-amd64 compressed oops)
>
> # Failed to write core dump. Core dumps have been disabled. To enable core
> dumping, try "ulimit -c unlimited" before starting Java again
>
> #
>
>
>
> ---  T H R E A D  ---
>
>
>
> Current thread (0x7f5b3c00a800):  JavaThread "Unknown thread"
> [_thread_in_vm, id=7875, stack(0x7f5b42395000,0x7f5b42496000)]
>
>
>
> Stack: [0x7f5b42395000,0x7f5b42496000],  sp=0x7f5b42494350,
> free space=1020k
>
> Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native
> code)
>
> V  [libjvm.so+0xacf94a]  VMError::report_and_die()+0x2ba
>
> V  [libjvm.so+0x50050b]  report_vm_out_of_memory(char const*, int,
> unsigned long, VMErrorType, char const*)+0x8b
>
> V  [libjvm.so+0x92b133]  os::Linux::commit_memory_impl(char*, unsigned
> long, bool)+0x103
>
> V  [libjvm.so+0x92b5c9]  os::pd_commit_memory(char*, unsigned long,
> unsigned long, bool)+0x29
>
> V  [libjvm.so+0x924c0a]  os::commit_memory(char*, unsigned long, unsigned
> long, bool)+0x2a
>
> V  [libjvm.so+0xacb629]  VirtualSpace::expand_by(unsigned long,
> bool)+0x199
>
> V  [libjvm.so+0xacc17e]  VirtualSpace::initialize(ReservedSpace, unsigned
> long)+0xee
>
> V  [libjvm.so+0x5fec11]  CardGeneration::CardGeneration(ReservedSpace,
> unsigned long, int, GenRemSet*)+0xf1
>
> V  [libjvm.so+0xa7225f]  TenuredGeneration::TenuredGeneration(ReservedSpace,
> unsigned long, int, GenRemSet*)+0x5f
>
> V  [libjvm.so+0x5fff19]  GenerationSpec::init(ReservedSpace, int,
> GenRemSet*)+0x339
>
> V  [libjvm.so+0x5eeaae]  GenCollectedHeap::initialize()+0x1de
>
> V  [libjvm.so+0xa979f3]  Universe::initialize_heap()+0xf3
>
> V  [libjvm.so+0xa97f5e]  universe_init()+0x3e
>
> V  [libjvm.so+0x641fb5]  init_globals()+0x65
>
> V  [libjvm.so+0xa7c5ae]  Threads::create_vm(JavaVMInitArgs*, bool*)+0x23e
>
> V  [libjvm.so+0x6d6c24]  JNI_CreateJavaVM+0x74
>
> C  [libjli.so+0x797e]  JavaMain+0x9e
>
> C  [libpthread.so.0+0x76ba]  start_thread+0xca
>
>
>
>
>
> ---  P R O C E S S  ---
>
>
>
> Java Threads: ( => current thread )
>
>
>
> Other Threads:
>
>
>
> =>0x7f5b3c00a800 (exited) JavaThread "Unknown thread" [_thread_in_vm,
> id=7875, stack(0x7f5b42395000,0x7f5b42496000)]
>
>
>
> VM state:not at safepoint (not fully initialized)
>
>
>
> VM Mutex/Monitor currently owned by a thread: None
>
>
>
> GC Heap History (0 events):
>
> No events
>
>
>
> Deoptimization events (0 events):
>
> No events
>
>
>
> Classes redefined (0 events):
>
> No events
>
>
>
> Internal exceptions (0 events):
>
> No events
>
>
>
> Events (0 events):
>
> No events
>
>
>
>
>
> Dynamic libraries:
>
> 0040-00401000 r-xp  08:00 252076
> /usr/lib/jvm/java-8-oracle/bin/java
>
> 0060-00601000 rw-p  08:00 252076
> /usr/lib/jvm/java-8-oracle/bin/java
>
> 021e2000-02203000 rw-p  00:00 0
> [heap]
>
> 5eb40-63e95 rw-p  00:00 0
>
> 63e95-68780 ---p  00:00 0
>
> 72e2b-7c000 ---p  00:00 0
>
> 7f5b2af79000-7f5b2b3ac000 rw-p  00:00 0
>
> 7f5b2b3ac000-7f5b2bfb7000 ---p  00:00 0
>
> 7f5b2bfb7000-7f5b2bfc2000 rw-p  00:00 0
>
> 7f5b2bfc2000-7f5b2c378000 ---p  00:00 0
>
> 7f5b2c378000-7f5b2c5e8000 rwxp  00:00 0
>
> 7f5b2c5e8000-7f5b3b378000 ---p  00:00 0
>
> 7f5b3b378000-7f5b3b393000 r-xp  08:00 253822
>  /usr/lib/jvm/java-8-oracle/jre/lib/amd64/libzip.so
>
> 7f5b3b393000-7f5b3b593000 ---p 0001b000 08:00 253822
> 

Re: [Dhis2-users] [Dhis2-devs] Error editing Dataset

[Knut Staring]

Hi Barnabas,

Please try this: https://www.dhis2.org/tutorials/how-to-really-clear-
browser-cache

Knut

On Fri, Feb 23, 2018 at 11:46 AM, Barnabas Akumba <akumbaba...@gmail.com>
wrote:

> Hello Lars,
>
> Thanks for the link. I've followed the instruction in the above link but
> still experience the problem.
> I've tried this on both 2.26 and 2.27.
>
> Regards
>
> On Fri, Feb 23, 2018 at 9:51 AM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>> Hi Barnabas,
>>
>> please have a look at guidelines for reporting problems and tell us your
>> DHIS 2 version:
>>
>> https://docs.dhis2.org/2.27/en/implementer/html/ch09s03.html
>>
>> regards,
>>
>> Lars
>>
>>
>> On 22 February 2018 at 10:51, Barnabas Akumba <akumbaba...@gmail.com>
>> wrote:
>>
>>> Hello All,
>>>
>>> Has anyone come across this issue before?
>>> I'm trying to edit Datasets using the maintenance app by selecting the
>>> edit option.
>>> The dataset fails to load but gives me an error "Can not add a model
>>> without id to a ModelCollection" - See attached snip.
>>>
>>> Any suggestion on how to sort this out will be appreciated.
>>>
>>> Regards
>>>
>>>
>>> --
>>>
>>> Barnabas AKUMBA
>>>
>>> *Mobile:* +2348036195778 <+234%20803%20619%205778>
>>> *Skype:* barnabas.akumba
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>
>
> --
>
> Barnabas AKUMBA
>
> *Mobile:* +2348036195778 <+234%20803%20619%205778>
> *Skype:* barnabas.akumba
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Error editing Dataset

[Knut Staring]

Anything in your Tomcat server log?

On Fri, Feb 23, 2018 at 1:29 PM, Barnabas Akumba <akumbaba...@gmail.com>
wrote:

> Hi Knur,
>
> Thanks for the link.
> I've cleared the cache as indicated but issue still persists.
>
> Regards
>
> On Fri, Feb 23, 2018 at 11:52 AM, Knut Staring <knu...@gmail.com> wrote:
>
>> Hi Barnabas,
>>
>> Please try this: https://www.dhis2.org/tutorial
>> s/how-to-really-clear-browser-cache
>>
>> Knut
>>
>> On Fri, Feb 23, 2018 at 11:46 AM, Barnabas Akumba <akumbaba...@gmail.com>
>> wrote:
>>
>>> Hello Lars,
>>>
>>> Thanks for the link. I've followed the instruction in the above link but
>>> still experience the problem.
>>> I've tried this on both 2.26 and 2.27.
>>>
>>> Regards
>>>
>>> On Fri, Feb 23, 2018 at 9:51 AM, Lars Helge Øverland <l...@dhis2.org>
>>> wrote:
>>>
>>>> Hi Barnabas,
>>>>
>>>> please have a look at guidelines for reporting problems and tell us
>>>> your DHIS 2 version:
>>>>
>>>> https://docs.dhis2.org/2.27/en/implementer/html/ch09s03.html
>>>>
>>>> regards,
>>>>
>>>> Lars
>>>>
>>>>
>>>> On 22 February 2018 at 10:51, Barnabas Akumba <akumbaba...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hello All,
>>>>>
>>>>> Has anyone come across this issue before?
>>>>> I'm trying to edit Datasets using the maintenance app by selecting the
>>>>> edit option.
>>>>> The dataset fails to load but gives me an error "Can not add a model
>>>>> without id to a ModelCollection" - See attached snip.
>>>>>
>>>>> Any suggestion on how to sort this out will be appreciated.
>>>>>
>>>>> Regards
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> Barnabas AKUMBA
>>>>>
>>>>> *Mobile:* +2348036195778 <+234%20803%20619%205778>
>>>>> *Skype:* barnabas.akumba
>>>>>
>>>>> ___
>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>> Post to : dhis2-d...@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Lars Helge Øverland
>>>> Lead developer, DHIS 2
>>>> University of Oslo
>>>> Skype: larshelgeoverland
>>>> l...@dhis2.org
>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>
>>>>
>>>
>>>
>>> --
>>>
>>> Barnabas AKUMBA
>>>
>>> *Mobile:* +2348036195778 <+234%20803%20619%205778>
>>> *Skype:* barnabas.akumba
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> 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
>>
>
>
>
> --
>
> Barnabas AKUMBA
>
> *Mobile:* +2348036195778 <+234%20803%20619%205778>
> *Skype:* barnabas.akumba
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Importing GADM boundaries into DHIS2

[Knut Staring]

Forgot to add some regions that can be used for grouping and filtering
(these are not WHO regions):

South-eastern Asia
'BRN','IDN','KHM','LAO','MMR','MYS','PHL','SGP','THA','TLS','VNM'
Southern Asia
'AFG','BGD','BTN','IND','IRN','LKA','MDV','NPL','PAK'
Western Asia
'ARE','ARM','AZE','BHR','CYP','GEO','IRQ','ISR','JOR','KWT','LBN','OMN','PSE','QAT','SAU','SYR','TUR','YEM'
Central Asia
'KAZ','KGZ','TJK','TKM','UZB'
Eastern Asia
'CHN','HKG','JPN','KOR','MAC','MNG','PRK','TWN'
Northern Africa
'DZA','EGY','ESH','LBY','MAR','SDN','TUN'
Sub-Saharan Africa
'AGO','ATF','BDI','BEN','BFA','BWA','CAF','CIV','CMR','COD','COG','COM','CPV','DJI','ERI','ETH','GAB','GHA','GIN','GMB','GNB','GNQ','IOT','KEN','LBR','LSO','MDG','MLI','MOZ','MRT','MUS','MWI','MYT','NAM','NER','NGA','REU','RWA','SEN','SHN','SLE','SOM','SSD','STP','SWZ','SYC','TCD','TGO','TZA','UGA','ZAF','ZMB','ZWE'
'AGO','BDI','COG','COD','GNQ','GAB','RWA','STP'

On Wed, Aug 8, 2018 at 12:25 PM Knut Staring  wrote:

> Hi Nick,
>
> I have been working on a solution to import all the levels, but if you are
> really only looking for the country level, it is quite straightforward. The
> main obstacle is the size of the file, which can be significantly reduced
> by a) filtering out polygons that you don't need (e.g. Antartica) and b)
> simplifying those you do need, e.g. using http://mapshaper.org/ (which
> can also be downloaded and run locally on your laptop).
>
> The filtering can be done in several ways.
> a) It seems you already have the orgunits in your tree, which will then
> serve as a filter itself. Do you already have three-letter ISO codes for
> matching?
> b) If you did not already have the countries (or no good way of matching),
> you can use the ogr2ogr tool of the GDAL package like this:
>
> ogr2ogr -where "GID_0  in
> ('AGO','BDI','COG','COD','GNQ','GAB','RWA','STP')" countries.shp
> gadm36_0.shp
>
> c) Since we now require PostGIS (from 2.30), that is the most versatile
> tool for all of these manipulations (though not sure if the simplification
> algorithms are as good as the ones Mapshaper offers).
>
> I attach a file of all countries reduced to 4%, let me know if you are
> able to use that directly.
>
> Knut
>
> On Tue, Aug 7, 2018 at 11:38 PM Shurajit Dutta 
> wrote:
>
>> Hi everyone
>>
>> Was wondering if there was a simplified process to import GADM (
>> https://gadm.org/) boundaries into DHIS2.
>>
>> For example, if I have a global hierarchy of some sort and only want to
>> import the country-level boundaries.
>>
>> ie.
>> Global
>> ---Regional
>> -Country
>>
>> Thanks,
>> Nick
>>
>> --
>> Shurajit Dutta (MPH, MHI)
>> Health Information Systems Adviser
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
> Skype: knutstar
>


-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Importing GADM boundaries into DHIS2

[Knut Staring]

Glad it worked!

On Wed, Aug 8, 2018 at 5:43 PM Shurajit Dutta 
wrote:

> Thanks Knut, I was able to import directly from the file you shared via
> matching the ISO codes. Very helpful!
>
>
> On Wed, Aug 8, 2018 at 6:26 AM Knut Staring  wrote:
>
>> Forgot to add some regions that can be used for grouping and filtering
>> (these are not WHO regions):
>>
>> South-eastern Asia
>> 'BRN','IDN','KHM','LAO','MMR','MYS','PHL','SGP','THA','TLS','VNM'
>> Southern Asia
>> 'AFG','BGD','BTN','IND','IRN','LKA','MDV','NPL','PAK'
>> Western Asia
>>
>> 'ARE','ARM','AZE','BHR','CYP','GEO','IRQ','ISR','JOR','KWT','LBN','OMN','PSE','QAT','SAU','SYR','TUR','YEM'
>> Central Asia
>> 'KAZ','KGZ','TJK','TKM','UZB'
>> Eastern Asia
>> 'CHN','HKG','JPN','KOR','MAC','MNG','PRK','TWN'
>> Northern Africa
>> 'DZA','EGY','ESH','LBY','MAR','SDN','TUN'
>> Sub-Saharan Africa
>>
>> 'AGO','ATF','BDI','BEN','BFA','BWA','CAF','CIV','CMR','COD','COG','COM','CPV','DJI','ERI','ETH','GAB','GHA','GIN','GMB','GNB','GNQ','IOT','KEN','LBR','LSO','MDG','MLI','MOZ','MRT','MUS','MWI','MYT','NAM','NER','NGA','REU','RWA','SEN','SHN','SLE','SOM','SSD','STP','SWZ','SYC','TCD','TGO','TZA','UGA','ZAF','ZMB','ZWE'
>> 'AGO','BDI','COG','COD','GNQ','GAB','RWA','STP'
>>
>> On Wed, Aug 8, 2018 at 12:25 PM Knut Staring  wrote:
>>
>>> Hi Nick,
>>>
>>> I have been working on a solution to import all the levels, but if you
>>> are really only looking for the country level, it is quite straightforward.
>>> The main obstacle is the size of the file, which can be significantly
>>> reduced by a) filtering out polygons that you don't need (e.g. Antartica)
>>> and b) simplifying those you do need, e.g. using http://mapshaper.org/
>>> (which can also be downloaded and run locally on your laptop).
>>>
>>> The filtering can be done in several ways.
>>> a) It seems you already have the orgunits in your tree, which will then
>>> serve as a filter itself. Do you already have three-letter ISO codes for
>>> matching?
>>> b) If you did not already have the countries (or no good way of
>>> matching), you can use the ogr2ogr tool of the GDAL package like this:
>>>
>>> ogr2ogr -where "GID_0  in
>>> ('AGO','BDI','COG','COD','GNQ','GAB','RWA','STP')" countries.shp
>>> gadm36_0.shp
>>>
>>> c) Since we now require PostGIS (from 2.30), that is the most versatile
>>> tool for all of these manipulations (though not sure if the simplification
>>> algorithms are as good as the ones Mapshaper offers).
>>>
>>> I attach a file of all countries reduced to 4%, let me know if you are
>>> able to use that directly.
>>>
>>> Knut
>>>
>>> On Tue, Aug 7, 2018 at 11:38 PM Shurajit Dutta 
>>> wrote:
>>>
>>>> Hi everyone
>>>>
>>>> Was wondering if there was a simplified process to import GADM (
>>>> https://gadm.org/) boundaries into DHIS2.
>>>>
>>>> For example, if I have a global hierarchy of some sort and only want to
>>>> import the country-level boundaries.
>>>>
>>>> ie.
>>>> Global
>>>> ---Regional
>>>> -Country
>>>>
>>>> Thanks,
>>>> Nick
>>>>
>>>> --
>>>> Shurajit Dutta (MPH, MHI)
>>>> Health Information Systems Adviser
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-users@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
>>> Skype: knutstar
>>>
>>
>>
>> --
>> Knut Staring
>>
>> Department of Information, Evidence and Research
>> World Health Organization, Geneva, Switzerland
>> Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
>> Skype: knutstar
>>
>
>
> --
> Shurajit Dutta (MPH, MHI)
> Health Information Systems Adviser
>


-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Google background maps not working anymore

[Knut Staring]

It seems perhaps a key has reached its limit of calls?

See here:
https://play.dhis2.org/2.30/dhis-web-maps/?id=voX07ulo2Bq

-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Minimum Analytics Time

[Knut Staring]

Hi,

You can trigger it through the API with a cron script at any frequency you
like

Knut

On Fri, Aug 17, 2018 at 2:34 AM Walusiku Muyunda  wrote:

> Hello,
>
> Am back with another question. Is there a reason why the minimum analytics
> period is capped at Daily which results to 24 hours. Is there a way of
> reducing to say 5 hours and if there is where else, since settings only has
> the last option as daily.
>
> Kind regards.
>
>
> *Walusiku J. Muyunda*
>
>
> *"We have heaven to win and hell to shun, our lives testify better!"
> <http://wildvoices.blogspot.com/>*
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Dhis2.30 Failing to start

[Knut Staring]

Hi there,

It may not be related to this at all, but have you made sure to install the
PostGIS extension, required  from 2.30?

https://github.com/dhis2/dhis2-releases/blob/master/releases/2.30/README.md

On Thu, Aug 23, 2018 at 4:46 PM Kabango Malewezi 
wrote:

> Dear Members,
> My DHIS2.30 is failing to start. This is a clean install not an upgrade.
> Please look at the enclosed log and assist.
> I installed 2.28 on the same server with no problems. I know this is not a
> new error to most of you.
>
> The error is: Error creating bean with name
> 'org.hisp.dhis.schema.PropertyIntrospectorService': Unsatisfied dependency
> expressed through field 'sessionFactory'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name 'sessionFactory' defined in URL
> [jar:file:/home/dhis/tomcat-dhis/webapps/dhis/WEB-INF/lib/dhis-support-hibernate-2.30.jar!/META-INF/dhis/beans.xml]:
> Invocation of init method failed; nested exception is
> java.lang.OutOfMemoryError: GC overhead limit exceeded
> at
> org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749)
> at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201)
>
> See enclosed file for a complete log.
>
> Thank you in advance.
>
> --
>
>
> Name: Kabango Malewezi
>
>
> Jhpiego, City Center, Lilongwe, Malawi
>
> Mobile: +265 (0) 88 4 245 431
>
> skype: kabango.malewezi
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Importing Organisation Unit

[Knut Staring]

Hello Nibras,

I am forwarding this to the DHIS 2 Users list <
dhis2-users@lists.launchpad.net>. Please use this address for technical
queries

Regards,
Knut

On Sun, Aug 19, 2018 at 1:27 AM Nibras Ar Rakib 
wrote:

> Dear Sir,
>
> My name is Nibras Ar Rakib and currently I am working at icddr, b
> (International Centre for Diarrhoeal Disease Research, Bangladesh) as
> programmer and involved in Routine Health Information System (RHIS).
>
> We have successfully installed and configured DHIS2 (2.29) for
> aggregated data collection purpose for different region of Bangladesh.
> Problem we are currently facing is preparing the csv file for importing
> organization unit.
>
> One particular field I do not understand that in the documentation
> (
> https://docs.dhis2.org/2.29/en/developer/html/webapi_csv_metadata_import.html-
> Table: 1.19) that there is column named UID and Parent UID. During
> populating the csv, do we need to specify those UIDS and Parent UIDS (I
> know we should do that otherwise hierarchy wont populate. Also then I
> need to handle Parent UIDS programmatically)? If that happens, then I
> need to populate the csv programmatically. I also know, DHIS2 has an API
> that provide stable identifier. Is there any other way around to develop
> the hierarchical organization unit?
>
> It would be really helpful if you provide your ideas or suggestion
> regarding this.
>
> This is the first time I am posting in this team. If this this team is
> not appropriate for this question please let me know and delete this
> message.
>
> Thanks & Regards,
> Nibras Ar Rakib
> --
> This message was sent from Launchpad by
> Nibras Ar Rakib (https://launchpad.net/~nibras.rakib)
> using the "Contact this team's admins" link on the DHIS 2 Users team page
> (https://launchpad.net/~dhis2-users).
> For more information see
> https://help.launchpad.net/YourAccount/ContactingPeople
>


-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Request Help On How To Access Web API in DHIS2

[Knut Staring]

The API is accessible like this: https://play.dhis2.org/2.30/api/resources

It is documented here:
https://docs.dhis2.org/master/en/developer/html/webapi.html#webapi_introduction

Knut



On Mon, Aug 20, 2018 at 9:04 AM Getachew Chala  wrote:

> Hi all,
> I need Help On How To Access Web API in DHIS2. Please put the clear steps
> and procedures how to access DHIS2 Web API.
>
> Thanks
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Error in event creation ERROR: relation "programstageinstance" does not exist Postion: 22

[Knut Staring]

Forwarding to user list.

On Mon, Aug 20, 2018 at 3:19 AM Parveen Panchal 
wrote:

> Hello Everyone,
>
> I  have created a tracker program in DHIS2 2.30. But when I am entering
> the data from tracker it is showing the following error.
> [image: error.png]
>
> Enrollment data has been entered but unable to edit it and enter data into
> different stages,
>
>
>
> --
>
>
>
>
>
> *Regards*
> *Parveen Panchal*
> *Contact No. - **+91-7827312972, **+91-9416865938*
>


-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Tragic passing of Dr Dapo Adejumo

[Knut Staring]

How shocking and sad for us all. Dapo's enthusiasm and gentleness will be
sorely missed.

Knut

On Fri, Aug 24, 2018, 5:10 PM Adebusoye Anifalaje 
wrote:

> Dear DHIS 2 community,
>
> I am deeply saddened to inform you that Dapo passed away yesterday. This
> is still very shocking to us.
>
> We have set up a gofundme  page
> where you can donate to support his wife and two children. Even if you are
> not able to give a monetary donation his family will appreciate if you can
> share messages and memories on this page.
>
> Many thanks for your support. May his soul will rest in peace
>
> Very best wishes,
>
> - -
>
>
>
>
>
> *Busoye Anifalaje (PhD)Director of Services (Principal), BAO SystemsUK:
> +44 7901-740-757 | US: +1 682-307-0986| bus...@baosystems.com
>  | http://www.baosystems.com
>  |Skype: busoye | 2900 K Street, Suite 406,
> Washington D.C. 20007 *
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Importing GADM boundaries into DHIS2

[Knut Staring]

Hi Nick,

I have been working on a solution to import all the levels, but if you are
really only looking for the country level, it is quite straightforward. The
main obstacle is the size of the file, which can be significantly reduced
by a) filtering out polygons that you don't need (e.g. Antartica) and b)
simplifying those you do need, e.g. using http://mapshaper.org/ (which can
also be downloaded and run locally on your laptop).

The filtering can be done in several ways.
a) It seems you already have the orgunits in your tree, which will then
serve as a filter itself. Do you already have three-letter ISO codes for
matching?
b) If you did not already have the countries (or no good way of matching),
you can use the ogr2ogr tool of the GDAL package like this:

ogr2ogr -where "GID_0  in
('AGO','BDI','COG','COD','GNQ','GAB','RWA','STP')" countries.shp
gadm36_0.shp

c) Since we now require PostGIS (from 2.30), that is the most versatile
tool for all of these manipulations (though not sure if the simplification
algorithms are as good as the ones Mapshaper offers).

I attach a file of all countries reduced to 4%, let me know if you are able
to use that directly.

Knut

On Tue, Aug 7, 2018 at 11:38 PM Shurajit Dutta 
wrote:

> Hi everyone
>
> Was wondering if there was a simplified process to import GADM (
> https://gadm.org/) boundaries into DHIS2.
>
> For example, if I have a global hierarchy of some sort and only want to
> import the country-level boundaries.
>
> ie.
> Global
> ---Regional
> -Country
>
> Thanks,
> Nick
>
> --
> Shurajit Dutta (MPH, MHI)
> Health Information Systems Adviser
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Dictionary of database

[Knut Staring]

Forwarding to the DHIS 2 Users list 

On Mon, Aug 20, 2018 at 1:29 PM nolabia  wrote:

> Hello
>  I am nolabia william student at the University of Yaoundé I in
> Cameroon, I am in master 2 computer science. My end of training report
> is on the integration between the BAHMNI system (OpenMRS) and the DHIS2
> system. The big difficulty I have right now is the understanding of the
> database(DHIS2), I would like to know if I could have the data
> dictionary for a better understanding of the different tables in the
> database.
>
> Thank you
> --
> This message was sent from Launchpad by
> nolabia (https://launchpad.net/~nolabia)
> using the "Contact this team's admins" link on the DHIS 2 Users team page
> (https://launchpad.net/~dhis2-users).
> For more information see
> https://help.launchpad.net/YourAccount/ContactingPeople
>


-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp