Export to CSV is timing out for large dataset

[RDmitchell]

Expected Behavior

Export data from the Inventory List view using the Action / Export option, selecting CSV

Actual Behavior

From the UI perspective, nothing happens -- no error message saying the program timed out, but no file is downloaded

Steps to Reproduce

See this doc https://docs.google.com/document/d/1Pq173YSOSi__WpwSP4_-qDsuk3X7sB-TEuEZYY6YTjw/edit?usp=sharing

Instance Information

Instance: LBNL staging SHA: d810c466 (2.5.0 release)

[RDmitchell]

Instance: seedv2 SHA: 9a2a5813 (2.5.2 release)

Property Records

• 2017: 15,438 records, 19 fields
• Exported without issue, all records

Tax Lot Records

• 2017: 24,238 records, 200+ fields
• 504 Gateway timeout error

---

Instance: seeddemostaging SHA: e120119f (2.6.0 release)

Property Records

• 2017: 15,438 records, 19 fields
• Exported without issue, all records

Tax Lot Records

• 2017: 24,238 records, 200+ fields

• 504 Gateway timeout error

• reduced # fields to 100+, then 48, then 16, then 1 (!)

• 504 error

So it seems that 24,000+ records is too many

---

Instance: dev1.seed-platform.org SHA:

Property Records

• 2017: 15,438 records, 19 fields
• exported fairly quickly, no errors.

Tax Lot Records

• 2017: 24,238 records, 200+ fields
• Error 524 -- Cloudflare timeout

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

[RDmitchell]

I will test on the latest dev version

[RDmitchell]

Still a problem. Using the new Property List, Property tab, selected all records (15000+) and as soon as I typed a name into the CSV dialog box program responded with 520 error

See this doc https://docs.google.com/document/d/1Pq173YSOSi__WpwSP4_-qDsuk3X7sB-TEuEZYY6YTjw/edit?usp=sharing

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

[isalanglois]

@RDmitchell Is this still an issue?

[RDmitchell]

@isalanglois -- I just assigned myself to test this.

[RDmitchell]

Instance: LBNL Staging SHA: de3b9d486 (2.18.1) Org: NYC

Using the New Property List option (not Legacy), View property tab, checked all the records, and set “select all” on the right, then used the Action menu to do the export

It got to 100%, then reported a 504 error -- so this is still an issue

[RDmitchell]

@isalanglois -- this is still an issue, so I moved it to the Q4 project