Missing data in table & download but is present when previewing

gunslinger · November 22, 2021, 2:47am

Hi Kal_LAm,
I have an issue with one of our kobotoolbox forms. I can view the entries in their submissions but when I download the data submitted via xls, there are some information that is not included, specifically, the gender name and other information under the same grouping.

Thank you and looking forward to your assistance.

I have attached a screenshot and a sample data extract that I did. I also included in this PM the xls file of the form.ESMF2_Test_Data.xlsx (176.3 KB)
Processing: ESMF 2 Project Worker Sample Form with Answers.docx…
Processing: ESMF 2 Project Worker Sample Form with Answers.pdf…
2.xlsx (23.8 KB)

Kal_Lam · November 22, 2021, 3:36am

@gunslinger, could you be specific on what is missing in the downloaded format so that we could funnel down the issue and troubleshoot?

gunslinger · November 22, 2021, 5:25am

I cant find anywhere in the table the responses for Full Name, Gender, Work Type, Employment Type, etc.

Kal_Lam · November 22, 2021, 5:49am

@gunslinger, could you share with me the following through a private message so that we could have a closer look at your case:

Username
Project name
Server

Kal_Lam · November 22, 2021, 6:48am

@gunslinger, would you also mind sharing the project name so that we could investigate?

Milanoka · November 22, 2021, 9:39am

Have you tried search?

gunslinger · November 23, 2021, 1:31am

I cant see it in the spreadsheet. I dont understand the search that you just mentioned.

Kal_Lam · November 24, 2021, 6:08am

@gunslinger, when having a closer look at your issue, I observed the following in your XLSForm:

This shows that the information that you are seeking under the DATA>Table and your download which you say is missing is from the repeat group. I could see the repeat group data as shown in the image below when downloading your data as XLS format:

Please note that repeat group data resides in a different sheet as the structure of the repeat group data is a bit complex. Hence they are not displayed in the DATA>Table too.

gunslinger · November 25, 2021, 7:27am

Thank you. Makes sense now. I tried downloading the default data set and not only my selected fields and I got the additional sheets that you indicated for each repeat group.
Much appreciated.

More power to your team!

angelajim · November 29, 2021, 2:03am

Hello.
I have the same problem. I can see data in the preview but when I download the file, there are not the other sheets I had last week.

(Today I only have 2 of the 6 sheets I had last week, the missing sheets are in the red square in the image)

I sent you in a private message futher information about my project.
Thank you.

Kal_Lam · November 29, 2021, 5:10am

@angelajim, before i make a check at my end could you ensure that you have the repeat group questions for those missing sheets in your latest deployed survey project? I guess that you redeployed your survey project removing those repeat group questions. If you did the same, you could see the sheets missing.

angelajim · November 29, 2021, 11:27am

Hi. Thank you for your fast answer.
I just check but in my deployed survey project still are the group question, as you can see in the image.

Thank you.

Kal_Lam · November 29, 2021, 3:07pm

You should be able to check it more effectively by downloading your data as XLSForm.

angelajim · November 29, 2021, 3:51pm

Hello.
I dowloaed asXLS form, like this, but some sheets are still missing

Josh · November 29, 2021, 6:24pm

Hi @angelajim, the issue seems to be that when the fields are selected in the advanced export options, the repeat groups aren’t being exported correctly. Can you please toggle this setting off and try again? It seemed export all your data in my test:
export
I will take a look into the cause of this, but in the meantime please continue your exports in this manner.

Josh · November 29, 2021, 10:32pm

Hi @angelajim, I have tracked the root of this down to an old issue that wasn’t correctly fixed (by me ). I’ve reopened the issue and will deal with it soon:

angelajim · November 30, 2021, 2:41am

Thank you so much. I hope you could fixe it.

angelajim · November 30, 2021, 2:35pm

Hello again.
It seems the problem its only with the option of download named “xml values and headers”. With this option group questions don’t appear and URL links either. I tried the option “labels” and the donwloaded file has all the missing information with the other download option, as you can see in the next image.

Kal_Lam · November 30, 2021, 3:20pm

Thank you for adding further details to the discussion @angelajim!

Stokes · December 8, 2021, 1:37pm

I have been having an issue lately with my data not showing up after I apply changes in the Queryt Editor.
The data will be there to start with, but if I “Enable Load” then decide later that I do in fact need that table to load in, so select Enable Load again, the data does not show up. It loads in the Column names, but it appears as if the tables are empty. Has anyone else had an issue like this? Am I missing something simple?

MyBalanceNow