Hi All,
I have imported a large amount of data values by uploading via csv file with monthly periods of a specific dataset (with DHIS 2.19). I thought that when calculating the reporting rate of this dataset, the report should return the number of actual reports containing values that I have just uploaded, but the number of this “actual reports” is now still counted as ZERO. My question is, in that case, is there a specific field in the database that I should update in order to consider the dataset containing data values in the reporting rates count? Here is the list of fields that I have used during the import: dataelement, period, orgunit, categoryoptioncombo, attributeoptioncombo, value, storedby, lastupdated, comment, followup
Thank you for your help!
Regards,
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
Hi there,
There are several ways of counting completeness, and it is not necessarily related to the datavalues, but rather recorded on the dataset (in the extreme case, there could be nothing to report (because no patients were seen), so no datavalues, but still the report is complete (we have not forgotten to report). Thus, there is a property of the dataset whether it is complete or not for a particular OU and period:
http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s25.html
Here is more on completeness:
http://www.uio.no/studier/emner/matnat/ifi/INF5761/v13/undervisningsmateriale/step-by-step-lab-instructions—completeness.doc
Knut
···
On Wed, Jul 13, 2016 at 9:19 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:
Hi All,
I have imported a large amount of data values by uploading via csv file with monthly periods of a specific dataset (with DHIS 2.19). I thought that when calculating the reporting rate of this dataset, the report should return the number of actual reports containing values that I have just uploaded, but the number of this “actual reports” is now still counted as ZERO. My question is, in that case, is there a specific field in the database that I should update in order to consider the dataset containing data values in the reporting rates count? Here is the list of fields that I have used during the import: dataelement, period, orgunit, categoryoptioncombo, attributeoptioncombo, value, storedby, lastupdated, comment, followup
Thank you for your help!
Regards,
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
If you want to look directly in the database, there is a table called completedatasetregistration.
···
On Wed, Jul 13, 2016 at 10:11 AM, Knut Staring knutst@gmail.com wrote:
Hi there,
There are several ways of counting completeness, and it is not necessarily related to the datavalues, but rather recorded on the dataset (in the extreme case, there could be nothing to report (because no patients were seen), so no datavalues, but still the report is complete (we have not forgotten to report). Thus, there is a property of the dataset whether it is complete or not for a particular OU and period:
http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s25.html
Here is more on completeness:
http://www.uio.no/studier/emner/matnat/ifi/INF5761/v13/undervisningsmateriale/step-by-step-lab-instructions—completeness.doc
Knut
–
On Wed, Jul 13, 2016 at 9:19 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:
Hi All,
I have imported a large amount of data values by uploading via csv file with monthly periods of a specific dataset (with DHIS 2.19). I thought that when calculating the reporting rate of this dataset, the report should return the number of actual reports containing values that I have just uploaded, but the number of this “actual reports” is now still counted as ZERO. My question is, in that case, is there a specific field in the database that I should update in order to consider the dataset containing data values in the reporting rates count? Here is the list of fields that I have used during the import: dataelement, period, orgunit, categoryoptioncombo, attributeoptioncombo, value, storedby, lastupdated, comment, followup
Thank you for your help!
Regards,
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
Thank you Knut, I got it. My question is in which table is linked the “sourceid” field of the completedatasetregistration table as I understand the 5 other fields.
Regards,
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
···
On Wed, Jul 13, 2016 at 11:20 AM, Knut Staring knutst@gmail.com wrote:
If you want to look directly in the database, there is a table called completedatasetregistration.
On Wed, Jul 13, 2016 at 10:11 AM, Knut Staring knutst@gmail.com wrote:
Hi there,
There are several ways of counting completeness, and it is not necessarily related to the datavalues, but rather recorded on the dataset (in the extreme case, there could be nothing to report (because no patients were seen), so no datavalues, but still the report is complete (we have not forgotten to report). Thus, there is a property of the dataset whether it is complete or not for a particular OU and period:
http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s25.html
Here is more on completeness:
http://www.uio.no/studier/emner/matnat/ifi/INF5761/v13/undervisningsmateriale/step-by-step-lab-instructions—completeness.doc
Knut
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
On Wed, Jul 13, 2016 at 9:19 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:
Hi All,
I have imported a large amount of data values by uploading via csv file with monthly periods of a specific dataset (with DHIS 2.19). I thought that when calculating the reporting rate of this dataset, the report should return the number of actual reports containing values that I have just uploaded, but the number of this “actual reports” is now still counted as ZERO. My question is, in that case, is there a specific field in the database that I should update in order to consider the dataset containing data values in the reporting rates count? Here is the list of fields that I have used during the import: dataelement, period, orgunit, categoryoptioncombo, attributeoptioncombo, value, storedby, lastupdated, comment, followup
Thank you for your help!
Regards,
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
–
Sourceid = Organisaitonunitid. This is an unfortunate historical naming.
Knut
···
On Wed, Jul 13, 2016 at 11:19 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:
Thank you Knut, I got it. My question is in which table is linked the “sourceid” field of the completedatasetregistration table as I understand the 5 other fields.
Regards,
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
–
On Wed, Jul 13, 2016 at 11:20 AM, Knut Staring knutst@gmail.com wrote:
If you want to look directly in the database, there is a table called completedatasetregistration.
On Wed, Jul 13, 2016 at 10:11 AM, Knut Staring knutst@gmail.com wrote:
Hi there,
There are several ways of counting completeness, and it is not necessarily related to the datavalues, but rather recorded on the dataset (in the extreme case, there could be nothing to report (because no patients were seen), so no datavalues, but still the report is complete (we have not forgotten to report). Thus, there is a property of the dataset whether it is complete or not for a particular OU and period:
http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s25.html
Here is more on completeness:
http://www.uio.no/studier/emner/matnat/ifi/INF5761/v13/undervisningsmateriale/step-by-step-lab-instructions—completeness.doc
Knut
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
On Wed, Jul 13, 2016 at 9:19 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:
Hi All,
I have imported a large amount of data values by uploading via csv file with monthly periods of a specific dataset (with DHIS 2.19). I thought that when calculating the reporting rate of this dataset, the report should return the number of actual reports containing values that I have just uploaded, but the number of this “actual reports” is now still counted as ZERO. My question is, in that case, is there a specific field in the database that I should update in order to consider the dataset containing data values in the reporting rates count? Here is the list of fields that I have used during the import: dataelement, period, orgunit, categoryoptioncombo, attributeoptioncombo, value, storedby, lastupdated, comment, followup
Thank you for your help!
Regards,
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
Great. Thanks!
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
···
On Wed, Jul 13, 2016 at 12:38 PM, Knut Staring knutst@gmail.com wrote:
Knut
Sourceid = Organisaitonunitid. This is an unfortunate historical naming.
On Wed, Jul 13, 2016 at 11:19 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:
Thank you Knut, I got it. My question is in which table is linked the “sourceid” field of the completedatasetregistration table as I understand the 5 other fields.
Regards,
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
On Wed, Jul 13, 2016 at 11:20 AM, Knut Staring knutst@gmail.com wrote:
If you want to look directly in the database, there is a table called completedatasetregistration.
On Wed, Jul 13, 2016 at 10:11 AM, Knut Staring knutst@gmail.com wrote:
Hi there,
There are several ways of counting completeness, and it is not necessarily related to the datavalues, but rather recorded on the dataset (in the extreme case, there could be nothing to report (because no patients were seen), so no datavalues, but still the report is complete (we have not forgotten to report). Thus, there is a property of the dataset whether it is complete or not for a particular OU and period:
http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s25.html
Here is more on completeness:
http://www.uio.no/studier/emner/matnat/ifi/INF5761/v13/undervisningsmateriale/step-by-step-lab-instructions—completeness.doc
Knut
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
On Wed, Jul 13, 2016 at 9:19 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:
Hi All,
I have imported a large amount of data values by uploading via csv file with monthly periods of a specific dataset (with DHIS 2.19). I thought that when calculating the reporting rate of this dataset, the report should return the number of actual reports containing values that I have just uploaded, but the number of this “actual reports” is now still counted as ZERO. My question is, in that case, is there a specific field in the database that I should update in order to consider the dataset containing data values in the reporting rates count? Here is the list of fields that I have used during the import: dataelement, period, orgunit, categoryoptioncombo, attributeoptioncombo, value, storedby, lastupdated, comment, followup
Thank you for your help!
Regards,
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
–