Downloading Repeat Groups In 1 excel file

Hi All,

How can I easily download an entire form, including the repeat groups?
Currently, if I click the export button on the forms page online, I will
get an .csv file with all the answers in separate columns (which is great)
but the repeat sections only show a link to a webpage which shows the
repeat groups answers for that single form. So if I wanted a .csv file that
included all the answers from my form, I would manually have to copy and
paste each repeat section from each survey and copy it into the original
.csv file. We are going to have about 50,000 surveys that include multiple
repeat sections, so doing this manually will not be an option.

When I use the briefcase, it exports the forms individually and it only
provides a .kml version, not a .csv version.

So ideally, is there an easy way to download all the data at once that
includes the repeat sections? Or, is there a way that I can download all
the repeat sections into their own .csv file?

The only other option I can see would be to just ask the same group of
questions multiple times with a "Do you want to add another?" question in
between. If they say yes, then it will "repeat" the group, if no, then it
will skip to the next section. However, this kind of diminishes the use of
the "repeat" logic.

Any advice would be greatly appreciate as I would really like to avoid
doing the last option.

Thanks,
Evelyn

··· -- Evelyn Castle Director, eHealth Nigeria www.eHealthNigeria.org 25 Race Course Road, Kano, Ng mobile: (NG) 0809-515-0585 (NG) 0813-883-2395 (US) 714-721-3157

Hi Evelyn,

formhub currently supports these types of relational exports (it will break
out each repeat group to a separate excel tab or additional csv rows).

You can try it out online or setup a local instance if you prefer.

Thanks,

Matt

··· On Fri, Jan 27, 2012 at 3:08 PM, Evelyn Castle wrote:

Hi All,

How can I easily download an entire form, including the repeat groups?
Currently, if I click the export button on the forms page online, I will
get an .csv file with all the answers in separate columns (which is great)
but the repeat sections only show a link to a webpage which shows the
repeat groups answers for that single form. So if I wanted a .csv file that
included all the answers from my form, I would manually have to copy and
paste each repeat section from each survey and copy it into the original
.csv file. We are going to have about 50,000 surveys that include multiple
repeat sections, so doing this manually will not be an option.

When I use the briefcase, it exports the forms individually and it only
provides a .kml version, not a .csv version.

So ideally, is there an easy way to download all the data at once that
includes the repeat sections? Or, is there a way that I can download all
the repeat sections into their own .csv file?

The only other option I can see would be to just ask the same group of
questions multiple times with a "Do you want to add another?" question in
between. If they say yes, then it will "repeat" the group, if no, then it
will skip to the next section. However, this kind of diminishes the use of
the "repeat" logic.

Any advice would be greatly appreciate as I would really like to avoid
doing the last option.

Thanks,
Evelyn

--
Evelyn Castle
Director, eHealth Nigeria
www.eHealthNigeria.org
25 Race Course Road, Kano, Ng
mobile: (NG) 0809-515-0585
(NG) 0813-883-2395
(US) 714-721-3157

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

Hi Matt,

I already have the ODK collect xml file and I am not using xlsform. How do
I get my data into formhub to do a relational export?

Thanks
Evelyn

··· On Fri, Jan 27, 2012 at 1:17 PM, Matt Berg wrote:

Hi Evelyn,

formhub currently supports these types of relational exports (it will
break out each repeat group to a separate excel tab or additional csv rows).

You can try it out online or setup a local instance if you prefer.

Thanks,

Matt

On Fri, Jan 27, 2012 at 3:08 PM, Evelyn Castle evelyn@ehealthnigeria.orgwrote:

Hi All,

How can I easily download an entire form, including the repeat groups?
Currently, if I click the export button on the forms page online, I will
get an .csv file with all the answers in separate columns (which is great)
but the repeat sections only show a link to a webpage which shows the
repeat groups answers for that single form. So if I wanted a .csv file that
included all the answers from my form, I would manually have to copy and
paste each repeat section from each survey and copy it into the original
.csv file. We are going to have about 50,000 surveys that include multiple
repeat sections, so doing this manually will not be an option.

