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

[Bob Jolliffe]

Very good Lars!  Looking at the move to postgresql 10 (presumably one
or two more versions down the line), have you been considering the
native partitioning support for dealing with huge datavalue tables?
This looks like it might be very suited to our classic problem of
large amounts of historic data..

On 9 November 2017 at 20:47, Lars Helge Øverland  wrote:
>
>
> On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring  wrote:
>>
>> Good decision. I assume this means H2 will also no longer be a fallback?
>> So dhis2 live will also require PG?
>>
>
> We will continue to use H2 for internal purposes (unit testing) for a while,
> and the system will still start and mostly work on H2. However there will
> gradually be more features requiring PostgreSQL, and we hope to replace Live
> with a Docker image in near future.
>
> As part of the move to PostgreSQL we will also require the PostGIS
> extension.
>
>
>
> 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-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>

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

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

[Lars Helge Øverland]

Yes. The datavalue table is definitely a good candidate for partitioning.



On Thu, Nov 9, 2017 at 5:53 PM, Bob Jolliffe  wrote:

> Very good Lars!  Looking at the move to postgresql 10 (presumably one
> or two more versions down the line), have you been considering the
> native partitioning support for dealing with huge datavalue tables?
> This looks like it might be very suited to our classic problem of
> large amounts of historic data..
>
> On 9 November 2017 at 20:47, Lars Helge Øverland  wrote:
> >
> >
> > On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring  wrote:
> >>
> >> Good decision. I assume this means H2 will also no longer be a fallback?
> >> So dhis2 live will also require PG?
> >>
> >
> > We will continue to use H2 for internal purposes (unit testing) for a
> while,
> > and the system will still start and mostly work on H2. However there will
> > gradually be more features requiring PostgreSQL, and we hope to replace
> Live
> > with a Docker image in near future.
> >
> > As part of the move to PostgreSQL we will also require the PostGIS
> > extension.
> >
> >
> >
> > 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-devs@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 
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[Lars Helge Øverland]

On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring  wrote:

> Good decision. I assume this means H2 will also no longer be a fallback?
> So dhis2 live will also require PG?
>
>
We will continue to use H2 for internal purposes (unit testing) for a
while, and the system will still start and mostly work on H2. However there
will gradually be more features requiring PostgreSQL, and we hope to
replace Live with a Docker image in near future.

As part of the move to PostgreSQL we will also require the PostGIS
extension.



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

Re: [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-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] DHIS 2, PostgreSQL only

[Lars Helge Øverland]

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

Re: [Dhis2-devs] SMS Parse Error in DHIS2 2.28

[Ocaya Stephen]

Dear Zubair,

Following our chat conversion, it seems that the code value separator is
missing in DHIS2 2.28 and rather has a field separator which does different
things.

Sending PMTCT a=2 seems to work instead of PMTCT a.2 (Our separator)

There is also no option for Code Value separator in the command
configurations.

regards

On Thu, Nov 9, 2017 at 1:53 PM, Ocaya Stephen  wrote:

> Dear Zubair,
>
> We have a number of Keywords (refer to attached list), BUT all the
> commands seems not to be processed because of an 
> java.lang.ArrayIndexOutOfBoundsException
> Error
>
> Please see the same issues with an SMS using pmtct command name.
>
> ALSO, we had noted that reimport fucntionality of the received SMS is not
> working.
>
> Regards
>
> On Thu, Nov 9, 2017 at 1:49 PM, Zubair Asghar Raja 
> wrote:
>
>> Yes.
>> StKA a.24
>> StKA is supposed to be command name. Whereas in the snapshot I can see it
>> named as PMTCT.
>> Secondly, Field Separator ( in your case "." ) cannot be used for
>> assigning values to parameters. You can try this a=24 and I hope it will
>> work.
>>
>> Regards
>> Zubair
>>
>> On Thu, Nov 9, 2017 at 11:26 AM, Ocaya Stephen 
>> wrote:
>>
>>> Dear Zubair,
>>>
>>> Thanks for a quick response.
>>>
>>> The Command uses a KEY_VALUE_PARSER between data element codes and the
>>> values separated by a dot (".").
>>>
>>> See attached screenshot for a sample command. Is there anything
>>> seemingly wrong?
>>>
>>> Regards
>>>
>>> On Thu, Nov 9, 2017 at 1:20 PM, Zubair Asghar Raja 
>>> wrote:
>>>
 Hi Stephen,
 I can see you are using "." in sms Text. Just make sure that sms
 commands are created properly. Your sms commands should comply with rules
 provided in the documentation.

 https://docs.dhis2.org/master/en/user/html/mobile_sms_comman
 d.html#d0e35642

 Regards
 Zubair


 On Thu, Nov 9, 2017 at 11:12 AM, Ocaya Stephen 
 wrote:

> Dear Zubair and the DHIS2 Mobile team,
>
> I recently upgraded the DHIS2 to 2.28 and somehow the DHIS2 SMS
> Parsing seems not to work. Please see attached error logs.
>
> * INFO  2017-11-09 13:02:39,973 'system-process' update
> org.hisp.dhis.user.UserCredentials, name: Systemuser Mobile, uid:
> QQudwuq4KmZ (AuditLogUtil.java [http-bio-8080-exec-18])
>
> * INFO  2017-11-09 13:02:42,857 Received SMS: StKA a.24
> (SmsConsumerThread.java [taskScheduler-21])
>
> java.lang.ArrayIndexOutOfBoundsException
>
>
> Thanks for your immediate support to troubleshoot the system
> --
>
> *You can do anything, but not everything.*
>
>

>>>
>>>
>>> --
>>>
>>> *You can do anything, but not everything.*
>>>
>>>
>>
>
>
> --
>
> *You can do anything, but not everything.*
>
>


-- 

*You can do anything, but not everything.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] SMS Parse Error in DHIS2 2.28

[Zubair Asghar Raja]

Yes.
StKA a.24
StKA is supposed to be command name. Whereas in the snapshot I can see it
named as PMTCT.
Secondly, Field Separator ( in your case "." ) cannot be used for assigning
values to parameters. You can try this a=24 and I hope it will work.

Regards
Zubair

On Thu, Nov 9, 2017 at 11:26 AM, Ocaya Stephen  wrote:

> Dear Zubair,
>
> Thanks for a quick response.
>
> The Command uses a KEY_VALUE_PARSER between data element codes and the
> values separated by a dot (".").
>
> See attached screenshot for a sample command. Is there anything seemingly
> wrong?
>
> Regards
>
> On Thu, Nov 9, 2017 at 1:20 PM, Zubair Asghar Raja 
> wrote:
>
>> Hi Stephen,
>> I can see you are using "." in sms Text. Just make sure that sms commands
>> are created properly. Your sms commands should comply with rules provided
>> in the documentation.
>>
>> https://docs.dhis2.org/master/en/user/html/mobile_sms_comman
>> d.html#d0e35642
>>
>> Regards
>> Zubair
>>
>>
>> On Thu, Nov 9, 2017 at 11:12 AM, Ocaya Stephen 
>> wrote:
>>
>>> Dear Zubair and the DHIS2 Mobile team,
>>>
>>> I recently upgraded the DHIS2 to 2.28 and somehow the DHIS2 SMS Parsing
>>> seems not to work. Please see attached error logs.
>>>
>>> * INFO  2017-11-09 13:02:39,973 'system-process' update
>>> org.hisp.dhis.user.UserCredentials, name: Systemuser Mobile, uid:
>>> QQudwuq4KmZ (AuditLogUtil.java [http-bio-8080-exec-18])
>>>
>>> * INFO  2017-11-09 13:02:42,857 Received SMS: StKA a.24
>>> (SmsConsumerThread.java [taskScheduler-21])
>>>
>>> java.lang.ArrayIndexOutOfBoundsException
>>>
>>>
>>> Thanks for your immediate support to troubleshoot the system
>>> --
>>>
>>> *You can do anything, but not everything.*
>>>
>>>
>>
>
>
> --
>
> *You can do anything, but not everything.*
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] SMS Parse Error in DHIS2 2.28

[Zubair Asghar Raja]

Hi Stephen,
I can see you are using "." in sms Text. Just make sure that sms commands
are created properly. Your sms commands should comply with rules provided
in the documentation.

https://docs.dhis2.org/master/en/user/html/mobile_sms_command.html#d0e35642

Regards
Zubair


On Thu, Nov 9, 2017 at 11:12 AM, Ocaya Stephen  wrote:

> Dear Zubair and the DHIS2 Mobile team,
>
> I recently upgraded the DHIS2 to 2.28 and somehow the DHIS2 SMS Parsing
> seems not to work. Please see attached error logs.
>
> * INFO  2017-11-09 13:02:39,973 'system-process' update
> org.hisp.dhis.user.UserCredentials, name: Systemuser Mobile, uid:
> QQudwuq4KmZ (AuditLogUtil.java [http-bio-8080-exec-18])
>
> * INFO  2017-11-09 13:02:42,857 Received SMS: StKA a.24
> (SmsConsumerThread.java [taskScheduler-21])
>
> java.lang.ArrayIndexOutOfBoundsException
>
>
> Thanks for your immediate support to troubleshoot the system
> --
>
> *You can do anything, but not everything.*
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] How to step by step use Web Api.

