Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
Hi Fatema I will try and have another look at this. -- Morten On Wed, Jun 17, 2015 at 4:45 PM, Uddin Fatema fatema...@gmail.com wrote: Dear Morten, Time zone error still remains in 2.18 and 2.19 version. but working fine in 2.17 and bellow version Time Zone (UTC+06:00) Dhaka (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi are giving same error. (UTC+06:30) Yangon (Rangoon)..do not showing that error. I change the time zone UTC+06.30 Yangon and update the resource table it was fine but inside period table a major change shows. id Startdate Enddate 1283308;3;2015-05-01;2015-05-31 1283335;3;2015-02-28;2015-03-30 1283334;3;2015-06-01;2015-06-30 1283336;3;2014-12-31;2015-01-30 1283337;3;2014-11-30;2014-12-30 1283338;3;2013-12-31;2014-01-30 1283339;3;2014-01-31;2014-02-27 1283340;3;2014-07-31;2014-08-30 1283341;3;2014-10-31;2014-11-29 1283342;3;2015-04-30;2015-05-30 1283343;3;2015-03-31;2015-04-29 Please resolve the bug and help us. Thanks in advance On Mon, Mar 23, 2015 at 2:12 PM, Morten Olav Hansen morte...@gmail.com wrote: Yes, this is a known bug. I'm still looking into it, it only happens with certain timezones, will let you know when it has been fixed. -- Morten On Mon, Mar 23, 2015 at 3:05 PM, Ola Hodne Titlestad ol...@ifi.uio.no wrote: Hi Fatema, This is not a database issue, but a bug that occurs when generating the period structure table on machines/servers using on of a few specific time zones. I think I commented on this issues on another email thread you started. Morten knows the details, but my quick fix advice is to change the system time zone to a zone that we know works, e.g. GMT. Ola On 20 Mar 2015 14:16, Alex Tumwesigye atumwesi...@gmail.com wrote: Dear Fatema, All looks good and no duplicates. The only odd stuff is this: Note the years (2063 and 2140) 811017,1,2063-03-11,2063-03-11 811018,1,2063-03-12,2063-03-12 811019,1,2063-03-13,2063-03-13 811020,1,2063-03-14,2063-03-14 811021,1,2063-03-15,2063-03-15 811022,1,2063-03-16,2063-03-16 811023,1,2063-03-17,2063-03-17 811024,1,2063-03-18,2063-03-18 811025,1,2063-03-19,2063-03-19 811026,1,2063-03-20,2063-03-20 811027,1,2063-03-21,2063-03-21 811028,1,2063-03-22,2063-03-22 811029,1,2063-03-23,2063-03-23 811030,1,2063-03-24,2063-03-24 811031,1,2063-03-25,2063-03-25 1555,1,2140-09-03,2140-09-03 1554,1,2140-09-04,2140-09-04 1550,1,2140-09-05,2140-09-05 1551,1,2140-09-06,2140-09-06 1552,1,2140-09-07,2140-09-07 1553,1,2140-09-08,2140-09-08 can you try this query on period table? delete from period where enddate is null or startdate is null; After running this query, go to resource table and regenerate them. Thanks. Alex On Fri, Mar 20, 2015 at 3:52 PM, Uddin Fatema fatema...@gmail.com wrote: Dear Alex, I have run this query and get two result. select enddate,startdate,periodtypeid from period where enddate = '2009-12-31' or startdate = '2009-12-31' Result is 2009-12-31;2009-12-01;3 2009-12-31;2009-01-01;6 here i attached the file too. Thanks a lot On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye atumwesi...@gmail.com wrote: Fatema, Can you dump for me the enddate, startdate and periodtype from period table for that date '2009-12-31' I need to see the output of select enddate,startdate,periodtypeid from period where enddate like '2009-12-31' or startdate like '2009-12-31' Thanks. Alex On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Did you verify that all three constraints are in place on the period table? If they are and you are 100% sure there are no duplicates, then I don't know - I've had similar error messages a couple of times, but removing the duplicates and re-inserting the constraint have always sorted it out. Clear cache (DHIS and browser), empty resource tables, re-start tomcat - I'm not aware of any other tricks Regards Calle On 20 March 2015 at 14:15, Uddin Fatema fatema...@gmail.com wrote: Thanks Calle, I have already checked all part and this period is daily, so startdate and enddate is same 2009-12-31 However, my problem is remains same What can i do. On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Fatema, note that 2009-12-31 looks like an ENDdate, not a startdate. Regards Calle On 20 March 2015 at 14:09, Uddin Fatema fatema...@gmail.com wrote: Thanks Bharath Anna and Alex. Actually i checked period table with this( 2009-12-31) startdate and there is no duplicate period with same startdate. Additionally, for test purpose i deleted this period from period table and from other related table with this periodid. Several time restart the tomcat and clear the cash. Although, problem remain same. Process failed: PreparedStatementCallback; SQL [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint
Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
Thank you Morten, I am eagerly waiting for it. On Thu, Jun 18, 2015 at 7:41 AM, Morten Olav Hansen morte...@gmail.com wrote: Hi Fatema I will try and have another look at this. -- Morten On Wed, Jun 17, 2015 at 4:45 PM, Uddin Fatema fatema...@gmail.com wrote: Dear Morten, Time zone error still remains in 2.18 and 2.19 version. but working fine in 2.17 and bellow version Time Zone (UTC+06:00) Dhaka (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi are giving same error. (UTC+06:30) Yangon (Rangoon)..do not showing that error. I change the time zone UTC+06.30 Yangon and update the resource table it was fine but inside period table a major change shows. id Startdate Enddate 1283308;3;2015-05-01;2015-05-31 1283335;3;2015-02-28;2015-03-30 1283334;3;2015-06-01;2015-06-30 1283336;3;2014-12-31;2015-01-30 1283337;3;2014-11-30;2014-12-30 1283338;3;2013-12-31;2014-01-30 1283339;3;2014-01-31;2014-02-27 1283340;3;2014-07-31;2014-08-30 1283341;3;2014-10-31;2014-11-29 1283342;3;2015-04-30;2015-05-30 1283343;3;2015-03-31;2015-04-29 Please resolve the bug and help us. Thanks in advance On Mon, Mar 23, 2015 at 2:12 PM, Morten Olav Hansen morte...@gmail.com wrote: Yes, this is a known bug. I'm still looking into it, it only happens with certain timezones, will let you know when it has been fixed. -- Morten On Mon, Mar 23, 2015 at 3:05 PM, Ola Hodne Titlestad ol...@ifi.uio.no wrote: Hi Fatema, This is not a database issue, but a bug that occurs when generating the period structure table on machines/servers using on of a few specific time zones. I think I commented on this issues on another email thread you started. Morten knows the details, but my quick fix advice is to change the system time zone to a zone that we know works, e.g. GMT. Ola On 20 Mar 2015 14:16, Alex Tumwesigye atumwesi...@gmail.com wrote: Dear Fatema, All looks good and no duplicates. The only odd stuff is this: Note the years (2063 and 2140) 811017,1,2063-03-11,2063-03-11 811018,1,2063-03-12,2063-03-12 811019,1,2063-03-13,2063-03-13 811020,1,2063-03-14,2063-03-14 811021,1,2063-03-15,2063-03-15 811022,1,2063-03-16,2063-03-16 811023,1,2063-03-17,2063-03-17 811024,1,2063-03-18,2063-03-18 811025,1,2063-03-19,2063-03-19 811026,1,2063-03-20,2063-03-20 811027,1,2063-03-21,2063-03-21 811028,1,2063-03-22,2063-03-22 811029,1,2063-03-23,2063-03-23 811030,1,2063-03-24,2063-03-24 811031,1,2063-03-25,2063-03-25 1555,1,2140-09-03,2140-09-03 1554,1,2140-09-04,2140-09-04 1550,1,2140-09-05,2140-09-05 1551,1,2140-09-06,2140-09-06 1552,1,2140-09-07,2140-09-07 1553,1,2140-09-08,2140-09-08 can you try this query on period table? delete from period where enddate is null or startdate is null; After running this query, go to resource table and regenerate them. Thanks. Alex On Fri, Mar 20, 2015 at 3:52 PM, Uddin Fatema fatema...@gmail.com wrote: Dear Alex, I have run this query and get two result. select enddate,startdate,periodtypeid from period where enddate = '2009-12-31' or startdate = '2009-12-31' Result is 2009-12-31;2009-12-01;3 2009-12-31;2009-01-01;6 here i attached the file too. Thanks a lot On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye atumwesi...@gmail.com wrote: Fatema, Can you dump for me the enddate, startdate and periodtype from period table for that date '2009-12-31' I need to see the output of select enddate,startdate,periodtypeid from period where enddate like '2009-12-31' or startdate like '2009-12-31' Thanks. Alex On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Did you verify that all three constraints are in place on the period table? If they are and you are 100% sure there are no duplicates, then I don't know - I've had similar error messages a couple of times, but removing the duplicates and re-inserting the constraint have always sorted it out. Clear cache (DHIS and browser), empty resource tables, re-start tomcat - I'm not aware of any other tricks Regards Calle On 20 March 2015 at 14:15, Uddin Fatema fatema...@gmail.com wrote: Thanks Calle, I have already checked all part and this period is daily, so startdate and enddate is same 2009-12-31 However, my problem is remains same What can i do. On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Fatema, note that 2009-12-31 looks like an ENDdate, not a startdate. Regards Calle On 20 March 2015 at 14:09, Uddin Fatema fatema...@gmail.com wrote: Thanks Bharath Anna and Alex. Actually i checked period table with this( 2009-12-31) startdate and there is no duplicate period with same startdate. Additionally, for test purpose i deleted this period from period table and from other related table with this periodid. Several time restart the tomcat and clear the cash. Although, problem remain same. Process failed: PreparedStatementCallback;
Re: [Dhis2-users] DHIS2 mobile forms and GPS
Hi, is this regarding aggregate or tracker? For the android apps custom forms do not work, but data sets and program stages are rendered based on the data elements assigned to them. On Wed, Jun 10, 2015 at 10:33 PM, Yoav Rappaport yrappap...@internationalmedicalcorps.org wrote: I would like to find out where to find information regarding the creation of mobile forms. I also want to find out if the mobile form can capture the GPS (lat/lon) from the android device. I have an external GPS working on the Android. Also the forms will be offline most of the time and will not have wifi or cellular connection. Forms will be submitted once we get to wifi. ___ 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
Re: [Dhis2-users] DHIS2 mobile forms and GPS
Hi Simen: Thank you for the response. I believe that this would apply for Tracker https://www.dhis2.org/individual-data-records Do you have information how to set up mobile forms that would capture the location as well as the attributes. Is it possible to have this done in an offline format and then synch to the database when connected? Thank you in advance. Yoav From: Simen Skogly Russnes [mailto:simen.s.russ...@gmail.com] Sent: Wednesday, June 17, 2015 1:05 PM To: Yoav Rappaport Cc: dhis2-users@lists.launchpad.net; Araz Abishov Subject: Re: [Dhis2-users] DHIS2 mobile forms and GPS Hi, is this regarding aggregate or tracker? For the android apps custom forms do not work, but data sets and program stages are rendered based on the data elements assigned to them. On Wed, Jun 10, 2015 at 10:33 PM, Yoav Rappaport yrappap...@internationalmedicalcorps.orgmailto:yrappap...@internationalmedicalcorps.org wrote: I would like to find out where to find information regarding the creation of mobile forms. I also want to find out if the mobile form can capture the GPS (lat/lon) from the android device. I have an external GPS working on the Android. Also the forms will be offline most of the time and will not have wifi or cellular connection. Forms will be submitted once we get to wifi. ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.netmailto: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
Re: [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.
Okay thanks. Could you let me know - what is the data element value type and aggregation operator for the data element for which you get this result? - is it possible for you to privately share a login and a link to a favorite? regards, Lars On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatema...@gmail.com wrote: Yes Lars i found same error in 2.18 too. Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic. And still I found same error which is described me and Nayeem Al Miftah. Thanks On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mift...@gmail.com wrote: Dear Lars There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days. It has happened as the analytic table calculate the data as Ms. Fatema has described. Nayeem Al Mifthah HMIS Consultant Management Information System Directorate General of Health Services (DGHS), Bangladesh Supported by: UNICEF-Bangladesh Email: n.mift...@gmail.com | nay...@mis.dghs.gov.bd Cell:+8801914030574 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshe...@gmail.com wrote: Hi Fatema, do you think you could explain a bit more about the data elements and calculation? Do you think you cold try with 2.18 / 2.19 ? regards, Lars On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com wrote: Dear All, Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too Here i attach screen short of Pivote Table Analysis and Data Entry Screen In pivote table value shows = 51.7 but originally dataentry screen shows = 50 Calculation it is dividing daysxvalue / 30 = 50* 31/30 = 51.7 But it should do daysxvalue/daysno = 50*31/31 =50 Please have a look on it. Thanks Fatema --- Forwarded message -- rom: Uddin Fatema fatema...@gmail.com Date: Tue, May 5, 2015 at 5:56 PM Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS. To: Jan Henrik Øverland janhenrik.overl...@gmail.com Dear Jan, DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table. The problem is in analytics table it store daysxvalue , daysno and value column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30 But it should do daysxvalue/daysno As a result in pivot table, data visualizer and gis mapping shows wrong data. Could you please solved it additionally, can you please tell me in source code in which file i have to change. Thanks a lot in advance. Regards, *Fatema Uddin* Technical Advisor (HIS)-Support to the Health Sector Program II Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH German House House 10/A-2, Road 90 Gulshan 2, Dhaka 1212, Bangladesh T +880 9666701000 F +880 28823099 M +880 19 6206 4721 I www.giz.de https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f -- Regards, *Fatema Uddin* Technical Advisor (HIS)-Support to the Health Sector Program II Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH German House House 10/A-2, Road 90 Gulshan 2, Dhaka 1212, Bangladesh T +880 9666701000 F +880 28823099 M +880 19 6206 4721 I www.giz.de https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f -- 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 -- Regards, *Fatema Uddin* Technical Advisor (HIS)-Support to the Health Sector Program II Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH German House House 10/A-2, Road 90 Gulshan 2, Dhaka 1212, Bangladesh T +880 9666701000 F +880 28823099 M +880 19 6206 4721 I www.giz.de https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype:
Re: [Dhis2-users] DHIS2 as LMIS
Dear all, I am interested in the topic and I can't read or speak French. Please can someone translate. Regards, Gerald On 17 Jun 2015 08:34, Ouango william williamoua...@yahoo.fr wrote: Bonjour Narodar, je vois que tu as des questions sur DHIS2, pour ce qui concerne tes questions, saches que DHIS2 est d'abord un outil de rapportage des données, il peut être utilisé pour le suivi des stocks de certains produits à travers son module tracker, mais ce n'est pas optimisé. Tu peux l'utiliser pour le suivi des produits traceurs par exemple mais pas d'une très grande quantité de produits, Pour ce qui concerne la gestion des médicaments (achat vente au client par exemple, transfert de stock, inventaire et ajustement de stock...), il est difficile de le faire à mon avis. L'alternative que tu as, c'est tout simplement l'utilisation de logiciels de gestions de stock des médicaments et la mise en place d'un pont qui permette de les mettre sur DHIS2 (Exemple gestion de stock = CHANNEL, Outil d'aide à la décision=DHIS2) et tu les relie de sorte à ce que les données de CHANNEL alimentent directement la base de données de DHIS2. Ainsi, tu verra la puissance de DHIS2. William N. D. OUANGO Analyste Programmeur DSITS (00226) 79 33 83 84 72 00 31 22 66 85 28 18 Le Mercredi 17 juin 2015 8h26, Ouango william williamoua...@yahoo.fr a écrit : Bonjour Narodar, je vois que tu as des questions sur DHIS2, pour ce qui concerne tes questions, saches que DHIS2 est d'abord un outil de rapportage des données, il peut être utilisé pour le suivi des stocks de certains produits à travers son module tracker, mais ce n'est pas optimisé. Tu peux l'utiliser pour le suivi des produits traceurs par exemple mais pas d'une très grande quantité de produits, Pour ce qui concerne la gestion des médicaments, il est difficile de le faire à mon avis. L'alternative que tu as, c'est tout simplement l'utilisation de logiciels de gestions de stock des médicaments et la mise en place d'un pont qui permette de les mettre sur DHIS2 (Exemple gestion de stock = CHANNEL, Outil d'aide à la décision=DHIS2) et tu les relie de sorte à ce que les données de CHANNEL alimentent directement la base de données de DHIS2. Ainsi, tu verra la puissance de DHIS2. William N. D. OUANGO Analyste Programmeur DSITS (00226) 79 33 83 84 72 00 31 22 66 85 28 18 Le Mardi 16 juin 2015 18h13, Aymar Narodar SOME naro...@gmail.com a écrit : Hi all, I've just want to know if somebody has an experience using DHIS2 as LMIS to manage heath products/commodities in a repository? regards, *Aymar* ___ 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 ___ 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: Default Registration option in Tracker Capture
Hi Muhammad, These are attributes. If you go to the programs/attributes app you will see where to find the attributes. Also if you select a program and choose edit you can see how the attributes have been added. You can find some more info here in the docs: https://www.dhis2.org/doc/snapshot/en/user/html/ch29s02.html#d5e5915 On Wed, Jun 17, 2015 at 2:49 PM, Muhammad Tahir mtag...@gmail.com wrote: Hi, On DHIS2 demo site - Tracker Capture When registering without selecting any program, it asks for FirstName, Last Name and National Identifier. But I am unable to locate, how is this configured, kindly share the details how can this be achieved? -- *Regards,* *Muhammad Tahir* ___ 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
Re: [Dhis2-users] [Dhis2-devs] DHIS2: Default Registration option in Tracker Capture
Hi Abyot, One more thing related to Manage attributes with no program, how to mark national identification as a mandatory field? On Wed, Jun 17, 2015 at 12:46 PM, Muhammad Tahir mtag...@gmail.com wrote: Thanks Abyot, Manage attributes with no program it is. Have you checked my latest email with subject Error in Registration? Can you help with that? On Wed, Jun 17, 2015 at 12:27 PM, Abyot Gizaw aby...@gmail.com wrote: Yes, you can control them by clicking Manage attributes with no program from the attributes page. On Wed, Jun 17, 2015 at 8:56 AM Shurajit Dutta shurajitdu...@gmail.com wrote: Hi Muhammad, These are attributes. If you go to the programs/attributes app you will see where to find the attributes. Also if you select a program and choose edit you can see how the attributes have been added. You can find some more info here in the docs: https://www.dhis2.org/doc/snapshot/en/user/html/ch29s02.html#d5e5915 On Wed, Jun 17, 2015 at 2:49 PM, Muhammad Tahir mtag...@gmail.com wrote: Hi, On DHIS2 demo site - Tracker Capture When registering without selecting any program, it asks for FirstName, Last Name and National Identifier. But I am unable to locate, how is this configured, kindly share the details how can this be achieved? -- *Regards,* *Muhammad Tahir* ___ 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 -- Thank you, Abyot -- *Regards,* *Muhammad Tahir* -- *Regards,* *Muhammad Tahir* ___ 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] DHIS2: Default Registration option in Tracker Capture
Hi, On DHIS2 demo site - Tracker Capture When registering without selecting any program, it asks for FirstName, Last Name and National Identifier. But I am unable to locate, how is this configured, kindly share the details how can this be achieved? -- *Regards,* *Muhammad Tahir* ___ 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 as LMIS
Bonjour Narodar, je vois que tu as des questions sur DHIS2, pour ce qui concerne tes questions, saches que DHIS2 est d'abord un outil de rapportage des données, il peut être utilisé pour le suivi des stocks de certains produits à travers son module tracker, mais ce n'est pas optimisé. Tu peux l'utiliser pour le suivi des produits traceurs par exemple mais pas d'une très grande quantité de produits,Pour ce qui concerne la gestion des médicaments (achat vente au client par exemple, transfert de stock, inventaire et ajustement de stock...), il est difficile de le faire à mon avis. L'alternative que tu as, c'est tout simplement l'utilisation de logiciels de gestions de stock des médicaments et la mise en place d'un pont qui permette de les mettre sur DHIS2 (Exemple gestion de stock = CHANNEL, Outil d'aide à la décision=DHIS2) et tu les relie de sorte à ce que les données de CHANNEL alimentent directement la base de données de DHIS2. Ainsi, tu verra la puissance de DHIS2. William N. D. OUANGOAnalyste Programmeur DSITS (00226) 79 33 83 84 72 00 31 22 66 85 28 18 Le Mercredi 17 juin 2015 8h26, Ouango william williamoua...@yahoo.fr a écrit : Bonjour Narodar, je vois que tu as des questions sur DHIS2, pour ce qui concerne tes questions, saches que DHIS2 est d'abord un outil de rapportage des données, il peut être utilisé pour le suivi des stocks de certains produits à travers son module tracker, mais ce n'est pas optimisé. Tu peux l'utiliser pour le suivi des produits traceurs par exemple mais pas d'une très grande quantité de produits,Pour ce qui concerne la gestion des médicaments, il est difficile de le faire à mon avis. L'alternative que tu as, c'est tout simplement l'utilisation de logiciels de gestions de stock des médicaments et la mise en place d'un pont qui permette de les mettre sur DHIS2 (Exemple gestion de stock = CHANNEL, Outil d'aide à la décision=DHIS2) et tu les relie de sorte à ce que les données de CHANNEL alimentent directement la base de données de DHIS2. Ainsi, tu verra la puissance de DHIS2. William N. D. OUANGOAnalyste Programmeur DSITS (00226) 79 33 83 84 72 00 31 22 66 85 28 18 Le Mardi 16 juin 2015 18h13, Aymar Narodar SOME naro...@gmail.com a écrit : Hi all, I've just want to know if somebody has an experience using DHIS2 as LMIS to manage heath products/commodities in a repository? regards, Aymar ___ 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
Re: [Dhis2-users] [Dhis2-devs] DHIS2: Default Registration option in Tracker Capture
Thanks Abyot, Manage attributes with no program it is. Have you checked my latest email with subject Error in Registration? Can you help with that? On Wed, Jun 17, 2015 at 12:27 PM, Abyot Gizaw aby...@gmail.com wrote: Yes, you can control them by clicking Manage attributes with no program from the attributes page. On Wed, Jun 17, 2015 at 8:56 AM Shurajit Dutta shurajitdu...@gmail.com wrote: Hi Muhammad, These are attributes. If you go to the programs/attributes app you will see where to find the attributes. Also if you select a program and choose edit you can see how the attributes have been added. You can find some more info here in the docs: https://www.dhis2.org/doc/snapshot/en/user/html/ch29s02.html#d5e5915 On Wed, Jun 17, 2015 at 2:49 PM, Muhammad Tahir mtag...@gmail.com wrote: Hi, On DHIS2 demo site - Tracker Capture When registering without selecting any program, it asks for FirstName, Last Name and National Identifier. But I am unable to locate, how is this configured, kindly share the details how can this be achieved? -- *Regards,* *Muhammad Tahir* ___ 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 -- Thank you, Abyot -- *Regards,* *Muhammad Tahir* ___ 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] DHIS2: Default Registration option in Tracker Capture
Yes, you can control them by clicking Manage attributes with no program from the attributes page. On Wed, Jun 17, 2015 at 8:56 AM Shurajit Dutta shurajitdu...@gmail.com wrote: Hi Muhammad, These are attributes. If you go to the programs/attributes app you will see where to find the attributes. Also if you select a program and choose edit you can see how the attributes have been added. You can find some more info here in the docs: https://www.dhis2.org/doc/snapshot/en/user/html/ch29s02.html#d5e5915 On Wed, Jun 17, 2015 at 2:49 PM, Muhammad Tahir mtag...@gmail.com wrote: Hi, On DHIS2 demo site - Tracker Capture When registering without selecting any program, it asks for FirstName, Last Name and National Identifier. But I am unable to locate, how is this configured, kindly share the details how can this be achieved? -- *Regards,* *Muhammad Tahir* ___ 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 -- Thank you, Abyot ___ 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 2.18, 2.17. 2.16 reporting Error. Please Help.
Yes Lars i found same error in 2.18 too. Actually I updated version in 2.18 in test server but still time zone error remains for (UTC+60 )Dhaka . You know that some time zone has time zone problem in resource table generation. So I Changes time zone UTC+6:30) Yaangoon) and update resource table and analytic. And still I found same error which is described me and Nayeem Al Miftah. Thanks On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mift...@gmail.com wrote: Dear Lars There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days. It has happened as the analytic table calculate the data as Ms. Fatema has described. Nayeem Al Mifthah HMIS Consultant Management Information System Directorate General of Health Services (DGHS), Bangladesh Supported by: UNICEF-Bangladesh Email: n.mift...@gmail.com | nay...@mis.dghs.gov.bd Cell:+8801914030574 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshe...@gmail.com wrote: Hi Fatema, do you think you could explain a bit more about the data elements and calculation? Do you think you cold try with 2.18 / 2.19 ? regards, Lars On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com wrote: Dear All, Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too Here i attach screen short of Pivote Table Analysis and Data Entry Screen In pivote table value shows = 51.7 but originally dataentry screen shows = 50 Calculation it is dividing daysxvalue / 30 = 50* 31/30 = 51.7 But it should do daysxvalue/daysno = 50*31/31 =50 Please have a look on it. Thanks Fatema --- Forwarded message -- rom: Uddin Fatema fatema...@gmail.com Date: Tue, May 5, 2015 at 5:56 PM Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS. To: Jan Henrik Øverland janhenrik.overl...@gmail.com Dear Jan, DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table. The problem is in analytics table it store daysxvalue , daysno and value column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30 But it should do daysxvalue/daysno As a result in pivot table, data visualizer and gis mapping shows wrong data. Could you please solved it additionally, can you please tell me in source code in which file i have to change. Thanks a lot in advance. Regards, *Fatema Uddin* Technical Advisor (HIS)-Support to the Health Sector Program II Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH German House House 10/A-2, Road 90 Gulshan 2, Dhaka 1212, Bangladesh T +880 9666701000 F +880 28823099 M +880 19 6206 4721 I www.giz.de https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f -- Regards, *Fatema Uddin* Technical Advisor (HIS)-Support to the Health Sector Program II Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH German House House 10/A-2, Road 90 Gulshan 2, Dhaka 1212, Bangladesh T +880 9666701000 F +880 28823099 M +880 19 6206 4721 I www.giz.de https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f -- 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 -- Regards, *Fatema Uddin* Technical Advisor (HIS)-Support to the Health Sector Program II Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH German House House 10/A-2, Road 90 Gulshan 2, Dhaka 1212, Bangladesh T +880 9666701000 F +880 28823099 M +880 19 6206 4721 I www.giz.de https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f ___ 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 - Error in Registration
That is not possible at the moment. Though not complete, we have a value type called Tracker associate for attributes. will try to make it part of the next release. The idea is, for those tracker associate type attributes, you will be able to select or register a tracked entity instance and make a linking. But I am not sure how much this will be helpful for you - because the associated tracked entity instance will always remain so long as assigned. For example if a trainee is assigned to one provider during the first round of training type 1, then the same provider will show up for the second round of training type 1. This could work if you have a training being given only once... what you need to do in this case is create different attributes of type tracker associate for each training. then during registration you assign the trainee to a unique trainer. On Wed, Jun 17, 2015 at 7:32 AM Muhammad Tahir mtag...@gmail.com wrote: Thank you Abyot, it does work. And now we want to move a bit ahead. In the provider training program we also want to keep the information of trainer/worker. (Trainer/worker will registered into the system in a similar manner as provider was registered.) The provider was selected from the list, now in the new form we have some information like ProviderCode (Already filled) ProviderName (Already filled) TrainerCode TrainerName How can we add up trainer information in it from the existing list. Trainer/Worker is also unique in the entire system, so it does not allow to enter any existing Trainer here. I know we can add relations, but relations are maintained in system irrespective of a program and remains the same and it does not identify uniquely which trainer trained in which program. And same is the case when adding an existing provider to another patient program. We can use the same patient and details for other project, but how to add an existing provider to it. Any hint on how can we achieve this? On Tue, Jun 16, 2015 at 10:35 PM, Muhammad Tahir mtag...@gmail.com wrote: Thanks Abyot for the hint, I'll try it and share the results soon. On Tue, Jun 16, 2015 at 5:51 PM, Abyot Gizaw aby...@gmail.com wrote: Hi Muhammad, I am not sure I understood what you wanted to do: 1. You have two programs - provider and provider training 2. You registered a provider under the provider program 3. Now you wanted to use the registered provider and register it again in training program Is this what you wanted to do? If true, then you can do number 3 from the provider's dashboard. Just click on the provider from the list, and it will take you to the dashboard. From this dashboard - you should see a program selection at the top. If you select your new program (which you called provider training), you will have a chance to put additional details in the Enrollment Widget. On Tue, Jun 16, 2015 at 2:38 PM Muhammad Tahir mtag...@gmail.com wrote: Hi, I have created a program to register all the providers at organization unit level and have registered some providers. Provider has some details for input, i.e Provider Code (A unique value in whole system), Provider Name etc. Now created another program that is provider trainings. Now want to select the same provider in that area (org unit) and register provider for trainings, but getting the error Error in Registration. -- *Regards,* *Muhammad Tahir* ___ 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 -- Thank you, Abyot -- *Regards,* *Muhammad Tahir* -- *Regards,* *Muhammad Tahir* -- Thank you, Abyot ___ 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 as LMIS
Hi Gerald,What I’m saying is that DHIS2 is an optimized a data reporting tool , it can be used to track inventory of some drugs through its tracker module, but it is not optimized if you want to manage all your drugs. You can use it to track some drugs stocks but not a very large amount of products and you can’t know your stock intantly,Regarding medication management (For exemple these operation like selling directly products to persons for example, making a stock transfer to another facility, making inventory and adjustment of your inventory... ), it is difficult to do in my opinion.The alternative you have, is just to use software optimized on drugs stock managements and then make a bridge with DHIS2. In BURKINA FASO, we use a software named CHANNEL2 to manage our drugs and DHIS2 for reporting,aggregating data, making chart or using pivot module. Our team is working on a solution to brige easily the two software. William N. D. OUANGOAnalyste Programmeur DSITS (00226) 79 33 83 84 72 00 31 22 66 85 28 18 Le Mercredi 17 juin 2015 8h36, gerald thomas gerald17...@gmail.com a écrit : Dear all, I am interested in the topic and I can't read or speak French. Please can someone translate.Regards, GeraldOn 17 Jun 2015 08:34, Ouango william williamoua...@yahoo.fr wrote: Bonjour Narodar, je vois que tu as des questions sur DHIS2, pour ce qui concerne tes questions, saches que DHIS2 est d'abord un outil de rapportage des données, il peut être utilisé pour le suivi des stocks de certains produits à travers son module tracker, mais ce n'est pas optimisé. Tu peux l'utiliser pour le suivi des produits traceurs par exemple mais pas d'une très grande quantité de produits,Pour ce qui concerne la gestion des médicaments (achat vente au client par exemple, transfert de stock, inventaire et ajustement de stock...), il est difficile de le faire à mon avis. L'alternative que tu as, c'est tout simplement l'utilisation de logiciels de gestions de stock des médicaments et la mise en place d'un pont qui permette de les mettre sur DHIS2 (Exemple gestion de stock = CHANNEL, Outil d'aide à la décision=DHIS2) et tu les relie de sorte à ce que les données de CHANNEL alimentent directement la base de données de DHIS2. Ainsi, tu verra la puissance de DHIS2. William N. D. OUANGOAnalyste Programmeur DSITS (00226) 79 33 83 84 72 00 31 22 66 85 28 18 Le Mercredi 17 juin 2015 8h26, Ouango william williamoua...@yahoo.fr a écrit : Bonjour Narodar, je vois que tu as des questions sur DHIS2, pour ce qui concerne tes questions, saches que DHIS2 est d'abord un outil de rapportage des données, il peut être utilisé pour le suivi des stocks de certains produits à travers son module tracker, mais ce n'est pas optimisé. Tu peux l'utiliser pour le suivi des produits traceurs par exemple mais pas d'une très grande quantité de produits,Pour ce qui concerne la gestion des médicaments, il est difficile de le faire à mon avis. L'alternative que tu as, c'est tout simplement l'utilisation de logiciels de gestions de stock des médicaments et la mise en place d'un pont qui permette de les mettre sur DHIS2 (Exemple gestion de stock = CHANNEL, Outil d'aide à la décision=DHIS2) et tu les relie de sorte à ce que les données de CHANNEL alimentent directement la base de données de DHIS2. Ainsi, tu verra la puissance de DHIS2. William N. D. OUANGOAnalyste Programmeur DSITS (00226) 79 33 83 84 72 00 31 22 66 85 28 18 Le Mardi 16 juin 2015 18h13, Aymar Narodar SOME naro...@gmail.com a écrit : Hi all, I've just want to know if somebody has an experience using DHIS2 as LMIS to manage heath products/commodities in a repository? regards, Aymar ___ 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 ___ 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] DHIS2: Default Registration option in Tracker Capture
Hi Abyot, We have actually 3 type of entities that we want to keep track of. 1) Provider 2) Patient 3) Worker/Trainer For now, I am testing how can these be done either separately or at one place. We can use Manage Attributes with program to register every person either it is a provider, patient or worker. And then use the program to store the program related attributes for each entity and use an option set to distinguish if a person to belongs to either of them. And use relations to link a provider to patient, one patient to another. But have one issue with this configuration is that, we want to track details of which provider provides which service. As in same organization unit, one provider is for vaccination and other is for TB or a separate program. Relations does not keep this information. Can we use details at program stage level, but can we make the list of persons(entity) used in Manage Attributes with program segregated according attributes (set to either patient, provider or worker) to appear in program stage. E.g. Person1 (Attribute: Patient) Person2 (Attribute:Patient) Person3 (Attribute: Provider) Person4 (Attribute: Provider) VaccineProgram-Stage1: Show only person with type providers in list, but providers have their unique code in whole system. Let me know, if any more details are required. On Wed, Jun 17, 2015 at 1:59 PM, Abyot Gizaw aby...@gmail.com wrote: That you have to do it with program. Just now we are discussing the merit of doing registration without selecting a program. The plan is to remove this feature. It seems you are using this feature. Can you tell us more about your usecase - why did you want to register without selecting a program? On Wed, Jun 17, 2015 at 9:59 AM Muhammad Tahir mtag...@gmail.com wrote: Hi Abyot, One more thing related to Manage attributes with no program, how to mark national identification as a mandatory field? On Wed, Jun 17, 2015 at 12:46 PM, Muhammad Tahir mtag...@gmail.com wrote: Thanks Abyot, Manage attributes with no program it is. Have you checked my latest email with subject Error in Registration? Can you help with that? On Wed, Jun 17, 2015 at 12:27 PM, Abyot Gizaw aby...@gmail.com wrote: Yes, you can control them by clicking Manage attributes with no program from the attributes page. On Wed, Jun 17, 2015 at 8:56 AM Shurajit Dutta shurajitdu...@gmail.com wrote: Hi Muhammad, These are attributes. If you go to the programs/attributes app you will see where to find the attributes. Also if you select a program and choose edit you can see how the attributes have been added. You can find some more info here in the docs: https://www.dhis2.org/doc/snapshot/en/user/html/ch29s02.html#d5e5915 On Wed, Jun 17, 2015 at 2:49 PM, Muhammad Tahir mtag...@gmail.com wrote: Hi, On DHIS2 demo site - Tracker Capture When registering without selecting any program, it asks for FirstName, Last Name and National Identifier. But I am unable to locate, how is this configured, kindly share the details how can this be achieved? -- *Regards,* *Muhammad Tahir* ___ 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 -- Thank you, Abyot -- *Regards,* *Muhammad Tahir* -- *Regards,* *Muhammad Tahir* -- Thank you, Abyot -- *Regards,* *Muhammad Tahir* ___ 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 2.18, 2.17. 2.16 reporting Error. Please Help.
Dear Lars There are monthly datasets on which a data entry operator input 50 in a cell. Analytic shows that same number as 51.7 in those months which have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in February as it have 28 days. It has happened as the analytic table calculate the data as Ms. Fatema has described. Nayeem Al Mifthah HMIS Consultant Management Information System Directorate General of Health Services (DGHS), Bangladesh Supported by: UNICEF-Bangladesh Email: n.mift...@gmail.com | nay...@mis.dghs.gov.bd Cell:+8801914030574 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshe...@gmail.com wrote: Hi Fatema, do you think you could explain a bit more about the data elements and calculation? Do you think you cold try with 2.18 / 2.19 ? regards, Lars On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com wrote: Dear All, Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too Here i attach screen short of Pivote Table Analysis and Data Entry Screen In pivote table value shows = 51.7 but originally dataentry screen shows = 50 Calculation it is dividing daysxvalue / 30 = 50* 31/30 = 51.7 But it should do daysxvalue/daysno = 50*31/31 =50 Please have a look on it. Thanks Fatema --- Forwarded message -- rom: Uddin Fatema fatema...@gmail.com Date: Tue, May 5, 2015 at 5:56 PM Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS. To: Jan Henrik Øverland janhenrik.overl...@gmail.com Dear Jan, DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table. The problem is in analytics table it store daysxvalue , daysno and value column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30 But it should do daysxvalue/daysno As a result in pivot table, data visualizer and gis mapping shows wrong data. Could you please solved it additionally, can you please tell me in source code in which file i have to change. Thanks a lot in advance. Regards, *Fatema Uddin* Technical Advisor (HIS)-Support to the Health Sector Program II Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH German House House 10/A-2, Road 90 Gulshan 2, Dhaka 1212, Bangladesh T +880 9666701000 F +880 28823099 M +880 19 6206 4721 I www.giz.de https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f -- Regards, *Fatema Uddin* Technical Advisor (HIS)-Support to the Health Sector Program II Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH German House House 10/A-2, Road 90 Gulshan 2, Dhaka 1212, Bangladesh T +880 9666701000 F +880 28823099 M +880 19 6206 4721 I www.giz.de https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f -- 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-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 2.18, 2.17. 2.16 reporting Error. Please Help.
Hi Fatema, do you think you could explain a bit more about the data elements and calculation? Do you think you cold try with 2.18 / 2.19 ? regards, Lars On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com wrote: Dear All, Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS and same error remain 2.17 and 2.16 too Here i attach screen short of Pivote Table Analysis and Data Entry Screen In pivote table value shows = 51.7 but originally dataentry screen shows = 50 Calculation it is dividing daysxvalue / 30 = 50* 31/30 = 51.7 But it should do daysxvalue/daysno = 50*31/31 =50 Please have a look on it. Thanks Fatema --- Forwarded message -- rom: Uddin Fatema fatema...@gmail.com Date: Tue, May 5, 2015 at 5:56 PM Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot table, data visualizer and GIS. To: Jan Henrik Øverland janhenrik.overl...@gmail.com Dear Jan, DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping retrieve wrong data from Analytics_2015 or all analytics table. The problem is in analytics table it store daysxvalue , daysno and value column but when it retrieve data for pivote table, data-visualizer and gis that time it is dividing daysxvalue / 30 But it should do daysxvalue/daysno As a result in pivot table, data visualizer and gis mapping shows wrong data. Could you please solved it additionally, can you please tell me in source code in which file i have to change. Thanks a lot in advance. Regards, *Fatema Uddin* Technical Advisor (HIS)-Support to the Health Sector Program II Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH German House House 10/A-2, Road 90 Gulshan 2, Dhaka 1212, Bangladesh T +880 9666701000 F +880 28823099 M +880 19 6206 4721 I www.giz.de https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f -- Regards, *Fatema Uddin* Technical Advisor (HIS)-Support to the Health Sector Program II Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH German House House 10/A-2, Road 90 Gulshan 2, Dhaka 1212, Bangladesh T +880 9666701000 F +880 28823099 M +880 19 6206 4721 I www.giz.de https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f -- 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
Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
Dear Morten, Time zone error still remains in 2.18 and 2.19 version. but working fine in 2.17 and bellow version Time Zone (UTC+06:00) Dhaka (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi are giving same error. (UTC+06:30) Yangon (Rangoon)..do not showing that error. I change the time zone UTC+06.30 Yangon and update the resource table it was fine but inside period table a major change shows. id Startdate Enddate 1283308;3;2015-05-01;2015-05-31 1283335;3;2015-02-28;2015-03-30 1283334;3;2015-06-01;2015-06-30 1283336;3;2014-12-31;2015-01-30 1283337;3;2014-11-30;2014-12-30 1283338;3;2013-12-31;2014-01-30 1283339;3;2014-01-31;2014-02-27 1283340;3;2014-07-31;2014-08-30 1283341;3;2014-10-31;2014-11-29 1283342;3;2015-04-30;2015-05-30 1283343;3;2015-03-31;2015-04-29 Please resolve the bug and help us. Thanks in advance On Mon, Mar 23, 2015 at 2:12 PM, Morten Olav Hansen morte...@gmail.com wrote: Yes, this is a known bug. I'm still looking into it, it only happens with certain timezones, will let you know when it has been fixed. -- Morten On Mon, Mar 23, 2015 at 3:05 PM, Ola Hodne Titlestad ol...@ifi.uio.no wrote: Hi Fatema, This is not a database issue, but a bug that occurs when generating the period structure table on machines/servers using on of a few specific time zones. I think I commented on this issues on another email thread you started. Morten knows the details, but my quick fix advice is to change the system time zone to a zone that we know works, e.g. GMT. Ola On 20 Mar 2015 14:16, Alex Tumwesigye atumwesi...@gmail.com wrote: Dear Fatema, All looks good and no duplicates. The only odd stuff is this: Note the years (2063 and 2140) 811017,1,2063-03-11,2063-03-11 811018,1,2063-03-12,2063-03-12 811019,1,2063-03-13,2063-03-13 811020,1,2063-03-14,2063-03-14 811021,1,2063-03-15,2063-03-15 811022,1,2063-03-16,2063-03-16 811023,1,2063-03-17,2063-03-17 811024,1,2063-03-18,2063-03-18 811025,1,2063-03-19,2063-03-19 811026,1,2063-03-20,2063-03-20 811027,1,2063-03-21,2063-03-21 811028,1,2063-03-22,2063-03-22 811029,1,2063-03-23,2063-03-23 811030,1,2063-03-24,2063-03-24 811031,1,2063-03-25,2063-03-25 1555,1,2140-09-03,2140-09-03 1554,1,2140-09-04,2140-09-04 1550,1,2140-09-05,2140-09-05 1551,1,2140-09-06,2140-09-06 1552,1,2140-09-07,2140-09-07 1553,1,2140-09-08,2140-09-08 can you try this query on period table? delete from period where enddate is null or startdate is null; After running this query, go to resource table and regenerate them. Thanks. Alex On Fri, Mar 20, 2015 at 3:52 PM, Uddin Fatema fatema...@gmail.com wrote: Dear Alex, I have run this query and get two result. select enddate,startdate,periodtypeid from period where enddate = '2009-12-31' or startdate = '2009-12-31' Result is 2009-12-31;2009-12-01;3 2009-12-31;2009-01-01;6 here i attached the file too. Thanks a lot On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye atumwesi...@gmail.com wrote: Fatema, Can you dump for me the enddate, startdate and periodtype from period table for that date '2009-12-31' I need to see the output of select enddate,startdate,periodtypeid from period where enddate like '2009-12-31' or startdate like '2009-12-31' Thanks. Alex On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Did you verify that all three constraints are in place on the period table? If they are and you are 100% sure there are no duplicates, then I don't know - I've had similar error messages a couple of times, but removing the duplicates and re-inserting the constraint have always sorted it out. Clear cache (DHIS and browser), empty resource tables, re-start tomcat - I'm not aware of any other tricks Regards Calle On 20 March 2015 at 14:15, Uddin Fatema fatema...@gmail.com wrote: Thanks Calle, I have already checked all part and this period is daily, so startdate and enddate is same 2009-12-31 However, my problem is remains same What can i do. On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Fatema, note that 2009-12-31 looks like an ENDdate, not a startdate. Regards Calle On 20 March 2015 at 14:09, Uddin Fatema fatema...@gmail.com wrote: Thanks Bharath Anna and Alex. Actually i checked period table with this( 2009-12-31) startdate and there is no duplicate period with same startdate. Additionally, for test purpose i deleted this period from period table and from other related table with this periodid. Several time restart the tomcat and clear the cash. Although, problem remain same. Process failed: PreparedStatementCallback; SQL [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint _dateperiodstructure_pkey Detail: Key (dateperiod)=(2009-12-31) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value
Re: [Dhis2-users] [Dhis2-devs] DHIS2: Default Registration option in Tracker Capture
That you have to do it with program. Just now we are discussing the merit of doing registration without selecting a program. The plan is to remove this feature. It seems you are using this feature. Can you tell us more about your usecase - why did you want to register without selecting a program? On Wed, Jun 17, 2015 at 9:59 AM Muhammad Tahir mtag...@gmail.com wrote: Hi Abyot, One more thing related to Manage attributes with no program, how to mark national identification as a mandatory field? On Wed, Jun 17, 2015 at 12:46 PM, Muhammad Tahir mtag...@gmail.com wrote: Thanks Abyot, Manage attributes with no program it is. Have you checked my latest email with subject Error in Registration? Can you help with that? On Wed, Jun 17, 2015 at 12:27 PM, Abyot Gizaw aby...@gmail.com wrote: Yes, you can control them by clicking Manage attributes with no program from the attributes page. On Wed, Jun 17, 2015 at 8:56 AM Shurajit Dutta shurajitdu...@gmail.com wrote: Hi Muhammad, These are attributes. If you go to the programs/attributes app you will see where to find the attributes. Also if you select a program and choose edit you can see how the attributes have been added. You can find some more info here in the docs: https://www.dhis2.org/doc/snapshot/en/user/html/ch29s02.html#d5e5915 On Wed, Jun 17, 2015 at 2:49 PM, Muhammad Tahir mtag...@gmail.com wrote: Hi, On DHIS2 demo site - Tracker Capture When registering without selecting any program, it asks for FirstName, Last Name and National Identifier. But I am unable to locate, how is this configured, kindly share the details how can this be achieved? -- *Regards,* *Muhammad Tahir* ___ 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 -- Thank you, Abyot -- *Regards,* *Muhammad Tahir* -- *Regards,* *Muhammad Tahir* -- Thank you, Abyot ___ 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] Tr : Weekly Epidemiologic reports on DHIS2
Dear Henri, Do you want pdf non-dynamic reports - data doesnt change in the previous reports if edits are made in DHIS2? If this then you can as well design the weekly Epi reports by exporting data out of dhis2 and designing standard pdf docs combining tables, charts and comments and upload then for sharing under reseources linked to the dashboard Otherwise you may consider using html reports of jasper reports Regards On Tue, Jun 16, 2015 at 6:09 PM, henri claude moungui henrimoun...@yahoo.fr wrote: Thank you Matthieu. The dasboard as presented now in DHIS2 only shows maps, tabs or graphs. It does not show comments or interpretations near each map, graph or table. You have to click to see comments and interpretations. A weekly epidemiological report, as I see it, should be printable, then you directly see the text and graphs/maps/tables on the same page.. Thank you. Henri. Le Lundi 15 juin 2015 11h56, Matthieu Pinard matth...@ifi.uio.no a écrit : Hi Henri, do you think that this weekly report be replaced by a dedicated dashboard? Cheers, Matthieu Matthieu Pinard DHIS 2 Academy Community Coordinator | University of Oslo On 15 June 2015 at 11:18, Guy Ekani constyek...@yahoo.fr wrote: Hi Henri, Can you try to setup a standard report as you can see on the developper manual : https://www.dhis2.org/doc/snapshot/en/developer/html/ch03s04.html Sincerely, = EKANI Guy Le Lundi 15 juin 2015 9h13, henri claude moungui henrimoun...@yahoo.fr a écrit : Hi to all. I still have this issue: how to set up a weekly epidemiological report on DHIS2. Is there somebody who did it already? Le Lundi 8 juin 2015 12h48, henri claude moungui henrimoun...@yahoo.fr a écrit : Thank Knut. Here is a sample, but the final version will only concern the AFP, Measles, Tetanus and Yellow fever. Le Lundi 8 juin 2015 11h45, Knut Staring knu...@gmail.com a écrit : Hi Henri, Could you explain what this should contain? Do you have an example? Maybe an existing report in Word, Excel, PDF? Knut On Jun 8, 2015 11:39 AM, henri claude moungui henrimoun...@yahoo.fr wrote: Hi all, please could you tell me what is the right tool to use to generate a weekly epidemiologic report on DHIS2? Than you, Henri ___ 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 ___ 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 -- Prosper Behumbiize, MPH Global HISP| University Of Oslo/HISP Uganda +256 751 751 776 | +256 776 139 139 ptb3...@gmail.com | pros...@dhis2.org | Skype: prospertb ___ 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] Cannot find the new data set in data entry form
Dear Thyda, The dataset has to be assigned to the user role Regards On Thu, Jun 11, 2015 at 11:23 AM, Thyda Eng th...@instedd.org wrote: Dear Sir, I am recently getting start with DHIS2, I play with the version 2.19. First, I create the new user and it to the group Administrator and System Administrator. Then I login as the new created user and I create the new data set and assign to some of the organization unit. However I cannot find my new data set in the data entry form at all. Anyway could anyone help me to create the new data entry form or give me some detail guideline to create it ? I am waiting for your reply. Thank, Thyda Eng ___ 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 -- Prosper Behumbiize, MPH Global HISP| University Of Oslo/HISP Uganda +256 751 751 776 | +256 776 139 139 ptb3...@gmail.com | pros...@dhis2.org | Skype: prospertb ___ 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] Tracked entity
Many thanks, I will try to simulate an example and then afterwards implementing as we need such thing but not for mobile devices. Best regards, João From: Prosper BT [mailto:ptb3...@gmail.com] Sent: 17 June 2015 17:12 To: Joao Mazuze Cc: dhis1-users Subject: Re: [Dhis2-users] Tracked entity Dear Joao, Single event without registration data entry is available offline with the Events capture. For Multiple events with registration using Tracker Capture you need the Android App to run offline. Regards On Mon, Jun 8, 2015 at 11:11 AM, Joao Mazuze joao_maz...@chasssmt.commailto:joao_maz...@chasssmt.com wrote: Hi all, Does tracked entity form work offline? Kind regards _ João Gabriel Mazuze National Database Manager Projecto CHASS-SMT Abt Associates Inc. Av. Marginal, 4067 Cidade de Maputo, Moçambique Fax: (+ 258) 21486767tel:%28%2B%20258%29%C2%A0%2021486767 Tel: (+ 258) 21493525tel:%28%2B%20258%29%C2%A0%2021493525/6/8 Cell: (+258) 82 4236279tel:%28%2B258%29%2082%204236279 www.chasssmt.comhttp://www.chasssmt.com/ [Description: Description: Description: Description: Description: Description: Description: Description: Description: Logotipo CHASS-SMT] Somos um projecto financiado pelo PEPFAR-II, através da USAID, para reforçar o Sistema de Saúde das Provincias de Sofala, Manica e Tete. Pretendemos melhorar a ligação e integração do HIV com os Cuidados Primários de Saúde e outros a ele relacionados em coordenação com as Direcções Provinciais de Saúde e outros parceiros. Através do projecto CHASS-SMT, o Governo Americano apoia o Governo Moçambicano na melhoria da qualidade dos Serviços de Saúde no país. This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system. ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- Prosper Behumbiize, MPH Global HISP| University Of Oslo/HISP Uganda +256 751 751 776 | +256 776 139 139 ptb3...@gmail.commailto:ptb3...@gmail.com | pros...@dhis2.orgmailto:pros...@dhis2.org | Skype: prospertb This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system. ___ 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