Submission submitted from KoBoCollect android app but not appearing in database

OK, there could be one issue here. If you are able to identify the enumerator who is using the device for that particular study_id, would you mind checking the date and time of that device and see if they are correct?

Hi @Kal_Lam

Sure I can do that, It may take a little bit of time to get a response but I will liaise with the local coordinator.

As far as I understand it was multiple devices (multiple enumerators) that submitted the 6 different studyID on 31/12/2020.

If the device time/date was incorrect would the submission fail to upload to the server or would it successfully upload with an incorrect interview_date?

Best wishes

Catherine

1 Like

Or, if the dates were correct, also please ensure that those forms were not edited on the that particular date. I guess these cases were edited hence there could be a date difference.

Thanks @Kal_Lam
I am just tring to understand if I understand your last point correctly.

If the device date and time was correct, the second possible issue is that they edited the form.

If a form was in their ‘Edit saved forms’ section of the kobo collect app, the enumerator edits the form and then marks it as completed, then it automatically moves from the ‘Edit saved forms’ section into ‘Send finalized form’, once they select the forms to send they automatically move into ‘view sent form’ section of the kobo collect app.

Why after these steps would the form fail to appear on the server?

Best wishes

Catherine

No worries for now. Let us see the date and time of the device first.

Dear @Kal_Lam

We have asked coordinators to check if date and time of device is correct, while they can do that there is no way to verify whether it was correct or not on 31/12/2020.

I have noticed that the number of submissions on the server states 70320

however I am just after downloading the data about half hour ago and there are 70313 submissions, so there are 7 submissions on the server but not getting into the downloaded data. Maybe this includes the 6 submissions I am referring to in this thread (StudyID missing=11182802, 11396304, 12198301, 12269201, 13374001, 31785202 all submitted 2020-12-31).

Is there any way for you to test this from your side?

Best wishes

Catherine

1 Like


OK so this could a sync issue @cp622. Will get back to you when fixed.

@cp622, would you mind checking the missing case. It should now be solved.

1 Like

Hi @Kal_Lam

Many thanks for investigating this for us, what ever you did has fixed our issue, thank you for that, as you can see in today’s download the IDs from 31st Dec are now in the file,

Many thanks, if it happens again I will post to this thread so you can apply the same fix.

Best wishes

Catherine

1 Like

Thank you for confirming @cp622!

having the same problem.how do solve it

how do i message you please

Welcome to the community, @cena! Could you share with me the following through a private message:

  • Username
  • Project name
  • Server

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

@cena, could you also explain a bit about your issue?

Hello, our team has been facing the same problem- field workers are collecting data and even sending it. from their Kobo Collect mobile applications The form appears on their ‘View Sent Forms’ (with a green cloud symbol). However, despite that we do not see the submission on our kobo server. We have also faced this problem a couple of times before.
Please do guide us on this.

@nidhi_h, do you see any deviations in the total number of submissions (as seen in the top right corner) and the total as shown in the table?

If both these figures are the same, then it should not be the case of a sync issue.

Yes, both the total submissions and table figures are the same. But, as seen below there are entries where the start date is January 4th and end date is only Jan 13th or Jan 20th.

Screenshot 2022-02-08 at 17.05.38

Moreover, our field functionaries are reporting they have submitted the data and we can see their sent forms in their View Sent Forms section too. But we have not yet received the data.

Maybe it’s because they collected the data on 4th January and made some edits on 13th January. You will need to confirm this or make some dummy entry and edit the same on a different date to see how the date behaves.

Could you explain this a bit on how you validated who sent the submissions to the server? Did you have some variables (like the name of the enumerator, district, or some sort of area assigned to the enumerator) that could track this in the dataset?

Yes, we have name of the District, ICDS project, ICDS Beat and centre to validate who sent the submissions. For e.g. in the photo below: the ICDS supervisor has submitted the following forms for each of her Beat on February 6, 2022 but as of February 15, 2022 this entry does not show on our server.