Re: [Dhis2-devs] No tables and No charts

2013-07-30 Thread Orvalho Augusto
server load in 2.12. > > Regards, > Jason > > > > On Tue, Jul 30, 2013 at 10:05 AM, Orvalho Augusto wrote: > >> I use apache as reverse proxy because this server has a lot more other >> applications besides DHIS. >> >> I used to place thes

Re: [Dhis2-devs] No tables and No charts

2013-07-30 Thread Orvalho Augusto
onfig related to your proxy? > > Also, do you have any upstream proxy which might be affecting this? In one > installation I did, the corporate proxy server was interfering with > requests to DHIS and we needed to exempt it. > > Regar > > > On Mon, Jul 29, 2013 a

Re: [Dhis2-devs] No tables and No charts

2013-07-29 Thread Orvalho Augusto
1212&filter=ou:RxI4QQCY37P[HTTP/1.1 404 Not Found 1ms] Which from here will never work from where I am. So I tried to access DHIS without Apache Proxy and Voila! So I have serious troubles with apache reverse proxying. But why is that? Thanks Caveman On Mon, Jul 29, 2013 at 1:28 PM, Orvalho

Re: [Dhis2-devs] No tables and No charts

2013-07-28 Thread Orvalho Augusto
s N from analytics_2013; year | n --+ 2011 |161 2012 | 821318 2013 | 279987 (3 rows) > - please also post your tomcat log contents after the process starts. > Those tomcat gossips are attached on the mail. They have targzipped. Lars > > > Thanks! Caveman > On Jul

[Dhis2-devs] Running DHIS 2.12 after migration

2013-06-28 Thread Orvalho Augusto
Dears! I had one DHIS 2.10 running fine on linode. But I had to migrate it to Maputo because of the price just moving a pg_dumped file. In Maputo I placed the same DHIS2 version. Then upgraded to DHIS 2.11 and then 2.12. I had run mrs datamart and the analytics. No erros were reported on the logs

[Dhis2-devs] 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-devs] Active Directory

2013-06-12 Thread Orvalho Augusto
Do you have any news about this? Thank you Caveman On Fri, Feb 22, 2013 at 1:33 PM, Bob Jolliffe wrote: > I can't find that old code. I'll try and resurrect (redo) it next week. > > On 20 February 2013 17:53, Bob Jolliffe wrote: > > On 20 February 2013 17:00, Lars Helge Øverland > wrote: >

[Dhis2-devs] Sending large bulks of data values by WebApi

2013-06-11 Thread Orvalho Augusto
I am trying to send datavalues through WebApi on some Yes/No fields. My script writes an xml file which is read by curl to POST it. I run this on the terminal: - curl -d @/tmp/comandos.xml "http://127.0.0.1:9080/dhis/api/dataValueSets?dryRun=true"; -H "Content-Type:application/xml" -u orva

Re: [Dhis2-devs] [Dhis2-users] 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-devs] [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-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-devs] [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-devs] [Dhis2-users] 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-devs] [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-devs] Data Browser by Datasets does not work

2013-05-14 Thread Orvalho Augusto
Thank you! Orvalho On Tue, May 14, 2013 at 1:40 PM, Lars Helge Øverland wrote: > Hi Orvalho, > > you are right, this must be a regression, I have opened a bug: > > https://bugs.launchpad.net/dhis2/+bug/1179905 > > Lars > > > On Sun, May 12, 2013 at 11:59 AM, Orv

Re: [Dhis2-devs] [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-devs] [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-devs] [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-devs] [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-devs] 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

[Dhis2-devs] Data Browser by Datasets does not work

2013-05-12 Thread Orvalho Augusto
I can not browse my data by dataset. It says "No data found". But I can by organisation units and dataelement groups. Nothing is said on the logs. I am using DHIS 2.10 with this selected specs: Version:2.10Build revision: 9121 Build date:2013-01-05 00:55User agent:Mozilla/5.0 (X11; Ubuntu; Linu

Re: [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-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-devs] [Dhis2-users] 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-devs] [Dhis2-users] 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-devs] [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-devs] DHIS-Live not working with Linux

2013-02-03 Thread Orvalho Augusto
exit > } > > echo "Starting DHIS2 live ..." > > DHIS2LIVE=`dirname $0` > java -jar $DHIS2LIVE/dhis2-live.jar || unexpected_exit > echo "DHIS2 live exited normally" > > > On 3 February 2013 07:20, Orvalho Augusto wrote: > > There

Re: [Dhis2-devs] DHIS-Live not working with Linux

2013-02-02 Thread Orvalho Augusto
There are two problems here: 1. The syntax to define a function. Can we check http://tldp.org/LDP/abs/html/functions.html 2. The character "-" is really trick when define functions with. I changed to this: #!/bin/bash # get ready to catch errors trap ctrl_c INT trap unexpected_exit ERR ctrl_c

[Dhis2-devs] Small request

2013-01-18 Thread Orvalho Augusto
Today I took some important minutes trying to deploy a dhis war file until I realize that is because the download was corrupted. So is it possible to provide on the download page the md5 of war file to help to check the integrity ? Caveman ___ Mailing l

Re: [Dhis2-devs] Reporting troubles

2013-01-08 Thread Orvalho Augusto
Yes! Thank you Caveman On Tue, Jan 8, 2013 at 1:00 AM, Bob Jolliffe wrote: > I think this problem is now solved. Related to not running datamart. > > On 7 January 2013 21:20, Orvalho Augusto wrote: > > We are fighting with DHIS 2.10. > > > > Today, we noticed that

[Dhis2-devs] Reporting troubles

2013-01-07 Thread Orvalho Augusto
We are fighting with DHIS 2.10. Today, we noticed that when we enter data on DHIS and we try to make a dataset report... DHIS brings empty values. On the report tables too we get empty cells too. What could be? Caveman ___ Mailing list: https://launch

Re: [Dhis2-devs] Troubles making reports

2013-01-07 Thread Orvalho Augusto
If you need custom reports I suggest you make queries against the > aggregateddatavalue/indicatorvalue tables and join with the appropriate > resource tables (they all start with an underscore): > > http://dhis2.org/doc/snapshot/en/user/html/ch18s06.html > > regards, > > Lars &

[Dhis2-devs] Troubles making reports

2013-01-06 Thread Orvalho Augusto
Sorry to disturb you guys! I have searched but I could not find a answer yet. When one builds a reporttable, where that reporttable is created. I need it to make a customized standard report. I am using DHIS 2.10. Caveman ___ Mailing list: https://laun

Re: [Dhis2-devs] Hierarchy manipulations

2012-12-27 Thread Orvalho Augusto
it is dangerous. Then I imported the metadata with orgunits sent by Bob yesterday. It seems to be working know Caveman On Tue, Dec 25, 2012 at 11:12 PM, Orvalho Augusto wrote: > I am using DHIS2 2.10. I exported the organisationunits from 2.6 as a > metadata. > > Now when I impor

[Dhis2-devs] Hierarchy manipulations

2012-12-25 Thread Orvalho Augusto
I am using DHIS2 2.10. I exported the organisationunits from 2.6 as a metadata. Now when I import it on 2.10 I see one province, and 2 health units from districts of that province appears duplicated in the organisation tree. I have checked for orphan and bad cycle organisationunits and is all OK

Re: [Dhis2-devs] Troubles with Accents in DHIS2.10

2012-12-23 Thread Orvalho Augusto
PM, Orvalho Augusto wrote: > Thank you!! > > Yes this new war file has some angelic actions. > Caveman > > > On Sat, Dec 1, 2012 at 5:29 PM, Morten Olav Hansen wrote: > >> Hi >> >> Can you try with the updated war from: >> http://dhis2.org/download/re

Re: [Dhis2-devs] Troubles with Accents in DHIS2.10

2012-12-01 Thread Orvalho Augusto
d be fixed now (it was fixed > a couple of days ago) > > -- > Morten > > > On Sat, Dec 1, 2012 at 4:28 PM, Orvalho Augusto wrote: > >> My organisationunits are not well stored. When I type a name with an >> accent or cedil DHIS stores on database something els

[Dhis2-devs] Troubles with Accents in DHIS2.10

2012-12-01 Thread Orvalho Augusto
My organisationunits are not well stored. When I type a name with an accent or cedil DHIS stores on database something else. Example: The province "Província de Cabo Delgado" (there is an acute accent on the first I) is stored like "Província de Cabo Delgado" on the database and it is shown with t

Re: [Dhis2-devs] [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-devs] A strange question

2011-12-26 Thread Orvalho Augusto
dar year). As I understand the indicators in data entry forms, they > inherit their periodicity from the dataset. What you want to do is mix > period types which is not currently supported AFAIK. > > -- > Sent from my mobile > On Dec 26, 2011 3:49 PM, "Orvalho Augusto" wrot

[Dhis2-devs] A strange question

2011-12-26 Thread Orvalho Augusto
I have a monthly entered form where there are fields to insert the cumulatives from the last month. Actually I will not allow none to fill it. I want to insert an indicator on the form with that info. How can I do? Thanks Caveman ___ Mailing list: https

Re: [Dhis2-devs] Using DHIS for a survey

2011-11-03 Thread Orvalho Augusto
DHIS2, but you may want to > consider other software (such as LimeSurvey, CSPro) for primary data > collection, followed by statistical analysis and cleaning, and finally, > export into the aggregate system. > > Just my two cents. > > Jason > > > On Thu, Nov 3, 2011 at 8:30

[Dhis2-devs] Using DHIS for a survey

2011-11-02 Thread Orvalho Augusto
I am making part of group that will collect data all over the country from a survey. There will be 3000 thousand HIV patients included on the sample. There are one big form with 10 pages and there is another for lab data. The study will take 6 months. The questions: 1. Can I use DHIS for this? C

Re: [Dhis2-devs] SQL erros when try to insert an organisationunit

2011-10-31 Thread Orvalho Augusto
that it has not been removed from your system however? I would remove > the foreign key constraint on source and see if this helps. > > Regards, > Jason > > > > On Mon, Oct 31, 2011 at 11:14 AM, Orvalho Augusto wrote: > >> I do not know how I still use t

Re: [Dhis2-devs] SQL erros when try to insert an organisationunit

2011-10-31 Thread Orvalho Augusto
Knut Staring wrote: > Inserting directly to the db? What are you using for the id? > > Regards, Knut (via mobile phone) > On Oct 31, 2011 9:49 AM, "Orvalho Augusto" wrote: > >> I have these errors when I insert an organisationunit: >> >> Caused by (java.

[Dhis2-devs] SQL erros when try to insert an organisationunit

2011-10-31 Thread Orvalho Augusto
I have these errors when I insert an organisationunit: Caused by (java.sql.SQLException): Field 'organisationunitid' doesn't have a default value - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) - com.mysql.j

Re: [Dhis2-devs] Multiple DHIS2 instances on Windows

2011-10-24 Thread Orvalho Augusto
Thanks I followed Jason solution in Nigeria editing dhis-support-external-**.jar It works. Caveman On Mon, Oct 24, 2011 at 10:02 AM, Orvalho Augusto wrote: > I am disoriented with this. So I have tried to set dhis2.home on web.xml > and the second war continues to use the DHIS

Re: [Dhis2-devs] Multiple DHIS2 instances on Windows

2011-10-24 Thread Orvalho Augusto
I am disoriented with this. So I have tried to set dhis2.home on web.xml and the second war continues to use the DHIS2_HOME. Setting tomcat to listen different ports means to waist machine resources that I do not have and the second instance will be used for tests. What is the recommendation now?

Re: [Dhis2-devs] Still having troubles after upgrade

2011-10-11 Thread Orvalho Augusto
This stills there. I have removed tomcat and reinstalled again... nothing. I am going to use 2.3 version. Caveman On Tue, Oct 11, 2011 at 1:36 PM, Knut Staring wrote: > Sometimes one also needs to clean out Tomcat's work directory > > On Tue, Oct 11, 2011 at 1:15 PM, Orvalho Au

Re: [Dhis2-devs] Still having troubles after upgrade

2011-10-11 Thread Orvalho Augusto
av Hansen" wrote: > >> Could it be that your DHIS 2.4 download was interrupted during >> download, and was corrupted? I would try and clean out webapps, and >> delete your war, and then re-download. >> >> -- >> Morten >> >> >> >> 2011/

Re: [Dhis2-devs] Still having troubles after upgrade

2011-10-11 Thread Orvalho Augusto
re-download. > > -- > Morten > > > > 2011/10/11 Orvalho Augusto : > > I have checked the permissions. Tomcat is run by tomcat6:tomcat6 user. > And > > tomcat home is /var/lib/tomcat6 which has these permissions: > > drwxr-xr-x 24 tomcat6 tomcat6 4.0K 201

Re: [Dhis2-devs] Still having troubles after upgrade

2011-10-11 Thread Orvalho Augusto
No! I am using the DHIS2 (not live) under Linux (Ubuntu 10.04 LTS) Caveman 2011/10/11 Knut Staring > Are you using Tomcat or DHIS2 Live? On Windows 7? > > 2011/10/11 Lars Helge Øverland : > > Hi Orvalho, > > > > it seems you are starting DHIS from a location on the file system > > where you do

[Dhis2-devs] Still having troubles after upgrade

2011-10-11 Thread Orvalho Augusto
May be I am not doing this well. As I toid you yesterday I am moving from 2.2 to 2.4. Now my forms does not appears. I copied and made paste on "Data Entry Form Management". When I try dataentry the form appears but my old data does not appear there and dataset report is not being generated too.

Re: [Dhis2-devs] DHIS2 migration

2011-10-10 Thread Orvalho Augusto
Thanks! I permited the admin user the MoH orgunit and he can enter data. Your are magicians. But the dataset report and on the others I have to click twice on organization unit (:-)). Thanks for the patience Caveman 2011/10/10 Lars Helge Øverland > Hi Caveman, > > make sure all users are a

Re: [Dhis2-devs] DHIS2 migration

2011-10-10 Thread Orvalho Augusto
n, Oct 10, 2011 at 11:01 AM, Orvalho Augusto wrote: > >> I moving data from one server to another. So I just copied the dumped >> MySQL database to the new server. >> >> And I have downloaded the new version of DHIS (2.4); Before it was 2.2. >> >> DHIS starts

[Dhis2-devs] DHIS2 migration

2011-10-10 Thread Orvalho Augusto
I moving data from one server to another. So I just copied the dumped MySQL database to the new server. And I have downloaded the new version of DHIS (2.4); Before it was 2.2. DHIS starts and I can login. But my Health Centers can not access the forms to insert data. I have manually place the htm

Re: [Dhis2-devs] Stored procedure to remove the foreign key 'sourceid'

2011-07-01 Thread Orvalho Augusto
This is nice!!! But it would be good if add a parameter for to select the DHIS database. Anyway for MySQL people they can understand where to correct. Thanks Caveman On 7/1/11, Hieu Dang Duy wrote: > Hello all, > > I have written down a stored procedure to remove all of the foreign keys > whic

Re: [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

[Dhis2-devs] Pie plot options

2011-06-29 Thread Orvalho Augusto
Sorry if I sound to bad. Under the charts I thing we miss some thing like this: 1. The pies should have their own options not the bar ones there. Some could be: hide legend, labels to be added on the plot By the way under Pie Chart If you choose Hide Legend DHIS sream on the logs with * ERROR 21:

Re: [Dhis2-devs] Combobexes/Selects and dataelements

2011-06-29 Thread Orvalho Augusto
Thanks! It works like a charm. Some told that "DHIS people a very special and odd magicians!" Caveman 2011/6/29 Lars Helge Øverland > That happens automatically, see for instance PHUF 4 form at the demo: > > demo.dhis2.org > > > > > 2011/6/29 Orvalho Augus

Re: [Dhis2-devs] Combobexes/Selects and dataelements

2011-06-29 Thread Orvalho Augusto
When used in data > sets/forms they give you a drop down with "no value", "no", "yes" as > options. > > 2011/6/29 Orvalho Augusto > >> For example a checkbox. I have one form where I have to place an yes >> or no dataelement. (Is a

Re: [Dhis2-devs] Combobexes/Selects and dataelements

2011-06-29 Thread Orvalho Augusto
e Øverland wrote: > Hi Caveman, > > can you elaborate a bit here? > > Lars > > > On Tue, Jun 28, 2011 at 8:40 AM, Orvalho Augusto wrote: > >> Hello is it possible to such things like combobox/select or even check >> boxes. >> >> If yes please

Re: [Dhis2-devs] DHIS 2.2 and dataset report

2011-06-29 Thread Orvalho Augusto
and we will have a look. > > Lars > > > On Mon, Jun 20, 2011 at 12:59 AM, Orvalho Augusto wrote: > >> When I try to use Dataset report with DHIS2.2 I get a line like >> ccr_aleitaart NaN >> >> All the values come NaN. >> >> For the period and or

Re: [Dhis2-devs] Sql view does not excute my SQL

2011-06-28 Thread Orvalho Augusto
stgres. > > Sent from my HTC > > - Reply message - > From: "Hieu Dang Duy" > Date: Mon, Jun 27, 2011 23:02 > Subject: [Dhis2-devs] Sql view does not excute my SQL > To: "Orvalho Augusto" > Cc: "Jason Pickering" , "DHIS 2 developers&

[Dhis2-devs] Combobexes/Selects and dataelements

2011-06-27 Thread Orvalho Augusto
Hello is it possible to such things like combobox/select or even check boxes. If yes please can someone tell me or point to the right doc? Caveman ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscri

Re: [Dhis2-devs] Sql view does not excute my SQL

2011-06-27 Thread Orvalho Augusto
Under MySQL there is one problem. In mysql we call a stored procedure like this: call storedprocedure(); And this SQLview just allow SELECT as the first word. Any ideias? Caveman On Mon, Jun 27, 2011 at 1:33 PM, Orvalho Augusto wrote: > Really thanks for this advice! > > Caveman >

Re: [Dhis2-devs] Sql view does not excute my SQL

2011-06-27 Thread Orvalho Augusto
t;> one in your db. But there is a validation on checking the given name (from >> input). If there is any special symple/characters then they will be remove >> before view created. Sorry for this inconvenient. >> >> >> On Mon, Jun 27, 2011 at 3:28 PM, Orvalho Augusto &g

Re: [Dhis2-devs] Sql view does not excute my SQL

2011-06-27 Thread Orvalho Augusto
I know now why the Querry does not show UP: I gave the name "Missings_from_old_system" under DHIS. And DHIS created the following view _view_Missingsfromoldsystem". So the "_" is eaten! I reacreated with another name without "_" and it is working. Caveman

Re: [Dhis2-devs] Sql view does not excute my SQL

2011-06-27 Thread Orvalho Augusto
S `count(*)` from > `datavalue` where (`datavalue`.`value` = 'NA') > > Next to see your result you must click on "Execute query" button first and > then see by "View" button. > > *Notes*: The second way is the best choise for your case because we don&#

[Dhis2-devs] Sql view does not excute my SQL

2011-06-25 Thread Orvalho Augusto
I have this simply query: -- select * from v_omissos -- The v_omissos is a view for: CREATE OR REPLACE VIEW v_omissos AS select '999' AS `OLDMISSCODE`, count(0) AS `contagem` from `datavalue` where (`datavalue`.`value` = '999') union all select '' AS `OLDMISSCODE`,count(0) AS `count(*)` from

Re: [Dhis2-devs] Custom periods question

2011-06-25 Thread Orvalho Augusto
e occurs entirely outside of DHIS but was the easiest way > for me to do this. > > Regards, > Jason > > > > > > > Sent from my HTC > > > - Reply message - > From: "Orvalho Augusto" > Date: Thu, Jun 23, 2011 12:37 > Subject: [Dhis2

[Dhis2-devs] Custom periods question

2011-06-23 Thread Orvalho Augusto
I using DHIS 2.2 and I have been requested to produce a semianual report and quarter report starting the year from October. Is there any way I could set up such? Another strange thing: Is there a way to set two period parameter under a report table or graph? One for starting period and other as e

[Dhis2-devs] DHIS 2.2 and dataset report

2011-06-19 Thread Orvalho Augusto
When I try to use Dataset report with DHIS2.2 I get a line like ccr_aleitaart NaN All the values come NaN. For the period and orgunit I have chosen I have data. No error on the screen neither in the logs I am using DHIS 2.2 stable (build 3434). Caveman

Re: [Dhis2-devs] Troubles when generate a report in DHIS 2

2011-06-17 Thread Orvalho Augusto
, 2011 at 10:13 PM, Orvalho Augusto wrote: > Thanks! > > I downloaded from the DHIS 2 (2.2) site last month. > > The database has been created by DHIS war by placing this: > > hibernate.dialect = org.hibernate.dialect.MySQLDialect > hibernate.connection.driver_class

Re: [Dhis2-devs] Troubles when generate a report in DHIS 2

2011-06-16 Thread Orvalho Augusto
create your database? > > > On Thu, Jun 16, 2011 at 9:50 PM, Orvalho Augusto wrote: > >> So I should delete the source table? >> >> Caveman >> >> >> On Thu, Jun 16, 2011 at 9:46 PM, Knut Staring wrote: >> >>> It looks as though you ar

Re: [Dhis2-devs] Troubles when generate a report in DHIS 2

2011-06-16 Thread Orvalho Augusto
So I should delete the source table? Caveman On Thu, Jun 16, 2011 at 9:46 PM, Knut Staring wrote: > It looks as though you are using a recent build with an old database, as I > think the Source table has now been removed. > > On Thu, Jun 16, 2011 at 9:25 PM, Orvalho Augusto wrot

[Dhis2-devs] Troubles when generate a report in DHIS 2

2011-06-16 Thread Orvalho Augusto
I am converting data from a NGO in Mozambique to DHIS 2. I moved one dataset to test DHIS. I dit not tune tomcat neither MySQL yet. When we generate reports we get this error on the browser and on the logs: org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: org.h

[Dhis2-devs] Data integrity check with troubles

2010-08-31 Thread Orvalho Augusto
When I run data integrity check on my database I get this on the logs and on the browser it shows that interesting message: "Please wait while the system is processing...". I waited for more that a hour!!! And nothing. My DHIS is 2.0.5 the beta from the last week. Yes I am on MySQL.

Re: [Dhis2-devs] dhis14 import

2010-07-20 Thread Orvalho Augusto
I am really impressed with that news. Caveman On Tue, Jul 20, 2010 at 3:23 PM, Bob Jolliffe wrote: > Just some throwaway code testing out jackcess for reading dhis14 (and > potentially modulo basico files): > > http://pastebin.com/wMv1SZqq > > I'm pretty impressed. It works well and I suspect

Re: [Dhis2-devs] Aggregating values

2010-07-15 Thread Orvalho Augusto
more information on this. > > > Regards, > JPP > > > > On Wed, Jul 14, 2010 at 8:43 PM, Orvalho Augusto wrote: > >> Is all I have on the logs. >> >> The thing it never finishs to run the creation of the organisation >> structure. And when I check MyS

Re: [Dhis2-devs] Aggregating values

2010-07-14 Thread Orvalho Augusto
Pickering < jason.p.picker...@gmail.com> wrote: > No need for medical help. I have had many of these sorts of problems as > well, so you are not alone. > > Can you post the log when you begin the aggregation process? > > > Regards, > Jason > > > On Wed, Jul 14,

Re: [Dhis2-devs] Aggregating values

2010-07-14 Thread Orvalho Augusto
; .... > > When you replaced the DHIS war file, did you also remove the dhis directory > (rm -rf dhis) ? > > Regards, > Jason > > > > > On Wed, Jul 14, 2010 at 6:24 PM, Orvalho Augusto wrote: > >> I am saying the truth. >> >> This is what I have o

Re: [Dhis2-devs] [Dhis2-users] 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-devs] Aggregating values

2010-07-14 Thread Orvalho Augusto
t and we may be able to help. > > > Let me know if something is not clear. > > Regards, > Jason > > > > On Wed, Jul 14, 2010 at 4:40 PM, Orvalho Augusto wrote: > >> There is nothing being logged. >> >> There are no views. >> >> Caveman &g

Re: [Dhis2-devs] Aggregating values

2010-07-14 Thread Orvalho Augusto
he datamart/report table > process? > > Do you have any external views that are linked to the report table you > are attempting to aggregate? > > Regards, > Jason > > > On Wed, Jul 14, 2010 at 8:57 AM, Orvalho Augusto > wrote: > > And even do those resource

Re: [Dhis2-devs] [Dhis2-users] 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-devs] Aggregating values

2010-07-13 Thread Orvalho Augusto
And even do those resource tables on Postgres it does not aggregate. Caveman On Wed, Jul 14, 2010 at 6:35 AM, Orvalho Augusto wrote: > I have changed the database (from MySQL to Postgres)... and used DHIS tools > to export and import the data. > > Well, those resource tables are be

Re: [Dhis2-devs] Aggregating values

2010-07-13 Thread Orvalho Augusto
the dataelementids is: The entering forms does not work no more. We have to redesign the forms after an import. Caveman On Tue, Jul 13, 2010 at 10:28 PM, Orvalho Augusto wrote: > Ok. > > > On Tue, Jul 13, 2010 at 11:55 AM, Bob Jolliffe wrote: > >> On 13 July 2010 07:17, O

Re: [Dhis2-devs] Aggregating values

2010-07-13 Thread Orvalho Augusto
Ok. On Tue, Jul 13, 2010 at 11:55 AM, Bob Jolliffe wrote: > On 13 July 2010 07:17, Orvalho Augusto wrote: > > I recompiled DHIS2.05 yesterday with help of a magician Jason yesterday. > And > > the first thing I tried was this aggregation thing. > > > > So I starte

Re: [Dhis2-devs] Old BIRT reports not seen on DHIS2.05

2010-07-13 Thread Orvalho Augusto
hether DHIS2 is running. This is really just to check to be sure that > BIRT is functioning properly. Also, you must have the exact same BIRT > run time that you used to design the reports with. BIRT is very picky > about versions. > > Regards, > Jason > > > On Tue, Jul 13,

[Dhis2-devs] Old BIRT reports not seen on DHIS2.05

2010-07-13 Thread Orvalho Augusto
Hi We had BIRT reports running on DHIS2.04, we are moving to 2.05 and we can find our reports. One note: Our reports does not use the report table generated by DHIS. What is happening? Logs does not have anything related to report. Caveman ___ Mailing

Re: [Dhis2-devs] Aggregating values

2010-07-12 Thread Orvalho Augusto
g orgunit level names. > > Regards, > Jason > > > 2010/7/12 Lars Helge Øverland : > > Generating any of the resource tables don't affect the aggregation / > > report tables... > > > > > > > > On Sun, Jul 11, 2010 at 5:36 PM, Orvalho Augusto >

Re: [Dhis2-devs] Aggregating values

2010-07-12 Thread Orvalho Augusto
0/7/12 Orvalho Augusto : > > Thanks!! > > > > That of restoring a database of huge size is not everyday you do. > > > > Well that depends :-) > > > I need people with databases of Postgres with sizes above 5GB. And tell > us > > how their postgre

Re: [Dhis2-devs] Aggregating values

2010-07-12 Thread Orvalho Augusto
ever takes more than minutes). > > cheers, Lars > > > > 2010/7/12 Orvalho Augusto : > > I need to have a repo/table that aggregates data as I asked before. I did > > not find it on docs. > > > > Someone told me that can happens if a generate those resource t

Re: [Dhis2-devs] Aggregating values

2010-07-12 Thread Orvalho Augusto
ask what I should do? Caveman 2010/7/12 Lars Helge Øverland > Generating any of the resource tables don't affect the aggregation / > report tables... > > > > On Sun, Jul 11, 2010 at 5:36 PM, Orvalho Augusto > wrote: > > Thanks!!! > > > > Caveman

Re: [Dhis2-devs] Aggregating values

2010-07-12 Thread Orvalho Augusto
me. I am get a sensation that the DHIS community is abandoning MySQL support. Is it that true? Caveman On Sun, Jul 11, 2010 at 9:28 PM, Orvalho Augusto wrote: > I did not have success. My logs are: > > === > * ERROR 21:24:

Re: [Dhis2-devs] [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

Re: [Dhis2-devs] Aggregating values

2010-07-11 Thread Orvalho Augusto
generated the resource tables, > namely "orgunitstructure". Consult the documentation for more details > on how to generate these tables. > > Regards, > Jason > > > On Sun, Jul 11, 2010 at 4:27 PM, Orvalho Augusto > wrote: > > I have a dataelement coll

Re: [Dhis2-devs] Aggregating values

2010-07-11 Thread Orvalho Augusto
these tables. > > Regards, > Jason > > > On Sun, Jul 11, 2010 at 4:27 PM, Orvalho Augusto > wrote: > > I have a dataelement collected at a Health Centre level (eg: ats_posfem) > in > > one province and only in some particular districts. In unpredictible > fu

[Dhis2-devs] Aggregating values

2010-07-11 Thread Orvalho Augusto
I have a dataelement collected at a Health Centre level (eg: ats_posfem) in one province and only in some particular districts. In unpredictible future at National level we will be collecting on every health centre. Now, my ignorance: How can I obtain the provincial total on Report Table? I have b

  1   2   >