Rating data missing

medi_ashenafi · February 23, 2022, 8:51am

Urgent!
I couldn’t find the recorded data under rating question types either on kobo table or exported XLS file even though the data is submitted successfully. All the questions are mandatory.

is there any way I can get those data? what’s the solution?

thanks

hakan_cetinkaya · February 23, 2022, 9:17am

Welcome to the community @medi_ashenafi,

Can you provide a screenshot of your rating question? And the answers related to that question?

Let’s see if I can help you.

medi_ashenafi · February 23, 2022, 9:26am

HI @hakan_cetinkaya, here is the screen shot of the rating question

here is the blank response

medi_ashenafi · February 23, 2022, 9:43am

@hakan_cetinkaya ,
here is also what the exported data looks like.

hakan_cetinkaya · February 23, 2022, 10:03am

Hi @medi_ashenafi,

Did you make modifications to your form after people start submitting?

medi_ashenafi · February 23, 2022, 10:06am

@hakan_cetinkaya , No i didn’t

hakan_cetinkaya · February 23, 2022, 10:12am

@medi_ashenafi which editor are you using to edit your form? Are you using KoBo’s internal editor or are you using an XLS editor (excel for example)?

Also can you go to the Data > Downloads and open advanced options and provide a screenshot from there aswell?

medi_ashenafi · February 23, 2022, 10:20am

I Used KoBo’s enteral editor

hakan_cetinkaya · February 23, 2022, 10:37am

The Include data from all 10 versions option shows that there are at least 9 modifications made to this form after it published. Do you know if the questions were in each version and they were all mandatory in each version?

Also can you provide a screenshot of the rating question in the form builder?

medi_ashenafi · February 23, 2022, 10:38am

@hakan_cetinkaya , i tried entering data and it popped this window when submitting the data and it took me to a new form when I press the 'load record ’ . does it affect the recorded data?
photo_2022-02-23_13-09-24

hakan_cetinkaya · February 23, 2022, 10:41am

Hi @medi_ashenafi,

This screen shows up if you start filling a form and did not submit it yet, it autosaves the form to the cache of your browser. Not to the actual server.

So if you are seeing this pop-up it means the data in the latest form is not submitted to the server.

medi_ashenafi · February 23, 2022, 10:46am

@hakan_cetinkaya, I will check whether the all the questions are in each version and also check if all the rating questions are mandatory.

screenshot of the rating question

medi_ashenafi · February 23, 2022, 10:55am

@hakan_cetinkaya, check out the version history, I deployed the last version.

hakan_cetinkaya · February 23, 2022, 11:12am

@medi_ashenafi,

To check if the questions are actually answered, can you click on the button which looks like an eye (open button, just left to the icon looks like a pencil.) in here and see if the respondants actually gave any answers to your rating questions?

medi_ashenafi · February 23, 2022, 11:48am

@hakan_cetinkaya , NO, it doesn’t show any response to those parts of the question. I wonder why though.

hakan_cetinkaya · February 23, 2022, 11:52am

@medi_ashenafi, I think, most likely the rating questions were not mandatory in the previous versions.

Can you provide us with details after checking that?

Kal_Lam · February 23, 2022, 2:54pm

@medi_ashenafi, could you also download your data in XLS (legacy) format to see if you can see the missing data there? Kindly please let us know what happens.

medi_ashenafi · February 24, 2022, 10:07am

@Kal_Lam, Now I can see the responses under the rating question, Thank you for the help.

Kal_Lam · February 24, 2022, 1:16pm

@medi_ashenafi, are you able to in both the formats (XLS and XLS (legacy)?

medi_ashenafi · February 24, 2022, 1:23pm

@Kal_Lam, only on the XLS (legacy)