date:20140304

Re: [Dhis2-users] Creating charts, maps and tables in dhis2-live 2.14

2014-03-04 Thread Lars Helge Øverland

Great..
On Mar 4, 2014 9:51 AM, "Marta Vila"  wrote:

> Hi Lars, all,
>
> sorry for the late response. I downloaded the war file today, it is fixed
> now.
>
> I´ve been able to run analytics and visualize charts and maps using the
> live version.
>
> *Version:**2.14* *Build revision:**13805* *Build date:**2014-03-04 02:06*
> Thank you !!
>
>
> On 18 February 2014 10:43, Lars Helge Øverland wrote:
>
>> Hi Marta,
>>
>> thanks for reporting. Your investigation is correct - there was again an
>> issue with column encoding on H2. It should be fixed now in trunk and 2.14.
>> Can you please try again by
>>
>> - replacing the war file under /webapps/ in live directory with the war
>> file from here in 30 minutes: http://apps.dhis2.org/ci/job/dhis-2.14/
>> - re-run analytics
>>
>> Let us know how it works.
>>
>> Lars
>>
>>
>>
>> On Mon, Feb 3, 2014 at 6:15 PM, Marta Vila  wrote:
>>
>>> Dear all,
>>>
>>> I have imported some data into a 2.14 dhis2-live and run the analytics
>>> process.
>>>
>>> Version:2.14 Build revision:13752 Build date:2014-01-31 16:41
>>> It has gone well, and I´ve checked with an SQL view that the analytics
>>> table and its values are there. However when I when I try to create a
>>> chart, table or map, I get the "Values not found" message.
>>>
>>> Having a look at the log (complete log attached)
>>>
>>> ** INFO  17:45:29,251 Query failed, likely because the requested
>>> analytics table does not exist (JdbcAnalyticsManager.java
>>> [SimpleAsyncTaskExecutor-6])*
>>> *org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
>>> SQL grammar [select "uidlevel4","de", sum(value) as value from
>>> analytics_2011 where "uidlevel4" in (**'zXcr52pysDR', 'dOfLwJp4HCR',
>>> 'ZZ2j0yKuZu8', 'xTki3rdk7cd', 'Y5pHHOo6Omn'**) and "de" in
>>> ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de"];
>>> nested exception is org.h2.jdbc.JdbcSQLException: Column "de" not found;
>>> SQL statement:*
>>> *select "uidlevel4","de", sum(value) as value from analytics_2011 where
>>> "uidlevel4" in ('u4Idnn89LtY', 'XGPQ2WduCfW', 'S4cPuE2d3dv', 'OCtV1PUshto',
>>> 'pBihSffHkhT') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group
>>> by "uidlevel4","de" [42122-173]*
>>>
>>> It seems like the query fails because "de" does not exist... However in
>>> the DB I see column a column DE and H2 is not supposed to be case
>>> sensitive.
>>>
>>> I found that it may be acting like this because of the double quote
>>> https://groups.google.com/forum/#!topic/h2-database/UXI2Mz5HM3s 
>>> 
>>> , tried an SQL view without the quotes and worked so...
>>>
>>> In case this is the problem... is there any way it can be solved?
>>>
>>> thanks!!
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] (no subject)

2014-03-04 Thread Marcos Antonio

Hi all

 

I need a help configuring a standart report.

 

I need to show all organization units level up from a selected organizaton
unit (including this selected one and its children)

I'm using the ireport with type "jasper report with report table" 

 

 

Consider the following:

Organisation unit level =  organisation unit name

1-National = Sierra Leone

2-Province = Bo

3-District = Badjia

4-Health Unit = Ngelehum CHC, Njandama MCHP

 

Example: If the user selects "Njandama MCHP", the report should contain the
following in this exact order:

Organization Unit field1   field2 field3

Njandama MCHP  value1   value2 value3

Badjia value4   value5 value6

Bovalue7   value8 value9

Sierra Leone   value10  value11value12

 

 

In order to do this I have tryed the following:

 

  1. In the pivot table I selected the options: User org unit, Org unit
Childen e Org unit Grand Children and 

  2. In the report(jasper) I filtered the Organization Unit that should not
be displayed.

  

  The problem with this solution is that the Organization Units do not
appear in the right order when I select Health Unit or district.

  

When a I select Health Unit, the report comes like:

Organization Unit  field 1   field 2 field 3

Njandama MCHP  value1   value2 value3

Sierra Leonevalue10  value11value12 

Bovalue7   value8 value9

Badjia value4   value5 value6

 

We are using version: 2.13 and Build revision 12905

 

Does anyone have a clue on what i might be doing wrong?

 

View the annex

 

Regards.

 

 


Marcos Lúcio António

  mlanto...@criticalsoftware.co.mz

Mob MZ. +258825143186
Mob MZ.  +258844831720


 


 

 


 


 

Bottom of Form

 

Hi all

I need a help configuring a standart report.

I need to show all organization units level up from a selected organizaton unit 
(including this selected one and its children)
I'm using the ireport with type "jasper report with report table" 


