Re: [Dhis2-users] Cross database querying for updating data

2015-04-20 Thread Knut Staring
Couldn't two left joins with null give you the diff? On Apr 21, 2015 12:36 AM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi there. I think the big challenge here is what is not there, as opposed to what needs to be added. DHIS2 has no functionality for soft deletes, meaning when you

Re: [Dhis2-users] [Dhis2-devs] Category Combo in Tracker Element

2015-04-20 Thread Uddin Fatema
Dear Nayeem, I just talked with John and he said it wil be good to make it aggregated data set as quarterly or monthly. Thanks On Mon, Apr 20, 2015 at 11:37 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Nayeem, Then I would use quarterly data: the first round of the campaign you

Re: [Dhis2-users] Generating Min/ Max

2015-04-20 Thread Prosper BT
Hi Rodolfo, Used its before and according to the results we got, it takes the ever max and min entered in the selected period for a given dataset. Regards On Mon, Apr 20, 2015 at 3:24 PM, Rodolfo Melia rme...@knowming.com wrote: I'm trying to understand how does DHIS generates the Min/ Max

Re: [Dhis2-users] module SIG

2015-04-20 Thread Jan Henrik Øverland
Hi Papa, could you please open GIS in the Google Chrome browser, press F12 to open the console, click the Console tab, then try to create the same map and see if there are any red error messages? Jan On Mon, Apr 20, 2015 at 2:22 PM, papa alioune Sokhna sokhnap...@gmail.com wrote: Hello, For

Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max

2015-04-20 Thread Jason Pickering
HI, I think as Prosper says, it is simply the overall max and min, and this can be set by the user, or calculated externally. Calle, use of standard deviation is problematic for several reasons however, mostly because it makes an assumption that the data is actually normally distributed, which

Re: [Dhis2-users] Cross database querying for updating data

2015-04-20 Thread Jason Pickering
It may work, but in general, it will not because the internal IDs of different DHIS2 databases are not the same. So, it might work, but it requires both databases to be in essentially the same state. Better to use the data import/export functionality if you can. Regards, Jason On Mon, Apr 20,

Re: [Dhis2-users] Category Combo in Tracker Element

2015-04-20 Thread Nayeem Al Mifthah
Dear Lars, Thanks for your guidence. Only thing I am confused about, this is an national event and agreegated report comes from sub districts. But, the event is happening without maintaining fixed interval. One of my colleague tell me to create agreegate dataset in replace of tracker. Please

Re: [Dhis2-users] Generating Min/ Max

2015-04-20 Thread Rodolfo Melia
Thanks Prosper - that makes sense. I guess that the only way to set a different rule (e.g., Max should be 150% than previous period) the max will need to be set via an app. Are Max/ Min of a Data Element/ Org Unit exposed in the API ? R *Rodolfo Meliá* *Principal | *rme...@knowming.com Skype:

Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max

2015-04-20 Thread Calle Hedberg
Hi, No generic model will fit ALL types of data elements, obviously - but it needs to fit the most typical data elements where you want to USE the min-max to capture e.g. reporting or capturing mistakes. If using a stdev model, you reset any negative values (which is impossible) to zero. Using

Re: [Dhis2-users] Category Combo in Tracker Element

2015-04-20 Thread Lars Helge Øverland
Hi Nayeem, sorry but categories are not supported for tracker data elements. We are considering to introduce it but for the moment you must create additional data elements. regards, Lars On Mon, Apr 20, 2015 at 1:17 PM, Nayeem Al Mifthah n.mift...@gmail.com wrote: Dear All Can we use

[Dhis2-users] Category Combo in Tracker Element

2015-04-20 Thread Nayeem Al Mifthah
Dear All Can we use category combo in event tracker element? We are going to capture vitamin A+ campaign report which run in annonyms time. Although the event has designed twice in a year, but not followes dates and frequency. As we can made only one campaign in 2014. Nayeem Al Mifthah HMIS

Re: [Dhis2-users] [Dhis2-devs] Category Combo in Tracker Element

2015-04-20 Thread Calle Hedberg
Nayeem Are you capturing data for each child separately? Or are you capturing the number of eligible children for VitA + no of children getting VitA? Regards calle On 20 April 2015 at 14:25, Nayeem Al Mifthah n.mift...@gmail.com wrote: Dear Lars, Thanks for your guidence. Only thing I am

Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max

