Re: [Dhis2-users] Data Entry Screen Fails to Load Data Set

[Morina Matasi]

Thanks Morten. I have done that and I get the following error:

Parse error on line 2637:
... "WNTP3yWBo9b": "(((#{REsnB7QOitO.pp
---^
Expecting 'STRING', 'NUMBER', 'NULL', 'TRUE', 'FALSE', '{', '['


However, The indicator in question (WNTP3yWBo9b) looks fine.



On Wed, Sep 10, 2014 at 8:02 AM, Morten Olav Hansen 
wrote:

> Yes, as Jason is saying, try and completely clear the browser cache (or
> run in private / incognito mode).
>
> If that doesn't work, you can also take the output from
> /dhis-web-dataentry/getMetaData.action and put it into
> jsonlint.com, and see if you get any errors, sometimes there might be
> issues with indicators etc.
>
> --
> Morten
>
> On Wed, Sep 10, 2014 at 12:54 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Try clearing the browser cache completely.
>>
>> Also send any messages from the tomcat logs. If you see nothing, press
>> F12 in your browser if you are using Chrome and look for any Java Script
>> error there.
>>
>> Regards,
>> Jason
>>
>> --
>> Sent from my mobile
>> On Sep 10, 2014 7:49 AM, "Morina Matasi" 
>> wrote:
>>
>>> The Server is Ubuntu 12.04 LTS with PostgresQL 9.2. Any help will be
>>> appreciated. All the other functions including reports are working well.
>>> Its just problem with the Data Entry screen attached in the previous email.
>>>
>>> On Wed, Sep 10, 2014 at 7:20 AM, Morina Matasi <
>>> morena.motsi...@gmail.com> wrote:
>>>
 Dear All,

 I have a DHIS2.14 build 13793 which was working. Suddenly, it can not
 load the data entry screen (Services  -> Data Entry). It gets stuck on
 retrieving data set as it just show the loading icon. At times, retrieving
 the org unit tree (on the left of the same screen) behaves the same but it
 is the loading dataset that is really not loading at all.

 I have tried to run tools under data maintenance to no avail. There are
 no errors in Catalina.out.

 I have even purged by datavalue table on a test server which has 3,5
 Million records but still, nothing changes.

 Any ideas what I can do??



>>>
>>> ___
>>> 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
>>
>>
>
___
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 Entry Screen Fails to Load Data Set

[Morten Olav Hansen]

Can you check and see if you have any extra newlines in the indicator
numerator or denominator ? that can cause issues, especially with older
version of DHIS.

--
Morten

On Wed, Sep 10, 2014 at 2:01 PM, Morina Matasi 
wrote:

> Thanks Morten. I have done that and I get the following error:
>
> Parse error on line 2637:
> ... "WNTP3yWBo9b": "(((#{REsnB7QOitO.pp
> ---^
> Expecting 'STRING', 'NUMBER', 'NULL', 'TRUE', 'FALSE', '{', '['
>
>
> However, The indicator in question (WNTP3yWBo9b) looks fine.
>
>
>
> On Wed, Sep 10, 2014 at 8:02 AM, Morten Olav Hansen 
> wrote:
>
>> Yes, as Jason is saying, try and completely clear the browser cache (or
>> run in private / incognito mode).
>>
>> If that doesn't work, you can also take the output from
>> /dhis-web-dataentry/getMetaData.action and put it into
>> jsonlint.com, and see if you get any errors, sometimes there might be
>> issues with indicators etc.
>>
>> --
>> Morten
>>
>> On Wed, Sep 10, 2014 at 12:54 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Try clearing the browser cache completely.
>>>
>>> Also send any messages from the tomcat logs. If you see nothing, press
>>> F12 in your browser if you are using Chrome and look for any Java Script
>>> error there.
>>>
>>> Regards,
>>> Jason
>>>
>>> --
>>> Sent from my mobile
>>> On Sep 10, 2014 7:49 AM, "Morina Matasi" 
>>> wrote:
>>>
 The Server is Ubuntu 12.04 LTS with PostgresQL 9.2. Any help will be
 appreciated. All the other functions including reports are working well.
 Its just problem with the Data Entry screen attached in the previous email.

 On Wed, Sep 10, 2014 at 7:20 AM, Morina Matasi <
 morena.motsi...@gmail.com> wrote:

> Dear All,
>
> I have a DHIS2.14 build 13793 which was working. Suddenly, it can not
> load the data entry screen (Services  -> Data Entry). It gets stuck on
> retrieving data set as it just show the loading icon. At times, retrieving
> the org unit tree (on the left of the same screen) behaves the same but it
> is the loading dataset that is really not loading at all.
>
> I have tried to run tools under data maintenance to no avail. There
> are no errors in Catalina.out.
>
> I have even purged by datavalue table on a test server which has 3,5
> Million records but still, nothing changes.
>
> Any ideas what I can do??
>
>
>

 ___
 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
>>>
>>>
>>
>
___
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 Entry Screen Fails to Load Data Set

[Morina Matasi]

That did the trick!! Thank YOU!!!

On Wed, Sep 10, 2014 at 9:18 AM, Morten Olav Hansen 
wrote:

>
> On Wed, Sep 10, 2014 at 2:17 PM, Morina Matasi 
> wrote:
>
>> "WNTP3yWBo9b":
>> "(((#{REsnB7QOitO.pp5KtxJWaZA}+#{YHCsjYeBMU7.pp5KtxJWaZA}+#{LCWdeMZ4Zb4.pp5KtxJWaZA}+#{vYbeCKa2zlj.pp5KtxJWaZA}+#{AzLw0PR9E9v.pp5KtxJWaZA}+#{dgGQFkvROzb.pp5KtxJWaZA})*0.65*233)+
>>
>
> Do you have a newline there? try and remove it.. after the +
>
> --
> Morten
>
___
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] "future" period as denominator data

[Johan Ivar Sæbø]

Hi,

we have some population-based indicators, and have population-data for 
2014 in the database. However, when we look at indicators for any month 
in 2014, it appears that the denominator is picked from the last 
finished period, i.e. 2013. When we look at 2014 as total by selecting 
"this year" in pivot table, the indicator is calculated correctly using 
2014 population data.


A point of allowing future data to be entered should be to use this 
year's projected population data in indicators. Is there some setting 
somewhere I have missed to allow this?


An example indicator is measles coverage:
Numerator: measles vaccination given (monthly)
Denominator: population <1 (yearly)
Percentage, annualized

Regards,
Johan

___
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] Enforcing Max/Min Value on Data entry Form

[Morina Matasi]

Can I enforce Max/Min values on a data entry form. Validation is not giving
me much flexibility. I want the data entry form not to save when a value
entered is outside a range (Min-Max). How do I do that?
___
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] Enforcing Max/Min Value on Data entry Form

[Moses Marimo]

I am sure HTML 5 attributes should help. Just go to the source of the data
entry form and add min and max attributes


On Wed, Sep 10, 2014 at 11:25 AM, Morina Matasi 
wrote:

> Can I enforce Max/Min values on a data entry form. Validation is not
> giving me much flexibility. I want the data entry form not to save when a
> value entered is outside a range (Min-Max). How do I do that?
>
>
>
> ___
> 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
>
>


-- 
ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
7 Chelmsford Belgravia, Harare
Tel: +263-8644-102349
Cell: +263-772-268353
Website: *www.ict.co.zw *


Innovative solutions in Web Design and E-Commerce, Software Engineering,
Mobile and Bulk SMS Solutions, Graphic Design and Printing, General ICT
Solutions and Consultancy.
___
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] Enforcing Max/Min Value on Data entry Form

[Morina Matasi]

This doesnt work. Those attributes disappear when I save the form.


On Wed, Sep 10, 2014 at 11:36 AM, Moses Marimo  wrote:

> I am sure HTML 5 attributes should help. Just go to the source of the data
> entry form and add min and max attributes
> 
>
> On Wed, Sep 10, 2014 at 11:25 AM, Morina Matasi  > wrote:
>
>> Can I enforce Max/Min values on a data entry form. Validation is not
>> giving me much flexibility. I want the data entry form not to save when a
>> value entered is outside a range (Min-Max). How do I do that?
>>
>>
>>
>> ___
>> 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
>>
>>
>
>
> --
> ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
> 7 Chelmsford Belgravia, Harare
> Tel: +263-8644-102349
> Cell: +263-772-268353
> Website: *www.ict.co.zw *
>
>
> Innovative solutions in Web Design and E-Commerce, Software Engineering,
> Mobile and Bulk SMS Solutions, Graphic Design and Printing, General ICT
> Solutions and Consultancy.
>
___
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] Enforcing Max/Min Value on Data entry Form

[Alex Tumwesigye]

Dear Morina,

The HTML 5 attributes will help if the form is a custom form, that way you
can persist the code.

Thanks.

On Wed, Sep 10, 2014 at 12:48 PM, Morina Matasi 
wrote:

> 
>
> This doesnt work. Those attributes disappear when I save the form.
>
>
> On Wed, Sep 10, 2014 at 11:36 AM, Moses Marimo  wrote:
>
>> I am sure HTML 5 attributes should help. Just go to the source of the
>> data entry form and add min and max attributes
>> 
>>
>> On Wed, Sep 10, 2014 at 11:25 AM, Morina Matasi <
>> morena.motsi...@gmail.com> wrote:
>>
>>> Can I enforce Max/Min values on a data entry form. Validation is not
>>> giving me much flexibility. I want the data entry form not to save when a
>>> value entered is outside a range (Min-Max). How do I do that?
>>>
>>>
>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
>> 7 Chelmsford Belgravia, Harare
>> Tel: +263-8644-102349
>> Cell: +263-772-268353
>> Website: *www.ict.co.zw *
>>
>>
>> Innovative solutions in Web Design and E-Commerce, Software Engineering,
>> Mobile and Bulk SMS Solutions, Graphic Design and Printing, General ICT
>> Solutions and Consultancy.
>>
>
>
> ___
> 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

Teaching Assistant,
Department of Electrical and Computer Engineering
College of Engineering, Design, Art and Technology, Makerere University

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

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

+256 774149 775, + 256 759 800161

"I don't want to be anything other than what I have been - one tree hill "
___
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] Enforcing Max/Min Value on Data entry Form

[Morina Matasi]

Thanks. Actually it was not overriding, but just re-arranging the
attributes. My apologies. I am actually using custom form. BUT, with the
attributes there, it does not work stil. It doesn't obey the range.

On Wed, Sep 10, 2014 at 11:51 AM, Alex Tumwesigye 
wrote:

> Dear Morina,
>
> The HTML 5 attributes will help if the form is a custom form, that way you
> can persist the code.
>
> Thanks.
>
> On Wed, Sep 10, 2014 at 12:48 PM, Morina Matasi  > wrote:
>
>> 
>>
>> This doesnt work. Those attributes disappear when I save the form.
>>
>>
>> On Wed, Sep 10, 2014 at 11:36 AM, Moses Marimo  wrote:
>>
>>> I am sure HTML 5 attributes should help. Just go to the source of the
>>> data entry form and add min and max attributes
>>> 
>>>
>>> On Wed, Sep 10, 2014 at 11:25 AM, Morina Matasi <
>>> morena.motsi...@gmail.com> wrote:
>>>
 Can I enforce Max/Min values on a data entry form. Validation is not
 giving me much flexibility. I want the data entry form not to save when a
 value entered is outside a range (Min-Max). How do I do that?



 ___
 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


>>>
>>>
>>> --
>>> ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
>>> 7 Chelmsford Belgravia, Harare
>>> Tel: +263-8644-102349
>>> Cell: +263-772-268353
>>> Website: *www.ict.co.zw *
>>>
>>>
>>> Innovative solutions in Web Design and E-Commerce, Software Engineering,
>>> Mobile and Bulk SMS Solutions, Graphic Design and Printing, General ICT
>>> Solutions and Consultancy.
>>>
>>
>>
>> ___
>> 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
>
> Teaching Assistant,
> Department of Electrical and Computer Engineering
> College of Engineering, Design, Art and Technology, Makerere University
>
> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>
> IT Specialist (Servers, Networks and Security, Health Information Systems
> - DHIS2 ) & Solar Consultant
>
> +256 774149 775, + 256 759 800161
>
> "I don't want to be anything other than what I have been - one tree hill "
>
___
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] Enforcing Max/Min Value on Data entry Form

[Alex Tumwesigye]

Morina,

It should work if the browser is supported.
May be you could look at JQuery as an option since DHIS2 preloads with
JQuery already added for you.
See example http://jqueryvalidation.org/max-method/

Just write you JQuery script below and it should work.

AT

On Wed, Sep 10, 2014 at 1:09 PM, Morina Matasi 
wrote:

> Thanks. Actually it was not overriding, but just re-arranging the
> attributes. My apologies. I am actually using custom form. BUT, with the
> attributes there, it does not work stil. It doesn't obey the range.
>
> On Wed, Sep 10, 2014 at 11:51 AM, Alex Tumwesigye 
> wrote:
>
>> Dear Morina,
>>
>> The HTML 5 attributes will help if the form is a custom form, that way
>> you can persist the code.
>>
>> Thanks.
>>
>> On Wed, Sep 10, 2014 at 12:48 PM, Morina Matasi <
>> morena.motsi...@gmail.com> wrote:
>>
>>> 
>>>
>>> This doesnt work. Those attributes disappear when I save the form.
>>>
>>>
>>> On Wed, Sep 10, 2014 at 11:36 AM, Moses Marimo  wrote:
>>>
 I am sure HTML 5 attributes should help. Just go to the source of the
 data entry form and add min and max attributes
 

 On Wed, Sep 10, 2014 at 11:25 AM, Morina Matasi <
 morena.motsi...@gmail.com> wrote:

> Can I enforce Max/Min values on a data entry form. Validation is not
> giving me much flexibility. I want the data entry form not to save when a
> value entered is outside a range (Min-Max). How do I do that?
>
>
>
> ___
> 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
>
>


 --
 ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
 7 Chelmsford Belgravia, Harare
 Tel: +263-8644-102349
 Cell: +263-772-268353
 Website: *www.ict.co.zw *


 Innovative solutions in Web Design and E-Commerce, Software
 Engineering, Mobile and Bulk SMS Solutions, Graphic Design and Printing,
 General ICT Solutions and Consultancy.

>>>
>>>
>>> ___
>>> 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
>>
>> Teaching Assistant,
>> Department of Electrical and Computer Engineering
>> College of Engineering, Design, Art and Technology, Makerere University
>>
>> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>>
>> IT Specialist (Servers, Networks and Security, Health Information Systems
>> - DHIS2 ) & Solar Consultant
>>
>> +256 774149 775, + 256 759 800161
>>
>> "I don't want to be anything other than what I have been - one tree hill "
>>
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2,
Ministry of Health/AFENET
Kampala
Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

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

+256 774149 775, + 256 759 800161

"I don't want to be anything other than what I have been - one tree hill "
___
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] Enforcing Max/Min Value on Data entry Form

[Morina Matasi]

I have just tried it. Since there is no Form Object in the customs forms, I
used jQuery's .closest('form') function but still, it does not work. The
data entry form then goes into a loop trying to open.

I have also noted that if you double click on the text box of a form at
run-time, it give a window were you can set min-max values, i need
something like that at design time.


On Wed, Sep 10, 2014 at 12:22 PM, Alex Tumwesigye 
wrote:

> Morina,
>
> It should work if the browser is supported.
> May be you could look at JQuery as an option since DHIS2 preloads with
> JQuery already added for you.
> See example http://jqueryvalidation.org/max-method/
>
> Just write you JQuery script below and it should work.
>
> AT
>
> On Wed, Sep 10, 2014 at 1:09 PM, Morina Matasi 
> wrote:
>
>> Thanks. Actually it was not overriding, but just re-arranging the
>> attributes. My apologies. I am actually using custom form. BUT, with the
>> attributes there, it does not work stil. It doesn't obey the range.
>>
>> On Wed, Sep 10, 2014 at 11:51 AM, Alex Tumwesigye 
>> wrote:
>>
>>> Dear Morina,
>>>
>>> The HTML 5 attributes will help if the form is a custom form, that way
>>> you can persist the code.
>>>
>>> Thanks.
>>>
>>> On Wed, Sep 10, 2014 at 12:48 PM, Morina Matasi <
>>> morena.motsi...@gmail.com> wrote:
>>>
 

 This doesnt work. Those attributes disappear when I save the form.


 On Wed, Sep 10, 2014 at 11:36 AM, Moses Marimo 
 wrote:

> I am sure HTML 5 attributes should help. Just go to the source of the
> data entry form and add min and max attributes
> 
>
> On Wed, Sep 10, 2014 at 11:25 AM, Morina Matasi <
> morena.motsi...@gmail.com> wrote:
>
>> Can I enforce Max/Min values on a data entry form. Validation is not
>> giving me much flexibility. I want the data entry form not to save when a
>> value entered is outside a range (Min-Max). How do I do that?
>>
>>
>>
>> ___
>> 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
>>
>>
>
>
> --
> ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
> 7 Chelmsford Belgravia, Harare
> Tel: +263-8644-102349
> Cell: +263-772-268353
> Website: *www.ict.co.zw *
>
>
> Innovative solutions in Web Design and E-Commerce, Software
> Engineering, Mobile and Bulk SMS Solutions, Graphic Design and Printing,
> General ICT Solutions and Consultancy.
>


 ___
 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
>>>
>>> Teaching Assistant,
>>> Department of Electrical and Computer Engineering
>>> College of Engineering, Design, Art and Technology, Makerere University
>>>
>>> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>>>
>>> IT Specialist (Servers, Networks and Security, Health Information
>>> Systems - DHIS2 ) & Solar Consultant
>>>
>>> +256 774149 775, + 256 759 800161
>>>
>>> "I don't want to be anything other than what I have been - one tree hill
>>> "
>>>
>>
>>
>
>
> --
> Alex Tumwesigye
>
> Technical Advisor - DHIS2,
> Ministry of Health/AFENET
> Kampala
> Uganda
>
> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>
> IT Specialist (Servers, Networks and Security, Health Information Systems
> - DHIS2 ) & Solar Consultant
>
> +256 774149 775, + 256 759 800161
>
> "I don't want to be anything other than what I have been - one tree hill "
>
___
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] Enforcing Max/Min Value on Data entry Form

[Alex Tumwesigye]

Dear Morina,

Can you share your code?
One thing I know when you are applying JQuery to a given field/input in
DHIS2, you may need to do something like this:
$(.entryfield).closest(blah blah)  This will apply the rule to all
inputs

or
$(#qTuxHtIBhkU-mt3cAOIDf32-val).closest(blah blah) This will apply
the rule to specific input

For attributes in programs
You need $(#attr2056) where the number refers to the ID of the attribute

Look at this to give you more light (This is an extract fron DHIS2 V 2.13),
you can inspect elements on your version to see how they are named:



Good luck.

On Wed, Sep 10, 2014 at 2:05 PM, Morina Matasi 
wrote:

> I have just tried it. Since there is no Form Object in the customs forms,
> I used jQuery's .closest('form') function but still, it does not work. The
> data entry form then goes into a loop trying to open.
>
> I have also noted that if you double click on the text box of a form at
> run-time, it give a window were you can set min-max values, i need
> something like that at design time.
>
>
> On Wed, Sep 10, 2014 at 12:22 PM, Alex Tumwesigye 
> wrote:
>
>> Morina,
>>
>> It should work if the browser is supported.
>> May be you could look at JQuery as an option since DHIS2 preloads with
>> JQuery already added for you.
>> See example http://jqueryvalidation.org/max-method/
>>
>> Just write you JQuery script below and it should work.
>>
>> AT
>>
>> On Wed, Sep 10, 2014 at 1:09 PM, Morina Matasi > > wrote:
>>
>>> Thanks. Actually it was not overriding, but just re-arranging the
>>> attributes. My apologies. I am actually using custom form. BUT, with the
>>> attributes there, it does not work stil. It doesn't obey the range.
>>>
>>> On Wed, Sep 10, 2014 at 11:51 AM, Alex Tumwesigye >> > wrote:
>>>
 Dear Morina,

 The HTML 5 attributes will help if the form is a custom form, that way
 you can persist the code.

 Thanks.

 On Wed, Sep 10, 2014 at 12:48 PM, Morina Matasi <
 morena.motsi...@gmail.com> wrote:

> 
>
> This doesnt work. Those attributes disappear when I save the form.
>
>
> On Wed, Sep 10, 2014 at 11:36 AM, Moses Marimo 
> wrote:
>
>> I am sure HTML 5 attributes should help. Just go to the source of the
>> data entry form and add min and max attributes
>> 
>>
>> On Wed, Sep 10, 2014 at 11:25 AM, Morina Matasi <
>> morena.motsi...@gmail.com> wrote:
>>
>>> Can I enforce Max/Min values on a data entry form. Validation is not
>>> giving me much flexibility. I want the data entry form not to save when 
>>> a
>>> value entered is outside a range (Min-Max). How do I do that?
>>>
>>>
>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
>> 7 Chelmsford Belgravia, Harare
>> Tel: +263-8644-102349
>> Cell: +263-772-268353
>> Website: *www.ict.co.zw *
>>
>>
>> Innovative solutions in Web Design and E-Commerce, Software
>> Engineering, Mobile and Bulk SMS Solutions, Graphic Design and Printing,
>> General ICT Solutions and Consultancy.
>>
>
>
> ___
> 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

 Teaching Assistant,
 Department of Electrical and Computer Engineering
 College of Engineering, Design, Art and Technology, Makerere University

 IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

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

 +256 774149 775, + 256 759 800161

 "I don't want to be anything other than what I have been - one tree
 hill "

>>>
>>>
>>
>>
>> --
>> Alex Tumwesigye
>>
>> Technical Advisor - DHIS2,
>> Ministry of Health/AFENET
>> Kampala
>> Uganda
>>
>> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>>
>> IT Specialist (Servers, Networks and Security, Health Information Systems
>> - DHIS2 ) & Solar Consultant
>>
>> +256 774149 775, + 256 759 800161
>>
>> "I don't want to be anything other than what I have been - one tree hill "
>>
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2,
Ministry of Health/AFENET
Kampala
Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

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

+256 774149 775, + 256

Re: [Dhis2-users] Enforcing Max/Min Value on Data entry Form

[Morina Matasi]

$("#dgGQFkvROzb-pp5KtxJWaZA-val").closest("form").validate({
  rules: {
dgGQFkvROzb-pp5KtxJWaZA-val: {
  max: 5
}
  }
});



On Wed, Sep 10, 2014 at 1:22 PM, Alex Tumwesigye 
wrote:

> Dear Morina,
>
> Can you share your code?
> One thing I know when you are applying JQuery to a given field/input in
> DHIS2, you may need to do something like this:
> $(.entryfield).closest(blah blah)  This will apply the rule to all
> inputs
>
> or
> $(#qTuxHtIBhkU-mt3cAOIDf32-val).closest(blah blah) This will
> apply the rule to specific input
>
> For attributes in programs
> You need $(#attr2056) where the number refers to the ID of the
> attribute
>
> Look at this to give you more light (This is an extract fron DHIS2 V
> 2.13), you can inspect elements on your version to see how they are named:
>
> 
>
> Good luck.
>
> On Wed, Sep 10, 2014 at 2:05 PM, Morina Matasi 
> wrote:
>
>> I have just tried it. Since there is no Form Object in the customs forms,
>> I used jQuery's .closest('form') function but still, it does not work. The
>> data entry form then goes into a loop trying to open.
>>
>> I have also noted that if you double click on the text box of a form at
>> run-time, it give a window were you can set min-max values, i need
>> something like that at design time.
>>
>>
>> On Wed, Sep 10, 2014 at 12:22 PM, Alex Tumwesigye 
>> wrote:
>>
>>> Morina,
>>>
>>> It should work if the browser is supported.
>>> May be you could look at JQuery as an option since DHIS2 preloads with
>>> JQuery already added for you.
>>> See example http://jqueryvalidation.org/max-method/
>>>
>>> Just write you JQuery script below and it should work.
>>>
>>> AT
>>>
>>> On Wed, Sep 10, 2014 at 1:09 PM, Morina Matasi <
>>> morena.motsi...@gmail.com> wrote:
>>>
 Thanks. Actually it was not overriding, but just re-arranging the
 attributes. My apologies. I am actually using custom form. BUT, with the
 attributes there, it does not work stil. It doesn't obey the range.

 On Wed, Sep 10, 2014 at 11:51 AM, Alex Tumwesigye <
 atumwesi...@gmail.com> wrote:

> Dear Morina,
>
> The HTML 5 attributes will help if the form is a custom form, that way
> you can persist the code.
>
> Thanks.
>
> On Wed, Sep 10, 2014 at 12:48 PM, Morina Matasi <
> morena.motsi...@gmail.com> wrote:
>
>> 
>>
>> This doesnt work. Those attributes disappear when I save the form.
>>
>>
>> On Wed, Sep 10, 2014 at 11:36 AM, Moses Marimo 
>> wrote:
>>
>>> I am sure HTML 5 attributes should help. Just go to the source of
>>> the data entry form and add min and max attributes
>>> 
>>>
>>> On Wed, Sep 10, 2014 at 11:25 AM, Morina Matasi <
>>> morena.motsi...@gmail.com> wrote:
>>>
 Can I enforce Max/Min values on a data entry form. Validation is
 not giving me much flexibility. I want the data entry form not to save 
 when
 a value entered is outside a range (Min-Max). How do I do that?



 ___
 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


>>>
>>>
>>> --
>>> ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
>>> 7 Chelmsford Belgravia, Harare
>>> Tel: +263-8644-102349
>>> Cell: +263-772-268353
>>> Website: *www.ict.co.zw *
>>>
>>>
>>> Innovative solutions in Web Design and E-Commerce, Software
>>> Engineering, Mobile and Bulk SMS Solutions, Graphic Design and Printing,
>>> General ICT Solutions and Consultancy.
>>>
>>
>>
>> ___
>> 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
>
> Teaching Assistant,
> Department of Electrical and Computer Engineering
> College of Engineering, Design, Art and Technology, Makerere University
>
> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>
> IT Specialist (Servers, Networks and Security, Health Information
> Systems - DHIS2 ) & Solar Consultant
>
> +256 774149 775, + 256 759 800161
>
> "I don't want to be anything other than what I have been - one tree
> hill "
>


>>>
>>>
>>> --
>>> Alex Tumwesigye
>>>
>>> Technical Advisor - DHIS2,
>>> Ministry of Health/AFENET
>>> Kampala
>>> Uganda
>>>
>>> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>>>
>>> IT Specialist (Servers, Networks and Security, Health Information
>>> Systems - DHIS2 ) & So

Re: [Dhis2-users] Enforcing Max/Min Value on Data entry Form

[Alex Tumwesigye]

Morina,

For your case, this should be the valid script. Do not use .closest("form")
because there is no form name "form"

$("#entryfield").validate({
  rules: {
entryfield: {
  max: 5
}
  }
});


The above script will set all maximum values to the whole form as 5,

For specific input, using the validation plugin may require more work but
this should work


$("#dgGQFkvROzb-pp5KtxJWaZA-val").attr({
   "max" : 5
});


On Wed, Sep 10, 2014 at 2:33 PM, Morina Matasi 
wrote:

> 
> $("#dgGQFkvROzb-pp5KtxJWaZA-val").closest("form").validate({
>   rules: {
> dgGQFkvROzb-pp5KtxJWaZA-val: {
>   max: 5
> }
>   }
> });
> 
>
>
> On Wed, Sep 10, 2014 at 1:22 PM, Alex Tumwesigye 
> wrote:
>
>> Dear Morina,
>>
>> Can you share your code?
>> One thing I know when you are applying JQuery to a given field/input in
>> DHIS2, you may need to do something like this:
>> $(.entryfield).closest(blah blah)  This will apply the rule to
>> all inputs
>>
>> or
>> $(#qTuxHtIBhkU-mt3cAOIDf32-val).closest(blah blah) This will
>> apply the rule to specific input
>>
>> For attributes in programs
>> You need $(#attr2056) where the number refers to the ID of the
>> attribute
>>
>> Look at this to give you more light (This is an extract fron DHIS2 V
>> 2.13), you can inspect elements on your version to see how they are named:
>>
>> 
>>
>> Good luck.
>>
>> On Wed, Sep 10, 2014 at 2:05 PM, Morina Matasi > > wrote:
>>
>>> I have just tried it. Since there is no Form Object in the customs
>>> forms, I used jQuery's .closest('form') function but still, it does not
>>> work. The data entry form then goes into a loop trying to open.
>>>
>>> I have also noted that if you double click on the text box of a form at
>>> run-time, it give a window were you can set min-max values, i need
>>> something like that at design time.
>>>
>>>
>>> On Wed, Sep 10, 2014 at 12:22 PM, Alex Tumwesigye >> > wrote:
>>>
 Morina,

 It should work if the browser is supported.
 May be you could look at JQuery as an option since DHIS2 preloads with
 JQuery already added for you.
 See example http://jqueryvalidation.org/max-method/

 Just write you JQuery script below and it should work.

 AT

 On Wed, Sep 10, 2014 at 1:09 PM, Morina Matasi <
 morena.motsi...@gmail.com> wrote:

> Thanks. Actually it was not overriding, but just re-arranging the
> attributes. My apologies. I am actually using custom form. BUT, with the
> attributes there, it does not work stil. It doesn't obey the range.
>
> On Wed, Sep 10, 2014 at 11:51 AM, Alex Tumwesigye <
> atumwesi...@gmail.com> wrote:
>
>> Dear Morina,
>>
>> The HTML 5 attributes will help if the form is a custom form, that
>> way you can persist the code.
>>
>> Thanks.
>>
>> On Wed, Sep 10, 2014 at 12:48 PM, Morina Matasi <
>> morena.motsi...@gmail.com> wrote:
>>
>>> 
>>>
>>> This doesnt work. Those attributes disappear when I save the form.
>>>
>>>
>>> On Wed, Sep 10, 2014 at 11:36 AM, Moses Marimo 
>>> wrote:
>>>
 I am sure HTML 5 attributes should help. Just go to the source of
 the data entry form and add min and max attributes
 

 On Wed, Sep 10, 2014 at 11:25 AM, Morina Matasi <
 morena.motsi...@gmail.com> wrote:

> Can I enforce Max/Min values on a data entry form. Validation is
> not giving me much flexibility. I want the data entry form not to 
> save when
> a value entered is outside a range (Min-Max). How do I do that?
>
>
>
> ___
> 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
>
>


 --
 ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
 7 Chelmsford Belgravia, Harare
 Tel: +263-8644-102349
 Cell: +263-772-268353
 Website: *www.ict.co.zw *


 Innovative solutions in Web Design and E-Commerce, Software
 Engineering, Mobile and Bulk SMS Solutions, Graphic Design and 
 Printing,
 General ICT Solutions and Consultancy.

>>>
>>>
>>> ___
>>> 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
>>
>> Teaching Assistant,
>> Department of Electrical and Computer Engineering
>> College of Engineering, Design, Art and Technology,

Re: [Dhis2-users] [Dhis2-devs] Limit characters in Comment

[Olav Poppe]

Hi,
I’m trying to apply the below patch to allow comments longer than 360 
characters. Changing the .js and .vm file works fine and the text field allows 
long comments, BUT the system still refuses to store the data values with long 
comments - 409 conflict is returned from the server. The comment column has 
type «longtext». Any ideas of what could be the problem?

Searching through the source code, I found two additional files where the lengt 
of the comments are mentioned:
- validationUtils.java, function commentIsValid() checks for comment length
- DataValue.hbm.xml has ""

Do these also need to be changed? If so, I guess a custom .war file will be 
needed (as opposed to just changing the .vm and .js files)?

Olav



9. apr. 2014 kl. 11:48 skrev channara rin :

> Oh!, i am using MySQL. where i can find this sql expression?
> 
> 
> On Wed, Apr 9, 2014 at 4:46 PM, Jason Pickering  
> wrote:
> Could be. On postgres, the datavalue table (at least on my system) looks like 
> this
> 
> CREATE TABLE datavalue
> (
>   dataelementid integer NOT NULL,
>   periodid integer NOT NULL,
>   sourceid integer NOT NULL,
>   categoryoptioncomboid integer NOT NULL,
>   value character varying(255),
>   storedby character varying(100),
>   lastupdated timestamp without time zone,
>   comment character varying(360),
>   followup boolean,
> 
> 
> In that case, not sure then. :-/
> 
> Regards,
> Jason
> 
> 
> 
> On Wed, Apr 9, 2014 at 11:42 AM, channara rin  wrote:
> The default, comment field in datavalue table is longtext type.
> 
> Best Regards,
> CHANNARA
> 
> 
> On Wed, Apr 9, 2014 at 4:40 PM, Jason Pickering  
> wrote:
> Did you change the database field type from varchar to text?
> 
> Regards,
> Jason
> 
> 
> 
> On Wed, Apr 9, 2014 at 11:31 AM, channara rin  wrote:
> Dear Lars,
> I tried to change in history.js
> but when i enter longer than 360 in comment, and press "Save Comment". It 
> always jump:
> CONSOLE
> -
> ReferenceError: i18n_saving_comment_failed_error_code is not defined  
> history.js:64
> -
> 
> history.js
> --
> function handleError( xhr, textStatus, errorThrown )
> {
> markComment( COLOR_RED );
> window.alert( i18n_saving_comment_failed_error_code + '\n\n' + 
> xhr.responseText );
> }
> 
> 
> On Wed, Apr 9, 2014 at 3:29 PM, Lars Helge Øverland  
> wrote:
> The cell border will be green for fields which have comments (next time you 
> open that form).
> 
> 
> 
> 
> On Wed, Apr 9, 2014 at 10:27 AM, channara rin  wrote:
> Great, Thank you.
> SO i need to modify the 360 in history.js file?
> 
> AND another problem is. when has comment, can show highlight data value in 
> dataset that has text in that comment? SO it is easy for us(M&E staff) to 
> view if that data value has comment..
> 
> Thank you
> CHANNARA
> 
> 
> 
> 
> 
> On Wed, Apr 9, 2014 at 3:02 PM, Lars Helge Øverland  
> wrote:
> Hi Channara,
> 
> the max is actually 255 characters, backed by a "varchar" column in the 
> database. I'm sorry but we don't plan to change it to a "text" type column 
> anytime soon - reason is just that most comments are pretty short and "text" 
> requires more storage space on disk.
> 
> Now that said you are of course free to change the column type to text 
> directly in your database, and then apply the patch copied below this email 
> to remove the validation.
> 
> regards,
> 
> Lars
> 
> -
> 
> 
> === modified file 
> 'dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/history.js'
> --- 
> dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/history.js
>2014-02-27 04:15:35 +
> +++ 
> dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/history.js
>2014-04-09 08:01:57 +
> @@ -5,14 +5,6 @@
>   
>  var commentValue = $( '#commentTextArea' ).val();
>  
> -if ( commentValue.length > 360 )
> -{
> -markComment( COLOR_YELLOW );
> -window.alert(i18n_value_too_long + " for comment field");
> -
> -return;
> -}
> -
>  var commentSaver = new CommentSaver( currentDataElementId, 
> currentOptionComboId, commentValue );
>  
>  commentSaver.save();
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> On Wed, Apr 9, 2014 at 6:55 AM, channara rin  wrote:
> Dear All,
> I found that, in the Comment in data value in dataset is limit character 
> around 360characters. 
> Can we extend to unlimited characters for comments?
> 
> 
> Thank you
> CHANNARA
> 
> ___
> 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/

Re: [Dhis2-users] [Dhis2-devs] Limit characters in Comment

[Lars Helge Øverland]

Hi Olav,

the datavalue.value column is of type varchar and not text. This might be
unfortunate but there is an overhead in using text vs varchar. The long
text vs text is more a UI setting to indicate whether to display an input
field or text area.

I am not sure how huge the difference is between text and varchar these
days so it could be looked into whether changing is feasible. I have seen
the requirement for storing "narratives" as data a few places.

regards,

Lars


On Wed, Sep 10, 2014 at 8:52 AM, Olav Poppe  wrote:

> Hi,
> I’m trying to apply the below patch to allow comments longer than 360
> characters. Changing the .js and .vm file works fine and the text field
> allows long comments, BUT the system still refuses to store the data values
> with long comments - 409 conflict is returned from the server. The comment
> column has type «longtext». Any ideas of what could be the problem?
>
> Searching through the source code, I found two additional files where the
> lengt of the comments are mentioned:
> - validationUtils.java, function commentIsValid() checks for comment length
> - DataValue.hbm.xml has ""
>
> Do these also need to be changed? If so, I guess a custom .war file will
> be needed (as opposed to just changing the .vm and .js files)?
>
> Olav
>
>
>
> 9. apr. 2014 kl. 11:48 skrev channara rin :
>
> Oh!, i am using MySQL. where i can find this sql expression?
>
>
> On Wed, Apr 9, 2014 at 4:46 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Could be. On postgres, the datavalue table (at least on my system) looks
>> like this
>>
>> CREATE TABLE datavalue
>> (
>>   dataelementid integer NOT NULL,
>>   periodid integer NOT NULL,
>>   sourceid integer NOT NULL,
>>   categoryoptioncomboid integer NOT NULL,
>>   value character varying(255),
>>   storedby character varying(100),
>>   lastupdated timestamp without time zone,
>>   comment character varying(360),
>>   followup boolean,
>> 
>>
>> In that case, not sure then. :-/
>>
>> Regards,
>> Jason
>>
>>
>>
>> On Wed, Apr 9, 2014 at 11:42 AM, channara rin 
>> wrote:
>>
>>> The default, comment field in datavalue table is longtext type.
>>>
>>> Best Regards,
>>> CHANNARA
>>>
>>>
>>> On Wed, Apr 9, 2014 at 4:40 PM, Jason Pickering <
>>> jason.p.picker...@gmail.com> wrote:
>>>
 Did you change the database field type from varchar to text?

 Regards,
 Jason



 On Wed, Apr 9, 2014 at 11:31 AM, channara rin 
 wrote:

> Dear Lars,
> I tried to change in history.js
> but when i enter longer than 360 in comment, and press "Save Comment".
> It always jump:
> CONSOLE
> -
> ReferenceError: i18n_saving_comment_failed_error_code is not defined
>history.js:64
> -
>
> history.js
> --
> function handleError( xhr, textStatus, errorThrown )
> {
> markComment( COLOR_RED );
> window.alert( i18n_saving_comment_failed_error_code + '\n\n' +
> xhr.responseText );
> }
>
>
> On Wed, Apr 9, 2014 at 3:29 PM, Lars Helge Øverland <
> larshe...@gmail.com> wrote:
>
>> The cell border will be green for fields which have comments (next
>> time you open that form).
>>
>>
>>
>>
>> On Wed, Apr 9, 2014 at 10:27 AM, channara rin > > wrote:
>>
>>> Great, Thank you.
>>> SO i need to modify the 360 in history.js file?
>>>
>>> AND another problem is. when has comment, can show highlight data
>>> value in dataset that has text in that comment? SO it is easy for us(M&E
>>> staff) to view if that data value has comment..
>>>
>>> Thank you
>>> CHANNARA
>>>
>>>
>>>
>>>
>>>
>>> On Wed, Apr 9, 2014 at 3:02 PM, Lars Helge Øverland <
>>> larshe...@gmail.com> wrote:
>>>
 Hi Channara,

 the max is actually 255 characters, backed by a "varchar" column in
 the database. I'm sorry but we don't plan to change it to a "text" type
 column anytime soon - reason is just that most comments are pretty 
 short
 and "text" requires more storage space on disk.

 Now that said you are of course free to change the column type to
 text directly in your database, and then apply the patch copied below 
 this
 email to remove the validation.

 regards,

 Lars

 -


 === modified file
 'dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/history.js'
 ---
 dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/history.js
  2014-02-27
 04:15:35 +
 +++
 dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/hi

Re: [Dhis2-users] Data Entry Screen Fails to Load Data Set

[Lars Helge Øverland]

This problem with linebreaks has been fixed in the latest 2.16 version.

regards,

Lars



On Wed, Sep 10, 2014 at 3:30 AM, Morina Matasi 
wrote:

> That did the trick!! Thank YOU!!!
>
> On Wed, Sep 10, 2014 at 9:18 AM, Morten Olav Hansen 
> wrote:
>
>>
>> On Wed, Sep 10, 2014 at 2:17 PM, Morina Matasi > > wrote:
>>
>>> "WNTP3yWBo9b":
>>> "(((#{REsnB7QOitO.pp5KtxJWaZA}+#{YHCsjYeBMU7.pp5KtxJWaZA}+#{LCWdeMZ4Zb4.pp5KtxJWaZA}+#{vYbeCKa2zlj.pp5KtxJWaZA}+#{AzLw0PR9E9v.pp5KtxJWaZA}+#{dgGQFkvROzb.pp5KtxJWaZA})*0.65*233)+
>>>
>>
>> Do you have a newline there? try and remove it.. after the +
>>
>> --
>> Morten
>>
>
>
> ___
> 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] DHIS2 - Indicator calculation over dimensions

[Robin Martens]

Dear all,

I've been testing the indicator calculation algorithm and noticed something 
particular of which I'm not sure if it's a bug or a deliberate development 
choice.

Indicators are not explicitly defined per category such as data elements but 
the reporting tools allow a disaggregated indicator calculation, which is 
definitely very useful. In a specific example, I want to know how many people 
were vaccinated this year and I have 3 kinds of vaccinations: A, B, and C. I 
have two data elements: the total population and the national vaccination 
levels (in %), with a custom category "vaccination type" which can be A, B, or 
C.

My indicator would be "total population" x "national vaccination level 
(total)". That works fine when put in a pivot table.

However, when trying to disaggregate the indicator calculation by adding my 
custom category to the pivot table, I don't have any values anymore. It seems 
the reason is that the "total population" data element does not have the 
"vaccination type" category (which seems logical) and therefore isn't found by 
the calculation algorithm. As a result, my table is empty. It seems useful that 
the algorithm would take the aggregated value (for population) available in 
such cases.

Another example is over the period dimension: my population is a yearly value, 
so when calculating an indicator on a monthly basis, instead of taking the 
available yearly value, he takes zero.

So my question: is this a deliberate choice in the development, a bug, or an 
idea for a future system improvement?

Kind regards,

Robin


___
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] DHIS2 - Indicator calculation over dimensions

[Jason Pickering]

Hi Robin,
It has been a discussed, and certainly not a bug. See a related thread here
(https://lists.launchpad.net/dhis2-devs/msg27571.html) for a similar
discussion on validation rules. It is essentially the same as indicators.
What you will have to do is to create seperate indicator for each and every
combination which you need. It can be painful, but the only way really
which I know at the moment.

Feel free to file a blueprint here. https://blueprints.launchpad.net/dhis2

Regards,
Jason


On Wed, Sep 10, 2014 at 5:37 PM, Robin Martens  wrote:

>   Dear all,
>
>
>
> I've been testing the indicator calculation algorithm and noticed
> something particular of which I'm not sure if it's a bug or a deliberate
> development choice.
>
>
>
> Indicators are not explicitly defined per category such as data elements
> but the reporting tools allow a disaggregated indicator calculation, which
> is definitely very useful. In a specific example, I want to know how many
> people were vaccinated this year and I have 3 kinds of vaccinations: A, B,
> and C. I have two data elements: the total population and the national
> vaccination levels (in %), with a custom category "vaccination type" which
> can be A, B, or C.
>
>
>
> My indicator would be "total population" x "national vaccination level
> (total)". That works fine when put in a pivot table.
>
>
>
> However, when trying to disaggregate the indicator calculation by adding
> my custom category to the pivot table, I don't have any values anymore. It
> seems the reason is that the "total population" data element does not have
> the "vaccination type" category (which seems logical) and therefore isn't
> found by the calculation algorithm. As a result, my table is empty. It
> seems useful that the algorithm would take the aggregated value (for
> population) available in such cases.
>
>
>
> Another example is over the period dimension: my population is a yearly
> value, so when calculating an indicator on a monthly basis, instead of
> taking the available yearly value, he takes zero.
>
>
>
> So my question: is this a deliberate choice in the development, a bug, or
> an idea for a future system improvement?
>
>
>
> Kind regards,
>
>
>
> Robin
>
>
>
>
>
> ___
> 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
___
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] Limit characters in Comment

[Olav Poppe]

Hi, 
in MySQL and 2.15 the type seems to be longtext (see below).

In any case, the patch suggested below is to 1) manually change the column type 
2) change the history.vm and history.js. Is that supposed to enough, or are 
further changes required?

Olav



++--+--+-+-+---+
| Field  | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| dataelementid  | int(11)  | NO   | PRI | NULL|   |
| periodid   | int(11)  | NO   | PRI | NULL|   |
| sourceid   | int(11)  | NO   | PRI | NULL|   |
| categoryoptioncomboid  | int(11)  | NO   | PRI | NULL|   |
| attributeoptioncomboid | int(11)  | NO   | PRI | NULL|   |
| value  | varchar(255) | YES  | | NULL|   |
| storedby   | varchar(100) | YES  | | NULL|   |
| lastupdated| datetime | YES  | | NULL|   |
| comment| longtext | YES  | | NULL|   |
| followup   | tinyint(1)   | YES  | | NULL|   |
++--+--+-+-+---+




10. sep. 2014 kl. 15:19 skrev Lars Helge Øverland :

> Hi Olav,
> 
> the datavalue.value column is of type varchar and not text. This might be 
> unfortunate but there is an overhead in using text vs varchar. The long text 
> vs text is more a UI setting to indicate whether to display an input field or 
> text area. 
> 
> I am not sure how huge the difference is between text and varchar these days 
> so it could be looked into whether changing is feasible. I have seen the 
> requirement for storing "narratives" as data a few places.
> 
> regards,
> 
> Lars
> 
> 
> On Wed, Sep 10, 2014 at 8:52 AM, Olav Poppe  wrote:
> Hi,
> I’m trying to apply the below patch to allow comments longer than 360 
> characters. Changing the .js and .vm file works fine and the text field 
> allows long comments, BUT the system still refuses to store the data values 
> with long comments - 409 conflict is returned from the server. The comment 
> column has type «longtext». Any ideas of what could be the problem?
> 
> Searching through the source code, I found two additional files where the 
> lengt of the comments are mentioned:
> - validationUtils.java, function commentIsValid() checks for comment length
> - DataValue.hbm.xml has ""
> 
> Do these also need to be changed? If so, I guess a custom .war file will be 
> needed (as opposed to just changing the .vm and .js files)?
> 
> Olav
> 
> 
> 
> 9. apr. 2014 kl. 11:48 skrev channara rin :
> 
>> Oh!, i am using MySQL. where i can find this sql expression?
>> 
>> 
>> On Wed, Apr 9, 2014 at 4:46 PM, Jason Pickering 
>>  wrote:
>> Could be. On postgres, the datavalue table (at least on my system) looks 
>> like this
>> 
>> CREATE TABLE datavalue
>> (
>>   dataelementid integer NOT NULL,
>>   periodid integer NOT NULL,
>>   sourceid integer NOT NULL,
>>   categoryoptioncomboid integer NOT NULL,
>>   value character varying(255),
>>   storedby character varying(100),
>>   lastupdated timestamp without time zone,
>>   comment character varying(360),
>>   followup boolean,
>> 
>> 
>> In that case, not sure then. :-/
>> 
>> Regards,
>> Jason
>> 
>> 
>> 
>> On Wed, Apr 9, 2014 at 11:42 AM, channara rin  wrote:
>> The default, comment field in datavalue table is longtext type.
>> 
>> Best Regards,
>> CHANNARA
>> 
>> 
>> On Wed, Apr 9, 2014 at 4:40 PM, Jason Pickering 
>>  wrote:
>> Did you change the database field type from varchar to text?
>> 
>> Regards,
>> Jason
>> 
>> 
>> 
>> On Wed, Apr 9, 2014 at 11:31 AM, channara rin  wrote:
>> Dear Lars,
>> I tried to change in history.js
>> but when i enter longer than 360 in comment, and press "Save Comment". It 
>> always jump:
>> CONSOLE
>> -
>> ReferenceError: i18n_saving_comment_failed_error_code is not defined 
>>  history.js:64
>> -
>> 
>> history.js
>> --
>> function handleError( xhr, textStatus, errorThrown )
>> {
>> markComment( COLOR_RED );
>> window.alert( i18n_saving_comment_failed_error_code + '\n\n' + 
>> xhr.responseText );
>> }
>> 
>> 
>> On Wed, Apr 9, 2014 at 3:29 PM, Lars Helge Øverland  
>> wrote:
>> The cell border will be green for fields which have comments (next time you 
>> open that form).
>> 
>> 
>> 
>> 
>> On Wed, Apr 9, 2014 at 10:27 AM, channara rin  wrote:
>> Great, Thank you.
>> SO i need to modify the 360 in history.js file?
>> 
>> AND another problem is. when has comment, can show highlight data value in 
>> dataset that has text in that comment? SO it is easy for us(M&E staff) to 
>> view if that data value has comment..
>> 
>> Thank you
>> CHANNARA
>> 
>> 
>> 
>> 
>> 
>> On Wed, Apr 9, 2014 a

[Dhis2-users] QGIS...

[Jerome Shaguy]

Hi Friends,

I am having trouble running my QGIS, it installs okay but does not give me
a start up icon on the desktop and does not give me any interface. Has
anyone else experienced this? Appreciate some advice.

Cheers
___
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] QGIS...

[rin.channara]

some time you installed wrong QGIS x32/86 or x64 to support your computer?


channara





From: Jerome Shaguy
Sent: ‎Thursday‎, ‎September‎ ‎11‎, ‎2014 ‎5‎:‎56‎ ‎Morning
To: DHIS 2 Users list





Hi Friends,



I am having trouble running my QGIS, it installs okay but does not give me a 
start up icon on the desktop and does not give me any interface. Has anyone 
else experienced this? Appreciate some advice.




Cheers___
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.16 upgrade notes

[Ngoc Thanh Nguyen]

Hi

DHIS2 is not exhaustively tested in mysql so don't be discouraged. I often
see this error.
Try the following:
- mvn clean
- check your hibernate configuration file
- try with a fresh new db to see if that error occurs

Thanh



On Thu, Sep 11, 2014 at 8:55 AM, sumudu weerasinghe 
wrote:

> Hi Lars and all,
> I used dhis 2.15 for our mental health information system, which contain
> both tracker and aggregate parts. I try to upgrade my instance to 2.16 from
> 2.15. Above mention things has been automatically happened , but there is a
> error
>
>1.  2.16 war file deployed on 2.15 database
>2. then data entry form unable to load
>3. give memory problem
>
> Can anyone advise regarding upgrading in to 2.16 ?
> Detail of log file and screen shot attach here.
> I am using
> *Version: 2.16**Build revision:16410**Database type:MySQL*
> *Java version:1.7.0_04**OS name:Windows 7*
> Regards
> Sumudu
>
>
> On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland 
> wrote:
>
>> Hi,
>>
>> a note on how to upgrade to dhis version 2.16:
>>
>> The following changes *require* *action* on the implementer's side.
>>
>>- From data administration > scheduling, scheduling should be
>>deactivated, set according to your needs and finally activated.
>>- A property "encryption.password" should be added to
>>hibernate.properties file if you plan to use the data synchronization
>>feature, see the docs
>>
>> 
>>.
>>
>> The following database changes require *no action* and will happen
>> automatically when running the new WAR file the first time.
>>
>>- Column "completed" of table "programstageinstance" has been removed
>>and is replaced by the existing "status" column.
>>- The values in column "domaintype" of table "dataelement" have been
>>migrated from "aggregate" to "AGGREGATE" and from "patient" to "TRACKER".
>>- A column "lastupdated" will be added to table "datavalue", this
>>might take some time when starting up the system for the first time.
>>
>> This information can also be found here:
>>
>> https://www.dhis2.org/2.16-upgrade
>>
>> We encourage people to upgrade their instances, test the new features and
>> provide feedback.
>>
>> best regards,
>>
>> Lars
>>
>>
>> ___
>> 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-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] [Dhis2-devs] dhis 2.16 upgrade notes

[Jason Pickering]

Hi Sumudu,

I looked through your log, and it looks like you are using an older build
of 2.16 which is subject to a potentially very serious security flaw. This
issue was disclosed on the DHIS2 developer  and user list last week out
last week and a fix has been committed by the developers. You would be well
advised to upgrade to the latest version of 2.16, available here (
https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
).

It is a bit hard to say from the logs what might be going on, because it is
only a quite short snippet. I suggest you shutdown Tomcat, remove the old
dhis.war file and all the contents of the /dhis directory (or whatever you
might be calling it), download the updated 2.16 war file as mentioned
above, restart Tomcat, and then post the logs of where things go wrong.

Best regards,
Jason




On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe 
wrote:

> Hi Lars and all,
> I used dhis 2.15 for our mental health information system, which contain
> both tracker and aggregate parts. I try to upgrade my instance to 2.16 from
> 2.15. Above mention things has been automatically happened , but there is a
> error
>
>1.  2.16 war file deployed on 2.15 database
>2. then data entry form unable to load
>3. give memory problem
>
> Can anyone advise regarding upgrading in to 2.16 ?
> Detail of log file and screen shot attach here.
> I am using
> *Version: 2.16**Build revision:16410**Database type:MySQL*
> *Java version:1.7.0_04**OS name:Windows 7*
> Regards
> Sumudu
>
>
> On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland 
> wrote:
>
>> Hi,
>>
>> a note on how to upgrade to dhis version 2.16:
>>
>> The following changes *require* *action* on the implementer's side.
>>
>>- From data administration > scheduling, scheduling should be
>>deactivated, set according to your needs and finally activated.
>>- A property "encryption.password" should be added to
>>hibernate.properties file if you plan to use the data synchronization
>>feature, see the docs
>>
>> 
>>.
>>
>> The following database changes require *no action* and will happen
>> automatically when running the new WAR file the first time.
>>
>>- Column "completed" of table "programstageinstance" has been removed
>>and is replaced by the existing "status" column.
>>- The values in column "domaintype" of table "dataelement" have been
>>migrated from "aggregate" to "AGGREGATE" and from "patient" to "TRACKER".
>>- A column "lastupdated" will be added to table "datavalue", this
>>might take some time when starting up the system for the first time.
>>
>> This information can also be found here:
>>
>> https://www.dhis2.org/2.16-upgrade
>>
>> We encourage people to upgrade their instances, test the new features and
>> provide feedback.
>>
>> best regards,
>>
>> Lars
>>
>>
>> ___
>> 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-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
___
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] XML ou CSV Importation de métadonnées

[Assetta BARA]

Salut chers tous,
l'importation des métadonnées n'est pas stable j'ai installé dhis2 en local 
(2.16) et importé mes métadonnées de ma base en ligne (2.16 aussi) avec succès. 
Mais à chaque fois, que je me déconnecte de ma base en local et me reconnecte, 
pas de métadonnées!!! Existe t-il une méthode de conserver ses variables 
importées? Merci de votre aide.
Assetta
DHIS2-Burkina___
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 report not showing proper breakdown.

[Kiran Prakash]

Hello,

I did a little debugging and figure that this might be because the
analytics query is failing with following error.

StatementCallback; bad SQL grammar [select
"de","weekly","uidlevel3","a99ecb2c5c3", sum(value) as value from
analytics_2014 where "de" in ('a0ea1b1d113') and "weekly" in ('2014W2') and
"uidlevel3" in ('a42405657c4') and "a99ecb2c5c3" in ('abacfb5842a',
'a5dd89a503f') and ( (uidlevel1 = 'a2cf79e8f13' and approvallevel <= 999) )
group by "de","weekly","uidlevel3","a99ecb2c5c3"]; nested exception is
org.postgresql.util.PSQLException: ERROR: column "a99ecb2c5c3" does not
exist
  Position: 34
at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
at
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
at
org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:366)
at
org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:140)
at sun.reflect.GeneratedMethodAccessor876.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at
org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: ERROR: column "a99ecb2c5c3"
does not exist
  Position: 34
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
at
com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
... 13 more
* INFO  2014-09-11 12:05:20,742 Query failed, likely because the requested
analytics table does not exist (JdbcAnalyticsManager.java
[SimpleAsyncTaskExecutor-921])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar [select "de","weekly","uidlevel3","a99ecb2c5c3", sum(value) as
value from analytics_2014 where "de" in ('aee83d48c4c') and "weekly" in
('2014W2') and "uidlevel3" in ('a42405657c4') and "a99ecb2c5c3" in
('abacfb5842a', 'a5dd89a503f') and ( (uidlevel1 = 'a2cf79e8f13' and
approvallevel <= 999) ) group by "de","weekly","uidlevel3","a99ecb2c5c3"];
nested exception is org.postgresql.util.PSQLException: ERROR: column
"a99ecb2c5c3" does not exist
  Position: 34


