You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Finding a list of 'Alumni' by searching on the best_email field.

Step-by-step guide

Locate the app

  1. Open aadReporting (aka SPI) https://connect.aad.cornell.edu
  2. Click on the "Tools" tab

  3. Select "Email Lookup"



  4. To use this app and get an Excel spreadsheet of the results follow these instructions
    1. Click the "Browse" button and navigate to your .txt file


    2. Double click on the correct file or single click and use the "open" button.


    3. Click the "Submit" button to push the data to and Excel spreadsheet.


    4. Click "Open" to launch Excel and open the spreadsheed


    5. If this message comes up, select "Yes"


    6. This is the final product next to my original .txt document.



  5. How to read the Excel document.
    1. Columns:
      1. ID – Number of the row uploaded
               In my example, there are 15 rows uploaded, but 18 rows returned.
              This is caused by multiples, one email address shared by 2 or more people (usually couples).
      2. STATUS –  indicates if (blank), INVALID, NOT FOUND, MULTIPLES, & DECEASED
        1. (blank)  – If status is blank a single record for that email address has been found. (Excel rows 15, 19, 24, 25)
        2.  INVALID – this was not a valid email address (Excel rows 9, 14, 16, 17, 18) notice that these will show "BLANK LINE" or "NOT EMAIL" in the email column, not a return of the data uploaded
        3. NOT FOUND – valid email but not found in our DB (Excel rows 10, 13, 26)
        4. MULTIPLES – More than 1 record has been found for this email address (Excel rows 11 & 12: ID 3, 20 & 21: ID 11, 22 & 23: ID 12)
        5. DECEASED – This record is showing as belonging to a deceased alum. (Excel row 12, ID 3) This happens to be a "MULTIPLE", you can tell because they have the same ID number, 3.
      3. EMAIL – returns email originally uploaded, except in the cases of INVALID email,these will show "BLANK LINE" or "NOT EMAIL" in the email column
      4. EMPLID – aka common id
      5. NETID
      6. NAME

 

  • No labels