Re: [Dhis2-devs] Need Help with Organisation Unit group

2015-09-28 Thread Knut Staring
You can achieve the same through the webapi On Sep 29, 2015 8:32 AM, "Asiz koju" wrote: > Thanks Knut, > > Thank you for your suggestion. I can distinguish them easily through sql > but the problem is the server is located else somewhere and i don't have > remote access to it. Is there any other

Re: [Dhis2-devs] Need Help with Organisation Unit group

2015-09-28 Thread Asiz koju
Thanks Knut, Thank you for your suggestion. I can distinguish them easily through sql but the problem is the server is located else somewhere and i don't have remote access to it. Is there any other way possible? Regards,Utsav Date: Tue, 29 Sep 2015 08:27:24 +0200 Subject: Re: [Dhis2-devs] Need

Re: [Dhis2-devs] Need Help with Organisation Unit group

2015-09-28 Thread Knut Staring
If you have a way of distinguishing them from the name or code, then you can do it directly in th db with SQL. Knut On Sep 29, 2015 7:53 AM, "Asiz koju" wrote: > Dear all, > I would be really grateful if someone can help me with my problem. In my > instance, at level 5 i have two different types

[Dhis2-devs] Need Help with Organisation Unit group

2015-09-28 Thread Asiz koju
Dear all,I would be really grateful if someone can help me with my problem. In my instance, at level 5 i have two different types of org unit (1 is community workers and other is outlet) so while assigning program to these levels i can't do it by selecting the levels but instead i need to select

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 20393: minor cleanup

2015-09-28 Thread noreply
revno: 20393 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Tue 2015-09-29 12:27:58 +0700 message: minor cleanup modified: dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/events/trackedentity/Abs

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 20392: Fixed bug - Exception thrown when to run Schedule Automated Message function ( DONE ).

2015-09-28 Thread noreply
revno: 20392 committer: Tran Chau branch nick: dhis2 timestamp: Mon 2015-09-28 14:49:39 -0700 message: Fixed bug - Exception thrown when to run Schedule Automated Message function ( DONE ). modified: dhis-2/dhis-services/dhis-servic

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 20391: Minor fix.

2015-09-28 Thread noreply
revno: 20391 committer: Tran Chau branch nick: dhis2 timestamp: Mon 2015-09-28 12:14:22 -0700 message: Minor fix. modified: dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/startup/TableAlteror.java

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 20390: Fixed bug - Exception thrown when to run Schedule Automated Message function.

2015-09-28 Thread noreply
revno: 20390 committer: Tran Chau branch nick: dhis2 timestamp: Mon 2015-09-28 12:06:45 -0700 message: Fixed bug - Exception thrown when to run Schedule Automated Message function. modified: dhis-2/dhis-api/src/main/java/org/hisp/dhi

[Dhis2-devs] Web Portal with DHIS2

2015-09-28 Thread Guy Ekani
Hello Everyone, Could someone can share tips on how to build a Web Portal with DHIS2 Data Sincerely, = EKANI Guy  ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe :

Re: [Dhis2-devs] Marquer les formulaires "Terminer"

2015-09-28 Thread Knut Staring
On peut aussi le faire par l'intermédiaire du web-API: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s18.html 2015-09-28 15:15 GMT+02:00 Matthieu Pinard : > Bonjour Martial, > > tu peux effectuer une telle tâche via une requête sql. As-tu les droits > nécessaires? > > Bien à toi, > Mat

Re: [Dhis2-devs] Bug with "Yes Only" in Analytics

2015-09-28 Thread Timothy Harding
Thanks Lars! *Timothy Harding* Sr. Systems Analyst, BAO Systems +1 202-536-1541 | thard...@baosystems.com | http://www.baosystems.com | Skype: hardi...@gmail.com | 2900 K Street, Suite 404, Washington D.C. 20007 On Mon, Sep 28, 2015 at 10:04 AM, Lars Helge Øverland wrote: > Hi Tim, > > this ha

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 20389: minor - display content of rule effect data if present