2015-04-20 Thread Calle Hedberg
Hi, Sorry, but if the automatic min-max calculation is simply retrieving the historical minimum and maximum values, then that makes little sense and would have no real value. I don't have time to verify it right now, but my assumption has always been that DHIS2 is using a method similar to the

[Dhis2-users] Cross database querying for updating data

2015-04-20 Thread Muyepa A.
Can I safely update DHIS2 database A with data from DHIS database B both on the same PostgreSQL server by cross query. B is backup of A From database B, I can retrieve and save the data that is required using: psql B -c \copy (select * from datavalue where periodid='') TO STDOUT

Re: [Dhis2-users] no organisation unit attached to current user

2015-04-20 Thread Lars Helge Øverland
Hi Nami, you need to go to users app and assign an org unit to your user. I assume you are using the built-in admin user. regards, Lars On Sat, Apr 18, 2015 at 6:23 PM, Nami Ghadri nami_gha...@hotmail.com wrote: Ok I will check that Thanks *From:* Halvdan Grelland

[Dhis2-users] Generating Min/ Max

2015-04-20 Thread Rodolfo Melia
I'm trying to understand how does DHIS generates the Min/ Max values for a given Data Element/ Period. The documentation https://www.dhis2.org/doc/snapshot/en/user/html/ch12s03.html only makes reference to the fact that Max/Min can be set manually or automatically calculated. When automatically

Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max

2015-04-20 Thread Rodolfo Melia
my test also shows that only the min/max across all values of an org unit is use for setting mix/max. As this is unlikely to change any soon, I just want to understand if I can set the min/max values based on my own logic, and then inject it via the API. *Rodolfo Meliá* *Principal |

[Dhis2-users] Show charts with Periods and Organization Units

2015-04-20 Thread Muhammad Bilal Siddqui
How do i show charts with periods with OrgUnits. Like i am select period (Last 2 Months) and select 1 OrgUnit at level 2 it show 2 bars on a Chart. Now if i select 2 OrgUnit at level2 it Sums both OrgUnit result. But i want to show both units separately. (Like when we select 2 different indicator

Re: [Dhis2-users] Can't run dhis2 from .war file

2015-04-20 Thread Muhammad Bilal Siddqui
Thanks for info. I checked it is very good news. Thanks On Mon, Apr 20, 2015 at 12:29 PM, Knut Staring knu...@gmail.com wrote: Thanks - I was asking because i was told the PermGen should no longer be an issue with Java 8. Knut On Mon, Apr 20, 2015 at 12:52 PM, Muhammad Bilal Siddqui

Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max

2015-04-20 Thread Jason Pickering
Good. I probably should have known that already, thus why I had to do some statistical analysis outside of DHIS2 to actually calculate reasonable min max. A quick check of the validity of a normal distribution, can be with the skewness and kurtosis , which provide a idea of how tilted a given

Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max

2015-04-20 Thread Lars Helge Øverland
Hi there, Calle is right here - we do average, then calculate std dev and set the upper and lower bounds for each value. We use data from ALL available time periods to calculate this (period org unit, data element, option combo) Mind you we should not really debate whether to use standard

Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max

2015-04-20 Thread Lars Helge Øverland
The number of std dev is by default 2, but can be set as desired from apps settings general settings. ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users

Re: [Dhis2-users] Cross database querying for updating data

2015-04-20 Thread Muyepa A.
I had thought of data import/export functionality, however this will require two instances of tomcat to be running. (or one instance with one database at a time, however there will be an associated down time). Since upgrading to 2.18, when exported, the resultant download zip file says invalid

Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max

2015-04-20 Thread Jason Pickering
Sure, and that is my point that generation of min/max is not something Normal users would do. This is a potentially complex operation, which requires statistical knowledge. But again, your insistence that it is calculated according to a normal model, I think it simply not right. It may work, but

Re: [Dhis2-users] [Dhis2-devs] Category Combo in Tracker Element

2015-04-20 Thread Nayeem Al Mifthah
​Dear Calle It is number. Agreegated data. But, this event is not performing in a regular manner.​ So I can't define the period. Nayeem Al Mifthah HMIS Consultant Management Information System Directorate General of Health Services (DGHS), Bangladesh Supported by: UNICEF-Bangladesh Email:

Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max

2015-04-20 Thread Calle Hedberg
Hi Calle is right here - we do average, then calculate std dev and set the upper and lower bounds for each value. We use data from ALL available time periods to calculate this (period org unit, data element, option combo). Here and there and back again :-) So I wasn't off the reservation, then.

Re: [Dhis2-users] Cross database querying for updating data

2015-04-20 Thread Bob Jolliffe
If database B is restored off a backup of database A then it will probably work with some caveats. Clearly they are not exactly the same because you've got extra data in A which you are trying to push into B. So it depends really on what else might have changed in A. If you have made any

Re: [Dhis2-users] [Dhis2-devs] Category Combo in Tracker Element

2015-04-20 Thread Nayeem Al Mifthah
Dear Calle The campaign has been performing almost twice in a year. If first campaign for one year has made in January and second in May/June, how can I disaggregate the data. Also, immediately after the champaign we required the data for monitoring. If we want that and design in agreegated

Re: [Dhis2-users] Cross database querying for updating data

2015-04-20 Thread Jason Pickering
Hi there. I think the big challenge here is what is not there, as opposed to what needs to be added. DHIS2 has no functionality for soft deletes, meaning when you mark a record with a column like deletedon with a timestamp for deletion, but you actually do not remove it from the database. This

Re: [Dhis2-users] Cross database querying for updating data

2015-04-20 Thread Knut Staring
I think I would trust UIDs or Codes more than database IDs On Mon, Apr 20, 2015 at 10:48 PM, Muyepa A. muye...@gmail.com wrote: Indeed Database A has extra data not available in B while B has data missing in A. No changes have been made to orgunits, dataelements, periods or users. The delta

Re: [Dhis2-users] [Dhis2-devs] Category Combo in Tracker Element

2015-04-20 Thread Calle Hedberg
Nayeem, Then I would use quarterly data: the first round of the campaign you capture under Q1, the second round under Q2. Whether some of the second round took place in May and some in June (e.g. from 20th May to 5th of June), it does not matter, right? I assume you will capture this data per

Re: [Dhis2-users] [Dhis2-devs] Category Combo in Tracker Element

2015-04-20 Thread Calle Hedberg
Hi I would still force the aggregated data into one of the routine periods, then - maybe use quarterly or six-monthly instead of the typical daily/weekly/monthly used for aggregated campaign data? Regards Calle On 20 April 2015 at 16:46, Nayeem Al Mifthah n.mift...@gmail.com wrote: ​Dear

[Dhis2-users] Interpreting Catalina.out

2015-04-20 Thread Muyepa A.
What cat I tell from this output of catalina * INFO 2015-04-13 15:23:59,790 'userlogedin' create org.hisp.dhis.message.MessageConversation, name: Form registered as complete, uid: lOwFJaUOxwO (AuditLogUtil.java [ajp-bio-8009-exec-678]) How can I get the data form that was registered complete.

Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max

2015-04-20 Thread Lars Helge Øverland
The minmax dataelement values are set by: - data element - org unit - category option combo - Lars On Mon, Apr 20, 2015 at 5:27 PM, Rodolfo Melia rme...@knowming.com wrote: Thanks everyone. It is good to understand how the max/min is calculated in DHIS (the documentation should be

Re: [Dhis2-users] Cross database querying for updating data

2015-04-20 Thread Muyepa A.
Indeed Database A has extra data not available in B while B has data missing in A. No changes have been made to orgunits, dataelements, periods or users. The delta is in data-values. I would really want to get views on whether the operation described (all other parameters being equal) will bring

Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max

2015-04-20 Thread Rodolfo Melia
Thanks everyone. It is good to understand how the max/min is calculated in DHIS (the documentation should be updated with the content of this email). We definitely need other ways to set min/ max values - my case has a specific logic, which needs to be implemented via SQL, until there is a way to

Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max

2015-04-20 Thread Rodolfo Melia
Is the attribute likely to be added to the mix? - the logic that IPPF uses for setting the maximum value is different for Attribute 1 and Attribute 2 of a data value. R *Rodolfo Meliá* *Principal | *rme...@knowming.com Skype: rod.melia | +44 777 576 4090 | +1 708 872 7636 www.knowming.com