← Back to team overview

dhis2-users team mailing list archive

Re: Analytics data querying problem

 

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

Follow ups

References