Re: [Dhis2-devs] dhis2 2.13 pivot table organization unite wise reporting bug in boriwser

2015-02-23 Thread Uddin Fatema
Dear Lars, Usually pivot table is working fine but when i am creating a new pivot table by organization unit wise. the steps are given bellow. Select a group of dataelemnt, and period 2014, select organization unit group (community clinic), den select organization unite. press update(Till this po

Re: [Dhis2-devs] Data capture and maintenance organisation units

2015-02-23 Thread Lars Helge Øverland
Hi Lungo, go to apps > settings > general > set max offline org unit levels to something lower. regards, Lars On Mon, Feb 23, 2015 at 9:00 AM, Juma Lungo wrote: > Dear all > > Please advise on how to improve loading of the "Data capture and > maintenance organisation units" list when adding/

Re: [Dhis2-devs] Analytics table dimensions contain duplicates: ["uidlevel3", "uidlevel4"] DHIS2 v2.17

2015-02-23 Thread Lars Helge Øverland
Hi Pierre, check the organisationunitlevel table and if the level column are continuous and has no duplicates. select * from orgunitlevel order by level; regards, Lars ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-23 Thread Emma Kassy
Hi Channara, The data element should be assigned to a different data set. In other wards, you can have the same data element but in different data sets. That way you will not have an error. On Mon, Feb 23, 2015 at 8:13 AM, channara rin wrote: > Hi all DHIS2, > I wonder can i make aggregation que

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-23 Thread channara rin
I did like that, but wonder has error. Let me try another data element first, i will inform you soon... Thank you Channara On Mon, Feb 23, 2015 at 4:48 PM, Emma Kassy wrote: > Hi Channara, > The data element should be assigned to a different data set. > In other wards, you can have the same dat

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-23 Thread channara rin
seem another data element is OK, but why only that data element meet error? s.th wrong with it? any one tell me? Thank you Channara On Mon, Feb 23, 2015 at 4:53 PM, channara rin wrote: > I did like that, but wonder has error. Let me try another data element > first, i will inform you soon... >

Re: [Dhis2-devs] SMS Not finding Users Associated with Phones

2015-02-23 Thread Lars Helge Øverland
The significant log part is this: WARN 2015-02-17 18:04:46,179 Cannot get users with disjoint roles as user does not have any user roles Try to give the dhis user at least one user role. Lars ___ Mailing list: https://launchpad.net/~dhis2-devs Post to

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-23 Thread Tran Chau (HISP Vietnam)
Hi Channara, No, we cannot define aggregation query builder for the same data element with different organisation units. Organisation unit is not required in one aggregate query builder formula. When these formulas is run automatically, the system will get tracker data from orgunits and generate

[Dhis2-devs] dhis2 2.18 upgrade - Event Capture and Resource table bugs

2015-02-23 Thread Uddin Fatema
Dear All, I have converted my dhis2 2.16 version to 2.18. Now i found two error those are given bellow. 1. When i click on event capture and select Orgunite and select event program that time it shows ERROR 2015-02-18 11:13:18,614 Error while executing action (ExceptionIntercept or.java [http-ap

Re: [Dhis2-devs] Analytics table dimensions contain duplicates: ["uidlevel3", "uidlevel4"] DHIS2 v2.17

2015-02-23 Thread Calle Hedberg
Lars, We had a nearly identical issue with one of our database on Friday - importing one new orgunit from another databaseinstance resulted in duplicates in the orgunitlevel table, which in turn caused analytics to fail. The key design issue (I would not call it a bug, even if it appears like tha

[Dhis2-devs] [Bug 1424604] [NEW] Category option combo not matched on import

2015-02-23 Thread Lars Helge Øverland
Public bug reported: During meta-data import, category option combos are sometimes not properly matched to existing ones. Most notably, you might end up with multiple "default" category option combos after a meta-data import. ** Affects: dhis2 Importance: Critical Assignee: Morten Olav

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 18375: Data set report, allowing for future periods as some data sets might have future data

2015-02-23 Thread noreply
revno: 18375 committer: Lars Helge Overland branch nick: dhis2 timestamp: Mon 2015-02-23 11:10:31 +0100 message: Data set report, allowing for future periods as some data sets might have future data modified: dhis-2/dhis-web/dhis-w

Re: [Dhis2-devs] [Bug 1424604] [NEW] Category option combo not matched on import

2015-02-23 Thread Calle Hedberg
Please add to this: the same happens with regard to the orgunitlevel table when importing OrgUnits - if the orgunit being imported have levels with different names or UIDs, you risk duplication. Regards Calle On 23 February 2015 at 13:49, Lars Helge Øverland wrote: > Public bug reported: > > Du

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 18377: Cache manifest action, fixed nullpointer vulnerability

2015-02-23 Thread noreply
revno: 18377 committer: Lars Helge Overland branch nick: dhis2 timestamp: Mon 2015-02-23 12:48:32 +0100 message: Cache manifest action, fixed nullpointer vulnerability modified: dhis-2/dhis-web/dhis-web-apps/src/main/resources/struts

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 18376: minor fixes, adds type to QueryEngine and adds ResultTransformers for running multiple transforme...

2015-02-23 Thread noreply
revno: 18376 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Mon 2015-02-23 18:17:55 +0700 message: minor fixes, adds type to QueryEngine and adds ResultTransformers for running multiple transformes on a result added: dh

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 18378: Added bean def for CacheManifestAction

2015-02-23 Thread noreply
revno: 18378 committer: Lars Helge Overland branch nick: dhis2 timestamp: Mon 2015-02-23 12:57:42 +0100 message: Added bean def for CacheManifestAction modified: dhis-2/dhis-web/dhis-web-commons/src/main/resources/META-INF/dhis/beans

Re: [Dhis2-devs] dhis2 2.18 upgrade - Event Capture and Resource table bugs

2015-02-23 Thread Lars Helge Øverland
Hi Fatema, > 1. When i click on event capture and select Orgunite and select event > program that time it shows > ERROR 2015-02-18 11:13:18,614 Error while executing action > (ExceptionIntercept > or.java [http-apr-8085-exec-10]) > java.lang.NullPointerException > at > org.hisp.dhis.appc

Re: [Dhis2-devs] Analytics table dimensions contain duplicates: ["uidlevel3", "uidlevel4"] DHIS2 v2.17

2015-02-23 Thread Lars Helge Øverland
Hi Calle, yes we will look into it. The meta-data importer does match against existing objects, first on uid, then code, then name (if unique). This problem is specific to category option combos, since option combos are generated based on category options/combos and not created explicitly. What

Re: [Dhis2-devs] Analytics table dimensions contain duplicates: ["uidlevel3", "uidlevel4"] DHIS2 v2.17

2015-02-23 Thread Calle Hedberg
In short, YES. There is clearly still a need for a more sophisticated type of import, though - where the user can SEE what is identified for import and if required modify or drop specific things Regards Calle On 23 February 2015 at 14:31, Lars Helge Øverland wrote: > > Hi Calle, > > yes we

Re: [Dhis2-devs] Analytics table dimensions contain duplicates: ["uidlevel3", "uidlevel4"] DHIS2 v2.17

2015-02-23 Thread Calle Hedberg
Sorry, one more thing: A more fundamental challenge relates to the whole cat/att-optioncombo DESIGN for any particular database - DHIS2 enables anything with very little guidance, and the net result can be very messy configurations with multiple permutations of what is basically the same thing, li

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 18379: remove unused imports

2015-02-23 Thread noreply
revno: 18379 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Mon 2015-02-23 20:06:26 +0700 message: remove unused imports modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/query/QueryEngine.java dhis-2/dhis-api/src/

Re: [Dhis2-devs] dhis2 2.18 upgrade - Event Capture and Resource table bugs

2015-02-23 Thread Ola Hodne Titlestad
On 23 February 2015 at 13:23, Lars Helge Øverland wrote: > Hi Fatema, > > >> 1. When i click on event capture and select Orgunite and select event >> program that time it shows >> ERROR 2015-02-18 11:13:18,614 Error while executing action >> (ExceptionIntercept >> or.java [http-apr-8085-exec-10]

Re: [Dhis2-devs] Editing the code in the option sets

2015-02-23 Thread Jose Garcia Muñoz
Following with this thread... I have tested changing the name of the option sets We had the following option '4A03 - Meidy Mazariegos' in the 2.16, when we upgrade to the 2.17 the name and the code of the option were filled both with the same text '4A03 - Meidy Mazariegos'. However, we realiz

Re: [Dhis2-devs] Editing the code in the option sets

2015-02-23 Thread Juan Manuel Alcantara Acosta
Hi Jose I tested this in DEV, where we have options that have a code that is different than the text. I changed the value of one option and checked the result in an event report, I kept getting the old text until I cleared the server cache. Best regards, JM > El 23/02/2015, a las 17:31, Jose Gar

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 18380: removed realObject hack on TEIController, expands relative in relationship (for one level)

2015-02-23 Thread noreply
revno: 18380 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Tue 2015-02-24 10:57:26 +0700 message: removed realObject hack on TEIController, expands relative in relationship (for one level) modified: dhis-2/dhis-servic

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-23 Thread channara rin
Hi Tran, if like this seem sound, but when i create New aggregate query builder, it require select "Data set" and then choose data element, And my DHIS2 system is each Dataset has different organisation unit. because each dataset has some is the same data element and some is different data element.

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder

2015-02-23 Thread Tran Chau (HISP Vietnam)
Hi Channara, Tracker Aggregation formula is for generating Data Elemment data. It is not 'Data Set' specific. It generates the Data Element value for all Data Sets that the Data Element belong to. On interface, there is 'Data Set' selector before selecting the Data Element. This does not limit th