Exporting Group Data from ODK aggregate

After using ODK collect and successfully submitting your data online to
your ODK Aggregate server, data export to a CSV format is possible. One
issue, I faced with the export is that the group data were not exported but
instead the link to the group data was exported. Is it possible to export
the group data to CSV as well? Thank you

Pema,

Please use ODK Briefcase if you wish to download the repeat data.
Below are two previous email threads from the mailing list that
discuss the issue and provide more detail.

https://groups.google.com/forum/?fromgroups=#!search/exporting$20repeats$20briefcase/opendatakit/li6v7AW7qxQ/GMAik9l_PLEJ

https://groups.google.com/forum/?fromgroups=#!search/exporting$20repeats$20briefcase/opendatakit/ytAjdJqa104/LzsVYNxd69MJ

Cheers,
Waylon

··· On Tue, Apr 16, 2013 at 12:52 AM, pema namgay wrote: > After using ODK collect and successfully submitting your data online to your > ODK Aggregate server, data export to a CSV format is possible. One issue, I > faced with the export is that the group data were not exported but instead > the link to the group data was exported. Is it possible to export the group > data to CSV as well? Thank you > > -- > -- > 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/groups/opt_out. > >

Dear all,

Thank you all for the responses. I have also tried exploring and found a
work around, this works with both excel and spss. Just in case if there are
people who are looking for the same solution as I am, I configured ms excel
with a MYSQL connector driver and exported the data directly from the Mysql
database but i modified the query as per my requirement. Similarly with
spss, I connect to the MYSQL sever directly and then modify the mysql query
as per my own requirement.

··· On Tuesday, April 16, 2013 1:52:42 PM UTC+6, pema namgay wrote: > > After using ODK collect and successfully submitting your data online to > your ODK Aggregate server, data export to a CSV format is possible. One > issue, I faced with the export is that the group data were not exported but > instead the link to the group data was exported. Is it possible to export > the group data to CSV as well? Thank you

Hi Waylon,
So far ODK Briefcase works greatly. One issue I have though: in the CSV
files, the header contains group name if a variable is in a group. I don't
know about others but for me in all the surveys I have done so far, this
part is redundant. It is because normally when you design a form, variable
names in the name column are unique and refer to the variable names you
want to use later on. Thus, we always need to write rename commands to
remove the group name.

It would be great if you can give some thoughts on this.

Thanks,
Trung.

··· On Tuesday, April 16, 2013 3:09:01 PM UTC+7, Waylon Brunette wrote: > > Pema, > > Please use ODK Briefcase if you wish to download the repeat data. > Below are two previous email threads from the mailing list that > discuss the issue and provide more detail. > > > https://groups.google.com/forum/?fromgroups=#!search/exporting$20repeats$20briefcase/opendatakit/li6v7AW7qxQ/GMAik9l_PLEJ > > > https://groups.google.com/forum/?fromgroups=#!search/exporting$20repeats$20briefcase/opendatakit/ytAjdJqa104/LzsVYNxd69MJ > > Cheers, > Waylon > > On Tue, Apr 16, 2013 at 12:52 AM, pema namgay <peman...@gmail.com> wrote: > > After using ODK collect and successfully submitting your data online to > your > > ODK Aggregate server, data export to a CSV format is possible. One > issue, I > > faced with the export is that the group data were not exported but > instead > > the link to the group data was exported. Is it possible to export the > group > > data to CSV as well? Thank you > > > > -- > > -- > > 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/groups/opt_out. > > > > >

Apologies for the delayed response.

Because the JavaRosa XForm allows users to reuse names in their model as
long as the path is different (e.g. inside a group) ODK adds the repeat
group name in front to ensure that every column has a unique name in the
output. This may or may not be the right thing to do; I am simply
explaining why it was done this way several years ago (based on my memory).

Cheers,
Waylon

··· On Tue, Apr 16, 2013 at 10:55 PM, Trung Dang Le wrote:

Hi Waylon,
So far ODK Briefcase works greatly. One issue I have though: in the CSV
files, the header contains group name if a variable is in a group. I don't
know about others but for me in all the surveys I have done so far, this
part is redundant. It is because normally when you design a form, variable
names in the name column are unique and refer to the variable names you
want to use later on. Thus, we always need to write rename commands to
remove the group name.

