Check Mailchimp alumnae list against platform database and generate account IDs

[dboyer]

Related to #4385.

Sasha will move the alumnae mailing list from Mailchimp to Salesforce. To match the data with the platform, we need to generate a list of accountIDs for the names on the alumnae list.

Sasha will provide a CSV of the list which we will match against the platform database. We'll then provide an account ID for the names that match an account on the platform.

[shaun-technovation]

I imported production data locally and wrote a rake task for this. The rake task reads in a CSV, for each email address, it tries to find an account with a matching email address, if an account is found, it adds the account id to the CSV; it outputs a new CSV that has a new column for all the account ids that it could find.

I tested the rake task locally with a Mailchimp export and it is working as expected, but the official Mailchimp export isn't finalized yet. If things get finalized on Monday, I can handle running this rake task. But if it's later in the week, I won't be here, I added a PR w/ some steps, #4861, if you want to run it, Vivian; or if you want to do it another way too, I'm not too savvy w/ spreadsheets, which is why I wrote the rake task. 😅

[shaun-technovation]

I have an update from Sasha, the plan is to do this the week of the 22nd. 👍

[shaun-technovation]

I ran the rake task for the 2024 Jr/Sr cohort CSV list, adding platform id (aka account id), and updating first and last name from what is being used on the platform (this was a new requirement).

[shaun-technovation]

The plan is to run this rake task (to add program participant ids) again in few weeks, so we're not quite done with this one.