Backend - Validation

[Blaze34536]

Extract Data: Open the provided .xlsx file and read the column containing user emails. Store these in a list/array.

Reset Validation Table: Delete all existing records currently in the Validation Table to ensure no outdated entries remain.

Insert the new list of emails from the spreadsheet into the Validation Table.

• Update Existing Users (Promote): Check all registered accounts in the Users Table. If a user's email exists in the new Validation Table, update their role to Member.
• Update Existing Users (Demote): If a registered user's email is NOT found in the new Validation Table, change their role to Unverified.

Whitelist New Users: By adding the emails to the Validation Table in step 2, any new person who signs up with those emails in the future will automatically be recognized as a valid candidate for the Member role.