Re: [Dhis2-devs] [Dhis2-users] can't delete data element

[channara rin]

YES,
thank you for reminding...
___
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] can't delete data element

[Ant Snyman]

Thanks Knutvery important.

On 18 November 2016 at 09:35, Knut Staring  wrote:

> This should be obvious, but better to remind people one time too much:
> If you decide to run DELETE queries, please always remember to first do a
> backup (pg_dump).
>
> On Nov 18, 2016 8:27 AM, "channara rin"  wrote:
>
>> Note thank you
>>
>> On Fri, Nov 18, 2016 at 2:20 PM, Ant Snyman  wrote:
>>
>>> Yes you are right. Some sql scripts you can run from the UI (SQLVIEWS -
>>> data administration) but you cannot update or delete using SQLVIEW, so in
>>> this case you would have to do it in the "back-end". What you could do to
>>> make sure is use SQLVIEW to see if that dataelementid exists in the
>>> datavalueaudit table. Something like "select * from datavalueaudit where
>>> dataelementid = .. ".
>>>
>>> Regards
>>>
>>> Ant Snyman
>>>
>>> On 18 November 2016 at 09:10, channara rin 
>>> wrote:
>>>
 ohh,i see...
 but sql script can only run on server? cannot from client side?

 On Fri, Nov 18, 2016 at 2:08 PM, Ant Snyman  wrote:

> Hi Channara,
> There is also a table called datavalueaudit which also contains a
> reference to the dataelementid. The record should also be deleted from 
> this
> table, I normally do it through sql script, not sure if deleting a
> datavalue from the UI will also remove the datavalueaudit record.
> Regards
> Ant Snyman
>
>
> On 18 November 2016 at 06:38, channara rin 
> wrote:
>
>> yes,
>> my DE use cate-combo and group.
>> so after remove group, i can delete?
>>
>>
>> On Fri, Nov 18, 2016 at 11:30 AM, Prosper BT 
>> wrote:
>>
>>> Hi Channara,
>>>
>>> Did you assign it an option set or cat-comb or grouped it in a group
>>> or even assigned it to a dataset or program,
>>>
>>> You have to check all these before deleting it.
>>>
>>> Regards
>>>
>>> Prosper Behumbiize, MPH
>>> DHIS2 Implementation| HISP Uganda/University Of Oslo
>>> +256 752 751 776 | +256 776 139 139
>>> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
>>> prospertb
>>>
>>> On Fri, Nov 18, 2016 at 5:04 AM, channara rin <
>>> rin.chann...@gmail.com> wrote:
>>>
 dear friend,
 i created new dataset and put only data element want to delete and
 then go through to delete data value already.
 but i still see the message like below:
 [image: Inline image 1]

 On Fri, Nov 18, 2016 at 9:02 AM, Shurajit Dutta <
 shurajitdu...@gmail.com> wrote:

> Hi Channara,
>
> You would have to delete all the values associated with that DE
> first.
>
> On Fri, Nov 18, 2016 at 9:43 AM, channara rin <
> rin.chann...@gmail.com> wrote:
>
>> dear all,
>> do you know how to delete data element that we already used input
>> data value?
>>
>> regards,
>> channara
>>
>> ___
>> 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
>>
>>
>
>
> --
> Shurajit Dutta
> Health Information Consultant
>


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


>>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> *Ant Snyman*
>
> *Cell: 0824910449*
>
> *Landline: 028 2713242*
>
>
> Health Information Systems Program - SA
>
> *This message and any attachments are subject to a disclaimer
> published at 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
>  and a copy will be provided to you. By replying to
> this e-mail or opening any attachment you agree to be 

Re: [Dhis2-devs] [Dhis2-users] can't delete data element

[Knut Staring]

This should be obvious, but better to remind people one time too much:
If you decide to run DELETE queries, please always remember to first do a
backup (pg_dump).

On Nov 18, 2016 8:27 AM, "channara rin"  wrote:

> Note thank you
>
> On Fri, Nov 18, 2016 at 2:20 PM, Ant Snyman  wrote:
>
>> Yes you are right. Some sql scripts you can run from the UI (SQLVIEWS -
>> data administration) but you cannot update or delete using SQLVIEW, so in
>> this case you would have to do it in the "back-end". What you could do to
>> make sure is use SQLVIEW to see if that dataelementid exists in the
>> datavalueaudit table. Something like "select * from datavalueaudit where
>> dataelementid = .. ".
>>
>> Regards
>>
>> Ant Snyman
>>
>> On 18 November 2016 at 09:10, channara rin 
>> wrote:
>>
>>> ohh,i see...
>>> but sql script can only run on server? cannot from client side?
>>>
>>> On Fri, Nov 18, 2016 at 2:08 PM, Ant Snyman  wrote:
>>>
 Hi Channara,
 There is also a table called datavalueaudit which also contains a
 reference to the dataelementid. The record should also be deleted from this
 table, I normally do it through sql script, not sure if deleting a
 datavalue from the UI will also remove the datavalueaudit record.
 Regards
 Ant Snyman


 On 18 November 2016 at 06:38, channara rin 
 wrote:

> yes,
> my DE use cate-combo and group.
> so after remove group, i can delete?
>
>
> On Fri, Nov 18, 2016 at 11:30 AM, Prosper BT 
> wrote:
>
>> Hi Channara,
>>
>> Did you assign it an option set or cat-comb or grouped it in a group
>> or even assigned it to a dataset or program,
>>
>> You have to check all these before deleting it.
>>
>> Regards
>>
>> Prosper Behumbiize, MPH
>> DHIS2 Implementation| HISP Uganda/University Of Oslo
>> +256 752 751 776 | +256 776 139 139
>> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
>> prospertb
>>
>> On Fri, Nov 18, 2016 at 5:04 AM, channara rin > > wrote:
>>
>>> dear friend,
>>> i created new dataset and put only data element want to delete and
>>> then go through to delete data value already.
>>> but i still see the message like below:
>>> [image: Inline image 1]
>>>
>>> On Fri, Nov 18, 2016 at 9:02 AM, Shurajit Dutta <
>>> shurajitdu...@gmail.com> wrote:
>>>
 Hi Channara,

 You would have to delete all the values associated with that DE
 first.

 On Fri, Nov 18, 2016 at 9:43 AM, channara rin <
 rin.chann...@gmail.com> wrote:

> dear all,
> do you know how to delete data element that we already used input
> data value?
>
> regards,
> channara
>
> ___
> 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
>
>


 --
 Shurajit Dutta
 Health Information Consultant

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


 --

 *Ant Snyman*

 *Cell: 0824910449*

 *Landline: 028 2713242*


 Health Information Systems Program - SA

 *This message and any attachments are subject to a disclaimer published
 at 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
  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.*

>>>
>>>
>>
>>
>> --
>>
>> *Ant Snyman*
>>
>> *Cell: 0824910449*
>>
>> *Landline: 028 2713242*
>>
>>
>> Health Information Systems Program - SA
>>
>> *This message and any attachments are subject to a 

Re: [Dhis2-devs] [Dhis2-users] can't delete data element

[channara rin]

Note thank you

On Fri, Nov 18, 2016 at 2:20 PM, Ant Snyman  wrote:

> Yes you are right. Some sql scripts you can run from the UI (SQLVIEWS -
> data administration) but you cannot update or delete using SQLVIEW, so in
> this case you would have to do it in the "back-end". What you could do to
> make sure is use SQLVIEW to see if that dataelementid exists in the
> datavalueaudit table. Something like "select * from datavalueaudit where
> dataelementid = .. ".
>
> Regards
>
> Ant Snyman
>
> On 18 November 2016 at 09:10, channara rin  wrote:
>
>> ohh,i see...
>> but sql script can only run on server? cannot from client side?
>>
>> On Fri, Nov 18, 2016 at 2:08 PM, Ant Snyman  wrote:
>>
>>> Hi Channara,
>>> There is also a table called datavalueaudit which also contains a
>>> reference to the dataelementid. The record should also be deleted from this
>>> table, I normally do it through sql script, not sure if deleting a
>>> datavalue from the UI will also remove the datavalueaudit record.
>>> Regards
>>> Ant Snyman
>>>
>>>
>>> On 18 November 2016 at 06:38, channara rin 
>>> wrote:
>>>
 yes,
 my DE use cate-combo and group.
 so after remove group, i can delete?


 On Fri, Nov 18, 2016 at 11:30 AM, Prosper BT  wrote:

> Hi Channara,
>
> Did you assign it an option set or cat-comb or grouped it in a group
> or even assigned it to a dataset or program,
>
> You have to check all these before deleting it.
>
> Regards
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation| HISP Uganda/University Of Oslo
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>
> On Fri, Nov 18, 2016 at 5:04 AM, channara rin 
> wrote:
>
>> dear friend,
>> i created new dataset and put only data element want to delete and
>> then go through to delete data value already.
>> but i still see the message like below:
>> [image: Inline image 1]
>>
>> On Fri, Nov 18, 2016 at 9:02 AM, Shurajit Dutta <
>> shurajitdu...@gmail.com> wrote:
>>
>>> Hi Channara,
>>>
>>> You would have to delete all the values associated with that DE
>>> first.
>>>
>>> On Fri, Nov 18, 2016 at 9:43 AM, channara rin <
>>> rin.chann...@gmail.com> wrote:
>>>
 dear all,
 do you know how to delete data element that we already used input
 data value?

 regards,
 channara

 ___
 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


>>>
>>>
>>> --
>>> Shurajit Dutta
>>> Health Information Consultant
>>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>

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


>>>
>>>
>>> --
>>>
>>> *Ant Snyman*
>>>
>>> *Cell: 0824910449*
>>>
>>> *Landline: 028 2713242*
>>>
>>>
>>> Health Information Systems Program - SA
>>>
>>> *This message and any attachments are subject to a disclaimer published
>>> at 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
>>>  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.*
>>>
>>
>>
>
>
> --
>
> *Ant Snyman*
>
> *Cell: 0824910449*
>
> *Landline: 028 2713242*
>
>
> Health Information Systems Program - SA
>
> *This message and any attachments are subject to a disclaimer published at
> 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
>  and a copy will be provided to 

Re: [Dhis2-devs] [Dhis2-users] can't delete data element

[Ant Snyman]

Hi Channara,
There is also a table called datavalueaudit which also contains a reference
to the dataelementid. The record should also be deleted from this table, I
normally do it through sql script, not sure if deleting a datavalue from
the UI will also remove the datavalueaudit record.
Regards
Ant Snyman


On 18 November 2016 at 06:38, channara rin  wrote:

