Re: [Dhis2-devs] [Dhis2-users] Upgrading from DHIS2.old version like 2.18 to 2.24

[gerald thomas]

Kamugunga,

https://mail.google.com/mail/u/0/h/120jm67l1ek8c/?&th=155df1acfeb87be2&d=u&n=e&v=c#m_15187aa80c4a1ee9

On 7/12/16, Knut Staring  wrote:
> No direct. Have to go step by step. I will forward an email with the
> details.
> Knut
> On 12 Jul 2016 4:02 p.m., "Kamugunga Adolphe"  wrote:
>
>> Dear community,
>>
>> Where can some one get old dhis2 war files  and upgrades notes especially
>> the .sql files released for updgrade  in case i want to upgrade step by
>> step from version to another till i reach the current to avoid jumping to
>> recent version.
>> Is direct jump to recent eg from 2.18 to 2.4  a best practices? if not
>> what should the best practices?
>>
>>
>> *Adolphe Kamugunga*
>> *MIS Technical Advisor*
>> Mobile: +250 788 740 578
>> Email:kaa...@gmail.com
>> Skype: ka.adolphe
>>
>>
>>
>> On 11 July 2016 at 18:43, Morina Matasi 
>> wrote:
>>
>>> Thanks Knut. I tried steps in that link with no joy. I was using
>>> standard
>>> reports in DHIS2.19. These reports are .jrxml files done in Jasper
>>> Reports.
>>> My JRXML report runs well in DHIS2.19 but stops running in DHIS2.20 or
>>> later. Am I the only one who faced this problem? Wasn't there an upgrade
>>> plan for JRXML reports.
>>>
>>>
>>>
>>> On Mon, Jul 11, 2016 at 3:02 PM, Knut Staring  wrote:
>>>
 Hello,

 I have no experience with running Jasper reports on JDK 8, but a quick
 googling showed up this:


 https://community.jaspersoft.com/questions/844403/how-run-jasperreports-java-8

 On Mon, Jul 11, 2016 at 2:20 PM, Morina Matasi <
 morena.motsi...@gmail.com> wrote:

> I need to upgrade my system from 2.19 to 2.24. I have first upgraded
> to
> 2.20 with Tomcat 8 and JDK 8. The system runs by the Jasper Reports
> won't.
> I get error:
>
> net.sf.jasperreports.engine.JRException: Errors were encountered when
> compiling report expressions class file:
> 1. The type java.lang.CharSequence cannot be resolved. It is indirectly
> referenced from required .class files
> value =
> ((java.lang.String)field_organisationunitname.getValue()).equals(((java.lang.String)field_param_organisationunit_name.getValue()))?
> //$JR_EXPR_ID=27$
>
> <>
>
> Did anyone had any issues with Jasper Reports running on JDK 8?
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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


-- 
Regards,

Gerald

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

[Dhis2-devs] Multiple DHIS2 instances on a Single Server

[gerald thomas]

Dear All,
We will be creating multiple instances on a single server with a single
public IP. I am inquiring how can this be done because i haven't done this
before.

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

Re: [Dhis2-devs] [Dhis2-users] Multiple DHIS2 instances on a Single Server

[gerald thomas]

Seth,
Thanks very much for your help. So it is on the ngnix that we define the
path of each instances?

Regards,
Gerald
On Jul 14, 2016 2:59 AM, "Seth Okeyo"  wrote:

> Hello Gerald.
> I have done that before,  you only need to set up different databases on
> postgresql  (Naming them differently) then creating dhis2 instances with
> the same names you used in the database., this is done by renaming the war
> file before exploding in tomcat.  Set the database connection in the .conf
> Files then environmental variables. You should be good to go.
> Regards
> Seth Okeyo
> Dndi Africa
>
>
> Envoyé à partir de mon Samsung.
>
>
> ---- Original message 
> From: gerald thomas
> Date:13/07/2016 12:31 PM (GMT+03:00)
> To: dhis2-users , dhis2-devs
> Subject: [Dhis2-users] Multiple DHIS2 instances on a Single Server
>
> Dear All,
> We will be creating multiple instances on a single server with a single
> public IP. I am inquiring how can this be done because i haven't done this
> before.
>
> Regards,
> Gerald
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Pivot Table Computation Error on 2.24

[gerald thomas]

Dear All,
After upgrading from 2.21 to 2.24 we noticed the following, when we
were pulling pivot table reports:
For Example if our:

Data Sets is HF1(Morbidity)
Periods is Monthly (the whole of 2015)
Organizations: Facility and then Chiefdom for Malema

and we are getting 100% which is not possible but when i revert to
2.21 the result is different. Please find the attached results from
2.24

Please i need help to solve this issue.





-- 
Regards,

Gerald


data.xls
Description: MS-Excel spreadsheet


data(1).xls
Description: MS-Excel spreadsheet
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Pivot table for reporting rate

[gerald thomas]

Hi all,
This is happening for version 2.23 and 2.24. We  reported this issue before
and we are still waiting for solution.

On Jul 23, 2016 07:23, "Prosper BT"  wrote:

> Dear Carlos,
>
> This usually happens when you have Orgunit in different Orgunits groups
> that belong to the same Orgunit group Set.
>
> For example You have a facility both in  Hospital and Clinic orgunit
> groups, then both Hospital and Clinic are part of one Orgunit group
> "Facility Type".
>
> Use the Data integrity check under "Data Administration" to find out which
> ones violate Orgunits group set.
>
> Organisation units violating exclusive group sets
> Regards
>
> On Wed, Jul 20, 2016 at 3:41 PM, Carlos Nyembwe  wrote:
>
>> Hi everyone,
>>
>> I have problem, these times I was making a reporting rate on pivot table
>> but, in reality we must have value under or equal to 100. In this picture,
>> same values are more that 100.
>>
>> What happened with DHIS2?
>>
>> [image: Inline image 1]
>> --
>> *Carlos Nyembwe*
>> *I'm just a Computer Scientist*
>>
>> *Skype: carloscnk1*
>> *Cell: (+243)813166381 <%28%2B243%29813166381>*
>> *Find me in: | Google Plus  | 
>> **Linkedin
>>  | Facebook
>>  | Twitter
>>  |*
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Global DHIS2 Implementation| HISP Uganda/University Of Oslo
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Upgrading DHIS2 from version 2.5 to 2.22

[gerald thomas]

Dear All,
I am inquiring for both technical guidance and materials to upgrade a
DHIS2 instance from version 2.5 to 2.22.

I will be grateful for any help anyone can render for me to
successfully achieve this task. Also, i will like to know where i can
get all the old war files.

-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

[gerald thomas]

Knut,
That is a very big jump and if it works, it will make my day.
As per your procedure, I should deploy the 2.16 war file on the newly
installed DHIS2 with empty database "hmis" and do metadata export of
everything from the old system which is running on 2.5 war file and finally
import to the new instance?
My question again Knut, what is the best method to do this export & import:
piecewise or everything; if it is piecewise what should I import first,
second,.. and last?

Thanks for your help

On Jul 26, 2016 15:40, "Knut Staring"  wrote:

> Hi Gerald,
> I would try to skip a few versions by exporting metadata and data and
> probably try to import to an intermediate version such as 2.13 or 2.16.
>
> On 26 Jul 2016 21:02, "gerald thomas"  wrote:
>
>> Dear All,
>> I am inquiring for both technical guidance and materials to upgrade a
>> DHIS2 instance from version 2.5 to 2.22.
>>
>> I will be grateful for any help anyone can render for me to
>> successfully achieve this task. Also, i will like to know where i can
>> get all the old war files.
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] NGINX ERROR-HELP

[gerald thomas]

Stanley,
it means cap header size.

You can increase it nginx.conf file normally located at /etc/nginx/nginx.conf

On 7/27/16, Stanley Kalyati  wrote:
> DHISiers,
>
> What does this error mean?
>
> Thank you
>
> 414 Request-URI Too Large
> --
> nginx
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

[gerald thomas]

Dear Knut,
Noted!!!
I noticed that upgrade procedures' starts from version 2.16 and the oldest
war file available is 2.7; which means I will have to work blindly till
2.16 by the grace of God.
HISP India, please can you help because I heard you had done something like
this before.

On Jul 27, 2016 12:31 PM, "Knut Staring"  wrote:

> Gi Gerald,
>
> Please do not take my suggestion as a fully formed and fool-proof
> procedure. But since you are exporting and then importing into an empty
> instance of a newer version, you will not be messing up your existing data
> (but should still take a backup first).
>
> Piecewise going through every version with the necessary database updates
> is the safest route and to always be recommended.
>
> However, this might be difficult in this case, and certainly very
> cumbersome. So I  suggest you give it a try. 2.16 was just a rough number,
> I am not sure it will work,  but this method can help you skip a few
> versions. However, you will have to test the results thoroughly, and
> probably will run into a few obstacles. So it is not a silver bullet,  I'm
> afraid.
>
> Knut
>
> On 27 Jul 2016 14:04, "gerald thomas"  wrote:
>
>> Knut,
>> That is a very big jump and if it works, it will make my day.
>> As per your procedure, I should deploy the 2.16 war file on the newly
>> installed DHIS2 with empty database "hmis" and do metadata export of
>> everything from the old system which is running on 2.5 war file and finally
>> import to the new instance?
>> My question again Knut, what is the best method to do this export &
>> import: piecewise or everything; if it is piecewise what should I import
>> first, second,.. and last?
>>
>> Thanks for your help
>>
>> On Jul 26, 2016 15:40, "Knut Staring"  wrote:
>>
>>> Hi Gerald,
>>> I would try to skip a few versions by exporting metadata and data and
>>> probably try to import to an intermediate version such as 2.13 or 2.16.
>>>
>>> On 26 Jul 2016 21:02, "gerald thomas"  wrote:
>>>
>>>> Dear All,
>>>> I am inquiring for both technical guidance and materials to upgrade a
>>>> DHIS2 instance from version 2.5 to 2.22.
>>>>
>>>> I will be grateful for any help anyone can render for me to
>>>> successfully achieve this task. Also, i will like to know where i can
>>>> get all the old war files.
>>>>
>>>> --
>>>> Regards,
>>>>
>>>> Gerald
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

[gerald thomas]

Thanks Knut, they are currently doing data entry till August 15. I will
start on the 16 or 17 and i will keep you informed.

On Jul 27, 2016 12:49 PM, "Knut Staring"  wrote:

> I suggest you try with 2.16 and let us know how it goes. If problematic,
> then try a few versions earlier.
> Knut
>
> On 27 Jul 2016 19:12, "gerald thomas"  wrote:
>
>> Dear Knut,
>> Noted!!!
>> I noticed that upgrade procedures' starts from version 2.16 and the
>> oldest war file available is 2.7; which means I will have to work blindly
>> till 2.16 by the grace of God.
>> HISP India, please can you help because I heard you had done something
>> like this before.
>>
>> On Jul 27, 2016 12:31 PM, "Knut Staring"  wrote:
>>
>>> Gi Gerald,
>>>
>>> Please do not take my suggestion as a fully formed and fool-proof
>>> procedure. But since you are exporting and then importing into an empty
>>> instance of a newer version, you will not be messing up your existing data
>>> (but should still take a backup first).
>>>
>>> Piecewise going through every version with the necessary database
>>> updates is the safest route and to always be recommended.
>>>
>>> However, this might be difficult in this case, and certainly very
>>> cumbersome. So I  suggest you give it a try. 2.16 was just a rough number,
>>> I am not sure it will work,  but this method can help you skip a few
>>> versions. However, you will have to test the results thoroughly, and
>>> probably will run into a few obstacles. So it is not a silver bullet,  I'm
>>> afraid.
>>>
>>> Knut
>>>
>>> On 27 Jul 2016 14:04, "gerald thomas"  wrote:
>>>
>>>> Knut,
>>>> That is a very big jump and if it works, it will make my day.
>>>> As per your procedure, I should deploy the 2.16 war file on the newly
>>>> installed DHIS2 with empty database "hmis" and do metadata export of
>>>> everything from the old system which is running on 2.5 war file and finally
>>>> import to the new instance?
>>>> My question again Knut, what is the best method to do this export &
>>>> import: piecewise or everything; if it is piecewise what should I import
>>>> first, second,.. and last?
>>>>
>>>> Thanks for your help
>>>>
>>>> On Jul 26, 2016 15:40, "Knut Staring"  wrote:
>>>>
>>>>> Hi Gerald,
>>>>> I would try to skip a few versions by exporting metadata and data and
>>>>> probably try to import to an intermediate version such as 2.13 or 2.16.
>>>>>
>>>>> On 26 Jul 2016 21:02, "gerald thomas"  wrote:
>>>>>
>>>>>> Dear All,
>>>>>> I am inquiring for both technical guidance and materials to upgrade a
>>>>>> DHIS2 instance from version 2.5 to 2.22.
>>>>>>
>>>>>> I will be grateful for any help anyone can render for me to
>>>>>> successfully achieve this task. Also, i will like to know where i can
>>>>>> get all the old war files.
>>>>>>
>>>>>> --
>>>>>> Regards,
>>>>>>
>>>>>> Gerald
>>>>>>
>>>>>> ___
>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>> Post to : dhis2-us...@lists.launchpad.net
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Merge and Deleting Facilities

[gerald thomas]

Dear All,
On previous DHIS2 version we were using merge for duplicate sites but
on version 2.22 i can't find merge. Please can someone help me?

Also, after merging i will like to remove the duplicate facility, what
are the procedures to remove or delete a facility.

Thanks in advance for your help

-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Merge and Deleting Facilities

[gerald thomas]

Dear Jason,
Thanks for your help and i will do a test on my laptop.

How can i delete these facilities after merging

On 7/29/16, Jason Pickering  wrote:
> Hi Gerald,
> This has been raised a few times on the list already. There were some
> serious flaws with that functionality, and it was removed and has yet to be
> put back in place.
>
> In the meantime, you can try this
>
> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/merge_orgunits.sql
>
> and call it directly from the database with
>
> SELECT * FROM merge_organisationunits('SOURCE', 'DESTINATION', 'STRATEGY');
>
> where
>
> SOURCE = the source orgunit UID
> DESTINATION = the destination orgunit UID
> STRATEGY= one of  SUM,MAX,MIN,AVG,LAST,FIRST
>
> each of those paramaters should be encased with single-quotes.
>
>
> It goes without saying, this should be thoroughly tested on your
> non-production system before attempting it on your production machine, as
> it is a destructive function (meaning things get permanently deleted).
>
> Regards,
> Jason
>
>
> On Fri, Jul 29, 2016 at 6:05 PM, gerald thomas 
> wrote:
>
>> Dear All,
>> On previous DHIS2 version we were using merge for duplicate sites but
>> on version 2.22 i can't find merge. Please can someone help me?
>>
>> Also, after merging i will like to remove the duplicate facility, what
>> are the procedures to remove or delete a facility.
>>
>> Thanks in advance for your help
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Data is not displayed in any report

[gerald thomas]

Chandrasekar,
Can you run analytics and generate reports again.

On Jul 30, 2016 8:28 AM, "Chandrasekar Ravi"  wrote:

> Dear Team
>
> We are successfully completed web tracker capture and mobile tracker
> capture.
>
> Data has been stored successfully. But we are facing the problem in data
> not showing in program summary report.
>
> Please any one make to fix this issue.
>
>
> *Thanks & Regards*
>
> *Chandrasekar Ravi*
> *Scientist - C, Data Manager*
> *9787214185*
> **
> *MAHA CDC Project*
> *National Institute of Epidemiology, ICMR*
>
> *127, Second Main Road, Tamil Nadu Housing BoardAyapakkam, Ambattur,
> Chennai – 77*
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Looking for Human Resource System to integrate with DHIS

[gerald thomas]

I had use ihris and it is good. If you want help with it I am willing to
help.

On Aug 26, 2016 6:46 PM, "Laura E. Lincks" 
wrote:

> We are looking for a simple Human Resources tool to integrate with a DHIS
> aggregate database. Little is known of the needs of the HRIS, but for now
> it needs to track personnel details and groups of personnel will need to be
> associated with various programs in a separate DHIS aggregate database. An
> Open Source HRIS is preferable.
>
> In searching for tools I have come across the following:
> HRHIS in Tanzania developed by the
> HISP-TZ/University of Dar es Salaam
> iHRIS  developed by global Capacity Project.​
>
> I was wondering if anyone had any knowledge of or experience with these
> packages or if there were other applications that could be of use to us?
>
> Thanks in advance to anyone with leads or information.
>
> *Laura E. Lincks*
> Database Manager/Developer
> ICAP - Columbia University
> Mailman School of Public Health
> 60 Haven Ave, Floor B1
> New York, NY 10032
> Tel: 212 304 7132
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Dashboard Error

[gerald thomas]

Dear All,
On my version 2.5, whenever i click "Dashboard" i am receiving an
error. Please find the attached error.

Kindly note that i am accessing all possibilities for a smooth upgrade
of war file version.

-- 
Regards,

Gerald
Title: DHIS 2




An exception occurred

Sorry! The system failed to execute the operation. Usually, no data 
is lost and you can continue working by going back to the previous page.
 If you wish to report the incident, please save this page by choosing 
"File -> Save (page as)" in your browser and include the saved page 
in the report. The problem details are listed below.


  
  [-]
Exception (org.hibernate.exception.SQLGrammarException):
  could not execute query
  
  

  org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.loader.Loader.doList(Loader.java:2536)
org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2319)
org.hibernate.loader.Loader.list(Loader.java:2268)
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
org.hisp.dhis.hibernate.HibernateGenericStore.getAll(HibernateGenericStore.java:259)
org.hisp.dhis.chart.impl.DefaultChartService.getAllCharts(DefaultChartService.java:1053)
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
com.sun.proxy.$Proxy61.getAllCharts(Unknown source)
org.hisp.dhis.dashboard.action.ProvideContentAction.execute(ProvideContentAction.java:132)
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
com.opensymph

Re: [Dhis2-devs] [Dhis2-users] Existing 2.23 event forms do not work in 2.24 (Only the reporting date field is visualized)

[gerald thomas]

Dear Pedro,
Did you read the upgrade notes: https://www.dhis2.org/223-upgrade.

There is an SQL upgrade script you need to run before moving to 2.24

On Sep 8, 2016 7:24 AM,  wrote:

> Hi,
>
> I upgraded to 2.24 by deploying the war file and using the existing DHIS2
> database.
>
> Best, Pedro
>
>
> > Pedro,
> > Can you be more specific, did you upgrade to 2.24 or are you running a
> new
> > instance on 2.24 but with the same forms??
> >
> > On Sep 8, 2016 7:16 AM,  wrote:
> >
> >> Good morning,
> >>
> >> We have a set of forms (Created by default from a set of programs
> without
> >> registration, i.e. events) working in DHIS 2.23 (Event capture).
> >>
> >> We installed DHIS 2.24 over the existing 2.23 database schema, but then
> >> none of
> >> the previous forms works. When we enter to any form, the screen only
> shows
> >> the
> >> field 'reporting date' and ignores the rest of fields and sections.
> >>
> >> What could be the problem?
> >>
> >> Best regards,
> >>
> >> Pedro González
> >> UPC-BarcelonaTech
> >>
> >>
> >> ___
> >> Mailing list: https://launchpad.net/~dhis2-users
> >> Post to : dhis2-us...@lists.launchpad.net
> >> Unsubscribe : https://launchpad.net/~dhis2-users
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >
>
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Existing 2.23 event forms do not work in 2.24 (Only the reporting date field is visualized)

[gerald thomas]

Yes Pedro, you are right. My question is did you ran that script when your
war file was 2.22? It seem like the issue is with the database; so please
share the various log files.

On Thursday, September 8, 2016,  wrote:

> Yes but up to my knowledge this is a upgrade note from 2.22 to 2.23 not
> from 2.23
> to 2.24. In fact the upgrade note of the 2.24 version does not mention
> nothing
> about the need of running any script.
>
> Best, Pedro
>
> > Dear Pedro,
> > Did you read the upgrade notes: https://www.dhis2.org/223-upgrade.
> >
> > There is an SQL upgrade script you need to run before moving to 2.24
> >
> > On Sep 8, 2016 7:24 AM, > wrote:
> >
> >> Hi,
> >>
> >> I upgraded to 2.24 by deploying the war file and using the existing
> DHIS2
> >> database.
> >>
> >> Best, Pedro
> >>
> >>
> >> > Pedro,
> >> > Can you be more specific, did you upgrade to 2.24 or are you running a
> >> new
> >> > instance on 2.24 but with the same forms??
> >> >
> >> > On Sep 8, 2016 7:16 AM, > wrote:
> >> >
> >> >> Good morning,
> >> >>
> >> >> We have a set of forms (Created by default from a set of programs
> >> without
> >> >> registration, i.e. events) working in DHIS 2.23 (Event capture).
> >> >>
> >> >> We installed DHIS 2.24 over the existing 2.23 database schema, but
> then
> >> >> none of
> >> >> the previous forms works. When we enter to any form, the screen only
> >> shows
> >> >> the
> >> >> field 'reporting date' and ignores the rest of fields and sections.
> >> >>
> >> >> What could be the problem?
> >> >>
> >> >> Best regards,
> >> >>
> >> >> Pedro González
> >> >> UPC-BarcelonaTech
> >> >>
> >> >>
> >> >> ___
> >> >> Mailing list: https://launchpad.net/~dhis2-users
> >> >> Post to : dhis2-us...@lists.launchpad.net 
> >> >> Unsubscribe : https://launchpad.net/~dhis2-users
> >> >> More help   : https://help.launchpad.net/ListHelp
> >> >>
> >> >
> >>
> >>
> >>
> >
>
>
>

-- 
Regards,

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

[Dhis2-devs] Creation of DHIS2 Team on Slack

[gerald thomas]

Dear All,
I will appreciate if we can create a DHIS2 Team on Slack. It is easier
and a much more faster response forum. It is a messenger also which
makes it instantaneous. Please DHIS2 users i will like to have your
opinion on this.
-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Looking for Human Resource System to integrate with DHIS

[gerald thomas]

Hi all,
In Sierra Leone we successfully deployed both applications and it was a
success but we had an intermediary connection which is the facility
register, which is this case helps us to synchronize the facility list
between both applications. Normally, iHRIS gives the full background
information of staff within each facilities which can be useful for
analysis during disease outbreak or even as part an indicator.
Furthermore, our iHRIS was empowered using mHERO, which is two-way SMS
connection between iHRIS and health workers. They could update their
profile in iHRIS or receive alter of outbreak or even medical instructions
from their leads.

On Oct 8, 2016 5:45 AM, "Bob Jolliffe"  wrote:

> Hi Arthur
>
> Carl will probably be able to point you to various cases where this
> has been done with dhis2 and ihris.  I am familiar with examples from
> Zanzibar, Kenya and Rwanda which sort of worked but none of which
> could fairly be described as successful in the sense of sustained use
> as far as I know.
>
> I think the main tricky bit to get right is the harmonization of
> health facilities in the two systems not just as one off, but with
> processes to keep them harmonized.  You might only have 20 indicators
> of interest but you have 1000s of facilities.  As soon as the orgunits
> start diverging the interoperability starts falling apart.  I think
> there was also some interesting work done in Bihar on this problem.
>
> One conventionasl "wisdom" that has done the rounds over the past few
> years is that a separate facility registry is the solution to this.  I
> am less sure.  In practice you now find that whereas before the
> problem was harmonizing between 2 systems, now it becomes more complex
> because you have 3 :-)  Add more with LMIS etc ..
>
> So 2 alternative approaches emerge:
> 1. retreat to dhis2 and try and do everything there - sometimes this
> sort of works for many things (which is better than most), but it has
> obvious limits and I don't believe can serve as the basis of long term
> strategy to solve all problems
> 2.  insist that any system that sends data to dhis2 treats dhis2 as
> the authoritative source of facility registry data.  If only they
> would :-)  Unfortunately dhis2 view of the
> physical/geographic/administrative world of the health system can
> diverge sometimes significantly from that of an HRIS system - think of
> MOH employees at offices not involved in health service delivery for
> example.  So there are local arrangements and understandings to be
> made, but in general I think this path holds the most potential,
>
> In practice I think we have to concede the problems have been unsolved
> for now.  Unless someone can point me otherwise.  The challenge seems
> on the surface to be technically fairly trivial,  But beneath lurk
> demons.
>
> Cheers
> Bob
>
> On 8 October 2016 at 07:13, Arthur Heywood 
> wrote:
> > Lungo
> > Good to hear from you ... long time no see
> > Thanks for this  can you tell me where we have a SUCCESSFUL
> > implementation where one can actually get IHRIS data through DHIS and
> make
> > integrated indicators, use IHRIS indicators for Bottleneck analysis etc
> >
> > Regards
> > Arthur
> >
> > **Without deviation from the norm, there can be no progress* *(Frank
> Zappa)
> > *Skype* arthur_heywood_za
> > Tanzania* +255-773669393 OR +255 673150252
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > On 5 October 2016 at 06:54, Juma Lungo  wrote:
> >>
> >> Hi Arthur,
> >>
> >> I would recommend iHRIS.
> >>
> >> It has many features, integrates nicely with DHIS2, implemented in many
> >> countries and it is being supported by an active community working
> closely
> >> with DHIS2 developers.
> >>
> >> Lungo
> >>
> >>
> >> 
> >> From: Calle Hedberg 
> >> To: Arthur Heywood 
> >> Cc: dhis2-users ; dhis2-devs
> >> ; gerald thomas  >;
> >> Seleman Ally 
> >> Sent: Tuesday, October 4, 2016 10:20 PM
> >> Subject: Re: [Dhis2-devs] [Dhis2-users] Looking for Human Resource
> System
> >> to integrate with DHIS
> >>
> >> Arthur,
> >>
> >> I'm not directly involved with the HRIS work using DHIS, my current
> focus
> >> is on a fully integrated disease surveillance system. Will find out and
> get
> >> back to you.
> >>
> >> Regards
> >> Calle
> >>
> >> On 4 October 2016 at 15:15, Arthur Heywood 
> >> wrote:
> >>
> >> C

Re: [Dhis2-devs] [Dhis2-users] Looking for Human Resource System to integrate with DHIS

[gerald thomas]

gt;>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 26 August 2016 at 23:08, Calle Hedberg 
>>>>>> wrote:
>>>>>>
>>>>>>> Laura,
>>>>>>>
>>>>>>> The two main HRIS component designs "within" DHIS2 are the HRHIS in
>>>>>>> Tanzania and another in Vietnam (John Lewis or Morten will be able to
>>>>>>> tell
>>>>>>> you more about that one).
>>>>>>>
>>>>>>> South Africa is currently using a customised Tracker app for
>>>>>>> managing
>>>>>>> Community Service and Internships (around 10,000 graduates are
>>>>>>> applying for
>>>>>>> internship or Community Service posts per annum).
>>>>>>>
>>>>>>> We are also working on a "core" workforce registry tightly
>>>>>>> integrated
>>>>>>> with DHIS2. By "core" I mean it will only deal with actual HR
>>>>>>> resources
>>>>>>> including position, what they are licensed/authorised to do, and
>>>>>>> contact
>>>>>>> details. Things like continuous education, bursaries, payroll, etc
>>>>>>> are
>>>>>>> processed/managed by other systems. A major advantage of tight
>>>>>>> integration
>>>>>>> will be the ability to use DHIS2 communication and messages + user
>>>>>>> registration to communicate directly with health workers - in
>>>>>>> particular
>>>>>>> since health workers increasingly will be interacting directly with
>>>>>>> DHIS2
>>>>>>> on a daily basis through (daily) capturing of routine data, disease
>>>>>>> notifications, various Tracker apps (browser or Android), etc.
>>>>>>>
>>>>>>> Your basic requirements seem very similar: your primary need is to
>>>>>>> track the workforce as an INPUT RESOURCE to health service delivery,
>>>>>>> and
>>>>>>> not to track salaries and CVs and health insurance and employment
>>>>>>> history
>>>>>>> and a bunch of other "personal" things. So you need to know WHO they
>>>>>>> are,
>>>>>>> where they actually work and with what (in what position), what they
>>>>>>> are
>>>>>>> able to do (mostly this relates to formal/legal practice licensing
>>>>>>> etc, but
>>>>>>> it could be expanded to include specialist knowledge about certain
>>>>>>> diseases
>>>>>>> etc), and how to contact them.
>>>>>>>
>>>>>>> Regards
>>>>>>> Calle
>>>>>>>
>>>>>>> On 26 August 2016 at 21:56, gerald thomas 
>>>>>>> wrote:
>>>>>>>
>>>>>>>> I had use ihris and it is good. If you want help with it I am
>>>>>>>> willing to help.
>>>>>>>>
>>>>>>>> On Aug 26, 2016 6:46 PM, "Laura E. Lincks" <
>>>>>>>> laura.lin...@icap.columbia.edu> wrote:
>>>>>>>>
>>>>>>>>> We are looking for a simple Human Resources tool to integrate with
>>>>>>>>> a DHIS aggregate database. Little is known of the needs of the
>>>>>>>>> HRIS, but
>>>>>>>>> for now it needs to track personnel details and groups of personnel
>>>>>>>>> will
>>>>>>>>> need to be associated with various programs in a separate DHIS
>>>>>>>>> aggregate
>>>>>>>>> database. An Open Source HRIS is preferable.
>>>>>>>>>
>>>>>>>>> In searching for tools I have come across the following:
>>>>>>>>> HRHIS <https://en.wikipedia.org/wiki/HRHIS>in Tanzania developed
>>>>>>>>> by the HISP-TZ/University of Dar es Salaam
>>>>>>>>> iHRIS <http://www.ihris.org/> developed by global Capacit

Re: [Dhis2-devs] [Dhis2-users] DHIS2.24 linking to a wrong database

[gerald thomas]

Absolom,
Kindly check the hibernate.properties or dhis.conf file again. It is
responsible to point DHIS2 to the right database.

On 10/27/16, Absolom MURAMIRA  wrote:
> Dear All,
> I am setting up DHIS2 to run on Ubuntu 16.04 server and PostgreSQL database
> but after setting up all the configuration settings in the dhis.conf and
> exporting the environmental variables in the tomcat-dhis instance, it still
> points to a different H2 database
> (dhis2;DB_CLOSE_DELAY=-1;MVCC=TRUE;ALIAS_COLUMN_NAME=TRUE;DB_CLOSE_ON_EXIT=FALSE)
> and a mysterious user (sa) database type DhisH2. This causes the system to
> loose all the data up on restart. This issue was raised by some one early
> this year but unfortunately i cannot find a solution. If anyone knows the
> solution, please support me.
> Thank you.
> Absolom
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] DHIS2-JIRA mini Getting Started doc

[gerald thomas]

Dear Lars,
How can someone have access to DHIS2-JIRA files or questions?

On Jan 2, 2017 7:18 AM, "Lars Helge Øverland"  wrote:

> Hi Sam,
>
> it seems this is not so easy and requires you to be a Jira administrator:
>
> https://confluence.atlassian.com/jira064/managing-groups-720412316.html
>
> We don't plan to grant admin rights at this point but let us know if you
> find a more clever way of achieving this ;)
>
> Lars
>
>
>
>
> On Mon, Jan 2, 2017 at 4:49 AM, Sam Johnson 
> wrote:
>
>> Hi Rachael/Devs,
>>
>>
>>
>> Am just following up on the query below – is it at all possible to enable
>> creation of private user groups within the DHIS2 Jira instance?
>>
>>
>>
>> Regards, Sam.
>>
>>
>>
>>
>>
>> *From: *Dhis2-devs > qebo.co...@lists.launchpad.net> on behalf of Sam Johnson <
>> samuel.john...@qebo.co.uk>
>> *Date: *Tuesday, 6 December 2016 at 00:52
>> *To: *Rachael Brooke , DHIS 2 Users list <
>> dhis2-us...@lists.launchpad.net>, DHIS2 Developers <
>> dhis2-devs@lists.launchpad.net>
>> *Cc: *Juan Manuel Alcantara Acosta , Rodolfo
>> Melia 
>> *Subject: *Re: [Dhis2-devs] [Dhis2-users] DHIS2-JIRA mini Getting
>> Started doc
>>
>>
>>
>> Hi Rachael,
>>
>>
>>
>> I just wanted to congratulate the team on successfully migrating to Jira
>> – it’s a great system, and will make feedback and collaboration around
>> DHIS2 even easier.  (I’ve just set up a custom Kanban dashboard for PSI to
>> monitor 2.25 bug-testing, which was very easy to do.)
>>
>>
>>
>> One quick request: would it be possible to enable ordinary users to set
>> up custom user groups?  In order for PSI team members to be able to see
>> this Kanban dashboard, I’ve had to open it up to ‘all logged-in users’,
>> whereas I’m guessing things will very quickly get very cluttered if
>> everyone can see everyone else’s dashboards…  Would it be possible for us
>> to set up custom user groups, so we can share our custom filters and
>> dashboards within a smaller set of users?
>>
>>
>>
>> Cheers, Sam.
>>
>>
>>
>>
>>
>> *From: *Dhis2-users > qebo.co...@lists.launchpad.net> on behalf of Rachael Brooke <
>> rach...@dhis2.org>
>> *Date: *Monday, 28 November 2016 at 12:05
>> *To: *DHIS 2 Users list , DHIS2
>> Developers 
>> *Subject: *[Dhis2-users] DHIS2-JIRA mini Getting Started doc
>>
>>
>>
>> Dear all,
>>
>>
>>
>> As announced previously, we've shifted over to JIRA
>>  for issue tracking.
>>
>>
>>
>> Here's a mini JIRA guide we've compiled for you: Using DHIS2-JIRA for
>> issue tracking
>> 
>> .
>>
>>
>>
>> Best regards,
>>
>> DHIS2 content team 
>>
>>
>>
>> *rach...@dhis2.org *
>>
>> *ceci...@dhis2.org *
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> 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-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Dear All,
We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
9.5.5) and it had been successfully done but the Postgres does not
automatically start after boot-up. I am using: (pg_ctlcluster 9.5 main
start) to start my database but i want it start automatically.

Please can someone help me?

-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

There were some issues with the migration so I had to purge the 9.3 and do
a fresh installation of 9.5 and restore my backup. But if the server reboot
I will have to manually do:
pg_ctlcluster 9.5 main start





On Jan 26, 2017 5:59 AM, "Uwe Wahser"  wrote:

Hi Gerald,

we did the upgrade while upgrading to Ubuntu 16.04 and everything starts
normally. But you have to manually migrate your 9.3 databases into the 9.5
format - did you do that?

These were the bash commands I recorded back then (at your own risk, no
guarantee - do backups and all that first)

~/tomcat-dhis/bin/shutdown.sh
sudo pg_dropcluster 9.5 main --stop
sudo pg_upgradecluster 9.3 main
pg_lsclusters
sudo pg_dropcluster 9.3 main

Hope that helps,

Uwe

---

> gerald thomas  hat am 26. Januar 2017 um 01:38
geschrieben:
>
>
> Dear All,
> We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
> 9.5.5) and it had been successfully done but the Postgres does not
> automatically start after boot-up. I am using: (pg_ctlcluster 9.5 main
> start) to start my database but i want it start automatically.
>
> Please can someone help me?
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

I already tried that and restart server but the issue is the same.

On Jan 26, 2017 7:27 AM, "J. Paul Mutali"  wrote:

> Hi Gerald,
>
>  you can use this command: sudo update-rc.d postgresql enable
>
> Hope it will work for you.
>
> ---
>
> JP Mutali
>
> Kigali - Rwanda
>
> On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas 
> wrote:
>
>> There were some issues with the migration so I had to purge the 9.3 and
>> do a fresh installation of 9.5 and restore my backup. But if the server
>> reboot I will have to manually do:
>> pg_ctlcluster 9.5 main start
>>
>>
>>
>>
>>
>> On Jan 26, 2017 5:59 AM, "Uwe Wahser"  wrote:
>>
>> Hi Gerald,
>>
>> we did the upgrade while upgrading to Ubuntu 16.04 and everything starts
>> normally. But you have to manually migrate your 9.3 databases into the 9.5
>> format - did you do that?
>>
>> These were the bash commands I recorded back then (at your own risk, no
>> guarantee - do backups and all that first)
>>
>> ~/tomcat-dhis/bin/shutdown.sh
>> sudo pg_dropcluster 9.5 main --stop
>> sudo pg_upgradecluster 9.3 main
>> pg_lsclusters
>> sudo pg_dropcluster 9.3 main
>>
>> Hope that helps,
>>
>> Uwe
>>
>> ---
>>
>> > gerald thomas  hat am 26. Januar 2017 um 01:38
>> geschrieben:
>> >
>> >
>> > Dear All,
>> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
>> > 9.5.5) and it had been successfully done but the Postgres does not
>> > automatically start after boot-up. I am using: (pg_ctlcluster 9.5 main
>> > start) to start my database but i want it start automatically.
>> >
>> > Please can someone help me?
>> >
>> > --
>> > Regards,
>> >
>> > Gerald
>> >
>> > ___
>> > Mailing list: https://launchpad.net/~dhis2-users
>> > Post to : dhis2-us...@lists.launchpad.net
>> > Unsubscribe : https://launchpad.net/~dhis2-users
>> > More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Mutali,
I think there was an issue where i have postgresql and postgresql-9.5
inside /etc/init.d. But when this command: sudo update-rc.d
postgresql-9.5 enable

I am getting this message "update-rc.d: warning:
/etc/init.d/postgresql-9.5 missing LSB information"
>

On 1/26/17, J. Paul Mutali  wrote:
> Hi Gerald,
>
>  you can use this command: sudo update-rc.d postgresql enable
>
> Hope it will work for you.
>
> ---
>
> JP Mutali
>
> Kigali - Rwanda
>
> On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas 
> wrote:
>
>> There were some issues with the migration so I had to purge the 9.3 and
>> do
>> a fresh installation of 9.5 and restore my backup. But if the server
>> reboot
>> I will have to manually do:
>> pg_ctlcluster 9.5 main start
>>
>>
>>
>>
>>
>> On Jan 26, 2017 5:59 AM, "Uwe Wahser"  wrote:
>>
>> Hi Gerald,
>>
>> we did the upgrade while upgrading to Ubuntu 16.04 and everything starts
>> normally. But you have to manually migrate your 9.3 databases into the
>> 9.5
>> format - did you do that?
>>
>> These were the bash commands I recorded back then (at your own risk, no
>> guarantee - do backups and all that first)
>>
>> ~/tomcat-dhis/bin/shutdown.sh
>> sudo pg_dropcluster 9.5 main --stop
>> sudo pg_upgradecluster 9.3 main
>> pg_lsclusters
>> sudo pg_dropcluster 9.3 main
>>
>> Hope that helps,
>>
>> Uwe
>>
>> ---
>>
>> > gerald thomas  hat am 26. Januar 2017 um 01:38
>> geschrieben:
>> >
>> >
>> > Dear All,
>> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
>> > 9.5.5) and it had been successfully done but the Postgres does not
>> > automatically start after boot-up. I am using: (pg_ctlcluster 9.5 main
>> > start) to start my database but i want it start automatically.
>> >
>> > Please can someone help me?
>> >
>> > --
>> > Regards,
>> >
>> > Gerald
>> >
>> > ___
>> > Mailing list: https://launchpad.net/~dhis2-users
>> > Post to : dhis2-us...@lists.launchpad.net
>> > Unsubscribe : https://launchpad.net/~dhis2-users
>> > More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Bob,
Thanks it is works


On 1/26/17, Bob Jolliffe  wrote:
> Gerald it sounds like it has got into a bit of a mess and maybe you risk
> just making it worse.  It is really not supposed to be this hard, but tit
> is next to impossible at a distance to figure out what might have gone
> wrong.
>
> Given that you are not dependent on migrating the cluster, but that you are
> simply going to restore your dbs, I would advise that you just try and get
> rid of the current non-working postgres installation completely and install
> it again.
>
> sudo apt-get purge postgresql ... etc  (check under /etc and /var/lib that
> all traces have truly gone)
>
> On 26 January 2017 at 08:42, gerald thomas  wrote:
>
>> Mutali,
>> I think there was an issue where i have postgresql and postgresql-9.5
>> inside /etc/init.d. But when this command: sudo update-rc.d
>> postgresql-9.5 enable
>>
>> I am getting this message "update-rc.d: warning:
>> /etc/init.d/postgresql-9.5 missing LSB information"
>> >
>>
>> On 1/26/17, J. Paul Mutali  wrote:
>> > Hi Gerald,
>> >
>> >  you can use this command: sudo update-rc.d postgresql enable
>> >
>> > Hope it will work for you.
>> >
>> > ---
>> >
>> > JP Mutali
>> >
>> > Kigali - Rwanda
>> >
>> > On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas 
>> > wrote:
>> >
>> >> There were some issues with the migration so I had to purge the 9.3
>> >> and
>> >> do
>> >> a fresh installation of 9.5 and restore my backup. But if the server
>> >> reboot
>> >> I will have to manually do:
>> >> pg_ctlcluster 9.5 main start
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> On Jan 26, 2017 5:59 AM, "Uwe Wahser"  wrote:
>> >>
>> >> Hi Gerald,
>> >>
>> >> we did the upgrade while upgrading to Ubuntu 16.04 and everything
>> >> starts
>> >> normally. But you have to manually migrate your 9.3 databases into the
>> >> 9.5
>> >> format - did you do that?
>> >>
>> >> These were the bash commands I recorded back then (at your own risk,
>> >> no
>> >> guarantee - do backups and all that first)
>> >>
>> >> ~/tomcat-dhis/bin/shutdown.sh
>> >> sudo pg_dropcluster 9.5 main --stop
>> >> sudo pg_upgradecluster 9.3 main
>> >> pg_lsclusters
>> >> sudo pg_dropcluster 9.3 main
>> >>
>> >> Hope that helps,
>> >>
>> >> Uwe
>> >>
>> >> ---
>> >>
>> >> > gerald thomas  hat am 26. Januar 2017 um
>> >> > 01:38
>> >> geschrieben:
>> >> >
>> >> >
>> >> > Dear All,
>> >> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
>> >> > 9.5.5) and it had been successfully done but the Postgres does not
>> >> > automatically start after boot-up. I am using: (pg_ctlcluster 9.5
>> >> > main
>> >> > start) to start my database but i want it start automatically.
>> >> >
>> >> > Please can someone help me?
>> >> >
>> >> > --
>> >> > Regards,
>> >> >
>> >> > Gerald
>> >> >
>> >> > ___
>> >> > Mailing list: https://launchpad.net/~dhis2-users
>> >> > Post to : dhis2-us...@lists.launchpad.net
>> >> > Unsubscribe : https://launchpad.net/~dhis2-users
>> >> > More help   : https://help.launchpad.net/ListHelp
>> >>
>> >>
>> >>
>> >>
>> >> ___
>> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> Post to : dhis2-devs@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Yes Bob,
But i now i am having a major issue because i can't find the
dhis2-startup, dhis2-stop or dhis2-status but the profile of the
instance is available.



On 1/26/17, Bob Jolliffe  wrote:
> what works?  you removed it and started again?
>
> On 26 January 2017 at 10:14, gerald thomas  wrote:
>
>> Bob,
>> Thanks it is works
>>
>>
>> On 1/26/17, Bob Jolliffe  wrote:
>> > Gerald it sounds like it has got into a bit of a mess and maybe you
>> > risk
>> > just making it worse.  It is really not supposed to be this hard, but
>> > tit
>> > is next to impossible at a distance to figure out what might have gone
>> > wrong.
>> >
>> > Given that you are not dependent on migrating the cluster, but that you
>> are
>> > simply going to restore your dbs, I would advise that you just try and
>> get
>> > rid of the current non-working postgres installation completely and
>> install
>> > it again.
>> >
>> > sudo apt-get purge postgresql ... etc  (check under /etc and /var/lib
>> that
>> > all traces have truly gone)
>> >
>> > On 26 January 2017 at 08:42, gerald thomas 
>> wrote:
>> >
>> >> Mutali,
>> >> I think there was an issue where i have postgresql and postgresql-9.5
>> >> inside /etc/init.d. But when this command: sudo update-rc.d
>> >> postgresql-9.5 enable
>> >>
>> >> I am getting this message "update-rc.d: warning:
>> >> /etc/init.d/postgresql-9.5 missing LSB information"
>> >> >
>> >>
>> >> On 1/26/17, J. Paul Mutali  wrote:
>> >> > Hi Gerald,
>> >> >
>> >> >  you can use this command: sudo update-rc.d postgresql enable
>> >> >
>> >> > Hope it will work for you.
>> >> >
>> >> > ---
>> >> >
>> >> > JP Mutali
>> >> >
>> >> > Kigali - Rwanda
>> >> >
>> >> > On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas
>> >> > > >
>> >> > wrote:
>> >> >
>> >> >> There were some issues with the migration so I had to purge the 9.3
>> >> >> and
>> >> >> do
>> >> >> a fresh installation of 9.5 and restore my backup. But if the
>> >> >> server
>> >> >> reboot
>> >> >> I will have to manually do:
>> >> >> pg_ctlcluster 9.5 main start
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> On Jan 26, 2017 5:59 AM, "Uwe Wahser"  wrote:
>> >> >>
>> >> >> Hi Gerald,
>> >> >>
>> >> >> we did the upgrade while upgrading to Ubuntu 16.04 and everything
>> >> >> starts
>> >> >> normally. But you have to manually migrate your 9.3 databases into
>> the
>> >> >> 9.5
>> >> >> format - did you do that?
>> >> >>
>> >> >> These were the bash commands I recorded back then (at your own
>> >> >> risk,
>> >> >> no
>> >> >> guarantee - do backups and all that first)
>> >> >>
>> >> >> ~/tomcat-dhis/bin/shutdown.sh
>> >> >> sudo pg_dropcluster 9.5 main --stop
>> >> >> sudo pg_upgradecluster 9.3 main
>> >> >> pg_lsclusters
>> >> >> sudo pg_dropcluster 9.3 main
>> >> >>
>> >> >> Hope that helps,
>> >> >>
>> >> >> Uwe
>> >> >>
>> >> >> ---
>> >> >>
>> >> >> > gerald thomas  hat am 26. Januar 2017 um
>> >> >> > 01:38
>> >> >> geschrieben:
>> >> >> >
>> >> >> >
>> >> >> > Dear All,
>> >> >> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
>> >> >> > 9.5.5) and it had been successfully done but the Postgres does
>> >> >> > not
>> >> >> > automatically start after boot-up. I am using: (pg_ctlcluster 9.5
>> >> >> > main
>> >> >> > start) to start my database but i want it start automatically.
>> >> >> >
>> >> >> > Please can someone help me?
>> >> >> >
>> >> >> > --
>> >> >> > Regards,
>> >> >> >
>> >> >> > Gerald
>> >> >> >
>> >> >> > ___
>> >> >> > Mailing list: https://launchpad.net/~dhis2-users
>> >> >> > Post to : dhis2-us...@lists.launchpad.net
>> >> >> > Unsubscribe : https://launchpad.net/~dhis2-users
>> >> >> > More help   : https://help.launchpad.net/ListHelp
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> ___
>> >> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> >> Post to : dhis2-devs@lists.launchpad.net
>> >> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> >> More help   : https://help.launchpad.net/ListHelp
>> >> >>
>> >> >>
>> >> >
>> >>
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >> ___
>> >> Mailing list: https://launchpad.net/~dhis2-users
>> >> Post to : dhis2-us...@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-users
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Thanks to everyone for your support and help during the process though
we are experience what looks to be like bugs but that will be save for
another ticket while we verify and test all the various scenarios
within 2.25.

Once again thanks.

On 1/26/17, Calle Hedberg  wrote:
> Hi
>
> Gerald managed to get it all up and working again this afternoon +
> restoring the dump file (onto 9.5.5). So all good now  :-)
>
> Analytics run time dropped from 56 minutes to 17 minutes, which is
> equivalent to the time it takes on my laptop, so the upgrade was overdue...
>
> Regards
> Calle
>
> On 26 January 2017 at 12:46, Bob Jolliffe  wrote:
>
>> Sounds like now you are really "waist deep in the big muddy".  You have
>> already had to scrap and reinstall your postgres and it looks like your
>> dhis2-tools package is also somehow missing or damaged.
>>
>> You have your backups.  scrap the machine and rebuild.  Follow
>> instruction
>> from https://github.com/dhis2/dhis2-tools.
>>
>> On 26 January 2017 at 10:30, gerald thomas  wrote:
>>
>>> Yes Bob,
>>> But i now i am having a major issue because i can't find the
>>> dhis2-startup, dhis2-stop or dhis2-status but the profile of the
>>> instance is available.
>>>
>>>
>>>
>>> On 1/26/17, Bob Jolliffe  wrote:
>>> > what works?  you removed it and started again?
>>> >
>>> > On 26 January 2017 at 10:14, gerald thomas 
>>> wrote:
>>> >
>>> >> Bob,
>>> >> Thanks it is works
>>> >>
>>> >>
>>> >> On 1/26/17, Bob Jolliffe  wrote:
>>> >> > Gerald it sounds like it has got into a bit of a mess and maybe you
>>> >> > risk
>>> >> > just making it worse.  It is really not supposed to be this hard,
>>> >> > but
>>> >> > tit
>>> >> > is next to impossible at a distance to figure out what might have
>>> gone
>>> >> > wrong.
>>> >> >
>>> >> > Given that you are not dependent on migrating the cluster, but that
>>> you
>>> >> are
>>> >> > simply going to restore your dbs, I would advise that you just try
>>> and
>>> >> get
>>> >> > rid of the current non-working postgres installation completely and
>>> >> install
>>> >> > it again.
>>> >> >
>>> >> > sudo apt-get purge postgresql ... etc  (check under /etc and
>>> >> > /var/lib
>>> >> that
>>> >> > all traces have truly gone)
>>> >> >
>>> >> > On 26 January 2017 at 08:42, gerald thomas 
>>> >> wrote:
>>> >> >
>>> >> >> Mutali,
>>> >> >> I think there was an issue where i have postgresql and
>>> postgresql-9.5
>>> >> >> inside /etc/init.d. But when this command: sudo update-rc.d
>>> >> >> postgresql-9.5 enable
>>> >> >>
>>> >> >> I am getting this message "update-rc.d: warning:
>>> >> >> /etc/init.d/postgresql-9.5 missing LSB information"
>>> >> >> >
>>> >> >>
>>> >> >> On 1/26/17, J. Paul Mutali  wrote:
>>> >> >> > Hi Gerald,
>>> >> >> >
>>> >> >> >  you can use this command: sudo update-rc.d postgresql enable
>>> >> >> >
>>> >> >> > Hope it will work for you.
>>> >> >> >
>>> >> >> > ---
>>> >> >> >
>>> >> >> > JP Mutali
>>> >> >> >
>>> >> >> > Kigali - Rwanda
>>> >> >> >
>>> >> >> > On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas
>>> >> >> > >> >> >
>>> >> >> > wrote:
>>> >> >> >
>>> >> >> >> There were some issues with the migration so I had to purge the
>>> 9.3
>>> >> >> >> and
>>> >> >> >> do
>>> >> >> >> a fresh installation of 9.5 and restore my backup. But if the
>>> >> >> >> server
>>> >> >> >> reboot
>>> >> >> >> I will have to manually do:
>>> >> >> 

[Dhis2-devs] Data Set Report is not Downloading

[gerald thomas]

Dear All,
We had successfully upgraded to version 2.25 but i noticed that we
can't download to excel or PDF our data set reports.

Please i don't know if it is a bug but it is working on the DHIS2 demo
but not on our production server.

Thanks in advance for your help.

-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Data Set Report is not Downloading

[gerald thomas]

Dear Elmarie,

I had done Data Integrity Checks but i don't know which option is
responsible for dataelements names with special characters. Besides we
had been doing data cleanup and we fixed most of those issues.

On 1/27/17, Elmarie Claasen  wrote:
> Gerald,
>
> We had the same problem so e toime back. Check that you dont have any
> special characters in dataelement names.
>
> Elmarie
>
> On 27 Jan 2017 14:29, "gerald thomas"  wrote:
>
>> Dear All,
>> We had successfully upgraded to version 2.25 but i noticed that we
>> can't download to excel or PDF our data set reports.
>>
>> Please i don't know if it is a bug but it is working on the DHIS2 demo
>> but not on our production server.
>>
>> Thanks in advance for your help.
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
> --
>
>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> <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.*
>


-- 
Regards,

Gerald

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

[Dhis2-devs] Tomcat error

[gerald thomas]

Dear All,

What is the meaning of this error:

* ERROR 2017-01-05 12:03:07,593 ERROR: duplicate key value violates
unique constraint "datavalue_pkey"
  Detail: Key (dataelementid, periodid, sourceid,
categoryoptioncomboid, attributeoptioncomboid)=(1973, 2784149, 301,
13, 13) already exists.

Please find the attached copy of catalina.out log file

-- 
Regards,

Gerald


Part of catalina.out
Description: Binary data
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

[gerald thomas]

Seid,
Thanks for your help but how can i identify those dataelements:

So I suggest you either to use the web API and import through the
import/export module or find out which of the metadata IDs is
duplicate and correct it.

On 1/28/17, Seid Hussein  wrote:
> Hi Gerald,
>
> I believe you're trying to import through the database rather than the API
> which is a better option because of you've duplicate there the most
> probable action ta update rather than a duplicate error.
>
> Most probably what happened is you have duplicate metadata. Each data value
> shall have a unique combination of data element id, period id, org unit id,
> category option combo id, and attribute option combo id.
>
> So I suggest you either to use the web API and import through the
> import/export module or find out which of the metadata IDs is duplicate and
> correct it.
>
> Regards,
>
>
> Seid,
>
> On Friday, January 27, 2017, gerald thomas  wrote:
>
>> Dear All,
>>
>> What is the meaning of this error:
>>
>> * ERROR 2017-01-05 12:03:07,593 ERROR: duplicate key value violates
>> unique constraint "datavalue_pkey"
>>   Detail: Key (dataelementid, periodid, sourceid,
>> categoryoptioncomboid, attributeoptioncomboid)=(1973, 2784149, 301,
>> 13, 13) already exists.
>>
>> Please find the attached copy of catalina.out log file
>>
>> --
>> Regards,
>>
>> Gerald
>>
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

[gerald thomas]

Funnily I Bob I only copied a section of the log, I have various
dataelements ids & period ids which are sending those errors.
So I am worried where are these errors coming from now.

On Jan 28, 2017 7:31 PM, "Bob Jolliffe"  wrote:

Gerald the clue is in your error message:

Detail: Key (dataelementid, periodid, sourceid,categoryoptioncomboid,
attributeoptioncomboid)=(1973, 2784149, 301,13, 13) already exists.

This usually means you have duplicates among the datavalues you are trying
to import.  ie. more than one row with the key values as shown in your
error message.

On 28 January 2017 at 19:02, gerald thomas  wrote:

> Seid,
> Thanks for your help but how can i identify those dataelements:
>
> So I suggest you either to use the web API and import through the
> import/export module or find out which of the metadata IDs is
> duplicate and correct it.
>
> On 1/28/17, Seid Hussein  wrote:
> > Hi Gerald,
> >
> > I believe you're trying to import through the database rather than the
> API
> > which is a better option because of you've duplicate there the most
> > probable action ta update rather than a duplicate error.
> >
> > Most probably what happened is you have duplicate metadata. Each data
> value
> > shall have a unique combination of data element id, period id, org unit
> id,
> > category option combo id, and attribute option combo id.
> >
> > So I suggest you either to use the web API and import through the
> > import/export module or find out which of the metadata IDs is duplicate
> and
> > correct it.
> >
> > Regards,
> >
> >
> > Seid,
> >
> > On Friday, January 27, 2017, gerald thomas 
> wrote:
> >
> >> Dear All,
> >>
> >> What is the meaning of this error:
> >>
> >> * ERROR 2017-01-05 12:03:07,593 ERROR: duplicate key value violates
> >> unique constraint "datavalue_pkey"
> >>   Detail: Key (dataelementid, periodid, sourceid,
> >> categoryoptioncomboid, attributeoptioncomboid)=(1973, 2784149, 301,
> >> 13, 13) already exists.
> >>
> >> Please find the attached copy of catalina.out log file
> >>
> >> --
> >> Regards,
> >>
> >> Gerald
> >>
> >
>
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

[gerald thomas]

Good morning all,

Bob, at some point Calle was importing metadata but i don't know if
that should be an issue. I am currently monitoring the logs to see if
i will receive those errors again.

On 1/28/17, Seid Hussein  wrote:
> Hi Gerald,
>
> You can use the (insert if not exists) query to insert your data. But
> unlike the COPY function which allows bulk insert, you have to write an
> insert statement for each data value you intend to insert.
>
> Regards,
>
>
> Seid,
>
> On Saturday, January 28, 2017, Bob Jolliffe  wrote:
>
>> where does the data come from that you try to import?
>>
>> On 28 January 2017 at 19:55, gerald thomas > > wrote:
>>
>>> Funnily I Bob I only copied a section of the log, I have various
>>> dataelements ids & period ids which are sending those errors.
>>> So I am worried where are these errors coming from now.
>>>
>>> On Jan 28, 2017 7:31 PM, "Bob Jolliffe" >> > wrote:
>>>
>>> Gerald the clue is in your error message:
>>>
>>> Detail: Key (dataelementid, periodid, sourceid,categoryoptioncomboid,
>>> attributeoptioncomboid)=(1973, 2784149, 301,13, 13) already exists.
>>>
>>> This usually means you have duplicates among the datavalues you are
>>> trying to import.  ie. more than one row with the key values as shown in
>>> your error message.
>>>
>>> On 28 January 2017 at 19:02, gerald thomas >> > wrote:
>>>
>>>> Seid,
>>>> Thanks for your help but how can i identify those dataelements:
>>>>
>>>> So I suggest you either to use the web API and import through the
>>>> import/export module or find out which of the metadata IDs is
>>>> duplicate and correct it.
>>>>
>>>> On 1/28/17, Seid Hussein >>> > wrote:
>>>> > Hi Gerald,
>>>> >
>>>> > I believe you're trying to import through the database rather than
>>>> > the
>>>> API
>>>> > which is a better option because of you've duplicate there the most
>>>> > probable action ta update rather than a duplicate error.
>>>> >
>>>> > Most probably what happened is you have duplicate metadata. Each data
>>>> value
>>>> > shall have a unique combination of data element id, period id, org
>>>> unit id,
>>>> > category option combo id, and attribute option combo id.
>>>> >
>>>> > So I suggest you either to use the web API and import through the
>>>> > import/export module or find out which of the metadata IDs is
>>>> duplicate and
>>>> > correct it.
>>>> >
>>>> > Regards,
>>>> >
>>>> >
>>>> > Seid,
>>>> >
>>>> > On Friday, January 27, 2017, gerald thomas >>> > wrote:
>>>> >
>>>> >> Dear All,
>>>> >>
>>>> >> What is the meaning of this error:
>>>> >>
>>>> >> * ERROR 2017-01-05 12:03:07,593 ERROR: duplicate key value violates
>>>> >> unique constraint "datavalue_pkey"
>>>> >>   Detail: Key (dataelementid, periodid, sourceid,
>>>> >> categoryoptioncomboid, attributeoptioncomboid)=(1973, 2784149, 301,
>>>> >> 13, 13) already exists.
>>>> >>
>>>> >> Please find the attached copy of catalina.out log file
>>>> >>
>>>> >> --
>>>> >> Regards,
>>>> >>
>>>> >> Gerald
>>>> >>
>>>> >
>>>>
>>>>
>>>> --
>>>> Regards,
>>>>
>>>> Gerald
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> 
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>
>>>
>>>
>>
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

[gerald thomas]

Dear Calle
Noted!!!



On 1/30/17, Calle Hedberg  wrote:
> Gerald,
>
> Firstly, I've verified this morning that there are no duplicates in the
> datavalue table. I was 99.9% sure of that since the primary key was in
> place, but to verify I created an exact duplicate called "datavalue2" with
> the same primary key and copied all the records across.
>
> Secondly, those errors might be log errors linked to some of the clean-up
> work we did on Thursday/Friday. The errors were probably triggered by me
> trying to insert some few data values via ODBC and failing due to those
> duplicates (i.e. no records inserted). There's no reason to be concerned
> about those.
>
> So unless those log errors should re-appear for some reason, there is no
> problem.
>
> Regards
> Calle
>
> On 30 January 2017 at 12:25, Bob Jolliffe  wrote:
>
>> Morning Gerald.  No this error would have nothing to do with importing
>> metadata or metadata that was previously imported as far as I can think.
>>
>> It is purely about duplicate reporting of data.  Usually two identical
>> rows in the batch you are importing.  Which is why I ask where you got
>> this
>> data from that you imported?  If it was data exported from another dhis2
>> system you wouldn't normally see this.  But if is from somewhere else (a
>> spreadsheet, ihris, some other system) there might be, for example,
>> duplicate orgunits in the batch.
>>
>> On 30 January 2017 at 09:54, gerald thomas  wrote:
>>
>>> Good morning all,
>>>
>>> Bob, at some point Calle was importing metadata but i don't know if
>>> that should be an issue. I am currently monitoring the logs to see if
>>> i will receive those errors again.
>>>
>>> On 1/28/17, Seid Hussein  wrote:
>>> > Hi Gerald,
>>> >
>>> > You can use the (insert if not exists) query to insert your data. But
>>> > unlike the COPY function which allows bulk insert, you have to write
>>> > an
>>> > insert statement for each data value you intend to insert.
>>> >
>>> > Regards,
>>> >
>>> >
>>> > Seid,
>>> >
>>> > On Saturday, January 28, 2017, Bob Jolliffe 
>>> wrote:
>>> >
>>> >> where does the data come from that you try to import?
>>> >>
>>> >> On 28 January 2017 at 19:55, gerald thomas >> >> > wrote:
>>> >>
>>> >>> Funnily I Bob I only copied a section of the log, I have various
>>> >>> dataelements ids & period ids which are sending those errors.
>>> >>> So I am worried where are these errors coming from now.
>>> >>>
>>> >>> On Jan 28, 2017 7:31 PM, "Bob Jolliffe" >> >>> > wrote:
>>> >>>
>>> >>> Gerald the clue is in your error message:
>>> >>>
>>> >>> Detail: Key (dataelementid, periodid,
>>> >>> sourceid,categoryoptioncomboid,
>>> >>> attributeoptioncomboid)=(1973, 2784149, 301,13, 13) already exists.
>>> >>>
>>> >>> This usually means you have duplicates among the datavalues you are
>>> >>> trying to import.  ie. more than one row with the key values as
>>> >>> shown
>>> in
>>> >>> your error message.
>>> >>>
>>> >>> On 28 January 2017 at 19:02, gerald thomas >> >>> > wrote:
>>> >>>
>>> >>>> Seid,
>>> >>>> Thanks for your help but how can i identify those dataelements:
>>> >>>>
>>> >>>> So I suggest you either to use the web API and import through the
>>> >>>> import/export module or find out which of the metadata IDs is
>>> >>>> duplicate and correct it.
>>> >>>>
>>> >>>> On 1/28/17, Seid Hussein >> >>>> > wrote:
>>> >>>> > Hi Gerald,
>>> >>>> >
>>> >>>> > I believe you're trying to import through the database rather
>>> >>>> > than
>>> >>>> > the
>>> >>>> API
>>> >>>> > which is a better option because of you've duplicate there the
>>> >>>> > most
>>> >>>> > probable action ta update rather than a duplicate error.
>>> >

Re: [Dhis2-devs] Visualizer issue

[gerald thomas]

Dear All.
I am using version 2.25 war file, build revision 3de90a5.

On 2/7/17, gerald thomas  wrote:
> Dear all,
> On my local instance I am receiving an error. Please find the attached
> print screen of the error.
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Visualizer issue

[gerald thomas]

Dear all,
I can't really tell what was the issue but after running maintenance &
analytics then change war file to the latest 2.25 war file the issue
was fixed. Everything is OK now. I actually didn't have time to look
at the 'browser console' again because i am afraid of the duration the
analytics will take.

I will keep you posted once those verification exercises are done.

On 2/8/17, Knut Staring  wrote:
> Hello all, what could be the issue with this message in the browser
> console?
>
> Line Number 1, Column 1:  ANALYTICSTABLE_UPDATE:1:1
> XML Parsing Error: syntax error
> Location:
> http://10.100.1.100:8080/api/system/tasks/ANALYTICSTABLE_UPDATE?lastId=StL6eohelA8
>
>
> On Tue, Feb 7, 2017 at 5:59 PM, gerald thomas 
> wrote:
>
>> Dear all,
>> I am trying to see if i could fix the error by running 'analytics' but
>> during my monitoring process using (shift + ctrl + j) i notice
>> something strange. Please find the attached file showing the error.
>>
>> On 2/7/17, gerald thomas  wrote:
>> > Dear All.
>> > I am using version 2.25 war file, build revision 3de90a5.
>> >
>> > On 2/7/17, gerald thomas  wrote:
>> >> Dear all,
>> >> On my local instance I am receiving an error. Please find the attached
>> >> print screen of the error.
>> >>
>> >
>> >
>> > --
>> > Regards,
>> >
>> > Gerald
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] My DHIS2 Reports app not loading

[gerald thomas]

Timothy,
Please run maintenance and delete war file and name of folder which has the
name of your war file. Download a new war and tail -f /path/Catalina.out if
there is no error then everything should be fine.
Kindly note I am saying "/path/" because I don't the path of your logs.
Also tomcat must be stop before deleting war file and folder and "tail" the
logs before starting tomcat.
Wishing you the best.

On Feb 13, 2017 06:26, "timothy kiyemba"  wrote:

> Anybody with a solution to this problem?
> --
> From: Timothy Kiyemba 
> Sent: ‎12/‎02/‎2017 21:59
> To: dhis2-devs ; dhis2-users
> 
> Subject: My DHIS2 Reports app not loading
>
> Dear all
>
> Has any one faced this challenge before, my DHIS2 reports app is not
> loading. It just shows that its loading but it never completes. Could I
> have missed out a step somewhere? See image below;
>
> [image: Inline image 1]
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] My DHIS2 Reports app not loading

[gerald thomas]

Kamugunga,
If he had provided the logs then that should had been easy to confirm but
currently the information seem like a bug on the war file. So the best
option is to replace the war file and monitor the logs. If it is a tomcat
issue it will definitely show on the logs.

On Feb 13, 2017 08:14, "Kamugunga Adolphe"  wrote:

Dear Gerald,
This could be also related to your tomcat version, we had the similar issue
here in Rwanda with data visualizer, pivot and event report apps not
loading after upgrading to dhis 2.24. We have upgraded to our tomcat from
7.052  to  7.0.68 and it worked.

Please trace back Bob,Lars, and Jason discussion on the tomcat version for
the new dhis2 releases.

Regards.

*Adolphe Kamugunga*
*MIS Technical Advisor*
Mobile: +250 788 740 578 <+250%20788%20740%20578>
Email:kaa...@gmail.com
Skype: ka.adolphe
 RWANDA


On 13 February 2017 at 08:48, gerald thomas  wrote:

> Timothy,
> Please run maintenance and delete war file and name of folder which has
> the name of your war file. Download a new war and tail -f
> /path/Catalina.out if there is no error then everything should be fine.
> Kindly note I am saying "/path/" because I don't the path of your logs.
> Also tomcat must be stop before deleting war file and folder and "tail" the
> logs before starting tomcat.
> Wishing you the best.
>
> On Feb 13, 2017 06:26, "timothy kiyemba"  wrote:
>
>> Anybody with a solution to this problem?
>> --
>> From: Timothy Kiyemba 
>> Sent: ‎12/‎02/‎2017 21:59
>> To: dhis2-devs ; dhis2-users
>> 
>> Subject: My DHIS2 Reports app not loading
>>
>> Dear all
>>
>> Has any one faced this challenge before, my DHIS2 reports app is not
>> loading. It just shows that its loading but it never completes. Could I
>> have missed out a step somewhere? See image below;
>>
>> [image: Inline image 1]
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Pivot table report per Ages Distribution issue

[gerald thomas]

Dear All,
i have a monthly data set for hospitals by age distribution, when i
create a reporting rate summary for an organization unit which sends
report i am getting values (per age distribution) but when i generate
a pivot table for the same values i am getting no data


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Pivot table report per Ages Distribution issue

[gerald thomas]

I already tried that but it not working. Using the "Total" option I am
getting values. I want to know why the "Details" option is not returning
values.

On Feb 16, 2017 07:44, "Kamugunga Adolphe"  wrote:

> Hi Gerald,
> Clear you cache  then also check if your analytics run correctly and try
> to generate the pivot again selecting  'Details" option.
>
> Regards,
>
>
> *Adolphe Kamugunga*
> *MIS Technical Advisor*
> Mobile: +250 788 740 578 <+250%20788%20740%20578>
> Email:kaa...@gmail.com
> Skype: ka.adolphe
>  RWANDA
>
>
> On 16 February 2017 at 08:25, gerald thomas  wrote:
>
>> Dear All,
>> i have a monthly data set for hospitals by age distribution, when i
>> create a reporting rate summary for an organization unit which sends
>> report i am getting values (per age distribution) but when i generate
>> a pivot table for the same values i am getting no data
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] UNABLE TO INSTALL DHIS2 ON A LOCAL MACHINE

[gerald thomas]

Dear Stanley,
Please check whether DHIS2_HOME folder contains the hibernate.properties or
dhis.config file. Also, you need to check Catalina.out log file to see that
your war file was extracted properly.
Please give further information also about your system:
1. OS
2. Installation procedure
3. The version of war file
4. Tomcat logs

On Feb 22, 2017 9:17 AM, "Stanley Kalyati"  wrote:

