← Back to team overview

dhis2-devs team mailing list archive

Re: Zero reporting rates for dataset with imported data values

 

Great. Thanks!

Tantely.

On Wed, Jul 13, 2016 at 12:38 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> Sourceid = Organisaitonunitid. This is an unfortunate historical naming.
>
> Knut
>
> On Wed, Jul 13, 2016 at 11:19 AM, Raminosoa Rabemanantsoa, Tantely <
> traminosoa@xxxxxxxxxx> 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.
>>
>> On Wed, Jul 13, 2016 at 11:20 AM, Knut Staring <knutst@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>>>> 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
>>>
>>
>>
>> *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
>

-- 
*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.*

References