I have checked the database, and the table analytics_2014 exists.

I think this is because the generate sql seems wrong.

"uidlevel3" in ('a42405657c4') and "a99ecb2c5c3"

should this be "uidlevel3" in ('a42405657c4', "a99ecb2c5c3")? or something
else?

Are you guys aware of this issue and if it's fixed in trunk, what revision?

We're very close to release, so cannot afford to merge with trunk. Any help
pointing out the fix/ revision number will be of great help

Thanks in advance

Kiran.

On Wed, Sep 10, 2014 at 1:23 PM, Mahendra Kariya <
mahendra.kar...@thoughtworks.com> wrote:

> Hi Lars/Morten,
>
> It would be really helpful if you guys could point us to where we can look
> for if something is going wrong.
>
> On Tue, Sep 9, 2014 at 10:59 AM, Kiran Prakash 
> wrote:
>
>> Hello Lars,
>>
>> any insight into this? this is holding up one of our stories. really
>> appreciate if you can have a look in
>>
>> thanks
>>
>> Kiran
>>

Re: [Dhis2-users] [Dhis2-devs] dhis 2.16 upgrade notes

[sumudu weerasinghe]

Thanks Jason and Ngoc Thanh!

I followed you instruction

   - remove old war file and its contents from  webapps directory
   - upgrade with new war file (build revision 16414)

