dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Maimoona,
I think there are two approaches. The best way would be to transmit the
completeness information through the WebAPI as detailed
here<http://www.dhis2.org/doc/snapshot/en/user/html/ch25s13.html>
.

We had a similar situation when importing data from DHIS 1.4. In this case,
no completeness information was transmitted, so we developed some scripts
to automatically populate the "completedatasetregistration" table based on
the presence of some compulsory data elements. It was assumed that if the
compulsory data elements existed, then the record was complete. Records
were then created and inserted into the "completedatasetregistration" so
that the completeness analysis would make sense for these imported records.
But of course, some assumptions had to be made in this case, like "Was the
record really complete?". Also determining the date of submission would
need to be considered. In this case, we just set it to 15 days past the end
of the period, but there could be other ways of doing this.

Best regards,
Jason



On Tue, Dec 10, 2013 at 10:57 PM, Maimoona Kausar <
maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:

> But we are not using any data entry forms. Our data comes into the system
> via dhisreport module for OpenMRS. This module saves data into table
> datavalue of dhis directly. I tried finding completeddataset via 'Reporting
> Rate Summary' but it appears that it has 0 'Actual Reports' for all months
> (data in table datavalue exists though). Our reports are dataSet centric
> and a report is comprised of a dataSet.
> Is there some important consideration we have not taken into account in
> using dhis?
> A quick solution could be finding all members for a dataSet and add those
> in dimension dynamically, but is there some other better way of achieving
> the goal?
>
>
> On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland <larshelge@xxxxxxxxx
> > wrote:
>
>> Hi Maimoona,
>>
>> "data sets" refers to data set reporting dates. It calculates the
>> reporting rates based on the number of complete data set registrations
>> (people clicking complete in data entry that is). The table name for your
>> reference is "completedatasetregistration".
>>
>> regards,
>>
>> Lars
>>
>>
>> On Tue, Dec 10, 2013 at 10:42 AM, Maimoona Kausar <
>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>
>>> Hi Team,
>>>
>>> I am working with DHIS Standard HTML Reports.
>>>
>>> I am trying to access json data via following:
>>>
>>> ../api/analytics?skipMeta=true&dimension=pe:201312&dimension=dx:xxxxxxxxx(dataSet
>>> id) .
>>>
>>> It doesnot return any row for the query. However by eliminating 'dx', it
>>> returns 1 row as expected.
>>> The dataSet exists and in datavalue table it also contains values for
>>> some of the elements of specified dataSet in given timePeriod.
>>>
>>> Does it perform an inner join on all members of the dataSet?
>>> Giving Ids of individual dataElements as dx also returns expected
>>> values. Is it possible to specify a dataSet/any group of elements that
>>> could return data for all members existing in datavalue table.
>>>
>>> I have also tried using dataElementGroupSet as follows
>>>
>>> api/analytics?skipMeta=true&dimension=pe:201312&dimension=mA8swNR1Vwi:CyAumtaciAg
>>>  but it doesnot work too.
>>>
>>> Many thanks,
>>> Maimoona
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>