15000 submissions with 700 questions

Hello,

I’m having a challenge conducting large scale survey.
In which, 700 questions are asked and eventually, there will be 15000 submissions.
So far, we have collected 5000 submissions. However, the size became greater and we’re having a concern for upcoming submissions.
The problem is Kobo only allows to export all the data. If there is a filter export function, the size of exported file could be reduce significantly.

My question is, “is there any option to handle large scale data ?” To check missed data and find errors in submission.
Currently, I export the file to Google sheet and check the fields with formula.
But, the google sheet no longer accepts importing ,because of too large file.

I’m looking forward to any suggestions.

Thanks

Hi @NC_Chan,

There is an enhancement request to be able to filter records prior to export: Media download export option - ability to filter records

You may wish to add comments or vote on that enhancement, if you think it would help you too?

Best wishes!

1 Like

@NC_Chan cc: @nat

Maybe you could download your data as discussed previously:

@NC_Chan, @nat the system now allows you to download your data by filtering it by date (from the UI), as explained in this support article: Advanced options for exporting data.

Hi @Kal_Lam can you please re-open this topic? Actually it has only been partly solved - yes, we can export the submission content date-wise - which is GREAT! But we are still not able to export the media attachments date-wise - i.e. still waiting for the feature request mentioned in my comment above. I believe it is on the list, the media attachments export filtering is what will really make a very positive difference for large surveys! Cheers