Aggregate basic submission 'counter'

Hi - fairly new here, I have been really enjoying getting into ODK so far.
Love the integration with Enketo. Got my server set up on App Engine,
looking forward to a first proper 'field' use in a few months. I am running
ODK collect on a couple of cheap Nook eink readers rooted to Android and
it's great to be able to tell people they can use their own phones /
devices too.

Getting to the point though, I may be completely dense but is there an easy
way of just getting a count of the total finalized submissions in Aggregate

  • without downloading a csv or just sitting there counting lines. Fusion
    tables is a good addition but I'm not too familiar with it, am I just
    missing something obvious? Would it automatically push responses to a Drive
    spreadsheet which you could access on another device?

I've looked into creating a basic app for Android that would just retrieve
this count, (for one form or for many) or possibly 'ping' you when the
responses reached a certain level (10, 100 etc). The Google Cloud
Messenging service seems a possibility.

Thanks for this amazing project!

We didn't provide a count largely because appengine would have incurred an
billing charge as if we did a full scan of all the data. That would very
quickly get very expensive

··· On Apr 2, 2015 5:26 AM, "Richard Fletcher" wrote:

Hi - fairly new here, I have been really enjoying getting into ODK so far.
Love the integration with Enketo. Got my server set up on App Engine,
looking forward to a first proper 'field' use in a few months. I am running
ODK collect on a couple of cheap Nook eink readers rooted to Android and
it's great to be able to tell people they can use their own phones /
devices too.

Getting to the point though, I may be completely dense but is there an
easy way of just getting a count of the total finalized submissions in
Aggregate - without downloading a csv or just sitting there counting lines.
Fusion tables is a good addition but I'm not too familiar with it, am I
just missing something obvious? Would it automatically push responses to a
Drive spreadsheet which you could access on another device?

I've looked into creating a basic app for Android that would just retrieve
this count, (for one form or for many) or possibly 'ping' you when the
responses reached a certain level (10, 100 etc). The Google Cloud
Messenging service seems a possibility.

Thanks for this amazing project!

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

That is an understandable decision, Mitch, thanks.

I think it will be possible via Cloud Monitoring - set an alert for a
certain amount of writes/reads reached, that kind of thing, maybe not a
precise count but sufficient to know when you are reaching the quota, or
just to reassure people that responses are coming in. The Cloud Console
mobile app is pretty cool too.

··· On Thursday, April 2, 2015 at 4:48:36 PM UTC+1, Mitch Sundt wrote: > > We didn't provide a count largely because appengine would have incurred an > billing charge as if we did a full scan of all the data. That would very > quickly get very expensive > On Apr 2, 2015 5:26 AM, "Richard Fletcher" <sku...@hotmail.com > wrote: > >> Hi - fairly new here, I have been really enjoying getting into ODK so >> far. Love the integration with Enketo. Got my server set up on App Engine, >> looking forward to a first proper 'field' use in a few months. I am running >> ODK collect on a couple of cheap Nook eink readers rooted to Android and >> it's great to be able to tell people they can use their own phones / >> devices too. >> >> Getting to the point though, I may be completely dense but is there an >> easy way of just getting a count of the total finalized submissions in >> Aggregate - without downloading a csv or just sitting there counting lines. >> Fusion tables is a good addition but I'm not too familiar with it, am I >> just missing something obvious? Would it automatically push responses to a >> Drive spreadsheet which you could access on another device? >> >> I've looked into creating a basic app for Android that would just >> retrieve this count, (for one form or for many) or possibly 'ping' you when >> the responses reached a certain level (10, 100 etc). The Google Cloud >> Messenging service seems a possibility. >> >> Thanks for this amazing project! >> >> >> -- >> -- >> Post: opend...@googlegroups.com >> Unsubscribe: opendatakit...@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "ODK Community" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to opendatakit...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> >

Just replying to myself here in case anyone has a similar issue/need.

If you link Aggregate to Fusion Tables (existing and streaming new
responses), you can set up a simple chart to count responses (say, the
metadata of meta-is-complete = true) and publish this chart. Fusion tables
will either give you an email link or html to drop into a site. (uses
iframe)

This is a pretty simple way of having some kind of tracking of responses
without logging on and downloading each time. I have found the delay from
Enketo-Aggregate-FusionTables is around or under 10 minutes so it is pretty
much 'live'. Remember to keep an eye on your App Engine quotas and so on!