EPIC: BEA Mass Verify

[Kaspiaan]

What Koala extension does this refer to (if applicable)

Verify

Is your feature request related to a problem? Please describe.

British Esports Association (BEA) have asked us to enable a mass-verify feature that can allow for a CSV to be given and roles to be automatically assigned to each individual in that CSV. In addition, BEA also wants us to remove roles from people/de-verify people that are not in a more up-to-date CSV given.

Describe the solution you'd like

A new command that takes a CSV input in a set format. Parses the CSV, checks the given server for differences in roles. Finally makes changes found.

• If no update is needed to a person, no functions are called.
• If a person no longer exists in a CSV/has roles changed, these changes will be made removing roles where needed and adding new roles if needed.
• If a person is now to the CSV, they will be verified and have appropriate roles added.

1. Define a CSV specification for use with batch set
2. Allow verifications for specific email instead of suffix
3. Create k!verify batchSet for setting from a file
4. Modify k!verify list to send a CSV or other file if there are over 20 verifications

Describe alternatives you've considered

Remove all roles in a server when given new CSV, then give back roles where needed. Very inefficient and destructive.

Additional context

• This may work in a superficial manor similar to Git diff for finding differences.
• This is to be reviewed by BEA for any changes needed.

Subtasks

• Mass Verify: Design CSV Spec #317
• Mass Verify: Verify specific Email #318
• Mass Verify: Import CSV #319
• Mass Verify: verify list modifications #320

[Kaspiaan]

Part 1: Define a CSV specification for use with batch set
Part 2: Allow verifications for specific email instead of suffix
Part 3: Create k!verify batchSet for setting from a file
Part 4: Modify k!verify list to send a CSV or other file if there are over 20 verifications

1. Define a basic header layout for the CSV, e.g. DiscordUserID, RoleID1, RoleID2, RoleID3, RoleID4. etc

2. Alter the verify command to allow an email regex/checked from list of allowed emails instead of list fo suffixes.
   

3. Create command 'batchSet', takes in a CSV file arguement.
    Extract the data from the CSV, look up Pandas.
    Loop over each individual in the CSV file, remove all roles then add back roles as dictated by the CSV. Alternatively, check the roles already given to said user, remove unnecessary roles and add needed ones.
   

4. Get all members verified to the server ID.
    If the list of usernames is over 20, then compile those usernames into a CSV and post it as a reply to the command.
    If the list of usernames is under or is 20, then just post the list of usernames.