Collecting issue of more than 1.5 million data row in a survey

[dataanalyticbd]

Hello.
Can we collect more than 1.5 (one and half) million data on the kobo humanitarian server? If possible, then how can I download the data from the server, because excel contains a maximum of just over 1 million rows. What should I do now? Please suggest.

Thanks
ARIF

[Kal_Lam]

Welcome back to the community, @dataanalyticbd! Maybe you could use this approach to download the data that has been discussed previously:

How to download Data between two dates from date to date

Hi @Ahmad1, this is possible, but unfortunately there is currently no UI to easily create the filtered export. To do this, you can navigate to the following URL with your ASSET_UID and KF_URL depending on the server you are using: https://<KF_URL>/api/v2/assets/<ASSET_UID>/exports/ for example: HHI https://kf.kobotoolbox.org/api/v2/assets/arhhVdJxyFxguzdyhuDZWb/exports/ OCHA https://kobo.humanitarianresponse.info/api/v2/assets/arhhVdJxyFxguzdyhuDZWb/exports/ Then paste the following JSON …

[Kal_Lam]

@dataanalyticbd 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.