← Back to team overview

dhis2-users team mailing list archive

Re: Analytics data querying problem

 

Great.
On Dec 12, 2013 5:15 AM, "Maimoona Kausar" <
maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:

> Thanks alot Lars. I was able to download document as pdf as per your
> suggestion.
>
>
> On Wed, Dec 11, 2013 at 6:23 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:
>
>> Sorry the label on the button is "Print". Try with chrome - it should
>> give you a nice pdf document.
>>
>> Example:
>>
>>
>> http://apps.dhis2.org/demo/dhis-web-reporting/generateHtmlReport.action?uid=AMERNML55Tg&pe=201309&;
>>
>>
>>
>> On Wed, Dec 11, 2013 at 1:28 PM, Maimoona Kausar <
>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>
>>> Thanks Knut, The Permgen problem resolved by running it via command
>>> prompt directly.
>>>
>>> Lars, could you please let me know how and where I can run my html
>>> report to get downloaded as pdf. Currently when I run report it shows me an
>>> html report with only two options 'Print' and Back.
>>>
>>>
>>> On Wed, Dec 11, 2013 at 5:19 PM, Lars Helge Øverland <
>>> larshelge@xxxxxxxxx> wrote:
>>>
>>>> Hi Maimoona,
>>>>
>>>> - like Jason says, you can indicate whether the "form" is complete
>>>> through the "dataSet" and "period" attribute on the "dataValueSet" xml
>>>> element.
>>>>
>>>> - The perm gen error is very likely due to lack of JAV_OPTS being set
>>>> and/or picked up by the system. You can double check from Help -> About ->
>>>> Java_opts inside DHIS.
>>>>
>>>> - For HTML reports you cannot get it as PDF through the Web API
>>>> directly. You can however run the report inside DHIS and click the
>>>> "Download as PDF" button, which will use the web browser to render as PDF
>>>> (we have optimized the CSS in order to make it render well).
>>>>
>>>> Lars
>>>>
>>>>
>>>> On Wed, Dec 11, 2013 at 10:19 AM, Knut Staring <knutst@xxxxxxxxx>wrote:
>>>>
>>>>> Sorry, mistakenly took this offlist. Why have the list policy been
>>>>> changed so that default is reply to just one person?
>>>>>
>>>>>
>>>>> On Wed, Dec 11, 2013 at 10:15 AM, Knut Staring <knutst@xxxxxxxxx>wrote:
>>>>>
>>>>>> startup.sh is only for Linux.
>>>>>>
>>>>>> You should create a Windows environment variable called JAVA_OPTS.
>>>>>>
>>>>>> Set the value to -Xmx:3000m -Xms:1024m -XX:MaxPermSize=512m
>>>>>> -XX:PermSize=128m
>>>>>>
>>>>>> Alternatively, you can open a cmd window, navigate to dhis-live and
>>>>>> paste your command directly there:
>>>>>>
>>>>>> java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Wed, Dec 11, 2013 at 9:54 AM, Maimoona Kausar <
>>>>>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>>>>>
>>>>>>> no, its Windows Desktop, Core i3 pc with Win 7 and 4GB RAM.
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Dec 11, 2013 at 1:46 PM, Knut Staring <knutst@xxxxxxxxx>wrote:
>>>>>>>
>>>>>>>> Are you running dhis live on ubuntu?
>>>>>>>>
>>>>>>>> Sent from my mobile
>>>>>>>> On 11 Dec 2013 14:43, "Maimoona Kausar" <
>>>>>>>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>> java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar
>>>>>>>>>
>>>>>>>>> I used above parameters in startup.sh, but it still gives me PermGen Space error.
>>>>>>>>>
>>>>>>>>> Is there some way I could download Html Standard Report as pdf?
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> I tried doing something like 'api/reports/rRehCvkn5mV/data.pdf?ou=uVvDS7yf79Y&pe=201312', but it didnot work.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Wed, Dec 11, 2013 at 12:21 PM, Knut Staring <knutst@xxxxxxxxx>wrote:
>>>>>>>>>
>>>>>>>>>> https://www.google.la/search?q=java_opts+dhis2
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Wed, Dec 11, 2013 at 8:18 AM, Maimoona Kausar <
>>>>>>>>>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>>>>>>>>>
>>>>>>>>>>> No I didnot, and unfortunately I donot have any idea of how to
>>>>>>>>>>> do it :(
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Wed, Dec 11, 2013 at 12:13 PM, Knut Staring <knutst@xxxxxxxxx
>>>>>>>>>>> > wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Did you set your JAVA_OPTS?
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> On Wed, Dec 11, 2013 at 7:18 AM, Maimoona Kausar <
>>>>>>>>>>>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> Thanks I would start working on it.
>>>>>>>>>>>>>
>>>>>>>>>>>>> I have another question. For standard html reports, is there
>>>>>>>>>>>>> any way to get/download report as pdf. Also in trying working with jrxml
>>>>>>>>>>>>> reports it throws PermGen Space error. I am using dhis-live on a 4 GB
>>>>>>>>>>>>> machine.
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> On Wed, Dec 11, 2013 at 9:54 AM, Jason Pickering <
>>>>>>>>>>>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>>>>>>>>>>>
>>>>>>>>>>>>>> Sorry, gave you the wrong link to how to send the
>>>>>>>>>>>>>> completeness information. It should be [1]
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> You can see it here as described in the docs
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> [1]
>>>>>>>>>>>>>> http://www.dhis2.org/doc/snapshot/en/user/html/ch25s06.html
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> On Wed, Dec 11, 2013 at 6:42 AM, Jason Pickering <
>>>>>>>>>>>>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>> 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
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> Knut Staring
>>>>>>>>>>>> Dept. of Informatics, University of Oslo
>>>>>>>>>>>> +4791880522
>>>>>>>>>>>> http://dhis2.org
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Knut Staring
>>>>>>>>>> Dept. of Informatics, University of Oslo
>>>>>>>>>> +4791880522
>>>>>>>>>> http://dhis2.org
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Knut Staring
>>>>>> Dept. of Informatics, University of Oslo
>>>>>> +4791880522
>>>>>> http://dhis2.org
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Knut Staring
>>>>> Dept. of Informatics, University of Oslo
>>>>> +4791880522
>>>>> http://dhis2.org
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>>>
>>>>>
>>>>
>>>
>>
>

References