Add membership CSV export to root group

Problem to solve

In %13.7 we'll be adding an export button to the admin area to enable self-managed customers to export a list of all users and their respective group, subgroup, and project memberships. This fulfills an important audit reporting need for compliance-minded customers, but this functionality does not yet exist at the group level to support SaaS customers.

Intended users

• Cameron (Compliance Manager)
• Sidney (Systems Administrator)

User experience goal

A group owner can click an export button in Group > Members to generate a csv file showing the same data in the self-managed proposal

Proposal

Add an export button in Group > Members to generate a csv file showing the same data in the self-managed proposal

Implementation Plan

• Add "Export to CSV" button to root group members list. (frontend but, backend can lead with assistance if neccessary)
• Clicking that button triggers a background job to generate the CSV and email it to the user who triggered the download. (Group owner)
  • Inline downloads are potentially too slow when SQL queries are potentially complex.
• The downloaded CSV list should match the visible content and columns of the members list.
• If this proves too difficult due to database constraints the CSV should contain a list of all members of the group and subgroups.