Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Export session participants #128

Closed
rbento1096 opened this issue Mar 20, 2024 · 2 comments
Closed

Export session participants #128

rbento1096 opened this issue Mar 20, 2024 · 2 comments
Assignees

Comments

@rbento1096
Copy link
Collaborator

As an admin I'd like to be able to download the details about the participants for each session so I can share it with the speakers.

This data is saved on the registrations table and the most useful one is the name of the participant his esn country (if existent)

For this feature I'm thinking of 2 ways this can be processed:

  • as a single call to the back-end that will scan all session registrations (at this time they are 5K+) and generate an excel with all data
  • Add a button to the front-end that works as the current excel export of the users page (we can query the registrations database by sessionIdto get all users registered in a session). This would be simpler but would require more manual work from the organizers. Excel should have a name = session.code or session.name if code is not defined.

Ideally we could have both.

@uatisdeproblem
Copy link
Owner

I implemented both the proposed scenarios.

The feature is online for testing in the development environment. Note: since there aren't many registrations in the dev environment, I tested by registering my user to "How I Enforced my Inclusion in an Unfriendly Environment" (random session). It will also need to be tested with higher volumes of data in the production environment.

A few notes:

  • Since the session data is repeated for each registration row in the spreadsheet, I added just the main data; feel free to add any more columns you like.
    Screenshot 2024-03-23 at 14 23 39
  • For sessions that don't have any registration, I added a row anyway (with empty data for the participants' columns); if you prefer not to include the sessions without registrations in the spreadsheet, we can change it.
  • The export is available only to users with "canManageContents" permissions.

The feature is available in three areas of the app:

  1. The Manage menu (download ALL sessions registrations):
    Screenshot 2024-03-23 at 14 13 58

  2. The sessions list, with a "current session" selected:
    Screenshot 2024-03-23 at 14 13 07

  3. The detail of a session:
    Screenshot 2024-03-23 at 14 13 35

I will now open the PR.

@rbento1096
Copy link
Collaborator Author

It is working perfectly with production data as well!
We'll keep the rows for sessions without registration, can be useful for the programme team as well.

Thanks a lot!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants