How to Hash Emails for Data Onboarding

Please follow the instructions below using Resonate's email hashing python script.  Resonate’s hashing script automatically removes any leading or trailing spaces and changes all email addresses to lower case prior to hashing to provide the highest possible match rate.

Hashing Instructions for Windows

Hashing Instructions for Mac

If you have not yet formatted your file, please first refer to the instructions here for Option 2: File Formatting for Unhashed Emails.

Instructions For Windows:

1. Before you can begin hashing your emails, please download Python 3 here: Python Releases for Windows

• Note: Python3 is a background running application, so once installed you will not need to open an interface for it

2. Now that you have Python3 installed, please download the python script and put it in the same folder as the file you wish to hash

3. Once the script is saved to the same location as the file you wish to hash, open your Command Prompt

4. Once the Command Prompt is open, change the directory location to where the files were put type in: cdand the path to the folder location and hit enter

5. Once the directory is where you need it type in ‘email_hasher.py’, the file name you want to hash, and the ID type you want to hash (HEMMD5). Example: email_hasher.py EmailsTest.csv HEMMD5

6. Run the path and you should see the following:

7. You’ll see that your email list got hashed and a new file was created

8. Rename the file as follows: <client name>_<onboarding>_<Segment>_<date>

• Segment is optional
• Example: Resonate_Onboarding_Segment1_20230302.csv

9. Follow the instructions outlined here to upload your data to Box

Instructions For Mac:

1. Start by opening Terminal, to do this hit command + space then type Terminal

2. Once Terminal is open you’ll need to install homebrew, to do that, copy and paste into terminal the following: /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

• This part can take a while. When the operations complete you will know because you’ll see your original directory ending in %

• However, there may be more instructions after the initial completion of Homebrew that will need to complete. An example of what those instructions look like are below, ensure that if you see this you copy and paste the highlighted text and run that code - if you do not see these instructions, then you may proceed to the next step

• 

3. Once homebrew is installed type: brew install python3

• Once complete, you’ll see your original directory again with a %

4. Now that you have Python3 installed, please download the python script and put it in the same folder as the file you wish to hash:

• Note: Do not put spaces in your folder name. Example: Hashing Script (not accepted) vs. HashingScript (accepted)

5. Now in your Terminal, you’ll need to update your directory to the location to where the files are located type in: cd then the path of the folder location (Example: c://directory) and hit enter

6. Once the directory is where you need it type in ‘python3 email_hasher.py’, the file name you want to hash, and the ID type you want to hash (HEMMD5) Example: python3 email_hasher.py emails.csv HEMMD5