[Ocaya Stephen]

Dear Limbe,

All you need to get started is in the Developer Manual for DHIS2. You can
download the PDF Version


Definitely, you will need some programming experience to use curl

Regards and good luck.

On Thu, Nov 9, 2017 at 12:23 PM, vunda limbe  wrote:

> Hi Stian,
>
> Thank you for, but I'm a newbie and look for a basis cours or tutorial
> that will help me to begin to use Web api.
> Your suggestion is welcome.
>
> Thanks.
>
> On Wed, Nov 8, 2017 at 8:33 AM, Stian Sandvold  wrote:
>
>> Hi Vunda,
>>
>> As far as I know, there isn't any other resources for getting started
>> working on the DHIS2 api.
>>
>> I assume you know the basics on how to consume an api, and just want to
>> get into using the DHIS2 api. If thats the case I would suggest:
>> * Setting up your own local DHIS2 instance (so you dont need to fear
>> other people changing data while you work)
>> * Use a tool like Postman or Curl to easily play around with the api
>> (There is a lot of curl examples in the documentation)
>> * Read the documentation regarding common DHIS2 api features like
>> pagination, field projection and filtering.
>> * Depending on your understanding of the DHIS2 data model, try to read
>> documentation and play around with the DHIS2 UI to get a better grip on how
>> the data model works.
>>
>> Hope this helps. Also if you are able to pinpoint exactly what you are
>> having challenges with, let us know so we can improve on this in the future.
>>
>> On Mon, Oct 30, 2017 at 5:15 PM, vunda limbe  wrote:
>>
>>> Hi Every body,
>>>
>>> I'm looking for a video or a way to begin to use web api for updating
>>> data, Accessing data, doing CRUD on DHIS2 metadata. When I read Developer
>>> manuel, I don't know where and how to begin using web api as explained in
>>> the manual.
>>> Can someone help me by providing me explanation and a case that will
>>> help me begin with web api?
>>>
>>> Your help is welcome.
>>>
>>> Thanks.
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Stian Sandvold
>> Software developer, DHIS2
>> University of Oslo
>> http://www.dhis2.org
>>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 

*You can do anything, but not everything.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] How to step by step use Web Api.

[vunda limbe]

Hi Stian,

Thank you for, but I'm a newbie and look for a basis cours or tutorial that
will help me to begin to use Web api.
Your suggestion is welcome.

Thanks.

On Wed, Nov 8, 2017 at 8:33 AM, Stian Sandvold  wrote:

> Hi Vunda,
>
> As far as I know, there isn't any other resources for getting started
> working on the DHIS2 api.
>
> I assume you know the basics on how to consume an api, and just want to
> get into using the DHIS2 api. If thats the case I would suggest:
> * Setting up your own local DHIS2 instance (so you dont need to fear other
> people changing data while you work)
> * Use a tool like Postman or Curl to easily play around with the api
> (There is a lot of curl examples in the documentation)
> * Read the documentation regarding common DHIS2 api features like
> pagination, field projection and filtering.
> * Depending on your understanding of the DHIS2 data model, try to read
> documentation and play around with the DHIS2 UI to get a better grip on how
> the data model works.
>
> Hope this helps. Also if you are able to pinpoint exactly what you are
> having challenges with, let us know so we can improve on this in the future.
>
> On Mon, Oct 30, 2017 at 5:15 PM, vunda limbe  wrote:
>
>> Hi Every body,
>>
>> I'm looking for a video or a way to begin to use web api for updating
>> data, Accessing data, doing CRUD on DHIS2 metadata. When I read Developer
>> manuel, I don't know where and how to begin using web api as explained in
>> the manual.
>> Can someone help me by providing me explanation and a case that will help
>> me begin with web api?
>>
>> Your help is welcome.
>>
>> Thanks.
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Stian Sandvold
> Software developer, DHIS2
> University of Oslo
> http://www.dhis2.org
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Android Tracker Capture app doen not allow complete on hidden mandatory fields

[Absolom MURAMIRA]

Dear Developers,
We are using the DHIS2 Tracker capture app compatible with v2.27 to conduct a 
survey. The survey design has some skip logic integrated in the tool and 
program stage. Most of the questions are mandatory but for example if the 
person is not available for the assessment, the enumerator selects not assessed 
and the jump hides the other mandatory fields and then the enumerator is 
supposed to complete the event. This was tested using the browser and it works 
perfectly well however when using the app, it hides the fields but does not 
allow to complete the event and reports that there are missing mandatory fields.
The work around is to flag this and wait for the app to sync and we complete 
the event from the browser which takes more time.

Kindly advise me if there is a better way i can accomplish this or if it is 
something that hasn't been supported yet. Thank you.
AbsolomKigali

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