Problem getting nested repeat group to publish to Fusion Tables properly

Support
1

Hello,

 I'm not sure how to explain this simply.  Basically I have a repeat

group to break down a product into constituent components using values
derived from a CSV file (test.csv). Then I nest another repeat group
within the parent to break down each of the components into their active
ingredients, again using values pulled in from a CSV file (test-ai.csv).
The good news is it works. Everything looks like it should within ODK
Aggregate. The problem is when I publish to Google Fusion Tables where my
target audience will get the results from. Four Fusion Tables result,
which is fine. The trouble is the Table for the active ingredients, the
nested repeat group, only reports the results from the final repetition of
the group. I've been trying to find a way around this but I've been
stymied and publishing it into Fusion Tables is almost a necessity.

 Below is the code.  I don't have much hair left so I would be grateful

for any ideas you may have.

Thank you!

<?xml version="1.0"?>

<h:html xmlns="http://www.w3.org/2002/xforms"
xmlns:h="http://www.w3.org/1999/xhtml"
xmlns:ev="http://www.w3.org/2001/xml-events"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:jr="http://openrosa.org/javarosa"
xmlns:odk="http://www.opendatakit.org/xforms">

<h:head>
<h:title>test</h:title>





2
3















  </instance>
<-- Parent group -->


<-- Nested group -->





</model>

</h:head>

<h:body>

Which product are you using: AA BB C_and_DC_and_D EE FF GG HH II JJ KK LL MM N_and_ON_and_O PP How much?


Components Calc

AI Calc Dummy field that doesn't do anything except make the loop work. Dummy field that doesn't do anything except make the loop work.

</h:body>
</h:html>

2

Hi Greg,

I'm sorry that the Fusion Tables integration has been causing hair loss!

I have been able to replicate this is a bug and filed it at
https://github.com/opendatakit/opendatakit/issues/1264. Until a fix
can be found, the best workaround is not to use repeats inside
repeats.

Thanks,

Yaw

ยทยทยท On Tue, Nov 29, 2016 at 4:01 PM, Greg wrote: > Hello, > > I'm not sure how to explain this simply. Basically I have a repeat > group to break down a product into constituent components using values > derived from a CSV file (test.csv). Then I nest another repeat group within > the parent to break down each of the components into their active > ingredients, again using values pulled in from a CSV file (test-ai.csv). > The good news is it works. Everything looks like it should within ODK > Aggregate. The problem is when I publish to Google Fusion Tables where my > target audience will get the results from. Four Fusion Tables result, which > is fine. The trouble is the Table for the active ingredients, the nested > repeat group, only reports the results from the final repetition of the > group. I've been trying to find a way around this but I've been stymied and > publishing it into Fusion Tables is almost a necessity. > > Below is the code. I don't have much hair left so I would be grateful > for any ideas you may have. > > Thank you! > > > <?xml version="1.0"?> > xmlns:h="http://www.w3.org/1999/xhtml" > xmlns:ev="http://www.w3.org/2001/xml-events" > xmlns:xsd="http://www.w3.org/2001/XMLSchema" > xmlns:jr="http://openrosa.org/javarosa" > xmlns:odk="http://www.opendatakit.org/xforms"> > > > test > > > > > > 2 > 3 > > > > > > > > > > > > > > > > > > > > > > > > > > <-- Parent group --> > calculate="position(/test/Components)"/> > calculate="concat(/test/ProductsList,'#',string(/test/Components/CompLoopNumb))"/> > > calculate="pulldata('test','fraction','Products_key',/test/Components/CompProdListNumb)"/> > > calculate="pulldata('test','ProductComponent','Products_key',/test/Components/CompProdListNumb)"/> > > calculate="/test/Amount * /test/Components/ProductMixFrac"/> > <-- Nested group --> > calculate="position(/test/Components/AI)"/> > calculate="concat(/test/Components/ProductCompName,'#',string(/test/Components/AI/AILoopNumb))"/> > calculate="pulldata('test-AI','ActiveIngredientName','ProductComponent_key',/test/Components/AI/AICompListNumb)"/> > calculate="pulldata('test-AI','Guarantee','ProductComponent_key',/test/Components/AI/AICompListNumb)"/> > calculate="/test/Components/ComponentPureAmount * > /test/Components/AI/AIfrac"/> > relevant="/test/LoopNumb = 10"/> > > relevant="/test/LoopNumb = 10"/> > > > > > > > > Which product are you using: > AA > BB > C_and_DC_and_D > EE > FF > GG > HH > II > JJ > KK > LL > MM > N_and_ON_and_O > PP > > > > How much? > > > > > Components Calc > > > > > AI Calc > > > > > > Dummy field that doesn't do anything except make the loop > work. > > > > > > > > Dummy field that doesn't do anything except make the loop > work. > > > > > > > > > > -- > -- > 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.