My project data doesn't easily lend itself to filters that will bring the row count under 100,000 for case export.
What are my options to get around this issue?
Are there ways download case data without going through the "export case" interface?
What are the options for getting around the 100,000 maximum row limit for case export
commcare
Related Solutions
For this, you can leave the Case Management tab as "does not use cases." This controls the cases of the case type you've selected in your module.
The User Case will automatically be loaded into your form when you choose a form that has User Case setup.
The date filter in the case export is based on modified date, not opened on.
If you also look closely at the subtext it will remind you that it is filtering on when cases were modified.
Note: Confusingly enough, at this time the list of cases in your export however will be sorted by the opened on date.
Related Topic
- The case and data behavior when I deactivate a mobile user in CommCare
- What do I need to “fix” for a case property highlighted yellow with a exclamation point warning
- If a worker is using a CommCare app what is the expected behavior for reaching the log out time limit
- CommCare – Benefits of Case Sharing via Locations vs. Groups
- How to get the reference ID of an extension case during a case export
- Way to customize the width of the header for the icon as a case property column
Best Answer
For now the best way to get around this is to use filters.
Date Range - You can use date ranges to select smaller chunks of data. These dates are based on the last time the case was modified (see Does the date filter for a CommCare case export filter forms by last modified date or opened date?)
Use reporting groups - You can further break down your case data by only downloading cases for a set of users, groups, or organizations. (For example, if your cases are evenly distributed amongst your users, you can put them in two separate groups which will halve the number of rows downloaded).
If all of that still doesn't work for you, and you have technical capacity, you can look into using the commcare-export tool