← Back to team overview

dhis2-users team mailing list archive

Re: Analytics data querying problem

 

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

Follow ups

References