aggregate
aggregate copied to clipboard
getodk
Submission continually published to Google Spreadsheet
Originally reported on Google Code with ID 935
What steps will reproduce the problem?
1. Submission is made by user and recognised by ODK Aggregate
2. Submission published to Google Spreadsheet (already set up and apparently working,
as the submissions do make it to the spreadsheet)
3. Submission gets periodically re-published (same UUID)
What is the expected output? What do you see instead?
I would expect the submission to only be submitted once, except it's now been repeated
around 18 times in the resulting Google Spreadsheet.
The attached screenshot of ODK Aggregate shows that the submission was received only
once. There is also an additional submission that has not yet been published to the
Google Spreadsheet some hours later.
The other screenshot is of the Google Spreadsheet, showing the duplicated UUIDs. I
had previously deleted the duplicate entries, which is why there are blank lines above.
What version of the product are you using? On what operating system?
ODK Aggregate 1.3.0 on Google App Engine
Please provide any additional information below.
There are a few extenuating circumstances here:
- The ODK form contains a repeating group, which should automatically populate a second
spreadsheet tab.
- It's interesting to note that the repeating group data DID NOT get pushed to the
second spreadsheet tab, and was completely empty. Checking the group data in ODK Aggregate
shows that there actually is data. I have another ODK form with a repeating group and
accompanying GSpreadsheet, which has the complete data and is not suffering from the
repeating submissions issue. It seems like this has something to do with the problem,
as it's the only difference.
- The resulting Google Spreadsheet has some ARRAYFORMULAs in a few columns, so that
calculations are automatically conducted. I have another GSpreadsheet with ARRAYFORMULAs
and which is working fine.
I'm happy to share the XML forms and provide access to the GSpreadsheets to debug this.
Please let me know whose email to share with.
Reported by [email protected] on 2013-11-13 18:23:20
- _Attachment: Screen Shot 2013-11-13 at 11.21.19 pm.png
_ - _Attachment: Screen Shot 2013-11-13 at 11.21.32 pm.png
_ - _Attachment: Screen Shot 2013-11-13 at 11.22.29 pm.png
_
Please add a note to this issue if it is still active. I think we worked out the problem
on the opendatakit@ list.
Reported by mitchellsundt on 2014-03-13 20:47:07
- Labels added: Aggregate
This is a different issue to the one we discussed - problem is not with publishing entries
to a spreadsheet, but that entries in a repeating group are continuously pushed to
Google Sheets.
Reported by jeremy.higgs on 2014-03-17 14:20:26
Do any of the field names in the repeat group start with numerals? That would explain
this issue, which has since been fixed in the 1.4.1 code by prepending an 'n' in front
of such a field name.
Otherwise, does the issue occur with the current 1.4.2 code?
If so, can you attach the form or send it to me directly, referencing this issue #.
Reported by mitchellsundt on 2014-03-17 16:50:02
Attention! We're housekeeping! This issue will automatically be closed if no feedback is received in one week.
If this issue is important to you or you can provide more information about it, please, do so as soon as possible :)
