One column of data missing

User Support Data Management
,
1

Hi @Kal_Lam ,
Hope you’re doing well :slight_smile: we are experiencing a problem with Kobo.
153 forms have been submitted and one column of data is missing in all of them.
How can we retrieve this data? I have checked related posts but have not been able to solve the issue.

I have downloaded the data with all previous versions, checked the very end of the form to see if the column is there. But it isn’t.

We can’t see the data when we view the data using Kobo either.

Could you kindly help us please? Thank you

2

Welcome to the community, @alex! Did you make changes to your survey project and then redeploy?

3

Thanks @Kal_Lam :slight_smile: yes we did but not regarding the question that has the missing data. The form was edited and redeployed and the users state that they refreshed the page before using the redeployed form.

4

Are you able to see the missing question when trying to fill up an blank form?

5

Yes, we are able to see the answer now as well. But the data from previous forms is gone. for that specific question.

1 Like
6

@Kal_Lam Yes, we are able to see the answer now as well. But the data from previous forms is gone. for that specific question.

1 Like
7

@alex, have you gone through our support article Recovering Data From Previous Form Versions? It should help you solve your issue.

8

@Kal_Lam yes I did before I wrote here, but it did not solve my problem. I already tried downloading the data with and without all previous versions.

9

OK, could you share with us a screenshot of the column that is missing in the download and is visible in the DATA>Table view (or vice-versa if it should be).

10

@Kal_Lam sure, thank you :slight_smile:

image
image739×792 33.1 KB

image
image508×643 13.8 KB

11

So which one is present and which one is missing? Could you also mark them so that it would be easier for us to distinguish?

13

Sorry I didn’t specify.
The blank E column is the column which should have data, but the entire column is blank. It is a question (phone number question) and enumerators have entered data under this question but no data is appearing.

14

Can you see the phone number question in the DATA>Table?

15

Yes we can.
For some reason we can also see 3 phone number entries out of 162

16

OK. Would you also mind sharing with me the following through a private message so that we could have a closer look at it:

  • Username
  • Project name
  • Server

You could send me a private message as outlined in the post discussed previously:

18

@alex, when looking at your survey project more closely I could observe that there were a total of 19 redeployments. The 19th redeployment had the missing variable i.e. phone number in it (FYR):

V19
V19842×218 7.23 KB

But when looking at your 7th redeployment I did not see the missing variable i.e. phone number there (FYR):

V7
V7918×468 17.2 KB

So this seems to be the reason you are seeing the values missing for the said variable in your survey project.

19

Thank you so much Kal.
:frowning: does this mean in V7 there never was a phone number question ?
So there is no data at all right ?

1 Like
20

You got that correct!

21

But what about the data that they have entered after version 7?
The form had been redeployed and the phone number question was appearing.
So all the data is gone and can’t be retrieved ?
How do we stop this from happening again?
Is it a case of having not redeployed the form at some point ?

22

I checked myself too seems the question was added in September :frowning: and there cant be any data prior to that. Sorry to trouble you :frowning:

1 Like