Re: [Dhis2-users] [Dhis2-devs] Tracker capture app displays the items in a different order...
Hi Yes, normal thinking/logic says that section sorting (possibly even custom sorting) should automatically re-sort the "basic" list too (aka the "sort_order" field in the programstagedataelement table), but it does not. I wrote a JIRA issue for it some time back (DHIS2-4322), and Jose did another one (DHIS2-4528) - they are supposed to have resolved the issue. So you might want to consider upgrading to a newer build (assuming you are using 2.29 or 2.30) Regards Calle On Sun, 25 Nov 2018 at 17:25, M.Selvaraaj Prabu wrote: > Hi Calle. > > Thanks for your help. It is working like a charm. I thought the sorting on > Basic option is not needed when we use the Section option. > > Thank you once again for taking your valuable time to assist us. I really > appreciate. God Bless! > > Thanks and regards > > MSP > > > On Sun, Nov 25, 2018 at 2:43 PM Calle Hedberg > wrote: > >> Hi, >> >> Make sure you have sorted the data elements correctly in the "basic" >> section too - section sort order is not necessarily the same as the basic >> sort order, and sorting the section part does not simultaneously update the >> "basic" part. >> >> regards >> Calle >> >> On Sun, 25 Nov 2018 at 13:00, M.Selvaraaj Prabu >> wrote: >> >>> Hi Stanley, >>> >>> Thanks for your reply. Yes, I have done the ordering in the "section" >>> side. As I have indicated, the order is fine on computers but different in >>> tablets. >>> >>> Thanks and regards >>> >>> MSP >>> >>> >>> On Sat, Nov 24, 2018 at 11:28 AM Stanley Kalyati >>> wrote: >>> >>>> Hi Selvaraaj, >>>> >>>> Did you arrange them in the Section part as below: >>>> >>>> [image: image.png] >>>> >>>> If not try to arrange them like this and see if it works. >>>> >>>> Thank you >>>> >>>> Stanley >>>> >>>> On Sat, Nov 24, 2018 at 9:41 AM M.Selvaraaj Prabu >>>> wrote: >>>> >>>>> Hi Devs. >>>>> >>>>> Please note I am facing a peculiar issue with the Tracker Capture App >>>>> on the tablets. >>>>> >>>>> The issue is, the data elements appear in a different order than what >>>>> I have defined in the programme stage. For example, say I designed a data >>>>> entry screen in the following order of data elements: >>>>> >>>>>1. First name >>>>>2. Surname >>>>>3. Date of Birth >>>>>4. Sex >>>>> >>>>> On the web interface (Tracker capture on computer), the order looks >>>>> fine as defined above. But on the tablets, the Tracker Capture App >>>>> displays >>>>> the elements in a different order, something like: >>>>> >>>>>1. Surname >>>>>2. Date of Birth >>>>>3. First name >>>>>4. Sex. >>>>> >>>>> Since the order appears correctly on the computer, I don't' know what >>>>> to do to make it to appear with the same order on the tablets. >>>>> >>>>> Kindly assist me to fix this issue. >>>>> >>>>> Thanks and regards >>>>> >>>>> MSP >>>>> ___ >>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>> Post to : dhis2-users@lists.launchpad.net >>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>> ___ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >> >> >> -- >> >> *** >> >> Calle Hedberg >> >> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA >> >> Tel/fax (home): +27-21-685-6472 >> >> Cell: +27-82-853-5352 >> >> Iridium SatPhone: +8816-315-19119 >> >> Email: calle.hedb...@gmail.com >> >> Skype: calle_hedberg >> >> *** >> >> -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Tracker capture app displays the items in a different order...
Hi, Make sure you have sorted the data elements correctly in the "basic" section too - section sort order is not necessarily the same as the basic sort order, and sorting the section part does not simultaneously update the "basic" part. regards Calle On Sun, 25 Nov 2018 at 13:00, M.Selvaraaj Prabu wrote: > Hi Stanley, > > Thanks for your reply. Yes, I have done the ordering in the "section" > side. As I have indicated, the order is fine on computers but different in > tablets. > > Thanks and regards > > MSP > > > On Sat, Nov 24, 2018 at 11:28 AM Stanley Kalyati > wrote: > >> Hi Selvaraaj, >> >> Did you arrange them in the Section part as below: >> >> [image: image.png] >> >> If not try to arrange them like this and see if it works. >> >> Thank you >> >> Stanley >> >> On Sat, Nov 24, 2018 at 9:41 AM M.Selvaraaj Prabu >> wrote: >> >>> Hi Devs. >>> >>> Please note I am facing a peculiar issue with the Tracker Capture App on >>> the tablets. >>> >>> The issue is, the data elements appear in a different order than what I >>> have defined in the programme stage. For example, say I designed a data >>> entry screen in the following order of data elements: >>> >>>1. First name >>>2. Surname >>>3. Date of Birth >>>4. Sex >>> >>> On the web interface (Tracker capture on computer), the order looks fine >>> as defined above. But on the tablets, the Tracker Capture App displays the >>> elements in a different order, something like: >>> >>>1. Surname >>>2. Date of Birth >>>3. First name >>>4. Sex. >>> >>> Since the order appears correctly on the computer, I don't' know what to >>> do to make it to appear with the same order on the tablets. >>> >>> Kindly assist me to fix this issue. >>> >>> Thanks and regards >>> >>> MSP >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >> ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Filtering indicators by OU
) that we have created additional related Data >> Elements that map to the disease e.g. we have different DEs for ‘ >> *Malaria’* & for ‘*Malaria (death)*’ to use for Mortality-type >> indicators. Mind you this is mapping to the aggregate data capture. >> >> >> >> I’m unsure if there are any Best Practices for these types of indicators >> & how to set them up (I would presume they are common) but if there is any >> we would be happy to know them & how organisations have configured these. >> >> From reading the below it may be wise to create Cat. Combos instead of >> additional DE’s but other people may have experience in which is best to >> capture this & easier to manage over the long term. >> >> >> >> Have a good evening, >> >> *Damien * >> >> >> >> *From:* Dhis2-users > brussels.msf@lists.launchpad.net> *On Behalf Of *Calle Hedberg >> *Sent:* Wednesday, 14 November 2018 6:02 PM >> *To:* Jaime Bosque >> *Cc:* DHIS 2 Users list ; dhis2-devs < >> dhis2-d...@lists.launchpad.net> >> *Subject:* Re: [Dhis2-users] [Dhis2-devs] Filtering indicators by OU >> >> >> >> Jaime and others, >> >> >> >> Using category combos (or attribute combos) are >> fundamentally/conceptually the same as having multiple data elements, >> because at the end of the day you will have the same number of physical >> records in your database (e.g. the datavalue table). Or in other words, the >> level of "granularity" in your data remains the same. (The main advantage >> in using catcombos is a reduction in the amount of meta-data records you >> maintain: so instead of creating and maintaining let us say 300 data >> elements, you create and maintain 50 data elements with 2 gender catoptions >> and 3 age catoptions (55 meta-data items) -> 50x2x3=300 >> dataelement variants. (Maintaining 55 items is presumably >> easier than 300 - although for many users it's also more difficult to fully >> grasp and I have seen a lot of databases where the catcombos have become >> really messy over the years. Typical examples are multiple changes in e.g. >> age groups over time). >> >> >> >> There are situations where you can use for instance orgunit groups to get >> "ou-dependent" indicator values, but I would in general not recommend them >> except when the relation between orgunit(type) and indicator is an inherent >> and stable dimension of every indicator at a particular orgunit level. A >> practical example: >> >> 1. >> >> If you collect data per hospital, and the hospital have 8 different wards >> (1 maternity, 2 medical, 2 surgical, 1 paediatrics, 1 ICU, 1 orthopaedics), >> and you need e.g. Bed Utilisation Rates for each ward type, you would >> typically create one data element & catcombo set for each type: >> >> Inpatient days - maternity, inpatient days - medical, inpatients >> separations - maternity, inpatient separations - medical, inpatient death - >> maternity, inpatient death - medical, etc. >> >> 2. >> >> If you on the other hand collect the same data per hospital ward (i.e. >> expand your orghierarchy to the sub-facility level), and these are grouped >> per ward type, you need only >> >> inpatient days, inpatient separations, inpatient deaths >> >> and you would do analysis per ou group. NOTE, though, that such a model >> means you cannot change a ward's orgunittype without messing up the >> historic data analysis. So if a ward is changed from a medical to a >> surgical ward, you would have to close the medical ou and open a surgical >> ou. >> >> >> >> Another perspective on the same is to say that the higher granularity you >> have in the geographic/administrative dimension (orghierarchy), the less >> granularity tend to be required in the fact dimension (data >> elements/indicators). When implementing something like option 2, though, >> you must also consider aggregation of data - if for instance some of your >> indicators are using higher level data (e.g. district totals) for some >> denominators, you might end up struggling to get that. >> >> >> >> Jaime do not provide any specifics about exactly what A,B,C is and >> whether each of them are firmly and permanently bonded to specific outypes >> only so it is difficult to know if "transferring" some of the granularity >> to the orgunit dimension is advisable (as indicated above, aggregated >> analysis needs might also play
Re: [Dhis2-users] [Dhis2-devs] Filtering indicators by OU
ndividual Data Elements. > My understanding is that you merged them by creating a Category > combination with a Data Dimension Type "Disaggregation" A, B and C as > options and assigned to the Element Called X. If that is the case, during > data entry, the system will disaggregate the Data Element X into X(A), X(B) > and X(C). > If you have gone this way, your analysis won't be an issue. > > Please verify and confirm if this is similar to what you want. > > Regards > > On Tue, Nov 13, 2018 at 5:34 PM Jaime Bosque < > jaime.bos...@barcelona.msf.org> wrote: > > Hello and thanks for the quick response... it seems it might have not been > really clear. > > > I will try to put an example. > > We had 3 Data Elements (A,B and C) that have been merged in one (let's > call it X). The reason they have been merged is because A,B and C belong to > a Medical Service called Nutrition and as they could be filtered later by > that service (Nutrition A, Nutrition B and Nutrition C) it simplified the > data input and analysis. > > > So, for example, now in the OU Nutrition A people will fill the Data > Element X. And when doing the analysis they will select Data Element X > filtered by service Nutrition A. Same for B and Same for C. > > > These three indicators were used before separately in several indicators, > sometimes we needed A+B+C/100. In those cases we don't need to do anything > as they have already been merged and we can use X/100. > > > However, and here is the issue. We have realized that when calculating > Deaths, the only valid deaths are those coming from Nutrition A and > Nutrition B. So before, we would have the indicator Nutrition A + Nutrition > B. > > > Ideally, I would like to be able to create an indicator where Data > Elements can be filtered, so I could create an indicator like X (Nutrition > A) + X (Nutrition B). > > > If this is not possible it obliges me to keep the old model with A, B and > C separated instead of the X. I hope it is clear... I will happily provide > more information if requested. > > > Thanks, > > > Jaime Bosque Torrecilla > > Applications Technician, eHealth & Operations Applications (‘Apps4OPS’) > > > *Projects & IT Unit Médecins Sans Frontières (MSF) Spain – Barcelona > Office* > > Fixed: +34 935 213 048 – Skype: msfe-healthdatatech2 > > Email: jaime.bos...@barcelona.msf.org > – www.msf.org > > -- > *From:* Barnabas Akumba > *Sent:* 13 November 2018 16:48:02 > *To:* Jaime Bosque > *Cc:* dhis2-users; dhis2-devs > *Subject:* Re: [Dhis2-devs] Filtering indicators by OU > > Hello Jaime, > > Could you be more detailed? Let's understand your implementation (eg. of > DEs). > > Regards > > On Tue, Nov 13, 2018 at 4:44 PM Jaime Bosque < > jaime.bos...@barcelona.msf.org> wrote: > > Good afternoon. First email to the list looking for some help... > > > We are revising our data model and we have come out with a simplification > on the number of Data Elements. For example, before we were using three > Data Elements that we have realized they can be joined and then filtered by > Organisation Unit when doing the analysis. > > > This works wonder in data analysis, however we have realized that this > will not work for the indicators as there is no possible way of filtering > by OU in the indicators. Am I correct? Is there a way that this could be > done somehow? > > > Thanks a lot, > > > Jaime Bosque Torrecilla > > Applications Technician, eHealth & Operations Applications (‘Apps4OPS’) > > > *Projects & IT Unit Médecins Sans Frontières (MSF) Spain – Barcelona > Office* > > Fixed: +34 935 213 048 – Skype: msfe-healthdatatech2 > > Email: jaime.bos...@barcelona.msf.org > – www.msf.org > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > > > -- > > Barnabas AKUMBA > > *Mobile:* +2348036195778 > *Skype:* barnabas.akumba > > > > -- > > Barnabas AKUMBA > > *Mobile:* +2348036195778 > *Skype:* barnabas.akumba > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] postgresql version 9.6 required for dhis version 2.31
Hi, With regard to minimum pg requirements: Bjorn, what is the minimum version requirement for Postgis, and what is the recommended version? Again, postGIS 2.5 was released recently, so if people need to upgrade anyhow it makes sense to upgrade to the latest, tested version... Regards Calle On Wed, 31 Oct 2018 at 09:15, Calle Hedberg wrote: > Lars, > > With postgresql version 11 out - are there any specific reasons for NOT > using pg 11? Many of the key features introduced in 10 - like table > partitioning - have been further enhanced in 11. > > Regards > Calle > > On Wed, 31 Oct 2018 at 08:04, stepho...@gmail.com > wrote: > >> Thanks Lars. >> >> Just to be clear, Is that the minimum requirements for PostgreSQL? >> >> Sent from my HTC >> >> - Reply message - >> From: "Lars Helge Øverland" >> To: "DHIS 2 Users list" , "DHIS 2 >> Developers list" >> Subject: [Dhis2-users] postgresql version 9.6 required for dhis version >> 2.31 >> Date: Tue, Oct 30, 2018 23:33 >> >> Hi all, >> >> heads up: for DHIS 2 version 2.31 we will require PostgreSQL version 9.6. >> >> This is in order to take advantage of certain SQL features introduced in >> that version. The current required version is 9.4. >> >> If you plan to upgrade your PostgreSQL version we recommend going >> straight to version 10, as it contains several great features and >> performance improvements. Also, we will eventually require this version and >> so going directly to version 10 will avoid multiple successive upgrades. >> >> >> best regards, >> >> Lars >> >> >> >> Lars Helge Øverland >> Technical lead, DHIS 2 >> University of Oslo >> l...@dhis2.org >> https://www.dhis2.org >> >> _______ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> > > > -- > > ******* > > Calle Hedberg > > 46D Alma Road, 7700 Rosebank, SOUTH AFRICA > > Tel/fax (home): +27-21-685-6472 > > Cell: +27-82-853-5352 > > Iridium SatPhone: +8816-315-19119 > > Email: calle.hedb...@gmail.com > > Skype: calle_hedberg > > *** > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] postgresql version 9.6 required for dhis version 2.31
Lars, With postgresql version 11 out - are there any specific reasons for NOT using pg 11? Many of the key features introduced in 10 - like table partitioning - have been further enhanced in 11. Regards Calle On Wed, 31 Oct 2018 at 08:04, stepho...@gmail.com wrote: > Thanks Lars. > > Just to be clear, Is that the minimum requirements for PostgreSQL? > > Sent from my HTC > > - Reply message - > From: "Lars Helge Øverland" > To: "DHIS 2 Users list" , "DHIS 2 > Developers list" > Subject: [Dhis2-users] postgresql version 9.6 required for dhis version > 2.31 > Date: Tue, Oct 30, 2018 23:33 > > Hi all, > > heads up: for DHIS 2 version 2.31 we will require PostgreSQL version 9.6. > > This is in order to take advantage of certain SQL features introduced in > that version. The current required version is 9.4. > > If you plan to upgrade your PostgreSQL version we recommend going straight > to version 10, as it contains several great features and performance > improvements. Also, we will eventually require this version and so going > directly to version 10 will avoid multiple successive upgrades. > > > best regards, > > Lars > > > > Lars Helge Øverland > Technical lead, DHIS 2 > University of Oslo > l...@dhis2.org > https://www.dhis2.org > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] NEW ENTITY IS NOT SAVED-TRACKER CAPTURE version 2.29
Pradeep, The first "GET" error is just noise, it is some .gif file referenced somewhere in the code but the file no longer exist. DHIS2 has a number of those that for some reason don't get cleaned out. It's just a bit annoying, though. The second one is your real problem, and to be frank similar TypeErrors are popping up in a multitude of settings for 2.29 and 2.30 - they usually reflect some inconsistency in the meta-data that makes up your Tracker Program - the problem is that the error message as it appears is rather cryptic and you need to either drill into each of those angular references OR else analyse your program setup AND current data. I encountered a very similar problem just last week, which turned out to be caused by a few new ASSIGN program rules which had assigned values to the wrong stages because the stage were not explicitly defined (something not supported by the User Interface, so you have to manually edit the program rule in the back end). The DHIS2 code was also not intercepting this particular design problem. So beyond drilling into those angular references, I would do the following: 1. Have you made ANY changes to the tracker program including program rules during the last week or two? if yes, try to roll those changes back. 2. Check carefully that all program attributes, and all stage data elements, do exist in the attribute or data element tables. 3. Check that all program rules are valid. 4. Run a frequency analysis on existing data in the trackedentityattributevalue and trackedentitydatavalue tables (assuming you have access to the back end), and verify in particular that all option values are correct AND that all data element values are linked to the correct stage That's what I can suggest for now - since this is a new problem that suddenly popped up, your best bet is to dig into any recent changes to the program or program rules. My 2c worth Regards Calle On Thu, 25 Oct 2018 at 01:16, Pradeep Kumar Thakur wrote: > Hi Calle, > > > > Thank you for suggestion. The system was working well previously day > before yesterday but from yesterday it does not work. I did as you > suggested and watched when the error shows and has pasted here below. The > first error showed when I tried to choose organization unit and second one > showed when I hit save and continue. Hope this is clear. > > > > > > > > Regards, > > Pradeep > > *From:* Calle Hedberg > *Sent:* Wednesday, October 24, 2018 9:24 PM > *To:* Pradeep Kumar Thakur > *Cc:* Stanley Kalyati ; DHIS 2 Users list < > dhis2-users@lists.launchpad.net>; dhis2-devs < > dhis2-d...@lists.launchpad.net> > *Subject:* Re: [Dhis2-devs] [Dhis2-users] NEW ENTITY IS NOT SAVED-TRACKER > CAPTURE version 2.29 > > > > Hi, > > > > Listen - as a first step for any problem like this, you MUST > > 1. > > Use CTRL-SHIFT-J to open the Chrome console (I'm assuming you are using > Chrome), and copy the error messages appearing there (if any) to the post. > In many cases, the messages appearing will directly or indirectly show you > what the problem is. > > 2. > > Monitor the tomcat/catalina log when you click save and continue, and > again copy the relevant sections to your post. > > > > No problem with Stanley's advice per se - incorrect sharing settings MIGHT > the root cause of what you experience - but in general going through all > possible problem scenarios is a wild goose chase. > > > > Furthermore, your post do not indicate whether this is a newly defined > program which has never worked OR if it is a program that previously worked > fine and now don't work any more. If the latter, any information about > recent changes (e.g. updating to a newer 2.29 war file) is helpful. > > > > Regards > > Calle > > > > On Wed, 24 Oct 2018 at 17:03, Pradeep Kumar Thakur > wrote: > > Yeah. TEI is also not updated by Admin user. > > > > > > *From:* Stanley Kalyati > *Sent:* Wednesday, October 24, 2018 8:42 PM > *To:* Pradeep Kumar Thakur > *Cc:* DHIS 2 Developers list ; DHIS Users > > *Subject:* Re: [Dhis2-users] NEW ENTITY IS NOT SAVED-TRACKER CAPTURE > version 2.29 > > > > How about the user rights? Can you ensure edit/add TEI is selected? > > > > On Wed, Oct 24, 2018, 16:34 Pradeep Kumar Thakur > wrote: > > Thanks Stanly, I did as you suggested but in vein. > > > > Regards, > > Pradeep > > > > *From:* Stanley Kalyati > *Sent:* Wednesday, October 24, 2018 7:10 PM > *To:* Pradeep Kumar Thakur > *Cc:* DHIS 2 Developers list ; DHIS Users > > *Subject:* Re: [Dhis2-users] NEW ENTITY IS NOT SAVED-TRACKER CAPTURE > version 2.29 > > > > Can you go to the program and right click.Select
Re: [Dhis2-users] [Dhis2-devs] NEW ENTITY IS NOT SAVED-TRACKER CAPTURE version 2.29
Hi, Listen - as a first step for any problem like this, you MUST 1. Use CTRL-SHIFT-J to open the Chrome console (I'm assuming you are using Chrome), and copy the error messages appearing there (if any) to the post. In many cases, the messages appearing will directly or indirectly show you what the problem is. 2. Monitor the tomcat/catalina log when you click save and continue, and again copy the relevant sections to your post. No problem with Stanley's advice per se - incorrect sharing settings MIGHT the root cause of what you experience - but in general going through all possible problem scenarios is a wild goose chase. Furthermore, your post do not indicate whether this is a newly defined program which has never worked OR if it is a program that previously worked fine and now don't work any more. If the latter, any information about recent changes (e.g. updating to a newer 2.29 war file) is helpful. Regards Calle On Wed, 24 Oct 2018 at 17:03, Pradeep Kumar Thakur wrote: > Yeah. TEI is also not updated by Admin user. > > > > > > *From:* Stanley Kalyati > *Sent:* Wednesday, October 24, 2018 8:42 PM > *To:* Pradeep Kumar Thakur > *Cc:* DHIS 2 Developers list ; DHIS Users > > *Subject:* Re: [Dhis2-users] NEW ENTITY IS NOT SAVED-TRACKER CAPTURE > version 2.29 > > > > How about the user rights? Can you ensure edit/add TEI is selected? > > > > On Wed, Oct 24, 2018, 16:34 Pradeep Kumar Thakur > wrote: > > Thanks Stanly, I did as you suggested but in vein. > > > > Regards, > > Pradeep > > > > *From:* Stanley Kalyati > *Sent:* Wednesday, October 24, 2018 7:10 PM > *To:* Pradeep Kumar Thakur > *Cc:* DHIS 2 Developers list ; DHIS Users > > *Subject:* Re: [Dhis2-users] NEW ENTITY IS NOT SAVED-TRACKER CAPTURE > version 2.29 > > > > Can you go to the program and right click.Select sharing settings.You can > disable the public users and then add the user groups you want to access > the program.Make sure the settings are set on view and edit and capture > data. > > > > Regards > > > > Stanley > > > > On Wed, Oct 24, 2018 at 3:22 PM Pradeep Kumar Thakur > wrote: > > Dear Collogues, > > > > I have been facing below issue. Our system is not accepting new entity in > Tracker Capture. The black circle keeps moving. What could be the problem. > > > > > > Regards, > > Pradeep > > ___ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Mandatory attributes can not be made optional
Neeraj, if correct, then it is an obvious BUG. Have you written a JIRA bug report for it? Regards Calle On Wed, 24 Oct 2018 at 09:34, Neeraj Gupta wrote: > Dear All, > > Once the attribute is made mandatory and if at a later stage it is > considered to be optional then we are able to go to attributes of the > program and uncheck the mandatory field but this is not reflected in the > registration page. > It always treats the attribute as mandatory, the user cannot move forward > without entering data for those attributes. > > Version: 2.30 > Build revision: bd6e33e > Build date: 2018-10-23 02:06 > > -- > Thanks, > Neeraj Gupta > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] PostgreSQL-10 Optimization for DHIS2
Gerald, Please post your postgresql.conf file Regards Calle On Sun, 7 Oct 2018 at 23:19, gerald thomas wrote: > Dear All, > My instance is running on Ubuntu 18.04 with PostgreSQL-10 and i am using > version 2.27 Build revision 49b827a with an allocated RAM of 16Gb for > PostgreSQL and 12Gb RAM for the other application processes. > Whatever i had done during optimization of Postgres had not reduce my > analytics time below 1 hour. Please can anyone help because i actually want > analytics to run below 30 minutes. > > -- > Regards, > > Gerald > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Indicator totals count is incorrect
Nayeem I agree with your approach for those examples, although using the data element aggregation type might not cater for all types of indicators (ref for instance where numerator and denominator have different aggregation types, or where one of them are some type of group membership count, or indicators where you only want a result if the numerator or denominator is above a threshold, or where one of them is offset in time). With the DHIS increasingly used for e.g. survey data, sample data, case-based tracker data etc etc, we need a more versatile indicator processing where all forms of aggregation are either blocked (if clearly not correct/relevant) or else yield correct results. The issues have been on the agenda for a long time now, and I hope it will be finally resolved in 2.31. What's needed is to ensure e.g. the SL demo instance have examples of all types of indicators (and the underlying data), then to verify that any relevant aggregation yields correct values. Regards Calle On Wed, 19 Sep 2018 at 16:50, Nayeem Al Mifthah wrote: > Hi Calle > Hope you doing well. > > You are correct in a sense of different analytics type may required for > indicator aggregation :-) > > There are better and easy way to calculate. If you minutely look at my > earlier mail, probably you identify that, I have written to perform > aggregation according to aggregation type of the particular data element, > which might be sum, average, average (sum in organisation unit hierarchy > etc.). After that the indicator calculation should done. > > Probably my earlier mail have difficulties to understand due to only one > example. Let me give another example as well- > > Probably there is a data element for number of doctors posted in an health > facility with aggregation type average (sum in organisation unit hierarchy) > and another data element for number of patient visited with aggregation > type sum. > > Now you might have the below data table- > > Hospital A, January, Doctor posted- 6 > Hospital A, February, Doctor posted- 4 > Hospital A, March, Doctor posted- 6 > > Hospital A, January, Patient visited- 3000 > Hospital A, February, Patient visited- 4000 > Hospital A, March, Patient visited- 6000 > > Hospital B, January, Doctor posted- 40 > Hospital B, February, Doctor posted- 50 > Hospital B, March, Doctor posted- 80 > > Hospital B, January, Patient visited- 4 > Hospital B, February, Patient visited- 3 > Hospital B, March, Patient visited- 4 > > ___ > If you want to calculate average number of patient seen by one doctor, you > can find- > Hospital A in January- 500 > Hospital A in February- 1000 > Hospital A in March- 1000 > > Now if you want to make the same indicator for first quarter there is no > way to calculate from 500, 1000, and 1000. There average is 833 which is > not actually expected result, even the sum 2500 is not also expected value. > > The best way is to make sum of patient as per the aggregation type of the > data element which gives (3000+4000+6000)= 13000 and make average number of > doctor posted for the period (6+4+6)/3= 5.33. Now if we done the > calculation for the indicator we found 13000/5.33= 2439 patient has been > seen averagely by one doctor in first quarter. > ___ > > Again, if you want to calculate the same indicator for- > Hospital A in January- 500 > Hospital B in January- 1000 > > Now, if you want to calculate for Hospital A and B together, there is no > way to find desired value from 500 and 1000. The average is 750 and sum is > 1500 which are not expected. > > The desired output should be (Patient visited hospital A in January, 3000 > + Patient visited hospital B in January, 4) / (Doctor posted in > Hospital A, 6 + Doctor posted in hospital B, 40). > Result 43000/46 = 934 patient per doctor. > ___ > > The same way of calculation is also applicable for indicators which build > in combination of organization unit, program indicators and others. > > Sorry for the long mail, but hope it clarifies. :-) > > Regards- > *Nayeem Al Mifthah* > *Health Information Systems Specialist* > Support to the National HMIS > MIS, Directorate General of Health Services > Ministry of Health and Family Welfare, Bangladesh > Telephone: +880-2-58816459|Fax: +880-2-58813875 > Mobile: +88-01914 030 574|Email: n.mift...@gmail.com > Skype: nayeem.a.m| LinkedIn: linkedin.com/in/nayeemam > > > On Wed, Sep 19, 2018 at 2:22 AM Calle Hedberg > wrote: > >> Folks, >> >> This has been repeated ad nauseam - as you say, most health indicators >> should in general be calculated as sum(numerator)/
Re: [Dhis2-users] [Dhis2-devs] Indicator totals count is incorrect
Folks, This has been repeated ad nauseam - as you say, most health indicators should in general be calculated as sum(numerator)/sum(denominator), whether it's aggregated in the time or in the geographic dimension. That is because most aggregated data elements used to calculate indicators are counts of many discrete events. Yes, we need some alternative processing for - "number only" indicators (aka "Calculated data elements") and certain indicators - indicators that include data elements representing "levels" (e.g. hospital beds, or staff numbers - those can be summed up geographically but must be averaged over time). Most of the underlying meta-concepts are in the DHIS already (data types, aggregation types), but implementing it fully requires quite a bit of re-engineering analytics - which hopefully will be done for 2.31 :-) Regards Calle On Tue, 18 Sep 2018 at 19:03, Nayeem Al Mifthah wrote: > Might be same behavior desires for totals as well. > > Regards, > Nayeem Al Mifthah > Kindly ignore typos. > > On Tue, 18 Sep 2018, 22:35 Nayeem Al Mifthah, wrote: > >> Hi Lars and others >> I have commented on an old issue DHIS2-575 about the desired behaviour ... >> >> I think expected behavior should calculate the element aggregation as per >> aggregation type of that perticular data elements first and later calculate >> the indicator. Example: >> >> If number of patient visited OPD in January is 200 and number of >> admission in January is 40. In that case, comparison of admission to OPD is >> 20%. >> >> And in February, number of OPD visit in February is 400 and admission is >> 200. % of admission to OPD in February will be 50%. >> >> >> >> If I want to see the same indicator in January+February, it is showing >> liniar average of two months indicator like (20+50)/2= 35% >> >> It should show, (40+200)/(200+400)=30% >> >> I think it should aggregate the element according to aggregation type of >> that element at first and then calculate indicator. >> >> >> Regards, >> Nayeem Al Mifthah >> Kindly ignore typos. >> >> >> On Tue, 18 Sep 2018, 22:14 Lars Helge Øverland, wrote: >> >>> Hi Gourav, >>> >>> thanks and, perhaps surprisingly, this is expected behavior as of now. >>> Indicators are often percentages, and it does not make sense to summarize a >>> lot percentages across different indicators; it makes more sense to average >>> them. >>> >>> That said, sometimes indicators represents plain sums of data elements >>> (no denominator, or denominator = 1), so we are working on some refinements >>> here which we will backport. >>> >>> best, >>> >>> Lars >>> >>> >>> On Tue, 18 Sep 2018 at 08:09, gourav sachdeva < >>> gouravsachdev...@gmail.com> wrote: >>> >>>> Hello Team, >>>> >>>> I'm facing an issue in a pivot table, version 2.28 while calculating >>>> the total of indicators. >>>> >>>> Whenever I try to generate the pivot report with indicators it shows >>>> the average instead of the sum in the total section. I checked, the same >>>> issue has been created on Jira and the status is resolved but I am still >>>> facing the above mentioned. >>>> >>>> https://jira.dhis2.org/browse/DHIS2-3350 >>>> >>>> Version: 2.28 >>>> Build Revision: 6657e9d >>>> Build Date: 2018-09-17 03:20 >>>> >>>> The screenshot is enclosed for the reference with the mail. >>>> Looking forward to your response. >>>> >>>> -- >>>> *Thanks & Regards,* >>>> >>>> *Gourav Sachdeva* >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : dhis2-d...@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>> >>> >>> -- >>> Lars Helge Øverland >>> Technical lead, DHIS 2 >>> University of Oslo >>> l...@dhis2.org >>> https://www.dhis2.org >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >> ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Uniqueness of organisation unit name
Hi, There are only unique constraints for the fields "uid" and "code". That said, I/we have always ensured that at least the main name is factually unique too - the short name is a different matter (although I would argue that ensuring unique short names within e.g. a district or state/province is a good idea, since reports etc for such smaller areas tend to be facility or sub-facility based. For larger countries, we normally use a sub-national prefix to ensure uniqueness (e.g. a two-character prefix representing the province, like in South Africa, or the state, like in Nigeria). Ensuring uniqueness require a bit more discipline when creating/maintaining orgunits, but you get that time back and more so by avoiding other problems (the import using Name scheme is one of them, but any output object using those names are usually the main problem). Regards calle On Sun, 9 Sep 2018 at 21:50, Nayeem Al Mifthah wrote: > Noted with thanks. > > Regards, > Nayeem Al Mifthah > Kindly ignore typos. > > On Sun, 9 Sep 2018, 23:13 Knut Staring, wrote: > >> Unless you know they are unique >> >> On Sun, Sep 9, 2018, 7:10 PM Nayeem Al Mifthah >> wrote: >> >>> Thanks Knut. In that case using orgunit name as a ID scheme for data >>> import may not work. >>> >>> [image: image.png] >>> >>> >>> Regards, >>> Nayeem Al Mifthah >>> Consultant for HSS, HMIS, M, GIS and Surveillance >>> >>> Kindly ignore typos. >>> >>> On 9 Sep 2018 11:03 pm, "Knut Staring" wrote: >>> >>> I think this is a feature, not a bug >>> >>> On Sun, Sep 9, 2018, 6:54 PM Nayeem Al Mifthah >>> wrote: >>> >>>> Dear All >>>> I have found that, Organisation unit name is accepting duplicate names. >>>> Is it allowed now a days? or a bug? I have created a number of Sierra Leone >>>> in 2.30 demo. Only Code field check duplicates. >>>> >>>> [image: image.png] >>>> *Nayeem Al Mifthah* >>>> *Health Information Systems Specialist* >>>> Support to the National HMIS >>>> MIS, Directorate General of Health Services >>>> Ministry of Health and Family Welfare, Bangladesh >>>> Telephone: +880-2-58816459|Fax: +880-2-58813875 >>>> Mobile: +88-01914 030 574|Email: n.mift...@gmail.com >>>> Skype: nayeem.a.m| LinkedIn: linkedin.com/in/nayeemam >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : dhis2-users@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>> >>> ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Discrepancy in table table programstageusergroupaccesses in version 2.29
Hi, Well spotted - the problem here is the NAMES for the column and the constraints' foreign key - I presume it is supposed to be column programstageid (not programid) and constraint foreign key programstageid (not programid). NOTE that both FK constrainst need updating. i can confirm that the "programid" DATA stored in the programstageusergroupaccesses table refers to the programstageid values in the programstaget table, NOT the programid values in the same table. So submit a JIRA "bug" report for it - I cannot see that it will result in any failures, but naming conventions should be consistent. Regards Calle On Tue, 28 Aug 2018 at 12:55, Mithilesh Kumar Thakur < mithilesh.h...@gmail.com> wrote: > Hi,Team > > while i am checking database structure of version 2.29 i am see the > following discrepancy > > in programstageusergroupaccesses table there is two columns programid > and usergroupaccessid and column programid is reference to table > programstage (programstageid) > > please see below the structure of table programstageusergroupaccesses > > CREATE TABLE public.programstageusergroupaccesses > ( > programid integer NOT NULL, > usergroupaccessid integer NOT NULL, > CONSTRAINT programstageusergroupaccesses_pkey PRIMARY KEY (programid, > usergroupaccessid), > CONSTRAINT fkbm0pqhdj9xudinnssoxjdgq6b FOREIGN KEY (programid) > REFERENCES public.programstage (programstageid) MATCH SIMPLE > ON UPDATE NO ACTION ON DELETE NO ACTION, > CONSTRAINT fkhrmc5b26i4fv714agdvwm2tly FOREIGN KEY (usergroupaccessid) > REFERENCES public.usergroupaccess (usergroupaccessid) MATCH SIMPLE > ON UPDATE NO ACTION ON DELETE NO ACTION, > CONSTRAINT uk_tcggvcb1rsd9tlnd1ub7mt0e0 UNIQUE (usergroupaccessid) > ) > WITH ( > OIDS=FALSE > ); > ALTER TABLE public.programstageusergroupaccesses > OWNER TO dhis; > -- > > Thanks and Regards > > Mithilesh Kumar Thakur > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Event Sync Error From Dhis2 Mobile App V2.29
Sourabh, This bug affects the browser too, blocking data capture. Viet is investigating the issue, according to Markus. No other info yet. Regards calle On Thu, 23 Aug 2018 at 15:07, Sourabh Bhardwaj wrote: > Hi All, > > We have recently upgrade Dhis2 from version 2.27 to 2.29. While trying to > sync enrollment/events from android app , I am able to sync enrollment but > following response is coming for event sync: > > *Failed to lazily initialize a collection of > role:org.hisp.dhis.dataelement.DataelementCategoryOptionCombo.categoryOptions, > could not initialize proxy: no sessions* > > However I am able to sync events successfully using the 'superuser' > access. Is there any role related to CategoryOptionCombo which I am > missing on if so,I am using tracker module only not the aggregated. > > I have attached the screenshot below with this email: > > Thanks & Regards, > Sourabh Bhardwaj > HISP India > > > > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Delete Validation Rules
Hi I do NOT agree that it should be possible to delete data elements that have datavalue or tracker records - in such cases where there is real DATA, the user must assess and delete such DATA first or else leave the data element no longer in use (with its data) - we typically move such historical data elements to an "inactive" data set. On the other hand, I have found many meta-data objects where deletion is being blocked due to (sometimes random) records in other meta-data tables - meta-data that clearly won't be relevant any more (e.g. various tables called "dimensionitems" is a typical example). It is also a huge problem that when e.g. data elements - even data elements with no actual data - at some stage were included in some favourite, deletion is blocked AND the error message says nothing about WHERE it is used. I always end up spending considerable time tracking those down in the back end and deleting them, before being able to delete the data element itself. Audit trails is another example of "process" data that no longer is useful when e.g. a data element is deleted. Regards Calle On Mon, 20 Aug 2018 at 11:35, Em Le Hong wrote: > Hi, > > I agree with Calle Hedberg that the system should automatically delete any > dependent records related to validation rules. > In DHIS2, this kind of issue is not only happen with Validation rules, but > also with many other objects. > > For example to delete a data element, we need to delete its data value and > audit trail. DHIS2 already provided API to delete data value and audit trail > */api/26/maintenance/dataPruning/dataElement/* > > I hope DHIS2 will support to delete validation rules and other objects > soon. > > On Wed, Aug 8, 2018 at 7:47 PM Calle Hedberg > wrote: > >> Hi >> >> Agree with Morten that it's a bug - it should be obvious that if you >> delete a validation rule, any old validation rule results are no longer of >> interest (with the rule deleted, you would not even know which rule any >> remaining results were referring too). >> >> So the solution here is that when you delete a validation rule, the >> system should automatically first delete any dependent records in the >> following tables, which have validationruleid as a foreign key: >> >> "validationnotificationtemplatevalidationrules" >> "validationresult" >> "validationruleattributevalues" >> "validationrulegroupmembers" >> "validationruleorganisationunitlevels" >> "validationrulesynchstatus" >> "validationruletranslations" >> "validationruleuseraccesses" >> "validationruleusergroupaccesses" >> >> Regards >> Calle >> >> On Wed, 8 Aug 2018 at 07:03, Morten Olav Hansen wrote: >> >>> Hi Em >>> >>> I'm not sure if there is any UI for deleting validation results, but you >>> can do it yourself in the database. >>> >>> The validationresults are located in the table "validationresult", and >>> it has a column called "validationruleid" which links to your validation >>> rules. >>> >>> So you need to find that validation rule in the "validationrule" table, >>> and use that "validationruleid" to delete the correct rows from the >>> "validationresult" table. >>> >>> "DELETE FROM validationresult WHERE validationruleid=??" >>> >>> This does sound like a bug though, so please file one in JIRA >>> >>> -- >>> Morten Olav Hansen >>> Senior Engineer, DHIS 2 >>> Team Integration Lead >>> University of Oslo >>> http://www.dhis2.org >>> >>> On Tue, Aug 7, 2018 at 5:07 PM, Em Le Hong >>> wrote: >>> >>>> Dear all, >>>> >>>> DHIS 2.29 >>>> >>>> I try to delete a validation rule on my database but the system >>>> response a message: >>>> Could not delete due to association with another object: >>>> ValidationResult >>>> >>>> This mean we need to delete Validation Result before delete Validation >>>> Rule >>>> >>>> Does anyone know how to delete Validation Result, if you don't mind >>>> please share. >>>> >>>> Thanks, >>>> -- >>>> *Em Le Hong* >>>> DHIS2 Implementation| *HISP Vietnam * >>>> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com >>>> >>>> >>>> >>>> >>>> &
Re: [Dhis2-users] [Dhis2-devs] Delete Validation Rules
Hi Agree with Morten that it's a bug - it should be obvious that if you delete a validation rule, any old validation rule results are no longer of interest (with the rule deleted, you would not even know which rule any remaining results were referring too). So the solution here is that when you delete a validation rule, the system should automatically first delete any dependent records in the following tables, which have validationruleid as a foreign key: "validationnotificationtemplatevalidationrules" "validationresult" "validationruleattributevalues" "validationrulegroupmembers" "validationruleorganisationunitlevels" "validationrulesynchstatus" "validationruletranslations" "validationruleuseraccesses" "validationruleusergroupaccesses" Regards Calle On Wed, 8 Aug 2018 at 07:03, Morten Olav Hansen wrote: > Hi Em > > I'm not sure if there is any UI for deleting validation results, but you > can do it yourself in the database. > > The validationresults are located in the table "validationresult", and it > has a column called "validationruleid" which links to your validation rules. > > So you need to find that validation rule in the "validationrule" table, > and use that "validationruleid" to delete the correct rows from the > "validationresult" table. > > "DELETE FROM validationresult WHERE validationruleid=??" > > This does sound like a bug though, so please file one in JIRA > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > Team Integration Lead > University of Oslo > http://www.dhis2.org > > On Tue, Aug 7, 2018 at 5:07 PM, Em Le Hong > wrote: > >> Dear all, >> >> DHIS 2.29 >> >> I try to delete a validation rule on my database but the system response >> a message: >> Could not delete due to association with another object: ValidationResult >> >> This mean we need to delete Validation Result before delete Validation >> Rule >> >> Does anyone know how to delete Validation Result, if you don't mind >> please share. >> >> Thanks, >> -- >> *Em Le Hong* >> DHIS2 Implementation| *HISP Vietnam * >> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com >> >> >> >> >> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Could not save data set (Invalid reference [e1sXdbpUsU7]
Adolphe Could the data set have one or more data elements with an outdated categorycombo? Individual data elements in a data set can now have "over-riding" categorycombos set (I cannot off hand recall it that was introduced in 2.27 or 2.28) Maybe try to run something like this in SQL view or in postgresql directly: SELECT dse.dataelementid, de.name, dse.categorycomboid FROM datasetelement dse inner join categorycombo cc on cc.categorycomboid=dse.categorycomboid inner join dataelement de on de.dataelementid=dse.dataelementid inner join dataset ds on ds.datasetid=dse.datasetid where cc.uid='e1sXdbpUsU7' and ds.uid='NXTpxbBK5lf'; Regards Calle On 24 July 2018 at 11:56, Kamugunga Adolphe wrote: > Hi, > Can someone assist on how to deal with this error message "Could not save > data set (Invalid reference [e1sXdbpUsU7] (DataElementCategoryCombo) on > object Chronic Diseases [NXTpxbBK5lf] (DataSet) for association > `categoryCombo`.) " while trying to save the edited data set? > > I am running instance on 2.28 with Build revision: a5da35f and Build date: > 2018-07-23 06:24 > > We have datasets with expiry days, and we have changed it to 0 to allow > data managers to updated reports. afterwards we want reset it and save, and > system complains of finding reference id. It happens also while someone > edit dataset and save even though no changes made on dataset. Here is the > > Regards, > > > *Adolphe Kamugunga* > *MIS Technical Advisor* > Mobile: +250 788 740 578 > Email:kaa...@gmail.com > Skype: ka.adolphe > RWANDA > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] usage of "light" web module
Hi I cannot recall having encountered any use of this the last few years. Suggest removing it from 2.30, but keep a functional "backup" just in case If nobody yells within the first 2 months, then dump it ;-) Regards Calle On 25 June 2018 at 14:41, Lars Helge Øverland wrote: > > Bringing the usage of "light" module to people's attention again. I have > only received one message on this topic which says it is not used. Does > this mean that we can remove this module from DHIS 2? Any reasons not to > remove it out there? > > regards, > > Lars > > > > > > > On Thu, 14 Jun 2018 at 13:44, Lars Helge Øverland wrote: > >> Hi all, >> >> the "light" web module for data entry, typically used by low-end mobile >> phones, is aging. We are interested in learning to what extent this module >> is being used to understand whether we should invest in developing a new >> version of it. If you are using the module, or aware of anyone using it, >> please let us know either here on the list or directly to me. >> >> This is the module being referred to: https://play.dhis2.org/2. >> 29/light/index.action >> >> best regards, >> >> Lars >> >> >> -- >> Lars Helge Øverland >> Technical lead, DHIS 2 >> University of Oslo >> l...@dhis2.org >> https://www.dhis2.org >> >> > > -- > Lars Helge Øverland > Technical lead, DHIS 2 > University of Oslo > l...@dhis2.org > https://www.dhis2.org > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Editing of Program Rules
Barnabas, It looks like something went a bit wrong during the upgrade, and that your programindicator records do not have the related analtyticsperiodboundary records (2 of them, start and end, are supposed to be automatically inserted during the startup after the upgrade). 1. Did you run the upgrade script before starting the instance on 2.29 exactly like this: -- *** NOTE *** -- From 2.29 UserRole-DataSet and UserRole-Program relations are replaced by the new Data Sharing level -- To migrate from 2.28 to 2.29 and apply new data sharing for existing data, do the following steps: -- 1) Execute below scripts (the upgrade script) -- 2) Start the DHIS2 server. -- 3) Then run the migration by executing this SQL: select migrateRoleToUserGroup(); -- 4) Restart server. 2. In order to (most likely) fix your immediate problem, you can try to run select migrateRoleToUserGroup(); again and then restart if you have direct database access, you can also check that the table analyticsperiodboundary has two records for each programindicator record. Regards Calle On 25 May 2018 at 20:11, Barnabas Akumba <akumbaba...@gmail.com> wrote: > Sorry. I meant Program indicators page > > On Fri, May 25, 2018 at 7:09 PM, Barnabas Akumba <akumbaba...@gmail.com> > wrote: > >> Hello All, >> >> I have upgraded an instance from 2.28 to 2.29 and tried to edit a program >> rule but the page fails to load. A look at the browser console shows the >> attached errors. >> >> Any one with an idea of what could be responsible for this and how it can >> be resolved? >> >> Any information will be appreciated. >> >> Regards >> >> -- >> >> Barnabas AKUMBA >> >> *Mobile:* +2348036195778 >> *Skype:* barnabas.akumba >> > > > > -- > > Barnabas AKUMBA > > *Mobile:* +2348036195778 > *Skype:* barnabas.akumba > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Failed to update the event in the server
Edouard, What do you see in the console (assuming Chrome, press CTRL-SHIFT-J)? Regards calle On 24 May 2018 at 12:16, Edouard Lavaud <edouard.lav...@gmail.com> wrote: > Hi there, > > In one of the instance I installed (2.29 in a local environment), a popup > message appears on screen with "Failed to update the event in the server, > could not execute statement". > It is kind of random and data are still well saved. > > Does that sound familiar to anybody? > > Best, > > Edouard > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] unable to edit a program stage instance (re-published)
Bernard, Are you sure you have SELECTED the orgunit on the left side (hierarchy), and not only listed cases and opened them? I had a similar issue some weeks back - I used "LIST ALL" and selected a case. It then opens in read-only mode. So you have to specifically select/highlight orgunits on the left side, then select the specific case - it will then (normally) open in edit mode If not that - press CTRL-SHIFT-J to open the console. any message there when opening a case? Note also DHIS2-3775, a bug I just reported - it's a showstopper Regards calle On 21 May 2018 at 11:42, Bernard Sadaka (IM Advisor) <lib@pu-ami.org> wrote: > Dear All, > > Our team is facing a problem with editing some program stage instances > that are open (not completed) and their enrollment is not completed. > > I am superuser and usually I am able to edit any instance but I still > can’t edit these ones even after clearing browser cache, deleting cookies, > logging in from incognito browsing, different computer, different internet > network… > > My best guess is that someone else might be editing that instance which is > causing other users to not be able to edit it. > > Have you faced similar problems? > > Any idea how to solve it? > > Ou current workaround: We are forcefully creating a new instance with the > same data and deleting the old instance; this solution is not really > sustainable since we are facing similar cases 10-15 times in the same day. > > Here’s a screenshot: > > > > Looking forward to hearing about your experience in this. > > > > All the best, > > Bernard > > > > [image: cid:image002.png@01D36F50.572585A0] > > *Bernard Sadaka* > > *Information Management Advisor* > > Première Urgence - Aide Médicale Internationale > > Nehmeh Building, Sanine Street, Chiyah, 3rd Floor > > Ain el Remmaneh, Beirut, Lebanon > > *E-mail:* lib@pu-ami.org > > *Cell:* +961 71 004 881 (208) > > *Skype:* imapuami > > *Website:* https://www.pu-ami.org > > > > > > > <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=icon> > Virus-free. > www.avast.com > <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=link> > <#m_-7061032963367630730_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Min Max Violations Preventing Data Set Complete when Passing Validations are Compulsory
Hi I agree with Pamod on this issue - from the very start of DHIS in 1997, min/max violations have always been regarded as "soft" violations - which means the user gets a warning but should not be blocked from continuing. That is different from the typical "absolute' validation rules which are "hard", like when you have a rule that the number of positives cannot be higher than the number tested (for whatever). Min/max values represent the NORMAL range of a data element / variable - not the absolute range (note: DHIS 1.4 supported defining ABSOLUTE min-max values, but DHIS2 does not) Regards from Sierra Leone Calle On 16 May 2018 at 07:59, Pamod Amarakoon <pam...@gmail.com> wrote: > Dear All, > > We have a data set which has been configured as passing validation rules > is compulsory for the data set to be completed. When we set up Min Max > rules, any violation is shown as a validation rule violation when > validation rule analysis is run which in turn prevents the user from > completing the data set. This was demonstrated in 2.28 build version > 3c2ba0b. > > Is this the expected behavior. I feel that it is okay to display Min/Max > violations as a validation rule violation but it should allow the user to > proceed completing the data set provided if he has put a comment etc. Since > Min/Max is set as a data quality check but not necessarily an error in data > entry (what is checked by validation rules), I think there should be a > provision to proceed completing data set. > > -- > Regards, > Pamod Amarakoon > MBBS (SL) > MSc (Biomedical Informatics), EMSc (Health Admin), PGCert (MedEd), CEH > HISP Sri Lanka > > Confidentiality Notice: the information contained in this email and any > attachments may be legally privileged and confidential. If you are not an > intended recipient, you are hereby notified that any dissemination, > distribution, or copying of this e-mail is strictly prohibited. If you have > received this e-mail in error, please notify the sender and permanently > delete the e-mail and any attachments immediately. You should not retain, > copy or use this e-mail or any attachments for any purpose, nor disclose > all or any part of the contents to any other person. > > > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Program Rule not responding to "false" data type
Hi use 1 (yes/true) and 0 (no/false) instead regards calle On 15 May 2018 at 16:35, Seleman Ally <seleman_a...@yahoo.com> wrote: > Dear Team, > > For a several versions of DHIS2 (Including 2.29), I have been struggling > to create *responsive* Program Rule for attribute or data elements with > Yes/No type. There is no problem at all on *Yes =false* part, but I > haven't been successful when the action is related with *false* part. > > Let me know what is not happening? > > Regards > > > > Sele > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Analytics taking too much time for tracker
m? >>> >>> We are using DHIS2 version 2.28 release 533e983. >>> >>> Need immediate help. >>> >>> Regards >>> >>> Muhammad Abdul Hannan Khan >>> Team Leader >>> Support to the National HMIS >>> MIS, Directorate General of Health Services >>> Ministry of Health and Family Welfare >>> >>> T +880-2- 58816459, 58816412 ext 118 >>> F +88 02 58813 875 >>> M+88 01819 239 241 >>> M+88 01534 312 066 >>> E hann...@gmail.com >>> S hannan.khan.dhaka >>> B hannan-tech.blogspot.com >>> L https://bd.linkedin.com/in/hannankhan >>> >>> >>> >>> >> > > > -- > Muhammad Abdul Hannan Khan > Team Leader > Support to the National HMIS > MIS, Directorate General of Health Services > Ministry of Health and Family Welfare > > T +880-2- 58816459, 58816412 ext 118 > F +88 02 58813 875 > M+88 01819 239 241 > M+88 01534 312 066 > E hann...@gmail.com > S hannan.khan.dhaka > B hannan-tech.blogspot.com > L https://bd.linkedin.com/in/hannankhan > > > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] SQL or api listing between Enrollement and stages
Sorry The above are apps and thus API-related. For SQL views, you can set up a view for the relevant Analytics tables yourself - painful, but doable: Analytics_enrollment.. (one for each tracker programme) Analytics_event. (one programme per year) Regards Calle On 24 April 2018 at 14:59, Calle Hedberg <calle.hedb...@gmail.com> wrote: > Djibril, > > Using Event Reports, you can run a report with enrollment attributes plus > data elements from ONE stage. > > For multi-stage support, you have to wait: Ismail et all from HISP-Tz is > working on one app for this, HISP-india has developed one (that nobody else > seemingly can get to work), and the core team is working on one for 2.30 > (see DHIS2-2461) > > Regards > Calle > > On 24 April 2018 at 12:14, DJIBRIL Hakim <djib.ha...@gmail.com> wrote: > >> Hi All, >> Could someone share with me a way to get listing for a tracker program >> based on lastest stages with the enrollment informations ? >> Thank you >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > > *** > > Calle Hedberg > > 46D Alma Road, 7700 Rosebank, SOUTH AFRICA > > Tel/fax (home): +27-21-685-6472 > > Cell: +27-82-853-5352 > > Iridium SatPhone: +8816-315-19119 > > Email: calle.hedb...@gmail.com > > Skype: calle_hedberg > > *** > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] SQL or api listing between Enrollement and stages
Djibril, Using Event Reports, you can run a report with enrollment attributes plus data elements from ONE stage. For multi-stage support, you have to wait: Ismail et all from HISP-Tz is working on one app for this, HISP-india has developed one (that nobody else seemingly can get to work), and the core team is working on one for 2.30 (see DHIS2-2461) Regards Calle On 24 April 2018 at 12:14, DJIBRIL Hakim <djib.ha...@gmail.com> wrote: > Hi All, > Could someone share with me a way to get listing for a tracker program > based on lastest stages with the enrollment informations ? > Thank you > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *********** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Get number of days between two event dates in different program stages
Hi
DHIS2 does not currently support V{event_date} for a specific stage - it
will always pick the anchor/report date for the most current event.
This is supposed to be fixed in 2.30 - see JIRA issue DHIS2-1397
Regards
Calle
On 19 April 2018 at 06:13, Marko David Garcia <markodavi...@gmail.com>
wrote:
> Hello friends!.
> Is there a solution for 2.25 version?.
> Thank you very much.
> Regards.
>
> Cordialmente,
>
> *Marko David Garcia M.*
> *Skype: marko_david*
>
> 2018-04-11 1:54 GMT-05:00 Edouard Lavaud <edouard.lav...@gmail.com>:
>
>> Hi Rady,
>>
>> I used a kind of hack for doing that:
>>
>> I first used a program rule to copy the event_date into a new data
>> element of the program stage (so, yup, the date is kind of duplicated
>> in the stage).
>>
>> However then I could create a program rule variable to fetch this date
>> I wanted, and compare it with another one.
>>
>> Hope this could help.
>>
>> Best,
>>
>> Edouard
>>
>> 2018-04-11 6:39 UTC+02:00, Rady <tryr...@gmail.com>:
>> > Hello DHIS2 community,
>> >
>> > I have a doubt how to get number of days between two event dates in
>> > different program stages. For example,
>> > *d2:daysBetween(programstage1.V{event_date},programstage2.V{
>> event_date})*.
>> >
>> > Anybody used to have experience on this? please help.
>> >
>> > Thanks,
>> > Rady
>> >
>>
>>
>> --
>> *Edouard Lavaud, *
>>
>>
>>
>> *MSc in Health Policy, Planning & FinancingMEng in
>> TelecommunicationUniversity Diploma in ICT for Health*
>> *Email:* edouard.lav...@gmail.com
>> *Mobile:* 0033 6 7210 23 59
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help : https://help.launchpad.net/ListHelp
>>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
>
--
***
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19119
Email: calle.hedb...@gmail.com
Skype: calle_hedberg
***
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Analytics not stopping
rrent.FutureTask.run(Unknown Source) > > at java.util.concurrent.ScheduledThreadPoolExecutor$ > ScheduledFutureTask.access$201(Unknown Source) > > at java.util.concurrent.ScheduledThreadPoolExecutor$ > ScheduledFutureTask.run(Unknown Source) > > at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown > Source) > > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown > Source) > > at java.lang.Thread.run(Unknown Source) > > Caused by: org.postgresql.util.PSQLException: ERROR: relation > "analytics_2017" does not exist > > Position: 65 > > at org.postgresql.core.v3.QueryExecutorImpl. > receiveErrorResponse(QueryExecutorImpl.java:2476) > > at org.postgresql.core.v3.QueryExecutorImpl. > processResults(QueryExecutorImpl.java:2189) > > at org.postgresql.core.v3.QueryExecutorImpl.execute( > QueryExecutorImpl.java:300) > > at org.postgresql.jdbc.PgStatement.executeInternal( > PgStatement.java:428) > > at org.postgresql.jdbc.PgStatement.execute( > PgStatement.java:354) > > at org.postgresql.jdbc.PgStatement.executeWithFlags( > PgStatement.java:301) > > at org.postgresql.jdbc.PgStatement.executeCachedSql( > PgStatement.java:287) > > at org.postgresql.jdbc.PgStatement.executeWithFlags( > PgStatement.java:264) > > at org.postgresql.jdbc.PgStatement.executeQuery( > PgStatement.java:231) > > at com.mchange.v2.c3p0.impl.NewProxyStatement. > executeQuery(NewProxyStatement.java:327) > > at org.springframework.jdbc.core.JdbcTemplate$ > 1QueryStatementCallback.doInStatement(JdbcTemplate.java:458) > > at org.springframework.jdbc.core.JdbcTemplate.execute( > JdbcTemplate.java:408) > > ... 18 more > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] How doing analytics on relationship in tracker
Hi Currently, there isn't really any analysis/reporting tools supporting this. You will have to use sql views or similar "back-end" analysis tools Multi-program analysis is making inroads into the roadmap ( ;-) ), but it's not clear when and to what extent yet. regards Calle On 5 March 2018 at 15:55, DJIBRIL Hakim <djib.ha...@gmail.com> wrote: > Hello all, > How to analyse informations in tracker based on Relationship option ; > Like mother and child? > > Best > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Program indicators export to another system
Knut I did that for IDSR/Malaria in order to "map" local IDSR program indicators to the WHO aggregated malaria data elements. It is, frankly, a painful and "expert" approach to the problem, and in my opinion very difficult to maintain. The presumably simplest solution is to expand the "Data Value Set" download option under the pivot table app to incorporate the optional use of CODES or NAMES. While some might argue that using the same code or name for a Program Indicator as for an aggregated data element is not "purist", it should work. A more sophisticated solution that would be useful for any type of data import is to introduce data element and organisationunit "mapping" during import - similar functionality has been available in DHIS v1 since time immemorial. Users can then define/store/use two lookup field values: uid (or code/name) INCOMING, and uid (or code/name) IMPORTING. So incoming uid/code/name will automatically be replaced by the equivalent/correct value before the system start POSTing records. Regards Calle On 1 February 2018 at 18:07, Knut Staring <knu...@gmail.com> wrote: > Hi Elmarie, > > This is an important issue, and I expect others will have a better answer, > but one approach could perhaps be to replace the UID for the Programme > Indicators with the desired data element UID. I suppose that would have to > be done either directly in the database or through the API, but if it were > to be a recommended way to link databases it should also be possibly to do > this kind of mapping through the user interface > > Knut > > On Thu, Feb 1, 2018 at 4:59 PM, Elmarie Claasen <elma...@hisp.org> wrote: > >> Hi all, >> >> Any response to this question? >> >> Regards >> >> Elmarie >> >> On 30 Jan 2018 12:11, "Elmarie Claasen" <elma...@hisp.org> wrote: >> >>> Hi all, >>> >>> >>> >>> We create Programme Indicators and would like to export those to other >>> systems with different data element UIDs than the created Programme >>> Indicator UID. >>> >>> If adding a code to the Programme Indicator which is same as the Data >>> Element code will this allow matching on import? >>> >>> >>> >>> Regards, >>> >>> >>> >>> *Elmarie Claasen* >>> >>> [image: Hisp logo] >>> >>> Project Manager >>> >>> Health Information Systems Program >>> >>> Tel: 041-367 1027 >>> >>> Cell: 082 374 2209 >>> >>> E-mail: elma...@hisp.org >>> >>> Skype: elmarie.claasen52 >>> >>> >>> >> >> *This message and any attachments are subject to a disclaimer published >> at http://www.hisp.org/policies.html#comms_disclaimer >> <http://www.hisp.org/policies.html#comms_disclaimer>. Please read the >> disclaimer before opening any attachment or taking any other action in >> terms of this electronic transmission. If you cannot access the >> disclaimer, kindly send an email to disclai...@hisp.org >> <disclai...@hisp.org> and a copy will be provided to you. By replying to >> this e-mail or opening any attachment you agree to be bound by the >> provisions of the disclaimer.* >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Knut Staring > > Department of Information, Evidence and Research > World Health Organization, Geneva, Switzerland > Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931 > <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522 > Skype: knutstar > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Organisation Units repetitive structure
1. Organisation A >>2. Base 2 >>3. PHCC 7 >>4. Test Base 1 >>5. Test PHCC 1 >>6. Test PHCC 4 >>7. Test PHCC 2 >>8. Test PHCC 5 >>9. Test PHCC 6 >>10. Test PHCC 7 >>11. Test Org A >>12. Test Base 2 >> >> >> >> Your help is appreciated. >> >> >> >> All the best, >> >> Bernard >> >> >> >> [image: cid:image002.png@01D36F50.572585A0] >> >> *Bernard Sadaka* >> >> *Information Management Advisor* >> >> Première Urgence - Aide Médicale Internationale >> >> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor >> >> Ain el Remmaneh, Beirut, Lebanon >> >> *E-mail:* lib@pu-ami.org >> >> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208) >> >> *Skype:* imapuami >> >> *Website:* https://www.pu-ami.org >> >> >> >> >> >> *From:* Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org] >> *Sent:* Monday, January 29, 2018 2:29 PM >> *To:* 'Knut Staring' <knu...@gmail.com> >> *Cc:* 'DHIS 2 Users list' <dhis2-users@lists.launchpad.net>; 'DHIS 2 >> developers' <dhis2-d...@lists.launchpad.net> >> *Subject:* RE: [Dhis2-users] Organisation Units repetitive structure >> >> >> >> Thank you Knut, >> >> The console error while at the pivot table and viewing the org units is >> “Cannot read property ‘internalId’ of undefined ” as per the bellow >> screenshot: >> >> >> >> My setup is Tomcat+ postgres+ Ubuntu 16.04.3LTS+ Certbot (for SSL)+nginx >> (for reverse proxy) >> >> >> >> As for the catalina.out, what should I be looking exactly for in there? >> Because when I go to the pivot table section while monitoring catalina.out >> there’s no exception thrown/shown using “tail –f catalina.out” (even after >> cleaning the browser cache) >> >> >> >> Thank you in advance for your invaluable help. >> >> >> >> Looking forward to hearing from you. >> >> >> >> All the best, >> >> Bernard >> >> >> >> [image: cid:image002.png@01D36F50.572585A0] >> >> *Bernard Sadaka* >> >> *Information Management Advisor* >> >> Première Urgence - Aide Médicale Internationale >> >> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor >> >> Ain el Remmaneh, Beirut, Lebanon >> >> *E-mail:* lib@pu-ami.org >> >> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208) >> >> *Skype:* imapuami >> >> *Website:* https://www.pu-ami.org >> >> >> >> >> >> *From:* Knut Staring [mailto:knu...@gmail.com <knu...@gmail.com>] >> *Sent:* Monday, January 29, 2018 1:04 PM >> *To:* Bernard Sadaka (IM Advisor) <lib@pu-ami.org> >> *Cc:* DHIS 2 Users list <dhis2-users@lists.launchpad.net>; DHIS 2 >> developers <dhis2-d...@lists.launchpad.net> >> *Subject:* Re: [Dhis2-users] Organisation Units repetitive structure >> >> >> >> Hi Bernard, >> >> >> >> In order to elucidate what is going on, the next places to check are the >> browser console and the server log. >> >> >> >> 1) In Chrome, click on Ctrl+Shit+I to open the console window and look >> for error messages in RED. >> >> >> >> 2) For the server, look for catalina.out in the logs folder (What is your >> setup? Tomcat or DHIS Live?. Operating system?) >> >> >> >> Regards, >> >> Knut >> >> >> >> On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) < >> lib@pu-ami.org> wrote: >> >> Hello All, >> >> I’m sending this message to seek your help in solving a problem with >> repetitive organization unit structure in the pivot tables section as well >> as user management and others: >> >> · The same org units are showing under their respective org unit >> and alone multiple times. >> >> · The org units in pivot tables keep trying to load each of >> their data without finishing (attached/bellow a screenshot) >> >> I tried but failed to find a similar bug in the JIRA. >> >> I tried to perform Maintenance, browser cache cleaner, login using >> incognito browsing… nothing worked. >> >> Is there a script or database queries I can run to fix this? >> >> >> >> All the best, >> >> Bernard
Re: [Dhis2-users] [Dhis2-devs] Option sets and data elements
Hi, Cascading option sets have been recognised as a need for quite some time - see DHIS2-431. We have so far not managed to get this prioritised high enough, but I've had some preliminary discussions with Markus on how to do it Regards Calle On 30 January 2018 at 12:30, Knut Staring <knu...@gmail.com> wrote: > Hi Nada, > > Are you collecting the same data at two levels? Is it a type of survey > question regarding the organisational unit? > > Perhaps you could have two different data elements linked to different > data sets, which can then in turn be assigned at different levels? > > Knut > > On Mon, Jan 29, 2018 at 12:11 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Hi Nada, >> >> This sounds like a "cascading drop down". This is not supported directly >> in DHIS2, so you will need to implement your own front-end solution for >> this. >> >> Regards, >> Jason >> >> >> On Sat, Jan 27, 2018 at 9:49 AM, Nada Ghosn <esumoh...@gmail.com> wrote: >> >>> Good morning, >>> Reference is made to tacker/event capture >>> Is it possible to have one data element having different option sets >>> based on specific criteria? >>> >>> Example: >>> data element_province (text) >>> data element_district. >>> Based on the value of the data element_province, the data >>> element_district will show different option sets. >>> >>> Sincerely >>> NG >>> >>> -- >>> Nada Ghosn, MD >>> Head, Epidemiology Surveillance Program (Esumoh) >>> Ministry of Public Health >>> Beirut, Museum square >>> Lebanon >>> Tel +961.1.614194 <+961%201%20614%20194> >>> Fax +961.1.610920 <+961%201%20610%20920> >>> Email esumoh...@gmail.com, esu...@moph.gov.lb >>> Website www.moph.gov.lb >>> >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Jason P. Pickering >> email: jason.p.picker...@gmail.com >> tel:+46764147049 <+46%2076%20414%2070%2049> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Knut Staring > > Department of Information, Evidence and Research > World Health Organization, Geneva, Switzerland > Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931 > <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522 > Skype: knutstar > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Fast/bulk delete of events
Hi, For events without registration, bulk deleting directly in the database is easy: 1. Delete all relevant data element records in the table trackedentitydatavalue (and if relevant trackedentitydatavalueaudit) 2. Delete the "case" records in the table programstageinstance Alex' method using the webAPI is OK for moderate number of records, but can be painful for large numbers Regards Calle On 24 January 2018 at 22:41, Petar Jovanovic <pe...@essi.upc.edu> wrote: > Thanks a lot Alex! > > Anyhow, it would be a convenient feature for end users to do it through > the DHIS2 interface as well. > > Best, > Petar > > Obtener Outlook para Android <https://aka.ms/ghei36> > > > > > On Wed, Jan 24, 2018 at 9:32 PM +0100, "Alex Tumwesigye" < > atumwesi...@gmail.com> wrote: > > Hi, >> The easier way is to use the api/events endpoint and query for events >> uids you want to delete. Once you have them, you can send http delete >> method via curl or nodejs or python or php,etc and loop through each to >> delete them via api/events/uid. >> >> Alex >> >> On Wednesday, January 24, 2018, Petar Jovanovic <pe...@essi.upc.edu> >> wrote: >> >>> Hi, >>> >>> We want to quickly (in groups) delete events related to a specific >>> program and/or to a specific org unit (or list of org units). In DHIS2, we >>> only managed to go one by one in the event capture app. >>> >>> Can anyone recommend us any other convenient and faster way to do this, >>> or if you are aware of an app that may help us? >>> >>> We have also checked if it is possible to do it through the database, >>> but we did not find easy to locate the table where the event data are >>> stored and it is safe to delete them without loosing references to other >>> objects. >>> >>> >>> Thank you! >>> >>> >>> Best, >>> Petar >>> >>> -- >>> _ >>> Petar Jovanovic >>> Department of Service and Information System Engineering (ESSI) >>> Universitat Politècnica de Catalunya, BarcelonaTech >>> Barcelona, Spain >>> _ http://www.essi.upc.edu/~petar/ ___ >>> >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >> >> >> -- >> Alex Tumwesigye >> >> Technical Advisor - DHIS2 (Consultant), >> Ministry of Health/AFENET | HISP Uganda >> Kampala >> Uganda >> +256 774149 775, + 256 759 800161 >> Skype ID: talexie >> >> IT Consultant (Servers, Networks and Security, Health Information Systems >> - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant >> >> >> "I don't want to be anything other than what I have been - one tree hill " >> >> > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] CONTROLLING THE DIRECTION THE CURSOR-CUSTOM FORMS
Stanley,
You need a few extra snippets of code in the custom form. DHIS users in
South Africa use this a lot for capturing monthly data on a daily basis,
i.e. we use a custom form where Day01 to Day31 are columns with data set
elements as rows - so you obviously need the tab cursor to move down when
you do the capturing of values for dayXX. That snippet looks like the
following (part of this will need to be adjusted depending on the columns
you have in the custom form).
Best regards
Calle
Custom HTML extract:
/*Code to change the tabindex of input cells from horizontal to
vertical: TAB Solution works
The code moves the input to the next cell using the tab key*/
// For each row
$('#keytable tr').each(function() {
// For each cell in that row (using i as a counter)
$(this).find('td').each(function(i) {
// Set the tabindex of each input in that cell to the counter
$(this).find('input').attr('tabindex', i + 1);
//Set the attribute name of each input in that cell to daily
$(this).find('input').attr('name','daily');
});
// Counter gets reset for every row
});
//Custom Code which changes the keypress operation to the next cell below:
Solution Working
$('input').on("keypress", function(e) {
if (e.keyCode == 13) {
var $this = $(this),
index = $this.closest('td').index();
$this.closest('tr').next().find('td').eq(index).find('input').focus();
e.preventDefault();
}
}); //end keypress function
//The Next Two Scroll function calls are responding for inserting two
horizontal scrollbars on the daily data entry form
$(".wmd-view-topscroll").scroll(function(){
$(".wmd-view").scrollLeft($(".wmd-view-topscroll").scrollLeft());
}); //end top scrollbar function
$(".wmd-view").scroll(function(){
$(".wmd-view-topscroll").scrollLeft($(".wmd-view").scrollLeft());
}); //end bottom scrollbar function
On 11 December 2017 at 12:59, Stanley Kalyati <skaly...@gmail.com> wrote:
> Hi All,
>
> How can someone customize the cursor to move either vertical or horizontal
> in a custom form?
>
> Thanks
>
> Stanley
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
>
--
***
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19119
Email: calle.hedb...@gmail.com
Skype: calle_hedberg
***
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Auto Unique Identifiers-Alphanumetical
Stanley, See JIRA issue for this - Stian is currently working on it. Regards Calle On 2 December 2017 at 11:41, Stanley Kalyati <skaly...@gmail.com> wrote: > Hi, > > Can anyone take me through how my tracker capture can automatically > generate Unique IDs with a specific algorithm such as first two letters of > the first name, first two letters of the surname, last two digits of the > year of birth and area code. > > Has anyone done this successfully? Or has anyone used another software to > generate this kind of UIC. > > Thanks > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] USE OF BARCODE IN TRACKER CAPTURE
Stanley, I wrote a JIRA issues for this back in 2016 - DHIS2-438. No progress on it. Regards Calle On 2 December 2017 at 09:03, Stanley Kalyati <skaly...@gmail.com> wrote: > Anyone with this experience? > > Kindly provide insight how this is deployed. > > Thanks > > Stanley > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Teenage Pregnancy DataSet for Schools
Gerald, OK, so there is no intention or requirement to track and analyze such data per school, then. If the idea is simply to somehow store a list of schools from where the data originates, and assuming that you are collecting it per chiefdom and per month, I would rather change the data element you have already created into a long text field. Capturers can then add school names in there, separated by a semi-colon or similar delimiter. Just make sure everybody understands that if the data per chiefdom per month has not already been aggregated in the input form, then such aggregation must be done manually during data entry. Note also that you do have one other possibility, and that is to treat each school report received as an event - or in other words you set this up as an Event Program - without registration, presumably - where the school itself it the entity. Regards Calle On 15 November 2017 at 11:45, gerald thomas <gerald17...@gmail.com> wrote: > Dear Calle, > Thanks for your response. That was what i told the partners but their > budget didn't permitted them and they didn't have names for all the > schools. How does comments works on DataSet? Because we can use the > option of comments to tag names to a particular Data Entry because the > name of the schools are for reference purposes. > > On 11/15/17, Calle Hedberg <calle.hedb...@gmail.com> wrote: > > Gerald, > > > > I would not recommend using the standard HMIS for school health - it > would > > give you minimal control and reporting capabilities per school. > > > > In South Africa, school health is captured into a separate DHIS2 database > > where the hierarchy ends with schools and not health facilities (although > > each school might store a reference health facility, of course). All the > > ~30,000 schools in the country is part of that orghierarchy, and we > > generally try to get annual data for the number of learners (pupils) per > > grade, which you can then use as denominator data to get coverage > > indicators. > > > > You COULD of course add the schools into the HMIS orghierarchy, but IMHO > > that is rather messy - better to use a separate database > > > > Regards > > Calle > > > > On 15 November 2017 at 08:30, gerald thomas <gerald17...@gmail.com> > wrote: > > > >> Dear All, > >> I created a Teenage Pregnancy dataSet whose data should be captured > >> from schools. Since we have multiple schools per Chiefdom; i created a > >> data element 'school' in the form of a text string. During data entry, > >> when a school had been entered for a particular chiefdom, it don't > >> accept another school again. > >> > >> Please can someone help. > >> > >> -- > >> Regards, > >> > >> Gerald > >> > >> _______ > >> Mailing list: https://launchpad.net/~dhis2-devs > >> Post to : dhis2-d...@lists.launchpad.net > >> Unsubscribe : https://launchpad.net/~dhis2-devs > >> More help : https://help.launchpad.net/ListHelp > >> > > > > > > > > -- > > > > *** > > > > Calle Hedberg > > > > 46D Alma Road, 7700 Rosebank, SOUTH AFRICA > > > > Tel/fax (home): +27-21-685-6472 > > > > Cell: +27-82-853-5352 > > > > Iridium SatPhone: +8816-315-19119 > > > > Email: calle.hedb...@gmail.com > > > > Skype: calle_hedberg > > > > *** > > > > > -- > Regards, > > Gerald > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Teenage Pregnancy DataSet for Schools
Gerald, I would not recommend using the standard HMIS for school health - it would give you minimal control and reporting capabilities per school. In South Africa, school health is captured into a separate DHIS2 database where the hierarchy ends with schools and not health facilities (although each school might store a reference health facility, of course). All the ~30,000 schools in the country is part of that orghierarchy, and we generally try to get annual data for the number of learners (pupils) per grade, which you can then use as denominator data to get coverage indicators. You COULD of course add the schools into the HMIS orghierarchy, but IMHO that is rather messy - better to use a separate database Regards Calle On 15 November 2017 at 08:30, gerald thomas <gerald17...@gmail.com> wrote: > Dear All, > I created a Teenage Pregnancy dataSet whose data should be captured > from schools. Since we have multiple schools per Chiefdom; i created a > data element 'school' in the form of a text string. During data entry, > when a school had been entered for a particular chiefdom, it don't > accept another school again. > > Please can someone help. > > -- > Regards, > > Gerald > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Import of a new event (not from another instance)
Terence, It definitely works to generate event UIDs using one of the methods above - just be aware that the import is very slow for larger record sets. I just imported around 2.4 mill events from 2001-2012 (with around 12 values each), and ended up having to import year by year - it still took 3 full days to import (i.e. around 40 hours). So the smart thing would be to (a) ensure you have a lot of ram allocated to the instance (~16GB is probably optimal), but also to limit the import file to not more than 2 mill rows. Regards Calle On 12 October 2017 at 10:47, Terence Scott <terence.sc...@rabiesalliance.org > wrote: > Hi Morten > > Thank you for the help! I will try these and see whether I can get it to > work! > > Kind regards, > Terence > > Terence Scott > > Global Alliance for Rabies Control (GARC) > Pan-African Rabies Control Network (PARACON) Steering Committee > terence.sc...@rabiesalliance.org > https://paracon.rabiesalliance.org > Skype: tpscott1987 > > > > > On Wed, Oct 11, 2017 at 1:32 PM, Morten Olav Hansen <mor...@dhis2.org> > wrote: > >> Hi there >> >> Sending in event IDs is not required, but its definitely recommended if >> you want do repeated imports (good to have a unique id connected to your >> event so that you don't end up with duplicates) >> >> We offer a few options to generate UIDs: >> >> 1) Using the web-api /api/system/id (you can add limit=X to adjust how >> many you need) >> 2) Install the dhis2 cli (npm -g install dhis2-cli) and then just do >> "dhis2 uid", or "dhis2 uid -h" to get more help >> 3) if you are nodejs directly you can also use the dhis2-uid lib for >> generating uids (npm --save install dhis2-uid) >> >> https://www.npmjs.com/package/dhis2-cli >> https://www.npmjs.com/package/dhis2-uid >> >> -- >> Morten Olav Hansen >> Senior Engineer, DHIS 2 >> University of Oslo >> http://www.dhis2.org >> >> On Wed, Oct 11, 2017 at 1:21 PM, Terence Scott < >> terence.sc...@rabiesalliance.org> wrote: >> >>> Dear All >>> >>> We have collected animal vaccination data (including GPS coordinates, >>> time, date, species etc.) in a custom developed program and have a CSV >>> output for this program. We are looking to try to import the data from the >>> custom-built programme into our DHIS2 instance via Event import. I have >>> gotten the import to work on Event export files that I have edited with new >>> animal data (e.g. by changing the species) and this works, as it simply >>> updates the old event (based on the event ID). However, we would like to >>> import these data as new events as opposed to simply replacing existing >>> events currently on the system. >>> >>> Therefore, I would like to please find out as to whether it is possible >>> to do one of the following: >>> >>> 1) Do an event import without an Event ID (i.e. register a new event on >>> the DHIS2 instance via Event import) >>> - I have looked through the documentation but am unable to find out >>> whetherthis is possible >>> - In the Developer Docs, it seems to mention that import using XML >>> does notrequire an Event ID, but I have not managed to >>> determine whether I am misinterpreting this or whether I >>> simply do not know how to do it. >>> >>> 2) Generate our own Event IDs in our custom-built programme that will be >>> recognised by the DHIS2 instance. >>> - Is there some way by which the Event IDs could be automatically >>> generated outside of the DHIS2 instance (in our programme) so that >>> new events can be imported into the instance? >>> >>> Please let me know if you need any further clarification. I would really >>> appreciate any help that you could provide! >>> >>> Kind regards, >>> Terence >>> >>> >>> Terence Scott >>> >>> Global Alliance for Rabies Control (GARC) >>> Pan-African Rabies Control Network (PARACON) Steering Committee >>> terence.sc...@rabiesalliance.org >>> https://paracon.rabiesalliance.org >>> Skype: tpscott1987 >>> >>> >>> >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpa
Re: [Dhis2-users] [Dhis2-devs] dhis version 2.28 is out
and deletion of all metadata objects. >> >> Docs >> <https://docs.dhis2.org/master/en/developer/html/webapi_amqp_rabbitmq_integration.html> >> >> >> Creating, updating and deleting SMS commands: CRUD operations for SMS >> commands are now available in the API. >> >> Docs >> <https://docs.dhis2.org/master/en/developer/html/webapi_sms_commands.html> >> >> >> Metadata export inclusionStrategy: The inclusion strategy parameter on >> metadata export allows for fine grained property inclusion control. >> >> Docs >> <https://docs.dhis2.org/master/en/developer/html/webapi_metadata_export.html> >> >> >> Default category exclusion support: Default category objects can now be >> excluded on metadata export. The system will now handle the absence of >> default category objects during metadata import. >> >> Docs >> <https://docs.dhis2.org/master/en/developer/html/webapi_metadata_export.html> >> >> >> >> RELEASE INFO >> >> --- >> >> Release Information >> >> Link >> >> Download release and sample database >> >> https://www.dhis2.org/downloads >> >> Documentation and Javadocs >> >> https://www.dhis2.org/documentation >> >> Upgrade notes >> >> https://www.dhis2.org/228-upgrade >> >> Details about each feature on JIRA >> >> https://jira.dhis2.org/issues/?filter=10002 >> >> Overview of fixed issues >> >> https://jira.dhis2.org/issues/?filter=10558 >> >> Source code on Github >> >> https://github.com/dhis2 >> >> Demo instance >> >> https://play.dhis2.org/demo >> >> Instructions for signing up for DHIS 2 mailing lists >> >> https://www.dhis2.org/contact >> >> >> >> >> Enjoy the new release. >> >> Best regards, >> >> The DHIS2 development team >> >> >> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DISABLING A STAGE IN SOME ORG UNITS
Stanley,
You can use Program Rules to hide stages, as long as you have attributes
and/or data elements already captured that can be utilised to trigger rules.
OR that you use some kind of pattern to e.g. assign OrgUnitCodes to
OrgUnits. If all OUs providing health services have OUcode numbers between
101 and 499, whereas all those without services range from 500
to , you can use the V{orgunit_code} function to retrieve the
OUcode and the determine if stage x should be hidden.
Just note that the current Tracker Capture apk for Android do not support
HIDEPROGRAMSTAGE
Regards
Calle
On 18 July 2017 at 15:20, Stanley Kalyati <skaly...@gmail.com> wrote:
> Thats exactly what i thought Abyot.But in my case,i want one enrollment
> but to disable some stages in certain OUs and allowing them to enable when
> at certain OUs.
>
> On Tue, Jul 18, 2017 at 3:14 PM, Abyot Gizaw <aby...@gmail.com> wrote:
>
>> Hi,
>>
>> There needs to be enrolment for each program.
>>
>> ---
>>
>> Thank you,
>> Abyot.
>> (sent from mobile)
>>
>>
>> On Jul 18, 2017 14:54, "Knut Staring" <knu...@gmail.com> wrote:
>>
>> Probably not in 2.27maybe others have better ideas...
>>
>> On Tue, Jul 18, 2017 at 11:44 AM, Stanley Kalyati <skaly...@gmail.com>
>> wrote:
>>
>>> So we have one enrollment form for someone to be part of the program.So
>>> if i create two programs with each with 3 stages,will someone be able to
>>> search the clients across the two programs?
>>>
>>> On Tue, Jul 18, 2017 at 11:40 AM, Knut Staring <knu...@gmail.com> wrote:
>>>
>>>> Right...but why does that preclude you from having two programs, each
>>>> with 3 stages?
>>>>
>>>> On Tue, Jul 18, 2017 at 11:38 AM, Stanley Kalyati <skaly...@gmail.com>
>>>> wrote:
>>>>
>>>>> Thanks Knut but we are using Unique identifiers and we need to track
>>>>> these individuals at all stages.Ofcourse right now it is going on well but
>>>>> what we have noticed is that due to so many files,data clerks have ended
>>>>> up
>>>>> capturing clinical data under an OU that does not offer such services.As
>>>>> we
>>>>> wanted to limit these errors by enabling the system to lock forms on
>>>>> certain OUs and open them on certain OUs.
>>>>>
>>>>> Thanks
>>>>>
>>>>> On Tue, Jul 18, 2017 at 11:34 AM, Knut Staring <knu...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Perhaps there are other ways, but obviously you could create two
>>>>>> programs and assign them to different OUs.
>>>>>>
>>>>>> Knut
>>>>>>
>>>>>> On Tue, Jul 18, 2017 at 11:30 AM, Stanley Kalyati <skaly...@gmail.com
>>>>>> > wrote:
>>>>>>
>>>>>>> Hi All,
>>>>>>>
>>>>>>> I have a program with 4 stages but two of these stages should only
>>>>>>> be enabled at selected OUs.Example stages for Clinic data should only be
>>>>>>> enabled at a health facility OU and not other OU.This will avoid data
>>>>>>> clerks to capture clinical data at an OU which does not offer clinical
>>>>>>> services.
>>>>>>>
>>>>>>> Can anyone assist.
>>>>>>>
>>>>>>> Thank you.
>>>>>>>
>>>>>>> Stanley
>>>>>>>
>>>>>>> ___
>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>> Post to : dhis2-d...@lists.launchpad.net
>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>> More help : https://help.launchpad.net/ListHelp
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Knut Staring
>>>>>> Dept. of Informatics, University of Oslo
>>>>>> Norway: +4791880522 <+47%20918%2080%20522>
>>>>>> Skype: knutstar
>>>>>> http://dhis2.org
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Knut Staring
>>>> Dept. of Informatics, University of Oslo
>>>> Norway: +4791880522 <+47%20918%2080%20522>
>>>> Skype: knutstar
>>>> http://dhis2.org
>>>>
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522 <918%2080%20522>
>> Skype: knutstar
>> http://dhis2.org
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help : https://help.launchpad.net/ListHelp
>>
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
>
--
***
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19119
Email: calle.hedb...@gmail.com
Skype: calle_hedberg
***
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Older war files
Hi and attached is a composite text file with all the upgrade stuff. Regards Calle On 10 July 2017 at 09:30, Calle Hedberg <calle.hedb...@gmail.com> wrote: > Hannan, > > If you don't get 2.16 and 2.17, then I can give you a copy of 2.17 - I > keep the latest war files for all versions since 2.17, but I've never dealt > with any 2.16 or earlier instance so I don't have that. > > As far as I know, there should be a repository of old war files somewhere > > Regards > Calle > > On 10 July 2017 at 08:58, Knut Staring <knu...@gmail.com> wrote: > >> Hi Hannan, >> >> Maybe first try go directly for 2.18 (after backing up the db, of >> course). >> >> There should not be a lot required: >> https://www.dhis2.org/217-upgrade >> https://www.dhis2.org/218-upgrade >> >> >> On Mon, Jul 10, 2017 at 8:34 AM, Hannan Khan <hann...@gmail.com> wrote: >> >>> Thanks Knut. >>> >>> Yes I find version 18 onward, but can get 16, 17. Need upgraded war >>> file. Can you please explore. >>> >>> Regards >>> >>> Hannan >>> >>> On Mon, Jul 10, 2017 at 12:22 PM, Knut Staring <knu...@gmail.com> wrote: >>> >>>> Not sure about 16 and 17 - might have to build them (I will take a >>>> look). >>>> >>>> From 2.18, this works; >>>> >>>> https://www.dhis2.org/download/releases/2.18/dhis.war >>>> >>>> On Jul 10, 2017 08:02, "Hannan Khan" <hann...@gmail.com> wrote: >>>> >>>>> Dear all >>>>> >>>>> I need earlier war files from 16 on ward; from where I can download? >>>>> >>>>> Regards >>>>> >>>>> Muhammad Abdul Hannan Khan >>>>> Team Leader >>>>> Support to the National HMIS >>>>> MIS, Director General of Health Service >>>>> Ministry of Health and Family Welfare >>>>> >>>>> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118 >>>>> F +88 02 58813 875 >>>>> M+88 01819 239 241 >>>>> M+88 01534 312 066 >>>>> E hann...@gmail.com >>>>> S hannan.khan.dhaka >>>>> B hannan-tech.blogspot.com >>>>> L https://bd.linkedin.com/in/hannankhan >>>>> >>>>> >>>>> >>>>> >>>>> ___ >>>>> Mailing list: https://launchpad.net/~dhis2-devs >>>>> Post to : dhis2-d...@lists.launchpad.net >>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>> >>> >>> -- >>> Muhammad Abdul Hannan Khan >>> Team Leader >>> Support to the National HMIS >>> MIS, Director General of Health Service >>> Ministry of Health and Family Welfare >>> >>> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118 >>> F +88 02 58813 875 >>> M+88 01819 239 241 >>> M+88 01534 312 066 >>> E hann...@gmail.com >>> S hannan.khan.dhaka >>> B hannan-tech.blogspot.com >>> L https://bd.linkedin.com/in/hannankhan >>> >>> >>> >>> >> >> >> -- >> Knut Staring >> Dept. of Informatics, University of Oslo >> Norway: +4791880522 <+47%20918%2080%20522> >> Skype: knutstar >> http://dhis2.org >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > > *** > > Calle Hedberg > > 46D Alma Road, 7700 Rosebank, SOUTH AFRICA > > Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472> > > Cell: +27-82-853-5352 <+27%2082%20853%205352> > > Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119> > > Email: calle.hedb...@gmail.com > > Skype: calle_hedberg > > *** > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg
Re: [Dhis2-users] [Dhis2-devs] Older war files
Hannan, If you don't get 2.16 and 2.17, then I can give you a copy of 2.17 - I keep the latest war files for all versions since 2.17, but I've never dealt with any 2.16 or earlier instance so I don't have that. As far as I know, there should be a repository of old war files somewhere Regards Calle On 10 July 2017 at 08:58, Knut Staring <knu...@gmail.com> wrote: > Hi Hannan, > > Maybe first try go directly for 2.18 (after backing up the db, of course). > > There should not be a lot required: > https://www.dhis2.org/217-upgrade > https://www.dhis2.org/218-upgrade > > > On Mon, Jul 10, 2017 at 8:34 AM, Hannan Khan <hann...@gmail.com> wrote: > >> Thanks Knut. >> >> Yes I find version 18 onward, but can get 16, 17. Need upgraded war file. >> Can you please explore. >> >> Regards >> >> Hannan >> >> On Mon, Jul 10, 2017 at 12:22 PM, Knut Staring <knu...@gmail.com> wrote: >> >>> Not sure about 16 and 17 - might have to build them (I will take a >>> look). >>> >>> From 2.18, this works; >>> >>> https://www.dhis2.org/download/releases/2.18/dhis.war >>> >>> On Jul 10, 2017 08:02, "Hannan Khan" <hann...@gmail.com> wrote: >>> >>>> Dear all >>>> >>>> I need earlier war files from 16 on ward; from where I can download? >>>> >>>> Regards >>>> >>>> Muhammad Abdul Hannan Khan >>>> Team Leader >>>> Support to the National HMIS >>>> MIS, Director General of Health Service >>>> Ministry of Health and Family Welfare >>>> >>>> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118 >>>> F +88 02 58813 875 >>>> M+88 01819 239 241 >>>> M+88 01534 312 066 >>>> E hann...@gmail.com >>>> S hannan.khan.dhaka >>>> B hannan-tech.blogspot.com >>>> L https://bd.linkedin.com/in/hannankhan >>>> >>>> >>>> >>>> >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : dhis2-d...@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >> >> >> -- >> Muhammad Abdul Hannan Khan >> Team Leader >> Support to the National HMIS >> MIS, Director General of Health Service >> Ministry of Health and Family Welfare >> >> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118 >> F +88 02 58813 875 >> M+88 01819 239 241 >> M+88 01534 312 066 >> E hann...@gmail.com >> S hannan.khan.dhaka >> B hannan-tech.blogspot.com >> L https://bd.linkedin.com/in/hannankhan >> >> >> >> > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > Norway: +4791880522 <+47%20918%2080%20522> > Skype: knutstar > http://dhis2.org > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Any open source GIS/map database tools other than DHIS2
/~dhis2-devs >> >>> Post to : dhis2-d...@lists.launchpad.net >> >>> Unsubscribe : https://launchpad.net/~dhis2-devs >> >>> More help : https://help.launchpad.net/ListHelp >> >>> >> >>> >> >>> ___ >> >>> Mailing list: https://launchpad.net/~dhis2-users >> >>> Post to : dhis2-users@lists.launchpad.net >> >>> Unsubscribe : https://launchpad.net/~dhis2-users >> >>> More help : https://help.launchpad.net/ListHelp >> >>> >> >> >> >> >> >> >> >> -- >> >> Jan Henrik Øverland >> >> Software developer, DHIS 2 >> >> University of Oslo >> >> http://www.dhis2.org >> >> >> >> ___ >> >> Mailing list: https://launchpad.net/~dhis2-users >> >> Post to : dhis2-users@lists.launchpad.net >> >> Unsubscribe : https://launchpad.net/~dhis2-users >> >> More help : https://help.launchpad.net/ListHelp >> >> >> > >> > >> > >> > >> > >> > ___ >> > Mailing list: https://launchpad.net/~dhis2-devs >> > Post to : dhis2-d...@lists.launchpad.net >> > Unsubscribe : https://launchpad.net/~dhis2-devs >> > More help : https://help.launchpad.net/ListHelp >> > >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] import validation rules in dhis2 2.24
Carlos Please post a sample of that CSV file - like the first 2-3 rows. Makes it a lot easier to diagnose the problem. Regards Calle On 14 June 2017 at 10:16, Carlos Nyembwe <nyem...@gmail.com> wrote: > Hi Knut, > > Visibly they are some violation rules but when we execute, nothing, > > About upgrade, I'm not the main person to do that > > Yes the same csv file work in 2.26 > > I must use 2.24 until now > > Regards > > On Wed, Jun 14, 2017 at 9:12 AM, Knut Staring <knu...@gmail.com> wrote: > >> Hi Carlos, >> >> Could you explain what your issue is - you say "nothing broken", meaning >> that you think there should be some violations, but everything passes >> without problem? >> >> Could you upgrade to 2.26? >> >> Regards, >> Knut >> >> >> >> On Wed, Jun 14, 2017 at 6:47 AM, Carlos Nyembwe <nyem...@gmail.com> >> wrote: >> >>> hello everyone, >>> >>> I'm working on validation rules. >>> I tried to import a CSv file in DHIS2 2.24, it didn't run but in DHIS2 >>> 2.26 It worked, for by passing this dificulty, I exported from 2.26 XML >>> file, and imported in 2.24, it was done fine >>> but for running these rules, nothing broken >>> >>> What can I do??? >>> >>> Regards >>> >>> -- >>> *Carlos Nyembwe* >>> *I'm just a Computer Scientist* >>> >>> *Skype: carloscnk1* >>> *Cell: (+243)813166381 <+243%20813%20166%20381>* >>> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | >>> **Linkedin >>> <http://www.linkedin.com/in/carloscnk> | Facebook >>> <https://www.facebook.com/carloscnksys> | Twitter >>> <https://twitter.com/Carlos_CNK> |* >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Knut Staring >> Dept. of Informatics, University of Oslo >> Norway: +4791880522 <+47%20918%2080%20522> >> Skype: knutstar >> http://dhis2.org >> > > > > -- > *Carlos Nyembwe* > *I'm just a Computer Scientist* > > *Skype: carloscnk1* > *Cell: (+243)813166381 <+243%20813%20166%20381>* > *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | > **Linkedin > <http://www.linkedin.com/in/carloscnk> | Facebook > <https://www.facebook.com/carloscnksys> | Twitter > <https://twitter.com/Carlos_CNK> |* > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] dhis version 2.27 is released
nt out to users 14 days before their > password expires and must be changed. > > - The minimum number of characters in passwords is configurable and can be > between 8 and 14. > > - Password must contain a mix of at least three characters from the > following categories: uppercase, lowercase, numeric and special > (non-alphanumeric). > > - When changing passwords, users cannot use any of the 24 previously used > passwords. > > > > Screenshot > <https://s3-eu-west-1.amazonaws.com/content.dhis2.org/releases/screenshots/27/security-access-settings.png> > | Docs Users app > <https://docs.dhis2.org/master/en/user/html/mgt_user.html#user_manage_password> > | Docs System Settings app > <https://docs.dhis2.org/master/en/user/html/system_access_settings.html> > > > > > > Cloud storage for resources: Resource (files and links, found in the > Reports app > Resources) can now be configured and be backed by a cloud > storage provider such as AWS S3. This allows for infinite storage of files. > This requires that you’ve configures a cloud store in dhis.conf. > Note: if you’ve configured cloud storage in dhis.conf, all files you > upload or the files system generates will use cloud storage, not only > resources. > > > > Demo > <https://play.dhis2.org/demo/dhis-web-reporting/displayViewDocumentForm.action> > | Screenshot > <https://s3-eu-west-1.amazonaws.com/content.dhis2.org/releases/screenshots/27/resource-cloud-store.png> > | Docs > <https://docs.dhis2.org/master/en/user/html/using_reporting_resources.html> > | Cloud file store setup docs > <https://docs.dhis2.org/master/en/implementer/html/install_file_store_configuration.html> > > > > > > Improved metadata export: Metadata export with dependencies now supports > data element groups and dashboards. > > > > Demo > <https://play.dhis2.org/demo/dhis-web-importexport/metadataDependencyExport.action> > | Docs > <https://docs.dhis2.org/master/en/user/html/export.html#metadata_export_dependencies> > > > > > > Data store manager: A new app is available which lets you manage the > content of the web API data stores. This is helpful when managing apps and > external scripts. > > > > Demo <https://play.dhis2.org/demo/dhis-web-datastore/#/> | Screenshot > <https://s3-eu-west-1.amazonaws.com/content.dhis2.org/releases/screenshots/27/datastore.png> > | Docs > <https://docs.dhis2.org/master/en/user/html/datastore_manager_app.html> > > > > > > SERVER ADMIN FEATURES > > --- > > > > Memcached support: You can now use memcached as an application cache > provider. This allows for greater scalability as memcached can be hosted on > a separate server off-heap. > > > > Docs > <https://docs.dhis2.org/master/en/implementer/html/install_application_cache_providers.html> > > > > > > WEB API FEATURES > > --- > > > > Tracker soft delete: Soft deletion has been introduced for the tracked > entity instance and enrollment entities. This gives clients with local > databases the opportunity to react on deleted entities. > > > > Docs > <https://docs.dhis2.org/master/en/developer/html/webapi_events.html#webapi_querying_reading_events> > > > > > > Deleted metadata objects log: Deletion of metadata is now logged and can > be queried from a new endpoint /api/deletedObjects. This allows clients > with local databases to react on deleted metadata objects. > > > > Docs > <https://docs.dhis2.org/master/en/developer/html/webapi_deleted_objects.html> > > > > > > Email sending: A new endpoint for sending email is introduced at > /api/email. > > > > Docs <https://docs.dhis2.org/master/en/developer/html/webapi_email.html> > > > > > > Min-max data element values: A new endpoint for setting and retrieving > min-max data element values is introduced at /api/minMaxDataElements. > > > > Docs > <https://docs.dhis2.org/master/en/developer/html/webapi_min_max_data_elements.html> > > > > > > Lock exceptions: A new endpoint which lets you create, retrieve and > remove data set lock exceptions is available at /api/lockExceptions. > > > > Docs > <https://docs.dhis2.org/master/en/developer/html/webapi_lock_exceptions.html> > > > > > > Event export identifier schemes: The event export resource for now > supported identifier schemes, i.e. allows for use of code as well as > identifier. > > > > Docs > <https://docs.dhis2.org/master/en/developer/html/webapi_events.html#webapi_querying_reading_events> > > > > > > RELEASE INFO > > --- > > > > Release Information > > Link > > Download release and sample database > > https://www.dhis2.org/downloads > > Documentation and Javadocs > > https://www.dhis2.org/documentation > > Upgrade notes > > https://www.dhis2.org/227-upgrade > > Details about each feature on JIRA > > https://jira.dhis2.org/issues/?filter=10257 > > Overview of fixed issues > > https://jira.dhis2.org/issues/?filter=10418 > > Source code on Github > > https://github.com/dhis2 > > Demo instance > > https://play.dhis2.org/demo > > Instructions for signing up for DHIS 2 mailing lists > > https://www.dhis2.org/contact > > > > > > > > > > Enjoy the new release. > > > > Best regards, > > > > The DHIS2 development team > > > > > > > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > l...@dhis2.org > http://www.dhis2.org <https://www.dhis2.org/> > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Fwd: Storing value type 'Age' in numeric form
Hi, I am not using the new age type at all in any application where you want to do analytics or reporting on the age (in years, months, days etc) AS IT WAS AT THE TIME OF THE ENROLLMENT AND/OR STAGE VISIT. The "Age" data type as it is now defined/designed is probably only relevant for use in applications where you have stored the date of birth and you simply want to know the patient's age at any point in time - i.e. the primary usage is patient-centric and not analytics centric. In the case of Disease Surveillance, for instance, we are capturing CASES and not PATIENTS per se (the same patient presenting with malaria in January and Measles in May will be two separate cases). So for any post-analysis of such data, you want to know e.g. the break-down of cases per age group AS THOSE AGES WERE ON THE DAY OF DIAGNOSIS/PRESENTATION. So my recommendation is to instead define three additional attributes/data elements: Age (years), Age (months), and Age (days) - then you use three ASSIGN program rules to calculate and assign the relevant values. Those values are now permanent and locked as long as the DoB or enrollment/report date don't change. Best regards Calle On 21 May 2017 at 11:23, Dipali Sahu <dipali.s...@gmail.com> wrote: > Hi > > I am facing the same issue. I could enter age of a patient in Tracker form > ( in a attribute type of Age) , but not able to create any indicators based > on it , for example 'No. of events where Age is less than 1 year'. > > Does it work yet? > > Thank you in advance > Deepali > > > > -- Forwarded message -- > From: Archana Chillala <archa...@thoughtworks.com> > Date: Thu, Mar 23, 2017 at 2:03 PM > Subject: Re: [Dhis2-users] Storing value type 'Age' in numeric form > To: dhis2-devs <dhis2-d...@lists.launchpad.net> > Cc: dhis2-users <dhis2-users@lists.launchpad.net>, Jane GREIG < > jane.gr...@london.msf.org>, Theo Krommydakis <theo.krommyda...@london.msf. > org>, twoca <tw...@thoughtworks.com>, carolyn.ta...@london.msf.org > > > adding dhis-users list > > Archana Chillala > Application Developer > Email archa...@thoughtworks.com > Telephone +91 9100960533 <+91+9100960533> > > [image: www.thoughtworks.com] <http://www.thoughtworks.com> > > On Thu, Mar 23, 2017 at 1:57 PM, Archana Chillala < > archa...@thoughtworks.com> wrote: > >> Hi >> >> We are using DHIS version 2.26. We are exploring the new value type " >> *Age*" that has been introduced with this release. On the UI, when we >> enter a date, it calculates the age in years, months and days perfectly. >> But we observe that the calculated age in years is not stored in the DB. >> The value of an Age type data element is stored only as a date (-MM-DD) >> in the database. We would like to use the age in years in analytics on the >> visualisation apps. We have tried using program indicators for the same, >> but that did not work as expected. >> >> Could you please suggest how we could leverage the use of age in years, >> given the existing functionality. >> >> >> >> *Cheers*, >> >> Archana Chillala >> Application Developer >> Email archa...@thoughtworks.com >> Telephone +91 9100960533 <+91+9100960533> >> >> [image: www.thoughtworks.com] <http://www.thoughtworks.com> >> > > > ___ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Create Scorecards using the Pivot Table app
Stanley, Have you tried the scorecard 2 app from HISP/Tanzania? It might work better... Regards calle On 5 May 2017 at 11:02, Stanley Kalyati <skaly...@gmail.com> wrote: > I followed through the instructions on the link below but i did not get > the results as expected. > > I am using dhis2 2.26. > > Anyone who has been successful please help > > https://docs.dhis2.org/master/en/user/html/create- > scorecards-pivot-table.html#d0e33931 > > Regards > > Stanley > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DELETING INACTIVE ENTITIES IN TRACKER CAPTURE
Stanley, Neither DELETE enrollment (DELETE button) nor "REMOVE person" (red button) - both in the dashboard - work at the moment. Stian Sandvold is working hard to try to track the bug down - seems to be an elusive one Croxx your fingers :-) Best regards Calle On 5 April 2017 at 09:27, Stanley Kalyati <skaly...@gmail.com> wrote: > How can one delete all enrolled entities without any events in Tracker > Capture? > > In my case those entities without any event are likely to be duplicates > and i want to delete them. > > Thanks > > Stanley > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] TRACKER CAPTURE FAILING TO CLEAR FORM AFTER SAVE AND ADD NEW
Stanley, I presume you are referring to the fact that SAVE AND ADD NEW would clear the enrollment part but not the stage part of the data entry form? If so, then the issue should be fixed now - Abyot sorted it out yesterday. I've only tested it in 2.26 where it works fine, but Abyot says he's back-ported the fix to 2.25 and 2.24 So download the latest war file for 2.25 and try again, please Regards Calle On 5 April 2017 at 09:47, Stanley Kalyati <skaly...@gmail.com> wrote: > I had posted this issue some days back. > > I am still experience the issue of data not clearing after pressing the > "SAVE AND ADD NEW'' batton. > > When i press twice hoping the elements will clear for another entity to be > added,i am getting the error below:\ > > > > On Fri, Mar 31, 2017 at 4:22 PM, Stanley Kalyati <skaly...@gmail.com> > wrote: > >> Dear Seth >> >> I have tried clearing the cache but nothing,the same story. >> >> Am confused though. >> >> Thanks >> >> Stanley >> >> On Fri, Mar 31, 2017 at 12:40 PM, Seth Okeyo <sok...@dndi.org> wrote: >> >>> Hello Stanley, >>> >>> I don't think it is a bug,we are currently running that same version. >>> which browser are you using? I experienced the same when I was using >>> Mozilla, use google chrome and clear your browsing data. >>> >>> Regards >>> >>> >>> *Seth Okeyo*| Data Management Officer >>> >>> Drugs for Neglected Diseases initiative – Africa Regional Office >>> >>> Tetezi Towers, 3rd Floor, George Padmore Road, Kilimani| P.O. Box 21936 >>> - 00505| Nairobi | Kenya >>> >>> T: +254 020 3995000 <+254%2020%203995000> | M: +254 727 389 149| >>> sok...@dndi.org | skype: dndi_seth.okeyo >>> >>> *Best Science for the Most Neglected* | www.dndi.org >>> >>> -- >>> *From:* Dhis2-users <dhis2-users-bounces+sokeyo=dn >>> di@lists.launchpad.net> on behalf of Stanley Kalyati < >>> skaly...@gmail.com> >>> *Sent:* Friday, March 31, 2017 12:41:33 PM >>> *To:* DHIS 2 Developers list; DHIS Users >>> *Subject:* [Dhis2-users] TRACKER CAPTURE FAILING TO CLEAR FORM AFTER >>> SAVE AND ADD NEW >>> >>> I have a program which has been working fine until today when i noticed >>> that whenever i add an entity to the program,the "SAVE AND ADD NEW' is not >>> clearing the form to allow for another entry. >>> >>> Is this a bug? >>> >>> Am using DHIS2 2.25 latest version >>> >>> Please help >>> >>> Regards >>> >>> Stanley >>> >> >> > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Problem loading pivot table results
Hi This is a common problem - the pivot table app cannot process/display larger sets of data, which is typically what you get when selecting the lowest OU level. Try dumping the result out into another format (CSV, Excel), and then process that into the report format you want. Regards Calle On 3 April 2017 at 13:05, Raminosoa Rabemanantsoa, Tantely < tramino...@mikolo.org> wrote: > Dear DHIS2 community, > > > We are using DHIS2 2.24. When we are running pivot table and are using > some indicators by selecting the lowest level of OrgUnit (Community Health > Workers), the application is running without any results output (an > illustration is attached). The application is only responding when we are > going up to a higher level in the OrgUnit tree. Are there some memories > parameters to tune or what should be done to troubleshoot this issue, as we > really need the results presented with the lowest OrgUnit. In the server > side, we are using 16 cores CPU and 64 Gb of RAM. > > > Thank you for your support, > > > Regards, > > > Tantely. > > *This message and its attachments are confidential and solely for the > intended recipients. If received in error, please delete them and notify > the sender via reply e-mail immediately.* > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] TABULAR TRACKER CAPTURE
t;>>>> >>>>>>>>> Please see the attached printScreen of what am getting here. >>>>>>>>> >>>>>>>>> I have tried to re-load but nothing and i am also logon as the >>>>>>>>> admin with all rights. >>>>>>>>> >>>>>>>>> Thanks >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> On Tue, Mar 14, 2017 at 9:01 AM, Prosper BT <ptb3...@gmail.com> >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> Hi Stanley, >>>>>>>>>> >>>>>>>>>> Try clicking on the page reload, if you are using an account not >>>>>>>>>> the admin, create a new account with the same roles and try again. >>>>>>>>>> >>>>>>>>>> Reloading has been working for me, this bug has been difficult to >>>>>>>>>> replicate on the demo. >>>>>>>>>> >>>>>>>>>> Regards >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Prosper Behumbiize, MPH >>>>>>>>>> DHIS2 Implementation| HISP Uganda >>>>>>>>>> +256 752 751 776 | +256 776 139 139 >>>>>>>>>> pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | >>>>>>>>>> Skype: >>>>>>>>>> prospertb >>>>>>>>>> >>>>>>>>>> On Tue, Mar 14, 2017 at 9:55 AM, Stanley Kalyati < >>>>>>>>>> skaly...@gmail.com> wrote: >>>>>>>>>> >>>>>>>>>>> I am currently using DHIS2 2.25 build da6a2df and build date >>>>>>>>>>> 2017-03-10 >>>>>>>>>>> 00:13. >>>>>>>>>>> >>>>>>>>>>> Has anyone used the Tabular Tracker Capture within this version? >>>>>>>>>>> >>>>>>>>>>> I have tried to work around this but it keeps laoding.It looks >>>>>>>>>>> like a good app for my line of work.Anyone please advise the best >>>>>>>>>>> way to >>>>>>>>>>> use this. >>>>>>>>>>> >>>>>>>>>>> My regards >>>>>>>>>>> >>>>>>>>>>> Stanley >>>>>>>>>>> >>>>>>>>>>> ___ >>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>>>>>>>> Post to : dhis2-users@lists.launchpad.net >>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>>> ___ >>>>>>> Mailing list: https://launchpad.net/~dhis2-devs >>>>>>> Post to : dhis2-d...@lists.launchpad.net >>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] Downloading war files from Jenkins (continuous integration server) is not reliable - use https://www.dhis2.org/downloads
FYI to all users: After some testing from my side and further investigation from Jason Pickering, we have concluded that users should preferably NOT use the continuous integration server (aka Jenkins) for downloading war files - in particular if you have a slow connection or if you are downloading several war files simultaneously. The https://www.dhis2.org/downloads <https://www.google.com/url?q=https%3A%2F%2Fwww.dhis2.org%2Fdownloads=D=1=AFQjCNGWmj0aV3vBfdRe_y_9dBZhkk7POQ> works fine, though - it servers war files as static files directly through nginx (and those files are also always the latest builds of whatever version(s) you need). Best regards Calle & Jason ******* Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] UNABLE TO INSTALL DHIS2 ON A LOCAL MACHINE
Hi Firstly, I would NOT use postgresql 9.3 - it's performance is abysmal compared with 9.5. Secondly, I presume you are using the latest java 8 64 bits? (if not, do so). Thirdly, I'm not really sure if tomcat 9.0 have problems (have not tested it). On the other hand, I KNOW tomcat 8.x works Regards calle On 22 February 2017 at 11:17, Stanley Kalyati <skaly...@gmail.com> wrote: > Dear Coalleagues, > > I am trying to install DHIS2 on a local machine, > > I have installed Tomcat 9.0 and installed Postgres 9.3 and followed the > instructions strictly. > > However when i type localhost:8080/dhis i am getting the message > below.Where am i getting it wrong? > > HTTP Status 404 - /dhis/ > > *type* Status report > > *message* */dhis/* > > *description* *The requested resource is not available.* > -- > Apache Tomcat/9.0.0.M1 > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Accessing the latest dhis2 builds
Jason, Thanks! I wasn't aware that all those unix/linux tools were available on Windows Will try them out, but please check the CI server too - something is definitely wrong there (looks like the time-out config is way too short, or something) Regards Calle On 20 February 2017 at 16:38, Jason Pickering <jason.p.picker...@gmail.com> wrote: > Hi Calle, > > Wget is freely available for Windows. > > http://unxutils.sourceforge.net/ > > > I will have a look at the CI server, as the reverse proxy configuration > could potentially be causing an issue. > > Regards, > Jason > > > On Mon, Feb 20, 2017 at 3:32 PM, Calle Hedberg <calle.hedb...@gmail.com> > wrote: > >> Knut, >> >> The wget one probably do work better, since I have no complaints related >> to this from our infrastructure team (we are running 150-200 DHIS2 >> instances, so they download updates regularly). But I'm using Windows on my >> laptop, so wget won't work. >> >> Regards >> Calle >> >> On 20 February 2017 at 16:19, Knut Staring <knu...@gmail.com> wrote: >> >>> Hi Calle, >>> >>> I also had this problem with the ci.dhis2.org link when I was in Burma. >>> But I found the other link that Lars and Morten pointed to to work much >>> better. >>> >>> Knut >>> >>> On Mon, Feb 20, 2017 at 2:26 PM, Calle Hedberg <calle.hedb...@gmail.com> >>> wrote: >>> >>>> Timothy, >>>> >>>> There is definitely something wrong with the configuration of the >>>> server that provides war files - it bails out immediately if there are >>>> delays in the download, or if you are on a slow connection. This is a >>>> relatively recent problem that appeared a few months ago. >>>> >>>> I discovered this the first time over Christmas, when I was trying to >>>> download a war file from my sister's place (in Norway) - she had a slow >>>> internet connection, and the download kept on bombing out, usually after >>>> downloading the first ~12mb. >>>> >>>> I discussed it with Lars in early January. His advice was the same as >>>> now, to use a download manager - but I have tried that, and it does not >>>> work. >>>> >>>> I've had similar reports from a number of people now, with the only >>>> workable solution being for me or somebody on a faster connection to >>>> download the war file and then make it available on another platform. >>>> >>>> My current home office connection is a 7mbits ADSL line, and download >>>> works OK here - AS LONG AS I ONLY DOWNLOAD ONE WAR FILE AT A TIME. >>>> >>>> On 20 February 2017 at 14:28, Morten Olav Hansen <mor...@dhis2.org> >>>> wrote: >>>> >>>>> You can also use wget if you are on a unix system (which your server >>>>> probably is) >>>>> >>>>> wget -c https://www.dhis2.org/download/releases/2.26/dhis.war >>>>> >>>>> (if it times out or disconnects... just run same command again and it >>>>> will continue) >>>>> >>>>> -- >>>>> Morten Olav Hansen >>>>> Senior Engineer, DHIS 2 >>>>> University of Oslo >>>>> http://www.dhis2.org >>>>> >>>>> On Mon, Feb 20, 2017 at 8:20 PM, Lars Helge Øverland <l...@dhis2.org> >>>>> wrote: >>>>> >>>>>> Hi Tim, >>>>>> >>>>>> you can get the latest WAR builds from here: >>>>>> >>>>>> https://www.dhis2.org/downloads >>>>>> >>>>>> You can also consider using a download manager with resume >>>>>> capabilities: >>>>>> >>>>>> https://chrome.google.com/webstore/detail/chrono-download-ma >>>>>> nager/mciiogijehkdemklbdcbfkefimifhecn >>>>>> >>>>>> >>>>>> regards, >>>>>> >>>>>> Lars >>>>>> >>>>>> On Mon, Feb 20, 2017 at 1:08 PM, Timothy Kiyemba <tkiye...@gmail.com> >>>>>> wrote: >>>>>> >>>>>>> Dear all, >>>>>>> >>>>>>> Can some one help me access the latest build for DHIS2 2.26. I have >>>>>>> tried accessing it from >>>>>>> >>>>>>> http
Re: [Dhis2-users] [Dhis2-devs] Accessing the latest dhis2 builds
Knut, The wget one probably do work better, since I have no complaints related to this from our infrastructure team (we are running 150-200 DHIS2 instances, so they download updates regularly). But I'm using Windows on my laptop, so wget won't work. Regards Calle On 20 February 2017 at 16:19, Knut Staring <knu...@gmail.com> wrote: > Hi Calle, > > I also had this problem with the ci.dhis2.org link when I was in Burma. > But I found the other link that Lars and Morten pointed to to work much > better. > > Knut > > On Mon, Feb 20, 2017 at 2:26 PM, Calle Hedberg <calle.hedb...@gmail.com> > wrote: > >> Timothy, >> >> There is definitely something wrong with the configuration of the server >> that provides war files - it bails out immediately if there are delays in >> the download, or if you are on a slow connection. This is a relatively >> recent problem that appeared a few months ago. >> >> I discovered this the first time over Christmas, when I was trying to >> download a war file from my sister's place (in Norway) - she had a slow >> internet connection, and the download kept on bombing out, usually after >> downloading the first ~12mb. >> >> I discussed it with Lars in early January. His advice was the same as >> now, to use a download manager - but I have tried that, and it does not >> work. >> >> I've had similar reports from a number of people now, with the only >> workable solution being for me or somebody on a faster connection to >> download the war file and then make it available on another platform. >> >> My current home office connection is a 7mbits ADSL line, and download >> works OK here - AS LONG AS I ONLY DOWNLOAD ONE WAR FILE AT A TIME. >> >> On 20 February 2017 at 14:28, Morten Olav Hansen <mor...@dhis2.org> >> wrote: >> >>> You can also use wget if you are on a unix system (which your server >>> probably is) >>> >>> wget -c https://www.dhis2.org/download/releases/2.26/dhis.war >>> >>> (if it times out or disconnects... just run same command again and it >>> will continue) >>> >>> -- >>> Morten Olav Hansen >>> Senior Engineer, DHIS 2 >>> University of Oslo >>> http://www.dhis2.org >>> >>> On Mon, Feb 20, 2017 at 8:20 PM, Lars Helge Øverland <l...@dhis2.org> >>> wrote: >>> >>>> Hi Tim, >>>> >>>> you can get the latest WAR builds from here: >>>> >>>> https://www.dhis2.org/downloads >>>> >>>> You can also consider using a download manager with resume capabilities: >>>> >>>> https://chrome.google.com/webstore/detail/chrono-download-ma >>>> nager/mciiogijehkdemklbdcbfkefimifhecn >>>> >>>> >>>> regards, >>>> >>>> Lars >>>> >>>> On Mon, Feb 20, 2017 at 1:08 PM, Timothy Kiyemba <tkiye...@gmail.com> >>>> wrote: >>>> >>>>> Dear all, >>>>> >>>>> Can some one help me access the latest build for DHIS2 2.26. I have >>>>> tried accessing it from >>>>> >>>>> https://ci.dhis2.org/job/dhis2-2.26/lastSuccessfulBuild/arti >>>>> fact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war >>>>> >>>>> But my downloads are not succeeding in completing. Could I be >>>>> accessing the wrong way? Is there a better way to get a successfull >>>>> download? >>>>> >>>>> Or can someone share with me a copy via googledocs? >>>>> >>>>> Timothy >>>>> >>>>> ___ >>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>> Post to : dhis2-users@lists.launchpad.net >>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>> >>>> >>>> -- >>>> Lars Helge Øverland >>>> Lead developer, DHIS 2 >>>> University of Oslo >>>> Skype: larshelgeoverland >>>> l...@dhis2.org >>>> http://www.dhis2.org <https://www.dhis2.org/> >>>> >>>> >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : dhis2-d...@lists.launchpad.net >>>> Unsubscribe : https://launchpad
Re: [Dhis2-users] [Dhis2-devs] Accessing the latest dhis2 builds
CONT: I have found that if I try to download multiple war files - e.g. to update all my war files from 2.21 to 2.27 - then the server bombs out the same way as when I'm on a slow connection. The war server is the ONLY server I know of that behaves in this manner. I'm downloading software from many sources regularly, and I've never seen this anywhere else - so I'm convinced there's a configuration error in the server setup. But Lars seems to be equally convinced that there isn't, so the setup won't change. Bottom line: Either use a faster connection, or else ask somebody else to download and then make it available for you on another platform. Regards Calle On 20 February 2017 at 15:26, Calle Hedberg <calle.hedb...@gmail.com> wrote: > Timothy, > > There is definitely something wrong with the configuration of the server > that provides war files - it bails out immediately if there are delays in > the download, or if you are on a slow connection. This is a relatively > recent problem that appeared a few months ago. > > I discovered this the first time over Christmas, when I was trying to > download a war file from my sister's place (in Norway) - she had a slow > internet connection, and the download kept on bombing out, usually after > downloading the first ~12mb. > > I discussed it with Lars in early January. His advice was the same as now, > to use a download manager - but I have tried that, and it does not work. > > I've had similar reports from a number of people now, with the only > workable solution being for me or somebody on a faster connection to > download the war file and then make it available on another platform. > > My current home office connection is a 7mbits ADSL line, and download > works OK here - AS LONG AS I ONLY DOWNLOAD ONE WAR FILE AT A TIME. > > On 20 February 2017 at 14:28, Morten Olav Hansen <mor...@dhis2.org> wrote: > >> You can also use wget if you are on a unix system (which your server >> probably is) >> >> wget -c https://www.dhis2.org/download/releases/2.26/dhis.war >> >> (if it times out or disconnects... just run same command again and it >> will continue) >> >> -- >> Morten Olav Hansen >> Senior Engineer, DHIS 2 >> University of Oslo >> http://www.dhis2.org >> >> On Mon, Feb 20, 2017 at 8:20 PM, Lars Helge Øverland <l...@dhis2.org> >> wrote: >> >>> Hi Tim, >>> >>> you can get the latest WAR builds from here: >>> >>> https://www.dhis2.org/downloads >>> >>> You can also consider using a download manager with resume capabilities: >>> >>> https://chrome.google.com/webstore/detail/chrono-download-ma >>> nager/mciiogijehkdemklbdcbfkefimifhecn >>> >>> >>> regards, >>> >>> Lars >>> >>> On Mon, Feb 20, 2017 at 1:08 PM, Timothy Kiyemba <tkiye...@gmail.com> >>> wrote: >>> >>>> Dear all, >>>> >>>> Can some one help me access the latest build for DHIS2 2.26. I have >>>> tried accessing it from >>>> >>>> https://ci.dhis2.org/job/dhis2-2.26/lastSuccessfulBuild/arti >>>> fact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war >>>> >>>> But my downloads are not succeeding in completing. Could I be accessing >>>> the wrong way? Is there a better way to get a successfull download? >>>> >>>> Or can someone share with me a copy via googledocs? >>>> >>>> Timothy >>>> >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : dhis2-users@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> >>> -- >>> Lars Helge Øverland >>> Lead developer, DHIS 2 >>> University of Oslo >>> Skype: larshelgeoverland >>> l...@dhis2.org >>> http://www.dhis2.org <https://www.dhis2.org/> >>> >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs
Re: [Dhis2-users] [Dhis2-devs] Accessing the latest dhis2 builds
Timothy, There is definitely something wrong with the configuration of the server that provides war files - it bails out immediately if there are delays in the download, or if you are on a slow connection. This is a relatively recent problem that appeared a few months ago. I discovered this the first time over Christmas, when I was trying to download a war file from my sister's place (in Norway) - she had a slow internet connection, and the download kept on bombing out, usually after downloading the first ~12mb. I discussed it with Lars in early January. His advice was the same as now, to use a download manager - but I have tried that, and it does not work. I've had similar reports from a number of people now, with the only workable solution being for me or somebody on a faster connection to download the war file and then make it available on another platform. My current home office connection is a 7mbits ADSL line, and download works OK here - AS LONG AS I ONLY DOWNLOAD ONE WAR FILE AT A TIME. On 20 February 2017 at 14:28, Morten Olav Hansen <mor...@dhis2.org> wrote: > You can also use wget if you are on a unix system (which your server > probably is) > > wget -c https://www.dhis2.org/download/releases/2.26/dhis.war > > (if it times out or disconnects... just run same command again and it will > continue) > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Mon, Feb 20, 2017 at 8:20 PM, Lars Helge Øverland <l...@dhis2.org> > wrote: > >> Hi Tim, >> >> you can get the latest WAR builds from here: >> >> https://www.dhis2.org/downloads >> >> You can also consider using a download manager with resume capabilities: >> >> https://chrome.google.com/webstore/detail/chrono-download-ma >> nager/mciiogijehkdemklbdcbfkefimifhecn >> >> >> regards, >> >> Lars >> >> On Mon, Feb 20, 2017 at 1:08 PM, Timothy Kiyemba <tkiye...@gmail.com> >> wrote: >> >>> Dear all, >>> >>> Can some one help me access the latest build for DHIS2 2.26. I have >>> tried accessing it from >>> >>> https://ci.dhis2.org/job/dhis2-2.26/lastSuccessfulBuild/arti >>> fact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war >>> >>> But my downloads are not succeeding in completing. Could I be accessing >>> the wrong way? Is there a better way to get a successfull download? >>> >>> Or can someone share with me a copy via googledocs? >>> >>> Timothy >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Lars Helge Øverland >> Lead developer, DHIS 2 >> University of Oslo >> Skype: larshelgeoverland >> l...@dhis2.org >> http://www.dhis2.org <https://www.dhis2.org/> >> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Fwd: Import of DHIS metdata taking long time
Hi, In GENERAL you can import data exported from 2.24 into 2.26 - BUT there seems to be unresolved compatibility issues with the export files of SOME objects. You might be able to identify them by scrutinizing the relevant documentation (which, regrettably, isn't always 100% up-to-date), but I would rather opt for a segmented export import process (assuming you are importing into an empty database): - start with the known "primary" building blocks (those not dependent on anything else), like option sets, attributes, users - continue with the section related to orgunits, ougroups, group sets, etc - then data element section, then indicators - then tracker & events - last you export/import everything to related to analysis, reports, charts, maps, dashboards etc. Do a quick pg_dump after each section. In case of a problem, you can then roll back and try again with a different segment configuration. Most important of all: document whatever issues you find with incompatible export/import formats, and write a JIRA bug report (as should be obvious, at least upward imports from previous versions must be made to work). Alternatively, try to import the data into 2.24 using the api/24/metadata as Morten suggests - then upgrade to 2.25 and then 2.26. My 2c worth Regards Calle On 13 February 2017 at 15:08, Karrtik Iyer <karr...@thoughtworks.com> wrote: > Hi Calle, thanks, one quick question, can we import files (meta data) > exported from 2.24 version into 2.26? Because when we tried that last the > import just kept running without showing any progress. Only then we > downgraded our version to 2.24. > Thanks, > Karrtik > > > On Mon, Feb 13, 2017, 5:21 PM Calle Hedberg <calle.hedb...@gmail.com> > wrote: > >> Hi, >> >> Importing a 165mb meta-data export file into 2.24 would be awfully slow, >> in particular if you have a lot of orgunits. I've regularly been >> exporting/importing ~10,000 OU records - even if I actually only wanted to >> update a few of them, but DHIS2 do not have any export filters for e.g. >> lastupdated - and it would typically take several hours. The main culprit >> is that these OrgUnits are being imported one by one (with a catalina entry >> for each of them), and I think it is the same for many other objects. >> >> The new export/import functionality is 2.25 and 2.26 is immensely much >> faster, though - presumably because they are using more efficient sql code >> (table comparisons instead of one by one). What took 3 hours in 2.24 takes >> 30 seconds or something in 2.25 and 2.26. >> >> Bottom line: consider moving at least to 2.25, and import there. >> Otherwise you just have to wait for it to finish >> >> Regards >> Calle >> >> On 13 February 2017 at 13:10, Anilkumar Kodi <anilk...@thoughtworks.com> >> wrote: >> >> Yes, we could see that process was still running, in logs we could see >> that there are no errors and it is creating, updating dataSets, orgUnits >> and orgGroups,.. etc. >> >> >> Thanks, >> Anil Kumar K >> >> On Mon, Feb 13, 2017 at 4:20 PM, Knut Staring <knu...@gmail.com> wrote: >> >> Are you sure the process was actually running? No errors in the Tomcat >> log? >> >> On Feb 13, 2017 10:43 AM, "Nalinikanth Meesala" <nali...@thoughtworks.com> >> wrote: >> >> Hi, >> >> We are trying to import Meta data of dhis2 exported from (2.23) to our >> local instance DHIS 2(2.24) [as import of the exported metadata is not >> working in DHIS 2.23 ]. >> >> The size of meta data is 164 mb can you please help in providing inputs >> to make the import faster. previously when we tried it took more than 2 >> days and it was still running. >> >> Ca you please let us know any work around so that we can make it faster. >> >> -- >> Thanks & Regards, >> Nalinikanth M >> Quality Analyst >> Email nali...@thoughtworks.com >> Telephone +91 9052234588 <+91+9052234588> >> [image: ThoughtWorks] >> <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature_medium=email_source=thoughtworks-email-signature-generator> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-
Re: [Dhis2-users] [Dhis2-devs] My DHIS2 Reports app not loading
Timothy, If you are using the latest version of 2.26, then the more stringent validation of URL characters in recent versions of Tomcat should be supported (for details on the 8.5.x changes, see http://tomcat.apache.org/tomcat-8.5-doc/changelog.html ) If your logs still indicate that this is a tomcat issue, try upgrading to tomcat 8.5.11 - if that don't work then downgrade to 8.0.36 Regards Calle On 13 February 2017 at 13:20, Jason Pickering <jason.p.picker...@gmail.com> wrote: > The important thing to look for is a JavaScript error from the server, > namely an HTTP 400 error code. Could you sent your JavaScript console when > you load the app? > > On Mon, Feb 13, 2017 at 5:57 PM, Timothy Kiyemba <tkiye...@gmail.com> > wrote: > >> Dear Gerald, >> >> I have tried replacing the war file but the problem persists. See >> attached my catalina log file. I am working with Tomcat 8.5.8 and DHIS2 >> 2.26. Jason, do I still need to downgrade my Tomcat to 8.0.36? All my apps >> work except the Event reports app. >> >> Kind regards >> >> Timothy >> >> >> >> On Mon, Feb 13, 2017 at 9:48 AM, gerald thomas <gerald17...@gmail.com> >> wrote: >> >>> Timothy, >>> Please run maintenance and delete war file and name of folder which has >>> the name of your war file. Download a new war and tail -f >>> /path/Catalina.out if there is no error then everything should be fine. >>> Kindly note I am saying "/path/" because I don't the path of your logs. >>> Also tomcat must be stop before deleting war file and folder and "tail" the >>> logs before starting tomcat. >>> Wishing you the best. >>> >>> On Feb 13, 2017 06:26, "timothy kiyemba" <tkiye...@gmail.com> wrote: >>> >>>> Anybody with a solution to this problem? >>>> -- >>>> From: Timothy Kiyemba <tkiye...@gmail.com> >>>> Sent: 12/02/2017 21:59 >>>> To: dhis2-devs <dhis2-d...@lists.launchpad.net>; dhis2-users >>>> <dhis2-users@lists.launchpad.net> >>>> Subject: My DHIS2 Reports app not loading >>>> >>>> Dear all >>>> >>>> Has any one faced this challenge before, my DHIS2 reports app is not >>>> loading. It just shows that its loading but it never completes. Could I >>>> have missed out a step somewhere? See image below; >>>> >>>> [image: Inline image 1] >>>> >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : dhis2-users@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 <+46%2076%20414%2070%2049> > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Fwd: Import of DHIS metdata taking long time
Hi, Importing a 165mb meta-data export file into 2.24 would be awfully slow, in particular if you have a lot of orgunits. I've regularly been exporting/importing ~10,000 OU records - even if I actually only wanted to update a few of them, but DHIS2 do not have any export filters for e.g. lastupdated - and it would typically take several hours. The main culprit is that these OrgUnits are being imported one by one (with a catalina entry for each of them), and I think it is the same for many other objects. The new export/import functionality is 2.25 and 2.26 is immensely much faster, though - presumably because they are using more efficient sql code (table comparisons instead of one by one). What took 3 hours in 2.24 takes 30 seconds or something in 2.25 and 2.26. Bottom line: consider moving at least to 2.25, and import there. Otherwise you just have to wait for it to finish Regards Calle On 13 February 2017 at 13:10, Anilkumar Kodi <anilk...@thoughtworks.com> wrote: > Yes, we could see that process was still running, in logs we could see > that there are no errors and it is creating, updating dataSets, orgUnits > and orgGroups,.. etc. > > > Thanks, > Anil Kumar K > > On Mon, Feb 13, 2017 at 4:20 PM, Knut Staring <knu...@gmail.com> wrote: > >> Are you sure the process was actually running? No errors in the Tomcat >> log? >> >> On Feb 13, 2017 10:43 AM, "Nalinikanth Meesala" <nali...@thoughtworks.com> >> wrote: >> >>> Hi, >>> >>> We are trying to import Meta data of dhis2 exported from (2.23) to our >>> local instance DHIS 2(2.24) [as import of the exported metadata is not >>> working in DHIS 2.23 ]. >>> >>> The size of meta data is 164 mb can you please help in providing inputs >>> to make the import faster. previously when we tried it took more than 2 >>> days and it was still running. >>> >>> Ca you please let us know any work around so that we can make it faster. >>> >>> -- >>> Thanks & Regards, >>> Nalinikanth M >>> Quality Analyst >>> Email nali...@thoughtworks.com >>> Telephone +91 9052234588 <+91+9052234588> >>> [image: ThoughtWorks] >>> <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature_medium=email_source=thoughtworks-email-signature-generator> >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Feature roadmap for the next releases
Hi The normal way: 1. go to https://jira.dhis2.org/login.jsp 2. If you have registered already, log in with your username and passwordl 3. if not registered yet, see the "Not a member? Sign up <https://jira.dhis2.org/secure/Signup!default.jspa> for an account." Click on Sign Up, then follow instructions. regards calle On 4 February 2017 at 16:54, Geegee Adu <adugee...@yahoo.com> wrote: > Thanks Calle > Please how do I sign up to JIRA > Regards > Kwame > > Sent from my iPhone > > On 4 Feb 2017, at 11:08, Calle Hedberg <calle.hedb...@gmail.com> wrote: > > Vanya, > > It's all on JIRA - much better if you review that directly instead of > requesting separate roadmaps (every additional task like that takes > resources away from progressing on the real stuff, yes?). > > Register at https://jira.dhis2.org and you can not only see what's in the > pipeline, you can add comments, vote up features you really want yourself, > write up new issues required, and so forth. > > Regards > Calle > > On 4 February 2017 at 09:32, Vanya Seth <van...@thoughtworks.com> wrote: > >> Hi Devs >> >> Thanks for the 2.26 release and the great features. Congratulations once >> again! >> >> Can you please point to the documentation for the upcoming releases? >> Wanted to get a sense of features that are lined up for the coming releases. >> >> Thanks for the help. >> -- >> With Regards >> Vanya >> ThoughtWorks Technologies >> Hyderabad >> >> --Stay Hungry Stay Foolish!! >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > > *** > > Calle Hedberg > > 46D Alma Road, 7700 Rosebank, SOUTH AFRICA > > Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472> > > Cell: +27-82-853-5352 <+27%2082%20853%205352> > > Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119> > > Email: calle.hedb...@gmail.com > > Skype: calle_hedberg > > *********** > > ___ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Feature roadmap for the next releases
Vanya, It's all on JIRA - much better if you review that directly instead of requesting separate roadmaps (every additional task like that takes resources away from progressing on the real stuff, yes?). Register at https://jira.dhis2.org and you can not only see what's in the pipeline, you can add comments, vote up features you really want yourself, write up new issues required, and so forth. Regards Calle On 4 February 2017 at 09:32, Vanya Seth <van...@thoughtworks.com> wrote: > Hi Devs > > Thanks for the 2.26 release and the great features. Congratulations once > again! > > Can you please point to the documentation for the upcoming releases? > Wanted to get a sense of features that are lined up for the coming releases. > > Thanks for the help. > -- > With Regards > Vanya > ThoughtWorks Technologies > Hyderabad > > --Stay Hungry Stay Foolish!! > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Tomcat error
gt; > shall have a unique combination of data element id, period id, org >> >>>> unit id, >> >>>> > category option combo id, and attribute option combo id. >> >>>> > >> >>>> > So I suggest you either to use the web API and import through the >> >>>> > import/export module or find out which of the metadata IDs is >> >>>> duplicate and >> >>>> > correct it. >> >>>> > >> >>>> > Regards, >> >>>> > >> >>>> > >> >>>> > Seid, >> >>>> > >> >>>> > On Friday, January 27, 2017, gerald thomas <gerald17...@gmail.com >> >>>> <javascript:_e(%7B%7D,'cvml','gerald17...@gmail.com');>> wrote: >> >>>> > >> >>>> >> Dear All, >> >>>> >> >> >>>> >> What is the meaning of this error: >> >>>> >> >> >>>> >> * ERROR 2017-01-05 12:03:07,593 ERROR: duplicate key value >> violates >> >>>> >> unique constraint "datavalue_pkey" >> >>>> >> Detail: Key (dataelementid, periodid, sourceid, >> >>>> >> categoryoptioncomboid, attributeoptioncomboid)=(1973, 2784149, >> 301, >> >>>> >> 13, 13) already exists. >> >>>> >> >> >>>> >> Please find the attached copy of catalina.out log file >> >>>> >> >> >>>> >> -- >> >>>> >> Regards, >> >>>> >> >> >>>> >> Gerald >> >>>> >> >> >>>> > >> >>>> >> >>>> >> >>>> -- >> >>>> Regards, >> >>>> >> >>>> Gerald >> >>>> >> >>>> ___ >> >>>> Mailing list: https://launchpad.net/~dhis2-users >> >>>> Post to : dhis2-users@lists.launchpad.net >> >>>> <javascript:_e(%7B%7D,'cvml','dhis2-users@lists.launchpad.net');> >> >>>> Unsubscribe : https://launchpad.net/~dhis2-users >> >>>> More help : https://help.launchpad.net/ListHelp >> >>>> >> >>> >> >>> >> >>> >> >> >> > >> >> >> -- >> Regards, >> >> Gerald >> > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Data Set Report is not Downloading
Elmarie, We have cleaned up many of the special characters in the data element and indicator table fields, but a number remains (in particular full stops and commas). There might be a few others - it's a lot to go through and a lot of problems to clean up. Exactly which special character caused the problem in the case you refer to? Regards calle On 27 January 2017 at 15:39, gerald thomas <gerald17...@gmail.com> wrote: > Dear Elmarie, > > I had done Data Integrity Checks but i don't know which option is > responsible for dataelements names with special characters. Besides we > had been doing data cleanup and we fixed most of those issues. > > On 1/27/17, Elmarie Claasen <elma...@hisp.org> wrote: > > Gerald, > > > > We had the same problem so e toime back. Check that you dont have any > > special characters in dataelement names. > > > > Elmarie > > > > On 27 Jan 2017 14:29, "gerald thomas" <gerald17...@gmail.com> wrote: > > > >> Dear All, > >> We had successfully upgraded to version 2.25 but i noticed that we > >> can't download to excel or PDF our data set reports. > >> > >> Please i don't know if it is a bug but it is working on the DHIS2 demo > >> but not on our production server. > >> > >> Thanks in advance for your help. > >> > >> -- > >> Regards, > >> > >> Gerald > >> > >> ___ > >> Mailing list: https://launchpad.net/~dhis2-devs > >> Post to : dhis2-d...@lists.launchpad.net > >> Unsubscribe : https://launchpad.net/~dhis2-devs > >> More help : https://help.launchpad.net/ListHelp > >> > > > > -- > > > > > > *This message and any attachments are subject to a disclaimer published > at > > http://www.hisp.org/policies.html#comms_disclaimer > > <http://www.hisp.org/policies.html#comms_disclaimer>. Please read the > > disclaimer before opening any attachment or taking any other action in > > terms of this electronic transmission. If you cannot access the > > disclaimer, kindly send an email to disclai...@hisp.org > > <disclai...@hisp.org> and a copy will be provided to you. By replying to > > this e-mail or opening any attachment you agree to be bound by the > > provisions of the disclaimer.* > > > > > -- > Regards, > > Gerald > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] PostgreSQL-9.5 failed to boot-up at restart of Linux server
Ubuntu 16.04 and everything >> >> >> >> starts >> >> >> >> normally. But you have to manually migrate your 9.3 databases >> into >> >> the >> >> >> >> 9.5 >> >> >> >> format - did you do that? >> >> >> >> >> >> >> >> These were the bash commands I recorded back then (at your own >> >> >> >> risk, >> >> >> >> no >> >> >> >> guarantee - do backups and all that first) >> >> >> >> >> >> >> >> ~/tomcat-dhis/bin/shutdown.sh >> >> >> >> sudo pg_dropcluster 9.5 main --stop >> >> >> >> sudo pg_upgradecluster 9.3 main >> >> >> >> pg_lsclusters >> >> >> >> sudo pg_dropcluster 9.3 main >> >> >> >> >> >> >> >> Hope that helps, >> >> >> >> >> >> >> >> Uwe >> >> >> >> >> >> >> >> --- >> >> >> >> >> >> >> >> > gerald thomas <gerald17...@gmail.com> hat am 26. Januar 2017 >> um >> >> >> >> > 01:38 >> >> >> >> geschrieben: >> >> >> >> > >> >> >> >> > >> >> >> >> > Dear All, >> >> >> >> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 >> to >> >> >> >> > 9.5.5) and it had been successfully done but the Postgres does >> >> >> >> > not >> >> >> >> > automatically start after boot-up. I am using: (pg_ctlcluster >> 9.5 >> >> >> >> > main >> >> >> >> > start) to start my database but i want it start automatically. >> >> >> >> > >> >> >> >> > Please can someone help me? >> >> >> >> > >> >> >> >> > -- >> >> >> >> > Regards, >> >> >> >> > >> >> >> >> > Gerald >> >> >> >> > >> >> >> >> > ___ >> >> >> >> > Mailing list: https://launchpad.net/~dhis2-users >> >> >> >> > Post to : dhis2-users@lists.launchpad.net >> >> >> >> > Unsubscribe : https://launchpad.net/~dhis2-users >> >> >> >> > More help : https://help.launchpad.net/ListHelp >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> ___ >> >> >> >> Mailing list: https://launchpad.net/~dhis2-devs >> >> >> >> Post to : dhis2-d...@lists.launchpad.net >> >> >> >> Unsubscribe : https://launchpad.net/~dhis2-devs >> >> >> >> More help : https://help.launchpad.net/ListHelp >> >> >> >> >> >> >> >> >> >> >> > >> >> >> >> >> >> >> >> >> -- >> >> >> Regards, >> >> >> >> >> >> Gerald >> >> >> >> >> >> ___ >> >> >> Mailing list: https://launchpad.net/~dhis2-users >> >> >> Post to : dhis2-users@lists.launchpad.net >> >> >> Unsubscribe : https://launchpad.net/~dhis2-users >> >> >> More help : https://help.launchpad.net/ListHelp >> >> >> >> >> > >> >> >> >> >> >> -- >> >> Regards, >> >> >> >> Gerald >> >> >> > >> >> >> -- >> Regards, >> >> Gerald >> > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] AttributeOptioncombo field in datavalue table
ead the > disclaimer before opening any attachment or taking any other action in > terms of this electronic transmission. If you cannot access the > disclaimer, kindly send an email to disclai...@hisp.org > <disclai...@hisp.org> and a copy will be provided to you. By replying to > this e-mail or opening any attachment you agree to be bound by the > provisions of the disclaimer.* > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Displaying dates for weekly Periods in the Pivot table as well as download
Asif, You can hope, but unless it's really simple I doubt it - the 2.26 code "freeze" kicked in 24th Dec. Right now only 86 out of 185 issues for 2.26 have been completed Regards Calle On 28 December 2016 at 22:55, Asif <rasifil...@gmail.com> wrote: > Many thanks, Calle! assuming this is an easy one, could we expect this to > be part of version 2.26? > > Thanks, > Asif > > On Wed, Dec 28, 2016 at 3:35 PM, Calle Hedberg <calle.hedb...@gmail.com> > wrote: > >> Asif, >> >> I don't think there is a JIRA issue written for this - nothing comes up >> when searching for any issue with "week" or "weekly" in it. >> >> I've created one - see https://jira.dhis2.org/browse/DHIS2-442 >> >> Regards >> Calle >> >> >> >> On 28 December 2016 at 19:46, Asif <rasifil...@gmail.com> wrote: >> >>> Hi Jan, >>> >>> Our users have been following up for this issue. Can you please share >>> jira issue number so we can track and keep our users informed of the >>> progress? >>> >>> Thanks, >>> Asif from IRC >>> >>> On Tue, Nov 22, 2016 at 4:28 PM, David Muturi <dnmut...@gmail.com> >>> wrote: >>> >>>> Hi Jan, >>>> Many thanks. >>>> rgds >>>> David >>>> >>>> On 23 Nov 2016 12:23 am, "Jan Henrik Øverland" <j...@dhis2.org> wrote: >>>> >>>>> Hi Muturi, >>>>> >>>>> We'll look into that. >>>>> >>>>> Jan >>>>> >>>>> On 22 November 2016 at 14:10, David Muturi <dnmut...@gmail.com> wrote: >>>>> >>>>>> Hi team, >>>>>> Is it possible to display dates for weekly periods in the pivot table >>>>>> as shown in the attached image (image003(1).jpg) instead of the way it >>>>>> appears now (image004.jpg) i.e. 2016W44. The week number shown is >>>>>> difficult >>>>>> to correlate to a date period for any user, the same applies to the >>>>>> downloaded data as well. >>>>>> rgds >>>>>> David >>>>>> >>>>>> ___ >>>>>> Mailing list: https://launchpad.net/~dhis2-devs >>>>>> Post to : dhis2-d...@lists.launchpad.net >>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>>> More help : https://help.launchpad.net/ListHelp >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Jan Henrik Øverland >>>>> Software developer, DHIS 2 >>>>> University of Oslo >>>>> http://www.dhis2.org <https://www.dhis2.org/> >>>>> >>>> >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : dhis2-users@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> >> *** >> >> Calle Hedberg >> >> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA >> >> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472> >> >> Cell: +27-82-853-5352 <+27%2082%20853%205352> >> >> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119> >> >> Email: calle.hedb...@gmail.com >> >> Skype: calle_hedberg >> >> *** >> >> > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Displaying dates for weekly Periods in the Pivot table as well as download
Asif, I don't think there is a JIRA issue written for this - nothing comes up when searching for any issue with "week" or "weekly" in it. I've created one - see https://jira.dhis2.org/browse/DHIS2-442 Regards Calle On 28 December 2016 at 19:46, Asif <rasifil...@gmail.com> wrote: > Hi Jan, > > Our users have been following up for this issue. Can you please share jira > issue number so we can track and keep our users informed of the progress? > > Thanks, > Asif from IRC > > On Tue, Nov 22, 2016 at 4:28 PM, David Muturi <dnmut...@gmail.com> wrote: > >> Hi Jan, >> Many thanks. >> rgds >> David >> >> On 23 Nov 2016 12:23 am, "Jan Henrik Øverland" <j...@dhis2.org> wrote: >> >>> Hi Muturi, >>> >>> We'll look into that. >>> >>> Jan >>> >>> On 22 November 2016 at 14:10, David Muturi <dnmut...@gmail.com> wrote: >>> >>>> Hi team, >>>> Is it possible to display dates for weekly periods in the pivot table >>>> as shown in the attached image (image003(1).jpg) instead of the way it >>>> appears now (image004.jpg) i.e. 2016W44. The week number shown is difficult >>>> to correlate to a date period for any user, the same applies to the >>>> downloaded data as well. >>>> rgds >>>> David >>>> >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : dhis2-d...@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> >>> -- >>> Jan Henrik Øverland >>> Software developer, DHIS 2 >>> University of Oslo >>> http://www.dhis2.org <https://www.dhis2.org/> >>> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DHIS 2 moving to JIRA for issue tracking
Lars, Thanks - I was wondering just earlier today if I had somehow totally missed a switch to a new platform... (BTW - system asked me to upload an avatar, but it won't accept a .jpg file...) Will start adding issues from unresolved blueprints and new issues Regards Calle On 22 November 2016 at 20:38, Lars Helge Øverland <l...@dhis2.org> wrote: > Hi all, > > today we are shifting over to JIRA for issue tracking. This means that > from now on you should report bugs and propose feature at our JIRA site. > Sign up for a user account to get started: > > > https://jira.dhis2.org > > > We are consolidating all issue tracking to a single location and existing > systems including Launchpad and GitHub will no longer be in use for issues. > All features have been migrated from Launchpad. There are still a backlog > of bugs which we are working on fixing/migrating over the coming weeks. > > > > *1. *To* report an issue* click *Create* in the top menu. Select *New > feature*, *Improvement* and *Bug* depending on whether you would like to > propose a new feature, an improvement to an existing feature or a bug, > respectively. > > As always, when reporting bugs please make sure to include as much context > as possible, including at least server logs, Javascript console logs, DHIS > 2 version at Web browser. > > > > > *2. *To* search for issues* in JIRA, sign up for an account and click > *Issues* > *Search for issues*. In the search screen you can specify > various criteria: > > > - *Project*: The main software project is DHIS 2*.* > > - *Type*: Filter by new features, improvements and bugs. > > - *Status*: Filter by ToDo (not started) and Done. > > - *Version*: Click More and then *Fix version* to filter by release > version. > > - *Internal*: Click More and then *Internal feature* to filter out > low-level, system internal features. > > > > > [image: Inline image 2] > > > > *3.* Your search can be saved as a *filter*, which allows you to easily > restore a search. Click save as next to the Search label and give it a name. > > We have created filters which could be useful for you for features slated > for 2.26, 2.27 and 2.28 as well as for all open bugs. To add those filters > to your profile, click Issues > Manage filters and click the star icon next > to each filter. > > > > > > > We hope this will make it easier for you to report and look for issues. > Feedback is appreciated. > > > > best regards, > > Lars > > > > > > > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > l...@dhis2.org > http://www.dhis2.org <https://www.dhis2.org/> > > > _______ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Visualisation of Data Element of Value Type - Organisation Unit
Abyot, OK, I will have to wait for the next 2.25 war build, then (I presume the fix has been implemented for both 2.25 and trunk) Regards Calle On 25 October 2016 at 15:33, Abyot Asalefew Gizaw <ab...@dhis2.org> wrote: > was fixed about 4 hours ago, see the commit here > > https://github.com/dhis2/tracker-capture-app/commit/ > 9757cf065c5710eac2a12bcd03431db258de8c26 > > > > -- > Abyot A. Gizaw. > Senior Engineer, DHIS2 > University of Oslo > http://www.dhis2.org > > On Tue, Oct 25, 2016 at 3:25 PM, Calle Hedberg <calle.hedb...@gmail.com> > wrote: > >> Mmm, >> >> I'm still seeing double text fields in the build from this morning? >> >> Regards >> Calle >> >> On 25 October 2016 at 15:16, Abyot Asalefew Gizaw <ab...@dhis2.org> >> wrote: >> >>> except the issue with ORGANISATION_UNIT, the rest are fixed. >>> >>> -- >>> Abyot A. Gizaw. >>> Senior Engineer, DHIS2 >>> University of Oslo >>> http://www.dhis2.org >>> >>> On Tue, Oct 25, 2016 at 3:12 PM, Calle Hedberg <calle.hedb...@gmail.com> >>> wrote: >>> >>>> Abyot, >>>> >>>> have you fixed the issue of the uid being displayed for value type >>>> ORGANISATION_UNIT instead of as expected the NAME? >>>> >>>> I saw when testing 2.25 yesterday the the COORDINATE data type is now >>>> having coordinates rounded to six decimals, so that's fixed. >>>> >>>> The double-display of TEXT value fields without optionsets is also >>>> critical to fix. >>>> >>>> Regards >>>> calle >>>> >>>> On 25 October 2016 at 12:16, Abyot Asalefew Gizaw <ab...@dhis2.org> >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> Value types ORGANISATION_UNIT and COORDINATE are new additions. >>>>> Handling the data entry part is the first step, the next step is the >>>>> analysis part which is coming. >>>>> >>>>> Probably a mistake to have a half baked solutions. However, there are >>>>> users who export data and do visualizations using separate systems. >>>>> >>>>> -- >>>>> Abyot A. Gizaw. >>>>> Senior Engineer, DHIS2 >>>>> University of Oslo >>>>> http://www.dhis2.org >>>>> >>>>> On Tue, Oct 25, 2016 at 7:45 AM, Archana Chillala < >>>>> archa...@thoughtworks.com> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> We are now using the latest 2.25 DHIS version. The new feature "*Data >>>>>> Element of value type organisation unit*" proves to be extremely >>>>>> useful to us. We have a use-case where we want to record the >>>>>> geo-locations >>>>>> (villages) of each individual patient at the Heath Centre they attend. >>>>>> And >>>>>> this feature seems a right approach for us, to be used for this purpose >>>>>> where these locations will be part of the master organisation unit >>>>>> hierarchy and can be selected from the list shown for the data element. >>>>>> >>>>>> We have configured a tracker type data element of value type 'org >>>>>> unit', assigned to a Program and stored some data. However, when we tried >>>>>> to visualise this data collected for that data element, through Event >>>>>> Reports and Event Visualiser app, it gives an error saying "No series >>>>>> items >>>>>> selected". Also, since the value of the data element is a string (which >>>>>> is >>>>>> the UID of the org. unit), we are not clear as to how we could visualise >>>>>> this data element. Ideally, what we need is a COUNT of the number of >>>>>> times >>>>>> a geo-location (some org. unit) selected. >>>>>> >>>>>> We also tried to use program indicators to form an expression that >>>>>> can give the desired result. But, that data element doesn't even come up >>>>>> in >>>>>> the box, where we choose data elements and form expressions. Only number >>>>>> type data elements show up here. >>>>>> >>>>>> Is there any other way we could use aggregation and visualisatio
Re: [Dhis2-users] [Dhis2-devs] Visualisation of Data Element of Value Type - Organisation Unit
Mmm, I'm still seeing double text fields in the build from this morning? Regards Calle On 25 October 2016 at 15:16, Abyot Asalefew Gizaw <ab...@dhis2.org> wrote: > except the issue with ORGANISATION_UNIT, the rest are fixed. > > -- > Abyot A. Gizaw. > Senior Engineer, DHIS2 > University of Oslo > http://www.dhis2.org > > On Tue, Oct 25, 2016 at 3:12 PM, Calle Hedberg <calle.hedb...@gmail.com> > wrote: > >> Abyot, >> >> have you fixed the issue of the uid being displayed for value type >> ORGANISATION_UNIT instead of as expected the NAME? >> >> I saw when testing 2.25 yesterday the the COORDINATE data type is now >> having coordinates rounded to six decimals, so that's fixed. >> >> The double-display of TEXT value fields without optionsets is also >> critical to fix. >> >> Regards >> calle >> >> On 25 October 2016 at 12:16, Abyot Asalefew Gizaw <ab...@dhis2.org> >> wrote: >> >>> Hi, >>> >>> Value types ORGANISATION_UNIT and COORDINATE are new additions. Handling >>> the data entry part is the first step, the next step is the analysis part >>> which is coming. >>> >>> Probably a mistake to have a half baked solutions. However, there are >>> users who export data and do visualizations using separate systems. >>> >>> -- >>> Abyot A. Gizaw. >>> Senior Engineer, DHIS2 >>> University of Oslo >>> http://www.dhis2.org >>> >>> On Tue, Oct 25, 2016 at 7:45 AM, Archana Chillala < >>> archa...@thoughtworks.com> wrote: >>> >>>> Hi, >>>> >>>> We are now using the latest 2.25 DHIS version. The new feature "*Data >>>> Element of value type organisation unit*" proves to be extremely >>>> useful to us. We have a use-case where we want to record the geo-locations >>>> (villages) of each individual patient at the Heath Centre they attend. And >>>> this feature seems a right approach for us, to be used for this purpose >>>> where these locations will be part of the master organisation unit >>>> hierarchy and can be selected from the list shown for the data element. >>>> >>>> We have configured a tracker type data element of value type 'org >>>> unit', assigned to a Program and stored some data. However, when we tried >>>> to visualise this data collected for that data element, through Event >>>> Reports and Event Visualiser app, it gives an error saying "No series items >>>> selected". Also, since the value of the data element is a string (which is >>>> the UID of the org. unit), we are not clear as to how we could visualise >>>> this data element. Ideally, what we need is a COUNT of the number of times >>>> a geo-location (some org. unit) selected. >>>> >>>> We also tried to use program indicators to form an expression that can >>>> give the desired result. But, that data element doesn't even come up in the >>>> box, where we choose data elements and form expressions. Only number type >>>> data elements show up here. >>>> >>>> Is there any other way we could use aggregation and visualisation for >>>> this new data element type? >>>> Could you also please let us know the road map for the visualisation >>>> capabilities of this new data element. >>>> >>>> Any help here would be appreciated. >>>> >>>> >>>> >>>> *Cheers,* >>>> >>>> Archana Chillala >>>> Application Developer >>>> Email archa...@thoughtworks.com >>>> Telephone +91 9100960533 <+91+9100960533> >>>> [image: ThoughtWorks] >>>> <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature_medium=email_source=thoughtworks-email-signature-generator> >>>> >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : dhis2-d...@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> >> *** >> >> Calle Hedberg >> >> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA >> >> Tel/fax (home): +27-21-685-6472 >> >> Cell: +27-82-853-5352 >> >> Iridium SatPhone: +8816-315-19119 >> >> Email: calle.hedb...@gmail.com >> >> Skype: calle_hedberg >> >> *** >> >> > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Visualisation of Data Element of Value Type - Organisation Unit
Abyot, have you fixed the issue of the uid being displayed for value type ORGANISATION_UNIT instead of as expected the NAME? I saw when testing 2.25 yesterday the the COORDINATE data type is now having coordinates rounded to six decimals, so that's fixed. The double-display of TEXT value fields without optionsets is also critical to fix. Regards calle On 25 October 2016 at 12:16, Abyot Asalefew Gizaw <ab...@dhis2.org> wrote: > Hi, > > Value types ORGANISATION_UNIT and COORDINATE are new additions. Handling > the data entry part is the first step, the next step is the analysis part > which is coming. > > Probably a mistake to have a half baked solutions. However, there are > users who export data and do visualizations using separate systems. > > -- > Abyot A. Gizaw. > Senior Engineer, DHIS2 > University of Oslo > http://www.dhis2.org > > On Tue, Oct 25, 2016 at 7:45 AM, Archana Chillala < > archa...@thoughtworks.com> wrote: > >> Hi, >> >> We are now using the latest 2.25 DHIS version. The new feature "*Data >> Element of value type organisation unit*" proves to be extremely useful >> to us. We have a use-case where we want to record the geo-locations >> (villages) of each individual patient at the Heath Centre they attend. And >> this feature seems a right approach for us, to be used for this purpose >> where these locations will be part of the master organisation unit >> hierarchy and can be selected from the list shown for the data element. >> >> We have configured a tracker type data element of value type 'org unit', >> assigned to a Program and stored some data. However, when we tried to >> visualise this data collected for that data element, through Event Reports >> and Event Visualiser app, it gives an error saying "No series items >> selected". Also, since the value of the data element is a string (which is >> the UID of the org. unit), we are not clear as to how we could visualise >> this data element. Ideally, what we need is a COUNT of the number of times >> a geo-location (some org. unit) selected. >> >> We also tried to use program indicators to form an expression that can >> give the desired result. But, that data element doesn't even come up in the >> box, where we choose data elements and form expressions. Only number type >> data elements show up here. >> >> Is there any other way we could use aggregation and visualisation for >> this new data element type? >> Could you also please let us know the road map for the visualisation >> capabilities of this new data element. >> >> Any help here would be appreciated. >> >> >> >> *Cheers,* >> >> Archana Chillala >> Application Developer >> Email archa...@thoughtworks.com >> Telephone +91 9100960533 <+91+9100960533> >> [image: ThoughtWorks] >> <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature_medium=email_source=thoughtworks-email-signature-generator> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic
Neeraj, Thanks for that, it is useful info. The instance has a very skewed balance between data elements/catcombos and indicators, but what else is new - outside of South Africa, most countries have the same: they collect a huge number or data elements but turn very few of them into indicators (SA collect very very few data elements that are NOT part of any indicator). But that is a separate discussion. I would NOT expect the number of data elements & catcombos + the number of orgunits to have a significant impact on analytics performance, but that needs to be verified. I WOULD expect the number of indicators to have a significant impact, so if you doubled or quadrupled the number of indicators I would expect a significant impact on analytics time Using your and my numbers as a baseline, I would envision the following tests to be revealing: Baseline system 1: SSD, 4-core CPU: 100 mill values, 400 DEs, 250 indicators, 30,000 OUs, few catcombos -> 1 hour for analytics processing Baseline system 2: SSD, 12-core CPU: 500 mill values, 3,500 DEs, 15,000 OUs, 25 catcombos -> ~10 hours for analytics processing Test 1: Using system 1, reduce OUs to 15,000 - run analytics (hypothesis: no significant difference) Test 2: Using system 1, reduce indicators to 125 - run analytics, then to 0 - run analytics (hypothesis: analytics reduced to 45 min) Test 3: Using system 1, increase datavalues from 100mill to 500 mill by introducing additional attributecombos (easy) - run analytics (hypothesis: ~15 hours for analytics processing, with 4-cores instead of 12-cores) Test 4: Using system 1, increase datavalues to 1 billion - run analytics (hypothesis: 35 hours for analytics processing). Neeraj, I don't know if you have a similar sandbox server available for testing, but if you do: Test 5: Using system 2, increase number of indicators to 600 (just export the 200 you have, modify the names and uids a bit, and re-import - for the purpose of this test, it does not matter that many of the indicators have identical formulas). Hypothesis: Analytics time up at least 20% Test 6: using system 2 (with 200 indicators), shift half of the 500 mill data values forward or backward in time resulting in twice the number of analytics tables at half the size. (hypothesis: slight reduction in processing time) Test 7: Using system 2 (with 200 indicators), increase datavalues to 1 billion using a new attributecombo - run analytics (hypothesis: analytics time up to 25 hours again). As far as I've seen, the bulk of analytics processing time is taken up by indexing - which I would expect to follow a moderately quadratic curve in terms of analytics table sizes. Best regards Calle On 24 October 2016 at 10:39, Neeraj Gupta <neeraj.h...@gmail.com> wrote: > Calle, > > We have around 500 million record in database with 3666 data elements > having 26 category combinations and 201 indicators and there are 14398 > organisation units. > > Thanks, > Neeraj > > On Mon, Oct 24, 2016 at 1:50 PM, Calle Hedberg <calle.hedb...@gmail.com> > wrote: > >> Neeraj, >> >> You never stated the number of records you have in the datavalue table - >> what is it? >> >> In the same context: anybody have a rough idea of how many datavalue >> records there are in the global DATIM database - which I think currently >> might be the largest DHIS2 instance around? >> >> Given our own recent work on performance + what Neeraj has reported, I've >> been thinking of creating one test instance with let us say 500 mill >> datavalue records and another with let us say 1 billion, then use them to >> identify key bottlenecks in various processes AND use them to ensure that >> DHIS2 analytics performance is as linear as possible in terms of database >> size. Postgresql has introduced a number of new indexing algorithms in >> recent versions, and I'm not sure if DHIS2 is taking full advantage of them. >> >> Best regards >> Calle >> >> On 24 October 2016 at 07:53, Brajesh Murari <brajesh.mur...@gmail.com> >> wrote: >> >>> Congratulation Neeraj and team ...it much appreciated >>> >>> On Mon, Oct 24, 2016 at 11:08 AM, Neeraj Gupta <neeraj.h...@gmail.com> >>> wrote: >>> >>>> Dear Team, Thanks for all your suggestions. >>>> >>>> Now the time of analytic is reduced to 10 hours 41 minutes. >>>> >>>> We tried to VACUUM as Sam suggested but it didn't help then we upgraded >>>> postgres from 9.4 to 9.5.4 and as Calle and Bob suggested we made some >>>> changes in configuration file of postgres and it reduced the time. But the >>>> database size is still same. >>>> >>>> Thanks for all your help! >>>> >>&
Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic
Neeraj, You never stated the number of records you have in the datavalue table - what is it? In the same context: anybody have a rough idea of how many datavalue records there are in the global DATIM database - which I think currently might be the largest DHIS2 instance around? Given our own recent work on performance + what Neeraj has reported, I've been thinking of creating one test instance with let us say 500 mill datavalue records and another with let us say 1 billion, then use them to identify key bottlenecks in various processes AND use them to ensure that DHIS2 analytics performance is as linear as possible in terms of database size. Postgresql has introduced a number of new indexing algorithms in recent versions, and I'm not sure if DHIS2 is taking full advantage of them. Best regards Calle On 24 October 2016 at 07:53, Brajesh Murari <brajesh.mur...@gmail.com> wrote: > Congratulation Neeraj and team ...it much appreciated > > On Mon, Oct 24, 2016 at 11:08 AM, Neeraj Gupta <neeraj.h...@gmail.com> > wrote: > >> Dear Team, Thanks for all your suggestions. >> >> Now the time of analytic is reduced to 10 hours 41 minutes. >> >> We tried to VACUUM as Sam suggested but it didn't help then we upgraded >> postgres from 9.4 to 9.5.4 and as Calle and Bob suggested we made some >> changes in configuration file of postgres and it reduced the time. But the >> database size is still same. >> >> Thanks for all your help! >> >> Thanks, >> Neeraj >> >> On Wed, Oct 19, 2016 at 6:46 PM, Calle Hedberg <calle.hedb...@gmail.com> >> wrote: >> >>> Neeraj, >>> >>> It's always an element of uncertainty linked to database sizes - ref >>> Sam's post over. So indicating the number of records you have in the >>> datavalue table & key meta-data tables would be useful + indicating whether >>> you are running other instances on the same server. Some comments - I've >>> been doing a lot of similar optimising work recently: >>> >>> 1. Upgrading to 9.5.4 is strongly recommended (and don't use 9.6 before >>> the worst bugs are fixed and it has stabilised). >>> >>> 2. Carefully check your postgres.conf against the recommended settings. >>> The guide is a bit superficial in the sense that it has recommended "fixed" >>> values only and no explanations around ranges below or above those, but you >>> can experiment a bit yourself (e.g. the recommended "max_connections = 200" >>> might not be sufficient for a really large system like what you have. >>> >>> 3. If your server is running that single instance only, then 48GB or RAM >>> should be sufficient. Our servers are all having 128GB RAM so we >>> experimented quite a bit earlier this year with giving a DHIS2 instance >>> large amounts or RAM (up to 60-70gb), with negligible impact on >>> performance. According to Lars, the DHIS2 cannot really utilize more than >>> around 16gb RAM (at least that is how I understood his communication at the >>> time). So 48GB should be sufficient for a single instance. >>> >>> 4. I've been doing performance optimizing recently on an instance with >>> - 4-core server with 2x 512gb ssd, 12gb allocated to DHIS2 >>> - 31,000 Orgunits >>> - 420 data elements >>> - 250 indicators >>> - around 100 mill datavalue records >>> - total size around 140gb with analytics tables. >>> >>> So the size is only 25% of your 500GB, but RUNNING ANALYTICS ON THAT >>> DATABASE INSTANCE IS TAKING JUST OVER 1 HOUR. Fundamentally, if the >>> analytics engine is designed well, I would expect a nearly linear >>> relationship between database size and the time analytics takes to run. So >>> running analytics on your database on our server should in theory take 4-5 >>> hours. >>> >>> We are obviously comparing oranges and nectarines here, in the sense >>> that there might be other aspects of our server and database that is >>> different from yours (type of CPU, no of OUs, no of DEs/Indicators, whether >>> your instance have lots of tracker data, etc etc). I have not seen any >>> scientific/quantified comparative performance values related to specific >>> parameters like number of CPUs and/or number of cores, but 12 cores SHOULD >>> improve analytics performance quite a bit - assuming around 30% then it >>> means running analytics on your database/server should take around 3 >>> hours.. >>> >>> I tried getting comparative, quantitative data on various configuratio
Re: [Dhis2-users] [Dhis2-devs] GIS failing to load in 2.25
Morten, Thanks - noted, Regards Calle On 24 October 2016 at 10:08, Morten Olav Hansen <mor...@dhis2.org> wrote: > Hi Calle > > No, this is just general Chrome Developer Tools stuff.. should be easy to > google for a guide :) > > I see that there are plenty videos on youtube also (search for "chrome > developer tools"), this can be very useful in figuring these kinds of > issues. > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Mon, Oct 24, 2016 at 2:49 PM, Calle Hedberg <calle.hedb...@gmail.com> > wrote: > >> Morten, >> >> i was not aware of the "log XHR requests" feature. >> >> Is there a DHIS2-related guide to using advanced features of the Chrome >> console somewhere? >> >> Regards >> Calle >> >> On 24 October 2016 at 04:31, Morten Olav Hansen <mor...@dhis2.org> wrote: >> >>> Hi Sam >>> >>> This is caused by the metadata having some issues I'm guessing... I >>> would try and have a look at the network panel (in the web inspector) to >>> see exactly which request it stops on.. since you are using Chrome, you >>> should be able to right click on the console and select "log XHR requests", >>> that will hopefully give you a clue to exactly which request is failing. >>> >>> -- >>> Morten Olav Hansen >>> Senior Engineer, DHIS 2 >>> University of Oslo >>> http://www.dhis2.org >>> >>> On Mon, Oct 17, 2016 at 9:37 PM, Sam Kasozi <kaso...@gmail.com> wrote: >>> >>>> Hi Lars, this is the original error message from an upgraded instance >>>> from 2.25. >>>> >>>> The developer console, gives the error below: >>>> >>>> ext-all.js:15 Uncaught You're trying to decode an invalid JSON String: >>>> Also in the attached./ Screen shot attached as well. >>>> >>>> >>>> P.s With the new instance, I could not access the orgunits; nor were >>>> they displaying as part of the maintenance, GIS module wasn't loading >>>> either - It would be good to try out from your end. >>>> >>>> regards, >>>> >>>> >>>> Sam Kasozi >>>> +256 788-993-565 >>>> Skype: sam.kasoziug >>>> >>>> On Mon, Oct 17, 2016 at 4:44 PM, Lars Helge Øverland <l...@dhis2.org> >>>> wrote: >>>> >>>>> >>>>> >>>>> On Mon, Oct 17, 2016 at 3:42 PM, Sam Kasozi <kaso...@gmail.com> wrote: >>>>> >>>>>> GIS is failing to load in a new instance of 2.25; not sure if this is >>>>>> a bug or whether some pre-configuration needs to happen. >>>>>> >>>>>> regards, >>>>>> >>>>>> >>>>> >>>>> Hi Sam, >>>>> >>>>> we need some more info, can you check in the browser developer console >>>>> and post output? If nothing there, tomcat log is helpful. >>>>> >>>>> regards, >>>>> >>>>> Lars >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>> Sam Kasozi >>>>>> +256 788-993-565 >>>>>> Skype: sam.kasoziug >>>>>> >>>>>> _______ >>>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>>> Post to : dhis2-users@lists.launchpad.net >>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>> More help : https://help.launchpad.net/ListHelp >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Lars Helge Øverland >>>>> Lead developer, DHIS 2 >>>>> University of Oslo >>>>> Skype: larshelgeoverland >>>>> l...@dhis2.org >>>>> http://www.dhis2.org <https://www.dhis2.org/> >>>>> >>>>> >>>> >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : dhis2-d...@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> >> *** >> >> Calle Hedberg >> >> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA >> >> Tel/fax (home): +27-21-685-6472 >> >> Cell: +27-82-853-5352 >> >> Iridium SatPhone: +8816-315-19119 >> >> Email: calle.hedb...@gmail.com >> >> Skype: calle_hedberg >> >> *** >> >> > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] GIS 2.25
Absalom, Postgis 9.5.3 don't exist... The latest version of postgis to use with PostgreSQL 9.5.2+ is Postgis 2.3.0 just note this from the download instructions: *Make sure you are using PostgreSQL 9.5.2+ or PostgreSQL 9.4.7+ or PostgreSQL 9.6.0+.* Otherwise follow Morten's advice - press CTRL-SHIFT-J to open the Chrome console (then check the Console tab), and look for errors which might give a clue. Regards Calle On 24 October 2016 at 06:54, Morten Olav Hansen <mor...@dhis2.org> wrote: > Hi > > Are you using chrome? could you open up the developer tools, and see if > there is anything in the console. Sounds like it can't load because of some > issues with your configuration. > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Mon, Oct 24, 2016 at 11:51 AM, Absolom MURAMIRA <absolo...@yahoo.com> > wrote: > >> Dear Calle, >> >> I installed postgis 9.5.3. Would that be the reason? >> >> Sent from Yahoo Mail on Android >> <https://overview.mail.yahoo.com/mobile/?.src=Android> >> >> On Mon, 24 Oct, 2016 at 0:35, Calle Hedberg >> <calle.hedb...@gmail.com> wrote: >> Absalom, >> >> You have installed postgis with pg 9.5.4? >> >> Regards >> Calle >> >> On 22 October 2016 at 10:36, Absolom MURAMIRA <absolo...@yahoo.com> >> wrote: >> >>> Dear All, >>> >>> I am testing release 2.25 and appreciate the developers' contribution to >>> the good improvements to the DHIS2 application. >>> Most of the apps are running well apart from the GIS app. It loads >>> forever and cannot load its interface to enable me generate maps. Can >>> someone please advise me if there is some configuration I need to enable >>> first? I checked the demo site which is okay. the pivot tables and data >>> visualizers are loading normally. >>> >>> The testing environment in Linux server 16.04 LTS and postgresql 9.5 >>> >>> Thank you. >>> >>> Absolom >>> Kigali >>> >>> __ _ >>> Mailing list: https://launchpad.net/~dhis2- devs >>> <https://launchpad.net/~dhis2-devs> >>> Post to : dhis2-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2- devs >>> <https://launchpad.net/~dhis2-devs> >>> More help : https://help.launchpad.net/ ListHelp >>> <https://help.launchpad.net/ListHelp> >>> >>> >> >> >> -- >> >> *** >> >> Calle Hedberg >> >> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA >> >> Tel/fax (home): +27-21-685-6472 >> >> Cell: +27-82-853-5352 >> >> Iridium SatPhone: +8816-315-19119 >> >> Email: calle.hedb...@gmail.com >> >> Skype: calle_hedberg >> >> *** >> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] GIS failing to load in 2.25
Morten, i was not aware of the "log XHR requests" feature. Is there a DHIS2-related guide to using advanced features of the Chrome console somewhere? Regards Calle On 24 October 2016 at 04:31, Morten Olav Hansen <mor...@dhis2.org> wrote: > Hi Sam > > This is caused by the metadata having some issues I'm guessing... I would > try and have a look at the network panel (in the web inspector) to see > exactly which request it stops on.. since you are using Chrome, you should > be able to right click on the console and select "log XHR requests", that > will hopefully give you a clue to exactly which request is failing. > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Mon, Oct 17, 2016 at 9:37 PM, Sam Kasozi <kaso...@gmail.com> wrote: > >> Hi Lars, this is the original error message from an upgraded instance >> from 2.25. >> >> The developer console, gives the error below: >> >> ext-all.js:15 Uncaught You're trying to decode an invalid JSON String: >> Also in the attached./ Screen shot attached as well. >> >> >> P.s With the new instance, I could not access the orgunits; nor were they >> displaying as part of the maintenance, GIS module wasn't loading either - >> It would be good to try out from your end. >> >> regards, >> >> >> Sam Kasozi >> +256 788-993-565 >> Skype: sam.kasoziug >> >> On Mon, Oct 17, 2016 at 4:44 PM, Lars Helge Øverland <l...@dhis2.org> >> wrote: >> >>> >>> >>> On Mon, Oct 17, 2016 at 3:42 PM, Sam Kasozi <kaso...@gmail.com> wrote: >>> >>>> GIS is failing to load in a new instance of 2.25; not sure if this is a >>>> bug or whether some pre-configuration needs to happen. >>>> >>>> regards, >>>> >>>> >>> >>> Hi Sam, >>> >>> we need some more info, can you check in the browser developer console >>> and post output? If nothing there, tomcat log is helpful. >>> >>> regards, >>> >>> Lars >>> >>> >>> >>> >>> >>> >>>> Sam Kasozi >>>> +256 788-993-565 >>>> Skype: sam.kasoziug >>>> >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : dhis2-users@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> >>> -- >>> Lars Helge Øverland >>> Lead developer, DHIS 2 >>> University of Oslo >>> Skype: larshelgeoverland >>> l...@dhis2.org >>> http://www.dhis2.org <https://www.dhis2.org/> >>> >>> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] GIS 2.25
Absalom, You have installed postgis with pg 9.5.4? Regards Calle On 22 October 2016 at 10:36, Absolom MURAMIRA <absolo...@yahoo.com> wrote: > Dear All, > > I am testing release 2.25 and appreciate the developers' contribution to > the good improvements to the DHIS2 application. > Most of the apps are running well apart from the GIS app. It loads forever > and cannot load its interface to enable me generate maps. Can someone > please advise me if there is some configuration I need to enable first? I > checked the demo site which is okay. the pivot tables and data visualizers > are loading normally. > > The testing environment in Linux server 16.04 LTS and postgresql 9.5 > > Thank you. > > Absolom > Kigali > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic
t; *Cc: *DHIS 2 Users list <dhis2-users@lists.launchpad.net>, DHIS2 > Developers <dhis2-d...@lists.launchpad.net> > *Subject: *Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic > > > > Dear Neeraj, > > > > The physical database size doesn't matter much, even the number of records > don't matter. In my experience the biggest problem that one can going to > run in to is not size, but the number of queries you can handle at a time > instance specially during analytic functionality execution. Most probably > you should going to have to move to a master/slave configuration of your > database, so that the read queries can run against the slaves and the write > queries run against the master. However, if you and your database > management team are not ready for this than, you can tweak your indexes for > the queries you are running to speed up the response times. Also there is a > lot of tweaking you can do to the network stack and kernel in Linux where > MySQL Server has been installed that will help.Perhaps, I would focus first > on your indexes, then have a server admin look at your OS, and if all that > doesn't help it might be time to implement a master/slave configuration. > The most important scalability factor is RAM. If the indexes of your tables > fit into memory and your queries are highly optimized in analytic > functionality, you can serve a reasonable amount of requests with a average > machine. The number of records do matter, depending of how your tables look > like. It's a difference to have a lot of varchar fields or only a couple of > ints or longs. The physical size of the database matters as well, think of > backups, for instance. Depending on your engine, your physical db files on > grow, but don't shrink, for instance with innodb. So deleting a lot of > rows, doesn't help to shrink your physical files. Thus the database size > does matter. If you have more than one table with more than a million > records, then performance starts indeed to degrade. Indexig is one of the > important stand need to take care, If you hit one million records you will > get performance problems, if the indices are not set right (for example no > indices for fields in "WHERE statements" or "ON conditions" in joins). If > you hit 10 million records, you will start to get performance problems even > if you have all your indices right. Hardware upgrades - adding more memory > and more processor power, especially memory - often help to reduce the most > severe problems by increasing the performance again, at least to a certain > degree. > > > > On Wed, Oct 19, 2016 at 12:35 PM, Knut Staring <knu...@gmail.com> wrote: > > Just a heads-up that there seems to be a JDBC issue with Postgres 9.6, so > perhaps you should try upgrading to 9.5 first. > > > > On Wed, Oct 19, 2016 at 8:58 AM, Lars Helge Øverland <l...@dhis2.org> > wrote: > > > > Hi Neeraj, > > > > what usually helps to improve runtime is to improve/increase: > > > > - ssd (read and write speed) > > - number of CPUs > > - using latest postgresql (9.6 claims to have even better indexing > performance <https://www.postgresql.org/docs/9.6/static/release-9-6.html> > than 9.5) > > - tuning > <https://dhis2.github.io/dhis2-docs/master/en/implementer/html/install_server_setup.html#install_postgresql_performance_tuning> > of postgresql > > > > > > regards, > > > > Lars > > > > > > > > -- > > Lars Helge Øverland > > Lead developer, DHIS 2 > > University of Oslo > > Skype: larshelgeoverland > > l...@dhis2.org > > http://www.dhis2.org <https://www.dhis2.org/> > > > > > > ___ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > > > > > -- > > Knut Staring > > Dept. of Informatics, University of Oslo > > Norway: +4791880522 > > Skype: knutstar > > http://dhis2.org > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > > > > > -- > > Best Regards, > > > > Brajesh Murari, > > Postgraduate, Department of Computer Science and Engineering, > > Chaudhary Devi Lal University, Sirsa, > > India. > > > > The three basic dimensions of human developm
Re: [Dhis2-users] [Dhis2-devs] Looking for Human Resource System to integrate with DHIS
Arthur, I'm not directly involved with the HRIS work using DHIS, my current focus is on a fully integrated disease surveillance system. Will find out and get back to you. Regards Calle On 4 October 2016 at 15:15, Arthur Heywood <arthurheyw...@gmail.com> wrote: > Calle > In Zambia we are also looking to set up what you call a "core" Human > Resource HMIS ... mainly to do some "Bottleneck analysis" for our MDGi > districts ... > > Are we able to use a beta version and see what we are able to adapt it to > our needs (same people being called different professional jobs etc) and > then feed back into the development process interesting to know how far > you have progressed? > > Cheers > a > > *Without deviation from the norm, there can be no progress*** *(Frank > Zappa)* > *Skype* arthur_heywood_za > Tanzania* +255-773669393 OR +255 673150252 > > > > > > > > > > On 26 August 2016 at 23:08, Calle Hedberg <calle.hedb...@gmail.com> wrote: > >> Laura, >> >> The two main HRIS component designs "within" DHIS2 are the HRHIS in >> Tanzania and another in Vietnam (John Lewis or Morten will be able to tell >> you more about that one). >> >> South Africa is currently using a customised Tracker app for managing >> Community Service and Internships (around 10,000 graduates are applying for >> internship or Community Service posts per annum). >> >> We are also working on a "core" workforce registry tightly integrated >> with DHIS2. By "core" I mean it will only deal with actual HR resources >> including position, what they are licensed/authorised to do, and contact >> details. Things like continuous education, bursaries, payroll, etc are >> processed/managed by other systems. A major advantage of tight integration >> will be the ability to use DHIS2 communication and messages + user >> registration to communicate directly with health workers - in particular >> since health workers increasingly will be interacting directly with DHIS2 >> on a daily basis through (daily) capturing of routine data, disease >> notifications, various Tracker apps (browser or Android), etc. >> >> Your basic requirements seem very similar: your primary need is to track >> the workforce as an INPUT RESOURCE to health service delivery, and not to >> track salaries and CVs and health insurance and employment history and a >> bunch of other "personal" things. So you need to know WHO they are, where >> they actually work and with what (in what position), what they are able to >> do (mostly this relates to formal/legal practice licensing etc, but it >> could be expanded to include specialist knowledge about certain diseases >> etc), and how to contact them. >> >> Regards >> Calle >> >> On 26 August 2016 at 21:56, gerald thomas <gerald17...@gmail.com> wrote: >> >>> I had use ihris and it is good. If you want help with it I am willing to >>> help. >>> >>> On Aug 26, 2016 6:46 PM, "Laura E. Lincks" < >>> laura.lin...@icap.columbia.edu> wrote: >>> >>>> We are looking for a simple Human Resources tool to integrate with a >>>> DHIS aggregate database. Little is known of the needs of the HRIS, but for >>>> now it needs to track personnel details and groups of personnel will need >>>> to be associated with various programs in a separate DHIS aggregate >>>> database. An Open Source HRIS is preferable. >>>> >>>> In searching for tools I have come across the following: >>>> HRHIS <https://en.wikipedia.org/wiki/HRHIS>in Tanzania developed by >>>> the HISP-TZ/University of Dar es Salaam >>>> iHRIS <http://www.ihris.org/> developed by global Capacity Project. >>>> >>>> I was wondering if anyone had any knowledge of or experience with these >>>> packages or if there were other applications that could be of use to us? >>>> >>>> Thanks in advance to anyone with leads or information. >>>> >>>> *Laura E. Lincks* >>>> Database Manager/Developer >>>> ICAP - Columbia University >>>> Mailman School of Public Health >>>> 60 Haven Ave, Floor B1 >>>> New York, NY 10032 >>>> Tel: 212 304 7132 >>>> >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : dhis2-users@lists.launchpad.net >>>> Unsubscribe : https:/
Re: [Dhis2-users] [Dhis2-devs] Looking for Human Resource System to integrate with DHIS
Laura, The two main HRIS component designs "within" DHIS2 are the HRHIS in Tanzania and another in Vietnam (John Lewis or Morten will be able to tell you more about that one). South Africa is currently using a customised Tracker app for managing Community Service and Internships (around 10,000 graduates are applying for internship or Community Service posts per annum). We are also working on a "core" workforce registry tightly integrated with DHIS2. By "core" I mean it will only deal with actual HR resources including position, what they are licensed/authorised to do, and contact details. Things like continuous education, bursaries, payroll, etc are processed/managed by other systems. A major advantage of tight integration will be the ability to use DHIS2 communication and messages + user registration to communicate directly with health workers - in particular since health workers increasingly will be interacting directly with DHIS2 on a daily basis through (daily) capturing of routine data, disease notifications, various Tracker apps (browser or Android), etc. Your basic requirements seem very similar: your primary need is to track the workforce as an INPUT RESOURCE to health service delivery, and not to track salaries and CVs and health insurance and employment history and a bunch of other "personal" things. So you need to know WHO they are, where they actually work and with what (in what position), what they are able to do (mostly this relates to formal/legal practice licensing etc, but it could be expanded to include specialist knowledge about certain diseases etc), and how to contact them. Regards Calle On 26 August 2016 at 21:56, gerald thomas <gerald17...@gmail.com> wrote: > I had use ihris and it is good. If you want help with it I am willing to > help. > > On Aug 26, 2016 6:46 PM, "Laura E. Lincks" <laura.lin...@icap.columbia.edu> > wrote: > >> We are looking for a simple Human Resources tool to integrate with a DHIS >> aggregate database. Little is known of the needs of the HRIS, but for now >> it needs to track personnel details and groups of personnel will need to be >> associated with various programs in a separate DHIS aggregate database. An >> Open Source HRIS is preferable. >> >> In searching for tools I have come across the following: >> HRHIS <https://en.wikipedia.org/wiki/HRHIS>in Tanzania developed by the >> HISP-TZ/University of Dar es Salaam >> iHRIS <http://www.ihris.org/> developed by global Capacity Project. >> >> I was wondering if anyone had any knowledge of or experience with these >> packages or if there were other applications that could be of use to us? >> >> Thanks in advance to anyone with leads or information. >> >> *Laura E. Lincks* >> Database Manager/Developer >> ICAP - Columbia University >> Mailman School of Public Health >> 60 Haven Ave, Floor B1 >> New York, NY 10032 >> Tel: 212 304 7132 >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > _______ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Overlapping text in DHIS2 UI
Elmarie, I will discuss it with Lars et al Regards Calle On 12 August 2016 at 07:16, Elmarie Claasen <elma...@hisp.org> wrote: > Hi Calle, > > Great that you found the problem but surely this os not desired behavior > as any user can chamge their personal settings and it should not result in > such changes? > > Elmarie > > On 11 Aug 2016 23:18, "Calle Hedberg" <calle.hedb...@gmail.com> wrote: > >> David, >> >> I found the problem: some user had changed the setting under >> "Profile->Settings->Interface" from "Light blue" to "Myanmar" - as soon as >> I changed that back for ONE user it resolved the problem. I also changed >> the same setting under Apps->Settings->Style, but that did not seem to do >> anything. >> >> Should be OK now - please check. >> >> Regards >> Calle >> >> On 11 August 2016 at 10:29, David Itana <dit...@hispna.org> wrote: >> >>> Hi Alex, >>> >>> >>> >>> Have cleared the cache over and over but it does not help at all. >>> >>> >>> >>> David >>> >>> >>> >>> *From:* Alex Tumwesigye [mailto:atumwesi...@gmail.com] >>> *Sent:* Thursday, August 11, 2016 9:21 AM >>> *To:* David Itana >>> *Cc:* Calle Hedberg; Knut Staring; DHIS 2 Users list; dhis2-devs >>> *Subject:* Re: [Dhis2-users] [Dhis2-devs] Overlapping text in DHIS2 UI >>> >>> >>> >>> Dear David, >>> >>> >>> >>> Please ensure that the cache is cleared when the user is logging in. >>> There is a possibility of mismatched download of metadata or userSettings. >>> >>> >>> >>> Alex >>> >>> >>> >>> On Thu, Aug 11, 2016 at 10:49 AM, David Itana <dit...@hispna.org> wrote: >>> >>> Hi Calle, >>> >>> >>> >>> The problem is consistent, it does not vary from session to session. >>> >>> >>> >>> I will have to investigate further on specific priviliges or settings in >>> common amongst the affected users. Let me get back to you later on this one. >>> >>> >>> >>> David >>> >>> >>> >>> *From:* Calle Hedberg [mailto:calle.hedb...@gmail.com] >>> *Sent:* Thursday, August 11, 2016 8:41 AM >>> *To:* Knut Staring >>> *Cc:* David Itana; DHIS 2 Users list; dhis2-devs >>> >>> >>> *Subject:* Re: [Dhis2-devs] Overlapping text in DHIS2 UI >>> >>> >>> >>> Knut, >>> >>> >>> >>> That was my first thought too - but it would not explain why only some >>> users have this issue when using exactly the same database and machine >>> >>> >>> >>> David, >>> >>> >>> >>> Some more questions: >>> >>> 1. is the problem consistent for those specific users, or will it vary >>> from session to session? >>> >>> 2. Do those affected users have any specific settings or privileges in >>> common? (like e.g. do they have private dashboards?) >>> >>> >>> >>> regards >>> >>> calle >>> >>> >>> >>> On 11 August 2016 at 09:26, Knut Staring <knu...@gmail.com> wrote: >>> >>> Does this apply to the most recent versions of Chrome and Firefox also? >>> >>> >>> >>> Or perhaps it did indeed start after an update of these browsers? >>> >>> >>> >>> Knut >>> >>> >>> >>> On Thu, Aug 11, 2016 at 9:17 AM, David Itana <dit...@hispna.org> wrote: >>> >>> Hi Calle, >>> >>> >>> >>> I have tried the screen resolution as well but no difference, the texts >>> remains overlapping. >>> >>> >>> >>> For further clarity, we have been using this version for some months >>> now, and this only started happening a few days ago. >>> >>> >>> >>> Regards, >>> >>> >>> >>> David >>> >>> >>> >>> *From:* Calle Hedberg [mailto:calle.hedb...@gmail.com] >>> *Sent:* Thursday, August 11, 2016 8:13 AM >>> *To:* David Itana >>> *Cc:* DHIS 2 Users list; dhis2-devs >>> *Subject:* Re: [Dhis2-devs] Overlapping text in DHIS2 UI >>>
Re: [Dhis2-users] [Dhis2-devs] Overlapping text in DHIS2 UI
David, I found the problem: some user had changed the setting under "Profile->Settings->Interface" from "Light blue" to "Myanmar" - as soon as I changed that back for ONE user it resolved the problem. I also changed the same setting under Apps->Settings->Style, but that did not seem to do anything. Should be OK now - please check. Regards Calle On 11 August 2016 at 10:29, David Itana <dit...@hispna.org> wrote: > Hi Alex, > > > > Have cleared the cache over and over but it does not help at all. > > > > David > > > > *From:* Alex Tumwesigye [mailto:atumwesi...@gmail.com] > *Sent:* Thursday, August 11, 2016 9:21 AM > *To:* David Itana > *Cc:* Calle Hedberg; Knut Staring; DHIS 2 Users list; dhis2-devs > *Subject:* Re: [Dhis2-users] [Dhis2-devs] Overlapping text in DHIS2 UI > > > > Dear David, > > > > Please ensure that the cache is cleared when the user is logging in. There > is a possibility of mismatched download of metadata or userSettings. > > > > Alex > > > > On Thu, Aug 11, 2016 at 10:49 AM, David Itana <dit...@hispna.org> wrote: > > Hi Calle, > > > > The problem is consistent, it does not vary from session to session. > > > > I will have to investigate further on specific priviliges or settings in > common amongst the affected users. Let me get back to you later on this one. > > > > David > > > > *From:* Calle Hedberg [mailto:calle.hedb...@gmail.com] > *Sent:* Thursday, August 11, 2016 8:41 AM > *To:* Knut Staring > *Cc:* David Itana; DHIS 2 Users list; dhis2-devs > > > *Subject:* Re: [Dhis2-devs] Overlapping text in DHIS2 UI > > > > Knut, > > > > That was my first thought too - but it would not explain why only some > users have this issue when using exactly the same database and machine > > > > David, > > > > Some more questions: > > 1. is the problem consistent for those specific users, or will it vary > from session to session? > > 2. Do those affected users have any specific settings or privileges in > common? (like e.g. do they have private dashboards?) > > > > regards > > calle > > > > On 11 August 2016 at 09:26, Knut Staring <knu...@gmail.com> wrote: > > Does this apply to the most recent versions of Chrome and Firefox also? > > > > Or perhaps it did indeed start after an update of these browsers? > > > > Knut > > > > On Thu, Aug 11, 2016 at 9:17 AM, David Itana <dit...@hispna.org> wrote: > > Hi Calle, > > > > I have tried the screen resolution as well but no difference, the texts > remains overlapping. > > > > For further clarity, we have been using this version for some months now, > and this only started happening a few days ago. > > > > Regards, > > > > David > > > > *From:* Calle Hedberg [mailto:calle.hedb...@gmail.com] > *Sent:* Thursday, August 11, 2016 8:13 AM > *To:* David Itana > *Cc:* DHIS 2 Users list; dhis2-devs > *Subject:* Re: [Dhis2-devs] Overlapping text in DHIS2 UI > > > > Hi > > > > Just a clarification note: the build number seems "abnormal" because this > is a build with a few Southern African additions. So the underlying core > build would be from mid-February 2016 (2.20). > > > > None of those additions would affect or cause the above issue, though. > > > > David - have you tried to experiment with screen resolution, to see if it > appears the same way with a different resolution (but same user)? > > > > regards > > Calle > > > > On 11 August 2016 at 09:06, David Itana <dit...@hispna.org> wrote: > > Dear DHIS community, > > > > We are using DHIS2 (Version: 2.20, Build revision: 16795, Build date: > 2016-02-23 09:07). We recently started experiencing a problem when using > chrome or Firefox where words appears overlapping as depicted in the > picture below. The Apps and Profile icons and texts as well as the list of > apps appears normal. > > > > > > This is not affecting all users, but affects specific users in different > user groups including superusers. Testing using the same computer proves > that the affected user will see scrambled/overlapping texts but when the > other user logs in, the system appears normal, that made us to rule out the > cache issues as the same machine reacts differently when used by different > users. > > > > We also verified the language settings both under profiles settings as > well as under the user app. They are all set to English as the interface > language and database language is s
Re: [Dhis2-users] [Dhis2-devs] Overlapping text in DHIS2 UI
Hi Just a clarification note: the build number seems "abnormal" because this is a build with a few Southern African additions. So the underlying core build would be from mid-February 2016 (2.20). None of those additions would affect or cause the above issue, though. David - have you tried to experiment with screen resolution, to see if it appears the same way with a different resolution (but same user)? regards Calle On 11 August 2016 at 09:06, David Itana <dit...@hispna.org> wrote: > Dear DHIS community, > > > > We are using DHIS2 (Version: 2.20, Build revision: 16795, Build date: > 2016-02-23 09:07). We recently started experiencing a problem when using > chrome or Firefox where words appears overlapping as depicted in the > picture below. The Apps and Profile icons and texts as well as the list of > apps appears normal. > > > > > > This is not affecting all users, but affects specific users in different > user groups including superusers. Testing using the same computer proves > that the affected user will see scrambled/overlapping texts but when the > other user logs in, the system appears normal, that made us to rule out the > cache issues as the same machine reacts differently when used by different > users. > > > > We also verified the language settings both under profiles settings as > well as under the user app. They are all set to English as the interface > language and database language is set to “use database locale/no > translation”. > > > > Again this is only affecting Chrome and Firefox, however internet explorer > is displaying all text normal. > > > > Are the any settings that we perhaps missed or what could be the cause? > > > > Kind regards, > > > > David > > > > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] signing up for google earth engine for dhis
Lars, Your step-by-step description don't fit what I get for Step 3 onwards - I see not "Create account' etc, just "Create project" and then it deviates completely from there. Regards calle On 6 August 2016 at 19:32, Lars Helge Øverland <l...@dhis2.org> wrote: > Hi all, > > in DHIS 2.24 we introduced GIS layers based on Google Earth Engine > <https://earthengine.google.com/>. This platform is still invitation-only > so there are a few steps to go through in order to enable it. I have > written a tutorial here which explains the steps: > > <http://goog_1295401050> > https://www.dhis2.org/signing-up-for-google-earth-engine-for-dhis2 > > > If you are getting in trouble we are of course willing to help. > > > best regards, > > Lars > > > > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > l...@dhis2.org > http://www.dhis2.org <https://www.dhis2.org/> > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Capture coordinates
Hi, Easiest method if you are talking about POINT co-ordinates (e.g. health facilities): 1. Create a comma-delimited list with facility name (exactly as in the DHIS), Latitude and Longitude. Coordinates must be ISO standard using datum WGS-84 (the same datum used by all Global Navigation Systems like GPS, and used by all modern maps). 2. For point co-ordinates, DHIS supports six decimals (equivalent to around 10cm precision) - that is the standard number of decimal for point data in most systems. 3. Whether you create the comma-delimited file in Excel, a text editor etc does not matter - use what's convenient for you. Make sure the facility name column is called "NAME" 4. There is no need to generalise point coordinates the same way you might do it for high-precision line or polygon (area) features, so when you are ready with the file either convert it to GML format using the (cumbersome) method described in the DHIS2 manual, OR import it into a GIS package like QGIS. 5. After creating the GML file, import it. Any mis-spelled name will show up during the import as having failed. regards Calle 2016-05-20 15:35 GMT+02:00 papa alioune Sokhna <sokhnap...@gmail.com>: > Hi everybody, > how to captures coordinate in DHIS2. > -- > Papa Alioune SOKHNA > *Informaticien * > Spécialité: développement d'application web, mobile et logiciels surs > Tel: +221 77 442 16 22 > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] dhis version 2.23 is released
Alex, I presume you will assess what parts of the current custom IDSR2 code that now can be replaced by standard tracker functionality - don't forget to share :-) Regards calle On 25 April 2016 at 15:28, Calle Hedberg <calle.hedb...@gmail.com> wrote: > Knut, > > That makes no sense - nobody does area calculations on lat/long (i.e. the > geographical graticule), you must first project the lat/long data into a > suitable projection and then calculate areas. > > For smaller areas (e.g. small and medium-sized countries) you would > typically use UTM (Transverse Mercator), but that is completely > inappropriate for larger areas. Just think about it: on a standard global > Mercator projection, Greenland looks twice as big as India - whereas the > reality is that India has a 50% larger area than Greenland. > > Besides, if you do calculate areas using lat/long and decimal degrees, the > "result" will be squared decimal degrees - which means nothing to anybody. > > Regards > Calle > > > On 25 April 2016 at 15:16, Knut Staring <knu...@gmail.com> wrote: > >> AFAIK all coordinates are lat/lon, so I suppose that also goes for the >> area calculation. >> >> Knut >> >> On Mon, Apr 25, 2016 at 3:05 PM, Calle Hedberg <calle.hedb...@gmail.com> >> wrote: >> >>> Lars, >>> >>> Thanks - it is downloading >>> >>> One initial question re GIS area calculations: what projection is used >>> for the calculation? >>> >>> regards >>> calle >>> >>> On 25 April 2016 at 14:53, Lars Helge Øverland <l...@dhis2.org> wrote: >>> >>>> >>>> >>>> On Mon, Apr 25, 2016 at 2:39 PM, Calle Hedberg <calle.hedb...@gmail.com >>>> > wrote: >>>> >>>>> Hi, >>>>> >>>>> Good stuff - will go through it in more detail, but please note that >>>>> trying to download the 2.23 demo database gives an error (file not found). >>>>> >>>>> regards >>>>> Calle >>>>> >>>> >>>> >>>> Right - fixed now. >>>> >>>> >>>> -- >>>> Lars Helge Øverland >>>> Lead developer, DHIS 2 >>>> University of Oslo >>>> Skype: larshelgeoverland >>>> http://www.dhis2.org <https://www.dhis2.org/> >>>> >>>> >>> >>> >>> -- >>> >>> *** >>> >>> Calle Hedberg >>> >>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA >>> >>> Tel/fax (home): +27-21-685-6472 >>> >>> Cell: +27-82-853-5352 >>> >>> Iridium SatPhone: +8816-315-19119 >>> >>> Email: calle.hedb...@gmail.com >>> >>> Skype: calle_hedberg >>> >>> *** >>> >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Knut Staring >> Dept. of Informatics, University of Oslo >> Norway: +4791880522 >> Skype: knutstar >> http://dhis2.org >> > > > > -- > > *** > > Calle Hedberg > > 46D Alma Road, 7700 Rosebank, SOUTH AFRICA > > Tel/fax (home): +27-21-685-6472 > > Cell: +27-82-853-5352 > > Iridium SatPhone: +8816-315-19119 > > Email: calle.hedb...@gmail.com > > Skype: calle_hedberg > > *** > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] dhis version 2.23 is released
Knut, That makes no sense - nobody does area calculations on lat/long (i.e. the geographical graticule), you must first project the lat/long data into a suitable projection and then calculate areas. For smaller areas (e.g. small and medium-sized countries) you would typically use UTM (Transverse Mercator), but that is completely inappropriate for larger areas. Just think about it: on a standard global Mercator projection, Greenland looks twice as big as India - whereas the reality is that India has a 50% larger area than Greenland. Besides, if you do calculate areas using lat/long and decimal degrees, the "result" will be squared decimal degrees - which means nothing to anybody. Regards Calle On 25 April 2016 at 15:16, Knut Staring <knu...@gmail.com> wrote: > AFAIK all coordinates are lat/lon, so I suppose that also goes for the > area calculation. > > Knut > > On Mon, Apr 25, 2016 at 3:05 PM, Calle Hedberg <calle.hedb...@gmail.com> > wrote: > >> Lars, >> >> Thanks - it is downloading >> >> One initial question re GIS area calculations: what projection is used >> for the calculation? >> >> regards >> calle >> >> On 25 April 2016 at 14:53, Lars Helge Øverland <l...@dhis2.org> wrote: >> >>> >>> >>> On Mon, Apr 25, 2016 at 2:39 PM, Calle Hedberg <calle.hedb...@gmail.com> >>> wrote: >>> >>>> Hi, >>>> >>>> Good stuff - will go through it in more detail, but please note that >>>> trying to download the 2.23 demo database gives an error (file not found). >>>> >>>> regards >>>> Calle >>>> >>> >>> >>> Right - fixed now. >>> >>> >>> -- >>> Lars Helge Øverland >>> Lead developer, DHIS 2 >>> University of Oslo >>> Skype: larshelgeoverland >>> http://www.dhis2.org <https://www.dhis2.org/> >>> >>> >> >> >> -- >> >> *** >> >> Calle Hedberg >> >> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA >> >> Tel/fax (home): +27-21-685-6472 >> >> Cell: +27-82-853-5352 >> >> Iridium SatPhone: +8816-315-19119 >> >> Email: calle.hedb...@gmail.com >> >> Skype: calle_hedberg >> >> *** >> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > Norway: +4791880522 > Skype: knutstar > http://dhis2.org > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] dhis version 2.23 is released
Lars, Thanks - it is downloading One initial question re GIS area calculations: what projection is used for the calculation? regards calle On 25 April 2016 at 14:53, Lars Helge Øverland <l...@dhis2.org> wrote: > > > On Mon, Apr 25, 2016 at 2:39 PM, Calle Hedberg <calle.hedb...@gmail.com> > wrote: > >> Hi, >> >> Good stuff - will go through it in more detail, but please note that >> trying to download the 2.23 demo database gives an error (file not found). >> >> regards >> Calle >> > > > Right - fixed now. > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > http://www.dhis2.org <https://www.dhis2.org/> > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] dhis version 2.23 is released
> store, a new key-value JSON data store has been introduced. Unlike the > general-purpose data store which is shared between all users, the new > user-based data store is linked to the currently logged in user. Only the > user linked to the data store can add, edit, update or delete data in their > store. This is useful for apps which need to store personalized data for a > user, for example user-defined settings. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s67.html> > > > > Encryption of data store values: Data stored in either the > general-purpose data store or the user-based data store can optionally be > encrypted upon creation. Existing data and data initially created as > unencrypted can only be encrypted by deleting the data and creating it over > with encryption enabled. Values will be encrypted when a encrypt=true > query parameter is supplied. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s66.html> > > > > Data set report: Added data set reports to the web api. The resource can > be found at /api/dataSetReport and returns a HTML report based on your > input parameters. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s34.html> > > > > User setting Web API changes: The user setting web api now allows > fetching setting with or without using the fallback to system setting > mechanism. That means a user setting will return 'null' if no value has > been set for the user setting in question if required, but will return the > value of the system setting by default if the user setting has not been > assigned a value. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s46.html> > > > > Support for identifier schemes in aggregate analysis requests: The > analytics web api resource now has support for other identifiers schemes > than UID. The resource now accepts a new parameter inputIdScheme which > determines how identifiers are handled. Currently both UID and CODE can be > used as identifiers. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s32.html#d0e7656> > > > > Ordering for event and eventRow endpoints: Added parameter order to > /api/events and /api/events/eventRows so result can be ordered on any > property, either ascending or descending. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s17.html#d5e2202> > > > > Average aggregation in analytics: Analytics web API now supports for an > AVERAGE aggregation type. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s32.html#d0e7656> > > > > Support for coordinate clustering: Event analytics now has support for > coordinate clustering through a new /api/analytics/events/cluster > resource. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s33.html#d0e8664> > > > > Usage statistics endpoint: Using the new /api/dataStatistics endpoint, > you can now create event views and fetch data statistics between two dates > and by different intervals. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s35.html> > > > > User credentials endpoint: A new endpoint /api/userCredentials has been > added. This will enable lookup of users by username through a > database-optimized search. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s43.html#d5e5508> > > > > CSV import of translations: Translations can be imported in CSV metadata > format, both through the Web API and the user interface.. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s11.html#d5e1191> > > > > Clearing analytics tables: The /api/maintenance resource now supports > dropping all analytics tables from the database. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s38.html> > > > Metadata exchange: The metadata import-export resource has been > completely rewritten and offers better performance and stability. We are > gradually introducing Web API versioning and the new metadata resource can > be found at /api/23/metadata. The current metadata resource will be > phased out in 2.26. We encourage app developers to upgrade their apps. > > > Docs > <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s13.html#d5e1405> > > > > RELEASE INFO > > > > > You can download Live package, WAR file, sample data and source code here: > > https://www.dhis2.org/downloads > > > You will find documentation and Javadocs here: > > https://www.dhis2.org/documentation > > > You can read the upgrade notes and find upgrade script here: > > https://www.dhis2.org/223-upgrade > > > The demo application can be found here: > > https://play.dhis2.org/demo > > > Full list of features can be found at the Launchpad page: > > https://launchpad.net/dhis2/+milestone/2.23 > > > Instructions for signing up for the DHIS 2 mailing lists here: > > https://www.dhis2.org/contact > > > > Enjoy the new features. > > > best regards, > > > the DHIS 2 development team > > > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] 2.23 Metadata importer rewrite and dryRuns
Morten, Dropping the dry run is OK if, and I stress if, the import process itself becomes more transparent and step-wise. Basically this means 1. Display new records coming in, with the ability to remove all or some from import 2. Display updated records coming in and the equivalent existing records, with the ability to remove all or some from import/updating. The fundamental problem with DHIS2 imports are that they are "black boxes", you cannot see what's happening until after it's done. Without even the dry run, your only "Safety net" is to back up the whole database just before importing - which is tricky to do in a production environment when manager A imports data while user B,C,D, and E are capturing data directly. Regards Calle On 2 February 2016 at 10:15, Morten Olav Hansen <morte...@gmail.com> wrote: > Hi everyone > > I'm currently in the process of re-writing our DXF2 metadata importer, and > was wondering if anyone is actually using the dryRun option? its adds quite > a bit of complexity to the code, so it will be added only to the new > importer if people are actually using it for imports > > -- > Morten > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Changed CSV-Format for OrgUnits
Hi,
1.
The header row is optional - it will automatically be discarded if it's
there. CSV import follows a pre-defined list of columns - you can drop
anything at the end, but must include extra commas if you have blank
columns in between relevant columns.
2. All UIDs must be 11 characters, and starting with a letter (NOT a digit).
Regards
Calle
On 17 December 2015 at 08:06, Knut Staring <knu...@gmail.com> wrote:
> I think header is completely optional (so docs should reflect that).
>
> On Thu, Dec 17, 2015 at 6:28 AM, Uwe Wahser <u...@wahser.de> wrote:
>
>> update inline
>> > Uwe Wahser <u...@wahser.de> hat am 17. Dezember 2015 um 06:23
>> geschrieben:
>> >
>> >
>> > Dear all,
>> >
>> > according to a previous post on the users list there have obviously been
>> > changes
>> > in the CSV-format for importing OrgUnits. Some have been documented,
>> others
>> > not
>> > (or might be bugs):
>> >
>> > - feature format seems to be mandatory now. I don't know whether that
>> makes
>> > sense, if it does, please indicate that in the docs, too.
>> > - If you decide to change the docs on that, please also add a column
>> with the
>> > technical names to be included in the header line of the csv - the
>> names in
>> > the
>> > example differ from the names in the format specification. (or indicate,
>> > whether
>> > the header line is optional)
>> > - the import summary records a funny error message. Don't know whether
>> it's
>> > new,
>> > but it seems to be wrong: Validation Violations:
>> > [ValidationViolation{property='id', message='Allowed range for length
>> [11,
>> > 11],
>> > length is 7', value=NAIROBI}]
>> UPDATE: only uid's >= 11char were imported - must be a bug
>> >
>> > I could have posted this as bug-report, but I wasn't sure, whether
>> those are
>> > bugs or features ...
>> >
>> > Regards,
>> >
>> > Uwe
>> >
>> > ___
>> > Mailing list: https://launchpad.net/~dhis2-users
>> > Post to : dhis2-users@lists.launchpad.net
>> > Unsubscribe : https://launchpad.net/~dhis2-users
>> > More help : https://help.launchpad.net/ListHelp
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
>
--
***
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19119
Email: calle.hedb...@gmail.com
Skype: calle_hedberg
***
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] A way to exclude current week
Raheel, The dev team is working on a more generic fix for this in 2.21 - it will be possible to specify an "anchor period/date" which will determine all the other relative reporting periods. Seems it will only be available in 2.21, not 2.20 or earlier. Regards Calle On 15 September 2015 at 20:06, Raheel Ayaz <raheela...@gmail.com> wrote: > Dear all, > > In pivot table and data visualizer of DHIS2 when a table or a graph is > generated for last four weeks then why current week is included in the > table or graph. Is a way to exclude current week from the report to have > the output data for last four weeks. > > Same query is applicable to monthly or quarterly selection as well. > > Best regards, > Raheel > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] data mart deprecation - 2.21
Paralytics?? On 27 August 2015 at 09:35, Hannan Khan hann...@gmail.com wrote: In Bangladesh we are not using Data Mart; instead we are using paralytics. So no problem from our end. Regards Hannan Khan HISP Bangladesh On Wed, Aug 26, 2015 at 5:27 PM, Lars Helge Øverland larshe...@gmail.com wrote: Hi, we are thinking of removing the data mart functionality in DHIS 2. This refers to the ability to populate the aggregateddatavalue and aggregatedindicatorvalue tables with pre-aggregated data. The data mart is no longer in use by DHIS 2. There might be third-party report tools out there that connects directly to the data mart tables. We recommend that you connect reporting tools to the analytics web api https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s26.html for the sake of performance, accessibility and security. If you need to connect with JDBC it is possible to create a SQL view to combine all analytics partitions and perform aggregation using group by statements. If we do not hear strong objections within a week we will remove data mart for version 2.21. regards, Lars -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype: larshelgeoverland http://www.dhis2.org https://www.dhis2.org ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19274 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Need help in Program Rules
Hi
Strange syntax in that expression: Less than 24 hours is the same as
#{age}23 ??? I would have thought it would be #{age} =23 ??
Regards
Calle
On 17 August 2015 at 12:49, Neeraj Gupta neeraj.h...@gmail.com wrote:
Thanks Markus.
On Mon, Aug 17, 2015 at 1:37 PM, Markus Bekken markus.bek...@gmail.com
wrote:
Hi Neeraj.
This kind of cross validation rules is half way supported already, and
the full support is right around the corner. The program rule can be
created in the editor, it is being run - but how to display the error
message in the UI is still under discussion. Keep an eye out in release
notes 2.21!
To construct the cross validation you want you would have to make one
rule for each of your options. For ex. one rule that validates that if
'Hours' is selected, age must be below 24, and another for 'Days'.
See the rule created in the editor:
17. aug. 2015 kl. 09.38 skrev Neeraj Gupta neeraj.h...@gmail.com:
Hello All,
I am using DHIS version 2.20 build revision 19691.
I am having a doubt in Program rules.
We have a case where
Data element 'Age Type' has options i.e. *Hours/Days/Weeks/Months/Years*
Now if the user is selecting 'Age type' as *Hours *then another data
element 'Age' should accept value between *0 to 23*, application should
not accept any value more that 23 in case of *Hours *'Age type'.
Similarly, If 'Age type' is *Days *then it should not accept more that *6
*for 'Age' data element.
Can we add these kind of program rules?
Can some one please guide?
--
Thanks,
Neeraj Gupta
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-d...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
--
Thanks,
Neeraj Gupta
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-d...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
--
***
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedb...@gmail.com
Skype: calle_hedberg
***
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] dhis version 2.20 is released
upgrade script here: https://www.dhis2.org/220-upgrade The demo application can be found here: https://apps.dhis2.org/demo Full list of features can be found at the Launchpad page: https://launchpad.net/dhis2/+milestone/2.20 Instructions for signing up for the DHIS 2 mailing lists here: https://www.dhis2.org/contact best regards, the DHIS 2 development team ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19274 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max
Lars, By the way - last week I saw that the bug related to OrgUnit counts in indicators is still there. I checked the Sierra Leone demo too, and it's the same - integrity checks are still showing org-unit-do not exist etc. Is this an indicator bug or an integrity check bug? Regards Calle On 3 May 2015 at 21:29, Calle Hedberg calle.hedb...@gmail.com wrote: Lars, Excellent - thanks for that. Two years is a reasonable default value - we've always used 18 months as the default in 1.4, so almost the same. I would nevertheless argue that (a) user-defined period, stdev value, and possibly average/median parameters should ideally be specified on a per data element basis; (b) adding the attribute option combo to the mix is probably required to cater for instances where data is captured for e.g. multiple collaborating NGOs; (c) tools enabling the specification of said parameters for larger groups of data elements will make it easier to manage. (d) a cherry on top would be the ability to adjust for typical seasonal fluctuations. I will try to write a blue-print for something like the above, not a critical need, but a positive step. Regards Calle On 3 May 2015 at 14:12, Lars Helge Øverland larshe...@gmail.com wrote: Hi Calle, I agree it makes sense to have a from date for the data values to include in the std dev and average calculation. I have changed it so it now includes data 2 years before the start date of the validation analysis period. I also helps on performance of the validation process. regards, Lars On Mon, Apr 20, 2015 at 5:02 PM, Calle Hedberg calle.hedb...@gmail.com wrote: 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. We have used the normal distribution like this in DHIS 1.x for around 17 years, and it fits the majority of data elements. In general, this distribution model handles random outbreaks and disruptions reasonably well, since the impact of such outliers are dampened. Data elements representing conditions or services with strong seasonal variation do not fit so well, and some very particular issues like Male condoms distributed tend to vary so much that the min/max is generally disregarded (outliers here also matter a lot less - when you distribute 1-2 billion condoms annually, an error of a few thousand does not matter). In DHIS 1.4 there is also a function for setting absolute min-max values - most typically used for data elements where e.g. only 0 and 1 are valid values. For such cases, statistically calculating min-max is obviously irrelevant. I don't like the use of ALL available time periods, though, since a large number of health facilities will see significant changes in their patient mix and patient numbers over let us say a 10 year period. We have found that 12-18 months provide a good compromise. So there are still some room for improvement. Regards Calle On 20 April 2015 at 16:15, Jason Pickering jason.p.picker...@gmail.com wrote: 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 distribution is. https://www.dhis2.org/doc/snapshot/en/developer/html/apas06.html Anyway, support for import via the API would be good. Regards, Jason On Mon, Apr 20, 2015, 16:06 Lars Helge Øverland larshe...@gmail.com wrote: 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 deviations or not, rather if we should support additional _distributions_ to better handle different kinds of data. We currently use the normal distribution http://en.wikipedia.org/wiki/Normal_distribution. Rodolfo - supporting min-max in the Web API is a good idea to allow for third-party tools - feel free to write a blueprint. regards, Lars -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19274 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19274 Email: calle.hedb...@gmail.com Skype
Re: [Dhis2-users] [Dhis2-devs] Generating Min/ Max
Lars, Excellent - thanks for that. Two years is a reasonable default value - we've always used 18 months as the default in 1.4, so almost the same. I would nevertheless argue that (a) user-defined period, stdev value, and possibly average/median parameters should ideally be specified on a per data element basis; (b) adding the attribute option combo to the mix is probably required to cater for instances where data is captured for e.g. multiple collaborating NGOs; (c) tools enabling the specification of said parameters for larger groups of data elements will make it easier to manage. (d) a cherry on top would be the ability to adjust for typical seasonal fluctuations. I will try to write a blue-print for something like the above, not a critical need, but a positive step. Regards Calle On 3 May 2015 at 14:12, Lars Helge Øverland larshe...@gmail.com wrote: Hi Calle, I agree it makes sense to have a from date for the data values to include in the std dev and average calculation. I have changed it so it now includes data 2 years before the start date of the validation analysis period. I also helps on performance of the validation process. regards, Lars On Mon, Apr 20, 2015 at 5:02 PM, Calle Hedberg calle.hedb...@gmail.com wrote: 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. We have used the normal distribution like this in DHIS 1.x for around 17 years, and it fits the majority of data elements. In general, this distribution model handles random outbreaks and disruptions reasonably well, since the impact of such outliers are dampened. Data elements representing conditions or services with strong seasonal variation do not fit so well, and some very particular issues like Male condoms distributed tend to vary so much that the min/max is generally disregarded (outliers here also matter a lot less - when you distribute 1-2 billion condoms annually, an error of a few thousand does not matter). In DHIS 1.4 there is also a function for setting absolute min-max values - most typically used for data elements where e.g. only 0 and 1 are valid values. For such cases, statistically calculating min-max is obviously irrelevant. I don't like the use of ALL available time periods, though, since a large number of health facilities will see significant changes in their patient mix and patient numbers over let us say a 10 year period. We have found that 12-18 months provide a good compromise. So there are still some room for improvement. Regards Calle On 20 April 2015 at 16:15, Jason Pickering jason.p.picker...@gmail.com wrote: 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 distribution is. https://www.dhis2.org/doc/snapshot/en/developer/html/apas06.html Anyway, support for import via the API would be good. Regards, Jason On Mon, Apr 20, 2015, 16:06 Lars Helge Øverland larshe...@gmail.com wrote: 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 deviations or not, rather if we should support additional _distributions_ to better handle different kinds of data. We currently use the normal distribution http://en.wikipedia.org/wiki/Normal_distribution. Rodolfo - supporting min-max in the Web API is a good idea to allow for third-party tools - feel free to write a blueprint. regards, Lars -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19274 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19274 Email: calle.hedb...@gmail.com Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
