Google Motion Chart (Gapminder) connected to DHIS 2 report tables

I have quickly set up a proof of concept (using PHP) for displaying DHIS 2 indicators in Google Motion Charts here:

http://97.107.142.53/mc/index.php

I don’t know (and doubt) that this will work offline (the current solution relies on Google’s servers to provide a Javascript API and serve the Flash app).

Reference:

http://code.google.com/apis/visualization/documentation/gallery/motionchart.html#Motion_Chart_initial_state

I attach my PHP code, which I hope can serve as inspiration for someone on our team (India? VN?) to implement the same functionality as a DHIS web module in Java.

Knut

index2.php (2.36 KB)

Overview codes, it’s really exciting and attractive ! But not understand this motion chart too much …

···

On Sat, Oct 10, 2009 at 11:41 PM, Knut Staring knutst@gmail.com wrote:

I have quickly set up a proof of concept (using PHP) for displaying DHIS 2 indicators in Google Motion Charts here:
http://97.107.142.53/mc/index.php

I don’t know (and doubt) that this will work offline (the current solution relies on Google’s servers to provide a Javascript API and serve the Flash app).

Reference:

http://code.google.com/apis/visualization/documentation/gallery/motionchart.html#Motion_Chart_initial_state

I attach my PHP code, which I hope can serve as inspiration for someone on our team (India? VN?) to implement the same functionality as a DHIS web module in Java.

Knut


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


Hieu.HISPVietnam
Good Health !

Hi Knut,

I think Bharath has written a module that takes the data and indicators from DHIS2 and displays a motion chart. The only quirk is that you have to be online to be able to see the motion chart, which is a Google lockin to be able to use its docs API.

···

Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

2009/10/10 Knut Staring knutst@gmail.com

I have quickly set up a proof of concept (using PHP) for displaying DHIS 2 indicators in Google Motion Charts here:
http://97.107.142.53/mc/index.php

I don’t know (and doubt) that this will work offline (the current solution relies on Google’s servers to provide a Javascript API and serve the Flash app).

Reference:

http://code.google.com/apis/visualization/documentation/gallery/motionchart.html#Motion_Chart_initial_state

I attach my PHP code, which I hope can serve as inspiration for someone on our team (India? VN?) to implement the same functionality as a DHIS web module in Java.

Knut


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

I think Bharath has written a module that takes the data and indicators from DHIS2 and displays a motion chart. The only quirk is that you have to be online to be able to see the motion chart, which is a Google lockin to be able to use its docs API.

RIght, that’s what I thought. Is that module available somewhere? Any reason its existence has not been communicated widely?

Knut

···

On Sat, Oct 10, 2009 at 9:14 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:


Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

2009/10/10 Knut Staring knutst@gmail.com

I have quickly set up a proof of concept (using PHP) for displaying DHIS 2 indicators in Google Motion Charts here:
http://97.107.142.53/mc/index.php

I don’t know (and doubt) that this will work offline (the current solution relies on Google’s servers to provide a Javascript API and serve the Flash app).

Reference:

http://code.google.com/apis/visualization/documentation/gallery/motionchart.html#Motion_Chart_initial_state

I attach my PHP code, which I hope can serve as inspiration for someone on our team (India? VN?) to implement the same functionality as a DHIS web module in Java.

Knut


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


Cheers,
Knut Staring

Its experimental I think or even complete perhaps… but I wouldn’t like to add anymore. May be bharath had a better launch in mind…

Sorry Bharath, if you had other things to say!..

···

Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

2009/10/11 Knut Staring knutst@gmail.com

On Sat, Oct 10, 2009 at 9:14 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:

Hi Knut,

I think Bharath has written a module that takes the data and indicators from DHIS2 and displays a motion chart. The only quirk is that you have to be online to be able to see the motion chart, which is a Google lockin to be able to use its docs API.

RIght, that’s what I thought. Is that module available somewhere? Any reason its existence has not been communicated widely?

Knut


Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

2009/10/10 Knut Staring knutst@gmail.com

I have quickly set up a proof of concept (using PHP) for displaying DHIS 2 indicators in Google Motion Charts here:
http://97.107.142.53/mc/index.php

I don’t know (and doubt) that this will work offline (the current solution relies on Google’s servers to provide a Javascript API and serve the Flash app).

Reference:

http://code.google.com/apis/visualization/documentation/gallery/motionchart.html#Motion_Chart_initial_state

I attach my PHP code, which I hope can serve as inspiration for someone on our team (India? VN?) to implement the same functionality as a DHIS web module in Java.

Knut


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


Cheers,
Knut Staring

Overview codes, it’s really exciting and attractive ! But not understand this motion chart too much …

Glad you like it, Hieu! I agree with you that my particular example is not very intuitive, and probably needs more tweaking - I just didn’t find it meaningful to take this much further now, as it rather has to be integrated with the DHIS 2 user interface - and use the DHIS 2 API (or webservices) rather than php.

Note that you can configure it much more than I did in the state variable at the end of the code. To see possible options, select a view you like in the Chart, then click on the wrench symbol in the lower right corner and then click Advanced (below to the left). This will display particular selections, e.g. like this:

{“dimensions”:{“iconDimensions”:[“dim0”]},“nonSelectedAlpha”:0.9,“orderedByX”:false,“xZoomedDataMax”:106.79433694857032,“iconType”:“BUBBLE”,“showTrails”:true,“uniColorForNonSelected”:false,“yLambda”:1,“duration”:{“timeUnit”:“D”,“multiplier”:1},“yZoomedDataMax”:38.243011456628494,“time”:“2008-04-01”,“sizeOption”:“_UNISIZE”,“xLambda”:1,“xZoomedDataMin”:88.9394191000742,“yZoomedDataMin”:-5.012307692307691,“stateVersion”:3,“xAxisOption”:“2”,“playDuration”:15,“iconKeySettings”:[{“trailStart”:“2008-01-17T12:32:38.400”,“key”:{“dim0”:“Kenema”}}],“yAxisOption”:“3”,“yZoomedIn”:true,“xZoomedIn”:true,“orderedByY”:false,“colorOption”:“4”}

Knut

···

On Sat, Oct 10, 2009 at 8:50 PM, Hieu Dang Duy hieu.hispvietnam@gmail.com wrote:

On Sat, Oct 10, 2009 at 11:41 PM, Knut Staring knutst@gmail.com wrote:

I have quickly set up a proof of concept (using PHP) for displaying DHIS 2 indicators in Google Motion Charts here:
http://97.107.142.53/mc/index.php

I don’t know (and doubt) that this will work offline (the current solution relies on Google’s servers to provide a Javascript API and serve the Flash app).

Reference:

http://code.google.com/apis/visualization/documentation/gallery/motionchart.html#Motion_Chart_initial_state

I attach my PHP code, which I hope can serve as inspiration for someone on our team (India? VN?) to implement the same functionality as a DHIS web module in Java.

Knut


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


Hieu.HISPVietnam
Good Health !


Cheers,
Knut Staring

Gapminder was discussed during the Goa workshop in July, here is a relevant cut from the summary that was sent out by Sundeep:

···

“GapMinder was presented by Greg Rowles from HISP South Africa. This is a very interesting data visualization tool that has been developed by Dr. Hans Rossling’s group from Karolinska Institute, in Sweden. Basically, the tool allows for a dynamic visualization of two related variables in relation to a reference variable such as population which is depicted as bubbles with the size of it indicating the relative values. It was pointed out that this tool is an online system that draws upon google serves. Saptarishi pointed out that this can be subverted by caching the google services for the particular country that is being analyzed. Bob pointed out to potential intellectual property infringement concerns. The tool was liked significantly by all, and it was agreed that Bharath and Saptarishi would explore how it may be integrated with the dashboard of DHIS2.”


Greg told us that in SA they have been working with Gapminder integration and if I remember correctly have a copy of the code for the previous (pre Google?) version of the app.

I though this was called Google trend analyser now. Is Google motion charts just the same thing or different somehow?

Ola

2009/10/10 Knut Staring knutst@gmail.com

On Sat, Oct 10, 2009 at 9:14 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:

Hi Knut,

I think Bharath has written a module that takes the data and indicators from DHIS2 and displays a motion chart. The only quirk is that you have to be online to be able to see the motion chart, which is a Google lockin to be able to use its docs API.

RIght, that’s what I thought. Is that module available somewhere? Any reason its existence has not been communicated widely?

Knut


Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India

Health Information Systems Programme

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

2009/10/10 Knut Staring knutst@gmail.com

I have quickly set up a proof of concept (using PHP) for displaying DHIS 2 indicators in Google Motion Charts here:
http://97.107.142.53/mc/index.php

I don’t know (and doubt) that this will work offline (the current solution relies on Google’s servers to provide a Javascript API and serve the Flash app).

Reference:

http://code.google.com/apis/visualization/documentation/gallery/motionchart.html#Motion_Chart_initial_state

I attach my PHP code, which I hope can serve as inspiration for someone on our team (India? VN?) to implement the same functionality as a DHIS web module in Java.

Knut


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


Cheers,
Knut Staring


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

Gapminder was discussed during the Goa workshop in July, here is a relevant cut from the summary that was sent out by Sundeep:


“GapMinder was presented by Greg Rowles from HISP South Africa. This is a very interesting data visualization tool that has been developed by Dr. Hans Rossling’s group from Karolinska Institute, in Sweden. Basically, the tool allows for a dynamic visualization of two related variables in relation to a reference variable such as population which is depicted as bubbles with the size of it indicating the relative values. It was pointed out that this tool is an online system that draws upon google serves. Saptarishi pointed out that this can be subverted by caching the google services for the particular country that is being analyzed. Bob pointed out to potential intellectual property infringement concerns. The tool was liked significantly by all, and it was agreed that Bharath and Saptarishi would explore how it may be integrated with the dashboard of DHIS2.”


Ok, I had not read this, obviously. Has any progress been made? Some thinking may be required on how to best integrate - I chose report tables because in a motion chart you obviously want to have more than one numerical variable (i.e. a crosstab of indicators or data elements). It would make sense to relate this to the current JFreeChart options. And also make all charting possibilities readily available from other places in DHIS 2, such as from data entry, since people would often like to visualize what they have just painstakingly entered.

We certainly should look at offline caching possibilities. But I don’t think it is a showstopper to have to be online either - we have many users who are. Here is a range of other interactive charts we should evaluate for suitability:

http://www.amcharts.com/ (not FOSS, but free with a small logo, works offline)

http://chart.inetsoft.com/gallery.html

http://www.ajaxline.com/10-best-flash-and-silverlight-chart-controls

http://www.swivel.com/

Greg told us that in SA they have been working with Gapminder integration and if I remember correctly have a copy of the code for the previous (pre Google?) version of the app.

I though this was called Google trend analyser now. Is Google motion charts just the same thing or different somehow?

Motion Charts is the new name of Trendalyzer:

http://blogstats.wordpress.com/2008/04/13/trendalyzer-becomes-motion-chart/

Here is a good recent article on motion chart use:

http://searchengineland.com/how-to-use-google-analytics-motion-charts-to-maximize-results-24146

Here is a java plugin for motion chart, with source code:

http://docs.codehaus.org/display/SONAR/Motion+Chart+plugin

On that note, we also really have to improve our ability to easily import data from various sources - which people will very much want to do now that we have excellent GIS and charting capabilities. I found the Swivel Toolbar for Excel to be helpful in transforming crosstabbed matrix data into relational table format, but that is just the first step.

http://www.google.ch/search?q=swivel+toolbar

Knut

···

On Sun, Oct 11, 2009 at 1:20 AM, Ola Hodne Titlestad olatitle@gmail.com wrote:

Ola

2009/10/10 Knut Staring knutst@gmail.com

On Sat, Oct 10, 2009 at 9:14 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:

Hi Knut,

I think Bharath has written a module that takes the data and indicators from DHIS2 and displays a motion chart. The only quirk is that you have to be online to be able to see the motion chart, which is a Google lockin to be able to use its docs API.

RIght, that’s what I thought. Is that module available somewhere? Any reason its existence has not been communicated widely?

Knut


Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India

Health Information Systems Programme

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

2009/10/10 Knut Staring knutst@gmail.com

I have quickly set up a proof of concept (using PHP) for displaying DHIS 2 indicators in Google Motion Charts here:
http://97.107.142.53/mc/index.php

I don’t know (and doubt) that this will work offline (the current solution relies on Google’s servers to provide a Javascript API and serve the Flash app).

Reference:

http://code.google.com/apis/visualization/documentation/gallery/motionchart.html#Motion_Chart_initial_state

I attach my PHP code, which I hope can serve as inspiration for someone on our team (India? VN?) to implement the same functionality as a DHIS web module in Java.

Knut


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


Cheers,
Knut Staring


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


Cheers,
Knut Staring

Hi Knut

Sorry to come into this conversation so late. The Gap-Minder software seemed really powerful but it came with too many strings attached (we were promised a free license but with a recurring data administration fee).

We’ve started using google-motioncharts instead. If there are any developments on the use of their software though - I’ll make sure you know about it…

Regards,

Greg

···

On Sun, Oct 11, 2009 at 8:47 AM, Knut Staring knutst@gmail.com wrote:

On Sun, Oct 11, 2009 at 1:20 AM, Ola Hodne Titlestad olatitle@gmail.com wrote:

Gapminder was discussed during the Goa workshop in July, here is a relevant cut from the summary that was sent out by Sundeep:


“GapMinder was presented by Greg Rowles from HISP South Africa. This is a very interesting data visualization tool that has been developed by Dr. Hans Rossling’s group from Karolinska Institute, in Sweden. Basically, the tool allows for a dynamic visualization of two related variables in relation to a reference variable such as population which is depicted as bubbles with the size of it indicating the relative values. It was pointed out that this tool is an online system that draws upon google serves. Saptarishi pointed out that this can be subverted by caching the google services for the particular country that is being analyzed. Bob pointed out to potential intellectual property infringement concerns. The tool was liked significantly by all, and it was agreed that Bharath and Saptarishi would explore how it may be integrated with the dashboard of DHIS2.”


Ok, I had not read this, obviously. Has any progress been made? Some thinking may be required on how to best integrate - I chose report tables because in a motion chart you obviously want to have more than one numerical variable (i.e. a crosstab of indicators or data elements). It would make sense to relate this to the current JFreeChart options. And also make all charting possibilities readily available from other places in DHIS 2, such as from data entry, since people would often like to visualize what they have just painstakingly entered.

We certainly should look at offline caching possibilities. But I don’t think it is a showstopper to have to be online either - we have many users who are. Here is a range of other interactive charts we should evaluate for suitability:

http://www.amcharts.com/ (not FOSS, but free with a small logo, works offline)

http://chart.inetsoft.com/gallery.html

http://www.ajaxline.com/10-best-flash-and-silverlight-chart-controls

http://www.swivel.com/

Greg told us that in SA they have been working with Gapminder integration and if I remember correctly have a copy of the code for the previous (pre Google?) version of the app.

I though this was called Google trend analyser now. Is Google motion charts just the same thing or different somehow?

Motion Charts is the new name of Trendalyzer:

http://blogstats.wordpress.com/2008/04/13/trendalyzer-becomes-motion-chart/

Here is a good recent article on motion chart use:

http://searchengineland.com/how-to-use-google-analytics-motion-charts-to-maximize-results-24146

Here is a java plugin for motion chart, with source code:

http://docs.codehaus.org/display/SONAR/Motion+Chart+plugin

On that note, we also really have to improve our ability to easily import data from various sources - which people will very much want to do now that we have excellent GIS and charting capabilities. I found the Swivel Toolbar for Excel to be helpful in transforming crosstabbed matrix data into relational table format, but that is just the first step.

http://www.google.ch/search?q=swivel+toolbar

Knut

Ola

2009/10/10 Knut Staring knutst@gmail.com

On Sat, Oct 10, 2009 at 9:14 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:

Hi Knut,

I think Bharath has written a module that takes the data and indicators from DHIS2 and displays a motion chart. The only quirk is that you have to be online to be able to see the motion chart, which is a Google lockin to be able to use its docs API.

RIght, that’s what I thought. Is that module available somewhere? Any reason its existence has not been communicated widely?

Knut


Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

2009/10/10 Knut Staring knutst@gmail.com

I have quickly set up a proof of concept (using PHP) for displaying DHIS 2 indicators in Google Motion Charts here:
http://97.107.142.53/mc/index.php

I don’t know (and doubt) that this will work offline (the current solution relies on Google’s servers to provide a Javascript API and serve the Flash app).

Reference:

http://code.google.com/apis/visualization/documentation/gallery/motionchart.html#Motion_Chart_initial_state

I attach my PHP code, which I hope can serve as inspiration for someone on our team (India? VN?) to implement the same functionality as a DHIS web module in Java.

Knut


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


Cheers,
Knut Staring


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


Cheers,

Knut Staring


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


Mobile 1: 082 041 6065
Mobile 2: 073 246 2992
Landline: 021 554 3130
Fax: 086 663 3812
Skype: gregory_rowles

HISP-SA: Software Development
www.hisp.org

Hi Knut

Sorry to come into this conversation so late. The Gap-Minder software seemed really powerful but it came with too many strings attached (we were promised a free license but with a recurring data administration fee).

We’ve started using google-motioncharts instead. If there are any developments on the use of their software though - I’ll make sure you know about it…

Thanks Greg.

Have you made an integration of DHIS 1.4 and GMC similar to what I did with PHP, or do you upload data to a Google spreadsheet?

Knut

···

On Wed, Oct 14, 2009 at 3:12 PM, Greg Rowles greg.rowles@gmail.com wrote:

Regards,

Greg

On Sun, Oct 11, 2009 at 8:47 AM, Knut Staring knutst@gmail.com wrote:

On Sun, Oct 11, 2009 at 1:20 AM, Ola Hodne Titlestad olatitle@gmail.com wrote:

Gapminder was discussed during the Goa workshop in July, here is a relevant cut from the summary that was sent out by Sundeep:


“GapMinder was presented by Greg Rowles from HISP South Africa. This is a very interesting data visualization tool that has been developed by Dr. Hans Rossling’s group from Karolinska Institute, in Sweden. Basically, the tool allows for a dynamic visualization of two related variables in relation to a reference variable such as population which is depicted as bubbles with the size of it indicating the relative values. It was pointed out that this tool is an online system that draws upon google serves. Saptarishi pointed out that this can be subverted by caching the google services for the particular country that is being analyzed. Bob pointed out to potential intellectual property infringement concerns. The tool was liked significantly by all, and it was agreed that Bharath and Saptarishi would explore how it may be integrated with the dashboard of DHIS2.”


Ok, I had not read this, obviously. Has any progress been made? Some thinking may be required on how to best integrate - I chose report tables because in a motion chart you obviously want to have more than one numerical variable (i.e. a crosstab of indicators or data elements). It would make sense to relate this to the current JFreeChart options. And also make all charting possibilities readily available from other places in DHIS 2, such as from data entry, since people would often like to visualize what they have just painstakingly entered.

We certainly should look at offline caching possibilities. But I don’t think it is a showstopper to have to be online either - we have many users who are. Here is a range of other interactive charts we should evaluate for suitability:

http://www.amcharts.com/ (not FOSS, but free with a small logo, works offline)

http://chart.inetsoft.com/gallery.html

http://www.ajaxline.com/10-best-flash-and-silverlight-chart-controls

http://www.swivel.com/

Greg told us that in SA they have been working with Gapminder integration and if I remember correctly have a copy of the code for the previous (pre Google?) version of the app.

I though this was called Google trend analyser now. Is Google motion charts just the same thing or different somehow?

Motion Charts is the new name of Trendalyzer:

http://blogstats.wordpress.com/2008/04/13/trendalyzer-becomes-motion-chart/

Here is a good recent article on motion chart use:

http://searchengineland.com/how-to-use-google-analytics-motion-charts-to-maximize-results-24146

Here is a java plugin for motion chart, with source code:

http://docs.codehaus.org/display/SONAR/Motion+Chart+plugin

On that note, we also really have to improve our ability to easily import data from various sources - which people will very much want to do now that we have excellent GIS and charting capabilities. I found the Swivel Toolbar for Excel to be helpful in transforming crosstabbed matrix data into relational table format, but that is just the first step.

http://www.google.ch/search?q=swivel+toolbar

Knut

Ola

2009/10/10 Knut Staring knutst@gmail.com

On Sat, Oct 10, 2009 at 9:14 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:

Hi Knut,

I think Bharath has written a module that takes the data and indicators from DHIS2 and displays a motion chart. The only quirk is that you have to be online to be able to see the motion chart, which is a Google lockin to be able to use its docs API.

RIght, that’s what I thought. Is that module available somewhere? Any reason its existence has not been communicated widely?

Knut


Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

2009/10/10 Knut Staring knutst@gmail.com

I have quickly set up a proof of concept (using PHP) for displaying DHIS 2 indicators in Google Motion Charts here:
http://97.107.142.53/mc/index.php

I don’t know (and doubt) that this will work offline (the current solution relies on Google’s servers to provide a Javascript API and serve the Flash app).

Reference:

http://code.google.com/apis/visualization/documentation/gallery/motionchart.html#Motion_Chart_initial_state

I attach my PHP code, which I hope can serve as inspiration for someone on our team (India? VN?) to implement the same functionality as a DHIS web module in Java.

Knut


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


Cheers,
Knut Staring


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

Cheers,

Knut Staring


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

Mobile 1: 082 041 6065
Mobile 2: 073 246 2992
Landline: 021 554 3130
Fax: 086 663 3812
Skype: gregory_rowles

HISP-SA: Software Development
www.hisp.org


Cheers,
Knut Staring

Currently we’re using the same client-script method (although we haven’t finalised our approach). FYI - the Gapminder sample data I presented used google docs - a definate disadvantage to google client-script approach!

···

On Wed, Oct 14, 2009 at 5:54 PM, Knut Staring knutst@gmail.com wrote:

On Wed, Oct 14, 2009 at 3:12 PM, Greg Rowles greg.rowles@gmail.com wrote:

Hi Knut

Sorry to come into this conversation so late. The Gap-Minder software seemed really powerful but it came with too many strings attached (we were promised a free license but with a recurring data administration fee).

We’ve started using google-motioncharts instead. If there are any developments on the use of their software though - I’ll make sure you know about it…

Thanks Greg.

Have you made an integration of DHIS 1.4 and GMC similar to what I did with PHP, or do you upload data to a Google spreadsheet?

Knut

Regards,

Greg

On Sun, Oct 11, 2009 at 8:47 AM, Knut Staring knutst@gmail.com wrote:

On Sun, Oct 11, 2009 at 1:20 AM, Ola Hodne Titlestad olatitle@gmail.com wrote:

Gapminder was discussed during the Goa workshop in July, here is a relevant cut from the summary that was sent out by Sundeep:


“GapMinder was presented by Greg Rowles from HISP South Africa. This is a very interesting data visualization tool that has been developed by Dr. Hans Rossling’s group from Karolinska Institute, in Sweden. Basically, the tool allows for a dynamic visualization of two related variables in relation to a reference variable such as population which is depicted as bubbles with the size of it indicating the relative values. It was pointed out that this tool is an online system that draws upon google serves. Saptarishi pointed out that this can be subverted by caching the google services for the particular country that is being analyzed. Bob pointed out to potential intellectual property infringement concerns. The tool was liked significantly by all, and it was agreed that Bharath and Saptarishi would explore how it may be integrated with the dashboard of DHIS2.”


Ok, I had not read this, obviously. Has any progress been made? Some thinking may be required on how to best integrate - I chose report tables because in a motion chart you obviously want to have more than one numerical variable (i.e. a crosstab of indicators or data elements). It would make sense to relate this to the current JFreeChart options. And also make all charting possibilities readily available from other places in DHIS 2, such as from data entry, since people would often like to visualize what they have just painstakingly entered.

