search

somkiattha / opendatakit

Automatically exported from code.google.com/p/opendatakit
0 stars 0 forks source link

Submission continually published to Google Spreadsheet #935

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
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.

Original issue reported on code.google.com by jhi...@ecoenergyfinance.org on 13 Nov 2013 at 6:23

Attachments:

GoogleCodeExporter commented 9 years ago 
Please add a note to this issue if it is still active. I think we worked out 
the problem on the opendatakit@ list.

Original comment by mitchellsundt@gmail.com on 13 Mar 2014 at 8:47

GoogleCodeExporter commented 9 years ago 
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.

Original comment by jeremy.h...@gmail.com on 17 Mar 2014 at 2:20

GoogleCodeExporter commented 9 years ago 
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 #.

Original comment by mitchellsundt@gmail.com on 17 Mar 2014 at 4:50