I'm using Collect 1.1.7 and Aggregate 1.0 RC3. I have made a simple form to
collect a series of gps coordinates during a transect walk. To do this I
have one field (gps1) nested inside a looped group (gpsgrp), allowing me to
enter as many locations as I want without the need for separate fields for
each gps reading (e.g. gps1, gps2, gps3...gps20 for 20 locations). The data
collection works fine and displays perfectly on Aggregate. However, when I
export the data as a CSV file, in the grouped field column (gpsgrp) this
appears: https://xxxxx.appspot.com/view/formMultipleValue?
formId=build_xxxxxx_1320071424%5B%40version%3Dnull+and+%
40uiVersion%3Dnull%5D%2Fdata%5B%40key%3Duuid%3A7a67a6c3-f965-44d8-b0f2-d4c934948cc7%5D%2Fgpsgrp
(note: in this post I have replaced my actual appspot name and form name
with xxxxx)
I'd appreciate it if somebody could explain the reason for this and how I
can display the real gps data that I collected.
One quick question: Is a bulk delete option in the pipeline to remove
multiple records from Aggregate? We have a large dataset stored on our
Aggregate instance which is incredibly slow to show up (although changing
the number of displayed records to, say, 50 helps). I'd like to
systematically delete entries submitted for an entire day at a time.
If you generate a CSV from the user interface, the generated file has links
back to your server for displaying any nested data.
The ODK Briefcase application performs CSV generation similar to that in
Aggregate 0.9.x. If you use this application, you would download the
contents of your aggregate server to your local machine and it will then
generate a set of CSV files, one for each nested repeating group in your
form. These files have columns in them that allow you to link the repeats
back into the parent data (e.g., within the nested repeating group,
PARENT_KEY will identify the KEY for the corresponding parent record.
SET-OF-xxxx will match the SET-OF-xxxx between the two tables (this is
redundant but might be useful in some scripting situations).
You will still need to do the stitching together of the data.
Note that the Briefcase application currently does not remember what data
it has downloaded from the server, so it will download everything each time.
Mitch
···
On Tue, Nov 1, 2011 at 10:51 PM, wrote:
Hi everybody,
I'm using Collect 1.1.7 and Aggregate 1.0 RC3. I have made a simple form
to collect a series of gps coordinates during a transect walk. To do this I
have one field (gps1) nested inside a looped group (gpsgrp), allowing me to
enter as many locations as I want without the need for separate fields for
each gps reading (e.g. gps1, gps2, gps3...gps20 for 20 locations). The data
collection works fine and displays perfectly on Aggregate. However, when I
export the data as a CSV file, in the grouped field column (gpsgrp) this
appears: https://xxxxx.appspot.com/view/formMultipleValue?
formId=build_xxxxxx_1320071424%5B%40version%3Dnull+and+%
40uiVersion%3Dnull%5D%2Fdata%5B%40key%3Duuid%3A7a67a6c3-f965-44d8-b0f2-d4c934948cc7%5D%2Fgpsgrp
(note: in this post I have replaced my actual appspot name and form name
with xxxxx)
I'd appreciate it if somebody could explain the reason for this and how I
can display the real gps data that I collected.
One quick question: Is a bulk delete option in the pipeline to remove
multiple records from Aggregate? We have a large dataset stored on our
Aggregate instance which is incredibly slow to show up (although changing
the number of displayed records to, say, 50 helps). I'd like to
systematically delete entries submitted for an entire day at a time.
I haven't fully understood what this will look like, but I will follow
your instructions and I'm sure it'll be clearer when I see it.
Regards,
Glyn
···
On Nov 3, 4:56 am, Mitch Sundt wrote:
> If you generate a CSV from the user interface, the generated file has links
> back to your server for displaying any nested data.
>
> The ODK Briefcase application performs CSV generation similar to that in
> Aggregate 0.9.x. If you use this application, you would download the
> contents of your aggregate server to your local machine and it will then
> generate a set of CSV files, one for each nested repeating group in your
> form. These files have columns in them that allow you to link the repeats
> back into the parent data (e.g., within the nested repeating group,
> PARENT_KEY will identify the KEY for the corresponding parent record.
> SET-OF-xxxx will match the SET-OF-xxxx between the two tables (this is
> redundant but might be useful in some scripting situations).
>
> You will still need to do the stitching together of the data.
>
> Note that the Briefcase application currently does not remember what data
> it has downloaded from the server, so it will download everything each time.
>
> Mitch
>
>
>
>
>
>
>
>
>
> On Tue, Nov 1, 2011 at 10:51 PM, wrote:
> > Hi everybody,
>
> > I'm using Collect 1.1.7 and Aggregate 1.0 RC3. I have made a simple form
> > to collect a series of gps coordinates during a transect walk. To do this I
> > have one field (gps1) nested inside a looped group (gpsgrp), allowing me to
> > enter as many locations as I want without the need for separate fields for
> > each gps reading (e.g. gps1, gps2, gps3...gps20 for 20 locations). The data
> > collection works fine and displays perfectly on Aggregate. However, when I
> > export the data as a CSV file, in the grouped field column (gpsgrp) this
> > appears:
> >https://xxxxx.appspot.com/view/formMultipleValue?
> > formId=build_xxxxxx_1320071424%5B%40version%3Dnull+and+%
> > 40uiVersion%3Dnull%5D%2Fdata%5B%40key%3Duuid%3A7a67a6c3-f965-44d8-b0f2-d4c9 34948cc7%5D%2Fgpsgrp
> > (note: in this post I have replaced my actual appspot name and form name
> > with xxxxx)
>
> > I'd appreciate it if somebody could explain the reason for this and how I
> > can display the real gps data that I collected.
>
> > One quick question: Is a bulk delete option in the pipeline to remove
> > multiple records from Aggregate? We have a large dataset stored on our
> > Aggregate instance which is incredibly slow to show up (although changing
> > the number of displayed records to, say, 50 helps). I'd like to
> > systematically delete entries submitted for an entire day at a time.
>
> > Many thanks,
> > Glyn
>
> > --
> > Post: opendatakit@googlegroups.com
> > Unsubscribe: opendatakit+unsubscribe@googlegroups.com
> > Options:http://groups.google.com/group/opendatakit?hl=en
>
> --
> Mitch Sundt
> Software Engineerhttp://www.OpenDataKit.org
> University of Washington
> mitchellsu...@gmail.com