We certainly should look at offline caching possibilities. But I don’t think it is a showstopper to have to be online either - we have many users who are. Here is a range of other interactive charts we should evaluate for suitability:

http://www.amcharts.com/ (not FOSS, but free with a small logo, works offline)

http://chart.inetsoft.com/gallery.html

http://www.ajaxline.com/10-best-flash-and-silverlight-chart-controls

http://www.swivel.com/

Greg told us that in SA they have been working with Gapminder integration and if I remember correctly have a copy of the code for the previous (pre Google?) version of the app.

I though this was called Google trend analyser now. Is Google motion charts just the same thing or different somehow?

Motion Charts is the new name of Trendalyzer:

http://blogstats.wordpress.com/2008/04/13/trendalyzer-becomes-motion-chart/

Here is a good recent article on motion chart use:

http://searchengineland.com/how-to-use-google-analytics-motion-charts-to-maximize-results-24146

Here is a java plugin for motion chart, with source code:

http://docs.codehaus.org/display/SONAR/Motion+Chart+plugin

On that note, we also really have to improve our ability to easily import data from various sources - which people will very much want to do now that we have excellent GIS and charting capabilities. I found the Swivel Toolbar for Excel to be helpful in transforming crosstabbed matrix data into relational table format, but that is just the first step.

http://www.google.ch/search?q=swivel+toolbar

Knut

Ola

2009/10/10 Knut Staring knutst@gmail.com

On Sat, Oct 10, 2009 at 9:14 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:

Hi Knut,

I think Bharath has written a module that takes the data and indicators from DHIS2 and displays a motion chart. The only quirk is that you have to be online to be able to see the motion chart, which is a Google lockin to be able to use its docs API.

RIght, that’s what I thought. Is that module available somewhere? Any reason its existence has not been communicated widely?

Knut


Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

2009/10/10 Knut Staring knutst@gmail.com

I have quickly set up a proof of concept (using PHP) for displaying DHIS 2 indicators in Google Motion Charts here:
http://97.107.142.53/mc/index.php

I don’t know (and doubt) that this will work offline (the current solution relies on Google’s servers to provide a Javascript API and serve the Flash app).

Reference:

http://code.google.com/apis/visualization/documentation/gallery/motionchart.html#Motion_Chart_initial_state

I attach my PHP code, which I hope can serve as inspiration for someone on our team (India? VN?) to implement the same functionality as a DHIS web module in Java.

Knut


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


Cheers,
Knut Staring


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


Cheers,

Knut Staring


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

Mobile 1: 082 041 6065
Mobile 2: 073 246 2992
Landline: 021 554 3130
Fax: 086 663 3812
Skype: gregory_rowles

HISP-SA: Software Development
www.hisp.org


Cheers,
Knut Staring


Mobile 1: 082 041 6065
Mobile 2: 073 246 2992
Landline: 021 554 3130
Fax: 086 663 3812
Skype: gregory_rowles

HISP-SA: Software Development
www.hisp.org

A reminder that we need to integrate Google Motion Charts into DHIS2:

http://www.ted.com/talks/view/id/620

···

On Sun, Oct 11, 2009 at 7:47 AM, Knut Staring knutst@gmail.com wrote:

On Sun, Oct 11, 2009 at 1:20 AM, Ola Hodne Titlestad olatitle@gmail.com wrote:

Gapminder was discussed during the Goa workshop in July, here is a relevant cut from the summary that was sent out by Sundeep:


“GapMinder was presented by Greg Rowles from HISP South Africa. This is a very interesting data visualization tool that has been developed by Dr. Hans Rossling’s group from Karolinska Institute, in Sweden. Basically, the tool allows for a dynamic visualization of two related variables in relation to a reference variable such as population which is depicted as bubbles with the size of it indicating the relative values. It was pointed out that this tool is an online system that draws upon google serves. Saptarishi pointed out that this can be subverted by caching the google services for the particular country that is being analyzed. Bob pointed out to potential intellectual property infringement concerns. The tool was liked significantly by all, and it was agreed that Bharath and Saptarishi would explore how it may be integrated with the dashboard of DHIS2.”


Ok, I had not read this, obviously. Has any progress been made? Some thinking may be required on how to best integrate - I chose report tables because in a motion chart you obviously want to have more than one numerical variable (i.e. a crosstab of indicators or data elements). It would make sense to relate this to the current JFreeChart options. And also make all charting possibilities readily available from other places in DHIS 2, such as from data entry, since people would often like to visualize what they have just painstakingly entered.

We certainly should look at offline caching possibilities. But I don’t think it is a showstopper to have to be online either - we have many users who are. Here is a range of other interactive charts we should evaluate for suitability:

http://www.amcharts.com/ (not FOSS, but free with a small logo, works offline)

http://chart.inetsoft.com/gallery.html

http://www.ajaxline.com/10-best-flash-and-silverlight-chart-controls

http://www.swivel.com/

Greg told us that in SA they have been working with Gapminder integration and if I remember correctly have a copy of the code for the previous (pre Google?) version of the app.

I though this was called Google trend analyser now. Is Google motion charts just the same thing or different somehow?

Motion Charts is the new name of Trendalyzer:

http://blogstats.wordpress.com/2008/04/13/trendalyzer-becomes-motion-chart/

Here is a good recent article on motion chart use:

http://searchengineland.com/how-to-use-google-analytics-motion-charts-to-maximize-results-24146

Here is a java plugin for motion chart, with source code:

http://docs.codehaus.org/display/SONAR/Motion+Chart+plugin

On that note, we also really have to improve our ability to easily import data from various sources - which people will very much want to do now that we have excellent GIS and charting capabilities. I found the Swivel Toolbar for Excel to be helpful in transforming crosstabbed matrix data into relational table format, but that is just the first step.

http://www.google.ch/search?q=swivel+toolbar

Knut

Ola

2009/10/10 Knut Staring knutst@gmail.com

On Sat, Oct 10, 2009 at 9:14 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:

Hi Knut,

I think Bharath has written a module that takes the data and indicators from DHIS2 and displays a motion chart. The only quirk is that you have to be online to be able to see the motion chart, which is a Google lockin to be able to use its docs API.

RIght, that’s what I thought. Is that module available somewhere? Any reason its existence has not been communicated widely?

Knut


Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India

Health Information Systems Programme

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

2009/10/10 Knut Staring knutst@gmail.com

I have quickly set up a proof of concept (using PHP) for displaying DHIS 2 indicators in Google Motion Charts here:
http://97.107.142.53/mc/index.php

I don’t know (and doubt) that this will work offline (the current solution relies on Google’s servers to provide a Javascript API and serve the Flash app).

Reference:

http://code.google.com/apis/visualization/documentation/gallery/motionchart.html#Motion_Chart_initial_state

I attach my PHP code, which I hope can serve as inspiration for someone on our team (India? VN?) to implement the same functionality as a DHIS web module in Java.

Knut


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


Cheers,
Knut Staring


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


Cheers,
Knut Staring


Cheers,
Knut Staring

Hi Knut, Vincent and Everyone

I have still not heard any more from the GapMinder team on our free license of their software (they have not responded to any communications since late August), seems like empty promises on their part. In South Africa we are moving ahead with Google-Motion charts incorporated in our DHIS 1.4 intranet reporting module. As it was not part of our original project spec it has not been high on our priority list but that will change just as soon as phase 2 of the project is completed. That will be in the next 2 weeks...

Kind Regards
Greg

···

Sent via my BlackBerry from Vodacom - let your email find you!

-----Original Message-----
From: Knut Staring <knutst@gmail.com>
Date: Thu, 19 Nov 2009 09:26:28
To: Ola Hodne Titlestad<olatitle@gmail.com>
Cc: Sundeep Sahay<sundeep.sahay@yahoo.com>; DHIS 2 developers<dhis2-devs@lists.launchpad.net>; Vincent Shaw<vpshaw@gmail.com>; Calle Hedberg<chedberg@telkomsa.net>
Subject: Re: [Dhis2-devs] Google Motion Chart (Gapminder) connected to DHIS
  2 report tables

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help