I am struggling slightly with repeat grouping questions / collected data.
Currently I have a survey form setup with NO repeat groups, which is working wonderfully. This gets pulled into Aggregate, and from there I use Briefcase to export it to CSV, from CSV into Mysql DB, storing text and reference/ links to the media images in the DB.
However I want to start making use of the repeat group feature, I have noticed that with a repeat group, and individual csv file gets created for each group - which is a problem for me importing that file into my mysql DB. The way its setup is that each form submission imports into its own row into mysql, but I cannot get my head around as to how I can add "multiple rows for each submission" into_ mysql.
Currently I am designing my form in such a way that I do not need repeat groups, but in future it is inevitable that I will need this feature.
Please can somebody assist in how add the individual repeat groups into my mysql db,