INGInious/INGInious

[frontend/submissions] Automatic join of users information in CSV exports

Open

#891 opened on Nov 7, 2022

View on GitHub
 (0 comments) (0 reactions) (0 assignees)Python (147 forks)auto 404
Feature requestGood First Issue

Repository metrics

Stars
 (237 stars)
PR merge metrics
 (PR metrics pending)

Description

Is your feature request related to a problem? Please describe. Currently if you download the results of the submissions page query, you only get the username as user identification. A manual join has to be performed with the "Users" CSV to get more insight (realname, email, ...).

Describe the solution you'd like It would be useful to perform the join automatically and serve a CSV file with the user info.

Contributor guide

Research direction
Look at the current CSV export code for submissions, find where user data is fetched, and add a join with the users table to include realname and email.
Tech stack
python
Domain
backend
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
PythonSQLCSV export concepts
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
72