> Dear Coalleagues,
>
> I am trying to install DHIS2 on a local machine,
>
> I have installed Tomcat 9.0 and installed Postgres 9.3 and followed the
> instructions strictly.
>
> However when i type localhost:8080/dhis i am getting the message
> below.Where am i getting it wrong?
>
> HTTP Status 404 - /dhis/
>
> *type* Status report
>
> *message* */dhis/*
>
> *description* *The requested resource is not available.*
> --
> Apache Tomcat/9.0.0.M1
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Aggregated Data Capture using Android app

[gerald thomas]

Dear All,
We want to capture our aggregated data (HF1 to HF8 forms) at CHC level
(partial electricity & network coverage) to an android device and
later synced all information to our cloud hosting instance. Please can
anyone help me with the procedures to achieve it. I will also like to
know the challenges colleagues face and their approach to tackle these
issues.

Thanks in advance for your help.
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Aggregated Data Capture using Android app

[gerald thomas]

Araz,
This is very new to me and i will like to know the best possible way
we should implement this project. Please if you can kindly share
everything with reference to similar project(s), i will be grateful.
Also i know there will be challenges with reference to android
devices, so i am kindly requesting that you should advice on the best
android tablet specification for this project.

On 2/27/17, Araz Abishov  wrote:
> Hi Gerald,
>
> Do you questions regarding android specifically or more about configuration
> part of the server?
>
> Best regards,
>
> —
> Araz Abishov,
> Android developer, DHIS 2
> University of Oslo
> https://www.dhis2.org/
>
> On February 27, 2017 at 3:15:27 PM, gerald thomas (gerald17...@gmail.com)
> wrote:
>
> Dear All,
> We want to capture our aggregated data (HF1 to HF8 forms) at CHC level
> (partial electricity & network coverage) to an android device and
> later synced all information to our cloud hosting instance. Please can
> anyone help me with the procedures to achieve it. I will also like to
> know the challenges colleagues face and their approach to tackle these
> issues.
>
> Thanks in advance for your help.
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help : https://help.launchpad.net/ListHelp
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Aggregated Data Capture using Android app

[gerald thomas]

Dear Araz & Colleagues,
Please i am really out of ideas; any help from OpCo who had done this
implementation before. Kindly remember that the key here is to do data
entry off-line using tablets and once they are on-line their tablets
should sync with the main server and all data are then uploaded.

Thanks in advance for your help.

On 2/27/17, Calle Hedberg  wrote:
> Araz,
>
> I've just assisted Gerald with getting into the "Data capture for DHIS2"
> app - the server is running 2.25 and we downloaded the latest app from
> Google store.
>
> What is really perplexing is that the app only shows ONE data set - the one
> called "Population estimates". Furthermore, the data elements under that
> data set are old elements that were removed over a month ago - and none of
> the current population data elements are showing.
>
> I cannot see any menu option for refreshing the database or anything like
> that - there is only "Aggregate Report" and then "Choose Organisation
> Unit".
>
> Is that app supported under 2.25?
>
> Regards
> Calle
>
> On 27 February 2017 at 17:27, gerald thomas  wrote:
>
>> Araz,
>> This is very new to me and i will like to know the best possible way
>> we should implement this project. Please if you can kindly share
>> everything with reference to similar project(s), i will be grateful.
>> Also i know there will be challenges with reference to android
>> devices, so i am kindly requesting that you should advice on the best
>> android tablet specification for this project.
>>
>> On 2/27/17, Araz Abishov  wrote:
>> > Hi Gerald,
>> >
>> > Do you questions regarding android specifically or more about
>> configuration
>> > part of the server?
>> >
>> > Best regards,
>> >
>> > —
>> > Araz Abishov,
>> > Android developer, DHIS 2
>> > University of Oslo
>> > https://www.dhis2.org/
>> >
>> > On February 27, 2017 at 3:15:27 PM, gerald thomas
>> > (gerald17...@gmail.com
>> )
>> > wrote:
>> >
>> > Dear All,
>> > We want to capture our aggregated data (HF1 to HF8 forms) at CHC level
>> > (partial electricity & network coverage) to an android device and
>> > later synced all information to our cloud hosting instance. Please can
>> > anyone help me with the procedures to achieve it. I will also like to
>> > know the challenges colleagues face and their approach to tackle these
>> > issues.
>> >
>> > Thanks in advance for your help.
>> > Regards,
>> >
>> > Gerald
>> >
>> > ___
>> > Mailing list: https://launchpad.net/~dhis2-users
>> > Post to : dhis2-us...@lists.launchpad.net
>> > Unsubscribe : https://launchpad.net/~dhis2-users
>> > More help : https://help.launchpad.net/ListHelp
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Aggregated Data Capture using Android app

[gerald thomas]

Dear Araz,
I do not know if it had been done before or not because i am not
having much feedback from my DHIS2 colleagues which means i rely
totally on you for this project to be successful.

We want to take Data Entry to chiefdom level and at this level we have
limited electricity and Internet connectivity. In that case we are
thinking of a tablet app that can store data offline and then
automatically sync those offline data into the central server when the
tablet is online.

My questions:
1. Do we have any extra technicalities
2. Can you give us hardware recommendation for this implementation


On 2/28/17, Araz Abishov  wrote:
> Hi,
>
> *@Calle, *
> In order to refresh metadata / data you either need to use pull-to-refresh
> gesture within “Aggregate Report” screen or just let android app to sync
> automatically (background service is invoked whenever device gets online).
> I will add refresh button in the next release, in order to make it more
> explicit (feel free to create an issue in jira).
>
> Aggregate data capture supports DHIS 2 starting from 2.23 and up to 2.26.
> If it fails to sync, there are changes or backports which could break API.
> If you notice this, please create a report in jira (including revision
> number of DHIS 2 instance).
>
> *@Gerald, *
> I guess a good place to start with android for DHIS 2 can be this document
> <https://docs.google.com/document/d/1FegyiHWcUTEulYMxJwDdbhWHcfnP7yuUZTbU4yGUh_8/edit>.
> Please, let us know if you have any specific questions.
>
> Best regards,
>
> —
> Araz Abishov,
> Android developer, DHIS 2
> University of Oslo
> https://www.dhis2.org/
>
> On February 28, 2017 at 8:44:52 AM, gerald thomas (gerald17...@gmail.com)
> wrote:
>
> Dear Araz & Colleagues,
> Please i am really out of ideas; any help from OpCo who had done this
> implementation before. Kindly remember that the key here is to do data
> entry off-line using tablets and once they are on-line their tablets
> should sync with the main server and all data are then uploaded.
>
> Thanks in advance for your help.
>
> On 2/27/17, Calle Hedberg  wrote:
>> Araz,
>>
>> I've just assisted Gerald with getting into the "Data capture for DHIS2"
>> app - the server is running 2.25 and we downloaded the latest app from
>> Google store.
>>
>> What is really perplexing is that the app only shows ONE data set - the
> one
>> called "Population estimates". Furthermore, the data elements under that
>> data set are old elements that were removed over a month ago - and none
> of
>> the current population data elements are showing.
>>
>> I cannot see any menu option for refreshing the database or anything like
>> that - there is only "Aggregate Report" and then "Choose Organisation
>> Unit".
>>
>> Is that app supported under 2.25?
>>
>> Regards
>> Calle
>>
>> On 27 February 2017 at 17:27, gerald thomas 
> wrote:
>>
>>> Araz,
>>> This is very new to me and i will like to know the best possible way
>>> we should implement this project. Please if you can kindly share
>>> everything with reference to similar project(s), i will be grateful.
>>> Also i know there will be challenges with reference to android
>>> devices, so i am kindly requesting that you should advice on the best
>>> android tablet specification for this project.
>>>
>>> On 2/27/17, Araz Abishov  wrote:
>>> > Hi Gerald,
>>> >
>>> > Do you questions regarding android specifically or more about
>>> configuration
>>> > part of the server?
>>> >
>>> > Best regards,
>>> >
>>> > —
>>> > Araz Abishov,
>>> > Android developer, DHIS 2
>>> > University of Oslo
>>> > https://www.dhis2.org/
>>> >
>>> > On February 27, 2017 at 3:15:27 PM, gerald thomas
>>> > (gerald17...@gmail.com
>>> )
>>> > wrote:
>>> >
>>> > Dear All,
>>> > We want to capture our aggregated data (HF1 to HF8 forms) at CHC level
>>> > (partial electricity & network coverage) to an android device and
>>> > later synced all information to our cloud hosting instance. Please can
>>> > anyone help me with the procedures to achieve it. I will also like to
>>> > know the challenges colleagues face and their approach to tackle these
>>> > issues.
>>> >
>>> > Thanks in advance for your help.
>>> > Regards,
>>> >
>>> > Gerald
>>> >
>>> 

Re: [Dhis2-devs] [Dhis2-users] Bug: visualizer not working in v2.25

[gerald thomas]

Priyanka,
Kindly delete war file and folder and download a new war file again.
Remember to shutdown instance before deleting the war file.

On Mar 23, 2017 9:38 AM, "Priyanka Bawa"  wrote:

Hi team
I am working on dhis2 v2.25 but it seems the data visualizer is not working.
Please see attached screenshot.

[image: Inline image 1]

Regards
Priyanka Bawa

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

Re: [Dhis2-devs] [Dhis2-users] Bug: visualizer not working in v2.25

[gerald thomas]

Prinyanka,
I am assuming all the others are working I.e data entry, pivot table, etc.
Run maintenance, after it had been completed; shutdown instance and delete
the war file and folder with repetitive instance name. Download a new war
file and monitor Catalina.out when the instance startup.

On Mar 23, 2017 09:53, "Priyanka Bawa"  wrote:

> Hi
> I already tried this way but no luck!
>
> Regards
> Priyanka Bawa
>
> On Thu, Mar 23, 2017 at 3:14 PM, gerald thomas 
> wrote:
>
>> Priyanka,
>> Kindly delete war file and folder and download a new war file again.
>> Remember to shutdown instance before deleting the war file.
>>
>> On Mar 23, 2017 9:38 AM, "Priyanka Bawa" 
>> wrote:
>>
>> Hi team
>> I am working on dhis2 v2.25 but it seems the data visualizer is not
>> working.
>> Please see attached screenshot.
>>
>> [image: Inline image 1]
>>
>> Regards
>> Priyanka Bawa
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Data Set Report is not Downloading to Excel

[gerald thomas]

Dear All,
I am having problems downloading Data Set report to excel or pdf. I am
using version 2.25. It is working on demo but not on my instance.
Please can someone help me with a fix.

-- 
Regards,

Gerald


HF1 - Morbidity.xls
Description: MS-Excel spreadsheet
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Data Set Report is not Downloading to Excel

[gerald thomas]

Dear all,
Please i need your your help it is urgent.

On 3/23/17, gerald thomas  wrote:
> Dear All,
> I am having problems downloading Data Set report to excel or pdf. I am
> using version 2.25. It is working on demo but not on my instance.
> Please can someone help me with a fix.
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Data Set Report is not Downloading to Excel

[gerald thomas]

Yes it is a customer form.

On Mar 24, 2017 13:25, "Dapo Adejumo"  wrote:

> Hi Gerald,
> Does this dataset use a custom form?
> ….
>
>
>
> *Dapo Adejumo*
>
> On 24 Mar 2017, at 13:57, gerald thomas  wrote:
>
> Dear all,
> Please i need your your help it is urgent.
>
> On 3/23/17, gerald thomas  wrote:
>
> Dear All,
> I am having problems downloading Data Set report to excel or pdf. I am
> using version 2.25. It is working on demo but not on my instance.
> Please can someone help me with a fix.
>
> --
> Regards,
>
> Gerald
>
>
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Data Set Report is not Downloading to Excel

[gerald thomas]

Dapo,
Thanks for the information. Just wish there will be another way out soon.

On 3/24/17, Dapo Adejumo  wrote:
> Hi Gerald,
> Unfortunately custom forms are not properly handled in dataset reports. A
> work around will be to  “print" the dataset report output to pdf using
> Chrome.
> ….
>
>
>
>
> Dapo Adejumo
>
>> On 24 Mar 2017, at 14:46, Mohamed Bangura  wrote:
>>
>> Dear Gerald,
>> Use mozilla firefox to extract the data.
>> Do Ctrl A,Ctrl C
>> Open your blank excel and do ctrl V.
>> Hope this helps.
>> On 3/24/17, gerald thomas  wrote:
>>> Dear all,
>>> Please i need your your help it is urgent.
>>>
>>> On 3/23/17, gerald thomas  wrote:
>>>> Dear All,
>>>> I am having problems downloading Data Set report to excel or pdf. I am
>>>> using version 2.25. It is working on demo but not on my instance.
>>>> Please can someone help me with a fix.
>>>>
>>>> --
>>>> Regards,
>>>>
>>>> Gerald
>>>>
>>>
>>>
>>> --
>>> Regards,
>>>
>>> Gerald
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Regards,

Gerald

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

[Dhis2-devs] Completeness above 100% and inconsistency in reporting rates

[gerald thomas]

Dear All,
We had been struggling with this issue along with other users and we
haven't received much to conclude it. Please any help to close the
subject? It is also on JIRA: https://jira.dhis2.org/browse/DHIS2-300.

Kindly note that when our instance is on 2.22 the reporting rate was
working fine. This issue occurs whenever we upgrade our system beyond
2.22.


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Data Set Report is not Downloading to Excel

[gerald thomas]

Dear Jason,
It is a custom form but there is no JavaScript on it.


On Mar 24, 2017 20:17, "Jason Pickering" 
wrote:

> Custom forms MAY work in dataset reports, but it depends. Are you getting
> any JavaScript errors in the dataset reports? Any server errors?
> Are you using any custom JavaScript in your forms?
>
> On Fri, Mar 24, 2017 at 9:56 AM, Dapo Adejumo  wrote:
>
>> Hi Gerald,
>> Unfortunately custom forms are not properly handled in dataset reports. A
>> work around will be to  “print" the dataset report output to pdf using
>> Chrome.
>> ….
>>
>>
>>
>> *Dapo Adejumo*
>>
>> On 24 Mar 2017, at 14:46, Mohamed Bangura  wrote:
>>
>> Dear Gerald,
>> Use mozilla firefox to extract the data.
>> Do Ctrl A,Ctrl C
>> Open your blank excel and do ctrl V.
>> Hope this helps.
>> On 3/24/17, gerald thomas  wrote:
>>
>> Dear all,
>> Please i need your your help it is urgent.
>>
>> On 3/23/17, gerald thomas  wrote:
>>
>> Dear All,
>> I am having problems downloading Data Set report to excel or pdf. I am
>> using version 2.25. It is working on demo but not on my instance.
>> Please can someone help me with a fix.
>>
>> --
>> Regards,
>>
>> Gerald
>>
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46%2076%20414%2070%2049>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Data Set Report is not Downloading to Excel

[gerald thomas]

Dear Jason,
I am receiving a parse error when I execute the report

On Mar 24, 2017 22:05, "Jason Pickering" 
wrote:

> Are there any errors in the browser console or the server when  you
> execute the report?
>
> On Fri, Mar 24, 2017, 18:02 gerald thomas  wrote:
>
>> Dear Jason,
>> It is a custom form but there is no JavaScript on it.
>>
>>
>> On Mar 24, 2017 20:17, "Jason Pickering" 
>> wrote:
>>
>> Custom forms MAY work in dataset reports, but it depends. Are you getting
>> any JavaScript errors in the dataset reports? Any server errors?
>> Are you using any custom JavaScript in your forms?
>>
>> On Fri, Mar 24, 2017 at 9:56 AM, Dapo Adejumo 
>> wrote:
>>
>> Hi Gerald,
>> Unfortunately custom forms are not properly handled in dataset reports. A
>> work around will be to  “print" the dataset report output to pdf using
>> Chrome.
>> ….
>>
>>
>>
>> *Dapo Adejumo*
>>
>> On 24 Mar 2017, at 14:46, Mohamed Bangura  wrote:
>>
>> Dear Gerald,
>> Use mozilla firefox to extract the data.
>> Do Ctrl A,Ctrl C
>> Open your blank excel and do ctrl V.
>> Hope this helps.
>> On 3/24/17, gerald thomas  wrote:
>>
>> Dear all,
>> Please i need your your help it is urgent.
>>
>> On 3/23/17, gerald thomas  wrote:
>>
>> Dear All,
>> I am having problems downloading Data Set report to excel or pdf. I am
>> using version 2.25. It is working on demo but not on my instance.
>> Please can someone help me with a fix.
>>
>> --
>> Regards,
>>
>> Gerald
>>
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>
>>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Data Set Report is not Downloading to Excel

[gerald thomas]

Dear Jason,
The only error found during the data set report process:

https://sl.dhis2.org/hmis/api/dataStatistics [HTTP/1.1 201 Created 184ms]
XML Parsing Error: no root element found
Location: 
https://sl.dhis2.org/hmis/api/dataStatistics?eventType=DATA_SET_REPORT_VIEW&favorite=UQGPrAQtDIV



On 3/24/17, Jason Pickering  wrote:
> Ok. Please post it.
>
> This error likely results from invalid HTML in your data set report form.
>
> On Fri, Mar 24, 2017, 18:10 gerald thomas  wrote:
>
>> Dear Jason,
>> I am receiving a parse error when I execute the report
>>
>> On Mar 24, 2017 22:05, "Jason Pickering" 
>> wrote:
>>
>> Are there any errors in the browser console or the server when  you
>> execute the report?
>>
>> On Fri, Mar 24, 2017, 18:02 gerald thomas  wrote:
>>
>> Dear Jason,
>> It is a custom form but there is no JavaScript on it.
>>
>>
>> On Mar 24, 2017 20:17, "Jason Pickering" 
>> wrote:
>>
>> Custom forms MAY work in dataset reports, but it depends. Are you getting
>> any JavaScript errors in the dataset reports? Any server errors?
>> Are you using any custom JavaScript in your forms?
>>
>> On Fri, Mar 24, 2017 at 9:56 AM, Dapo Adejumo 
>> wrote:
>>
>> Hi Gerald,
>> Unfortunately custom forms are not properly handled in dataset reports. A
>> work around will be to  “print" the dataset report output to pdf using
>> Chrome.
>> ….
>>
>>
>>
>> *Dapo Adejumo*
>>
>> On 24 Mar 2017, at 14:46, Mohamed Bangura  wrote:
>>
>> Dear Gerald,
>> Use mozilla firefox to extract the data.
>> Do Ctrl A,Ctrl C
>> Open your blank excel and do ctrl V.
>> Hope this helps.
>> On 3/24/17, gerald thomas  wrote:
>>
>> Dear all,
>> Please i need your your help it is urgent.
>>
>> On 3/23/17, gerald thomas  wrote:
>>
>> Dear All,
>> I am having problems downloading Data Set report to excel or pdf. I am
>> using version 2.25. It is working on demo but not on my instance.
>> Please can someone help me with a fix.
>>
>> --
>> Regards,
>>
>> Gerald
>>
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>
>>
>


-- 
Regards,

Gerald
POST 
XHR 
https://sl.dhis2.org/hmis/api/i18n [HTTP/1.1 200 OK 238ms]
GET 
XHR 
https://sl.dhis2.org/hmis/api/dimensions/dataSet/UQGPrAQtDIV.json [HTTP/1.1 409 
Conflict 435ms]
POST 
XHR 
https://sl.dhis2.org/hmis/dhis-web-commons/oust/setorgunit.action [HTTP/1.1 200 
OK 275ms]
GET 
XHR 
https://sl.dhis2.org/hmis/dhis-web-reporting/generateDataSetReport.action 
[HTTP/1.1 200 OK 1308ms]
POST 
XHR 
https://sl.dhis2.org/hmis/api/dataStatistics [HTTP/1.1 201 Created 184ms]
XML Parsing Error: no root element found
Location: 
https://sl.dhis2.org/hmis/api/dataStatistics?eventType=DATA_SET_REPORT_VIEW&favorite=UQGPrAQtDIV
Line Number 1, Column 1:  dataStatistics:1:1
GET 
XHR 
https://sl.dhis2.org/hmis/api/systemSettings [HTTP/1.1 200 OK 293ms]
GET 
XHR 
https://sl.dhis2.org/hmis/api/userSettings/keyStyle [HTTP/1.1 200 OK 348ms]
GET 
https://sl.dhis2.org/hmis/dhis-web-commons/css/themes/light_blue/light_blue.css 
[HTTP/1.1 200 OK 0ms]
GET 
https://sl.dhis2.org/hmis/dhis-web-reporting/generateDataSetReport.action 
[HTTP/1.1 200 OK 3177ms]___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Data Set Report is not Downloading to Excel

[gerald thomas]

Dear Jason,
Please find the attached error.

On 3/25/17, Jason Pickering  wrote:
> Hi Gerald,
> Check the server logs when  you make the API call below. There seems to be
> an error here.
>
> https://sl.dhis2.org/hmis/api/dimensions/dataSet/UQGPrAQtDIV.json [HTTP/1.1
> 409 Conflict 435ms]
>
> Regards,
> Jason
>
> On Sat, Mar 25, 2017, 05:01 gerald thomas  wrote:
>
>> Dear Jason,
>> The only error found during the data set report process:
>>
>> https://sl.dhis2.org/hmis/api/dataStatistics [HTTP/1.1 201 Created 184ms]
>> XML Parsing Error: no root element found
>> Location:
>> https://sl.dhis2.org/hmis/api/dataStatistics?eventType=DATA_SET_REPORT_VIEW&favorite=UQGPrAQtDIV
>>
>>
>>
>> On 3/24/17, Jason Pickering  wrote:
>> > Ok. Please post it.
>> >
>> > This error likely results from invalid HTML in your data set report
>> > form.
>> >
>> > On Fri, Mar 24, 2017, 18:10 gerald thomas 
>> > wrote:
>> >
>> >> Dear Jason,
>> >> I am receiving a parse error when I execute the report
>> >>
>> >> On Mar 24, 2017 22:05, "Jason Pickering" 
>> >> wrote:
>> >>
>> >> Are there any errors in the browser console or the server when  you
>> >> execute the report?
>> >>
>> >> On Fri, Mar 24, 2017, 18:02 gerald thomas 
>> wrote:
>> >>
>> >> Dear Jason,
>> >> It is a custom form but there is no JavaScript on it.
>> >>
>> >>
>> >> On Mar 24, 2017 20:17, "Jason Pickering" 
>> >> wrote:
>> >>
>> >> Custom forms MAY work in dataset reports, but it depends. Are you
>> getting
>> >> any JavaScript errors in the dataset reports? Any server errors?
>> >> Are you using any custom JavaScript in your forms?
>> >>
>> >> On Fri, Mar 24, 2017 at 9:56 AM, Dapo Adejumo 
>> >> wrote:
>> >>
>> >> Hi Gerald,
>> >> Unfortunately custom forms are not properly handled in dataset
>> >> reports.
>> A
>> >> work around will be to  “print" the dataset report output to pdf using
>> >> Chrome.
>> >> ….
>> >>
>> >>
>> >>
>> >> *Dapo Adejumo*
>> >>
>> >> On 24 Mar 2017, at 14:46, Mohamed Bangura  wrote:
>> >>
>> >> Dear Gerald,
>> >> Use mozilla firefox to extract the data.
>> >> Do Ctrl A,Ctrl C
>> >> Open your blank excel and do ctrl V.
>> >> Hope this helps.
>> >> On 3/24/17, gerald thomas  wrote:
>> >>
>> >> Dear all,
>> >> Please i need your your help it is urgent.
>> >>
>> >> On 3/23/17, gerald thomas  wrote:
>> >>
>> >> Dear All,
>> >> I am having problems downloading Data Set report to excel or pdf. I am
>> >> using version 2.25. It is working on demo but not on my instance.
>> >> Please can someone help me with a fix.
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >>
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >> ___
>> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> Post to : dhis2-devs@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >>
>> >> ___
>> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> Post to : dhis2-devs@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >>
>> >>
>> >> ___
>> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> Post to : dhis2-devs@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >> Jason P. Pickering
>> >> email: jason.p.picker...@gmail.com
>> >> tel:+46764147049 <+46%2076%20414%2070%2049>
>> >>
>> >>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>


-- 
Regards,

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

[Dhis2-devs] DHIS2 2.26 doesn't have the Score Card

[gerald thomas]

Dear All,
I had upgraded my DHIS2 instance to 2.26 as per upgrade note and my
build revision: a52916f but i can't find score card. Do i have to do
something before it becomes active?

-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] DHIS2 2.26 doesn't have the Score Card

[gerald thomas]

Dear Knut,
Thanks for your response. How can i add the App to my dhis2 instance?

On 4/22/17, Knut Staring  wrote:
> Hi Gerald,
> Scorecard is an external app which ypu have to add
>
> Knut
>
> On Apr 22, 2017 12:35 PM, "gerald thomas"  wrote:
>
>> Dear All,
>> I had upgraded my DHIS2 instance to 2.26 as per upgrade note and my
>> build revision: a52916f but i can't find score card. Do i have to do
>> something before it becomes active?
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] DHIS2 2.26 doesn't have the Score Card

[gerald thomas]

Thanks very much Wilfred

On 4/22/17, Wilfred Senyoni  wrote:
> Hello gerald
> You can find the scorecard apps here <http://appstore.hisptanzania.org/> at
> the HISP Tanzania Apps store and the documentation for installation of apps
> in DHIS2 here <https://www.dhis2.org/how-to-create-find-install-apps>
>
> Wilfred Senyoni
> Information Systems Researcher
> Skype: senyoni
> Mob: (+255) 0713595231/(+47) 46573133
>
> On Sat, Apr 22, 2017 at 2:07 PM, gerald thomas 
> wrote:
>
>> Dear Knut,
>> Thanks for your response. How can i add the App to my dhis2 instance?
>>
>> On 4/22/17, Knut Staring  wrote:
>> > Hi Gerald,
>> > Scorecard is an external app which ypu have to add
>> >
>> > Knut
>> >
>> > On Apr 22, 2017 12:35 PM, "gerald thomas" 
>> > wrote:
>> >
>> >> Dear All,
>> >> I had upgraded my DHIS2 instance to 2.26 as per upgrade note and my
>> >> build revision: a52916f but i can't find score card. Do i have to do
>> >> something before it becomes active?
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >> ___
>> >> Mailing list: https://launchpad.net/~dhis2-users
>> >> Post to : dhis2-us...@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-users
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>


-- 
Regards,

Gerald

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

[Dhis2-devs] Domain Name for SL Training Server

[gerald thomas]

Dear All,
I had setup a test server for Sierra Leone and i need a sub-domain
from dhis2.org (trainingsl.dhis2.org). Please what is the procedure to
get it.

-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Domain Name for SL Training Server

[gerald thomas]

Ok, thanks for the clarification but can I have a sub-domain of such.
Please send me your public key so that I can create your account on the
server. I think can now start with automatic verification of backups files
between the two instances.

On May 27, 2017 17:27, "Bob Jolliffe"  wrote:

> Hi Gerald
>
> There isn't really a "procedure" for this.  dhis2.org is a domain owned
> by the HISP project which we use for our servers.   Its not really
> something which is offered as a service.
>
> Regards
> Bob
>
> On 27 May 2017 at 16:30, gerald thomas  wrote:
>
>> Dear All,
>> I had setup a test server for Sierra Leone and i need a sub-domain
>> from dhis2.org (trainingsl.dhis2.org). Please what is the procedure to
>> get it.
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Analytics Error

[gerald thomas]

Dear Knut,
Please find the attached copy of the full process.

On May 28, 2017 14:49, "Knut Staring"  wrote:
>
> Dear Gerald,
>
> The picture you sent only shows the last 20 steps or so, and indicates that 
> they took only a second. Are you able to see which earlier steps took so much 
> longer?
>
> Knut
>
> On Sun, May 28, 2017 at 3:23 PM, gerald thomas  wrote:
>>
>> Dear all,
>> I finally got it to successfully run but it took almost 4 hours for it
>> to ran completely after tweaking the postgresql.conf file based on the
>> explanations on the implementation manual.
>>
>> Now, my question will be how can i reduce time for analytics giving
>> that my RAM is 7168 MB, 150 GB disk space.
>>
>> On 5/28/17, gerald thomas  wrote:
>> > Dear All,
>> > I created a test instance but analytics takes time to run and doesn't
>> > complete. The error below was found in the catalina.out file during
>> > analytics:
>> >
>> > Caused by: org.Postgresql.util.PSQLException: ERROR: relation
>> > "analytics_completenesstarget" does not exist
>> > Postion: 51
>> >
>> > Please find the screen print after analytics failed.
>> >
>> > --
>> > Regards,
>> >
>> > Gerald
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
2017-05-28 12:58:43 Analytics tables updated: 03:53:14.237  
2017-05-28 12:58:43 No events exist, not updating event analytics tables  
2017-05-28 12:58:43 Updating tables: ENROLLMENT  
2017-05-28 12:58:43 No events exist, not updating event analytics tables  
2017-05-28 12:58:43 Updating tables: EVENT  
2017-05-28 12:58:43 Table update done  
2017-05-28 12:58:43 Clearing caches  
2017-05-28 12:58:43 Creating SQL views  
2017-05-28 12:58:43 Swapping tables  
2017-05-28 12:58:43 Swapping analytics tables  
2017-05-28 12:58:43 Analyzing analytics tables  
2017-05-28 12:58:43 Creating indexes  
2017-05-28 12:58:43 Applying aggregation levels  
2017-05-28 12:58:42 Populating analytics tables  
2017-05-28 12:58:42 Creating analytics tables  
2017-05-28 12:58:42 Performing pre-create table work, org unit levels: 4  
2017-05-28 12:58:42 Updating tables: ORG_UNIT_TARGET  
2017-05-28 12:58:42 Table update done  
2017-05-28 12:58:42 Clearing caches  
2017-05-28 12:58:42 Creating SQL views  
2017-05-28 12:58:42 Swapping tables  
2017-05-28 12:58:42 Swapping analytics tables  
2017-05-28 12:58:42 Analyzing analytics tables  
2017-05-28 12:58:42 Creating indexes  
2017-05-28 12:58:42 Applying aggregation levels  
2017-05-28 12:58:41 Populating analytics tables  
2017-05-28 12:58:41 Creating analytics tables  
2017-05-28 12:58:41 Performing pre-create table work, org unit levels: 4  
2017-05-28 12:58:41 Updating tables: COMPLETENESS_TARGET  
2017-05-28 12:58:41 Table update done  
2017-05-28 12:58:41 Clearing caches  
2017-05-28 12:58:41 Creating SQL views  
2017-05-28 12:58:41 Swapping tables  
2017-05-28 12:58:41 Swapping analytics tables  
2017-05-28 12:58:35 Analyzing analytics tables  
2017-05-28 12:58:14 Creating indexes  
2017-05-28 12:58:14 Applying aggregation levels  
2017-05-28 12:58:09 Populating analytics tables  
2017-05-28 12:58:09 Creating analytics tables  
2017-05-28 12:58:09 Performing pre-create table work, org unit levels: 4  
2017-05-28 12:58:08 Updating tables: COMPLETENESS  
2017-05-28 12:58:08 Table update done  
2017-05-28 12:58:08 Clearing caches  
2017-05-28 12:58:07 Creating SQL views  
2017-05-28 12:58:04 Swapping tables  
2017-05-28 12:58:03 Swapping analytics tables  
2017-05-28 12:55:46 Analyzing analytics tables  
2017-05-28 12:11:30 Creating indexes  
2017-05-28 11:37:19 Applying aggregation levels  
2017-05-28 09:06:50 Populating analytics tables  
2017-05-28 09:06:49 Creating analytics tables  
2017-05-28 09:06:49 Performing pre-create table work, org unit levels: 4  
2017-05-28 09:05:56 Updating tables: DATA_VALUE  
2017-05-28 09:05:29 Updating resource tables  
2017-05-28 09:05:29 Analytics table update process started  ___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Error Message on Log

[gerald thomas]

Dear All,

I am having the following errors:

* ERROR 2017-05-29 00:46:10,458 Initialised statement manager
(StatementInterceptor.java [tomcat-http-191])
* ERROR 2017-05-29 00:46:15,648 Initialised statement manager
(StatementInterceptor.java [tomcat-http-191])
* ERROR 2017-05-29 00:46:42,437 Initialised statement manager
(StatementInterceptor.java [tomcat-http-187])
* ERROR 2017-05-29 00:46:47,430 Initialised statement manager
(StatementInterceptor.java [tomcat-http-152])

Any idea what is it means?

-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Error Message on Log

[gerald thomas]

Noted Lars!!!

Thanks

On 5/29/17, Lars Helge Øverland  wrote:
> Hi Gerald,
>
> this is normal and is an internal system log message related to database
> connections - nothing to worry about.
>
> regards,
>
> Lars
>
>
> On Mon, May 29, 2017 at 1:51 PM, gerald thomas 
> wrote:
>
>> Dear All,
>>
>> I am having the following errors:
>>
>> * ERROR 2017-05-29 00:46:10,458 Initialised statement manager
>> (StatementInterceptor.java [tomcat-http-191])
>> * ERROR 2017-05-29 00:46:15,648 Initialised statement manager
>> (StatementInterceptor.java [tomcat-http-191])
>> * ERROR 2017-05-29 00:46:42,437 Initialised statement manager
>> (StatementInterceptor.java [tomcat-http-187])
>> * ERROR 2017-05-29 00:46:47,430 Initialised statement manager
>> (StatementInterceptor.java [tomcat-http-152])
>>
>> Any idea what is it means?
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org <https://www.dhis2.org/>
>


-- 
Regards,

Gerald

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

[Dhis2-devs] Pivot Table Not Loading

[gerald thomas]

Dear All,
We updated our instance in Sierra Leone from 2.18 to 2.19 and finally
to 2.20. The job was successfully completed with everything working as
it should when it was on the 2.19 war file. But on the 2.20 war file
the pivot table is not working. Please find the attached file showing
where is it handing.

Please help.

-- 
Regards,

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

Re: [Dhis2-devs] Pivot Table Not Loading

[gerald thomas]

Dear All,
Please any help my Data not displaying in Pivot tables it keeps
showing "initializing".

On 11/28/15, gerald thomas  wrote:
> Dear All,
> We updated our instance in Sierra Leone from 2.18 to 2.19 and finally
> to 2.20. The job was successfully completed with everything working as
> it should when it was on the 2.19 war file. But on the 2.20 war file
> the pivot table is not working. Please find the attached file showing
> where is it handing.
>
> Please help.
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Pivot Table Not Loading

[gerald thomas]

Dear Knutst,
I didn't know anything about an database update script. I will be
sharing the logs soon. Please can you share the database update script
and thanks for your help.

On 11/29/15, knutst  wrote:
> Hi Gerald, we would need to see error
> messages the comsole of your browser as well as in the Tomcat log. Did you
> run the database update scripts? Regards, Knut style="font-size:75%;color:#575757">Sent from my Samsung Galaxy
> smartphone. Original message
> From: gerald thomas <gerald17...@gmail.com>
> Date: 2015/11/29  10:00 am  (GMT+06:30) Date:2015/11/29
> 10:00 am  (GMT+06:30) To: dhis2-users
> <dhis2-us...@lists.launchpad.net>, dhis2-devs
> <dhis2-devs@lists.launchpad.net> Cc:  Subject:
> Re: [Dhis2-devs] Pivot Table Not Loading Dear All,
> Please any help my Data not displaying in Pivot tables it keeps
> showing "initializing".
>
> On 11/28/15, gerald thomas  wrote:
>> Dear All,
>> We updated our instance in Sierra Leone from 2.18 to 2.19 and finally
>> to 2.20. The job was successfully completed with everything working as
>> it should when it was on the 2.19 war file. But on the 2.20 war file
>> the pivot table is not working. Please find the attached file showing
>> where is it handing.
>>
>> Please help.
>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
> null


-- 
Regards,

Gerald

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

[Dhis2-devs] Automatic backup and restoration of Database to Local Server

[gerald thomas]

Dear All,
Currently our Cloud Hosting and Local Servers are running on version
2.21 build 20928. We did an automatic rysnc to copy the database
backup from the Cloud Hosting server to our Local server on a daily
basis.

I want Local server to automatic verify backups; drop the old database
and import the new database it had collected every Friday on the week.

Thanks in advance for your help and i will be grateful for any contribution.

-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Automatic backup and restoration of Database to Local Server

[gerald thomas]

Dear All,
Please can someone help as per subject???

On 1/8/16, gerald thomas  wrote:
> Dear All,
> Currently our Cloud Hosting and Local Servers are running on version
> 2.21 build 20928. We did an automatic rysnc to copy the database
> backup from the Cloud Hosting server to our Local server on a daily
> basis.
>
> I want Local server to automatic verify backups; drop the old database
> and import the new database it had collected every Friday on the week.
>
> Thanks in advance for your help and i will be grateful for any
> contribution.
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Automatic backup and restoration of Database to Local Server

[gerald thomas]

Dear Bob,
Any help will be grateful because i need a solution currently.

On 1/14/16, Bob Jolliffe  wrote:
> Gerald, are you asking how to do it or do you want someone to write a
> script for you?
>
> On 14 January 2016 at 11:09, gerald thomas  wrote:
>> Dear All,
>> Please can someone help as per subject???
>>
>> On 1/8/16, gerald thomas  wrote:
>>> Dear All,
>>> Currently our Cloud Hosting and Local Servers are running on version
>>> 2.21 build 20928. We did an automatic rysnc to copy the database
>>> backup from the Cloud Hosting server to our Local server on a daily
>>> basis.
>>>
>>> I want Local server to automatic verify backups; drop the old database
>>> and import the new database it had collected every Friday on the week.
>>>
>>> Thanks in advance for your help and i will be grateful for any
>>> contribution.
>>>
>>> --
>>> Regards,
>>>
>>> Gerald
>>>
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Upgrade from 2.20 to 2.22

[gerald thomas]

Boss,
I think you should upgrade the data structures of postgresql database 2.20
before migrating them to 2.22. Please read the upgrade procedures again
because there are steps you should have done. I think it will always fail
if your want to move them directly from 2.20 to 2.22

Regards,
Gerald
On Feb 18, 2016 2:38 AM, "Furqonuddin Ramdhani"  wrote:

> Hi,
>
> I already installed dhis 2.22 and want to migrate all my data from dhis
> 2.20, how the best way to do it, I already tried import the metadata from
> 2.20 to 2.22 but failed. Any suggestion ?
>
> Thanks
>
> --
> Regards,
> *Furqonuddin Ramdhani*
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Upgrade from 2.20 to 2.22

[gerald thomas]

Boss
https://www.dhis2.org/220-upgrade
https://www.dhis2.org/221-upgrade
https://www.dhis2.org/222-upgrade

Did you run the script:
https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql
When upgrading to 2.20?

There is not too much for version 2.21 but you need pay attention to
the changes for version 2.22. Kindly go through the links again.

On Thursday, February 18, 2016, Furqonuddin Ramdhani 
wrote:

>
> I didn't find any upgrade procedures documents for dhis 2.22, maybe
> someone can send me the link or explain a little bit about the procedures.
> I'm aware there are some changes in table structures but how to migrate it
> properly I still doing trial and error here. In previous version usually
> have upgrade scripts  like this one :
>
> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql
>
> Thanks
>
> Regards,
> Dhani
>
>
>
> On Thu, Feb 18, 2016 at 11:50 AM, gerald thomas  > wrote:
>
>> Boss,
>> I think you should upgrade the data structures of postgresql database
>> 2.20 before migrating them to 2.22. Please read the upgrade procedures
>> again because there are steps you should have done. I think it will always
>> fail if your want to move them directly from 2.20 to 2.22
>>
>> Regards,
>> Gerald
>> On Feb 18, 2016 2:38 AM, "Furqonuddin Ramdhani" > > wrote:
>>
>>> Hi,
>>>
>>> I already installed dhis 2.22 and want to migrate all my data from dhis
>>> 2.20, how the best way to do it, I already tried import the metadata from
>>> 2.20 to 2.22 but failed. Any suggestion ?
>>>
>>> Thanks
>>>
>>> --
>>> Regards,
>>> *Furqonuddin Ramdhani*
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@lists.launchpad.net
>>> 
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>
>
> --
> Salam
> *Furqonuddin Ramdhani*
>


-- 
Regards,

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

Re: [Dhis2-devs] [Dhis2-users] [DHIS] Unable to delete a user

[gerald thomas]

Dear all,
This is not really new, from I can delete a user without any problem as
long as I am admin but in a life instance you can only disable users.

Regards,
Gerald
On Mar 11, 2016 05:44, "Archana Chillala"  wrote:

> Hi Lars,
>
> I tried clear cache. But still the same. Unable to delete a user. Even if
> the user is newly created and not associated to any other object.
>
> Any thoughts on this?
>
>
> *Thanks*
>
> Archana Chillala
> Application Developer
> Email archa...@thoughtworks.com
> Telephone +91 9100960533 <+91+9100960533>
> [image: ThoughtWorks]
> 
>
> On Wed, Mar 9, 2016 at 6:22 PM, Lars Helge Øverland 
> wrote:
>
>> Hi Archana,
>>
>> I think this happens due to some leak in our application cache. Try going
>> to data admin > cache statistics > clear cache and try again.
>>
>> regards,
>>
>> Lars
>>
>>
>> On Fri, Mar 4, 2016 at 11:52 AM, Archana Chillala <
>> archa...@thoughtworks.com> wrote:
>>
>>> Hi Morten,
>>>
>>> We are using DHIS version 2.23 and created some sample metadata on it.
>>> When we try to delete a user, the user does not get removed.
>>>
>>> Following are the logs for the exception:
>>>
>>> * INFO  2016-03-04 16:13:13,146 'admin' update
>>> org.hisp.dhis.user.UserAuthorityGroup, name: Superuser, uid: gETZb5SDObu
>>> (AuditLogUtil.java [qtp1727373358-105])
>>> * ERROR 2016-03-04 16:13:13,151 Failed to invoke method deleteUser on
>>> DeletionHandler 'UserSettingDeletionHandler' (DefaultDeletionManager.java
>>> [qtp1727373358-105])
>>> java.lang.reflect.InvocationTargetException
>>> at sun.reflect.GeneratedMethodAccessor618.invoke(Unknown Source)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>> at java.lang.reflect.Method.invoke(Method.java:497)
>>> at
>>> org.hisp.dhis.system.deletion.DefaultDeletionManager.execute(DefaultDeletionManager.java:147)
>>> at
>>> org.hisp.dhis.system.deletion.DeletionInterceptor.intercept(DeletionInterceptor.java:54)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>> at java.lang.reflect.Method.invoke(Method.java:497)
>>> Caused by: org.hibernate.NonUniqueObjectException: a different object
>>> with the same identifier value was already associated with the session:
>>> [org.hisp.dhis.user.UserSetting#org.hisp.dhis.user.UserSetting@528fc6ba]
>>> at
>>> org.hibernate.engine.internal.StatefulPersistenceContext.checkUniqueness(StatefulPersistenceContext.java:696)
>>> at
>>> org.hibernate.event.internal.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:119)
>>> at
>>> org.hibernate.event.internal.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:74)
>>> at org.hibernate.internal.SessionImpl.fireDelete(SessionImpl.java:918)
>>> at org.hibernate.internal.SessionImpl.delete(SessionImpl.java:855)
>>> at
>>> org.hisp.dhis.user.hibernate.HibernateUserSettingStore.deleteUserSetting(HibernateUserSettingStore.java:107)
>>> at
>>> org.hisp.dhis.user.DefaultUserSettingService.deleteUserSetting(DefaultUserSettingService.java:160)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> * INFO  2016-03-04 16:13:13,154 'admin' delete org.hisp.dhis.user.User,
>>> name: user new, uid: bSJzGJPYnWi (AuditLogUtil.java [qtp1727373358-105])
>>> * INFO  2016-03-04 16:13:13,155 'admin' delete
>>> org.hisp.dhis.user.UserCredentials, name: admin admin (AuditLogUtil.java
>>> [qtp1727373358-105])
>>> * INFO  2016-03-04 16:13:13,158 'admin' delete org.hisp.dhis.user.User,
>>> name: user new, uid: bSJzGJPYnWi (AuditLogUtil.java [qtp1727373358-105])
>>> * WARN  2016-03-04 16:13:13,174 SQL Error: 0, SQLState: 23503
>>> (SqlExceptionHelper.java [qtp1727373358-105])
>>> * ERROR 2016-03-04 16:13:13,175 ERROR: update or delete on table
>>> "userinfo" violates foreign key constraint "fk_usersetting_userinfoid" on
>>> table "usersetting"
>>>   Detail: Key (userinfoid)=(289) is still referenced from table
>>> "usersetting". (SqlExceptionHelper.java [qtp1727373358-105])
>>> * ERROR 2016-03-04 16:13:13,175 Error while executing action
>>> (ExceptionInterceptor.java [qtp1727373358-105])
>>> org.springframework.dao.DataIntegrityViolationException: could not
>>> execute statement; SQL [n/a]; constraint [fk_usersetting_userinfoid];
>>> nested exception is org.hibernate.exception.ConstraintViolationException:
>>> could not execute statement
>>> at
>>> org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:163)
>>> at
>>> org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:730)
>>> at
>>> org.springframework.orm.hibernate4.Hibernat

Re: [Dhis2-devs] [Dhis2-users] restore database out of memory

[gerald thomas]

Dear Channara,
Have you configure environmental variables for DHIS2 on the desktop?

Regards,
Gerald
On Mar 19, 2016 02:14, "channara rin"  wrote:

> Hi bob,
> when i backup, i use command pg_dumpall.
> i can restore on my personal laptop with 4GB Memory. but for desktop seem
> out of memory.
> i will re-check again on task manager what is still processing.
>
> On Fri, Mar 18, 2016 at 11:14 PM, Bob Jolliffe 
> wrote:
>
>> One other quick thought that is easy to test and eliminate.  Postgres
>> out of memory errors on restore can also result from a corrupted dump
>> file.  It might be worthwhile to check on another system that your
>> dump is good.
>>
>> On 18 March 2016 at 17:08, Bob Jolliffe  wrote:
>> > Ah you are on Windoze.  I also don't have much real experience of
>> > running dhis2 other than on linux, but it strikes me that
>> > (i) 4G machine is small but should still "work"
>> > (ii) the databse size you are talking about 100m is quite small and
>> > the restore operation should not be consuming vast amounts of memory
>> > (iii) postgres will run, albeit not very efficiently, with quite small
>> > amounts of memory.
>> >
>> > So ...
>> >
>> > I think you need to look at what else you have running on that machine
>> > which could be consuming the bulk of memory.  I think windoze system
>> > tools like task manager and perfmon.exe might show you useful
>> > information.
>> >
>> > Have you modified postgres config or is it default setting?  Default
>> > settings would be very conservative but should work.  If you have
>> > modified, you might have given postgres the impression it has more
>> > memory available than actually exists.
>> >
>> > On 18 March 2016 at 16:53, channara rin  wrote:
>> >> No from hard drive. it has free disk space 100GB for C: and D: is 45GB
>> >>
>> >> On Fri, Mar 18, 2016 at 10:31 PM, Knut Staring 
>> wrote:
>> >>>
>> >>> Sorry Channara, I didn't read your question properly, this has
>> nothing to
>> >>> do with JAVA_OPTS.
>> >>>
>> >>> Unfortunately, I have no experience with getting Postgres out of
>> memory
>> >>> errors, though google tells me a lot of people do.
>> >>>
>> >>> Could it perhaps be that your hard drive is filling up?
>> >>>
>> >>> On Fri, Mar 18, 2016 at 3:38 PM, channara rin > >
>> >>> wrote:
>> 
>>  here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8
>> -server
>>  -Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m
>> -XX:PermSize=256m
>>  -XX:MaxPermSize=1024m -XX:+DisableExplicitGC -xx:+UseConcMarkSweepGC
>>  -XX:+DisableExplicitGC
>> 
>>  On Fri, Mar 18, 2016 at 7:39 PM, Knut Staring 
>> wrote:
>> >
>> > Hi Channara,
>> >
>> > What values do you have for JAVA_OPTS?
>> >
>> > On Fri, Mar 18, 2016 at 1:10 PM, channara rin <
>> rin.chann...@gmail.com>
>> > wrote:
>> >>
>> >> hi all,
>> >> do you hav any experience with postgresql database?
>> >> i use command psql/pg_restore into new system. i got out of memory.
>> >> my system server is 4GB memory and file backup size is around 100MB
>> >>
>> >> ___
>> >> Mailing list: https://launchpad.net/~dhis2-users
>> >> Post to : dhis2-us...@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-users
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >
>> >
>> >
>> > --
>> > Knut Staring
>> > Dept. of Informatics, University of Oslo
>> > Norway: +4791880522
>> > Skype: knutstar
>> > http://dhis2.org
>> 
>> 
>> >>>
>> >>>
>> >>>
>> >>> --
>> >>> 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-us...@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-users
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] restore database out of memory

[gerald thomas]

Dear Channara,
I think Dcocos solution should be a break through and it will minimize the
database size.

Regards,
Gerald
On Mar 19, 2016 05:03, "channara rin"  wrote:

> Thank you,
> let me try testing...
> and by the way, i configured and can run DHIS2 on localhost already. but
> when i plug data into existing DHIS2. it is out of memory.
>
> On Sat, Mar 19, 2016 at 10:08 AM, dcocos  wrote:
>
>> Hi,
>>
>> If you dump with (where dbname is your rename)
>> pg_dump dbname -O -T _* -T aggregated* -T analytics* -T completeness*
>>
>> This will dump without the generated tables which you can recreate by
>> running analytics this reduces the size of the import often by an order of
>> magnitude.
>>
>> On Mar 18, 2016, at 10:14 PM, channara rin 
>> wrote:
>>
>> Hi bob,
>> when i backup, i use command pg_dumpall.
>> i can restore on my personal laptop with 4GB Memory. but for desktop seem
>> out of memory.
>> i will re-check again on task manager what is still processing.
>>
>> On Fri, Mar 18, 2016 at 11:14 PM, Bob Jolliffe 
>> wrote:
>>
>>> One other quick thought that is easy to test and eliminate.  Postgres
>>> out of memory errors on restore can also result from a corrupted dump
>>> file.  It might be worthwhile to check on another system that your
>>> dump is good.
>>>
>>> On 18 March 2016 at 17:08, Bob Jolliffe  wrote:
>>> > Ah you are on Windoze.  I also don't have much real experience of
>>> > running dhis2 other than on linux, but it strikes me that
>>> > (i) 4G machine is small but should still "work"
>>> > (ii) the databse size you are talking about 100m is quite small and
>>> > the restore operation should not be consuming vast amounts of memory
>>> > (iii) postgres will run, albeit not very efficiently, with quite small
>>> > amounts of memory.
>>> >
>>> > So ...
>>> >
>>> > I think you need to look at what else you have running on that machine
>>> > which could be consuming the bulk of memory.  I think windoze system
>>> > tools like task manager and perfmon.exe might show you useful
>>> > information.
>>> >
>>> > Have you modified postgres config or is it default setting?  Default
>>> > settings would be very conservative but should work.  If you have
>>> > modified, you might have given postgres the impression it has more
>>> > memory available than actually exists.
>>> >
>>> > On 18 March 2016 at 16:53, channara rin 
>>> wrote:
>>> >> No from hard drive. it has free disk space 100GB for C: and D: is 45GB
>>> >>
>>> >> On Fri, Mar 18, 2016 at 10:31 PM, Knut Staring 
>>> wrote:
>>> >>>
>>> >>> Sorry Channara, I didn't read your question properly, this has
>>> nothing to
>>> >>> do with JAVA_OPTS.
>>> >>>
>>> >>> Unfortunately, I have no experience with getting Postgres out of
>>> memory
>>> >>> errors, though google tells me a lot of people do.
>>> >>>
>>> >>> Could it perhaps be that your hard drive is filling up?
>>> >>>
>>> >>> On Fri, Mar 18, 2016 at 3:38 PM, channara rin <
>>> rin.chann...@gmail.com>
>>> >>> wrote:
>>> 
>>>  here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8
>>> -server
>>>  -Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m
>>> -XX:PermSize=256m
>>>  -XX:MaxPermSize=1024m -XX:+DisableExplicitGC -xx:+UseConcMarkSweepGC
>>>  -XX:+DisableExplicitGC
>>> 
>>>  On Fri, Mar 18, 2016 at 7:39 PM, Knut Staring 
>>> wrote:
>>> >
>>> > Hi Channara,
>>> >
>>> > What values do you have for JAVA_OPTS?
>>> >
>>> > On Fri, Mar 18, 2016 at 1:10 PM, channara rin <
>>> rin.chann...@gmail.com>
>>> > wrote:
>>> >>
>>> >> hi all,
>>> >> do you hav any experience with postgresql database?
>>> >> i use command psql/pg_restore into new system. i got out of
>>> memory.
>>> >> my system server is 4GB memory and file backup size is around
>>> 100MB
>>> >>
>>> >> ___
>>> >> Mailing list: https://launchpad.net/~dhis2-users
>>> >> Post to : dhis2-us...@lists.launchpad.net
>>> >> Unsubscribe : https://launchpad.net/~dhis2-users
>>> >> More help   : https://help.launchpad.net/ListHelp
>>> >>
>>> >
>>> >
>>> >
>>> > --
>>> > Knut Staring
>>> > Dept. of Informatics, University of Oslo
>>> > Norway: +4791880522
>>> > Skype: knutstar
>>> > http://dhis2.org
>>> 
>>> 
>>> >>>
>>> >>>
>>> >>>
>>> >>> --
>>> >>> 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-us...@lists.launchpad.net
>>> >> Unsubscribe : https://launchpad.net/~dhis2-users
>>> >> More help   : https://help.launchpad.net/ListHelp
>>> >>
>>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Un

[Dhis2-devs] Export & Import of a single Data Set

[gerald thomas]

Dear all,
I am inquiring how could I export a single Data set from one instance and
import that Data set to another instance.
Please help
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Export & Import of a single Data Set

[gerald thomas]

Dear Morten,
I am using 2.26. Let me try your workaround and get back to you with
the result. Thanks very much.

On 6/20/17, Morten Olav Hansen  wrote:
> Hi Gerald
>
> What version of DHIS2 are you on? if you are on a recent version (I think
> 2.25+) you can go to import-export module, then select metadata dependency
> export, and then the data set you want exported.
>
> This data set can then be imported into your other instance.
>
> --
> Morten
>
> On Tue, Jun 20, 2017 at 6:31 AM, gerald thomas 
> wrote:
>
>> Dear all,
>> I am inquiring how could I export a single Data set from one instance and
>> import that Data set to another instance.
>> Please help
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "DHIS2 system administrators" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to dhis2-system-administrators+unsubscr...@googlegroups.com.
>> To post to this group, send email to dhis2-system-administrators@
>> googlegroups.com.
>> To view this discussion on the web, visit https://groups.google.com/d/
>> msgid/dhis2-system-administrators/CA%2BthV3TNnraDen%3DerDuVSxpzkt%
>> 3DVwyevxw71WK1qk%2BFFWL0_Pg%40mail.gmail.com
>> <https://groups.google.com/d/msgid/dhis2-system-administrators/CA%2BthV3TNnraDen%3DerDuVSxpzkt%3DVwyevxw71WK1qk%2BFFWL0_Pg%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Export & Import of a single Data Set

[gerald thomas]

Dear Morten,

The import is not moving beyond this point shown below:

2017-06-20 06:38:44 (geraldthomas) Updating 10 object(s) of type Section
2017-06-20 06:38:43 (geraldthomas) Updating 1 object(s) of type DataSet
2017-06-20 06:38:43 (geraldthomas) Updating 10 object(s) of type Indicator
2017-06-20 06:38:43 (geraldthomas) Updating 1 object(s) of type 
IndicatorType
2017-06-20 06:38:43 (geraldthomas) Updating 73 object(s) of type DataElement
2017-06-20 06:38:42 (geraldthomas) Updating 2 object(s) of type OptionSet
2017-06-20 06:38:42 (geraldthomas) Updating 3 object(s) of type Option
2017-06-20 06:38:39 (geraldthomas) Import:Start


It had been on this for almost 4 hours now.

On 6/20/17, gerald thomas  wrote:
> Dear Morten,
> I am using 2.26. Let me try your workaround and get back to you with
> the result. Thanks very much.
>
> On 6/20/17, Morten Olav Hansen  wrote:
>> Hi Gerald
>>
>> What version of DHIS2 are you on? if you are on a recent version (I think
>> 2.25+) you can go to import-export module, then select metadata
>> dependency
>> export, and then the data set you want exported.
>>
>> This data set can then be imported into your other instance.
>>
>> --
>> Morten
>>
>> On Tue, Jun 20, 2017 at 6:31 AM, gerald thomas 
>> wrote:
>>
>>> Dear all,
>>> I am inquiring how could I export a single Data set from one instance
>>> and
>>> import that Data set to another instance.
>>> Please help
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups
>>> "DHIS2 system administrators" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an
>>> email to dhis2-system-administrators+unsubscr...@googlegroups.com.
>>> To post to this group, send email to dhis2-system-administrators@
>>> googlegroups.com.
>>> To view this discussion on the web, visit https://groups.google.com/d/
>>> msgid/dhis2-system-administrators/CA%2BthV3TNnraDen%3DerDuVSxpzkt%
>>> 3DVwyevxw71WK1qk%2BFFWL0_Pg%40mail.gmail.com
>>> <https://groups.google.com/d/msgid/dhis2-system-administrators/CA%2BthV3TNnraDen%3DerDuVSxpzkt%3DVwyevxw71WK1qk%2BFFWL0_Pg%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Export & Import of a single Data Set

[gerald thomas]

Dear Morten,
I was trying to update the corrupted data set rather than creating a
new one that was my issue before. I deleted the corrupted one and do
the import again; it works perfect.

Thanks for your help.

On 6/20/17, gerald thomas  wrote:
> Dear Morten,
>
> The import is not moving beyond this point shown below:
>
> 2017-06-20 06:38:44   (geraldthomas) Updating 10 object(s) of type Section
> 2017-06-20 06:38:43   (geraldthomas) Updating 1 object(s) of type DataSet
> 2017-06-20 06:38:43   (geraldthomas) Updating 10 object(s) of type Indicator
> 2017-06-20 06:38:43   (geraldthomas) Updating 1 object(s) of type
> IndicatorType
> 2017-06-20 06:38:43   (geraldthomas) Updating 73 object(s) of type
> DataElement
> 2017-06-20 06:38:42   (geraldthomas) Updating 2 object(s) of type OptionSet
> 2017-06-20 06:38:42   (geraldthomas) Updating 3 object(s) of type Option
> 2017-06-20 06:38:39   (geraldthomas) Import:Start
>
>
> It had been on this for almost 4 hours now.
>
> On 6/20/17, gerald thomas  wrote:
>> Dear Morten,
>> I am using 2.26. Let me try your workaround and get back to you with
>> the result. Thanks very much.
>>
>> On 6/20/17, Morten Olav Hansen  wrote:
>>> Hi Gerald
>>>
>>> What version of DHIS2 are you on? if you are on a recent version (I
>>> think
>>> 2.25+) you can go to import-export module, then select metadata
>>> dependency
>>> export, and then the data set you want exported.
>>>
>>> This data set can then be imported into your other instance.
>>>
>>> --
>>> Morten
>>>
>>> On Tue, Jun 20, 2017 at 6:31 AM, gerald thomas 
>>> wrote:
>>>
>>>> Dear all,
>>>> I am inquiring how could I export a single Data set from one instance
>>>> and
>>>> import that Data set to another instance.
>>>> Please help
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups
>>>> "DHIS2 system administrators" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an
>>>> email to dhis2-system-administrators+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to dhis2-system-administrators@
>>>> googlegroups.com.
>>>> To view this discussion on the web, visit https://groups.google.com/d/
>>>> msgid/dhis2-system-administrators/CA%2BthV3TNnraDen%3DerDuVSxpzkt%
>>>> 3DVwyevxw71WK1qk%2BFFWL0_Pg%40mail.gmail.com
>>>> <https://groups.google.com/d/msgid/dhis2-system-administrators/CA%2BthV3TNnraDen%3DerDuVSxpzkt%3DVwyevxw71WK1qk%2BFFWL0_Pg%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>> .
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] CANNOT CREATE PROGRAM STAGE SECTIONS in v. 2.27

[gerald thomas]

Dear Victor & Georgi,
I have you tried it on the dhis2.org demo? If it doesn't work there it
might be a bug but if it works, i suggest you should change your war
file.

On 6/30/17, Victor Garcia  wrote:
> Same problem here.
> Reported a few days ago (https://jira.dhis2.org/browse/DHIS2-1871). This
> issue is reproducible in demo server.
>
> Regards,
>
> Víctor
>
> On 29 June 2017 at 19:16, Georgi Chakarov 
> wrote:
>
>> I am a superuser and I have access to all! I was able to successfully
>> create sections in 2.26, but once we updated to 2.27 I get errors.
>>
>>
>>
>> *From:* Stanley Kalyati [mailto:skaly...@gmail.com]
>> *Sent:* Thursday, June 29, 2017 8:10 PM
>> *To:* Georgi Chakarov 
>> *Cc:* DHIS 2 Developers list ; DHIS Users
>> 
>> *Subject:* Re: [Dhis2-users] CANNOT CREATE PROGRAM STAGE SECTIONS in v.
>> 2.27
>>
>>
>>
>> Georgi,
>>
>>
>>
>> Please look at your user rights.You are not allowed to add a stage.
>>
>>
>>
>> Try to log in as a superuser and you will succeed
>>
>>
>>
>> All the best
>>
>>
>>
>> Stanley
>>
>>
>>
>> On Jun 29, 2017 7:05 PM, "Georgi Chakarov" 
>> wrote:
>>
>> Does anyone know why I cannot create a program stage section in DHIS2
>> version 2.27?
>>
>> I get the screen below. PLEASE help, as I need to proceed quickly with
>> sections. Thanks!
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104
>> <(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation,
>> 720 Bathurst Street, Toronto Canada M5S 2R4 | *You may unsubscribe from
>> receiving commercial electronic messages from LogicalOutcomes by emailing
>> *
>> *i...@logicaloutcomes.net* 
>>
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Error running Analytics

[gerald thomas]

Normally this error occur if your database tweaking or configuration
with reference to RAM is not properly done. You will need to edit the
configuration file again and return your system.
I am certain your system had run out of RAM.

On 8/3/17, ThankGod Anazodo  wrote:
> Dear all,I got this error while trying to run analytics:
> Process failed: StatementCallback; bad SQL grammar [create table
> _orgunitstructure_temp (organisationunitid integer not null primary key,
> organisationunituid character(11), level integer, "idlevel1" integer,
> "uidlevel1" character(11), "idlevel2" integer, "uidlevel2" character(11),
> "idlevel3" integer, "uidlevel3" character(11), "idlevel4" integer,
> "uidlevel4" character(11));]; nested exception is
> org.h2.jdbc.JdbcSQLException: Table "_ORGUNITSTRUCTURE_TEMP" already exists;
> SQL statement: create table _orgunitstructure_temp (organisationunitid
> integer not null primary key, organisationunituid character(11), level
> integer, "idlevel1" integer, "uidlevel1" character(11), "idlevel2" integer,
> "uidlevel2" character(11), "idlevel3" integer, "uidlevel3" character(11),
> "idlevel4" integer, "uidlevel4" character(11)); [42101-194]
>
> I am running version 2.27, any help please.
>
> Thanks.ThankGod


-- 
Regards,

Gerald

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

[Dhis2-devs] Application to improve Data Quality

[gerald thomas]

Dear All,
I am currently looking for a data collection application solution for
our current instance and the scenario is as follows:

CURRENT SITUATION
PHUsDHMTs-DHIS2

Public Health Units: PHUs has the following paper based records
(Register--->Tally Sheet-->Summary Forms): These Summary Forms are
then submitted to the District Health Management Teams: DHMTs they in
turn access DHIS 2 to do data entry. Having look at our data
collection strategy up to our data entry there is need for concern
since it might affect the quality of our data.

FUTURE SITUATION
PHUsDHIS2

In light of this, i am inquiring if anyone had done a project that
could improve our data quality or is there a recommendation from Oslo
in relation to an application that could be a solution. Actually i was
thinking of an app within a tab that could act as a register & tally
sheet which will then the sum data collected at the end of the month,
populate the various Summary Forms and then sync to DHIS 2 once these
tabs are within the environs of the DHMTs.

Kindly share your views or opinions or anything in relation to this
topic because it is something that i think is affecting most countries
using DHIS 2.

Thanks in advance for help or support or comments.


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Application to improve Data Quality

[gerald thomas]

Dear Dr. Chansaly,

I totally agreed with you with reference to the stats giving and that
arouse my attention to raise this inquiry. I am craving for such
implementation and if necessary i can share the registers, tally forms
and summary forms because only way you can properly address our
current situation.

I am craving for those information you about to share and thanks in
advance for your help

On 10/2/17, chansaly  wrote:
> Dear Gerald Thomas,
> This kind of flow information, we have implemented since 2014 up to now. In
> order to improve quality of data and information, it is important to
> improve
> quality of data from registration, tally and summary report forms before it
> can entry into DHIS2. 80% of error is occurred in paper system (compiling)
> and only 20% error while entry into DHIS2.
>
> Some of information like EPI and MCH, we are now trying to apply event
> capture in DHIS2 which data entry is from registration if infrastructure is
> supported (staff are well train and connect inter net stable and cover
> large
> areas)
>
> Anyway, we have done assessment and external verification, if you need we
> can share with you.
>
> Kind regards,
>
>
> Dr. Chansaly
> Deputy Director of HGNDP
> Department of Planning and Cooperation
> Ministry of Health Lao PDR
> -Original Message-
> From: Dhis2-users
> [mailto:dhis2-users-bounces+hsipchansaly=etllao@lists.launchpad.net] On
> Behalf Of gerald thomas
> Sent: Monday, October 2, 2017 12:17 PM
> To: dhis2-users ; DHIS2 system
> administrators ; dhis2-devs
> 
> Subject: [Dhis2-users] Application to improve Data Quality
>
> Dear All,
> I am currently looking for a data collection application solution for our
> current instance and the scenario is as follows:
>
> CURRENT SITUATION
> PHUsDHMTs-DHIS2
>
> Public Health Units: PHUs has the following paper based records
> (Register--->Tally Sheet-->Summary Forms): These Summary Forms are then
> submitted to the District Health Management Teams: DHMTs they in turn
> access
> DHIS 2 to do data entry. Having look at our data collection strategy up to
> our data entry there is need for concern since it might affect the quality
> of our data.
>
> FUTURE SITUATION
> PHUsDHIS2
>
> In light of this, i am inquiring if anyone had done a project that could
> improve our data quality or is there a recommendation from Oslo in relation
> to an application that could be a solution. Actually i was thinking of an
> app within a tab that could act as a register & tally sheet which will then
> the sum data collected at the end of the month, populate the various
> Summary
> Forms and then sync to DHIS 2 once these tabs are within the environs of
> the
> DHMTs.
>
> Kindly share your views or opinions or anything in relation to this topic
> because it is something that i think is affecting most countries using DHIS
> 2.
>
> Thanks in advance for help or support or comments.
>
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Application to improve Data Quality

[gerald thomas]

Dears,

Any update or support.

On 10/2/17, gerald thomas  wrote:
> Dear Dr. Chansaly,
>
> I totally agreed with you with reference to the stats giving and that
> arouse my attention to raise this inquiry. I am craving for such
> implementation and if necessary i can share the registers, tally forms
> and summary forms because only way you can properly address our
> current situation.
>
> I am craving for those information you about to share and thanks in
> advance for your help
>
> On 10/2/17, chansaly  wrote:
>> Dear Gerald Thomas,
>> This kind of flow information, we have implemented since 2014 up to now.
>> In
>> order to improve quality of data and information, it is important to
>> improve
>> quality of data from registration, tally and summary report forms before
>> it
>> can entry into DHIS2. 80% of error is occurred in paper system
>> (compiling)
>> and only 20% error while entry into DHIS2.
>>
>> Some of information like EPI and MCH, we are now trying to apply event
>> capture in DHIS2 which data entry is from registration if infrastructure
>> is
>> supported (staff are well train and connect inter net stable and cover
>> large
>> areas)
>>
>> Anyway, we have done assessment and external verification, if you need we
>> can share with you.
>>
>> Kind regards,
>>
>>
>> Dr. Chansaly
>> Deputy Director of HGNDP
>> Department of Planning and Cooperation
>> Ministry of Health Lao PDR
>> -Original Message-
>> From: Dhis2-users
>> [mailto:dhis2-users-bounces+hsipchansaly=etllao@lists.launchpad.net]
>> On
>> Behalf Of gerald thomas
>> Sent: Monday, October 2, 2017 12:17 PM
>> To: dhis2-users ; DHIS2 system
>> administrators ; dhis2-devs
>> 
>> Subject: [Dhis2-users] Application to improve Data Quality
>>
>> Dear All,
>> I am currently looking for a data collection application solution for our
>> current instance and the scenario is as follows:
>>
>> CURRENT SITUATION
>> PHUsDHMTs-DHIS2
>>
>> Public Health Units: PHUs has the following paper based records
>> (Register--->Tally Sheet-->Summary Forms): These Summary Forms are
>> then
>> submitted to the District Health Management Teams: DHMTs they in turn
>> access
>> DHIS 2 to do data entry. Having look at our data collection strategy up
>> to
>> our data entry there is need for concern since it might affect the
>> quality
>> of our data.
>>
>> FUTURE SITUATION
>> PHUsDHIS2
>>
>> In light of this, i am inquiring if anyone had done a project that could
>> improve our data quality or is there a recommendation from Oslo in
>> relation
>> to an application that could be a solution. Actually i was thinking of an
>> app within a tab that could act as a register & tally sheet which will
>> then
>> the sum data collected at the end of the month, populate the various
>> Summary
>> Forms and then sync to DHIS 2 once these tabs are within the environs of
>> the
>> DHMTs.
>>
>> Kindly share your views or opinions or anything in relation to this topic
>> because it is something that i think is affecting most countries using
>> DHIS
>> 2.
>>
>> Thanks in advance for help or support or comments.
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

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

[Dhis2-devs] Integration of OpenMRS & DHIS2

[gerald thomas]

Dear All,
I am trying to integrate DHIS2 and OpenMRS application. On the OpenMRS
application there is a module called "DHIS2 Reporting Module" which
was installed successfully. But anytime i click on the DHIS2 tab i am
getting the following error as shown on the attached file.

Please can anyone help.

-- 
Regards,

Gerald


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

Re: [Dhis2-devs] Integration of OpenMRS & DHIS2

[gerald thomas]

Thanks, I'll check it out but please if you have such contacts available
then I will be grateful if you provide them. Google search responses
haven't been that good on this topic.

On Nov 7, 2017 15:04, "Bob Jolliffe"  wrote:

Hi Gerald

My knowledge of that openmrs module is quite old .. I wrote the
initial implementation but that is over 5 years ago.  I think what you
should do is to contact the current maintainers of the module for
support on the various errors you might be seeing.  I know there was
some Google summer of code work done on it this year for example.

Cheers
Bob

On 7 November 2017 at 20:50, gerald thomas  wrote:
> Dear All,
> I am trying to integrate DHIS2 and OpenMRS application. On the OpenMRS
> application there is a module called "DHIS2 Reporting Module" which
> was installed successfully. But anytime i click on the DHIS2 tab i am
> getting the following error as shown on the attached file.
>
> Please can anyone help.
>
> --
> Regards,
>
> Gerald
>
> --
> You received this message because you are subscribed to the Google Groups
"DHIS2 system administrators" group.
> To unsubscribe from this group and stop receiving emails from it, send an
email to dhis2-system-administrators+unsubscr...@googlegroups.com.
> To post to this group, send an email to dhis2-system-administrators@
googlegroups.com.
> To view this discussion on the web, visit https://groups.google.com/d/
msgid/dhis2-system-administrators/CA%2BthV3TDGa8WXHjG2xNNce129zJkrU
Tqtzi%2BVG99_zv3BFmqCQ%40mail.gmail.com.
> For more options, visit https://groups.google.com/d/optout.
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Teenage Pregnancy DataSet for Schools

[gerald thomas]

Dear All,
I created a Teenage Pregnancy dataSet whose data should be captured
from schools. Since we have multiple schools per Chiefdom; i created a
data element 'school' in the form of a text string. During data entry,
when a school had been entered for a particular chiefdom, it don't
accept another school again.

Please can someone help.

-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] DHIS2 Assistance...

[gerald thomas]

Selvaraaj,
I am interested

On Wed, 15 Nov 2017 at 08:36, M.Selvaraaj Prabu  wrote:

> Good day guys,
>
> I am looking for someone who can do online DHIS2 consultancy. Anyone
> interested, please reply to this email with details.
>
> Thanks and regards
>
> MSP (Selvaraj)
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
-- 
Regards,

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

Re: [Dhis2-devs] Teenage Pregnancy DataSet for Schools

[gerald thomas]

Dear Calle,
Thanks for your response. That was what i told the partners but their
budget didn't permitted them and they didn't have names for all the
schools. How does comments works on DataSet? Because we can use the
option of comments to tag names to a particular Data Entry because the
name of the schools are for reference purposes.

On 11/15/17, Calle Hedberg  wrote:
> Gerald,
>
> I would not recommend using the standard HMIS for school health - it would
> give you minimal control and reporting capabilities per school.
>
> In South Africa, school health is captured into a separate DHIS2 database
> where the hierarchy ends with schools and not health facilities (although
> each school might store a reference health facility, of course). All the
> ~30,000 schools in the country is part of that orghierarchy, and we
> generally try to get annual data for the number of learners (pupils) per
> grade, which you can then use as denominator data to get coverage
> indicators.
>
> You COULD of course add the schools into the HMIS orghierarchy, but IMHO
> that is rather messy - better to use a separate database
>
> Regards
> Calle
>
> On 15 November 2017 at 08:30, gerald thomas  wrote:
>
>> Dear All,
>> I created a Teenage Pregnancy dataSet whose data should be captured
>> from schools. Since we have multiple schools per Chiefdom; i created a
>> data element 'school' in the form of a text string. During data entry,
>> when a school had been entered for a particular chiefdom, it don't
>> accept another school again.
>>
>> Please can someone help.
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Teenage Pregnancy DataSet for Schools

[gerald thomas]

Dear Calle,
I had already did as you suggested but i am face with a challenge of
attaching my category combination to the various data element.

Please i need help

On 11/15/17, Calle Hedberg  wrote:
> Gerald,
>
> OK, so there is no intention or requirement to track and analyze such data
> per school, then. If the idea is simply to somehow store a list of schools
> from where the data originates, and assuming that you are collecting it per
> chiefdom and per month, I would rather change the data element you have
> already created into a long text field. Capturers can then add school names
> in there, separated by a semi-colon or similar delimiter.
>
> Just make sure everybody understands that if the data per chiefdom per
> month has not already been aggregated in the input form, then such
> aggregation must be done manually during data entry.
>
> Note also that you do have one other possibility, and that is to treat each
> school report received as an event - or in other words you set this up as
> an Event Program - without registration, presumably - where the school
> itself it the entity.
>
> Regards
> Calle
>
> On 15 November 2017 at 11:45, gerald thomas  wrote:
>
>> Dear Calle,
>> Thanks for your response. That was what i told the partners but their
>> budget didn't permitted them and they didn't have names for all the
>> schools. How does comments works on DataSet? Because we can use the
>> option of comments to tag names to a particular Data Entry because the
>> name of the schools are for reference purposes.
>>
>> On 11/15/17, Calle Hedberg  wrote:
>> > Gerald,
>> >
>> > I would not recommend using the standard HMIS for school health - it
>> would
>> > give you minimal control and reporting capabilities per school.
>> >
>> > In South Africa, school health is captured into a separate DHIS2
>> > database
>> > where the hierarchy ends with schools and not health facilities
>> > (although
>> > each school might store a reference health facility, of course). All
>> > the
>> > ~30,000 schools in the country is part of that orghierarchy, and we
>> > generally try to get annual data for the number of learners (pupils)
>> > per
>> > grade, which you can then use as denominator data to get coverage
>> > indicators.
>> >
>> > You COULD of course add the schools into the HMIS orghierarchy, but
>> > IMHO
>> > that is rather messy - better to use a separate database
>> >
>> > Regards
>> > Calle
>> >
>> > On 15 November 2017 at 08:30, gerald thomas 
>> wrote:
>> >
>> >> Dear All,
>> >> I created a Teenage Pregnancy dataSet whose data should be captured
>> >> from schools. Since we have multiple schools per Chiefdom; i created a
>> >> data element 'school' in the form of a text string. During data entry,
>> >> when a school had been entered for a particular chiefdom, it don't
>> >> accept another school again.
>> >>
>> >> Please can someone help.
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >> ___
>> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> Post to : dhis2-devs@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >
>> >
>> >
>> > --
>> >
>> > ***
>> >
>> > Calle Hedberg
>> >
>> > 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>> >
>> > Tel/fax (home): +27-21-685-6472
>> >
>> > Cell: +27-82-853-5352
>> >
>> > Iridium SatPhone: +8816-315-19119
>> >
>> > Email: calle.hedb...@gmail.com
>> >
>> > Skype: calle_hedberg
>> >
>> > ***
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>


-- 
Regards,

Gerald

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

[Dhis2-devs] Creating a comment like data element

[gerald thomas]

Dear All,
I am creating a data set which needs a section on the form for
comment. Please how can I create a comment section data element on a
data set form.

-- 
Regards,

Gerald

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

Re: [Dhis2-devs] [Dhis2-users] Creating a comment like data element

[gerald thomas]

Dear Nayeem,
How do we add an option set to a data set so that it could be available
during data entry?

On Thu, 23 Nov 2017 at 03:45, Nayeem Al Mifthah  wrote:

> Dear Gerald
>
> I don't know how you want to analyze. If those are common comments you may
> create option set.
>
> If you want to get some narrative description, you may make a data element
> with long text as type.
>
> *Nayeem Al Mifthah*
> *Consultant for HSS, Health MIS, M&E*
> Email: n.mift...@gmail.com
> Cell:+8801914030574
> Skype: nayeem.a.m
>
> On Thu, Nov 23, 2017 at 6:39 AM, gerald thomas 
> wrote:
>
>> Dear All,
>> I am creating a data set which needs a section on the form for
>> comment. Please how can I create a comment section data element on a
>> data set form.
>>
>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
> --
Regards,

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

[Dhis2-devs] Data Set Issue

[gerald thomas]

Dear All,
I am having two different DataSets by the name of RC School and LC
School sharing the same data elements and category combination. During
data entry when I entered information on the RC School DataSet it
saves but when i switched to LC School the information of RC School
DataSet is present of LC School and whatever changes done on LC School
DataSet will automatically reflect on RC School DataSet.

Please can anyone help.

-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Data Set Issue

[gerald thomas]

Dear all,
Thanks for your help.
I am was only using two schools for explanation purposes. But the scenario
is much more complex. I have 32 schools of which the partners didn’t want
us to use them on their current hierarchy; so we decided to use each school
as a DataSet but that didn’t work either. The idea of attributes came up
before but i am sure it doesn’t work with category combinations.
Please what is the best option

On Mon, 4 Dec 2017 at 18:12, Dennis Banga  wrote:

> Hi Gerald,
>
> A data set is just a container for the data elements, hence the behavior.
> Utilize attrubutes for the RC and LC schools instead.
> Kindly see the documentation here
> <https://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#use_category_combo_for_data_set>
>
>
> Regards,
> Dennis
>
> On 4 December 2017 at 19:46, gerald thomas  wrote:
>
>> Dear All,
>> I am having two different DataSets by the name of RC School and LC
>> School sharing the same data elements and category combination. During
>> data entry when I entered information on the RC School DataSet it
>> saves but when i switched to LC School the information of RC School
>> DataSet is present of LC School and whatever changes done on LC School
>> DataSet will automatically reflect on RC School DataSet.
>>
>> Please can anyone help.
>>
>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
> --
Regards,

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

Re: [Dhis2-devs] Data Set Issue

[gerald thomas]

Dear Knut,
Thanks for the note, I will try to explore this option.

On Mon, 4 Dec 2017 at 18:46, Knut Staring  wrote:

> I think you could use attributeoptioncombos for this instead of categories:
>
> https://docs.dhis2.org/2.22/en/user/html/ch05s07.html
>
> Knut
>
> On Mon, Dec 4, 2017 at 11:33 PM, gerald thomas 
> wrote:
>
>> Dear all,
>> Thanks for your help.
>> I am was only using two schools for explanation purposes. But the
>> scenario is much more complex. I have 32 schools of which the partners
>> didn’t want us to use them on their current hierarchy; so we decided to use
>> each school as a DataSet but that didn’t work either. The idea of
>> attributes came up before but i am sure it doesn’t work with category
>> combinations.
>> Please what is the best option
>>
>> On Mon, 4 Dec 2017 at 18:12, Dennis Banga  wrote:
>>
>>> Hi Gerald,
>>>
>>> A data set is just a container for the data elements, hence the
>>> behavior. Utilize attrubutes for the RC and LC schools instead.
>>> Kindly see the documentation here
>>> <https://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#use_category_combo_for_data_set>
>>>
>>>
>>> Regards,
>>> Dennis
>>>
>>> On 4 December 2017 at 19:46, gerald thomas 
>>> wrote:
>>>
>>>> Dear All,
>>>> I am having two different DataSets by the name of RC School and LC
>>>> School sharing the same data elements and category combination. During
>>>> data entry when I entered information on the RC School DataSet it
>>>> saves but when i switched to LC School the information of RC School
>>>> DataSet is present of LC School and whatever changes done on LC School
>>>> DataSet will automatically reflect on RC School DataSet.
>>>>
>>>> Please can anyone help.
>>>>
>>>
>>>> --
>>>> Regards,
>>>>
>>>> Gerald
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to : dhis2-devs@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
>
> Department of Information, Evidence and Research
> World Health Organization, Geneva, Switzerland
> Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
> Skype: knutstar
>
-- 
Regards,

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

Re: [Dhis2-devs] Data Set Issue

[gerald thomas]

Dear Knut,
Thanks very much for your help but i have one more question; I have 31
schools of which 4 of them have the same name (RC Junior Sec School)
but of different chiefdoms. Can i do a single attributecategory RC
Junior Sec School and assigned it to the various chiefdoms? Will the
schools data save separately with reference to their respective
chiefdoms or should i create attributecategory for each RC Junior Sec
School label with its chiefdom?

On 12/4/17, gerald thomas  wrote:
> Dear Knut,
> Thanks for the note, I will try to explore this option.
>
> On Mon, 4 Dec 2017 at 18:46, Knut Staring  wrote:
>
>> I think you could use attributeoptioncombos for this instead of
>> categories:
>
>> https://docs.dhis2.org/2.22/en/user/html/ch05s07.html
>
>> Knut
>
>> On Mon, Dec 4, 2017 at 11:33 PM, gerald thomas 
>> wrote:
>
>>> Dear all,
>>> Thanks for your help.
>>> I am was only using two schools for explanation purposes. But the
>>> scenario is much more complex. I have 32 schools of which the partners
>>> didn’t want us to use them on their current hierarchy; so we decided to
>>>
>>> use
>>> each school as a DataSet but that didn’t work either. The idea of
>>> attributes came up before but i am sure it doesn’t work with category
>>> combinations.
>>> Please what is the best option
>
>>> On Mon, 4 Dec 2017 at 18:12, Dennis Banga  wrote:
>
>>>> Hi Gerald,
>
>>>> A data set is just a container for the data elements, hence the
>>>> behavior. Utilize attrubutes for the RC and LC schools instead.
>>>> Kindly see the documentation here
>>>> <https://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#use_category_combo_for_data_set>
>
>
>>>> Regards,
>>>> Dennis
>
>>>> On 4 December 2017 at 19:46, gerald thomas 
>>>> wrote:
>
>>>>> Dear All,
>>>>> I am having two different DataSets by the name of RC School and LC
>>>>> School sharing the same data elements and category combination. During
>>>>> data entry when I entered information on the RC School DataSet it
>>>>> saves but when i switched to LC School the information of RC School
>>>>> DataSet is present of LC School and whatever changes done on LC School
>>>>> DataSet will automatically reflect on RC School DataSet.
>
>>>>> Please can anyone help.
>
>
>>>>> --
>>>>> Regards,
>
>>>>> Gerald
>
>>>>> ___
>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>> Post to : dhis2-devs@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>
>>>> --
>>> Regards,
>
>>> Gerald
>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>> --
>> Knut Staring
>
>> Department of Information, Evidence and Research
>> World Health Organization, Geneva, Switzerland
>> Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
>> Skype: knutstar
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Data Set Issue

[gerald thomas]

Dear Knut,

Yes. Chiefdom will be my OU for this data collection.


On 12/7/17, Knut Staring  wrote:
> Hi Gerald, I assume you will be using the Chiefdom as the OrgUnit for this
> data collection?
>
> Regards,
> Knut
>
> On Tue, Dec 5, 2017 at 8:19 PM, gerald thomas 
> wrote:
>
>> Dear Knut,
>> Thanks very much for your help but i have one more question; I have 31
>> schools of which 4 of them have the same name (RC Junior Sec School)
>> but of different chiefdoms. Can i do a single attributecategory RC
>> Junior Sec School and assigned it to the various chiefdoms? Will the
>> schools data save separately with reference to their respective
>> chiefdoms or should i create attributecategory for each RC Junior Sec
>> School label with its chiefdom?
>>
>> On 12/4/17, gerald thomas  wrote:
>> > Dear Knut,
>> > Thanks for the note, I will try to explore this option.
>> >
>> > On Mon, 4 Dec 2017 at 18:46, Knut Staring  wrote:
>> >
>> >> I think you could use attributeoptioncombos for this instead of
>> >> categories:
>> >
>> >> https://docs.dhis2.org/2.22/en/user/html/ch05s07.html
>> >
>> >> Knut
>> >
>> >> On Mon, Dec 4, 2017 at 11:33 PM, gerald thomas 
>> >> wrote:
>> >
>> >>> Dear all,
>> >>> Thanks for your help.
>> >>> I am was only using two schools for explanation purposes. But the
>> >>> scenario is much more complex. I have 32 schools of which the
>> >>> partners
>> >>> didn’t want us to use them on their current hierarchy; so we decided
>> >>> to
>> >>>
>> >>> use
>> >>> each school as a DataSet but that didn’t work either. The idea of
>> >>> attributes came up before but i am sure it doesn’t work with category
>> >>> combinations.
>> >>> Please what is the best option
>> >
>> >>> On Mon, 4 Dec 2017 at 18:12, Dennis Banga 
>> wrote:
>> >
>> >>>> Hi Gerald,
>> >
>> >>>> A data set is just a container for the data elements, hence the
>> >>>> behavior. Utilize attrubutes for the RC and LC schools instead.
>> >>>> Kindly see the documentation here
>> >>>> <https://docs.dhis2.org/master/en/user/html/dhis2_
>> user_manual_en_full.html#use_category_combo_for_data_set>
>> >
>> >
>> >>>> Regards,
>> >>>> Dennis
>> >
>> >>>> On 4 December 2017 at 19:46, gerald thomas 
>> >>>> wrote:
>> >
>> >>>>> Dear All,
>> >>>>> I am having two different DataSets by the name of RC School and LC
>> >>>>> School sharing the same data elements and category combination.
>> During
>> >>>>> data entry when I entered information on the RC School DataSet it
>> >>>>> saves but when i switched to LC School the information of RC School
>> >>>>> DataSet is present of LC School and whatever changes done on LC
>> School
>> >>>>> DataSet will automatically reflect on RC School DataSet.
>> >
>> >>>>> Please can anyone help.
>> >
>> >
>> >>>>> --
>> >>>>> Regards,
>> >
>> >>>>> Gerald
>> >
>> >>>>> ___
>> >>>>> Mailing list: https://launchpad.net/~dhis2-devs
>> >>>>> Post to : dhis2-devs@lists.launchpad.net
>> >>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >>>>> More help   : https://help.launchpad.net/ListHelp
>> >
>> >>>> --
>> >>> Regards,
>> >
>> >>> Gerald
>> >
>> >>> ___
>> >>> Mailing list: https://launchpad.net/~dhis2-devs
>> >>> Post to : dhis2-devs@lists.launchpad.net
>> >>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >>> More help   : https://help.launchpad.net/ListHelp
>> >
>> >
>> >
>> >
>> >> --
>> >> Knut Staring
>> >
>> >> Department of Information, Evidence and Research
>> >> World Health Organization, Geneva, Switzerland
>> >> Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
>> >> Skype: knutstar
>> >
>> > --
>> > Regards,
>> >
>> > Gerald
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
>
> --
> Knut Staring
>
> Department of Information, Evidence and Research
> World Health Organization, Geneva, Switzerland
> Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
> Skype: knutstar
>


-- 
Regards,

Gerald

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

Re: [Dhis2-devs] Data Set Issue

[gerald thomas]

Dear Knut,

I will take the second option then.

Thanks very much for help and patience.

On 12/7/17, Knut Staring  wrote:
> Right - so you could have two options, either use the Chiefdom to
> differentiate though they all just use the same name. However, you may
> require some special analytics for this.
>
> The other way would be to add the name of each chiefdom at the end of the
> identical school names to make them not identical.
>
> Knut
>
> On Thu, Dec 7, 2017 at 8:45 AM, gerald thomas 
> wrote:
>
>> Dear Knut,
>>
>> Yes. Chiefdom will be my OU for this data collection.
>>
>>
>> On 12/7/17, Knut Staring  wrote:
>> > Hi Gerald, I assume you will be using the Chiefdom as the OrgUnit for
>> this
>> > data collection?
>> >
>> > Regards,
>> > Knut
>> >
>> > On Tue, Dec 5, 2017 at 8:19 PM, gerald thomas 
>> > wrote:
>> >
>> >> Dear Knut,
>> >> Thanks very much for your help but i have one more question; I have 31
>> >> schools of which 4 of them have the same name (RC Junior Sec School)
>> >> but of different chiefdoms. Can i do a single attributecategory RC
>> >> Junior Sec School and assigned it to the various chiefdoms? Will the
>> >> schools data save separately with reference to their respective
>> >> chiefdoms or should i create attributecategory for each RC Junior Sec
>> >> School label with its chiefdom?
>> >>
>> >> On 12/4/17, gerald thomas  wrote:
>> >> > Dear Knut,
>> >> > Thanks for the note, I will try to explore this option.
>> >> >
>> >> > On Mon, 4 Dec 2017 at 18:46, Knut Staring  wrote:
>> >> >
>> >> >> I think you could use attributeoptioncombos for this instead of
>> >> >> categories:
>> >> >
>> >> >> https://docs.dhis2.org/2.22/en/user/html/ch05s07.html
>> >> >
>> >> >> Knut
>> >> >
>> >> >> On Mon, Dec 4, 2017 at 11:33 PM, gerald thomas <
>> gerald17...@gmail.com>
>> >> >> wrote:
>> >> >
>> >> >>> Dear all,
>> >> >>> Thanks for your help.
>> >> >>> I am was only using two schools for explanation purposes. But the
>> >> >>> scenario is much more complex. I have 32 schools of which the
>> >> >>> partners
>> >> >>> didn’t want us to use them on their current hierarchy; so we
>> >> >>> decided
>> >> >>> to
>> >> >>>
>> >> >>> use
>> >> >>> each school as a DataSet but that didn’t work either. The idea of
>> >> >>> attributes came up before but i am sure it doesn’t work with
>> category
>> >> >>> combinations.
>> >> >>> Please what is the best option
>> >> >
>> >> >>> On Mon, 4 Dec 2017 at 18:12, Dennis Banga 
>> >> wrote:
>> >> >
>> >> >>>> Hi Gerald,
>> >> >
>> >> >>>> A data set is just a container for the data elements, hence the
>> >> >>>> behavior. Utilize attrubutes for the RC and LC schools instead.
>> >> >>>> Kindly see the documentation here
>> >> >>>> <https://docs.dhis2.org/master/en/user/html/dhis2_
>> >> user_manual_en_full.html#use_category_combo_for_data_set>
>> >> >
>> >> >
>> >> >>>> Regards,
>> >> >>>> Dennis
>> >> >
>> >> >>>> On 4 December 2017 at 19:46, gerald thomas
>> >> >>>> 
>> >> >>>> wrote:
>> >> >
>> >> >>>>> Dear All,
>> >> >>>>> I am having two different DataSets by the name of RC School and
>> >> >>>>> LC
>> >> >>>>> School sharing the same data elements and category combination.
>> >> During
>> >> >>>>> data entry when I entered information on the RC School DataSet
>> >> >>>>> it
>> >> >>>>> saves but when i switched to LC School the information of RC
>> School
>> >> >>>>> DataSet is present of LC School and whatever changes done on LC
>> >> School
>> >> >>>>> DataSet will a