Answers in repeat cycle exported to csv

Dear all,

I built a form with a “repeat” statement after a couple of preliminary
questions. When I enter in the repeat cycle, let us suppose that I need to
repeat the cycle 3 times. The problem is that when I download the CSV file,
the inserted answers appear as a single line (with a weblink instead of the
three answers to the repeat cycle questions). Is there a way to export the
csv file with each answer inside the repeat cycle expanded on multiple
lines?

Thank you in advance

Laura

Use ODK Briefcase.

After downloading the dataset to your computer, you can export data as a
CSV. That would produce a csv for the top-level survey, and a csv for each
repeat group within that survey. If you had just one repeat group in your
survey, it would produce two csv files and you would use the REF and
PARENT_REF columns to tie the two generated csv files together.

··· On Tue, Jan 6, 2015 at 10:35 AM, Laura Carcano wrote:

Dear all,

I built a form with a “repeat” statement after a couple of preliminary
questions. When I enter in the repeat cycle, let us suppose that I need to
repeat the cycle 3 times. The problem is that when I download the CSV file,
the inserted answers appear as a single line (with a weblink instead of the
three answers to the repeat cycle questions). Is there a way to export the
csv file with each answer inside the repeat cycle expanded on multiple
lines?

Thank you in advance

Laura

--

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

Mitch (and/or others),

I was having the same problem. I used ODK Briefcase and downloaded the data, and it did exactly as you said--putting the top level survey and all repeat groups in separate Excel files.

Now, I want to know how to deal with having separate files during data analysis. I want to be able to analyze all the births from all women in my survey by educational level, wealth quintile, total parity, location, etc.--all variables contained in my top level survey. How do I do that? Do I have to manually compile all the excel files into one single spreadsheet? I'm wanting to use a stats program like Stata to analyze, if that's pertinent...

Thanks for your help!
Jacquie

··· On Tuesday, January 6, 2015 at 4:41:02 PM UTC-5, Mitch Sundt wrote: > Use ODK Briefcase. > > After downloading the dataset to your computer, you can export data as a CSV. That would produce a csv for the top-level survey, and a csv for each repeat group within that survey. If you had just one repeat group in your survey, it would produce two csv files and you would use the REF and PARENT_REF columns to tie the two generated csv files together. > > > > On Tue, Jan 6, 2015 at 10:35 AM, Laura Carcano wrote: > > > Dear all, > > > I built a > form with a “repeat” statement after a couple of preliminary questions. When I > enter in the repeat cycle, let us suppose that I need to repeat the cycle 3 > times. The problem is that when I download the CSV file, the inserted answers appear > as a single line (with a weblink instead of the three answers to the repeat > cycle questions). Is there a way to export the csv file with each answer inside > the repeat cycle expanded on multiple lines? > > > Thank you > in advance > > > Laura > > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@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...@googlegroups.com. > > For more options, visit https://groups.google.com/d/optout. > > > > > -- > > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com

You should talk to your organization's data analysts. This is a standard
analysis circumstance.

Tools like STATA should allow you to import multiple data sets and
establish relationships among those data sets (e.g., PARENT_KEY in this
data set corresponds to KEY in that data set).

··· On Tue, Jun 9, 2015 at 7:00 AM, wrote:

Mitch (and/or others),

I was having the same problem. I used ODK Briefcase and downloaded the
data, and it did exactly as you said--putting the top level survey and all
repeat groups in separate Excel files.

Now, I want to know how to deal with having separate files during data
analysis. I want to be able to analyze all the births from all women in my
survey by educational level, wealth quintile, total parity, location,
etc.--all variables contained in my top level survey. How do I do that? Do
I have to manually compile all the excel files into one single spreadsheet?
I'm wanting to use a stats program like Stata to analyze, if that's
pertinent...

Thanks for your help!
Jacquie

On Tuesday, January 6, 2015 at 4:41:02 PM UTC-5, Mitch Sundt wrote:

Use ODK Briefcase.

After downloading the dataset to your computer, you can export data as a
CSV. That would produce a csv for the top-level survey, and a csv for each
repeat group within that survey. If you had just one repeat group in your
survey, it would produce two csv files and you would use the REF and
PARENT_REF columns to tie the two generated csv files together.

On Tue, Jan 6, 2015 at 10:35 AM, Laura Carcano lau.c...@gmail.com wrote:

Dear all,

I built a
form with a “repeat” statement after a couple of preliminary questions.
When I
enter in the repeat cycle, let us suppose that I need to repeat the
cycle 3
times. The problem is that when I download the CSV file, the inserted
answers appear
as a single line (with a weblink instead of the three answers to the
repeat
cycle questions). Is there a way to export the csv file with each answer
inside
the repeat cycle expanded on multiple lines?

Thank you
in advance

Laura

--

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@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...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

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

