I have just discovered that I mistakenly gave same name to the repeat group and to one of the elements in the questionnaire. I was trying to investigate the reason why data captured in the repeat group was not being displayed in the kobo table as well as when I download in excel but it shows in Enketo form when I open individual forms. I renamed the other data element and uploaded questionnaire and redeployed but still data from the repeat group is not showing and neither is it showing in the excel download and now even when I open the questionnaire using Enketo the data disappears.
I need help on how best to deal with this issue. I have read several support articles and I can’t seem to find one that is exactly like my issue.
Welcome to the community, @BaMwamba! You got that correct. The table view does not allow you to view the entire repeat group in the UI, as the repeat group is a bit complex. Having said that, you should still be able to get the repeat group when you try to download it in the XLS format. Did you not see a different sheet when downloading your data in XLS format? Data from the repeat group is stored in a different sheet when you download them.
FYR, here is a similar post that should explain to you how the data is stored in a different sheet for a repeat group.
Hi @Kal_Lam : thank you for your informative feedback. I have two separate repeating groups in my questionnaire and I can see the data for one perfectly well in both Kobo and even when I download. However the repeating group which has a similar name with another element in my questionnaire is the one which is not displaying the data. even after renaming the other element (to prevent the name conflict) and uploading my questionnaire and redeploying. I could share my credentials so that you see what I am referring to whenever you have time to look at it.
I am still in need of your kind help with my issue. I decided to remove the repeating group that had same name with one of the other element and only retained that element but now I can’t download the data in XLS format which I am using to link to PowerBI. I am able to download data in XLS (Legacy) but that’s not what I want to use or rather it is not linked to PowerBI. I have tried to download the XLS Form, reupload and reloading (Now I am at 47 versions), I have tried unchecking the include data from all 46 versions, I have tried activating the Select Questions to download but to no avail. I keep getting Export failed. I did validate my XLS Form on ODK XLS Form validator and it validated without errors. Please help, why can’t I download the data in XLS format? I have attached the form. aEgVP5Bq43vZPirCBmSqSr (1).xlsx (56.8 KB)