Submissions in link

Halo Team,
Is there any one who may advice me on how to avoid having part of my
submissions in a "link" it is a repeat part of the form
And it is a link, instead of the normal results like the other variables.

Would like to know the mistake i made in form design, and or how to avoid
this kind of results in the future
Here is an example of the linked set of variables, associated with the link
results, and the result it's self.

  begin group production_sales PRODUCTION AND SALES OF MAIZE (Last Most 

Recent Season) selected(${farmer_type}, '1') and
selected(${proceed}, '1') and selected(${maize_grown1}, '1') begin repeat
plot PLOT field-list integer plot_number Plot number 1, 2, 3, or 4. .

= 1 and . <= 4 don't exceed four plots yes decimal plot_size What was
the size of this plot (acre) estimate size in acres yes decimal
qty_sd_used What was the Quantity of Maize Seed used on this Plot (kgs) in
the last season estimate the quantity in kilogrammes yes select_one
sd_type sd_type_used What was the Type of maize Seed used on this plot in
the last season yes select_one unit_type tt_sd_produced1 In what UNITS
did you Harvest the Maize on this plot in the last season yes minimal
decimal tt_sd_produced2 How many of these UNITS referred to in the previous
question did you Produce from this Plot in the last season yes decimal
tt_sd_weight What is the estimated Weight of each UNIT in Kilogrames? estimate
in kilogrammes yes selected(${tt_sd_produced1}, '1') or
selected(${tt_sd_produced1}, '2') or selected(${tt_sd_produced1}, '3') or
selected(${tt_sd_produced1}, '5') end repeat end group

and here is the type of result am getting from it!

https://bracresearch.appspot.com/view/formMultipleValue?formId=LEAD_Baseline_TZ_Data[%40version%3Dnull+and+%40uiVersion%3Dnull]%2FLEAD_Baseline_TZ_Data[%40key%3Duuid%3Ae4939f1f-2bab-4ad2-9b8f-491adf5e6e69]%2Fproduction_sales%3Aplot

Thank you for the Advice

(1) Use ODK Briefcase to download your results from ODK Aggregate to your
desktop.
Then use ODK Briefcase's Export to CSV function to emit csvs of your data.

You will have one csv for your main form, and one csv for each repeat group
within it. Link the two together via the PARENT_KEY and KEY fields.

(2) if publishing, instead of publishing to Google Spreadsheets, publish to
Google Fusion Tables.

You will get a separate fusion table for the main form and each repeat
group. And, we also generate a
fusion table that joins the main form with all the first-level repeat
groups (tying together the KEY and PARENT_KEY fields of these).

If you have nested repeat groups, you could define your own composite
Fusion Table with whatever result structure you need.

··· ================ (1) is good for analysis at the end of a survey or periodically throughout. (2) is good for continuous access to incoming data, as once you set up the publisher, and the tables, the data just flows into them without any manual processing.

On Tue, Oct 21, 2014 at 7:38 AM, Oundo Moses wagson.2011@gmail.com wrote:

Halo Team,
Is there any one who may advice me on how to avoid having part of my
submissions in a "link" it is a repeat part of the form
And it is a link, instead of the normal results like the other variables.

Would like to know the mistake i made in form design, and or how to avoid
this kind of results in the future
Here is an example of the linked set of variables, associated with the
link results, and the result it's self.

  begin group production_sales PRODUCTION AND SALES OF MAIZE (Last

Most Recent Season) selected(${farmer_type}, '1') and
selected(${proceed}, '1') and selected(${maize_grown1}, '1') begin repeat
plot PLOT field-list integer plot_number Plot number 1, 2, 3, or 4. .

= 1 and . <= 4 don't exceed four plots yes decimal plot_size What was
the size of this plot (acre) estimate size in acres yes decimal
qty_sd_used What was the Quantity of Maize Seed used on this Plot (kgs)
in the last season estimate the quantity in kilogrammes yes select_one
sd_type sd_type_used What was the Type of maize Seed used on this plot in
the last season yes select_one unit_type tt_sd_produced1 In what UNITS
did you Harvest the Maize on this plot in the last season yes minimal
decimal tt_sd_produced2 How many of these UNITS referred to in the
previous question did you Produce from this Plot in the last season yes
decimal tt_sd_weight What is the estimated Weight of each UNIT in
Kilogrames? estimate in kilogrammes yes selected(${tt_sd_produced1},
'1') or selected(${tt_sd_produced1}, '2') or selected(${tt_sd_produced1},
'3') or selected(${tt_sd_produced1}, '5') end repeat end group

