Streaming Data to Google Spreadsheet

Hi Folks,

I am a real beginner with regard to these technologies . I am using Collect
v1.1.7-RC1 and Aggregate v1.0-RC2 on the Google App Engine to collect data
and publish it to a Google Spreadsheet. I use 'Sign in with Google' to
access Aggregate, the account being the same as the account that contains
the Spreadsheet file to which I want to publish. When I set up publishing
to Google Spreadsheet, I provide a filename and select the option 'Both
Upload Existing And Stream New'. I am then presented with the response from
Google accounts stating that anonymous is requesting access to my Google
Account with a recommendation to 'Deny access'. If I grant Access the data
is published to Google Spreadsheet but subsequent streaming of new Aggregate
entries does not appended to the Google Spreadsheet. I do not fully
enderstand the GAE dashboard but there seems to be substantial activity
under the following load headings although only 3 or 4 records were
submitted via ODK collect in the past 24 hours ie ODK may be trying to
access Google Spreadsheet repeatedly?

                                                        Requests     Avg

CPU(API) % CPU

                               Last 14hr   last hr              last 14

hr

/gae/uploadSubmissionTask 2.51K (742(652)
54%

/gae/watchdog 278 4918
(4563) 36%

From the above it appears that I need to resolve a security issue to comply
with Google's requirements in order to use Aggregate to append records
automatically to the Spreadsheet, but despite researching this I have no
idea how to resolve it.

I have read that I need to upload a HTML file generated by Google to verify
specific 'ownership', but I do not know how to access and upload a this
single file to the to the root directory of Appspot or indeed if this is the
correct solution or possible, or is there some other way or is some other
approach that I have missed.

I would greatly appreciate any advice, observations or words of wisdom that
you might be able to offer as to how I might deal with this issue.

Thanking you in advance.

Kind Regards

Gerard Martin

Check the logs (click Logs on the left margin) and look for errors during
the uploadSubmissionTask. By default, the logs will only show errors. If
you're using RC2 (see below), send me the errors, or, from the Appengine
management screen, go to Administration / Permissions and invite me to be
an owner of your appspot instance, and I can look myself.

It may be that you are using the Beta 2 and not the RC2. Does your
Aggregate instance have separate "Form Management" and "Site Admin" tabs?
If not, then you are using Beta 2, and publishing is broken due to a Google
infrastructure change; there is no upgrade path from the Beta 2 to the
Release Candidates (we are currently on RC 4). Your only recourse is to
export your data and media files using the Briefcase applet, accessible
from the Beta 2 at
http://your-app-id.appspot.com/Briefcase

Mitch

··· On Mon, Oct 31, 2011 at 3:35 PM, qs1 wrote:

Hi Folks,****

I am a real beginner with regard to these technologies . I am using
Collect v1.1.7-RC1 and Aggregate v1.0-RC2 on the Google App Engine to
collect data and publish it to a Google Spreadsheet. I use ‘Sign in with
Google’ to access Aggregate, the account being the same as the account that
contains the Spreadsheet file to which I want to publish. When I set up
publishing to Google Spreadsheet, I provide a filename and select the
option ‘Both Upload Existing And Stream New’. I am then presented with the
response from Google accounts stating that anonymous is requesting access
to my Google Account with a recommendation to ‘Deny access’. If I grant
Access the data is published to Google Spreadsheet but subsequent streaming
of new Aggregate entries does not appended to the Google Spreadsheet. I do
not fully enderstand the GAE dashboard but there seems to be substantial
activity under the following load headings although only 3 or 4 records
were submitted via ODK collect in the past 24 hours ie ODK may be trying
to access Google Spreadsheet repeatedly?****

                                                        *Requests

Avg CPU(API) % CPU*

  •                               Last 14hr   last hr              last
    

14 hr*

/gae/uploadSubmissionTask 2.51K
(742(652) 54%****

/gae/watchdog 278 4918
(4563) 36%****


From the above it appears that I need to resolve a security issue to
comply with Google’s requirements in order to use Aggregate to append
records automatically to the Spreadsheet, but despite researching this I
have no idea how to resolve it. ****

I have read that I need to upload a HTML file generated by Google to
verify specific ‘ownership’, but I do not know how to access and upload a
this single file to the to the root directory of Appspot or indeed if this
is the correct solution or possible, or is there some other way or is some
other approach that I have missed. ****

I would greatly appreciate any advice, observations or words of wisdom
that you might be able to offer as to how I might deal with this issue. **
**

Thanking you in advance. ****

Kind Regards****

Gerard Martin ****


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

--
Mitch Sundt
Software Engineer

University of Washington
mitchellsundt@gmail.com

I created an issue for this:
http://code.google.com/p/opendatakit/issues/detail?id=410

Streaming publication of submissions broke starting with RC2.

Mitch

··· On Tue, Nov 1, 2011 at 10:50 AM, Mitch Sundt wrote:

Check the logs (click Logs on the left margin) and look for errors during
the uploadSubmissionTask. By default, the logs will only show errors. If
you're using RC2 (see below), send me the errors, or, from the Appengine
management screen, go to Administration / Permissions and invite me to be
an owner of your appspot instance, and I can look myself.

It may be that you are using the Beta 2 and not the RC2. Does your
Aggregate instance have separate "Form Management" and "Site Admin" tabs?
If not, then you are using Beta 2, and publishing is broken due to a Google
infrastructure change; there is no upgrade path from the Beta 2 to the
Release Candidates (we are currently on RC 4). Your only recourse is to
export your data and media files using the Briefcase applet, accessible
from the Beta 2 at
http://your-app-id.appspot.com/Briefcase

Mitch

On Mon, Oct 31, 2011 at 3:35 PM, qs1 qs1@quantitysurveyingonline.comwrote:

Hi Folks,****

I am a real beginner with regard to these technologies . I am using
Collect v1.1.7-RC1 and Aggregate v1.0-RC2 on the Google App Engine to
collect data and publish it to a Google Spreadsheet. I use ‘Sign in with
Google’ to access Aggregate, the account being the same as the account that
contains the Spreadsheet file to which I want to publish. When I set up
publishing to Google Spreadsheet, I provide a filename and select the
option ‘Both Upload Existing And Stream New’. I am then presented with the
response from Google accounts stating that anonymous is requesting access
to my Google Account with a recommendation to ‘Deny access’. If I grant
Access the data is published to Google Spreadsheet but subsequent streaming
of new Aggregate entries does not appended to the Google Spreadsheet. I do
not fully enderstand the GAE dashboard but there seems to be substantial
activity under the following load headings although only 3 or 4 records
were submitted via ODK collect in the past 24 hours ie ODK may be trying
to access Google Spreadsheet repeatedly?****

                                                        *Requests

Avg CPU(API) % CPU*

  •                               Last 14hr   last hr
    

last 14 hr*

/gae/uploadSubmissionTask 2.51K
(742(652) 54%****

/gae/watchdog 278 4918
(4563) 36%****


From the above it appears that I need to resolve a security issue to
comply with Google’s requirements in order to use Aggregate to append
records automatically to the Spreadsheet, but despite researching this I
have no idea how to resolve it. ****

I have read that I need to upload a HTML file generated by Google to
verify specific ‘ownership’, but I do not know how to access and upload a
this single file to the to the root directory of Appspot or indeed if this
is the correct solution or possible, or is there some other way or is some
other approach that I have missed. ****

I would greatly appreciate any advice, observations or words of wisdom
that you might be able to offer as to how I might deal with this issue. *


Thanking you in advance. ****

Kind Regards****

Gerard Martin ****


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

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com