Problem Fetching Data with ODK Briefcase

I'm working on a complex maternal and child health and mortality study. We did our final round of test data collection yesterday. However, because the power had gone out and took out the internet, the survey manager was unable to download the most recent version of the form from Aggregate and, unbeknownst to me at the time, let the surveyors just use the version of the survey that was already on the tablets. Most everything was the same; all that changed was a few codes in the relevant column and maybe an actual column or two (though I really don't remember, there's been so many versions at this point). The surveys all uploaded to ODK Aggregate perfectly and I can see all the submissions on the "Form Submissions" tab...

BUT when I try to download the data using ODK Briefcase, I get the following error code:

Fetching form definition
resolving against briefcase form definitions
preparing to retrieve instance data
retrieving next chunk of instances from server...
fetching instance 1 ...
SUBMISSION NOT RETRIEVED: Error fetching submission uri: uuid:dc42fc1c-b494-475e-ac9a-e58d59dc97b7 details: Fetch of a submission failed. Detailed error: Not Found (404) while accessing: https://safebaseline.appspot.com/view/downloadSubmission?formId=SAFE_MCH_Survey_FINAL[%40version%3Dnull+and+%40uiVersion%3Dnull]%2FSAFE_MCH_Survey_FINAL[%40key%3Duuid%3Adc42fc1c-b494-475e-ac9a-e58d59dc97b7]
Please verify that the URL, your user credentials and your permissions are all correct.

I get this error code X 108.

The URL, user credentials and permissions are correct. That said, I'm sure that this is my fault somehow, but I can't figure out how to deal with it and I don't want to lose all this data... Like REALLY don't want to lose this data.

There are a lot of repeat sections, so exporting directly from Aggregate isn't optimal, unless someone can tell me how to export the repeats in their own files and link them with the parent file using the uuids (essentially replicating what Briefcase does).

Any ideas?

Thank you in advance for any input!
Jacquie Cutts

P.S. I'm happy to share my XLSForm if anyone wants an example of what I consider to be a complex survey with skips, repeats, and how to the end the survey work-around, etc. :slight_smile:

When using the core ODK tools, it is important that any changes to a form
that add questions or alter the data type of a question also change the
form-id of the form.
If you are simply correcting text, you can re-use
the form-id and declare a new version of the form by specifying a version
string. That version is then propagated into the submission record,
enabling you to distinguish among different versions of a form (e.g.,
different wordings of questions) and uncover biases caused by those changes.

Other OpenRosa-compliant tools have more relaxed handling of these changes
(e.g., formhub).

In this case, since the form-id was not changed, the best solution is to
isolate the data collected from the older version of this form using a
completely different ODK Briefcase Storage Location. i.e., you would
maintain two storage locations for ODK Briefcase, the main location holding
data from the 'correct' form definition, and a secondary storage location
holding the data from the 'obsolete' form definition.

To do that, using ODK Briefcase, change the Storage Location (shown at the
top of the ODK Briefcase screen), and pull the data collected with the
older forms into that new location. From there, you can then generate the
CSV for that data, and process it separately from the data collected via
the newer form definition.

ยทยทยท On Tue, Jun 16, 2015 at 6:25 PM, wrote:

I'm working on a complex maternal and child health and mortality study. We
did our final round of test data collection yesterday. However, because the
power had gone out and took out the internet, the survey manager was unable
to download the most recent version of the form from Aggregate and,
unbeknownst to me at the time, let the surveyors just use the version of
the survey that was already on the tablets. Most everything was the same;
all that changed was a few codes in the relevant column and maybe an actual
column or two (though I really don't remember, there's been so many
versions at this point). The surveys all uploaded to ODK Aggregate
perfectly and I can see all the submissions on the "Form Submissions" tab...

BUT when I try to download the data using ODK Briefcase, I get the
following error code:

Fetching form definition
resolving against briefcase form definitions
preparing to retrieve instance data
retrieving next chunk of instances from server...
fetching instance 1 ...
SUBMISSION NOT RETRIEVED: Error fetching submission uri:
uuid:dc42fc1c-b494-475e-ac9a-e58d59dc97b7 details: Fetch of a submission
failed. Detailed error: Not Found (404) while accessing:
https://safebaseline.appspot.com/view/downloadSubmission?formId=SAFE_MCH_Survey_FINAL[%40version%3Dnull+and+%40uiVersion%3Dnull]%2FSAFE_MCH_Survey_FINAL[%40key%3Duuid%3Adc42fc1c-b494-475e-ac9a-e58d59dc97b7]
Please verify that the URL, your user credentials and your permissions are
all correct.

I get this error code X 108.

The URL, user credentials and permissions are correct. That said, I'm sure
that this is my fault somehow, but I can't figure out how to deal with it
and I don't want to lose all this data... Like REALLY don't want to lose
this data.

There are a lot of repeat sections, so exporting directly from Aggregate
isn't optimal, unless someone can tell me how to export the repeats in
their own files and link them with the parent file using the uuids
(essentially replicating what Briefcase does).

Any ideas?

Thank you in advance for any input!
Jacquie Cutts

P.S. I'm happy to share my XLSForm if anyone wants an example of what I
consider to be a complex survey with skips, repeats, and how to the end the
survey work-around, etc. :slight_smile:

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com