dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Okay then there is trick based on generating the analytics URL yourself.
Using the API you can ignore the limit. Docs
here<http://www.dhis2.org/doc/snapshot/en/user/html/ch27s16.html#d5e8374>
.

- In chrome click F12, go to Network
- Generate the pivot table you want (and let it fail validation)
- Copy the URL of the request going to the server, starting with
api/analytics/.. etc.
- In the URL, replace the file extension .json with .xls , then append a
query parameter: &ignoreLimit=true

Don't try this at home.

Lars









On Thu, Jan 23, 2014 at 9:13 PM, Dapo Adejumo <dapo_adejumo@xxxxxxxxx>wrote:

> Hi Lars, to be able to download will be fine not necessarily to view in
> the browser.
>
>
>
> ................................................
>
>
>
> *Regards,*
>
>
>
> *Dapo Adejumo*
>
> *+2348033683677 <%2B2348033683677>*
>
> *skype : dapojorge*
>
>
>
> *From:* Lars Helge Øverland [mailto:larshelge@xxxxxxxxx]
> *Sent:* 23 January 2014 19:36
> *To:* Dapo Adejumo
> *Cc:* DHIS 2 Developers list
> *Subject:* Re: [Dhis2-devs] Web pivot cell limit
>
>
>
> Hi Dapo,
>
>
>
> sorry not through the UI. Is it enough to download the table as excel/csv,
> or do you want to it in the browser?
>
>
>
> Lars
>
>
>
>
>
>
>
> On Thu, Jan 23, 2014 at 8:30 PM, Dapo Adejumo <dapo_adejumo@xxxxxxxxx>
> wrote:
>
> Hi Devs,
>
> The cell limit for the web pivot has been set to 50,000 understandably to
> protect the server. But is there a way to override this temporarily?
>
> Any ideas?
>
>
>
> ................................................
>
>
>
> *Regards,*
>
>
>
> *Dapo Adejumo*
>
> *+2348033683677 <%2B2348033683677>*
>
> *skype : dapojorge*
>
>
>
>
> _______________________________________________
> 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
>
>
>