Consider the following:
Organisation unit level =  organisation unit name
1-National = Sierra Leone
2-Province = Bo
3-District = Badjia
4-Health Unit = Ngelehum CHC, Njandama MCHP

Example: If the user selects "Njandama MCHP", the report should contain the 
following in this exact order:
Organization Unit   field1   field2 field3
Njandama MCHP   value1   value2 value3
Badjia  value4   value5 value6
Bo  value7   value8 value9
Sierra Leonevalue10  value11value12


In order to do this I have tryed the following:

  1. In the pivot table I selected the options: User org unit, Org unit Childen 
e Org unit Grand Children and 
  2. In the report(jasper) I filtered the Organization Unit that should not be 
displayed.
  
  The problem with this solution is that the Organization Units do not appear 
in the right order when I select Health Unit or district.
  
When a I select Health Unit, the report comes like:
Organization Unit   field1   field2 field3
Njandama MCHP   value1   value2 value3
Sierra Leonevalue10  value11value12 
Bo  value7   value8 value9
Badjia  value4   value5 value6

We are using version: 2.13 and Build revision 12905

Does anyone have a clue on what i might be doing wrong?


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

Re: [Dhis2-users] Creating charts, maps and tables in dhis2-live 2.14

2014-03-04 Thread Marta Vila

Hi Lars, all,

sorry for the late response. I downloaded the war file today, it is fixed
now.

I´ve been able to run analytics and visualize charts and maps using the
live version.

*Version:**2.14* *Build revision:**13805* *Build date:**2014-03-04 02:06*
Thank you !!


On 18 February 2014 10:43, Lars Helge Øverland  wrote:

> Hi Marta,
>
> thanks for reporting. Your investigation is correct - there was again an
> issue with column encoding on H2. It should be fixed now in trunk and 2.14.
> Can you please try again by
>
> - replacing the war file under /webapps/ in live directory with the war
> file from here in 30 minutes: http://apps.dhis2.org/ci/job/dhis-2.14/
> - re-run analytics
>
> Let us know how it works.
>
> Lars
>
>
>
> On Mon, Feb 3, 2014 at 6:15 PM, Marta Vila  wrote:
>
>> Dear all,
>>
>> I have imported some data into a 2.14 dhis2-live and run the analytics
>> process.
>>
>> Version:2.14 Build revision:13752 Build date:2014-01-31 16:41
>> It has gone well, and I´ve checked with an SQL view that the analytics
>> table and its values are there. However when I when I try to create a
>> chart, table or map, I get the "Values not found" message.
>>
>> Having a look at the log (complete log attached)
>>
>> ** INFO  17:45:29,251 Query failed, likely because the requested
>> analytics table does not exist (JdbcAnalyticsManager.java
>> [SimpleAsyncTaskExecutor-6])*
>> *org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
>> SQL grammar [select "uidlevel4","de", sum(value) as value from
>> analytics_2011 where "uidlevel4" in (**'zXcr52pysDR', 'dOfLwJp4HCR',
>> 'ZZ2j0yKuZu8', 'xTki3rdk7cd', 'Y5pHHOo6Omn'**) and "de" in
>> ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de"];
>> nested exception is org.h2.jdbc.JdbcSQLException: Column "de" not found;
>> SQL statement:*
>> *select "uidlevel4","de", sum(value) as value from analytics_2011 where
>> "uidlevel4" in ('u4Idnn89LtY', 'XGPQ2WduCfW', 'S4cPuE2d3dv', 'OCtV1PUshto',
>> 'pBihSffHkhT') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group
>> by "uidlevel4","de" [42122-173]*
>>
>> It seems like the query fails because "de" does not exist... However in
>> the DB I see column a column DE and H2 is not supposed to be case
>> sensitive.
>>
>> I found that it may be acting like this because of the double quote
>> https://groups.google.com/forum/#!topic/h2-database/UXI2Mz5HM3s 
>> 
>> , tried an SQL view without the quotes and worked so...
>>
>> In case this is the problem... is there any way it can be solved?
>>
>> thanks!!
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DHIS2 mobile java error

2014-03-04 Thread Lars Kristian Roland

Hi,

can you give us the version of the DHIS2 server  you are using, and whether
you're using the newest J2ME client or an older build?

You find the build revision number of the DHIS instance under Profile ->
About DHIS2.

Best regards,
Lars


2014-03-04 15:17 GMT+01:00 tasokwa nkhonjera :

> Hello guys,
> i am having a problem with DHIS2 mobile aggregate.jar. am able to install
> it on my nokia C3 phone, even logging in is fine am able to reach a point
> were am required to put a 4 digit pin, but when i do this its giving me an
> error as follows:
> Null Pointer Java/lang/Null pointer exception. how can i solve this?
>
> ___
> 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
>
>


-- 
Lars Kristian Roland
Research Fellow, Department of Informatics, University of Oslo
Email: l...@roland.bz - rol...@ifi.uio.no
Phone: +47 90733036
___
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 mobile java error

2014-03-04 Thread tasokwa nkhonjera

Hello guys,
i am having a problem with DHIS2 mobile aggregate.jar. am able to install
it on my nokia C3 phone, even logging in is fine am able to reach a point
were am required to put a 4 digit pin, but when i do this its giving me an
error as follows:
Null Pointer Java/lang/Null pointer exception. how can i solve this?
___
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] Fwd: importing sql file in postgresql database

