Hi all, based on below link, I am trying to get the data from Kobo to excel using query so I can refresh when I need instead of re-donwloading the data. It worked for projects with less #of submissions but it gives “Timedout error” in projects with more submissions. Any help please? I use the global server. Thanks
Hi @rahmat, How many submissions do you have any in the form, would it be more than 30.000?
1 Like
Yes, way more than 30,000. will be reaching 200K today and going forward. The number of columns will be around 120
So the problem is if your data is more than 30000, kobo connection time out without downloading the data to excel. So there is a work around by the limiting the the total number of submissions for each connection. You can check the topics below
1 Like
