dhis2-devs team mailing list archive

["Dapo Adejumo" <dapo_adejumo@xxxxxxxxx>]

Thanks Lars….will only try this at home…

 

................................................

 

Regards,

 

Dapo Adejumo

+2348033683677

skype : dapojorge

 

From: Lars Helge Øverland [mailto:larshelge@xxxxxxxxx] 
Sent: 23 January 2014 20:34
To: Dapo Adejumo
Cc: DHIS 2 Developers list
Subject: Re: [Dhis2-devs] Web pivot cell limit

 

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
<mailto:dapo_adejumo@xxxxxxxxx> > wrote:

Hi Lars, to be able to download will be fine not necessarily to view in the
browser.

 

................................................

 

Regards,

 

Dapo Adejumo

 <tel:%2B2348033683677> +2348033683677

skype : dapojorge

 

From: Lars Helge Øverland [mailto: <mailto:larshelge@xxxxxxxxx>
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
<mailto: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

 <tel:%2B2348033683677> +2348033683677

skype : dapojorge

 


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx> 
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp