← Back to team overview

dhis2-users team mailing list archive

Re: Analytics data querying problem

 

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

Follow ups

References