2015-09-28 Thread noreply
revno: 20389 committer: Markus Bekken branch nick: dhis2 timestamp: Mon 2015-09-28 15:08:36 +0200 message: minor - display content of rule effect data if present modified: dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-track

Re: [Dhis2-devs] Loading missing period records through webAPI?

2015-09-28 Thread Jason Pickering
Yeah, of course SELECT startdate::date,(startdate::date + '1 month'::interval - '1 day'::interval)::date as enddate from (SELECT * FROM generate_series('2015-01-01'::date,'2015-12-31'::date, '1 month') as startdate) as foo :) On Mon, Sep 28, 2015 at 3:02 PM, Knut Staring wrote: > Nice, Jason

Re: [Dhis2-devs] Loading missing period records through webAPI?

2015-09-28 Thread Knut Staring
Nice, Jason. But did you mean enddate at the end of the first line (just before "from")? On Mon, Sep 28, 2015 at 2:53 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > If you are using Postgres, you could always simply generate the periods > your self with something like.. > > SELECT st

Re: [Dhis2-devs] Loading missing period records through webAPI?

2015-09-28 Thread Greg Rowles
Will give it a try... many thanks! On Mon, Sep 28, 2015 at 2:53 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > If you are using Postgres, you could always simply generate the periods > your self with something like.. > > SELECT startdate::date,(startdate::date + '1 month'::interval -

Re: [Dhis2-devs] Loading missing period records through webAPI?

2015-09-28 Thread Jason Pickering
If you are using Postgres, you could always simply generate the periods your self with something like.. SELECT startdate::date,(startdate::date + '1 month'::interval - '1 day'::interval)::date as startdate from (SELECT * FROM generate_series('2015-01-01'::date,'2015-12-31'::date, '1 month') as sta

Re: [Dhis2-devs] Loading missing period records through webAPI?

2015-09-28 Thread Greg Rowles
I guess there's no short way of explaining this. I'm using a SQL query (that allows for variables) to create a count of orgunits (coming from a specific ou-level) per orgunit groupset. I've set up an example on the dhis2 demo site here: https://apps.dhis2.org/demo/api/sqlViews/mLsbp3ds7pF/data?var

Re: [Dhis2-devs] Interesting problem with sql view dependencies

2015-09-28 Thread Lars Helge Øverland
It might - I cannot remember.. Lars On Mon, Sep 28, 2015 at 1:29 PM, Bob Jolliffe wrote: > Thanks Lars. That should help. Though it is still a bit of mystery > why it worked on one system but not on the other. Is this alphabetic > ordering post 2.17? > > On 28 September 2015 at 12:22, Lars H

Re: [Dhis2-devs] Loading missing period records through webAPI?

2015-09-28 Thread Jason Pickering
I am not really sure why this would be needed. Could you explain more why you need this? The period formats are well documented ( https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s04.html), so there is no need to have them stored by the server. The client can simply create the periods as t

Re: [Dhis2-devs] Loading missing period records through webAPI?

2015-09-28 Thread Greg Rowles
Hi Jason Yeah, its for a "non-standard" DHIS2 instance. Our national data dictionary doesn't host actual data only master meta-data. Any suggestions? I don't see any options for periods under meta-data export either... Greg On Mon, Sep 28, 2015 at 2:17 PM, Jason Pickering < jason.p.picker...@gm

Re: [Dhis2-devs] Loading missing period records through webAPI?

2015-09-28 Thread Jason Pickering
Hi Greg, There is no need to do this, as they will be added when data actually exists for that period. I suppose you could add a dummy record and delete it, and that would have the same affect as creating the period. Regards, Jason On Mon, Sep 28, 2015 at 2:10 PM, Greg Rowles wrote: > Hi Dev

[Dhis2-devs] Loading missing period records through webAPI?

2015-09-28 Thread Greg Rowles
Hi Devs Is there an API call to add missing period records? E.g. we have no yearly (periodtypeid: 8) records in an instance which has restricted access. Only API calls are supported... Regards, Greg -- *Health Information Systems Program - South Africa* *- - - - - - - **- - - - - - - **- - - -

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 20388: GIS minor fix.

2015-09-28 Thread noreply
revno: 20388 committer: Jan Henrik Overland branch nick: dhis2 timestamp: Mon 2015-09-28 14:56:16 +0300 message: GIS minor fix. modified: dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/app.js -- lp:dhis2 htt

Re: [Dhis2-devs] Interesting problem with sql view dependencies

2015-09-28 Thread Bob Jolliffe
Thanks Lars. That should help. Though it is still a bit of mystery why it worked on one system but not on the other. Is this alphabetic ordering post 2.17? On 28 September 2015 at 12:22, Lars Helge Øverland wrote: > Hi Bob, > > just to inform - the SQL views are dropped in reversed alphabetica

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 20387: GIS program data in favorites.

2015-09-28 Thread noreply
revno: 20387 committer: Jan Henrik Overland branch nick: dhis2 timestamp: Mon 2015-09-28 14:25:26 +0300 message: GIS program data in favorites. modified: dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/app.js

Re: [Dhis2-devs] Interesting problem with sql view dependencies

2015-09-28 Thread Lars Helge Øverland
Hi Bob, just to inform - the SQL views are dropped in reversed alphabetical order, and generated in alphabetical order based on name. This means there is no "intelligence" around detecting view inter-dependencies, but at least gives a way to deal with it (make sure that a view which depends on ano

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 20386: Adding new pom for checking of resource bundles.

2015-09-28 Thread noreply
revno: 20386 committer: Jason P. Pickering branch nick: dhis2 timestamp: Mon 2015-09-28 13:18:20 +0200 message: Adding new pom for checking of resource bundles. added: dhis-2/pom-resource-bundle.xml -- lp:dhis2 https://code.launchp

Re: [Dhis2-devs] Interesting problem with sql view dependencies

2015-09-28 Thread Knut Staring
I have a similar problem in 2.19 where backups are not getting generated because of sqlviews. On Mon, Sep 28, 2015 at 11:03 AM, Bob Jolliffe wrote: > I am not sure if this is an issue which has been fixed in later > versions, but we recently chanced upon some odd behaviour in 2.17. > > On the pr

[Dhis2-devs] Interesting problem with sql view dependencies

2015-09-28 Thread Bob Jolliffe
I am not sure if this is an issue which has been fixed in later versions, but we recently chanced upon some odd behaviour in 2.17. On the production system there are a number of views defined (through the sql view interface). A couple of those views depend on other views. When resource tables a

Re: [Dhis2-devs] Bug with "Yes Only" in Analytics

2015-09-28 Thread Lars Helge Øverland
Hi Tim, this has been fixed in 2.20 now. regards, Lars On Sat, Sep 26, 2015 at 10:51 PM, Timothy Harding wrote: > Hello Devs! > > We just upgraded quite a few servers to 2.20 and I noticed that we are > getting a lot of this while using the pivot tables: > [image: Inline image 1] > > I've fo

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 20385: Added annotated method getDataDimensionItemType to DataDimensionItem

2015-09-28 Thread noreply
revno: 20385 committer: Lars Helge Overland branch nick: dhis2 timestamp: Mon 2015-09-28 11:25:45 +0200 message: Added annotated method getDataDimensionItemType to DataDimensionItem modified: dhis-2/dhis-api/src/main/java/org/hisp/dh

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 20384: Moved enum DataDimensionItemType to own file

2015-09-28 Thread noreply
revno: 20384 committer: Lars Helge Overland branch nick: dhis2 timestamp: Mon 2015-09-28 11:07:56 +0200 message: Moved enum DataDimensionItemType to own file added: dhis-2/dhis-api/src/main/java/org/hisp/dhis/common/DataDimensionItem

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 20383: Code style

2015-09-28 Thread noreply
revno: 20383 committer: Lars Helge Overland branch nick: dhis2 timestamp: Mon 2015-09-28 09:12:35 +0200 message: Code style modified: dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/util/MathUtils.java