Missing data in table and download

effy1988 · July 28, 2021, 3:35pm

Hello,
One data column does not appear when downloading (with the all versions option ticked), neither does it appear in the table, however it does appear in the report section (variable “name”). See screenshots attached - the Excel downloaded database missing the name, the report showing it, I have also attached the XLS form source file (with the question “name” and “other-autre” - which does appear in downloaded data.

Edit afterwards: I just realized the repeat_groups are also missing from the downloaded data… Although they appear when viewing the form, which is deployed.

What could be the problem?
Many thanks!

dataexcel

Kal_Lam · July 28, 2021, 4:46pm

Welcome to the community, @effy1988! Did you make edits and redeploy?

effy1988 · July 29, 2021, 7:35am

Hi @Kal_Lam , many thanks for the quick reply. Yes I did make edits and redeploy, earlier in the month - not recently. Have checked the form history, it is redeployed correctly.

effy1988 · August 2, 2021, 1:07pm

Hello @Kal_Lam , it’s now all fine!! I don’t know what happened - didn’t change anything… But it’s all good?!

Kal_Lam · August 2, 2021, 1:48pm

Thank you for confirming @effy1988!

effy1988 · October 15, 2021, 8:55am

Hello @Kal_Lam ,
Same issue is happening again - same data missing from the table and download… As well as the repeat groups data. With the same file.
I did make edits few weeks and redeploy, all ok.
Any idea what could be causing the issue?
E

Kal_Lam · October 18, 2021, 2:25pm

@effy1988, could you explain what is missing? Maybe with a screenshot so that we should also be able to understand your issue pictorially?

effy1988 · October 19, 2021, 10:39am

Hi @Kal_Lam, thanks for your reply. There are screenshots above showing the issue - it’s the same issue happening again. Last time, somehow it solved itself - but it reappeared?
Let me know if those screenshots are enough.
Thanks

Kal_Lam · October 19, 2021, 2:29pm

@effy1988, is it the same data column tech_autre that is not visible or is it a different one this time?

effy1988 · October 19, 2021, 2:55pm

@Kal_Lam , The column “nom” is not appearing - in the middle screenshot (XLS spreadsheet), you can see that there should be a column “nom” before “tech_autre”.
Repeat groups are also absent.

Kal_Lam · October 19, 2021, 3:08pm

OK as a quick check would you mind to see if your latest deployed survey form has this question? If no, we could explore further.

effy1988 · October 19, 2021, 3:47pm

Have just checked, yes it does have this question.

Kal_Lam · October 19, 2021, 5:13pm

Could you share with me the following through a private message:

Username
Project name
Server

Kal_Lam · October 29, 2021, 5:33am

@effy1988, I see the variable tech_autre and nom under your DATA>Table:

effy1988 · October 29, 2021, 7:07am

Hum… Indeed it now appears again… Honestly, not sure what happened, but I had downloaded the data yesterday and it was missing. Today it reappeared. I haven’t changed any download settings etc.
Same happened last time - reappeared after a few days.
Any idea where this might come from? As not ideal when we need the data on the day…
Thanks!

Kal_Lam · October 29, 2021, 8:08am

@effy1988, thank you for confirming. I simply changed the DATA>Table label view from label to XML values.

effy1988 · October 29, 2021, 10:50am

Thanks for the explanation, but that still does not explain why the data column including the repeat group data was missing from the download? I had downloaded w XML values.