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

Provide CSV on RC Service App #10709

Open
HollyJoyPhillips opened this issue Feb 9, 2024 · 0 comments · May be fixed by #10722
Open

Provide CSV on RC Service App #10709

HollyJoyPhillips opened this issue Feb 9, 2024 · 0 comments · May be fixed by #10722
Labels
5 5 story points back-end Relates to back end issues feature New feature or request internal Relates to internal tickets rc-service-app Relates to the Reapit Connect Service app

Comments

@HollyJoyPhillips
Copy link
Contributor

HollyJoyPhillips commented Feb 9, 2024

Summary: We've introduced the ability to filter by first time login on the RC service app and part of the requirement is to download the results.

Based on the amount of data, it would be problematic to do this in the front end. We should look to create a reporting function on the organisations endpoint to support a seperate section in the RC Service app specific for reporting.

Details specific to this requirement:

Provide a ‘Download CSV’ option on the RC Service App for 'Users' only
Extract to include the following fields
Name,
Email Address,
Job Title,
Active,
Mfa Status,
Tracking Consent,
Org Name,
Primary Org ID,
Date Created,
First Login Date ,
User Roles

Specification

  • Project: Internal user service
  • New endpoint GET /users/download that uses the same query object as the GET /users endpoint with the exception of page size/page number parameters
  • Store the generated file in S3. New bucket to be created for this purpose with a lifecycle policy that deletes these files after 24 hours. Generate a random filename for the extract (guid is fine or similar). Use a redirect to send the user off to download the file
  • Use same repository methods as the main endpoint to fetch the database from the data (this means that the same set of frontend filters can be used to serve as a report generator)
  • Find a suitable package for generating an excel sheet. CSV is a bit old hat and we should consider moving away from it as people are likely going to want to do things with the data that a CSV won't support (potential option but check licensing)
  • Once this is built and available log front end ticket with appropriate details
@HollyJoyPhillips HollyJoyPhillips added feature New feature or request front-end Relates to front end issues rc-service-app Relates to the Reapit Connect Service app labels Feb 9, 2024
@bashleigh bashleigh linked a pull request Feb 12, 2024 that will close this issue
@HollyJoyPhillips HollyJoyPhillips added back-end Relates to back end issues and removed front-end Relates to front end issues labels Feb 20, 2024
@HollyJoyPhillips HollyJoyPhillips added the refinement To be included in a future refinement session label Feb 20, 2024
@plittlewood-rpt plittlewood-rpt added the 5 5 story points label Feb 29, 2024
@plittlewood-rpt plittlewood-rpt removed the refinement To be included in a future refinement session label Feb 29, 2024
@HollyJoyPhillips HollyJoyPhillips added the internal Relates to internal tickets label Jul 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
5 5 story points back-end Relates to back end issues feature New feature or request internal Relates to internal tickets rc-service-app Relates to the Reapit Connect Service app
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants