Articles in this section

Hashing Script Instructions for rAI-powered Predictive Modeling

Avatar
Permanently deleted user
  • Updated
Follow

Hashing Script Instructions

Hashing Script Download

This script reads a CSV file, hashes the email addresses using HMAC MD5, SHA1, SHA2, and then outputs the hashes to another file.
The script will output some execution information (line count, time taken and output file
name) by default unless the --silent flag is specified.

Hashing Instructions for Mac

CAUTION

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

1. Start by opening Terminal.  To do this, hit command + space then type Terminal.image-20221018-204613 (2).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. 

image-20221018-204850 (2).png

  • This part can take a while (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.image-20221018-205307 (2).png

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

image-20221018-210208 (2).png

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

image-20231129-173135.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

image (15).png

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

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

image-20240110-151331.png

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

image-20221017-173822 (1).png

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

image-20221018-202356 (1).png

8. Please save with the following name:

  • Name file(s) as follows: <client name>_<model_type>_<date>

    • Example: Resonate_Churned_20220419.csv

9. Upload your file to the appropriate location:

  • Instructions outlined here to setup/upload your data via AWS

 

Hashing Instructions for PCs

CAUTION

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

1. Before you can begin hashing your emails, please download 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 python script and put it in the same folder as the file you wish to hash

image-20220922-211742 (1).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

image-20220804-231523 (4).png

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, HEMSHA1, or HEMSHA1. Example: email_hasher.py EmailsTest.csv HEMMD5

image-20220922-212016 (2).png

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

image-20220923-210026 (2).png

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

7. Please save with the following name:

  • Name file(s) as follows: <client name>_<model_type>_<date>

    • Example: Resonate_Churned_20220419.csv

10. Upload your file to the appropriate location:

  • Instructions outlined here to setup/upload your data via AWS

 

Related articles

Comments

0 comments

Please sign in to leave a comment.