Skip to content

feat: Replace JSON upload with CSV in Team Leaderboard

📌 Description

Currently, the "Add All Teams" feature in the Team Leaderboard section allows uploading team data using a JSON file.

For better usability and easier data handling, this should be updated to support CSV file uploads instead of JSON.

❗ Current Behavior

  • Button label: "Add All Teams Using JSON"
  • Accepts .json file upload
  • Parses JSON structure to create teams

✅ Expected Behavior

  • Button label should be changed to: "Add All Teams Using CSV"
  • File uploader should accept .csv files only
  • CSV file should be parsed and converted into team structure

📄 Proposed CSV Format

team_name,project_name,member_name,username
Team Alpha,Project A,John,john123
Team Alpha,Project A,Ravi,ravi123
Team Beta,Project B,Sita,sita123

🔧 Suggested Changes

  1. Replace JSON file uploader with CSV uploader
  2. Use pandas.read_csv() to parse uploaded file
  3. Group rows by team_name and project_name
  4. Convert rows into existing team structure format
  5. Update UI labels from JSON → CSV
  6. Show success/error messages appropriately

🎯 Benefits

  • Easier for users to prepare data (Excel/CSV)
  • More readable and maintainable input format
  • Better usability for non-technical users

📎 Additional Notes

Ensure backward compatibility is not required, or remove JSON-related logic completely if deprecated.

🙋 Assigned Task

Implement CSV upload functionality in place of JSON for Team Leaderboard.