Downloading Line List with more than 5000 records (v2.40.3)

Support - Assistance technique
1

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

2

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!

1 Like
3

Hi @AL-Gassim Sharaf Addin,

Thank you for your reply.

I’m downloading the report as an Excel file

2025-09-03_17-28-44

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,

4

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.

1 Like