Testing modified JSON inside of Pivot Tables

Hi Devs

Is there any way or planned functionality for testing JSON urls inside of pivot tables? E.g. I set up a pivot table then download the JSON data source but then want to test a modified version of that JSON string inside the current session… is that possible or do-able…?

Greg

···

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

Hi Greg,

you mean you want the JSON string to render a pivot? The problem is that the JSON analytics request only contains the data source for the pivot, not the layout of it.

What you can do is to simply paste the URL into a web browser or use curl to test it, and see how your changes affects output.

best regards,

Lars

···

On Tue, Mar 17, 2015 at 12:10 PM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Devs

Is there any way or planned functionality for testing JSON urls inside of pivot tables? E.g. I set up a pivot table then download the JSON data source but then want to test a modified version of that JSON string inside the current session… is that possible or do-able…?

Greg


Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Hi Greg, what kind of modifications do you want to make?

I can easily expose a function so that you can test stuff via the Chrome console. But the data needs to follow a specific format, so you will only be able to change the data/values basically.

Jan

···

On Wed, Mar 18, 2015 at 11:55 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Greg,

you mean you want the JSON string to render a pivot? The problem is that the JSON analytics request only contains the data source for the pivot, not the layout of it.

What you can do is to simply paste the URL into a web browser or use curl to test it, and see how your changes affects output.

best regards,

Lars


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Mar 17, 2015 at 12:10 PM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Devs

Is there any way or planned functionality for testing JSON urls inside of pivot tables? E.g. I set up a pivot table then download the JSON data source but then want to test a modified version of that JSON string inside the current session… is that possible or do-able…?

Greg


Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Hi Jan + Lars

We’re doing rapid reports development and most of our specifications appear to be in a pivot table layout. To answer your question (rendering a pivot: YES). What I’m looking at is finding a way to create dynamic pivots (OLAP/drill-through) and use a template that uses interchangable JSON (but with slight variations on dx values or on pe values)…

Greg

···

On Wed, Mar 18, 2015 at 1:09 PM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Hi Greg, what kind of modifications do you want to make?

I can easily expose a function so that you can test stuff via the Chrome console. But the data needs to follow a specific format, so you will only be able to change the data/values basically.

Jan

On Wed, Mar 18, 2015 at 11:55 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Greg,

you mean you want the JSON string to render a pivot? The problem is that the JSON analytics request only contains the data source for the pivot, not the layout of it.

What you can do is to simply paste the URL into a web browser or use curl to test it, and see how your changes affects output.

best regards,

Lars


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Mar 17, 2015 at 12:10 PM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Devs

Is there any way or planned functionality for testing JSON urls inside of pivot tables? E.g. I set up a pivot table then download the JSON data source but then want to test a modified version of that JSON string inside the current session… is that possible or do-able…?

Greg


Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

Of course I forgot to mention the drill-through filter on OU-level or parent ouUID…

···

On Wed, Mar 18, 2015 at 1:26 PM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Jan + Lars

We’re doing rapid reports development and most of our specifications appear to be in a pivot table layout. To answer your question (rendering a pivot: YES). What I’m looking at is finding a way to create dynamic pivots (OLAP/drill-through) and use a template that uses interchangable JSON (but with slight variations on dx values or on pe values)…

Greg

On Wed, Mar 18, 2015 at 1:09 PM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Hi Greg, what kind of modifications do you want to make?

I can easily expose a function so that you can test stuff via the Chrome console. But the data needs to follow a specific format, so you will only be able to change the data/values basically.

Jan


Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

On Wed, Mar 18, 2015 at 11:55 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Greg,

you mean you want the JSON string to render a pivot? The problem is that the JSON analytics request only contains the data source for the pivot, not the layout of it.

What you can do is to simply paste the URL into a web browser or use curl to test it, and see how your changes affects output.

best regards,

Lars


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Mar 17, 2015 at 12:10 PM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Devs

Is there any way or planned functionality for testing JSON urls inside of pivot tables? E.g. I set up a pivot table then download the JSON data source but then want to test a modified version of that JSON string inside the current session… is that possible or do-able…?

Greg


Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles