Download and Drop Handshake Approved Internships File for Data Warehouse Import

This procedure outlines how to download the "Approved Internships" file from Handshake and place it in the appropriate folder for import into the Data Warehouse.

Requirements

  • Access to the Handshake-to-DW importexport folder.

  • Permission to download Experience files from Handshake.

Steps

  1. Log in to Handshake.

  2. In the left-hand navigation, click on "Experiences".

  3. Select the "Approved" tab at the top of the page.

  4. Click the checkbox in the top left corner of the list, then choose "Select All".

  5. Click the "More" button, then select "Download Approval CSV".

  6. Wait a few minutes until you receive an email titled "Handshake download: Experience Download" from handshake@notifications.joinhandshake.com.

  7. Open the email and click "Bulk Download" to download the CSV file of approved internships.

  8. Navigate to the Handshake-to-DW folder.

  9. Open the "Internship Approvals" subfolder.

  10. Copy and paste the downloaded CSV file into this folder.
    – The file will be automatically processed and imported into the Data Warehouse.

If you need to reference a previously processed file, return to the Handshake-to-DW folder and open the "Archived" folder.

Print Article