But it is still unable to open a data entry form, in this time log file
does not show any error massage  . Here is my log screen shot is same as
previous.

Sumudu

On Thu, Sep 11, 2014 at 10:09 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Sumudu,
>
> I looked through your log, and it looks like you are using an older build
> of 2.16 which is subject to a potentially very serious security flaw. This
> issue was disclosed on the DHIS2 developer  and user list last week out
> last week and a fix has been committed by the developers. You would be well
> advised to upgrade to the latest version of 2.16, available here (
> https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
> ).
>
> It is a bit hard to say from the logs what might be going on, because it
> is only a quite short snippet. I suggest you shutdown Tomcat, remove the
> old dhis.war file and all the contents of the /dhis directory (or whatever
> you might be calling it), download the updated 2.16 war file as mentioned
> above, restart Tomcat, and then post the logs of where things go wrong.
>
> Best regards,
> Jason
>
>
>
>
> On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe 
> wrote:
>
>> Hi Lars and all,
>> I used dhis 2.15 for our mental health information system, which contain
>> both tracker and aggregate parts. I try to upgrade my instance to 2.16 from
>> 2.15. Above mention things has been automatically happened , but there is a
>> error
>>
>>1.  2.16 war file deployed on 2.15 database
>>2. then data entry form unable to load
>>3. give memory problem
>>
>> Can anyone advise regarding upgrading in to 2.16 ?
>> Detail of log file and screen shot attach here.
>> I am using
>> *Version: 2.16**Build revision:16410**Database type:MySQL*
>> *Java version:1.7.0_04**OS name:Windows 7*
>> Regards
>> Sumudu
>>
>>
>> On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland > > wrote:
>>
>>> Hi,
>>>
>>> a note on how to upgrade to dhis version 2.16:
>>>
>>> The following changes *require* *action* on the implementer's side.
>>>
>>>- From data administration > scheduling, scheduling should be
>>>deactivated, set according to your needs and finally activated.
>>>- A property "encryption.password" should be added to
>>>hibernate.properties file if you plan to use the data synchronization
>>>feature, see the docs
>>>
>>> 
>>>.
>>>
>>> The following database changes require *no action* and will happen
>>> automatically when running the new WAR file the first time.
>>>
>>>- Column "completed" of table "programstageinstance" has been
>>>removed and is replaced by the existing "status" column.
>>>- The values in column "domaintype" of table "dataelement" have been
>>>migrated from "aggregate" to "AGGREGATE" and from "patient" to "TRACKER".
>>>- A column "lastupdated" will be added to table "datavalue", this
>>>might take some time when starting up the system for the first time.
>>>
>>> This information can also be found here:
>>>
>>> https://www.dhis2.org/2.16-upgrade
>>>
>>> We encourage people to upgrade their instances, test the new features
>>> and provide feedback.
>>>
>>> best regards,
>>>
>>> Lars
>>>
>>>
>>> ___
>>> 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-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
>
Sep 11, 2014 11:41:14 AM org.apache.catalina.core.AprLifecycleListener init
INFO: Loaded APR based Apache Tomcat Native library 1.1.29 using APR version 1.4
.8.
Sep 11, 2014 11:41:14 AM org.apache.catalina.core.AprLifecycleListener init
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], ra
ndom [true].
Sep 11, 2014 11:41:16 AM org.apache.catalina.core.AprLifecycleListener initializ
eSSL
INFO: OpenSSL successfully initialized (OpenSSL 1.0.1e 11 Feb 2013)
Sep 11, 2014 11:41:17 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-apr-8084"]
Sep 11, 2014 11:41:17 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-apr-8009"]
Sep 11, 2014 11:41:17 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3706 ms
Sep 11, 2014 11:41:17 AM org.apache.cat