> yes,
> my DE use cate-combo and group.
> so after remove group, i can delete?
>
>
> On Fri, Nov 18, 2016 at 11:30 AM, Prosper BT  wrote:
>
>> Hi Channara,
>>
>> Did you assign it an option set or cat-comb or grouped it in a group or
>> even assigned it to a dataset or program,
>>
>> You have to check all these before deleting it.
>>
>> Regards
>>
>> Prosper Behumbiize, MPH
>> DHIS2 Implementation| HISP Uganda/University Of Oslo
>> +256 752 751 776 | +256 776 139 139
>> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
>> prospertb
>>
>> On Fri, Nov 18, 2016 at 5:04 AM, channara rin 
>> wrote:
>>
>>> dear friend,
>>> i created new dataset and put only data element want to delete and then
>>> go through to delete data value already.
>>> but i still see the message like below:
>>> [image: Inline image 1]
>>>
>>> On Fri, Nov 18, 2016 at 9:02 AM, Shurajit Dutta >> > wrote:
>>>
 Hi Channara,

 You would have to delete all the values associated with that DE first.

 On Fri, Nov 18, 2016 at 9:43 AM, channara rin 
 wrote:

> dear all,
> do you know how to delete data element that we already used input data
> value?
>
> regards,
> channara
>
> ___
> 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
>
>


 --
 Shurajit Dutta
 Health Information Consultant

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


-- 

*Ant Snyman*

*Cell: 0824910449*

*Landline: 028 2713242*


Health Information Systems Program - SA

-- 


*This message and any attachments are subject to a disclaimer published at 
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 
 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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] can't delete data element

[channara rin]

yes,
my DE use cate-combo and group.
so after remove group, i can delete?


On Fri, Nov 18, 2016 at 11:30 AM, Prosper BT  wrote:

> Hi Channara,
>
> Did you assign it an option set or cat-comb or grouped it in a group or
> even assigned it to a dataset or program,
>
> You have to check all these before deleting it.
>
> Regards
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation| HISP Uganda/University Of Oslo
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>
> On Fri, Nov 18, 2016 at 5:04 AM, channara rin 
> wrote:
>
>> dear friend,
>> i created new dataset and put only data element want to delete and then
>> go through to delete data value already.
>> but i still see the message like below:
>> [image: Inline image 1]
>>
>> On Fri, Nov 18, 2016 at 9:02 AM, Shurajit Dutta 
>> wrote:
>>
>>> Hi Channara,
>>>
>>> You would have to delete all the values associated with that DE first.
>>>
>>> On Fri, Nov 18, 2016 at 9:43 AM, channara rin 
>>> wrote:
>>>
 dear all,
 do you know how to delete data element that we already used input data
 value?

 regards,
 channara

 ___
 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


>>>
>>>
>>> --
>>> Shurajit Dutta
>>> Health Information Consultant
>>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Events not getting auto-generated

[Arun Paul]

Hi Abyot,

That's not the case. Anyway I cleaned the browser cache just to be double
sure.
The issue is still not solved.
Any other ideas?

​Thanks
,
- Arun Paul

On Wed, Nov 16, 2016 at 11:19 AM, Abyot Asalefew Gizaw 
wrote:

> May be the meta data is changed after the app has run... if this is the
> case, the solution is to fully clear your browser cache and run the app
> again.
>
> ---
>
> Thank you,
> Abyot.
> (sent from mobile)
>
> On Nov 16, 2016 03:39, "Arun Paul"  wrote:
>
>> Hi Abyot,
>>
>> This issue is still not resolved. I am attaching the screenshots here.
>> I could not find anything error-like on the browser console too. I have
>> attached the both the screenshots, just after enrolling to the program and
>> just after manually generating the stage1 event.
>>
>>
>> Let me know if you find anything.
>> Thanks in advance.
>>
>> - Arun Paul
>>
>> On Mon, Nov 14, 2016 at 12:25 PM, Abyot Asalefew Gizaw 
>> wrote:
>>
>>> Hi Arun,
>>>
>>> It works fine in our demo server - which is 2.25. I don't remember any
>>> big change in that area between 2.23 and 2.25.
>>>
>>> Can you share us some screenshots? Also, do you see anything in red
>>> under your browser console?
>>>
>>> --
>>> Abyot A. Gizaw.
>>> Senior Engineer, DHIS2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>> On Mon, Nov 14, 2016 at 6:11 AM, Arun Paul  wrote:
>>>
 Thanks Prosper.
 Yes I set the incident date as the delivery date but it does not help.
 Is there anything else I have to check?

 Regards,
 Arun

 On Mon, Nov 14, 2016 at 1:09 AM, Prosper BT  wrote:

> Dear Arun,
>
> Is delivery date your incident date?
> You must have an incident date or use enrollment date for the auto
> generate events to work.
>
> Regards
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation| HISP Uganda/University Of Oslo
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>
> On Sat, Nov 12, 2016 at 3:22 PM, Arun Paul 
> wrote:
>
>> Hi everyone,
>>
>> I am creating a program for tracking the PNC visits in the lines of
>> "​
>> MNCH / PNC (Adult Woman)
>> ​"​ Program configured in the Sierra Leon Demo system.
>>
>> In my case I have created multiple PNC visits such as PNC 1, PNC2,
>> PNC3 that would occur at 1,3,5 days after the delivery date which is the
>> incident date of the program.
>>
>> I would like these events to be auto-generated at scheduled days, so
>> that I can generate overdue reports for the health workers to act upon.
>> However, I cannot get this working, despite doing all the
>> configurations(Listed down below). Even after the required number of 
>> days,
>>  I can't see the overdue events are being generated for the patients, nor
>> can I see them listed in the events overdue reports.
>>
>> In the program stage configuration for each stages :
>> "Scheduled days from start" was given a valid value.
>> "Auto-generate event" was ticked on.
>>
>> Have I missed any configuration? I am using version 2.23.
>>
>> Please help.
>>
>> Thanks,
>> Arun Paul.
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>

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


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

Re: [Dhis2-devs] [Dhis2-users] can't delete data element

[Prosper BT]

