A few weeks ago, I noticed that a CSV project export was missing some tasks. After quite a lot of research and a few emails with Asana support, I was informed:
One thing to note is that CSV exports are truncated at 3000 lines as the export limit. This is why you are seeing tasks missing.
This is quite problematic, for a number of reasons. The biggest issue for us is that we use the project exports 1) to backup our editorial calendar, and therefore need them to be complete, and 2) to create an interactive database in Excel that pulls together data from a few different sources. Limiting the export to 3000 lines (without clearly indicating what tasks are being omitted) makes it very difficult to keep both of these things up to date.
I recognize that there may be technical challenges to exporting especially large projects, but I think there are a few different solutions that would be better than the current approach, including:
- Clearly communicate the necessary row limit for project exports, indicating which tasks were included and which tasks were excluded. (OK)
- Automatically break the export into multiple CSV files. (Better)
- Increase the limit for CSV exports from 3,000 rows to something like 50,000 rows. (Best)