[Dhis2-devs] using mydatamart to export data excel format

2015-06-24 Thread Moemedi Ntunyane
Hi evryone Mydatamart tool not able to download metadata from dhis instance. All possible options checked!! Just to verify: is this tool available DHIS2.14! that is before implementation of pivot tables!!...Thankz in advbanced!! Moemedi Ntunyane Co-founder KeyInConsulting

Re: [Dhis2-devs] using mydatamart to export data excel format

2015-06-24 Thread Moemedi Ntunyane
Thanks Bob. We are not stuck, jst needed a simply tool to be used by clients to extract data in form of excel format. And the format should always be the same because it will be used to update data in powerpoint for presentation purposes Moemedi Ntunyane Co-founder KeyInConsulting > D

[Dhis2-devs] DHIS upgrade from 2.0.5 to 2.14

2014-08-08 Thread Moemedi Ntunyane
Good Day Every one I want to upgrade DHIS 2.0.5 to a new version(2.14) which is more advanced with a lot of improved features. I cannot see a clear manual for doing the upgrade like scripts for all the versions from 2.0.5 to 2.14. How can I upgrade without continuously moving version by versio

[Dhis2-devs] upgrade from 2.0.5 to 2.14

2014-08-08 Thread Moemedi Ntunyane
. Thanks for your help in advanced... Moemedi Ntunyane Co-founder KeyInConsulting ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https

[Dhis2-devs] dhis upgrade from 2.0.5 to 2.15

2014-08-19 Thread Moemedi Ntunyane
Hi Developers, where can I get the upgrade scripts from the very lowest dhis 2.0.6 so that i do incremental Moemedi Ntunyane Co-founder KeyInConsulting ___ Mailing list: https://launchpad.net/~dhis2-devs Post

Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15

2014-08-19 Thread Moemedi Ntunyane
Hi Dan Thanks a lot. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 From: d...@dancocos.com Date: Tue, 19 Aug 2014 10:40:56 -0400 CC: dhis2-devs@lists.launchpad.net To: moemedi.ntuny...@hotmail.com Hello Moemedi, The upgrades

Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15

2014-08-19 Thread Moemedi Ntunyane
exist. Moemedi Ntunyane Co-founder KeyInConsulting From: moemedi.ntuny...@hotmail.com To: d...@dancocos.com CC: dhis2-devs@lists.launchpad.net Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 Date: Tue, 19 Aug 2014 16:47:46 +0200 Hi Dan Thanks a lot. Regards, Moemedi Ntunyane Co-founder

Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15

2014-08-20 Thread Moemedi Ntunyane
Hi Adebusoye Did you upload run any scripts? just uploaded the war file and restored the old database backup but the problem is everything seems fine but cannot display information related to dataset. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Subject: Re: [Dhis2-devs] dhis upgrade

Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15

2014-08-21 Thread Moemedi Ntunyane
Hi, Thanks a lot for information. I did manage to upgrade to 2.10. The datasets are not appearing but the data is available from the database, only displaying is a problem Moemedi Ntunyane Co-founder KeyInConsulting Date: Thu, 21 Aug 2014 10:58:06 +0300 Subject: Re: [Dhis2-devs] dhis upgrade

Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15

2014-08-21 Thread Moemedi Ntunyane
Hi, Thanks a lot for information. I did manage to upgrade to 2.10. The datasets are not appearing but the data is available from the database, only displaying is a problem Moemedi Ntunyane Co-founder KeyInConsulting Date: Thu, 21 Aug 2014 10:58:06 +0300 Subject: Re: [Dhis2-devs] dhis upgrade

Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15

2014-08-21 Thread Moemedi Ntunyane
The old datasets and data elements are not displayed on the form. I was upgrading from 2.0.5 to 2.13. Moemedi Ntunyane Co-founder KeyInConsulting From: knu...@gmail.com Date: Thu, 21 Aug 2014 12:45:19 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny

Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15

2014-08-22 Thread Moemedi Ntunyane
ull values (SchemaUpdate.java [main]) Moemedi Ntunyane Co-founder KeyInConsulting Date: Thu, 21 Aug 2014 21:17:32 +0200 Subject: RE: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 From: knu...@gmail.com To: moemedi.ntuny...@hotmail.com CC: seny...@gmail.com; dhis2-devs@lists.launchpad.net Maybe try goi

Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15

2014-08-22 Thread Moemedi Ntunyane
Thanks a lot Morten, datasets are ok and their. I only have problem with editing orgunits. Orgunits are displaying but cannot be edited but cant see any error logs associateed with the problem. Moemedi Ntunyane Co-founder KeyInConsulting From: morte...@gmail.com Date: Fri, 22 Aug 2014 15:08

Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15

2014-08-22 Thread Moemedi Ntunyane
Thanks a lot...I managed by including latitude column orgnunit table. Moemedi Ntunyane Co-founder KeyInConsulting From: knu...@gmail.com Date: Fri, 22 Aug 2014 11:53:31 +0200 Subject: Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15 To: moemedi.ntuny...@hotmail.com CC: morte...@gmail.com; dhis2

Re: [Dhis2-devs] dhis upgrade from 2.0.5 to 2.15

2014-08-22 Thread Moemedi Ntunyane
problems, we would really appreciate it if you could share a short write-up of your experience. Thanks, Knut On Fri, Aug 22, 2014 at 1:51 PM, Moemedi Ntunyane wrote: Thanks a lot...I managed by including latitude column orgnunit table. Moemedi Ntunyane Co-founder KeyInConsulting From

[Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist

2014-09-11 Thread Moemedi Ntunyane
Hi all I am having a problem with generating pivot tables as dat cannot be found and the follwing error appears:Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist thnzx in advance Moemedi Ntunyane Co-founder KeyIn

Re: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist

2014-09-11 Thread Moemedi Ntunyane
Hi All All data seems to be ok as it is available in data entry screen and only not available in reports Moemedi Ntunyane Co-founder KeyInConsulting From: moemedi.ntuny...@hotmail.com To: dhis2-devs@lists.launchpad.net Subject: Caused by: org.postgresql.util.PSQLException: ERROR: relation

Re: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist

2014-09-12 Thread Moemedi Ntunyane
Hi Lars Will send the copy of the log file as I am not at the station. I generated the analytics tables but the errors shows that the errors analytics tables cannot be created Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Thu, 11 Sep 2014 14:19:19 -0400 Subject: Re

Re: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist

2014-09-12 Thread Moemedi Ntunyane
.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

Re: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist

2014-09-12 Thread Moemedi Ntunyane
ues (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint Moemedi Ntunyane Co-founder KeyInConsulting From: moemedi.ntuny...

[Dhis2-devs] periodstructure giving errors...

2014-09-12 Thread Moemedi Ntunyane
s not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint Regards, Moemedi Ntunyane Co-founder KeyInConsulting ___

Re: [Dhis2-devs] periodstructure giving errors...

2014-09-15 Thread Moemedi Ntunyane
le shows that there is key violation for null values for iso column in the periodstructure table. Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 11:46:07 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moe

Re: [Dhis2-devs] periodstructure giving errors...

2014-09-15 Thread Moemedi Ntunyane
t;iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 12:22:31 +0200 Subject: Re: [Dhis2-devs] pe

Re: [Dhis2-devs] periodstructure giving errors...

2014-09-15 Thread Moemedi Ntunyane
Thanks, will eliminate all of them. So far the query returned 5 records. But other records are referenced by foreign keys like: chart_periods;reporttable_periods;completedatasetregistration Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 16:01:08 +0200 Subject: Re: [Dhis2

Re: [Dhis2-devs] periodstructure giving errors...

2014-09-15 Thread Moemedi Ntunyane
Hi Lars, I have not done that. Im only capturing statistical data. Regards, Moemedi Ntunyane Co-founder KeyInConsulting Date: Mon, 15 Sep 2014 16:10:13 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: larshe...@gmail.com To: jason.p.picker...@gmail.com CC: moemedi.ntuny

Re: [Dhis2-devs] periodstructure giving errors...

2014-09-15 Thread Moemedi Ntunyane
LException: ERROR: null value in column "iso" violates not-null constraint. Moemedi Ntunyane Co-founder KeyInConsulting From: moemedi.ntuny...@hotmail.com To: larshe...@gmail.com; jason.p.picker...@gmail.com CC: dhis2-devs@lists.launchpad.net Subject: RE: [Dhis2-devs] periodstructure g

Re: [Dhis2-devs] periodstructure giving errors...

2014-09-16 Thread Moemedi Ntunyane
I cleared cache and even restarted my tomcat server Moemedi Ntunyane Co-founder KeyInConsulting Date: Tue, 16 Sep 2014 06:09:43 +0200 Subject: Re: [Dhis2-devs] periodstructure giving errors... From: jason.p.picker...@gmail.com To: moemedi.ntuny...@hotmail.com CC: larshe...@gmail.com; dhis2-devs

Re: [Dhis2-devs] periodstructure giving errors...

2014-09-16 Thread Moemedi Ntunyane
Thanks, I was upgrading from 2.0.5 to 2.14. I can only see this error its not complaining of duplication but null value error: org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint. Moemedi Ntunyane Co-founder KeyInConsulting Date: T

Re: [Dhis2-devs] periodstructure giving errors...

2014-09-16 Thread Moemedi Ntunyane
Thanks a lot for your assistance, I just used a fresh database and imported meta data and the data itself eventhough other info was missing but managed to fix everything. Now its working ok on my local instance. Moemedi Ntunyane Co-founder KeyInConsulting From: knu...@gmail.com Date: Tue, 16