[ODK Community] Exporting problems with CSV file when using repeating groups

Use the ODK Briefcase application. This allows you to pull all data down to
your local computer. After that, you can Export to CSV. This will produce
one CSV file for the top level group and one CSV file for each repeat group
within the form.

Mitch

··· On Thu, Jul 5, 2012 at 4:23 PM, wrote:

When I have a repeating group in a form and I download this form from
aggregate in the multiple entry field I get an http:/ instead of the actual
data. I have attached a copy of my CSV file. Does anyone know what to do to
prevent this from happening and to be able to export the real data?

--
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

There is a usage section that explains this on the website
http://opendatakit.org/use/briefcase/

My guess is you are using a google account instead of a ODK account.

··· On Fri, Jul 6, 2012 at 10:59 AM, wrote: > On Thursday, July 5, 2012 6:42:45 PM UTC-5, Mitch wrote: >> Use the ODK Briefcase application. This allows you to pull all data down to your local computer. After that, you can Export to CSV. This will produce one CSV file for the top level group and one CSV file for each repeat group within the form. >> >> >> Mitch >> >> >> On Thu, Jul 5, 2012 at 4:23 PM, <nabil.mansouri@gmail.com> wrote: >>
>> When I have a repeating group in a form and I download this form from aggregate in the multiple entry field I get an http:/ instead of the actual data. I have attached a copy of my CSV file. Does anyone know what to do to prevent this from happening and to be able to export the real data? >> >> >> >> >> -- >> >> 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 > > Hey Mike, > > I downloaded briefcase into my computer. But I'm having trouble pulling the info into briefcase. I get this error message: > > Fetching form definition > Unexpected error: Fetch of /Users/nabilmansouri/Desktop/ODK Briefcase Storage/forms/Multiple.Operator.DropOff.v1/Multiple.Operator.DropOff.v1.xml failed. Detailed reason: Unauthorized (401) while accessing: https://stanfordresource.appspot.com/formXml?formId=build_Multiple-Operator-DropOff-v1_1341426905 > > The error message mentions an unauthorized user but I did use my correct login info? Do you have an idea what could be happening? > > -nabil > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en

No, if you need everything in one file, consider exporting to JSON (newly
available in ODK Aggregate 1.2 -- ODK Briefcase isn't able to do this).

This will recursively traverse the form, emitting all nested repeat data
along with the form. The media attachments are referenced as URLs.

Mitch

··· On Wed, Jul 25, 2012 at 1:59 PM, wrote:

Mitch,

Is there a way (or java application) that merges the repeat data files
into one csv file?

Thanks,

Mike

On Thursday, July 5, 2012 4:42:45 PM UTC-7, Mitch wrote:

Use the ODK Briefcase application. This allows you to pull all data down
to your local computer. After that, you can Export to CSV. This will
produce one CSV file for the top level group and one CSV file for each
repeat group within the form.

Mitch

On Thu, Jul 5, 2012 at 4:23 PM, <nabil.mansouri@gmail.com> wrote:

#ccc solid;padding-left:1ex">

When I have a repeating group in a form and I download this form from
aggregate in the multiple entry field I get an http:/ instead of the actual
data. I have attached a copy of my CSV file. Does anyone know what to do to
prevent this from happening and to be able to export the real data?

--

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

--
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

Hey Mike,

Along those same lines, you can also patch Briefcase to export JSON.

Yaw

··· On Wed, Jul 25, 2012 at 2:30 PM, Mitch S wrote: > No, if you need everything in one file, consider exporting to JSON (newly > available in ODK Aggregate 1.2 -- ODK Briefcase isn't able to do this). > > This will recursively traverse the form, emitting all nested repeat data > along with the form. The media attachments are referenced as URLs. > > Mitch > > > On Wed, Jul 25, 2012 at 1:59 PM, wrote: >> >> Mitch, >> >> Is there a way (or java application) that merges the repeat data files >> into one csv file? >> >> Thanks, >> >> Mike >> >> On Thursday, July 5, 2012 4:42:45 PM UTC-7, Mitch wrote: >> > Use the ODK Briefcase application. This allows you to pull all data down >> > to your local computer. After that, you can Export to CSV. This will produce >> > one CSV file for the top level group and one CSV file for each repeat group >> > within the form. >> > >> > >> > Mitch >> > >> > >> > On Thu, Jul 5, 2012 at 4:23 PM, <nabil.mansouri@gmail.com> wrote: >> >
>> > When I have a repeating group in a form and I download this form from >> > aggregate in the multiple entry field I get an http:/ instead of the actual >> > data. I have attached a copy of my CSV file. Does anyone know what to do to >> > prevent this from happening and to be able to export the real data? >> > >> > >> > >> > >> > -- >> > >> > Post: > > target="_blank">opendatakit@googlegroups.com >> > >> > Unsubscribe: > > target="_blank">opendatakit+unsubscribe@googlegroups.com >> > >> > Options: > > target="_blank">http://groups.google.com/group/opendatakit?hl=en >> > >> >
>> > >> > >> > -- >> > Mitch Sundt >> > Software Engineer >> > University of Washington >> > > > target="_blank">mitchellsundt@gmail.com >> >> -- >> 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 > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en