Hi Channara,

Did you assign it an option set or cat-comb or grouped it in a group or
even assigned it to a dataset or program,

You have to check all these before deleting it.

Regards

Prosper Behumbiize, MPH
DHIS2 Implementation| HISP Uganda/University Of Oslo
+256 752 751 776 | +256 776 139 139
pros...@hispuganda.org  | pros...@dhis2.org | Skype:
prospertb

On Fri, Nov 18, 2016 at 5:04 AM, channara rin 
wrote:

> dear friend,
> i created new dataset and put only data element want to delete and then go
> through to delete data value already.
> but i still see the message like below:
> [image: Inline image 1]
>
> On Fri, Nov 18, 2016 at 9:02 AM, Shurajit Dutta 
> wrote:
>
>> Hi Channara,
>>
>> You would have to delete all the values associated with that DE first.
>>
>> On Fri, Nov 18, 2016 at 9:43 AM, channara rin 
>> wrote:
>>
>>> dear all,
>>> do you know how to delete data element that we already used input data
>>> value?
>>>
>>> regards,
>>> channara
>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> Shurajit Dutta
>> Health Information Consultant
>>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Phone Number not supported as Data element value type

[Prosper BT]

Dear Team,

With the latest build of 2.25,
Version:2.25Build revision:a129625

Data element value type - Phone Number is not supported see below

[image: Inline image 1]

Yet its okay for attributes
[image: Inline image 2]

Regards

Prosper Behumbiize, MPH
DHIS2 Implementation| HISP Uganda/University Of Oslo
+256 752 751 776 | +256 776 139 139
pros...@hispuganda.org  | pros...@dhis2.org | Skype:
prospertb
___
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] can't delete data element

[channara rin]

dear friend,
i created new dataset and put only data element want to delete and then go
through to delete data value already.
but i still see the message like below:
[image: Inline image 1]

On Fri, Nov 18, 2016 at 9:02 AM, Shurajit Dutta 
wrote:

> Hi Channara,
>
> You would have to delete all the values associated with that DE first.
>
> On Fri, Nov 18, 2016 at 9:43 AM, channara rin 
> wrote:
>
>> dear all,
>> do you know how to delete data element that we already used input data
>> value?
>>
>> regards,
>> channara
>>
>> ___
>> 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
>>
>>
>
>
> --
> Shurajit Dutta
> Health Information Consultant
>
___
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] can't delete data element

[Shurajit Dutta]

Hi Channara,

You would have to delete all the values associated with that DE first.

On Fri, Nov 18, 2016 at 9:43 AM, channara rin 
wrote:

> dear all,
> do you know how to delete data element that we already used input data
> value?
>
> regards,
> channara
>
> ___
> 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
>
>


-- 
Shurajit Dutta
Health Information Consultant
___
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] can't delete data element

[channara rin]

dear all,
do you know how to delete data element that we already used input data
value?

regards,
channara
___
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] [Bug 1638563] Re: 2.24 Data Entry not showing entered values for optionsets

[Lars Helge Øverland]

This should be back-ported to 2.24 now. Please let us know if it works.

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1638563

Title:
  2.24 Data Entry not showing entered values for optionsets

Status in DHIS:
  New

Bug description:
  2.24, the latest build:

  When reviewing already entered data in the data entry app, it will
  fail to display the last entered value.

  This was fixed in 2.25, hopefully this can be back ported to 2.24?

  Steps to reproduce:
  1. create element with an optionset (assign to dataset, assign dataset to 
orgunit)
  2. enter data
  3. refresh page
  4. review audit log for data element to show that it does have a value, 
although it does not display it as having one.

  This behavior is the same on custom forms, section forms, and default.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1638563/+subscriptions

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

Re: [Dhis2-devs] [Bug 1638563] Re: 2.24 Data Entry not showing entered values for optionsets

[Timothy Harding]

Tested and working, thanks devteam!!!


*Timothy Harding*
Sr. Systems Analyst, BAO Systems
+1 202-536-1541 | thard...@baosystems.com | http://www.baosystems.com | Skype:
hardi...@gmail.com | 2900 K Street, Suite 404, Washington D.C. 20007

On Thu, Nov 17, 2016 at 3:15 PM, Lars Helge Øverland 
wrote:

> This should be back-ported to 2.24 now. Please let us know if it works.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1638563
>
> Title:
>   2.24 Data Entry not showing entered values for optionsets
>
> Status in DHIS:
>   New
>
> Bug description:
>   2.24, the latest build:
>
>   When reviewing already entered data in the data entry app, it will
>   fail to display the last entered value.
>
>   This was fixed in 2.25, hopefully this can be back ported to 2.24?
>
>   Steps to reproduce:
>   1. create element with an optionset (assign to dataset, assign dataset
> to orgunit)
>   2. enter data
>   3. refresh page
>   4. review audit log for data element to show that it does have a value,
> although it does not display it as having one.
>
>   This behavior is the same on custom forms, section forms, and default.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1638563/+subscriptions
>

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1638563

Title:
  2.24 Data Entry not showing entered values for optionsets

Status in DHIS:
  New

Bug description:
  2.24, the latest build:

  When reviewing already entered data in the data entry app, it will
  fail to display the last entered value.

  This was fixed in 2.25, hopefully this can be back ported to 2.24?

  Steps to reproduce:
  1. create element with an optionset (assign to dataset, assign dataset to 
orgunit)
  2. enter data
  3. refresh page
  4. review audit log for data element to show that it does have a value, 
although it does not display it as having one.

  This behavior is the same on custom forms, section forms, and default.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1638563/+subscriptions

___
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] Average Sum in Org unit Hierarchy

[David Muturi]

Hi Lars,
Many thanks for your response. Adding a bi-weekly period type will
definitely be a good feature to have. However in my example screen shot the
value for one month e.g. July is 20 and since it was collected for one week
then the average is 20/1 which is 20. What the system is doing is 20
/(31/7) = 4.5,given July has 31 days which means the system is including
weeks in which no data was collected and mathematically this is incorrect.
If formula for calculating this can be fixed to be a count of the weeks in
which data is entered (including zeroes) then it would be mathematically
correct instead of including periods in which no data is collected.
rgds
David

2016-11-17 20:49 GMT+03:00 Lars Helge Øverland :

> Hi David,
>
> the way the average+sum aggregation works is roughly this:
>
>
> sum( [days in data period] X data value ) / [days-in-aggregation-period]
>
>
> In other words, we take the sum of the product of no of days in the data
> value period and data value, divided by no of days in aggregation period.
>
> Data value period is the period for which the raw data is collected
> (weekly in your case). Aggregation period is the period which is requested
> in analytics (monthly and quarterly in your case).
>
> So in this case, the problem is that you capture data by weeks which in
> reality represent bi-weeks - this confuses the aggregation output. The
> holes in the data (you have many weeks without data) will pull down the
> average score. Based on the rules outlined the results seems correct from
> what I can see.
>
>
> We could rather look into adding support for a bi-weekly period type.
>
>
> best regards,
>
> Lars
>
>
>
> On Wed, Nov 16, 2016 at 2:24 PM, David Muturi  wrote:
>
>> Hi Lars,
>> Many thanks for your response, since we do not have biweekly defined as a
>> dhis2 period type(which would be great to have), we have configured the
>> dataset to be weekly but only that data is entered on a biweekly basis,
>> meaning one week will miss data while another will have based on when it
>> was collected. I have attached an excel download from the datavalues table
>> as well as a screen shot showing the weekly periods that data is collected.
>> rgds
>> David
>>
>> 2016-11-16 14:08 GMT+03:00 Lars Helge Øverland :
>>
>>> Hi David,
>>>
>>> sounds strange indeed. We need some more info. Can you include bi-weekly
>>> periods in your screenshot so that we can see what the original captured
>>> value is?
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>>
>>> On Mon, Nov 14, 2016 at 8:50 PM, David Muturi 
>>> wrote:
>>>
 Hi Team,
 I have a data element set us Average sum in org unit hierarchy and
 collected on a bi weekly basis, when I select the data in the pivot table,
 the average values are bizarre(see attachment). Is this how the above
 aggregation operator is meant to work or its a bug?
 rgds
 David

 ___
 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 
>>>
>>>
>>
>
>
> --
> 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] Average Sum in Org unit Hierarchy

[Lars Helge Øverland]

Hi David,

the way the average+sum aggregation works is roughly this:


sum( [days in data period] X data value ) / [days-in-aggregation-period]


In other words, we take the sum of the product of no of days in the data
value period and data value, divided by no of days in aggregation period.

Data value period is the period for which the raw data is collected (weekly
in your case). Aggregation period is the period which is requested in
analytics (monthly and quarterly in your case).

So in this case, the problem is that you capture data by weeks which in
reality represent bi-weeks - this confuses the aggregation output. The
holes in the data (you have many weeks without data) will pull down the
average score. Based on the rules outlined the results seems correct from
what I can see.


We could rather look into adding support for a bi-weekly period type.


best regards,

Lars



On Wed, Nov 16, 2016 at 2:24 PM, David Muturi  wrote:

> Hi Lars,
> Many thanks for your response, since we do not have biweekly defined as a
> dhis2 period type(which would be great to have), we have configured the
> dataset to be weekly but only that data is entered on a biweekly basis,
> meaning one week will miss data while another will have based on when it
> was collected. I have attached an excel download from the datavalues table
> as well as a screen shot showing the weekly periods that data is collected.
> rgds
> David
>
> 2016-11-16 14:08 GMT+03:00 Lars Helge Øverland :
>
>> Hi David,
>>
>> sounds strange indeed. We need some more info. Can you include bi-weekly
>> periods in your screenshot so that we can see what the original captured
>> value is?
>>
>> regards,
>>
>> Lars
>>
>>
>>
>> On Mon, Nov 14, 2016 at 8:50 PM, David Muturi  wrote:
>>
>>> Hi Team,
>>> I have a data element set us Average sum in org unit hierarchy and
>>> collected on a bi weekly basis, when I select the data in the pivot table,
>>> the average values are bizarre(see attachment). Is this how the above
>>> aggregation operator is meant to work or its a bug?
>>> rgds
>>> David
>>>
>>> ___
>>> 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 
>>
>>
>


-- 
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] Multiple calendars on same instance

[Lars Helge Øverland]

Hi Craig,

unfortunately we do not plan to support that in the near future. The
calendar has a big impact on the system including some of the shared
resources such as analytics tables which makes it hard to adapt per user. I
do understand the need / requirement though so let's keep this open for the
future.

best regards,

Lars


On Thu, Nov 17, 2016 at 1:18 PM, Craig Hollingsworth <
craig.hollingswo...@nrc.no> wrote:

> Hi,
>
>
>
> Hope you’re well.
>
>
>
> Just wondered if there are any plans to enable localised calendars on the
> same global instance?
>
>
>
> Many thanks
>
>
>
> Craig
>
>
>
>
>
> ___
> 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] SQL Exception when selecting event data items in pivot tables

[Lars Helge Øverland]

Hi Jose,

this is caused by the "None" aggregation type. It needs to be set in order
to have the event analytics work properly.

I have reported the maintenance app issue here:

https://github.com/dhis2/maintenance-app/issues/284

We will fix. If it is urgent you can set the aggregation type through the
API or in database.

best regards,

Lars





On Tue, Nov 8, 2016 at 6:24 AM, Jose Garcia Muñoz 
wrote:

>
> Hi devs,
>
> each time I try to do some calculation with event data items
> (numeric/integer/.. tracker dataelements), I'm getting the following SQL
> exception (attached at the bottom of them email). The SQL is:
>
> select none("DvTQcjDWH3M") as value,"monthly" from 
> analytics_event_2016_lyyizex7izm
> where Monthly in ('201601', '201602', '201603', '201604', '201605',
> '201606', '201607', '201608', '201609', '201610') and (uidlevel1 =
> 'FvUGp8I75zV' ) group by "monthly" limit 11
>
> The table 'analytics_event_2016_lyyizex7izm' exists in the database, so I
> believe this is happening becuase the agg operator should be 'sum' instead
> of 'none' (otherwise we would need to group also by the "DvTQcjDWH3M"
> column). I check the dataelement definition and in fact the agg type is
> 'none'. However in 2.25, the interface does not allow us to create tracker
> dataelements with an aggregation type different than 'none'..
>
> Would this be related to the issue we are having? Am I missing something?
> It is strange because it is working in the Sierra Leone demo, but I don't
> know if this is because the datelements has been upgraded from the previous
> version, while I'm creating them directly in 2.25
>
> Many thanks
> Jose
>
>
> * INFO  2016-11-08 05:45:59,032 Query failed, likely because the requested
> analytics table does not exist (JdbcEventAnalyticsManager.java
> [http-apr-8080-exec-4])
> org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
> SQL grammar [select none("DvTQcjDWH3M") as value,"monthly" from
> analytics_event_2016_lyyizex7izm where Monthly in ('201601', '201602',
> '201603', '201604', '201605', '201606', '201607', '201608', '201609',
> '201610') and (uidlevel1 = 'FvUGp8I75zV' ) group by "monthly" limit
> 11]; nested exception is org.postgresql.util.PSQLException: ERROR:
> error de sintaxis en o cerca de ½(╗
>   Position: 12
> at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTransl
> ator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
> at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTr
> anslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
>
> ___
> 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] Unable to create a favourites on GIS module

[Lars Helge Øverland]

Hi Archana and Jose,

are you able to privately share a login to the instances so that we can
check it out?

regards,

Lars



On Tue, Nov 8, 2016 at 12:30 PM, Jose Garcia Muñoz 
wrote:

>
>
> Hi Morten,
>
> also we (PSI) are having the same problem. For some reason the uid is null
> when trying to save the favourite in the mapview table of the database.
>
> Don't know why it is working on the demo, but no in our database...
>
> On Tue, Nov 8, 2016 at 12:11 PM, Archana Chillala <
> archa...@thoughtworks.com> wrote:
>
>> Hi Morten,
>>
>> You're right, it works fine on the play server, but not on our machines.
>> Not sure of the reason, though.
>>
>>
>>
>>
>> Archana Chillala
>> Application Developer
>> Email archa...@thoughtworks.com
>> Telephone +91 9100960533 <+91+9100960533>
>> [image: ThoughtWorks]
>> 
>>
>> On Mon, Nov 7, 2016 at 7:04 AM, Morten Olav Hansen 
>> wrote:
>>
>>> Hi Archana
>>>
>>> Seems to work fine on the play/demo server, but maybe you have a certain
>>> config that doesn't work.
>>>
>>> Can you try and reproduce on [1] and give us the steps back?
>>>
>>> [1] https://play.dhis2.org/demo (admin/district)
>>>
>>> --
>>> Morten Olav Hansen
>>> Senior Engineer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>> On Fri, Nov 4, 2016 at 7:18 PM, Archana Chillala <
>>> archa...@thoughtworks.com> wrote:
>>>
 Hi,

 We are using the latest version of DHIS 2.25 (build - 5e16867).
 We are trying to create a favourite on GIS module, but it does not get
 created. Following is the exception it throws in the logs.


 * INFO  2016-11-03 11:43:07,115 'admin' create
 org.hisp.dhis.mapping.Map, name: amsterdam location, uid: c9wq3KMvvuy
 (AuditLogUtil.java [http-bio-8080-exec-2])
 * WARN  2016-11-03 11:43:07,131 SQL Error: 0, SQLState: 23502
 (SqlExceptionHelper.java [http-bio-8080-exec-2])
 * *ERROR 2016-11-03 11:43:07,133 ERROR: null value in column "uid"
 violates not-null constraint*
 *  Detail: Failing row contains (369, null, null, null, null, boundary,
 null, f, f, f, null, null, null, null, null, null, null, null, null, null,
 5, null, 1, null, null, f, f, 11px, null, normal, null, f, null, 0, null,
 null, null). (SqlExceptionHelper.java [http-bio-8080-exec-2])*
 * ERROR 2016-11-03 11:43:07,134 HHH000346: Error during managed flush
 [could not execute statement] (SessionImpl.java [http-bio-8080-exec-2])
 org.springframework.dao.DataIntegrityViolationException: could not
 execute statement; SQL [n/a]; constraint [uid]; nested exception is
 org.hibernate.exception.ConstraintViolationException: could not
 execute statement
 at org.springframework.orm.hibernate5.SessionFactoryUtils.conve
 rtHibernateAccessException(SessionFactoryUtils.java:164)
 at org.springframework.orm.hibernate5.HibernateTransactionManag
 er.convertHibernateAccessException(HibernateTransactionManag
 er.java:741)
 at org.springframework.orm.hibernate5.HibernateTransactionManag
 er.doCommit(HibernateTransactionManager.java:589)
 at org.springframework.transaction.support.AbstractPlatformTran
 sactionManager.processCommit(AbstractPlatformTransactionMana
 ger.java:761)
 at org.springframework.transaction.support.AbstractPlatformTran
 sactionManager.commit(AbstractPlatformTransactionManager.java:730)
 at org.springframework.transaction.interceptor.TransactionAspec
 tSupport.commitTransactionAfterReturning(TransactionAspectSu
 pport.java:485)
 at org.springframework.transaction.interceptor.TransactionAspec
 tSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
 at org.springframework.transaction.interceptor.TransactionInter
 ceptor.invoke(TransactionInterceptor.java:96)
 at org.springframework.aop.framework.ReflectiveMethodInvocation
 .proceed(ReflectiveMethodInvocation.java:179)
 at org.springframework.aop.interceptor.ExposeInvocationIntercep
 tor.invoke(ExposeInvocationInterceptor.java:92)
 at org.springframework.aop.framework.ReflectiveMethodInvocation
 .proceed(ReflectiveMethodInvocation.java:179)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
 JdkDynamicAopProxy.java:208)
 at com.sun.proxy.$Proxy130.addMap(Unknown Source)
 at org.hisp.dhis.webapi.controller.mapping.MapController.postJs
 onObject(MapController.java:129)
 at sun.reflect.GeneratedMethodAccessor1850.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
 thodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at org.springframework.web.method.support.InvocableHandlerMetho
 d.doInvoke(InvocableHandlerMethod.java:221)
 at 