and here is the type of result am getting from it!

https://bracresearch.appspot.com/view/formMultipleValue?formId=LEAD_Baseline_TZ_Data[%40version%3Dnull+and+%40uiVersion%3Dnull]%2FLEAD_Baseline_TZ_Data[%40key%3Duuid%3Ae4939f1f-2bab-4ad2-9b8f-491adf5e6e69]%2Fproduction_sales%3Aplot

Thank you for the Advice

--

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

Thank you Mitch, it is working for me very wel

··· On Tue, Oct 21, 2014 at 8:16 PM, Mitch Sundt wrote:

(1) Use ODK Briefcase to download your results from ODK Aggregate to your
desktop.
Then use ODK Briefcase's Export to CSV function to emit csvs of your data.

You will have one csv for your main form, and one csv for each repeat
group within it. Link the two together via the PARENT_KEY and KEY fields.

(2) if publishing, instead of publishing to Google Spreadsheets, publish
to Google Fusion Tables.

You will get a separate fusion table for the main form and each repeat
group. And, we also generate a
fusion table that joins the main form with all the first-level repeat
groups (tying together the KEY and PARENT_KEY fields of these).

If you have nested repeat groups, you could define your own composite
Fusion Table with whatever result structure you need.

================
(1) is good for analysis at the end of a survey or periodically throughout.
(2) is good for continuous access to incoming data, as once you set up the
publisher, and the tables, the data just flows into them without any manual
processing.

On Tue, Oct 21, 2014 at 7:38 AM, Oundo Moses wagson.2011@gmail.com wrote:

Halo Team,
Is there any one who may advice me on how to avoid having part of my
submissions in a "link" it is a repeat part of the form
And it is a link, instead of the normal results like the other variables.

Would like to know the mistake i made in form design, and or how to avoid
this kind of results in the future
Here is an example of the linked set of variables, associated with the
link results, and the result it's self.

  begin group production_sales PRODUCTION AND SALES OF MAIZE (Last

Most Recent Season) selected(${farmer_type}, '1') and
selected(${proceed}, '1') and selected(${maize_grown1}, '1') begin
repeat plot PLOT field-list integer plot_number Plot number 1, 2, 3,
or 4. . >= 1 and . <= 4 don't exceed four plots yes decimal plot_size What
was the size of this plot (acre) estimate size in acres yes decimal
qty_sd_used What was the Quantity of Maize Seed used on this Plot (kgs)
in the last season estimate the quantity in kilogrammes yes select_one
sd_type sd_type_used What was the Type of maize Seed used on this plot
in the last season yes select_one unit_type tt_sd_produced1 In what
UNITS did you Harvest the Maize on this plot in the last season yes
minimal decimal tt_sd_produced2 How many of these UNITS referred to in
the previous question did you Produce from this Plot in the last season
yes decimal tt_sd_weight What is the estimated Weight of each UNIT in
Kilogrames? estimate in kilogrammes yes selected(${tt_sd_produced1},
'1') or selected(${tt_sd_produced1}, '2') or selected(${tt_sd_produced1},
'3') or selected(${tt_sd_produced1}, '5') end repeat end group

and here is the type of result am getting from it!

https://bracresearch.appspot.com/view/formMultipleValue?formId=LEAD_Baseline_TZ_Data[%40version%3Dnull+and+%40uiVersion%3Dnull]%2FLEAD_Baseline_TZ_Data[%40key%3Duuid%3Ae4939f1f-2bab-4ad2-9b8f-491adf5e6e69]%2Fproduction_sales%3Aplot

Thank you for the Advice

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/tnJStKmr1jo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
___________________________________
Moses Oundo Wanjere
Field Research Supervisor
(R.E.U) BRAC Uganda

*Office: *+256 (0) 759214286
*Home: *+256 (0) 700608210
*Mobile: * +256 (0) 774319504
Skype: oundo.moses.w.
Adress: P O Box 31817, Kampala Uganda