I have Aggregate deployed on my google appspot (aggregate v0.9.4).
I created a form with Build. This form includes date & integer-input
data types (as well as others, like string-inputs, etc.).
I posted my form to aggregate, downloaded it onto my phone (Cliq) and
ran several forms via Collect (v1.1.5), then sent those finished forms
to my Aggregate instance on my appspot.
From Aggregate on my appspot I then viewed my data (List Forms > View
Forms) - everything looked fine.
Next, I tried to send my data to google spreadsheets (List Forms >
External Service Connection > Google Spreadsheet)...
However, after exporting to google spreadsheet, when I opened up my
google spreadsheet I'd created and exported to, some of the questions
were missing data! None of the questions that were "date" data-types
or "integer-input" data-types had any values (data) in the google
spreadsheet. The column header was there, but the results from the
completed forms were empty for these questions.
What happened?
Matt
Matt,
Good question. I have opened an issue
http://code.google.com/p/opendatakit/issues/detail?id=190
Can you attach the form that is causing the the problem to the issue?
It's easier if we can exactly recreate your problem. Google continues
to make updates to the Gdata interface and App engine and the updates
have been known to break pre-existing code. We are aware of a break
that happened last week on the newer version of GAE and spreadsheets
but I did not think it would affect 0.9.4 code. Additionally, it could
be an oversight on our part of a use case we didn't think of (for
example bad characters in your column headings) or something could
have changed in Google APIs that breaks existing code (this happens
about every 6 months).
Please provide as much detail as possible in the issue and we will look into it.
Cheers,
Waylon
···
On Tue, Feb 22, 2011 at 6:52 PM, Matt Basinger wrote:
> I have Aggregate deployed on my google appspot (aggregate v0.9.4).
>
> I created a form with Build. This form includes date & integer-input
> data types (as well as others, like string-inputs, etc.).
>
> I posted my form to aggregate, downloaded it onto my phone (Cliq) and
> ran several forms via Collect (v1.1.5), then sent those finished forms
> to my Aggregate instance on my appspot.
>
> From Aggregate on my appspot I then viewed my data (List Forms > View
> Forms) - everything looked fine.
>
> Next, I tried to send my data to google spreadsheets (List Forms >
> External Service Connection > Google Spreadsheet)...
>
> However, after exporting to google spreadsheet, when I opened up my
> google spreadsheet I'd created and exported to, some of the questions
> were missing data! None of the questions that were "date" data-types
> or "integer-input" data-types had any values (data) in the google
> spreadsheet. The column header was there, but the results from the
> completed forms were empty for these questions.
>
> What happened?
>
> Matt
>
> --
> Post: opendatakit@googlegroups.com
> Unsubscribe: opendatakit+unsubscribe@googlegroups.com
> Options: http://groups.google.com/group/opendatakit?hl=en
>
here you go - here's the form
form (1).xml (7.91 KB)
···
On Tue, Feb 22, 2011 at 10:14 PM, W. Brunette wrote:
Matt,
Good question. I have opened an issue
http://code.google.com/p/opendatakit/issues/detail?id=190
Can you attach the form that is causing the the problem to the issue?
It's easier if we can exactly recreate your problem. Google continues
to make updates to the Gdata interface and App engine and the updates
have been known to break pre-existing code. We are aware of a break
that happened last week on the newer version of GAE and spreadsheets
but I did not think it would affect 0.9.4 code. Additionally, it could
be an oversight on our part of a use case we didn't think of (for
example bad characters in your column headings) or something could
have changed in Google APIs that breaks existing code (this happens
about every 6 months).
Please provide as much detail as possible in the issue and we will look
into it.
Cheers,
Waylon
On Tue, Feb 22, 2011 at 6:52 PM, Matt Basinger mattbasinger@gmail.com wrote:
I have Aggregate deployed on my google appspot (aggregate v0.9.4).
I created a form with Build. This form includes date & integer-input
data types (as well as others, like string-inputs, etc.).
I posted my form to aggregate, downloaded it onto my phone (Cliq) and
ran several forms via Collect (v1.1.5), then sent those finished forms
to my Aggregate instance on my appspot.
From Aggregate on my appspot I then viewed my data (List Forms > View
Forms) - everything looked fine.
Next, I tried to send my data to google spreadsheets (List Forms >
External Service Connection > Google Spreadsheet)...
However, after exporting to google spreadsheet, when I opened up my
google spreadsheet I'd created and exported to, some of the questions
were missing data! None of the questions that were "date" data-types
or "integer-input" data-types had any values (data) in the google
spreadsheet. The column header was there, but the results from the
completed forms were empty for these questions.
What happened?
Matt
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
--
Matt Basinger, MS EngScD
Research Scientist, Post-Doc
The Earth Institute, Columbia University
mlb2133@columbia.edu
- 1 212 854 7306 [office]
- 1 646 290 4152 [mobile]
Matt,
Google Spreadsheet does not like the underscore character "_" in the
element name. This was already fixed in Aggregate 1.x tree. I back
ported the fix to the 0.9.x tree (aka default).
Waylon
···
On Tue, Feb 22, 2011 at 7:17 PM, Matt Basinger wrote:
> here you go - here's the form
>
> On Tue, Feb 22, 2011 at 10:14 PM, W. Brunette wrote:
>>
>> Matt,
>>
>> Good question. I have opened an issue
>> http://code.google.com/p/opendatakit/issues/detail?id=190
>>
>> Can you attach the form that is causing the the problem to the issue?
>> It's easier if we can exactly recreate your problem. Google continues
>> to make updates to the Gdata interface and App engine and the updates
>> have been known to break pre-existing code. We are aware of a break
>> that happened last week on the newer version of GAE and spreadsheets
>> but I did not think it would affect 0.9.4 code. Additionally, it could
>> be an oversight on our part of a use case we didn't think of (for
>> example bad characters in your column headings) or something could
>> have changed in Google APIs that breaks existing code (this happens
>> about every 6 months).
>>
>> Please provide as much detail as possible in the issue and we will look
>> into it.
>>
>> Cheers,
>> Waylon
>>
>> On Tue, Feb 22, 2011 at 6:52 PM, Matt Basinger wrote:
>> > I have Aggregate deployed on my google appspot (aggregate v0.9.4).
>> >
>> > I created a form with Build. This form includes date & integer-input
>> > data types (as well as others, like string-inputs, etc.).
>> >
>> > I posted my form to aggregate, downloaded it onto my phone (Cliq) and
>> > ran several forms via Collect (v1.1.5), then sent those finished forms
>> > to my Aggregate instance on my appspot.
>> >
>> > From Aggregate on my appspot I then viewed my data (List Forms > View
>> > Forms) - everything looked fine.
>> >
>> > Next, I tried to send my data to google spreadsheets (List Forms >
>> > External Service Connection > Google Spreadsheet)...
>> >
>> > However, after exporting to google spreadsheet, when I opened up my
>> > google spreadsheet I'd created and exported to, some of the questions
>> > were missing data! None of the questions that were "date" data-types
>> > or "integer-input" data-types had any values (data) in the google
>> > spreadsheet. The column header was there, but the results from the
>> > completed forms were empty for these questions.
>> >
>> > What happened?
>> >
>> > Matt
>> >
>> > --
>> > Post: opendatakit@googlegroups.com
>> > Unsubscribe: opendatakit+unsubscribe@googlegroups.com
>> > Options: http://groups.google.com/group/opendatakit?hl=en
>> >
>
>
>
> --
> Matt Basinger, MS EngScD
> Research Scientist, Post-Doc
> The Earth Institute, Columbia University
> mlb2133@columbia.edu
> + 1 212 854 7306 [office]
> + 1 646 290 4152 [mobile]
>
>
>