Re: [Dhis2-devs] Average (sum in org unit hierarchy) not working in 2.24 and 2.25?

[Lars Helge Øverland]

Hi Jose,

these issues should be fixed now (same problem as previous issue).

regards,

Lars





On Fri, Nov 11, 2016 at 5:11 AM, Jose Garcia Muñoz 
wrote:

>
> More info about this...
>
> We only have data for October 2016 (20), and September 2016 (4). If I
> select periods as a filter, this is what happens:
>
> 1) Last month. The value should be 20!!
>
> [image: Inline image 1]
>
> 2) Last 3 months, last 6 months, and last 12 months, gives 24.7. It
> calculates the sum (with the strange 0.7), no the average.
>
> [image: Inline image 2]
>
> 3) This Quarter (approx, the real result should be 6.666)
>
> [image: Inline image 3]
>
> 4) Last Quarter (correct!)
>
> [image: Inline image 4]
>
>
> 5) This six-month (approx, the result should be 4. Don't understand why
> the addition of 0.1 as the results of divisions are integers)
>
> [image: Inline image 5]
>
> 6) This year (correct!)
>
> [image: Inline image 6]
>
>
> Will be great to have your feedback, as this is very urgent for us! :) .
> It seems it works well (but with some rounding problems) when the periods
> selected in the analytics are quartes, six-months, years, etc. but no for
> months (that calculates the total).
>
> Many thanks
> Jose
>
> On Tue, Nov 8, 2016 at 2:19 PM, Jose Garcia Muñoz 
> wrote:
>
>>
>> Dear devs,
>>
>> I have the 'test' dataelement which its Agregation type is 'Average (sum
>> in org unit hierarchy)', however it doesn't seem to calculate the average
>> for periods. For example
>>
>> [image: Inline image 1]
>>
>> if a select the period as filter I suppose I should get 12 right?
>> However, what I get is:
>>
>> [image: Inline image 2]
>>
>> 24.7 that I don't understand. Am I doing something wrong? Is it a bug?
>> This is very urgent for us. If it is a bug, we would need a fix for both,
>> 2.24 and 2.25. Would that be possible?
>>
>> Sum accross org. unit tree seems to be ok
>>
>> Thanks much
>> Jose
>>
>>
>
> ___
> 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] Average (sum in org unit hierarchy) not working in 2.24 and 2.25?

[Lars Helge Øverland]

Hi Jose,

On Tue, Nov 8, 2016 at 2:19 PM, Jose Garcia Muñoz 
wrote:

>
> Dear devs,
>
> I have the 'test' dataelement which its Agregation type is 'Average (sum
> in org unit hierarchy)', however it doesn't seem to calculate the average
> for periods. For example
>
> [image: Inline image 1]
>
> if a select the period as filter I suppose I should get 12 right? However,
> what I get is:
>
> [image: Inline image 2]
>
> 24.7 that I don't understand. Am I doing something wrong? Is it a bug?
> This is very urgent for us. If it is a bug, we would need a fix for both,
> 2.24 and 2.25. Would that be possible?
>
>
This was a bug. Data elements with "sum + avg in hierarchy" aggregation
operator were not handled properly when you had multiple periods as filter.
Fixed now in 2.24 -> master.


best regards,

Lars




> Sum accross org. unit tree seems to be ok
>
> Thanks much
> Jose
>
>
> ___
> 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

[Dhis2-devs] Problem when print a "repport based on the form"

[Mamadou Diao Diallo]

Hello everyone,
I encounter some problem when i print a repport based on the form.
Insteat of having the form in the printed file, i have html tags.

I use : DHIS2 2.22
   Ubuntu Version 3.19.0-25-generic

Please find attached two screenshots.

Best regards.

Diao

