I am trying to survey few households in my area. The logic is to collect the details of house like houseno,wardno and then the number of members present in the house and then to collect the details like name,age and sex of the all the members.
To make the same possible came to know about the repeat feature in XLSForms.
i.e Once entering the basic details of house and no. of members a repeat function is called based on the no. of members to collect the name, age and sex of the members.
Now tried running the Form using Google Drive and Aggregate and in both the instances encountered few errors as below.
-
While using ODK Collect & Google Drive
While submitting data to Google Sheets from ODK Collect the error thrown in ODK Collect was member_count is an invalid column name in your form. Came to knew that though i had not created any column name with an _ , the online ODK XLSForm creator actually creates a member_count tag in the xml file which caused error in creating the column names in Google sheets.
I was able to resolve the issue by editing the xml file and renaming the member_count tag as member-count tag.
Eventhough i was able to resolve the issue, the data submitted from ODK Collect stored only the final repeat value in the row.
i.e for a househould, i gave basic details and member count as 2 and then entered name age and sex of two person and submitted. but in the google sheet the data present was the basic details and data of the second person.
How to resolve this issue? i.e i need the basic data along with all the repeat group datas in the same google sheet.? -
While trying to use the form with Aggregate, it works fine, but again the data of the repeat groups are clubbed as a separate entity and in csv export also it comes as an external data?
Is there a way to combine the repeat data along with the basic data and present as a single csv.