dhis2-devs team mailing list archive

["Raminosoa Rabemanantsoa, Tantely" <traminosoa@xxxxxxxxxx>]

Hi Jan, Jason,

Thank you for this suggestion! Clicking on csv under update is working! It
is giving the raw data with only the selected dataelements in the query in
the left side. It seems interesting, I only have to build the
crosstabulation in the spreadsheet.

Also, could you please mention the step-by-step way in order to change the
parameters in the browser JS console to handle a big URL? Or it will affect
system stability? I am using Mozilla Firefox.

Regards,

Tantely.

On Wed, Apr 5, 2017 at 10:20 AM, Jan Henrik Øverland <jan@xxxxxxxxx> wrote:

> As long as you are selecting orgunits by level, and not explicitly, that
> should not be a problem.
>
> On 5 April 2017 at 09:08, Jason Pickering <jason.p.pickering@xxxxxxxxx>
> wrote:
>
>> You maybe getting a "HTTP Error 414 Request URI too long" error in the
>> browser. This happens when the URL generated by the client is too big to be
>> handled by the HTTP server. Check the JS console in the browser and see.
>>
>> Jan's method may work, but it will not work if you are getting that
>> error.
>>
>> Regards,
>> Jason
>>
>>
>>
>> On Wed, Apr 5, 2017 at 9:06 AM, Jan Henrik Øverland <jan@xxxxxxxxx>
>> wrote:
>>
>>> Hi Tantely,
>>>
>>> You can dump larger chunks of data by doing the following:
>>>
>>> - Open the pivot tables app
>>> - Select what you need in the left menu
>>> - Do not click "update" -  instead click the small down-arrow next to
>>> the update button and download as CSV
>>>
>>> Jan
>>>
>>> On 5 April 2017 at 08:32, Raminosoa Rabemanantsoa, Tantely <
>>> traminosoa@xxxxxxxxxx> wrote:
>>>
>>>> Dear Calle,
>>>>
>>>> Thank you for your suggestions. In order to dump the results, I have to
>>>> lower the number of OrgUnits by splitting them by parents OrgUnits and loop
>>>> the process unitl all OrgUnits are done.
>>>>
>>>> Regards,
>>>>
>>>> Tantely.
>>>>
>>>>
>>>> On Tue, Apr 4, 2017 at 11:00 AM, Calle Hedberg <calle.hedberg@xxxxxxxxx
>>>> > wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> This is a common problem - the pivot table app cannot process/display
>>>>> larger sets of data, which is typically what you get when selecting the
>>>>> lowest OU level.
>>>>>
>>>>> Try dumping the result out into another format (CSV, Excel), and then
>>>>> process that into the report format you want.
>>>>>
>>>>> Regards
>>>>> Calle
>>>>>
>>>>> On 3 April 2017 at 13:05, Raminosoa Rabemanantsoa, Tantely <
>>>>> traminosoa@xxxxxxxxxx> wrote:
>>>>>
>>>>>> Dear DHIS2 community,
>>>>>>
>>>>>>
>>>>>> We are using DHIS2 2.24. When we are running pivot table and are
>>>>>> using some indicators by selecting the lowest level of OrgUnit (Community
>>>>>> Health Workers), the application is running without any results output (an
>>>>>> illustration is attached). The application is only responding when we are
>>>>>> going up to a higher level in the OrgUnit tree. Are there some memories
>>>>>> parameters to tune or what should be done to troubleshoot this issue, as we
>>>>>> really need the results presented with the lowest OrgUnit. In the server
>>>>>> side, we are using 16 cores CPU and 64 Gb of RAM.
>>>>>>
>>>>>>
>>>>>> Thank you for your support,
>>>>>>
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>>
>>>>>> Tantely.
>>>>>>
>>>>>> *This message and its attachments are confidential and solely for the
>>>>>> intended recipients. If received in error, please delete them and notify
>>>>>> the sender via reply e-mail immediately.*
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> *******************************************
>>>>>
>>>>> Calle Hedberg
>>>>>
>>>>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>>>
>>>>> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>>>>>
>>>>> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>>>>>
>>>>> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>>>>>
>>>>> Email: calle.hedberg@xxxxxxxxx
>>>>>
>>>>> Skype: calle_hedberg
>>>>>
>>>>> *******************************************
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *This message and its attachments are confidential and solely for the
>>>> intended recipients. If received in error, please delete them and notify
>>>> the sender via reply e-mail immediately.*
>>>>
>>>> _______________________________________________
>>>> 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
>>>>
>>>>
>>>
>>>
>>> --
>>> Jan Henrik Øverland
>>> Software developer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.pickering@xxxxxxxxx
>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>
>
>
>
> --
> Jan Henrik Øverland
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org <https://www.dhis2.org/>
>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*