Hi,
I am using DHIS2 version 2.40.3.
When I create a Line List report with more than 5000 records, the results are split into pages. To download all patient names, I have to go through each page before downloading.
Is this normal, or should the Download button export all records directly?
Thanks
Hi @rehabm
When you download, what option are you selecting? I tried downloading as CSV and I’m getting the full export (more than 27000).
Would you please try to reproduce the issue in any of the play.dhis2.org instances or share a recording of the issue?
Thank you!
Thank you for your reply.
I’m downloading the report as an Excel file
The data is not complete unless I go through each page. Without clicking Next, I get an error (see attached video).
Is there any limit in DHIS2 for downloading records that I should be aware of when exporting to Excel?
Best regards,
Hi
It’s possible that there’s a metadata/data issue (possibly an indicator). Could you please try removing all the columns and check one by one which causes the issue? After you figure that out, please share more details about its configuration.
For example, if you try only selecting the first three columns (OU, Incident Date, and Name) it will most probably download the entire list. Please check this.
Update: @rehabm , were you able to figure this out? – Thanks!
So at least according to the screenshot, the reverse proxy is timing out the request. You may need to ask your administrator to increase the timeout there. We usually recommend an absolute maximum of 10 minutes. If this still is not enough time to complete the request, then it could be another performance issue.
Best regards,
Jason