And Jacquie, odkmeta can do a lot of the hard work for you if you're using
Stata. Check it out here:

Chris

··· --- Christopher Robert Dobility, Inc. (SurveyCTO) http://www.surveycto.com/ http://blog.surveycto.com/

On Tue, Jun 9, 2015 at 4:40 PM Mitch Sundt mitchellsundt@gmail.com wrote:

You should talk to your organization's data analysts. This is a standard
analysis circumstance.

Tools like STATA should allow you to import multiple data sets and
establish relationships among those data sets (e.g., PARENT_KEY in this
data set corresponds to KEY in that data set).

On Tue, Jun 9, 2015 at 7:00 AM, safemothers.safebabies@gmail.com wrote:

Mitch (and/or others),

I was having the same problem. I used ODK Briefcase and downloaded the
data, and it did exactly as you said--putting the top level survey and all
repeat groups in separate Excel files.

Now, I want to know how to deal with having separate files during data
analysis. I want to be able to analyze all the births from all women in my
survey by educational level, wealth quintile, total parity, location,
etc.--all variables contained in my top level survey. How do I do that? Do
I have to manually compile all the excel files into one single spreadsheet?
I'm wanting to use a stats program like Stata to analyze, if that's
pertinent...

Thanks for your help!
Jacquie

On Tuesday, January 6, 2015 at 4:41:02 PM UTC-5, Mitch Sundt wrote:

Use ODK Briefcase.

After downloading the dataset to your computer, you can export data as
a CSV. That would produce a csv for the top-level survey, and a csv for
each repeat group within that survey. If you had just one repeat group in
your survey, it would produce two csv files and you would use the REF and
PARENT_REF columns to tie the two generated csv files together.

On Tue, Jan 6, 2015 at 10:35 AM, Laura Carcano lau.c...@gmail.com wrote:

Dear all,

I built a
form with a “repeat” statement after a couple of preliminary questions.
When I
enter in the repeat cycle, let us suppose that I need to repeat the
cycle 3
times. The problem is that when I download the CSV file, the inserted
answers appear
as a single line (with a weblink instead of the three answers to the
repeat
cycle questions). Is there a way to export the csv file with each
answer inside
the repeat cycle expanded on multiple lines?

Thank you
in advance

Laura

--

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@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...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

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

--

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.

And Jacquie, odkmeta can do a lot of the hard work for you if you're using Stata. Check it out here:

https://ideas.repec.org/c/boc/bocode/s457767.html

Chris


Christopher Robert
Dobility, Inc. (SurveyCTO)

http://www.surveycto.com/
http://blog.surveycto.com/

You should talk to your organization's data analysts. This is a standard analysis circumstance.

Tools like STATA should allow you to import multiple data sets and establish relationships among those data sets (e.g., PARENT_KEY in this data set corresponds to KEY in that data set).

Mitch (and/or others),

I was having the same problem. I used ODK Briefcase and downloaded the data, and it did exactly as you said--putting the top level survey and all repeat groups in separate Excel files.

Now, I want to know how to deal with having separate files during data analysis. I want to be able to analyze all the births from all women in my survey by educational level, wealth quintile, total parity, location, etc.--all variables contained in my top level survey. How do I do that? Do I have to manually compile all the excel files into one single spreadsheet? I'm wanting to use a stats program like Stata to analyze, if that's pertinent...

Thanks for your help!

Jacquie

Use ODK Briefcase.

After downloading the dataset to your computer, you can export data as a CSV. That would produce a csv for the top-level survey, and a csv for each repeat group within that survey. If you had just one repeat group in your survey, it would produce two csv files and you would use the REF and PARENT_REF columns to tie the two generated csv files together.

Dear all,

I built a

form with a “repeat” statement after a couple of preliminary questions. When I

enter in the repeat cycle, let us suppose that I need to repeat the cycle 3

times. The problem is that when I download the CSV file, the inserted answers appear

as a single line (with a weblink instead of the three answers to the repeat

cycle questions). Is there a way to export the csv file with each answer inside

the repeat cycle expanded on multiple lines?

Thank you

in advance

Laura

--

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@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...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Mitch Sundt

Software Engineer

University of Washington

mitche...@gmail.com

--

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@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...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Mitch Sundt
Software Engineer
University of Washington

mitche...@gmail.com

--

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@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...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Yaw and Christopher,

Thank you for your help! Much appreciated.

Jacquie

··· On Tuesday, June 9, 2015 at 4:47:22 PM UTC-4, Christopher Robert wrote: > On Tue, Jun 9, 2015 at 4:40 PM Mitch Sundt wrote: > On Tue, Jun 9, 2015 at 7:00 AM, wrote: > On Tuesday, January 6, 2015 at 4:41:02 PM UTC-5, Mitch Sundt wrote: > > On Tue, Jan 6, 2015 at 10:35 AM, Laura Carcano wrote: