[Dhis2-users] Restore a large PostgreSQL dump
Hi team I am having a challenge on restoring a postres dump which is large (16gig), it gives an error on restoring data in table analytics 2014. Can anyone please help with how I can go around it, or maybe how to edit the dump (notepad++ cannot open the file is too large). Regards Ngonidzashe Manika Data Officer +263 772 789673, mailto:nman...@hotmail.com nman...@hotmail.com, skype: ngoni.manika Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library, Mkwati Building ___ 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] Restore a large PostgreSQL dump
Easiest way is to not dump the analytics tables at all. They can be regenerated by running the analytics process once you have restores your database without these tables. Regards, Jason On Mar 11, 2015 5:31 PM, Ngoni Manika nman...@hotmail.com wrote: Hi team I am having a challenge on restoring a postres dump which is large (16gig), it gives an error on restoring data in table analytics 2014. Can anyone please help with how I can go around it, or maybe how to edit the dump (notepad++ cannot open the file is too large). Regards *Ngonidzashe Manika* *Data Officer* *+*263 772 789673, nman...@hotmail.com, skype: ngoni.manika Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library, Mkwati Building ___ 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] Restore a large PostgreSQL dump
Thanks a lot, I have also tried the command line but it's the same result. I guess its corrupted then. Will try to do another one. Thanks guys Ngonidzashe Manika Data Officer +263 772 789673, nman...@hotmail.com mailto:nman...@hotmail.com , skype: ngoni.manika Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library, Mkwati Building From: Bob Jolliffe [mailto:bobjolli...@gmail.com] Sent: Wednesday, March 11, 2015 9:29 PM To: Ngoni Manika Cc: Knut Staring; dhis2-users Subject: RE: [Dhis2-users] Restore a large PostgreSQL dump Thats a bit odd. If the data was in the table when it was dumped it should be there when its restored. Looks like the dump file could be corrupted. Are you restoring with pgadmin. You might have better luck with command line. If you don't have the option to make another dump then leave out these big useless analytics tables as others have suggested On 11 Mar 2015 19:49, Ngoni Manika nman...@hotmail.com mailto:nman...@hotmail.com wrote: Thanks Bob Below is the error im getting pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 5328; 0 1415587 TABLE DATA analytics_2014 postgres pg_restore: [archiver (db)] COPY failed for table analytics_2014: ERROR: missing data for column NDAElbuYMNM CONTEXT: COPY analytics_2014, line 11201741: \N \N \N \N \N xuuDrpnpEPDc2g5zOOo pg_restore: restoring data for table analytics_2015 pg_restore: [tar archiver] corrupt tar header found in \N (expected 3679, computed 33533) file position 9118576128 Regards Ngonidzashe Manika Data Officer +263 772 789673, nman...@hotmail.com mailto:nman...@hotmail.com , skype: ngoni.manika Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library, Mkwati Building From: Bob Jolliffe [mailto:bobjolli...@gmail.com mailto:bobjolli...@gmail.com ] Sent: Wednesday, March 11, 2015 6:52 PM To: Knut Staring Cc: Ngoni Manika; dhis2-users Subject: Re: [Dhis2-users] Restore a large PostgreSQL dump Knut and Jason are both right. There is no point dumping tables which can be recreated. But that in itself shouldn't cause an error restoring a dump and 16G is far from huge (of course too big for notepad++ but that's a different issue). What was the error message? On 11 March 2015 at 16:39, Knut Staring knu...@gmail.com mailto:knu...@gmail.com wrote: This advice may be a bit late for you, but I would recommend excluding analytics when you do a backup. On 11 Mar 2015 17:31, Ngoni Manika nman...@hotmail.com mailto:nman...@hotmail.com wrote: Hi team I am having a challenge on restoring a postres dump which is large (16gig), it gives an error on restoring data in table analytics 2014. Can anyone please help with how I can go around it, or maybe how to edit the dump (notepad++ cannot open the file is too large). Regards Ngonidzashe Manika Data Officer +263 772 789673, nman...@hotmail.com mailto:nman...@hotmail.com , skype: ngoni.manika Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library, Mkwati Building ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net mailto: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 mailto: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] Restore a large PostgreSQL dump
Thanks Bob Below is the error im getting pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 5328; 0 1415587 TABLE DATA analytics_2014 postgres pg_restore: [archiver (db)] COPY failed for table analytics_2014: ERROR: missing data for column NDAElbuYMNM CONTEXT: COPY analytics_2014, line 11201741: \N \N \N \N \N xuuDrpnpEPDc2g5zOOo pg_restore: restoring data for table analytics_2015 pg_restore: [tar archiver] corrupt tar header found in \N (expected 3679, computed 33533) file position 9118576128 Regards Ngonidzashe Manika Data Officer +263 772 789673, nman...@hotmail.com mailto:nman...@hotmail.com , skype: ngoni.manika Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library, Mkwati Building From: Bob Jolliffe [mailto:bobjolli...@gmail.com] Sent: Wednesday, March 11, 2015 6:52 PM To: Knut Staring Cc: Ngoni Manika; dhis2-users Subject: Re: [Dhis2-users] Restore a large PostgreSQL dump Knut and Jason are both right. There is no point dumping tables which can be recreated. But that in itself shouldn't cause an error restoring a dump and 16G is far from huge (of course too big for notepad++ but that's a different issue). What was the error message? On 11 March 2015 at 16:39, Knut Staring knu...@gmail.com mailto:knu...@gmail.com wrote: This advice may be a bit late for you, but I would recommend excluding analytics when you do a backup. On 11 Mar 2015 17:31, Ngoni Manika nman...@hotmail.com mailto:nman...@hotmail.com wrote: Hi team I am having a challenge on restoring a postres dump which is large (16gig), it gives an error on restoring data in table analytics 2014. Can anyone please help with how I can go around it, or maybe how to edit the dump (notepad++ cannot open the file is too large). Regards Ngonidzashe Manika Data Officer +263 772 789673, nman...@hotmail.com mailto:nman...@hotmail.com , skype: ngoni.manika Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library, Mkwati Building ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net mailto: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 mailto: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] Restore a large PostgreSQL dump
Thats a bit odd. If the data was in the table when it was dumped it should be there when its restored. Looks like the dump file could be corrupted. Are you restoring with pgadmin. You might have better luck with command line. If you don't have the option to make another dump then leave out these big useless analytics tables as others have suggested On 11 Mar 2015 19:49, Ngoni Manika nman...@hotmail.com wrote: Thanks Bob Below is the error im getting pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 5328; 0 1415587 TABLE DATA analytics_2014 postgres pg_restore: [archiver (db)] COPY failed for table analytics_2014: ERROR: missing data for column NDAElbuYMNM CONTEXT: COPY analytics_2014, line 11201741: \N \N \N \N \N xuuDrpnpEPDc2g5zOOo pg_restore: restoring data for table analytics_2015 pg_restore: [tar archiver] corrupt tar header found in \N (expected 3679, computed 33533) file position 9118576128 Regards Ngonidzashe Manika Data Officer +263 772 789673, nman...@hotmail.com, skype: ngoni.manika Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library, Mkwati Building From: Bob Jolliffe [mailto:bobjolli...@gmail.com] Sent: Wednesday, March 11, 2015 6:52 PM To: Knut Staring Cc: Ngoni Manika; dhis2-users Subject: Re: [Dhis2-users] Restore a large PostgreSQL dump Knut and Jason are both right. There is no point dumping tables which can be recreated. But that in itself shouldn't cause an error restoring a dump and 16G is far from huge (of course too big for notepad++ but that's a different issue). What was the error message? On 11 March 2015 at 16:39, Knut Staring knu...@gmail.com wrote: This advice may be a bit late for you, but I would recommend excluding analytics when you do a backup. On 11 Mar 2015 17:31, Ngoni Manika nman...@hotmail.com wrote: Hi team I am having a challenge on restoring a postres dump which is large (16gig), it gives an error on restoring data in table analytics 2014. Can anyone please help with how I can go around it, or maybe how to edit the dump (notepad++ cannot open the file is too large). Regards Ngonidzashe Manika Data Officer +263 772 789673, nman...@hotmail.com, skype: ngoni.manika Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library, Mkwati Building ___ 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] Restore a large PostgreSQL dump
Knut and Jason are both right. There is no point dumping tables which can be recreated. But that in itself shouldn't cause an error restoring a dump and 16G is far from huge (of course too big for notepad++ but that's a different issue). What was the error message? On 11 March 2015 at 16:39, Knut Staring knu...@gmail.com wrote: This advice may be a bit late for you, but I would recommend excluding analytics when you do a backup. On 11 Mar 2015 17:31, Ngoni Manika nman...@hotmail.com wrote: Hi team I am having a challenge on restoring a postres dump which is large (16gig), it gives an error on restoring data in table analytics 2014. Can anyone please help with how I can go around it, or maybe how to edit the dump (notepad++ cannot open the file is too large). Regards *Ngonidzashe Manika* *Data Officer* *+*263 772 789673, nman...@hotmail.com, skype: ngoni.manika Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library, Mkwati Building ___ 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] Restore a large PostgreSQL dump
This advice may be a bit late for you, but I would recommend excluding analytics when you do a backup. On 11 Mar 2015 17:31, Ngoni Manika nman...@hotmail.com wrote: Hi team I am having a challenge on restoring a postres dump which is large (16gig), it gives an error on restoring data in table analytics 2014. Can anyone please help with how I can go around it, or maybe how to edit the dump (notepad++ cannot open the file is too large). Regards *Ngonidzashe Manika* *Data Officer* *+*263 772 789673, nman...@hotmail.com, skype: ngoni.manika Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library, Mkwati Building ___ 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 indicator problems
Hi Joao Have you tried running the analytics to see if this will solve your problem? Apps-Reports-Analytics and Data Mart Nick On Mar 11, 2015 7:22 PM, Joao Mazuze joao_maz...@chasssmt.com wrote: Dear all, We are facing now is about indicators, all the data entered manually appear to be zero values on pivot tables when using indicators, we don´t know what is happening as data elements produce real values. The only data visible using indicators is the imported one from the old system we were using before.in summary, our system is not calculating any indicator using data entered by users, it displays only zero for those periods. Can someone help us in solving this? Best regards João -- 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 ___ 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 indicator problems
Dear all, We are facing now is about indicators, all the data entered manually appear to be zero values on pivot tables when using indicators, we don´t know what is happening as data elements produce real values. The only data visible using indicators is the imported one from the old system we were using before.in summary, our system is not calculating any indicator using data entered by users, it displays only zero for those periods. Can someone help us in solving this? Best regards João 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
Re: [Dhis2-users] dhis2 indicator problems
Have you executed Analytics and DataMart for new data entered? 2015-03-11 9:22 GMT+01:00 Joao Mazuze joao_maz...@chasssmt.com: Dear all, We are facing now is about indicators, all the data entered manually appear to be zero values on pivot tables when using indicators, we don´t know what is happening as data elements produce real values. The only data visible using indicators is the imported one from the old system we were using before.in summary, our system is not calculating any indicator using data entered by users, it displays only zero for those periods. Can someone help us in solving this? Best regards João -- 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 -- Riddy NDOMA Software Developer *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma *Blog:* http://riddyndoma.blogspot.com/ *Vous servir est mon désire (Serving you is my desire)* ___ 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 indicator problems
Okay thanks. On Wed, Mar 11, 2015 at 10:11 AM, Joao Mazuze joao_maz...@chasssmt.com wrote: Hi Lars, I am able to create dataelements that make up my indicator expressions. I will ask for access with my host provider in order to back up my database and share it. The attached *jpeg* file is an example showing indicator and the corresponding dataElement that made it up, in period where data where entered by users indicator display zero values. Kind regards Joao *From:* Lars Helge Øverland [mailto:larshe...@gmail.com] *Sent:* 11 March 2015 10:54 *To:* Joao Mazuze *Cc:* riddy ndoma; dhis2-users@lists.launchpad.net *Subject:* Re: [Dhis2-users] dhis2 indicator problems Hi Joao, we will need more information from you in order to help. Are you allowed to share your database privately? In pivot table, can you create a report with the data elements that make up your indicator expressions? That could tell you whether the problem is with the indicators or something else. regards, Lars On Wed, Mar 11, 2015 at 9:34 AM, Joao Mazuze joao_maz...@chasssmt.com wrote: We have set Analytics and DataMarts to run automatically and we had also run manually, but indicators still zero values. I would like to know if there is any rule on indicators definitions like for instance, some characters are not allowed or some other rules that have not been applied just to avoid this issue. Regards Joao *From:* riddy ndoma [mailto:riddynd...@gmail.com] *Sent:* 11 March 2015 10:27 *To:* Joao Mazuze *Cc:* dhis2-users@lists.launchpad.net *Subject:* Re: [Dhis2-users] dhis2 indicator problems Have you executed Analytics and DataMart for new data entered? 2015-03-11 9:22 GMT+01:00 Joao Mazuze joao_maz...@chasssmt.com: Dear all, We are facing now is about indicators, all the data entered manually appear to be zero values on pivot tables when using indicators, we don´t know what is happening as data elements produce real values. The only data visible using indicators is the imported one from the old system we were using before.in summary, our system is not calculating any indicator using data entered by users, it displays only zero for those periods. Can someone help us in solving this? Best regards João -- 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 -- Riddy NDOMA Software Developer *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma *Blog:* http://riddyndoma.blogspot.com/ *Vous servir est mon désire (Serving you is my desire)* -- 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 -- 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
Re: [Dhis2-users] dhis2 indicator problems
Hi Joao, we will need more information from you in order to help. Are you allowed to share your database privately? In pivot table, can you create a report with the data elements that make up your indicator expressions? That could tell you whether the problem is with the indicators or something else. regards, Lars On Wed, Mar 11, 2015 at 9:34 AM, Joao Mazuze joao_maz...@chasssmt.com wrote: We have set Analytics and DataMarts to run automatically and we had also run manually, but indicators still zero values. I would like to know if there is any rule on indicators definitions like for instance, some characters are not allowed or some other rules that have not been applied just to avoid this issue. Regards Joao *From:* riddy ndoma [mailto:riddynd...@gmail.com] *Sent:* 11 March 2015 10:27 *To:* Joao Mazuze *Cc:* dhis2-users@lists.launchpad.net *Subject:* Re: [Dhis2-users] dhis2 indicator problems Have you executed Analytics and DataMart for new data entered? 2015-03-11 9:22 GMT+01:00 Joao Mazuze joao_maz...@chasssmt.com: Dear all, We are facing now is about indicators, all the data entered manually appear to be zero values on pivot tables when using indicators, we don´t know what is happening as data elements produce real values. The only data visible using indicators is the imported one from the old system we were using before.in summary, our system is not calculating any indicator using data entered by users, it displays only zero for those periods. Can someone help us in solving this? Best regards João -- 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 -- Riddy NDOMA Software Developer *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma *Blog:* http://riddyndoma.blogspot.com/ *Vous servir est mon désire (Serving you is my desire)* -- 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 ___ 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] how DHIS2 system identify individual track?
Hi all, how DHIS2 system identify individual track in Aggregate Query Builder when we choose Number of tracked entity instances? THank you CHANNARA ___ 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 indicator problems
Hi Lars, I am able to create dataelements that make up my indicator expressions. I will ask for access with my host provider in order to back up my database and share it. The attached jpeg file is an example showing indicator and the corresponding dataElement that made it up, in period where data where entered by users indicator display zero values. Kind regards Joao From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 11 March 2015 10:54 To: Joao Mazuze Cc: riddy ndoma; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] dhis2 indicator problems Hi Joao, we will need more information from you in order to help. Are you allowed to share your database privately? In pivot table, can you create a report with the data elements that make up your indicator expressions? That could tell you whether the problem is with the indicators or something else. regards, Lars On Wed, Mar 11, 2015 at 9:34 AM, Joao Mazuze joao_maz...@chasssmt.commailto:joao_maz...@chasssmt.com wrote: We have set Analytics and DataMarts to run automatically and we had also run manually, but indicators still zero values. I would like to know if there is any rule on indicators definitions like for instance, some characters are not allowed or some other rules that have not been applied just to avoid this issue. Regards Joao From: riddy ndoma [mailto:riddynd...@gmail.commailto:riddynd...@gmail.com] Sent: 11 March 2015 10:27 To: Joao Mazuze Cc: dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] dhis2 indicator problems Have you executed Analytics and DataMart for new data entered? 2015-03-11 9:22 GMT+01:00 Joao Mazuze joao_maz...@chasssmt.commailto:joao_maz...@chasssmt.com: Dear all, We are facing now is about indicators, all the data entered manually appear to be zero values on pivot tables when using indicators, we don´t know what is happening as data elements produce real values. The only data visible using indicators is the imported one from the old system we were using before.inhttp://before.in summary, our system is not calculating any indicator using data entered by users, it displays only zero for those periods. Can someone help us in solving this? Best regards João 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 -- Riddy NDOMA Software Developer Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma Twitter: riddyndoma, LinkedIn: riddy ndoma Blog: http://riddyndoma.blogspot.com/ Vous servir est mon désire (Serving you is my desire) 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 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
Re: [Dhis2-users] dhis2 indicator problems
We have set Analytics and DataMarts to run automatically and we had also run manually, but indicators still zero values. I would like to know if there is any rule on indicators definitions like for instance, some characters are not allowed or some other rules that have not been applied just to avoid this issue. Regards Joao From: riddy ndoma [mailto:riddynd...@gmail.com] Sent: 11 March 2015 10:27 To: Joao Mazuze Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] dhis2 indicator problems Have you executed Analytics and DataMart for new data entered? 2015-03-11 9:22 GMT+01:00 Joao Mazuze joao_maz...@chasssmt.commailto:joao_maz...@chasssmt.com: Dear all, We are facing now is about indicators, all the data entered manually appear to be zero values on pivot tables when using indicators, we don´t know what is happening as data elements produce real values. The only data visible using indicators is the imported one from the old system we were using before.inhttp://before.in summary, our system is not calculating any indicator using data entered by users, it displays only zero for those periods. Can someone help us in solving this? Best regards João 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 -- Riddy NDOMA Software Developer Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma Twitter: riddyndoma, LinkedIn: riddy ndoma Blog: http://riddyndoma.blogspot.com/ Vous servir est mon désire (Serving you is my desire) 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
[Dhis2-users] Getting value from dataelement/indicator
Dear all, Can someone please help me on a script doing the following: I have a form with data Elements that must be filled with values according to values entered in another data elements before submitting the form. How do I get values from this data Elements/Indicators on the form in order to perform operations? May someone has any JavaScript just performing similar? Regards Joao 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
[Dhis2-users] DHIS2's individual records vs OpenMRS
Dear all, Has anyone explain me more detail what is the different between DHIS2's individual records vs OpenMRS? when we use both? Thank you CHANNARA ___ 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