How To Pull EEO Test Taker List

Locate the course SKU (example: REL-ACU-0-NITIP) this can be found of the free ce/sponsored course page: https://www.nurse.com/ce/nursing-informatics-technology-to-improve-patient-care and click on the course details tab.

Open

Locate the DIGIOH box ID ( https://account.digioh.com/ )

Open

Login into Power BI to access the list of people who filled out the survey ( Power BI )

Enter the SKU and select the box ID:

Next click on the any cell on the data field. Options will appear on the top right. Select the highlighted box with 3 dots and select EXPORT DATA.

Select the green export button on the pop up box. This will download the data to your computer.

Open the downloaded file.

• Delete columns J and K.

• Delete all columns that come after M.

• Highlight all remaining columns and delete all duplicates in column G (profile email)

• Highlight all remaining data in order A-Z in column G so all emails are in alphabetical order.

• Open a new spreadsheet and copy and paste column G (profile email) onto the new spreadsheet.

• Save this file as a CSV file and name the new file NAME_BASE_DATE

Open and login to Everest: Validity ( Login : Validity )

• On the left rail select LIST VALIDATION

• Next page, select the blue Validate New List button at the top right.

• Enter your file description, choose your file and save list.

The page will refresh and begin processing your list. This can take several minutes.

While this list is processing, go back to your saved CSV file. Lets rename the headers of each row to match our database in Iterable.

We will need to add 3 additional columns:

1. exprerian.validation_result

   1. place in column L

2. exprerian.validation_verbost_result

3. exprerian.validation_date

   1. in this column, add the following to the first cell then copy it down to every cell in this row: 2024-08-26 00:00:00 +00:00

      1. replace the leading date with todays date.

Your verified list should be ready in Everest: Validity. A list that is ready will appear as a circle that is mostly shaded green.

• Click on the blue view details button,

• Next page, click on the DOWNLOAD ALL button on the top right of the page.

• Open the downloaded file and sort A-Z on the email.

• Copy and paste both columns and place them in columns K and L

  • Email in column K

  • Status in column L

• Spot check and compare column K with the email column G to ensure the email addresses match within each row.

• Add a filter to your exprerian.validation_result column.

Using the filter you will need to replace the result in the exprerian.validation_result column and map to with the below and add the result for the exprerian.validation_verbost_result column with the below:

Save your updated file.

Go to your IT Help Center tile in your Relias apps. (https://relias.atlassian.net/servicedesk/customer/portals)

1. Select the Service Request button

2. Select the Email Support button

3. Subject: Please add the attached list to the Nurse.com project in iterable

4. Select an email support request type: New Distribution List

5. Provide a name for the distribution list: DATE_CLIENT NAME_Test Taker

6. Provide name of owner of list: Your Name

7. Provide the members you would like to add: LIST ATTACHED TO COMMENT FIELD. PLEASE UPLOAD LIST BY: GIVE DATE 2 DAYS PRIOR TO SEND DATE

8. Provide business reason: 3^rd party email

9. Click the send button

10.   Once next page, in the comment field, select the file icon and attach your saved file.