Articles in this section

Resonate Append Hashing Script Instructions

Avatar
Permanently deleted user
  • Updated
Follow

Validate and prepare files with confidence

To streamline onboarding of appended data and ensure privacy compliance, Resonate provides a hashing script you can run locally before sharing your data. This script helps you properly format your file by converting all emails into lowercase and removing leading or trailing whitespace, apply secure hashing, and validate required fields—saving time, reducing errors, and accelerating the enrichment process.

Use this script to:

  • Hash identifiers (HEM, MAID, etc.) according to Resonate’s standards
  • Confirm your file is formatted correctly for processing
  • Ensure your data is privacy-safe and ready for upload

Follow the steps below for Mac or PCs to confidently prepare your file. 

Hashing Instructions for Mac

CAUTION

  • Do not include spaces in the file name.
  • ID Types: HEMMD5, HEMSHA2, HEMSHA1
  • Put files on your local machine (not on the cloud)

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

1.png

2. Once Terminal is open you’ll need to install Homebrew.  To do that, copy and paste the following into Terminal: /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)" Note: You may be prompted to enter a password.  You can enter your systems password followed by Enter and Homebrew will begin to install. 

2.png

  • This part can take up to a few minutes.  When the operation is complete you should see your original directory ending in %.

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

3.png

3. Once homebrew is installed, type: brew install python3

no3.png

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

4. Now that you have Python3 installed, please download the appended 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 vs. HashingScript

3b.png

 

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: cd c://directory) and hit enter NOTE: Include a space between cd and the directory

 

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 append_email_hasher.py append_input.csv HEMMD5

  • Remember to update your file name to match the name of the file you’re hashing: python3 email_hasher.py append_input.csv HEMMD5

6.png

7. Run the command by hitting enter on your keyboard. You should see the following:

7.png

You’ll see that your email list got hashed and put in a new file called  append_input_hashed_hemmd5.csv. Once you open that file you’ll see the list of hashed emails

7b.png

 

8. Email list before hashing

Customer ID Address Line 1 Address Line 2 City State ZIP Code ZIP11 MAID email HEMType IP Address
1001 123 Main St Apt 4B New York NY 10001 10001-1234 M1234567890 alice@example.com 192.168.1.10
1002 456 Oak Ave Los Angeles CA 90001 90001-5678 M0987654321 bob.smith@example.org 10.0.0.55
1003 789 Pine Rd Unit 12 Chicago IL 60601 60601-2468 M1122334455 charlie123@example.net 172.16.0.23
1004 321 Maple Dr Suite 200 Austin TX 73301 73301-1122 M5566778899 diana@example.co 203.0.113.5
1005 654 Cedar Blvd Seattle WA 98101 98101-3344 M6677889900 elaine@resonate.com 198.51.100.42

 

9. Email list after hashing

Customer ID Address Line 1 Address Line 2 City State ZIP Code ZIP11 MAID HEM HEMType IP Address
1001 123 Main St Apt 4B New York NY 10001 10001-1234 M1234567890 c160f8cc69a4f0bf2b0362752353d060 HEMMD5 192.168.1.10
1002 456 Oak Ave Los Angeles CA 90001 90001-5678 M0987654321 45ee3ca16bc44e2a76e01c7a47151862 HEMMD5 10.0.0.55
1003 789 Pine Rd Unit 12 Chicago IL 60601 60601-2468 M1122334455 b385afe718dd0b908d20db2243cada6d HEMMD5 172.16.0.23
1004 321 Maple Dr Suite 200 Austin TX 73301 73301-1122 M5566778899 6b23b4f2a9564116de835759ca8e0c5b HEMMD5 203.0.113.5
1005 654 Cedar Blvd Seattle WA 98101 98101-3344 M6677889900 46da4fcb982f523b7572557e604f2ce7 HEMMD5 198.51.100.42

10. Please review and step through our file formatting guidance, including using the provided template to format your files. 

11. Please save your file with the following name:

  • <clientname>_<Segment>_<yyyymmdd> 

    Example: Clientname_ResonateAppend_20250201.csv 

12. Upload your file to the appropriate location using the linked steps:

If you have additional questions, please reach out to your Customer Success Manager, or resonatesupport@resonate.com. 

 

Hashing Instructions for PCs

CAUTION

  • Do not include spaces in the file name
  • ID Types: HEMMD5, HEMSHA2, HEMSHA1
  • Put files on your local machine (not on the cloud)

1. Before you can begin hashing your emails, please download and install Python 3 here:  - Choose the Windows Installer (64-bit) under the Stable Releases section

  •  

    • 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 Append 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 vs. HashingScript

2pc.png

 

 

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

  • You can click the Window button in the bottom left corner and start typing “Command” to bring up the application

4. Once the Command Prompt is open, change the directory location to where the files were put type in: cd and the path to the folder location (Example: cd c://directory) and hit enter NOTE: Include a space between cd and the directory

pc4.png

 

5. Once the directory is where you need it type in ‘append_email_hasher.py’, the file name you want to hash, and the ID type you want to hash: HEMMD5, HEMSHA2, HEMSHA1. Example: append_email_hasher.py append_input.csv HEMMD5

5pc.png

6. You’ll see that your email list got hashed and put in a new file called append_input_hashed_hemmd5.csv.  Once you open that file you’ll see the list of hashed emails.

6pc.png

 

You’ll see that your email list got hashed and put in a new file called append_input_hashed_hemmd5.csv , once you open that file you’ll see the list of email hashed 

7. Emails before being hashed:

7pc.png

 

8. After being hashed:

8pc.png

 

9. Please review and step through our file formatting guidance, including using the provided template to format your files. 

10. Please save your file with the following name:

  • <clientname>_<Segment>_<yyyymmdd> 

    Example: Clientname_ResonateAppend_20250201.csv 

11. Upload your file to the appropriate location using the linked steps:

If you have additional questions, please reach out to your Customer Success Manager, or resonatesupport@resonate.com. 

Related articles

Comments

0 comments

Please sign in to leave a comment.