It would be great if you can give some thoughts on this.

Thanks,
Trung.

On Tuesday, April 16, 2013 3:09:01 PM UTC+7, Waylon Brunette wrote:

Pema,

Please use ODK Briefcase if you wish to download the repeat data.
Below are two previous email threads from the mailing list that
discuss the issue and provide more detail.

https://groups.google.com/forum/?fromgroups=#!search/
exporting$20repeats$**20briefcase/opendatakit/**li6v7AW7qxQ/GMAik9l_PLEJhttps://groups.google.com/forum/?fromgroups=#!search/exporting$20repeats$20briefcase/opendatakit/li6v7AW7qxQ/GMAik9l_PLEJ

https://groups.google.com/forum/?fromgroups=#!search/
exporting$20repeats$**20briefcase/opendatakit/**ytAjdJqa104/LzsVYNxd69MJhttps://groups.google.com/forum/?fromgroups=#!search/exporting$20repeats$20briefcase/opendatakit/ytAjdJqa104/LzsVYNxd69MJ

Cheers,
Waylon

On Tue, Apr 16, 2013 at 12:52 AM, pema namgay peman...@gmail.com wrote:

After using ODK collect and successfully submitting your data online to
your
ODK Aggregate server, data export to a CSV format is possible. One
issue, I
faced with the export is that the group data were not exported but
instead
the link to the group data was exported. Is it possible to export the
group
data to CSV as well? Thank you

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@**googlegroups.com
Options: http://groups.google.com/**group/opendatakit?hl=enhttp://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/**groups/opt_outhttps://groups.google.com/groups/opt_out.

--

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/groups/opt_out.

This is an "ugly" fix, but in the CSV file in Excel, you can select the
first column, search for "*:", and replace with "". I believe this should
work for everything except gps coordinates, since they are stored as e.g.
q12:longitude q12:latitude q12:altitude, etc. and performing the
find-replace will remove the relevant "q12" part. I do this in excel rather
than Stata since Stata does not allow : and therefore removes them, making
it harder to identify and cut out the unnecessary prefix - not sure how
other programs treat that character.

··· On Wednesday, April 24, 2013 3:20:37 PM UTC-4, Waylon Brunette wrote: > > Apologies for the delayed response. > > Because the JavaRosa XForm allows users to reuse names in their model as > long as the path is different (e.g. inside a group) ODK adds the repeat > group name in front to ensure that every column has a unique name in the > output. This may or may not be the right thing to do; I am simply > explaining why it was done this way several years ago (based on my memory). > > Cheers, > Waylon > > > On Tue, Apr 16, 2013 at 10:55 PM, Trung Dang Le <trung...@gmail.com wrote: > >> Hi Waylon, >> So far ODK Briefcase works greatly. One issue I have though: in the CSV >> files, the header contains group name if a variable is in a group. I don't >> know about others but for me in all the surveys I have done so far, this >> part is redundant. It is because normally when you design a form, variable >> names in the name column are unique and refer to the variable names you >> want to use later on. Thus, we always need to write rename commands to >> remove the group name. >> >> It would be great if you can give some thoughts on this. >> >> Thanks, >> Trung. >> >> >> On Tuesday, April 16, 2013 3:09:01 PM UTC+7, Waylon Brunette wrote: >> >>> Pema, >>> >>> Please use ODK Briefcase if you wish to download the repeat data. >>> Below are two previous email threads from the mailing list that >>> discuss the issue and provide more detail. >>> >>> https://groups.google.com/**forum/?fromgroups=#!search/** >>> exporting$20repeats$**20briefcase/opendatakit/**li6v7AW7qxQ/GMAik9l_PLEJ >>> >>> https://groups.google.com/**forum/?fromgroups=#!search/** >>> exporting$20repeats$**20briefcase/opendatakit/**ytAjdJqa104/LzsVYNxd69MJ >>> >>> Cheers, >>> Waylon >>> >>> On Tue, Apr 16, 2013 at 12:52 AM, pema namgay wrote: >>> > After using ODK collect and successfully submitting your data online >>> to your >>> > ODK Aggregate server, data export to a CSV format is possible. One >>> issue, I >>> > faced with the export is that the group data were not exported but >>> instead >>> > the link to the group data was exported. Is it possible to export the >>> group >>> > data to CSV as well? Thank you >>> > >>> > -- >>> > -- >>> > 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/**groups/opt_out. >>> >>> > >>> > >>> >> -- >> -- >> 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/groups/opt_out. >> >> >> > >

A less "ugly" fix would be to write codes in Stata (I believe the separator
is "-" instead of ":" and stata automatically eliminates it when importing
from CSV using command insheet). You can just rename or renvars but it
requires unnecessary works I think.

··· On Thursday, April 25, 2013 8:19:56 PM UTC+7, Katherine Hoffmann wrote: > > This is an "ugly" fix, but in the CSV file in Excel, you can select the > first column, search for "*:", and replace with "". I believe this should > work for everything except gps coordinates, since they are stored as e.g. > q12:longitude q12:latitude q12:altitude, etc. and performing the > find-replace will remove the relevant "q12" part. I do this in excel rather > than Stata since Stata does not allow : and therefore removes them, making > it harder to identify and cut out the unnecessary prefix - not sure how > other programs treat that character. > > > > On Wednesday, April 24, 2013 3:20:37 PM UTC-4, Waylon Brunette wrote: >> >> Apologies for the delayed response. >> >> Because the JavaRosa XForm allows users to reuse names in their model as >> long as the path is different (e.g. inside a group) ODK adds the repeat >> group name in front to ensure that every column has a unique name in the >> output. This may or may not be the right thing to do; I am simply >> explaining why it was done this way several years ago (based on my memory). >> >> Cheers, >> Waylon >> >> >> On Tue, Apr 16, 2013 at 10:55 PM, Trung Dang Le wrote: >> >>> Hi Waylon, >>> So far ODK Briefcase works greatly. One issue I have though: in the CSV >>> files, the header contains group name if a variable is in a group. I don't >>> know about others but for me in all the surveys I have done so far, this >>> part is redundant. It is because normally when you design a form, variable >>> names in the name column are unique and refer to the variable names you >>> want to use later on. Thus, we always need to write rename commands to >>> remove the group name. >>> >>> It would be great if you can give some thoughts on this. >>> >>> Thanks, >>> Trung. >>> >>> >>> On Tuesday, April 16, 2013 3:09:01 PM UTC+7, Waylon Brunette wrote: >>> >>>> Pema, >>>> >>>> Please use ODK Briefcase if you wish to download the repeat data. >>>> Below are two previous email threads from the mailing list that >>>> discuss the issue and provide more detail. >>>> >>>> https://groups.google.com/**forum/?fromgroups=#!search/** >>>> exporting$20repeats$**20briefcase/opendatakit/** >>>> li6v7AW7qxQ/GMAik9l_PLEJ >>>> >>>> https://groups.google.com/**forum/?fromgroups=#!search/** >>>> exporting$20repeats$**20briefcase/opendatakit/** >>>> ytAjdJqa104/LzsVYNxd69MJ >>>> >>>> Cheers, >>>> Waylon >>>> >>>> On Tue, Apr 16, 2013 at 12:52 AM, pema namgay wrote: >>>> > After using ODK collect and successfully submitting your data online >>>> to your >>>> > ODK Aggregate server, data export to a CSV format is possible. One >>>> issue, I >>>> > faced with the export is that the group data were not exported but >>>> instead >>>> > the link to the group data was exported. Is it possible to export the >>>> group >>>> > data to CSV as well? Thank you >>>> > >>>> > -- >>>> > -- >>>> > 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/**groups/opt_out. >>>> >>>> > >>>> > >>>> >>> -- >>> -- >>> 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/groups/opt_out. >>> >>> >>> >> >>

Dear W_Brunette,
i think the link provided isn't working

https://github.com/getodk/briefcase/releases/download/v1.17.4/ODK-Briefcase-v1.17.4.jar

Hi @Owura_Effah_Ampem,

Adding to the link provide, checkout the documentation on how to use the tool.

Thank you
:smiling_face_with_three_hearts: