Re: [Dhis2-users] Cumulative Reporting?

2013-12-12 Thread Orvalho Augusto
was available through the > datamart. > > It would be good I think to have a "Cumulative Sum" operator which would > work similar to this over the time dimension in DHIS2, rather than having > to worry about these external methods. > > Regards, > Jason > > >

Re: [Dhis2-users] Cumulative Reporting?

2013-12-12 Thread Orvalho Augusto
Good idea Jason! I had a long time ago this issue. Number of cumulative ARV patiens or Number of cumulative patients on TB something. I wrote a R script which got data from the datavalue table rearanged it and produced a new table with the cumulatives. A table for each type of period. Then the rep

Re: [Dhis2-users] Fw: Results of eHealth Award - 10 winners

2013-08-25 Thread Orvalho Augusto
Weldone people. Congratulations! Caveman On Aug 23, 2013 10:27 AM, "denis adaletey" wrote: > Hi Folks, > This is Ghana's second achievment since the implementation of dhis2 in > less than 2 years! Lets all celebrate Ghana's success! > > Regards, > > *Denis Leonard Adaletey,* > -

Re: [Dhis2-users] WebAPI do not work.

2013-08-13 Thread Orvalho Augusto
This is nice to have. But please should be a way to prevent exposure to everything. Thanks Caveman On Tue, Aug 13, 2013 at 11:21 AM, Lars Helge Øverland wrote: > > We see that many people face the same issue and there isn't really any > "best-practice" solution to these light-weight "web page

Re: [Dhis2-users] [DHIS2-users] DHIS-live 2.12 problem

2013-06-21 Thread Orvalho Augusto
Hello Dear! First it is advisable to use 64 bits. But anyway we can use 32bit. Second do not mess up java in ubuntu using those enviroment settings; Use update-alternatives command. Check the doccumentation for that. In my experience the Linux kernel settings by default are fine. And the it is i

[Dhis2-users] MariaDB and DHIS2

2013-06-15 Thread Orvalho Augusto
I remember once in these beloved place someone mentioned something about MariaDB to replace MySQL. Is there anyone who ever tried? I know that many of us use PostgreSQL. Anyway, MariaDB will be replace MySQL soon at least for the Linux world as RedHat announced for the next version ( http://www.it

Re: [Dhis2-users] Problem with toucat7- DHIS2.11 - postgres

2013-06-10 Thread Orvalho Augusto
Yes! The connection pool software is saying that the connection is expiring. I have DHIS running with OpenJDK under 64bit. Can you try OpenJDK instead of the Oracle one? Caveman On Mon, Jun 10, 2013 at 12:30 PM, Saptarshi Purkayastha wrote: > I dont think its a 64-bit JVM issue. Its been in

Re: [Dhis2-users] [Dhis2-devs] Dhis 2.12 Installation error

2013-06-04 Thread Orvalho Augusto
generated. (ERROR: relation "analytics_2012" does not exist) from > "Reports->Analytics and Data Mart". > > Regards, > Jason > > > On Wed, Jun 5, 2013 at 5:55 AM, Orvalho Augusto wrote: > >> Thank you for this mail both of you. I have the same issue. &

Re: [Dhis2-users] Dhis 2.12 Installation error

2013-06-04 Thread Orvalho Augusto
Thank you for this mail both of you. I have the same issue. I have made a pgdum of the data from a cloud server using 2.10. I want to test 2.12. So I place that data on my laptop. I upgraded first to 2.11 and I saw this on the logs when trying to retrieve my old plots: Jun 5, 2013 5:26:13 AM org.

Re: [Dhis2-users] [Dhis2-devs] DHIS version 2.12 is released

2013-05-31 Thread Orvalho Augusto
Astonishing! Well done Caveman On Fri, May 31, 2013 at 12:47 PM, Lars Helge Øverland wrote: > Hi all, > > DHIS 2 version 2.12 is released. We have some great new features for you: > > > - All analysis tools are working against the analytics Web API. This means > that the system is no longer d

Re: [Dhis2-users] new web site

2013-05-31 Thread Orvalho Augusto
Humm... Looks nice! Thank you!!! Orvalho On Fri, May 31, 2013 at 10:57 AM, Lars Helge Øverland wrote: > Hi all, > > we have a new web site today. We have tried to present DHIS 2 and the > community in a more comprehensive way, give the site a modern look and have > it scale well on mobile devic

Re: [Dhis2-users] [Dhis2-devs] Troubles running datamart

2013-05-14 Thread Orvalho Augusto
gt;>> There is not suppose to be negative counting though. That is why it is >>> very necessary to have validation rules in place. >>> Sent from my BlackBerry® smartphone from Etisalat. Enjoy high speed >>> mobile broadband on our easyblaze and plans for BlackBerry.

Re: [Dhis2-users] Troubles running datamart

2013-05-14 Thread Orvalho Augusto
plans for BlackBerry. Visit > www.etisalat.com.ng for details. > ---------- > *From: * Orvalho Augusto > *Date: *Tue, 14 May 2013 12:49:39 +0200 > *To: *Ocaya Stephen > *Cc: *Dayo Adeyomoye; > Dhis2-users; > dhis1-users; DHIS 2 developers< > dhis

Re: [Dhis2-users] Troubles running datamart

2013-05-14 Thread Orvalho Augusto
One thing: Couldn't negative numbers trouble datamart? I do not know how people here count negatively! Orvalho On Tue, May 14, 2013 at 11:34 AM, Orvalho Augusto wrote: > Thank you! > > Yes those logs seemed to be clean. > > I can not run datamart now because it is a

Re: [Dhis2-users] Troubles running datamart

2013-05-14 Thread Orvalho Augusto
To View Log on the Fly, you could > > tail -f /var/logs/tomcat7/catalina.out (if the log file is in > /var/logs/tomcat7 path ... and the log file is catalina.out > > Thanks > > > On Tue, May 14, 2013 at 11:18 AM, Orvalho Augusto wrote: > >> OK! >> >> The log

Re: [Dhis2-users] Troubles running datamart

2013-05-14 Thread Orvalho Augusto
> > > > > On Tue, May 14, 2013 at 10:33 AM, Orvalho Augusto wrote: > >> Dears! >> >> Thank you for the answers. >> >> I have no text on value field according to this >> >> dhis2=# select * from datavalue where value is NULL; >> datae

Re: [Dhis2-users] Troubles running datamart

2013-05-14 Thread Orvalho Augusto
e and plans for BlackBerry. Visit > www.etisalat.com.ng for details. > > -Original Message- > From: Ocaya Stephen > Sender: "Dhis2-users" > > Date: Tue, 14 May 2013 10:22:45 > To: Orvalho Augusto > Cc: dhis1-users; DHIS 2 deve

[Dhis2-users] Troubles running datamart

2013-05-13 Thread Orvalho Augusto
Some organisationunities does not have data on reportting. I am using DHIS 2.10 under CentOS 6.3 64bit. The last log has this: * INFO 2013-05-14 07:54:38,130 Created indicator index: 0:23:21.391 (Clock.java [taskScheduler-1]) * INFO 2013-05-14 07:54:38,223 Aggregated data export done: 0:23:21.48

Re: [Dhis2-users] Migrating from MySQL to PostgreSQL

2013-05-08 Thread Orvalho Augusto
I understood your point and yes it is good to share what you have done. What worries me is you say "DHIS2 datamart ran faster on PostgreSQL 9.2". Your conditions are not the same for everyone. You did on Windows and most of DHIS are setup on Linux which is a quite different situation. You are wri

Re: [Dhis2-users] [Dhis2-devs] Migrating from MySQL to PostgreSQL

2013-05-07 Thread Orvalho Augusto
_writes = false > autovacuum = true > constraint_exclusion = partition > > > > --- > Regards, > Saptarshi PURKAYASTHA > > My Tech Blog: http://sunnytalkstech.blogspot.com > You Live by CHOICE, Not by CHANCE > > > On 7 May 2013 20:36, Orvalho Augusto wrote: >

Re: [Dhis2-users] [Dhis2-devs] Migrating from MySQL to PostgreSQL

2013-05-07 Thread Orvalho Augusto
Wow! Weldone! I do not have a huge database as yours. And yes I have migrated from MySQL to postgreSQL because I felt that the DHIS community does not support enough MySQL. Anyway getting back to your journey I must ask what means tunned MySQL or tunned PostgreSQL? What you tune might dictate the

Re: [Dhis2-users] [Dhis2-devs] Server specifications

2013-05-02 Thread Orvalho Augusto
gt; > Lars > > * > > > > > On Thu, May 2, 2013 at 2:01 PM, Bob Jolliffe wrote: > >> Hi Orvalho >> >> On 1 May 2013 15:07, Orvalho Augusto wrote: >> >>> It is true that hardware prices have decreased a lot. >>> >>>

Re: [Dhis2-users] [Dhis2-devs] Server specifications

2013-05-01 Thread Orvalho Augusto
It is true that hardware prices have decreased a lot. But for me it seems too excessive these recommendations. So I am wondering how we arrived to these recommendations. Would be nice if we share that. And for professional solutions it is not only one big machine you buy. You must have two. So wh

Re: [Dhis2-users] Metadata Export - Metada Import in DHIS2 Live

2013-04-18 Thread Orvalho Augusto
it? > > ** ** > > Many thanks for your help. > > ** ** > > Regards, > > Paulo > > ** ** > > *From:* Orvalho Augusto [mailto:orvaq...@gmail.com] > *Sent:* quinta-feira, 18 de Abril de 2013 08:21 > *To:* Paulo Grácio > *Cc:* Morten Ola

Re: [Dhis2-users] Fwd: Improving Tomcat memory parameters

2013-04-15 Thread Orvalho Augusto
Great!!! Needless to say on a 64bit machine. And are you usinge an enterprise kernel (from Red Hat Enterprise or CentOS one)? Thank you Caveman On Mon, Apr 15, 2013 at 9:38 AM, Knut Staring wrote: > This discussion can be of interest to DHIS2 administrators as well. > > -- Forwarded

Re: [Dhis2-users] DHIS version 2.11 is released

2013-03-22 Thread Orvalho Augusto
Weldone! Thank you Caveman On Fri, Mar 22, 2013 at 7:05 PM, Lars Helge Øverland wrote: > > Hi all, > > DHIS version 2.11 is out and we have some great features for you: > > > - Web-based pivot table: Allows you to create pivot tables with data > aggregated along all data dimensions, including d

Re: [Dhis2-users] data entry in the new year

2013-01-05 Thread Orvalho Augusto
t until january in Cauca we worked without problems with the data entry. >> >> But now when we try to enter any data it seems like it is loading the >> organization units, or the data sets and it doesn't work. >> >> We have installed the last versión. >> &

Re: [Dhis2-users] data entry in the new year

2013-01-04 Thread Orvalho Augusto
There is a major concern on this upgrade. As on the previous version Portuguese accents and cedilla are not well rendered. What can we do? Caveman On Thu, Jan 3, 2013 at 5:14 PM, Lars Helge Øverland wrote: > > Hi, > > there is a small snag in data entry module which becomes apparent in > Januar

Re: [Dhis2-users] MySQL logging and auditing

2012-12-30 Thread Orvalho Augusto
Thank you this is nice! By the way: Do someone have used MariaDB to replace MySQL? How it was? Caveman On Mon, Dec 31, 2012 at 8:56 AM, Saptarshi Purkayastha wrote: > Recently we wanted to add good logging to an DHIS2 implementation > While we used postgres in that instance, MySQL > out-of-the

Re: [Dhis2-users] DHIS 2 version 2.10 released

2012-11-16 Thread Orvalho Augusto
Well done! Great wor! Caveman On Nov 15, 2012 9:45 PM, "Lars Helge Øverland" wrote: > > Hi all, > > DHIS 2 version 2.10 has been released. The major features this time: > > - We have included elements from social networking: You can self-register > a user account, create your own profile, post m

Re: [Dhis2-users] need some help

2012-04-17 Thread Orvalho Augusto
That is tomcat screaming: I can not access TEMP folder. Are you using windows or linux. If linux check the permissions for the folder temp under tomcat folder, typically /opt/tomcat/: ls -l /opt/tomcat. >From windows wait for more clever guys. Hope it helps. Caveman On Tue, Apr 17, 2012 at 5:

Re: [Dhis2-users] Help Required

2011-10-28 Thread Orvalho Augusto
Good! Thanks Caveman On Fri, Oct 28, 2011 at 7:40 PM, Knut Staring wrote: > Caveman, we don't recommend windows for servers. > > Regards, Knut (via mobile phone) > On Oct 28, 2011 7:35 PM, "Orvalho Augusto" wrote: > >> Indeed is ngix is better for reverse

Re: [Dhis2-users] Help Required

2011-10-28 Thread Orvalho Augusto
Indeed is ngix is better for reverse proxy and a lot of more people start to use it. But I think there is not native ngix for windows so apache would fit for this. And I think is not good to edit files (on debian way) /etc/apache/mods-enabled. So on Docs we must change those reverse proxy settings

Re: [Dhis2-users] Help Required

2011-10-28 Thread Orvalho Augusto
And another recommendation is protect tomcat with Apache (configure it to work like reverse proxy). Somewhere on the tomcat docs they do recommend that too. Caveman On Fri, Oct 28, 2011 at 9:49 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Stephen, > Just one more important p

Re: [Dhis2-users] [Dhis2-devs] MySQL script for upgrading to DHIS version 2.3

2011-06-30 Thread Orvalho Augusto
I suggest to place -f option because not all the tables mentioned in the script are there. Caveman 2011/6/30 Lars Helge Øverland > One way of executing such a script is from the terminal: > > mysql database_name -u user -p < dhis-upgrade-2.3.sql > > > > If you get in trouble please tell us and

Re: [Dhis2-users] [Dhis2-devs] DHIS2 setup problem

2010-07-14 Thread Orvalho Augusto
Sorry if I insist... Have set the environment as system variable and as the user administrator? After the reboot check if it is being defined by opening de command prompt and run the command set Caveman On Wed, Jul 14, 2010 at 7:18 PM, Friedman, Roger (CDC/CGH/DGHA) (CTR) < r...@cdc.gov> wrote

Re: [Dhis2-users] [Dhis2-devs] DHIS2 setup problem

2010-07-14 Thread Orvalho Augusto
I am guessing, only... May be tomcat is running with a another username. So set DHIS2_HOME as a system variable. You must be logged as the administrator (NOT AN administrator must be THE administrator). You might try to place the on begging of startup.sh (on $CATALINA_HOME/bin) on the first line

Re: [Dhis2-users] DHIS2 setup problem

2010-07-11 Thread Orvalho Augusto
Good to move to DHIS2. And WELCOME!! I do not understand, do you have data in a DB (not in DHIS2 format) and you want to move that data to a DHIS2 format? And DHIS does not use ODBC. You must set the connection on: hibernate.properties On your instructions file step 2 has the file hibernate.pro