[Dhis2-users] Font rendering in Chrome Canary

[Nils Kaiser]

Hey,

In Chrome Canary the font padauk which is used by DHIS2 is not rendered
properly, which leads to the following effect:

[image: Inline image 1]

Best,

Nils

-- 
Nils Kaiser
Information Systems Manager
eHealth Systems Africa
m (sierra leone): + <+23299891119>232 9989 1119 <+23299891119>
m (germany): *+49 178 8079029*
m (guinea): *+224 624 205 831*
skype: Berlinils
http://ehealthafrica.org/
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Analyzing Yes/No values GIS

[Pamod Amarakoon]

Dear All,

When using GIS module to analyze yes/no data elements it asks to select a
values from a numerical scale with a logical parameter (equal, greater
than, less than etc).


​
​
 How does this numerical scale works with yes/no values. What's the value
and parameter I should select to display only yes values.

Thank you.

-- 
Regards,
Pamod Amarakoon

Confidentiality Notice: the information contained in this email and any
attachments may be legally privileged and confidential. If you are not an
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this e-mail is strictly prohibited. If you have
received this e-mail in error, please notify the sender and permanently
delete the e-mail and any attachments immediately. You should not retain,
copy or use this e-mail or any attachments for any purpose, nor disclose
all or any part of the contents to any other person.
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Analytics period

[Abdul karim Jaafar]

Dears,

 

I forgot to tell you analytic was taking from 2 to 7 hour, then we made hosting 
in ‘BAO system’ for two month and then analytic take 18 hour in there system,

 

Then gradually began to decrease, but when I took DB backup from them and start 
it in our old local server and analytic take now too much time.

 

Also in tomcat server after analytic I see this error

 

 

“* INFO  2016-05-31 13:21:26,787 Query failed, likely because the requested 
analytics table does not exist (JdbcEventAnalyticsManager.java 
[http-apr-8085-exec-5])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL 
grammar [select count(coalesce("u52tYTj6mV8",0)) as value,"yearly" from 
analytics_event_2015_qmal2yvmlpc where Yearly in ('2015') and (uidlevel1 = 
'Z8WFmqm0AvD' ) and ("u52tYTj6mV8" is not null) group by "yearly" ]; nested 
exception is org.postgresql.util.PSQLException: ERROR: COALESCE types text and 
integer cannot be matched

  Position: 37”

 

 

I did tuning for PostgreSQL put analytic still take too much time.

Regards,

 

From: Halvdan Hoem Grelland [mailto:halv...@dhis2.org] 
Sent: Tuesday, May 31, 2016 12:12 PM
To: Hannan Khan 
Cc: Abdul karim Jaafar ; DHIS 2 Users list 

Subject: Re: [Dhis2-users] Analytics period

 

18 hours seems very excessive. Did you do any performance tuning of Postgres? 
You could have a look at section 8.3.6 here 
 

 

On Tue, May 31, 2016 at 6:47 AM, Hannan Khan mailto:hann...@gmail.com> > wrote:

Dear Abdul Karim

 

This is quite unusual for this amount of data. We have several million tracked 
entity and took only half an hour for run analytics for last three years. 

 

Can you please check your postgres tuning parameter, server tuning parameters 
and get back to me.

 

Regards

 

Hannan Khan  

 

On Tue, May 31, 2016 at 10:05 AM, Abdul karim Jaafar 
mailto:abdulkarim.jaafa...@gmail.com> > wrote:

Hi Lars,

 

I have 337460 value in data value, 692719 in ‘tracked entity attribute value’ 
and 994129 in ‘tracked entity data value’

 

also these inputs are increasing daily,

 

I have upgraded PostgreSQL to 9.5 but analytic still take much time

 

now it take about 19 hour!

 

I use DHIS2 Version: 2.22

 

Build revision:22057

Java version:1.8.0_92

 

Time since last analytics table generation:

34 h, 32 m, 5 s

Last analytics table runtime:

18 h, 44 m, 55 s

 

Best regards,

 

 

 

From: Lars Helge Øverland [mailto:l...@dhis2.org  ] 
Sent: Tuesday, May 31, 2016 4:19 AM
To: Abdul karim Jaafar mailto:abdulkarim.jaafa...@gmail.com> >
Cc: DHIS 2 Users list mailto:dhis2-users@lists.launchpad.net> >
Subject: Re: [Dhis2-users] Analytics period

 

Hi Abdul,

 

okay. Can you let us know a bit more info here, such as:

 

- how many data values do you have in your database

- how long does analytics take to complete

- tomcat log output from the process

 

Upgrading to PostgreSQL 9.5 will make the process significantly faster compared 
to 9.3.

 

regards,

 

Lars

 

 

On Mon, May 30, 2016 at 10:56 PM, Abdul karim Jaafar 
mailto:abdulkarim.jaafa...@gmail.com> > wrote:

Dears all,

 

I have a problem with analytics period, It take too much time to finish, I did 
‘Maintenance’ from ‘Data Administration’ and fixed all problems in ‘Data 
Integrity’

 

Sometime when I change tomcat version, analytic goes better.

 

I want to know what things that make analytic take much time, and how to make 
it faster

 

I have server, OS Windows 64 bit, ram 32 GB, hard 2 TB

 

Best regards,

Abdul Karim,


___
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 Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

l...@dhis2.org  

http://www.dhis2.org  

 


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





 

-- 

Muhammad Abdul Hannan Khan

Secretary

HISP Bangladesh 

 

T +880-2- 8816459  , 8816412 ext 118

F +88 02 8813 875

M+88 01819 239 241

M+88 01534 312 066

E hann...@gmail.com  

S hannan.khan.dhaka

B hannan-tech.blogspot.com  




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





 

-- 

Halvdan 

Re: [Dhis2-users] Uneven Organizational hierarchies urban/rural

[Jason Pickering]

Hi Kristof,

The other question you should ask yourself prior to implementing such a
detailed hierarchy, is whether you will be doing analysis at all those
levels. Other implementations I have been involved in have taken out a
level or two (leaving out street and attaching the water point directly to
the ward for instance) because it was too difficult to maintain the
hierarchy at such a detailed level.  Organization unit levels should be
driven by an analysis requirement.

Otherwise, there is no requirement that you must have all water points at
the same level.  You can use organization unit groups to impart this
distinction.

Regards,
Jason

On Tue, May 31, 2016, 14:27 Kristof Bostoen 
wrote:

> Dear Elmarie Claasen,
>
> Thank you very much for your prompt reply and confirming that this could
> work. I was wondering if anybody has implemented another approach that does
> not require a double entry of the street name as a placeholder?
>
> Kind regards
> K.
>
> On 31 May 2016 at 14:12, Elmarie Claasen  wrote:
>
>> Hi Kristof,
>>
>> What you are really proposing is a placeholder orgunit (to fill the gap
>> in your hierarchy). We have also done that in South Africa and I would say
>> it is a workable solution in your case.
>>
>> Good luck!
>>
>> Elmarie
>> HISP-SA
>> On 31 May 2016 14:01, "Kristof Bostoen" 
>> wrote:
>>
>>> Dear All,
>>>
>>> We are starting the steep DHIS2 learning curve for its use in the water
>>> sector and would like to benefit from your collective experience to get
>>> our implementation right.
>>> We map all the points according to the national
>>> geo-administrative hierarchy of the country but the hierarchy is slightly
>>> different in Urban and rural areas.
>>> Down to ward it is the same but then in urban areas it goes down to
>>> street one level only while in rural areas there are two level down,
>>> villages and and Hamlets as illustrated below.
>>>
>>> We think we do best to duplicate the street as highlighted in the table
>>> but are not sure that is required. Anybody came across a similar
>>> problem and implemented an elegant solution?
>>> Always happy to clarify if required.
>>>
>>> Thank you in advance for your help
>>> Kristof
>>>
>>> Monitoring[4]Change
>>>
>>> #
>>>
>>> Urban
>>>
>>> Rural
>>>
>>> 1
>>>
>>> Zones
>>>
>>> 2
>>>
>>> Regions
>>>
>>> 3
>>>
>>> Districts
>>>
>>> 4
>>>
>>> Divisions
>>>
>>> 5
>>>
>>> Wards
>>>
>>> 6
>>>
>>> Street
>>>
>>> Villages
>>>
>>> 7
>>>
>>> Street
>>>
>>> Hamlets
>>>
>>> 8
>>>
>>> Water distribution point
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> ___
>>> 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
>>>
>>>
>> *This message and any attachments are subject to a disclaimer published
>> at http://www.hisp.org/policies.html#comms_disclaimer
>> .  Please read the
>> disclaimer before opening any attachment or taking any other action in
>> terms of this electronic transmission.  If you cannot access the
>> disclaimer, kindly send an email to disclai...@hisp.org
>>  and a copy will be provided to you. By replying to
>> this e-mail or opening any attachment you agree to be bound by the
>> provisions of the disclaimer.*
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-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] Uneven Organizational hierarchies urban/rural

[Kristof Bostoen]

Dear Elmarie Claasen,

Thank you very much for your prompt reply and confirming that this could
work. I was wondering if anybody has implemented another approach that does
not require a double entry of the street name as a placeholder?

Kind regards
K.

On 31 May 2016 at 14:12, Elmarie Claasen  wrote:

> Hi Kristof,
>
> What you are really proposing is a placeholder orgunit (to fill the gap in
> your hierarchy). We have also done that in South Africa and I would say it
> is a workable solution in your case.
>
> Good luck!
>
> Elmarie
> HISP-SA
> On 31 May 2016 14:01, "Kristof Bostoen" 
> wrote:
>
>> Dear All,
>>
>> We are starting the steep DHIS2 learning curve for its use in the water
>> sector and would like to benefit from your collective experience to get
>> our implementation right.
>> We map all the points according to the national
>> geo-administrative hierarchy of the country but the hierarchy is slightly
>> different in Urban and rural areas.
>> Down to ward it is the same but then in urban areas it goes down to
>> street one level only while in rural areas there are two level down,
>> villages and and Hamlets as illustrated below.
>>
>> We think we do best to duplicate the street as highlighted in the table
>> but are not sure that is required. Anybody came across a similar problem
>> and implemented an elegant solution?
>> Always happy to clarify if required.
>>
>> Thank you in advance for your help
>> Kristof
>>
>> Monitoring[4]Change
>>
>> #
>>
>> Urban
>>
>> Rural
>>
>> 1
>>
>> Zones
>>
>> 2
>>
>> Regions
>>
>> 3
>>
>> Districts
>>
>> 4
>>
>> Divisions
>>
>> 5
>>
>> Wards
>>
>> 6
>>
>> Street
>>
>> Villages
>>
>> 7
>>
>> Street
>>
>> Hamlets
>>
>> 8
>>
>> Water distribution point
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> ___
>> 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
>>
>>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> .  Please read the
> disclaimer before opening any attachment or taking any other action in
> terms of this electronic transmission.  If you cannot access the
> disclaimer, kindly send an email to disclai...@hisp.org
>  and a copy will be provided to you. By replying to
> this e-mail or opening any attachment you agree to be bound by the
> provisions of the disclaimer.*
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Uneven Organizational hierarchies urban/rural

[Elmarie Claasen]

Hi Kristof,

What you are really proposing is a placeholder orgunit (to fill the gap in
your hierarchy). We have also done that in South Africa and I would say it
is a workable solution in your case.

Good luck!

Elmarie
HISP-SA
On 31 May 2016 14:01, "Kristof Bostoen" 
wrote:

> Dear All,
>
> We are starting the steep DHIS2 learning curve for its use in the water
> sector and would like to benefit from your collective experience to get
> our implementation right.
> We map all the points according to the national
> geo-administrative hierarchy of the country but the hierarchy is slightly
> different in Urban and rural areas.
> Down to ward it is the same but then in urban areas it goes down to street
> one level only while in rural areas there are two level down, villages and
> and Hamlets as illustrated below.
>
> We think we do best to duplicate the street as highlighted in the table
> but are not sure that is required. Anybody came across a similar problem
> and implemented an elegant solution?
> Always happy to clarify if required.
>
> Thank you in advance for your help
> Kristof
>
> Monitoring[4]Change
>
> #
>
> Urban
>
> Rural
>
> 1
>
> Zones
>
> 2
>
> Regions
>
> 3
>
> Districts
>
> 4
>
> Divisions
>
> 5
>
> Wards
>
> 6
>
> Street
>
> Villages
>
> 7
>
> Street
>
> Hamlets
>
> 8
>
> Water distribution point
>
>
>
>
>
>
>
>
>
>
> ___
> 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
>
>

-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Uneven Organizational hierarchies urban/rural

[Kristof Bostoen]

Dear All,

We are starting the steep DHIS2 learning curve for its use in the water
sector and would like to benefit from your collective experience to get
our implementation right.
We map all the points according to the national
geo-administrative hierarchy of the country but the hierarchy is slightly
different in Urban and rural areas.
Down to ward it is the same but then in urban areas it goes down to street
one level only while in rural areas there are two level down, villages and
and Hamlets as illustrated below.

We think we do best to duplicate the street as highlighted in the table but
are not sure that is required. Anybody came across a similar problem and
implemented an elegant solution?
Always happy to clarify if required.

Thank you in advance for your help
Kristof

Monitoring[4]Change

#

Urban

Rural

1

Zones

2

Regions

3

Districts

4

Divisions

5

Wards

6

Street

Villages

7

Street

Hamlets

8