Re: [Dhis2-users] [Dhis2-devs] dhis 2.16 upgrade notes

[Morten Olav Hansen]

Can you open the web inspector with F12, and give use any output there?

--
Morten

On Thu, Sep 11, 2014 at 1:47 PM, sumudu weerasinghe 
wrote:

> Thanks Jason and Ngoc Thanh!
>
> I followed you instruction
>
>- remove old war file and its contents from  webapps directory
>- upgrade with new war file (build revision 16414)
>
> But it is still unable to open a data entry form, in this time log file
> does not show any error massage  . Here is my log screen shot is same as
> previous.
>
> Sumudu
>
> On Thu, Sep 11, 2014 at 10:09 AM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Sumudu,
>>
>> I looked through your log, and it looks like you are using an older build
>> of 2.16 which is subject to a potentially very serious security flaw. This
>> issue was disclosed on the DHIS2 developer  and user list last week out
>> last week and a fix has been committed by the developers. You would be well
>> advised to upgrade to the latest version of 2.16, available here (
>> https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
>> ).
>>
>> It is a bit hard to say from the logs what might be going on, because it
>> is only a quite short snippet. I suggest you shutdown Tomcat, remove the
>> old dhis.war file and all the contents of the /dhis directory (or whatever
>> you might be calling it), download the updated 2.16 war file as mentioned
>> above, restart Tomcat, and then post the logs of where things go wrong.
>>
>> Best regards,
>> Jason
>>
>>
>>
>>
>> On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe 
>> wrote:
>>
>>> Hi Lars and all,
>>> I used dhis 2.15 for our mental health information system, which contain
>>> both tracker and aggregate parts. I try to upgrade my instance to 2.16 from
>>> 2.15. Above mention things has been automatically happened , but there is a
>>> error
>>>
>>>1.  2.16 war file deployed on 2.15 database
>>>2. then data entry form unable to load
>>>3. give memory problem
>>>
>>> Can anyone advise regarding upgrading in to 2.16 ?
>>> Detail of log file and screen shot attach here.
>>> I am using
>>> *Version: 2.16**Build revision:16410**Database type:MySQL*
>>> *Java version:1.7.0_04**OS name:Windows 7*
>>> Regards
>>> Sumudu
>>>
>>>
>>> On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland <
>>> larshe...@gmail.com> wrote:
>>>
 Hi,

 a note on how to upgrade to dhis version 2.16:

 The following changes *require* *action* on the implementer's side.

- From data administration > scheduling, scheduling should be
deactivated, set according to your needs and finally activated.
- A property "encryption.password" should be added to
hibernate.properties file if you plan to use the data synchronization
feature, see the docs

 
.

 The following database changes require *no action* and will happen
 automatically when running the new WAR file the first time.

- Column "completed" of table "programstageinstance" has been
removed and is replaced by the existing "status" column.
- The values in column "domaintype" of table "dataelement" have
been migrated from "aggregate" to "AGGREGATE" and from "patient" to
"TRACKER".
- A column "lastupdated" will be added to table "datavalue", this
might take some time when starting up the system for the first time.

 This information can also be found here:

 https://www.dhis2.org/2.16-upgrade

 We encourage people to upgrade their instances, test the new features
 and provide feedback.

 best regards,

 Lars


 ___
 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-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
>>
>
>
> ___
> 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