2014-03-04 Thread Thái Chương

Hello, could you please clarify how did you import thing and what is the
error you face?
How did you have you sql backup?
Normally we can import as previous reply
 On Mar 4, 2014 5:08 PM, "HAKIZIMANA Franck" 
wrote:

>
>
> -- Forwarded message --
> From: riddy ndoma 
> Date: Tue, Mar 4, 2014 at 9:03 AM
> Subject: Re: [Dhis2-users] importing sql file in postgresql database
> To: HAKIZIMANA Franck 
> Cc: DHIS 2 Users list 
>
>
> Hi @Hakizimana
> firstly, we must create a blank database in pgadmin3. Then type the
> following command in the psql command prompt:
>
> psql-d NAME_DATABASE-U-f NAME_USER PATH_FILE_SQL
>
>
> 2014-03-04 8:58 GMT+01:00 HAKIZIMANA Franck :
>
>> hi,
>>
>> I want to import sql file into postgresql database that I want to use in
>> dhis2 2.14 live in local, but I have tried many ways I failed to import it
>> in postgresql.
>> Could someone help me on this issue?
>>
>> best regards,
>>
>> Franck
>>
>> ___
>> 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
>>
>>
>
>
> --
> Riddy NDOMA
> Software Developer
> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
> *Blog:* http://riddyndoma.blogspot.com/
>
> Vous servir est mon désire (Serving you is my desire)
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Fwd: importing sql file in postgresql database

2014-03-04 Thread HAKIZIMANA Franck

-- Forwarded message --
From: riddy ndoma 
Date: Tue, Mar 4, 2014 at 9:03 AM
Subject: Re: [Dhis2-users] importing sql file in postgresql database
To: HAKIZIMANA Franck 
Cc: DHIS 2 Users list 


Hi @Hakizimana
firstly, we must create a blank database in pgadmin3. Then type the
following command in the psql command prompt:

psql-d NAME_DATABASE-U-f NAME_USER PATH_FILE_SQL


2014-03-04 8:58 GMT+01:00 HAKIZIMANA Franck :

> hi,
>
> I want to import sql file into postgresql database that I want to use in
> dhis2 2.14 live in local, but I have tried many ways I failed to import it
> in postgresql.
> Could someone help me on this issue?
>
> best regards,
>
> Franck
>
> ___
> 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
>
>


-- 
Riddy NDOMA
Software Developer
*Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
*Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
*Blog:* http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] importing sql file in postgresql database

2014-03-04 Thread riddy ndoma

In the attached excerpt from my command prompt. You have to reassure you
that you have configured the postgresql environment variable. for the psql
commands can be recognized in your command prompt.


2014-03-04 9:03 GMT+01:00 riddy ndoma :

> Hi @Hakizimana
> firstly, we must create a blank database in pgadmin3. Then type the
> following command in the psql command prompt:
>
> psql-d NAME_DATABASE-U-f NAME_USER PATH_FILE_SQL
>
>
> 2014-03-04 8:58 GMT+01:00 HAKIZIMANA Franck :
>
>> hi,
>>
>> I want to import sql file into postgresql database that I want to use in
>> dhis2 2.14 live in local, but I have tried many ways I failed to import it
>> in postgresql.
>> Could someone help me on this issue?
>>
>> best regards,
>>
>> Franck
>>
>> ___
>> 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
>>
>>
>
>
> --
> Riddy NDOMA
> Software Developer
> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
> *Blog:* http://riddyndoma.blogspot.com/
>
> Vous servir est mon désire (Serving you is my desire)
>



-- 
Riddy NDOMA
Software Developer
*Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
*Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
*Blog:* http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)
<>___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] importing sql file in postgresql database

2014-03-04 Thread riddy ndoma

Hi @Hakizimana
firstly, we must create a blank database in pgadmin3. Then type the
following command in the psql command prompt:

psql-d NAME_DATABASE-U-f NAME_USER PATH_FILE_SQL


2014-03-04 8:58 GMT+01:00 HAKIZIMANA Franck :

> hi,
>
> I want to import sql file into postgresql database that I want to use in
> dhis2 2.14 live in local, but I have tried many ways I failed to import it
> in postgresql.
> Could someone help me on this issue?
>
> best regards,
>
> Franck
>
> ___
> 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
>
>


-- 
Riddy NDOMA
Software Developer
*Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
*Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
*Blog:* http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)
___
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] Creating charts, maps and tables in dhis2-live 2.14

[Dhis2-users] (no subject)

Re: [Dhis2-users] Creating charts, maps and tables in dhis2-live 2.14

Re: [Dhis2-users] DHIS2 mobile java error

[Dhis2-users] DHIS2 mobile java error

Re: [Dhis2-users] Fwd: importing sql file in postgresql database

[Dhis2-users] Fwd: importing sql file in postgresql database

Re: [Dhis2-users] importing sql file in postgresql database

Re: [Dhis2-users] importing sql file in postgresql database

9 matches

Site Navigation

Mail list logo

Footer information