-- 
*DIALLO MAMADOU DIAO CONSEILLER IT, SPECIALISTE DE DHIS 2 **( District
Health Information Software )*
*MEASURE Evaluation | JSI*
*PHONE : 623909413 | 662256106*
*SKYPE : diawwdiallo*
www.jsi.com
___
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] Fwd: Getting dataStore from dhis server

[Mark Polak]

Hey,

Not sure if you still need help with this but it looks like Angular2?

I believe that this.http.get returns an Observable, so you'll need to
subscribe to it. You might want to have a look at [1]

[1]
https://angular.io/docs/ts/latest/guide/server-communication.html#!#the-herolistcomponent-class

On Mon, Nov 14, 2016 at 4:35 PM, Halvdan Hoem Grelland 
wrote:

> Also, for future reference 
>
>
>
> On Mon, Nov 14, 2016 at 3:08 PM, Stian Sandvold  wrote:
>
>> Hi. Could you try JSON.stringify() instead of to toString?
>>
>> On 14 Nov 2016 3:05 p.m., "Knut Staring"  wrote:
>>
>>> Hi devs,
>>>
>>> Could you please respond to this?
>>>
>>> Thanks,
>>> Knut
>>>
>>> -- Forwarded message --
>>> From: 
>>> Date: Mon, Nov 14, 2016 at 11:06 AM
>>> Subject: Getting dataStore from dhis server
>>> To: "knu...@ifi.uio.no" 
>>>
>>>
>>>
>>> Whenever we try to get a json object containing all the dataStore items,
>>> it returns an empty object.
>>>
>>>
>>>
>>> This is the code which is run at pageload.
>>>
>>>
>>>
>>>
>>> loadObjectList(): *void *{
>>>
>>>
>>> console.log("" + *this*.appService.getNamespaces());
>>>
>>>
>>>
>>> }
>>>
>>>
>>>
>>>
>>>
>>> This method in the app.component.ts file references the getNamespaces
>>> function in the app.service.ts file
>>>
>>>
>>>
>>>
>>>
>>>
>>> *private *serverUrl = 'https://play.dhis2.org/test/api/dataStore';
>>>
>>> *private *headers = *new *Headers({'Content-Type': 'application/json'});
>>>
>>>
>>>
>>>
>>> getNamespaces(): *any*{
>>>
>>>
>>>
>>>
>>> *var *;
>>>  = *this*.http.get(*this*.serverUrl, {headers: *this*.headers})
>>> .map(res => res.json());
>>> console.log(": " + .toString());
>>> *return *;
>>>
>>>
>>>
>>> }
>>>
>>>
>>>
>>> This method tries to contact the dhis2.org/test server to get the
>>> dataStore object.
>>>
>>> I know that it exist, as the url ‘https://play.dhis2.org/test/a
>>> pi/dataStore’ gives
>>>
>>> ["METADATASTORE","social-media-video"]
>>>
>>>
>>>
>>> This tells me that I should at least get something, but I don’t.
>>>
>>>
>>>
>>> I also tried to add my client to the CORS whitelist, and tried different
>>> types of header, but nothing works.
>>>
>>>
>>>
>>> I constantly get the response
>>>
>>> app.service.ts:91   : [object Object]
>>>
>>> app.component.ts:195 [object Object]
>>>
>>>
>>>
>>> Hope you have an answer for this
>>>
>>>
>>>
>>> Regards, Magnus W. Molaug
>>>
>>>
>>>
>>> --
>>> Cheers,
>>> Knut Staring
>>>
>>> ___
>>> 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
>>
>>
>
>
> --
> Halvdan Hoem Grelland
> Software developer, DHIS 2
> 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
>
>


-- 
Regards,


Mark Polak
Software developer, DHIS 2
University of Oslo
http://www.dhis2.org 
m...@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] [Bug 1642594] [NEW] Problem inserting dataelement name with special character in tracker custom form

[edem]

Public bug reported:

It is impossible to insert dataelements that have single quote or
apostrophe (as used in french). Example data element with name << Age de
l'enfant>> cannot be inserted while it will work for the name <>

** Affects: dhis2
 Importance: Undecided
 Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1642594

Title:
  Problem inserting  dataelement name with special character in tracker
  custom form

Status in DHIS:
  New

Bug description:
  It is impossible to insert dataelements that have single quote or
  apostrophe (as used in french). Example data element with name << Age
  de l'enfant>> cannot be inserted while it will work for the name <>

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1642594/+subscriptions

___
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] Multiple calendars on same instance

[Craig Hollingsworth]

Hi,

Hope you're well.

Just wondered if there are any plans to enable localised calendars on the same 
global instance?

Many thanks

Craig


___
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] Module SIG can't open !

[GUY ROLLAND KOUASSI]

Hello everyone !

For some time, after the migration of dhis 2.19 to 2.24, we can no
longer open the GIS module. I have cleared the cache of the browser and
even that of DHIS 2, that did not give anything. Someone could help us.


-

Bonjour à tous !

Depuis quelque temps, après la migration de ces 2.19 à 2.24, nous ne pouvons
Ouvrir le module SIG. J'ai effacé le cache du navigateur et
Même celle de DHIS 2, qui n'a rien donné. Quelqu'un pourrait nous aider.



<< Nos pensées deviennent nos paroles, nos paroles deviennent nos actes,
nos actes deviennent nos coutumes, nos coutumes deviennent nos valeurs et
nos valeurs deviennent notre destinée *>>*



*  KOUASSI GUY ROLLAND*
*Administrateur Systèmes et Réseaux*
*  Ingénieur Des Systèmes Numériques de Communication *
*Direction de la Prospective, de la Planification, de l’Évaluationet de
l'Information Sanitaire (DPPEIS*

*Téléphone : +(225) 44-744-156*
___
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