Does it have a repeat group question?
Yes it does
Did you make any changes to the repeat group and then redeploy?
aGbBAuoGnzFPS678RqntjR.xlsx (22.8 KB)
Please find attached the XLS Form
Did you edit the repeat group and then redeploy your survey project?
No. I haven’t edited the repeat group
Well have you tried downloading your data as legacy format as outlined in the image shared below:
Yes I have tried but it also showed the same error
Seems like you are having issues as you have a lot of submissions.
True there are quiet a number of submissions. How can i access the data for now? Is it possible for your to download it for me from the back end?
OK maybe you could download your data as outlined in our previous post:
This isn’t yet working
@icydtransfer, could you share the following though a private message:
- Project name
Maybe we could have a closer look at it?
Project name: home visit tool
Server: Humanitarian server
Hi @icydtransfer, I apologize for this inconvenience — it’s due to the export timing out on the server with the large number of submissions. I’m looking at it now to see what I can do
Thanks @Josh. Looking forward to the solution
Hi @icydtransfer, the legacy XLS export was successful so please use that if it’s urgent. We are going to be doing maintenance on the server soon so I’ve been advised not to start a large export until after that has been completed
Hi @icydtransfer I was able successfully export your data. Unfortunately due to the size of your project it will continue to fail if you try exporting from the UI or through the API — so I will have to due it manually from the server.
We will be introducing a new date range filtering feature for exports soon, so hopefully this won’t be an issue for much longer as you can just export the data submitted since your previous export.
Thank you so much the KoboCollect team. This has also been a concern for me too.
Your timely support is the only thing that gives me confidence around any misappropriation, well done.
While the date filtering option for download will be of a great help - I can’t wait to see it on the download option - for those who wants to download to a local file, how would we be able to go around it if we are using the API and it is connected to a BI tool for visualization ?
I currently have a survey with over 30000 submissions and more than 120 questions that is connected to Power BI for real time visualization. However, I do sometimes get error messages that the data extraction time out, what can I do to solve this?
Can the time for the data extraction be increased ?
Hi @tomisin, we appreciate your feedback
You can track the export filtering progress here and hopefully it can slip into one of the next releases. Unfortunately it will not initially address the integration issue yet, although this is something that will be incorporated in the future.
Unfortunately server load can affect projects of your size and result in occasional time-outs. We are considering how to better handle this at the moment, so hopefully it will be resolved in the coming months.