When I use the briefcase, it exports the forms individually and it only
provides a .kml version, not a .csv version.

So ideally, is there an easy way to download all the data at once that
includes the repeat sections? Or, is there a way that I can download all
the repeat sections into their own .csv file?

The only other option I can see would be to just ask the same group of
questions multiple times with a "Do you want to add another?" question in
between. If they say yes, then it will "repeat" the group, if no, then it
will skip to the next section. However, this kind of diminishes the use of
the "repeat" logic.

Any advice would be greatly appreciate as I would really like to avoid
doing the last option.

Thanks,
Evelyn

--
Evelyn Castle
Director, eHealth Nigeria
www.eHealthNigeria.org
25 Race Course Road, Kano, Ng
mobile: (NG) 0809-515-0585
(NG) 0813-883-2395
(US) 714-721-3157

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Evelyn Castle
Director, eHealth Nigeria


25 Race Course Road, Kano, Ng
mobile: (NG) 0809-515-0585
(NG) 0813-883-2395
(US) 714-721-3157

Hi Evelyn,

I am finalizing wording on an ODK Briefcase 1.0 production release that
will generate a CSV file for each repeat group. To use briefcase, you
would download all the data off your server to your local machine, then,
from there, export the CSV file.

The current 1.0 Beta has a bug that prevents all repeat elements to be
emitted now, but that is fixed in the 1.0 production release.

I aim to get the production release out later today or Monday.

Mitch

··· On Fri, Jan 27, 2012 at 7:21 AM, Evelyn Castle wrote:

Hi Matt,

I already have the ODK collect xml file and I am not using xlsform. How do
I get my data into formhub to do a relational export?

Thanks
Evelyn

On Fri, Jan 27, 2012 at 1:17 PM, Matt Berg mlberg@gmail.com wrote:

Hi Evelyn,

formhub currently supports these types of relational exports (it will
break out each repeat group to a separate excel tab or additional csv rows).

You can try it out online or setup a local instance if you prefer.

Thanks,

Matt

On Fri, Jan 27, 2012 at 3:08 PM, Evelyn Castle <evelyn@ehealthnigeria.org wrote:

Hi All,

How can I easily download an entire form, including the repeat groups?
Currently, if I click the export button on the forms page online, I will
get an .csv file with all the answers in separate columns (which is great)
but the repeat sections only show a link to a webpage which shows the
repeat groups answers for that single form. So if I wanted a .csv file that
included all the answers from my form, I would manually have to copy and
paste each repeat section from each survey and copy it into the original
.csv file. We are going to have about 50,000 surveys that include multiple
repeat sections, so doing this manually will not be an option.

When I use the briefcase, it exports the forms individually and it only
provides a .kml version, not a .csv version.

So ideally, is there an easy way to download all the data at once that
includes the repeat sections? Or, is there a way that I can download all
the repeat sections into their own .csv file?

The only other option I can see would be to just ask the same group of
questions multiple times with a "Do you want to add another?" question in
between. If they say yes, then it will "repeat" the group, if no, then it
will skip to the next section. However, this kind of diminishes the use of
the "repeat" logic.

Any advice would be greatly appreciate as I would really like to avoid
doing the last option.

Thanks,
Evelyn

--
Evelyn Castle
Director, eHealth Nigeria
www.eHealthNigeria.org
25 Race Course Road, Kano, Ng
mobile: (NG) 0809-515-0585
(NG) 0813-883-2395
(US) 714-721-3157

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Evelyn Castle
Director, eHealth Nigeria
www.eHealthNigeria.org
25 Race Course Road, Kano, Ng
mobile: (NG) 0809-515-0585
(NG) 0813-883-2395
(US) 714-721-3157

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