← Back to team overview

dhis2-devs team mailing list archive

Re: Zero reporting rates for dataset with imported data values

 

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

Follow ups

References