Water distribution point
___
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] Migration dhis2.19 to 2.22

[Knut Staring]

Hi, please have a look at this:
https://lists.launchpad.net/dhis2-users/msg08793.html


On Tue, May 31, 2016 at 1:50 PM, allade  wrote:

> Dear community
> I migrated my dhis2.19 to 2.20 it was successful. But when I was doing the
> same process to 2.20 i had no result
> Please can someone give me best practice to do this migration to 2.22
> Best 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
>
>


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

[Dhis2-users] Migration dhis2.19 to 2.22

[allade]

Dear community 
I migrated my dhis2.19 to 2.20 it was successful. But when I was doing the same process to 2.20 i had no result
Please can someone give me best practice to do this migration to 2.22
Best 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] Analytics period

[Halvdan Hoem Grelland]

18 hours seems very excessive. Did you do any performance tuning of
Postgres? You could have a look at section 8.3.6 here


On Tue, May 31, 2016 at 6:47 AM, Hannan Khan  wrote:

> Dear Abdul Karim
>
> This is quite unusual for this amount of data. We have several million
> tracked entity and took only half an hour for run analytics for last three
> years.
>
> Can you please check your postgres tuning parameter, server tuning
> parameters and get back to me.
>
> Regards
>
> Hannan Khan
>
> On Tue, May 31, 2016 at 10:05 AM, Abdul karim Jaafar <
> abdulkarim.jaafa...@gmail.com> wrote:
>
>> Hi Lars,
>>
>>
>>
>> I have 337460 value in data value, 692719 in ‘tracked entity attribute
>> value’ and 994129 in ‘tracked entity data value’
>>
>>
>>
>> also these inputs are increasing daily,
>>
>>
>>
>> I have upgraded PostgreSQL to 9.5 but analytic still take much time
>>
>>
>>
>> now it take about 19 hour!
>>
>>
>>
>> I use DHIS2 Version: 2.22
>>
>>
>>
>> Build revision:22057
>>
>> Java version:1.8.0_92
>>
>>
>>
>> Time since last analytics table generation:
>>
>> 34 h, 32 m, 5 s
>>
>> Last analytics table runtime:
>>
>> 18 h, 44 m, 55 s
>>
>>
>>
>> Best regards,
>>
>>
>>
>>
>>
>>
>>
>> *From:* Lars Helge Øverland [mailto:l...@dhis2.org]
>> *Sent:* Tuesday, May 31, 2016 4:19 AM
>> *To:* Abdul karim Jaafar 
>> *Cc:* DHIS 2 Users list 
>> *Subject:* Re: [Dhis2-users] Analytics period
>>
>>
>>
>> Hi Abdul,
>>
>>
>>
>> okay. Can you let us know a bit more info here, such as:
>>
>>
>>
>> - how many data values do you have in your database
>>
>> - how long does analytics take to complete
>>
>> - tomcat log output from the process
>>
>>
>>
>> Upgrading to PostgreSQL 9.5 will make the process significantly faster
>> compared to 9.3.
>>
>>
>>
>> regards,
>>
>>
>>
>> Lars
>>
>>
>>
>>
>>
>> On Mon, May 30, 2016 at 10:56 PM, Abdul karim Jaafar <
>> abdulkarim.jaafa...@gmail.com> wrote:
>>
>> Dears all,
>>
>>
>>
>> I have a problem with analytics period, It take too much time to finish,
>> I did ‘Maintenance’ from ‘Data Administration’ and fixed all problems in
>> ‘Data Integrity’
>>
>>
>>
>> Sometime when I change tomcat version, analytic goes better.
>>
>>
>>
>> I want to know what things that make analytic take much time, and how to
>> make it faster
>>
>>
>>
>> I have server, OS Windows 64 bit, ram 32 GB, hard 2 TB
>>
>>
>>
>> Best regards,
>>
>> Abdul Karim,
>>
>>
>> ___
>> 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 Helge Øverland
>>
>> Lead developer, DHIS 2
>>
>> University of Oslo
>>
>> Skype: larshelgeoverland
>>
>> l...@dhis2.org
>>
>> http://www.dhis2.org 
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Muhammad Abdul Hannan Khan
> Secretary
> HISP Bangladesh
>
> T +880-2- 8816459, 8816412 ext 118
> F +88 02 8813 875
> M+88 01819 239 241
> M+88 01534 312 066
> E hann...@gmail.com
> S hannan.khan.dhaka
> B hannan-tech.blogspot.com
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Halvdan Hoem Grelland
Software developer, DHIS 2
University of Oslo
http://www.dhis2.org 
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp