Re: [Dhis2-devs] On categories and dimensions and zooks

2009-09-29 Thread Bob Jolliffe
2009/9/29 Abyot Gizaw > > > On Tue, Sep 29, 2009 at 9:16 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> I think Abyot raises some good points, especially his last one about >> differenences of what the age dimension really is. >> >> I think the biggest challenge is going to be h

Re: [Dhis2-devs] On categories and dimensions and zooks

2009-09-29 Thread Bob Jolliffe
2009/9/29 Jason Pickering > I think Abyot raises some good points, especially his last one about > differenences of what the age dimension really is. > > I think the biggest challenge is going to be how to unite the concepts > of a multidimensional data element (as it is currently implemented > w

Re: [Dhis2-devs] On categories and dimensions and zooks

2009-09-29 Thread Bob Jolliffe
Hi 2009/9/29 Abyot Gizaw > Yes your suggestion is doable and less is better but I think the > requirement from the field is more complex. > > If, for a moment, we stop talking about datavalues and talk about > dataelements - why are we talking about dimension combinations? > > Because you a

Re: [Dhis2-devs] On categories and dimensions and zooks

2009-09-29 Thread Abyot Gizaw
On Tue, Sep 29, 2009 at 9:16 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > I think Abyot raises some good points, especially his last one about > differenences of what the age dimension really is. > > I think the biggest challenge is going to be how to unite the concepts > of a multi

Re: [Dhis2-devs] On categories and dimensions and zooks

2009-09-29 Thread Jason Pickering
I think Abyot raises some good points, especially his last one about differenences of what the age dimension really is. I think the biggest challenge is going to be how to unite the concepts of a multidimensional data element (as it is currently implemented with categories) and a data element that

Re: [Dhis2-devs] On categories and dimensions and zooks

2009-09-29 Thread Abyot Gizaw
Yes your suggestion is doable and less is better but I think the requirement from the field is more complex. If, for a moment, we stop talking about datavalues and talk about dataelements - why are we talking about dimension combinations? Because you are assuming a dataelement to have only o

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 803: Typo corrected.

2009-09-29 Thread noreply
revno: 803 committer: Jan Henrik Overland janhenrik.overl...@gmail.com branch nick: trunk timestamp: Tue 2009-09-29 19:24:58 +0200 message: Typo corrected. modified: dhis-2/dhis-web/dhis-web-mapping/src/main/webapp/dhis-web-mapping/m

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 802: (GIS) Removed the non-functional preview button. Double click a grid row to preview layers.

2009-09-29 Thread noreply
revno: 802 committer: Jan Henrik Overland janhenrik.overl...@gmail.com branch nick: trunk timestamp: Tue 2009-09-29 18:26:11 +0200 message: (GIS) Removed the non-functional preview button. Double click a grid row to preview layers. mod

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 801: (GIS) New source type (shapefiles) introduced. Lets you connect your Geoserver and its shapefiles...

2009-09-29 Thread noreply
revno: 801 committer: Jan Henrik Overland janhenrik.overl...@gmail.com branch nick: trunk timestamp: Tue 2009-09-29 18:17:58 +0200 message: (GIS) New source type (shapefiles) introduced. Lets you connect your Geoserver and its shapefil

Re: [Dhis2-devs] DHIS 2 Documentation

2009-09-29 Thread Jason Pickering
Hi Jens and others, I have added a bit more detail to the document about how to create documentation. I am attaching a PDF file along with this email. As you can see, we still need to do a bit of work on rendering the PDF doucment properly (URLs are not rendered as they should be) but otherwise, I

Re: [Dhis2-devs] Use liquibase to deal with database changes and tosimplify DHIS update process?

2009-09-29 Thread sunbiz
Openmrs started using liquibase because these database scripts were taken from mysqldump and could not b used with other dbms many times. Liquibase makes it kind of database independent. Don't get me wrong I really love liquibase, but it also adds some xml overhead and small but learning curve.

Re: [Dhis2-devs] Use liquibase to deal with database changes and tosimplify DHIS update process?

2009-09-29 Thread Ola Hodne Titlestad
2009/9/29 > I had tutored one student nishtha who was learning java to implement these > beautiful looking setup screens of openmrs. > > So I know its quite simple to inplement and applying updates works quite > out of the box in liquibase. Though I don't fully understand why we want to > use it

Re: [Dhis2-devs] [Bug 438623] Re: Expression does not appear when click select button

2009-09-29 Thread Thuy
Hi, I'm really sorry. I changed it from new to invalid as well. On Tue, Sep 29, 2009 at 5:22 PM, Tran Thanh Tri wrote: > Pls check, i so tired. Do you see one button [<], pls click there > > Tran Thanh Tri > HISP Viet Nam > Cell phone: +84903670967 > Websit

Re: [Dhis2-devs] Use liquibase to deal with database changes and tosimplify DHIS update process?

2009-09-29 Thread sunbiz
I had tutored one student nishtha who was learning java to implement these beautiful looking setup screens of openmrs. So I know its quite simple to inplement and applying updates works quite out of the box in liquibase. Though I don't fully understand why we want to use it in dhis. Sent from

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 802: dhis-web-portal/pom.xml

2009-09-29 Thread Lars Helge Øverland
Reverted trunk back to revision 800 as requested by Tri. On Tue, Sep 29, 2009 at 12:51 PM, wrote: > > revno: 802 > committer: Tran Thanh Tri > branch nick: trunk > timestamp: Tue 2009-09-29 17:27:29 +0700 > message: > dhis-web-port

Re: [Dhis2-devs] Use liquibase to deal with database changes and to simplify DHIS update process?

2009-09-29 Thread Lars Helge Øverland
On Tue, Sep 29, 2009 at 12:54 PM, Bob Jolliffe wrote: > I agree the new openmrs installation and update process is very slick. > Does anyone have the time to investigate further how we might apply > something similar. Student project? > > Sorry deadline for submitting student projects was yesterd

Re: [Dhis2-devs] Use liquibase to deal with database changes and to simplify DHIS update process?

2009-09-29 Thread Bob Jolliffe
I agree the new openmrs installation and update process is very slick. Does anyone have the time to investigate further how we might apply something similar. Student project? Cheers Bob 2009/9/29 Ola Hodne Titlestad > Here is a screen shot to give you an illustration of what a database update

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 802: dhis-web-portal/pom.xml

2009-09-29 Thread noreply
revno: 802 committer: Tran Thanh Tri branch nick: trunk timestamp: Tue 2009-09-29 17:27:29 +0700 message: dhis-web-portal/pom.xml modified: dhis-2/dhis-options/src/main/java/org/hisp/dhis/options/SystemSettingManager.java dhis-2/d

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 801: Re-factoried Preview Report function in Excel Reporting module more suitable

2009-09-29 Thread noreply
revno: 801 committer: hieu branch nick: trunk timestamp: Tue 2009-09-29 17:11:31 +0700 message: Re-factoried Preview Report function in Excel Reporting module more suitable added: dhis-2/dhis-web/dhis-web-excel-reporting/src/main/ja

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 800: minor-fix

2009-09-29 Thread noreply
revno: 800 committer: brajesh2mur...@gmail.com branch nick: trunk timestamp: Tue 2009-09-29 15:12:30 +0530 message: minor-fix added: dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/webapp/dhis-web-mainten

Re: [Dhis2-devs] [Bug 438623] Re: Expression does not appear when click select button

2009-09-29 Thread Tran Thanh Tri
Pls check, i so tired. Do you see one button [<], pls click there Tran Thanh Tri HISP Viet Nam Cell phone: +84903670967 Website: http://tringuyenvn.com 2009/9/29 Thuy > This bug only appear when I create new report item wh

Re: [Dhis2-devs] On categories and dimensions and zooks

2009-09-29 Thread Bob Jolliffe
Hi On the back of Jason and others comments, I've reached the conclusion that we cannot really live with the MD model the way it is. Whereas I think it is (just about) workable there are some serious optimizations we can and should do. I am going to put my other work back a day or two and propos

[Dhis2-devs] Use liquibase to deal with database changes and to simplify DHIS update process?

2009-09-29 Thread Ola Hodne Titlestad
Hi, OpenMRS uses a tool called Liquibase (http://www.liquibase.org/) to take care of database changes on application startup. The tool keeps track of all changes to the database and updates the local database when starting up the application. The tools also helps to allow users to create a new dat

[Dhis2-devs] [Bug 438623] Re: Expression does not appear when click select button

2009-09-29 Thread Thuy
This bug only appear when I create new report item which after I create organization report item. ** Changed in: dhis2 Status: New => Invalid -- Expression does not appear when click select button https://bugs.launchpad.net/bugs/438623 You received this bug notification because you are a

[Dhis2-devs] [Bug 438623] [NEW] Expression does not appear when click select button

2009-09-29 Thread Thuy
Public bug reported: When create new report item. The expression doesn't appear after choose data element > default > click select button. ** Affects: dhis2 Importance: Undecided Assignee: Tran Thanh Tri (tranthanhtri84) Status: Invalid ** Changed in: dhis2 Assignee: (una

Re: [Dhis2-devs] On categories and dimensions and zooks

2009-09-29 Thread Lars Helge Øverland
> > Thanks for the explanations Jason. The multidimensional model is quite > complicated, is poorly documented, and as you say is DHIS-centric in the way > that it is built around the DHIS notion of a Data Element. > > Could we assemble and put some of the text being written on the list to docbook?

Re: [Dhis2-devs] [Bug 436692] Re: Blanks are displayed as 0 in report

2009-09-29 Thread Ola Hodne Titlestad
2009/9/29 Jason Pickering > > Yes there is a slight inconsistency here. Still, I think this is as good > as > > we get it. Remember that we (in most cases, except for "average" > > dataelements) don't store 0s in the raw datavalue table. This means that > the > > 0s you would get in the agg.datav

Re: [Dhis2-devs] [Bug 436692] Re: Blanks are displayed as 0 in report

2009-09-29 Thread Jason Pickering
> Yes there is a slight inconsistency here. Still, I think this is as good as > we get it. Remember that we (in most cases, except for "average" > dataelements) don't store 0s in the raw datavalue table. This means that the > 0s you would get in the agg.datavalue table would represent blanks anyway

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 799: minor fix

2009-09-29 Thread noreply
revno: 799 committer: brajesh2mur...@gmail.com branch nick: trunk timestamp: Tue 2009-09-29 13:52:30 +0530 message: minor fix modified: dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/resources/META-INF/d

Re: [Dhis2-devs] [Bug 436692] Re: Blanks are displayed as 0 in report

2009-09-29 Thread Lars Helge Øverland
> OK, but then I would think that zeros should also be written to the > aggregatedatavalue table as well ? > > If the aggregated numerator shows up as the numerator in the > aggregatedindicatorvalue table as zero (but not blank) but does not > show up at all in the aggregateddatavalue table at all

Re: [Dhis2-devs] [Bug 436692] Re: Blanks are displayed as 0 in report

2009-09-29 Thread Jason Pickering
> > > OK. That's where the mentioned system setting comes in ("Omit indicator > values with zero numerator value"). The difference between the 0s in the > agg.datavalue table and the 0s you mention in the agg.indicatorvalue is that > the lattter has a non-0 denominator value. (Entries with 0 denomi

Re: [Dhis2-devs] [Bug 436692] Re: Blanks are displayed as 0 in report

2009-09-29 Thread Lars Helge Øverland
> > returns 70. I am missing two districts, who reported nothing. I think > this is the behaviour you a mentioning, namely that zeroes (or blanks) > should not be written to the data mart? > Yes. > > However, for the aggregateindicatorvalue table, blanks are written to > the table as zeroes. > >

Re: [Dhis2-devs] help with the query

2009-09-29 Thread Jason Pickering
OK, so does this work on both databases (when connected to each on seperately?) There is no need to reference the database itself (dhis2 or dhis2_znmay) when you are connected to the database itself. SELECT pivotsource_indicator_ou4.indicator, pivotsource_indicator_ou4.orgunit1, pivotsource_indi

Re: [Dhis2-devs] help with the query

2009-09-29 Thread Yusuph Kassim
I am having each database with its own connection. I actually tried to create direct from the ODBC connection and also tried to create the connection as I was creating the query, but both ways gives me the same error. On Tue, Sep 29, 2009 at 10:00 AM, Jason Pickering < jason.p.picker...@gmail.com>

Re: [Dhis2-devs] help with the query

2009-09-29 Thread Yusuph Kassim
Hi bob, thanks for the response, I am using two different odbc datasource. one for the dhis2 and the other the znzMay database. On Tue, Sep 29, 2009 at 9:59 AM, Bob Jolliffe wrote: > Hi Yusuph > > I haven't got excel to cross-check but I wonder if you are still > "connected" to dhis2 database w

Re: [Dhis2-devs] help with the query

2009-09-29 Thread Jason Pickering
On Tue, Sep 29, 2009 at 8:53 AM, Yusuph Kassim wrote: > this is the query that doesnt work > SELECT pivotsource_indicator_ou4.indicator, > pivotsource_indicator_ou4.orgunit1, pivotsource_indicator_ou4.ou1, > pivotsource_indicator_ou4.orgunit2, pivotsource_indicator_ou4.ou2, > pivotsource_indicator

Re: [Dhis2-devs] help with the query

2009-09-29 Thread Bob Jolliffe
Hi Yusuph I haven't got excel to cross-check but I wonder if you are still "connected" to dhis2 database when you try to make the query to the other one. Is that how it works? You first setup a datasource then execute a query on it. If you just change the query you would then get this error. Y