Hi all,
I am hoping to integrate ODK into use for by M&E teams. What I see as a
biggest hurdle to making the collected data actionable is what happens to
it after it has been collected.
I was wondering how easy/difficult it would be to customize the some of
the functionality of the ODK Aggregate web portal. I know that currently
there are basic analytics built-in, but I think it would be great if it
would be easy to subset (think "filter" function in Excel) and maybe have
the option to have programmed some analytics(and also to "lock" them so
that not all the users can alter them). For example, for submissions to a
particular form, the indicator1 would always be averaged by month
(automaticall y), indicator2 would give summary of all selected options and
corresponding counts (also automatically). Also, it would be awesome if
indicators that are above/below some pre-specified cut-off would light up
in orange/red. Now, I realize that you can do this all in Excel, but
cutting out the extra step of exporting & doing basic analytics would be of
great advantage. It would be absolutely fantastic if M&E staff in the field
could just collect the data, upload it and then inspect the data there with
the analysis done for them while the same view was available to staff in
the home office.
Basically, I am hoping that we could use ODK Briefcase/ODK Aggregate and
just add some bells and whistles to the web portal. I'm not a programmer so
I can't gage how much work that would involve. Is this difficult? What sort
of skills should a programmer who could do this have?
Any advice would be much appreciated!
j
Hello Jitka,
One avenue you might want to explore is telling aggregate to push the
records to google spreadsheet. Then you can use all the spreadsheet
functions there to do some of the coloring and averaging. You could even
further push part of the spreadsheet (the final calculations and
indicators) to a web page.
Curtis
···
2013/7/2 Jitka Hiscox
Hi all,
I am hoping to integrate ODK into use for by M&E teams. What I see as a
biggest hurdle to making the collected data actionable is what happens to
it after it has been collected.
I was wondering how easy/difficult it would be to customize the some of
the functionality of the ODK Aggregate web portal. I know that currently
there are basic analytics built-in, but I think it would be great if it
would be easy to subset (think "filter" function in Excel) and maybe have
the option to have programmed some analytics(and also to "lock" them so
that not all the users can alter them). For example, for submissions to a
particular form, the indicator1 would always be averaged by month
(automaticall y), indicator2 would give summary of all selected options and
corresponding counts (also automatically). Also, it would be awesome if
indicators that are above/below some pre-specified cut-off would light up
in orange/red. Now, I realize that you can do this all in Excel, but
cutting out the extra step of exporting & doing basic analytics would be of
great advantage. It would be absolutely fantastic if M&E staff in the field
could just collect the data, upload it and then inspect the data there with
the analysis done for them while the same view was available to staff in
the home office.
Basically, I am hoping that we could use ODK Briefcase/ODK Aggregate and
just add some bells and whistles to the web portal. I'm not a programmer so
I can't gage how much work that would involve. Is this difficult? What sort
of skills should a programmer who could do this have?
Any advice would be much appreciated!
j
Curtis BRODERICK
Head of training and user support
Tél : + 33(0)1.53.02.40.61 06.15.33.57.37
---------------------------EpiConcept---------------------------
Systèmes d'Information en Santé
Health Information System
47, rue de Charenton - 75012 PARIS
Tel : +33 (0)1 53 02 40 60 Fax : +33 (0)1 53 02 40 62
-----------------------www.epiconcept.fr------------------------
Ce message et toutes les pièces jointes sont établis à l'intention
exclusive de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur, merci de le détruire et d'en
avertir l'expéditeur.
The information contained in the Email and any attachments is
confidential and intended solely and for the attention and use of the
named address(es). It may not be disclosed to any other person without
the express authority of EpiConcept, or the intended recipient, or
both.
If you are not the intended recipient, you must not disclose, copy,
distribute or retain this message or any part of it.
Hey Jitka, not quite what you asked for but you could have a look at using
Formhub (formhub.org) to host your data - much friendlier UI than ODK
Aggregate in my opinion. It seems you can then dynamically link your data
to Bamboo (bambo.io) to perform analytics to your data in real-time. I've
not tried it myself but looking to at some stage. There's an example here
of the sort of thing you could achiever: https://github.com/modilabs/bamboo-examples/blob/master/docs/water_points.rst
Cheers
Martyn
···
On Tuesday, July 2, 2013 3:25:34 AM UTC+1, Jitka Hiscox wrote:
>
> Hi all,
> I am hoping to integrate ODK into use for by M&E teams. What I see as a
> biggest hurdle to making the collected data actionable is what happens to
> it *after* it has been collected.
>
> I was wondering how easy/difficult it would be to customize the some of
> the functionality of the ODK Aggregate web portal. I know that currently
> there are basic analytics built-in, but I think it would be great if it
> would be easy to subset (think "filter" function in Excel) and maybe have
> the option to have programmed some analytics(and also to "lock" them so
> that not all the users can alter them). For example, for submissions to a
> particular form, the indicator1 would always be averaged by month
> (automaticall y), indicator2 would give summary of all selected options and
> corresponding counts (also automatically). Also, it would be awesome if
> indicators that are above/below some pre-specified cut-off would light up
> in orange/red. Now, I realize that you can do this all in Excel, but
> cutting out the extra step of exporting & doing basic analytics would be of
> great advantage. It would be absolutely fantastic if M&E staff in the field
> could just collect the data, upload it and then inspect the data there with
> the analysis done for them while the same view was available to staff in
> the home office.
>
> Basically, I am hoping that we could use ODK Briefcase/ODK Aggregate and
> just add some bells and whistles to the web portal. I'm not a programmer so
> I can't gage how much work that would involve. Is this difficult? What sort
> of skills should a programmer who could do this have?
> Any advice would be much appreciated!
> j
>
--
This message and its attachments are private and confidential. If you have
received this message in error, please notify the sender and remove it and
its attachments from your system.
The University of Westminster is a charity and a company
limited by guarantee. Registration number: 977818 England.
Registered Office: 309 Regent Street, London W1B 2UW.
In general, if you are hosting on Google AppEngine, the datastore we use
there (BigTables) is NOT suitable for performing anything but basic
analytics.
The easiest way to provide analytics is through Google Spreadsheets or
Fusion Tables.
Next easiest is by hosting your own server with Tomcat on a MySQL or
PostgreSQL database, and using an analytics package written for those
databases to directly access the ODK Aggregate tables (read-only), or a
VIEW layered on top of those tables.
We also have an XML (RedCap-ish) publisher, and two JSON publishers for
publishing into other systems that might provide better analytics, but that
likely requires writing some software to facilitate that process.
Mitch
···
On Tue, Jul 2, 2013 at 1:20 AM, Curtis Broderick wrote:
Hello Jitka,
One avenue you might want to explore is telling aggregate to push the
records to google spreadsheet. Then you can use all the spreadsheet
functions there to do some of the coloring and averaging. You could even
further push part of the spreadsheet (the final calculations and
indicators) to a web page.
Curtis
Hi all,
I am hoping to integrate ODK into use for by M&E teams. What I see as a
biggest hurdle to making the collected data actionable is what happens to
it after it has been collected.
I was wondering how easy/difficult it would be to customize the some of
the functionality of the ODK Aggregate web portal. I know that currently
there are basic analytics built-in, but I think it would be great if it
would be easy to subset (think "filter" function in Excel) and maybe have
the option to have programmed some analytics(and also to "lock" them so
that not all the users can alter them). For example, for submissions to a
particular form, the indicator1 would always be averaged by month
(automaticall y), indicator2 would give summary of all selected options and
corresponding counts (also automatically). Also, it would be awesome if
indicators that are above/below some pre-specified cut-off would light up
in orange/red. Now, I realize that you can do this all in Excel, but
cutting out the extra step of exporting & doing basic analytics would be of
great advantage. It would be absolutely fantastic if M&E staff in the field
could just collect the data, upload it and then inspect the data there with
the analysis done for them while the same view was available to staff in
the home office.
Basically, I am hoping that we could use ODK Briefcase/ODK Aggregate and
just add some bells and whistles to the web portal. I'm not a programmer so
I can't gage how much work that would involve. Is this difficult? What sort
of skills should a programmer who could do this have?
Any advice would be much appreciated!
j
Curtis BRODERICK
Head of training and user support
Tél : + 33(0)1.53.02.40.61 06.15.33.57.37
---------------------------EpiConcept---------------------------
Systèmes d'Information en Santé
Health Information System
47, rue de Charenton - 75012 PARIS
Ce message et toutes les pièces jointes sont établis à l'intention exclusive de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur, merci de le détruire et d'en avertir l'expéditeur.
The information contained in the Email and any attachments is confidential and intended solely and for the attention and use of the
named address(es). It may not be disclosed to any other person without the express authority of EpiConcept, or the intended recipient, or both.
If you are not the intended recipient, you must not disclose, copy, distribute or retain this message or any part of it.
Thank you all for your responses. That was incredibly helpful!
j
···
On Wed, Jul 3, 2013 at 4:37 AM, marty wrote:
Hey Jitka, not quite what you asked for but you could have a look at using
Formhub (formhub.org) to host your data - much friendlier UI than ODK
Aggregate in my opinion. It seems you can then dynamically link your data
to Bamboo (bambo.io) to perform analytics to your data in real-time. I've
not tried it myself but looking to at some stage. There's an example here
of the sort of thing you could achiever: https://github.com/modilabs/bamboo-examples/blob/master/docs/water_points.rst
Cheers
Martyn
On Tuesday, July 2, 2013 3:25:34 AM UTC+1, Jitka Hiscox wrote:
Hi all,
I am hoping to integrate ODK into use for by M&E teams. What I see as a
biggest hurdle to making the collected data actionable is what happens to
it after it has been collected.
I was wondering how easy/difficult it would be to customize the some of
the functionality of the ODK Aggregate web portal. I know that currently
there are basic analytics built-in, but I think it would be great if it
would be easy to subset (think "filter" function in Excel) and maybe have
the option to have programmed some analytics(and also to "lock" them so
that not all the users can alter them). For example, for submissions to a
particular form, the indicator1 would always be averaged by month
(automaticall y), indicator2 would give summary of all selected options and
corresponding counts (also automatically). Also, it would be awesome if
indicators that are above/below some pre-specified cut-off would light up
in orange/red. Now, I realize that you can do this all in Excel, but
cutting out the extra step of exporting & doing basic analytics would be of
great advantage. It would be absolutely fantastic if M&E staff in the field
could just collect the data, upload it and then inspect the data there with
the analysis done for them while the same view was available to staff in
the home office.
Basically, I am hoping that we could use ODK Briefcase/ODK Aggregate and
just add some bells and whistles to the web portal. I'm not a programmer so
I can't gage how much work that would involve. Is this difficult? What sort
of skills should a programmer who could do this have?
Any advice would be much appreciated!
j
This message and its attachments are private and confidential. If you have
received this message in error, please notify the sender and remove it and
its attachments from your system.
The University of Westminster is a charity and a company
limited by guarantee. Registration number: 977818 En**gland.
Registered Office: 309 Regent **Street, London W1B 2UW.