The ETS Data Manager makes it easy for approved score users to view GRE and TOEFL score information currently being sent to them by ETS. The Touchless Solution makes it even easier by allowing institutions to automatically import scores directly into Slate via the ETS Data Manager API. This document outlines the necessary steps to configure this process within Slate.

Three steps to configuring automated import:

1. Request access from ETS

2. Add one or both source formats

3. Configure the import for GRE, TOEFL, or both

Step One: Receiving and encoding Client ID and Client Secret

GRE and TOEFL scores can be imported into Slate using an API call configured as a Source Format.

To automatically fetch the data via API, you will need the Client ID and Client Secret provided by ETS. These values need to be encoded before they will function.

To receive and encode the Client ID and Client Secret:

1. Visit the GRE and/or TOEFL website to request access to ETS Data Manager Automated Server-to-Server Data Feeds.

2. Follow instructions on the GRE and/or TOEFL website to obtain a Client ID and a Client Secret.

3. Using a website such as https://www.base64encode.org/, perform a base 64 encoding on the Client ID and Client Secret values provided by ETS Institutional Portal. Create the base-64 encoded value by pasting the Client ID and the Client Secret values separated by a colon.

4. Keep the encoded values handy for the next steps in the integration process.

Step Two: Adding the source format

To add one or both source formats:

1. From the main navigation, select Database.

2. Under Import and Data Processing, select Source Format Library.

3. Use Search Library to find the following source formats:

• GRE Score Data File

  • Format: Fixed Width 2017

  • TOEFL Score Data File

    • Format: Fixed Width > 10/2017

4. Click Add. A pop-up appears that describes the source format.

5. Click Add. A browser dialog appears asking you to confirm.

6. Click OK. You are redirected to the overview page for the source format. 

7. Repeat as needed for the other source format.

Step Three: Configuring the import

GRE Scores

The Score Data File automatically fetches score results shared with your institution.

1. From the main navigation, select Database.

2. Under Import and Data Processing, select Source Formats.

3. Select GRE Score Data File (Format: Fixed Width 2017).

4. Click Edit. A pop-up appears.

5. Select the Import Automation tab.

6. Copy the following text:

https://datamanager-api.ets.org/api/v1/scores/testtakers?startdate={{dtstart|date:'s'}}&enddate={{dtend|date:'s'}}&type=GRE&reportby=scorelinkbyreportdate

7. Paste the text in the Import Remote Server field.

8. In the HTTP Headers field, add the following tag:

<t name="authcode"></t>

9. Between the opening and closing tags, paste the base-64 encoded value you created earlier as part of step one.

10. By default, all currently valid EDMGRE scores released to your institution will be sent during the first fetch. If you prefer this option, click Save. If you'd like to override this default, continue to the next steps.

Optional: Override the Last Remote Server Fetch

1. Overriding this value will limit the fetch to just those since the last import. Click the Override link to the right of the Last Remote Server Fetch (UTC) field. A pop-up appears.

2. Enter the case-sensitive confirmation message and click OK.  

3. In the Last Remote Server Fetch (UTC) field, enter the approximate timestamp that the source format should send to EDMGRE to restrict the data that is retrieved during the first data fetch. Note: The timestamp should be in the UTC timezone in the format: yyyy-MM-ddTHH:mm:ss (for example, 2023-04-05T03:22:30)

4. Click Save.

TOEFL Scores

The Score Data File automatically fetches score results shared with your institution.

1. From the main navigation, select Database.

2. Under Import and Data Processing, select Source Formats.

3. Select TOEFL Score Data File (Format: Fixed Width > 10/2017).

4. Click Edit. A pop-up appears.

5. Select the Import Automation tab.

6. Copy the following text:

   https://datamanager-api.ets.org/api/v1/scores/testtakers?startdate={{dtstart|date:'s'}}&enddate={{dtend|date:'s'}}&type=TOEFL&reportby=scorelinkbyreportdate

7. Paste the text in the Import Remote Server field.

8. In the HTTP Headers field, add the following tag:

   <t name="authcode"></t>

9. Between the opening and closing tags, paste the base-64 encoded value you created earlier as part of step one.

10. By default, all currently valid EDMGRE scores released to your institution will be sent during the first fetch. If you prefer this option, click Save. If you'd like to override this default, continue to the next steps.

Optional: Override the Last Remote Server Fetch

1. Overriding this value will limit the fetch to just those since the last import. Click the Override link to the right of the Last Remote Server Fetch (UTC) field. A pop-up appears.

2. Enter the case-sensitive confirmation message and click OK.  

3. In the Last Remote Server Fetch (UTC) field, enter the approximate timestamp that the source format should send to EDMTOEFL to restrict the data that is retrieved during the first data fetch. Note: The timestamp should be in the UTC timezone in the format: yyyy-MM-ddTHH:mm:ss (for example, 2023-04-05T03:22:30)

4. Click Save.

Troubleshooting

If the connection from the GRE or TOEFL source formats break, the password probably expired and ETS tech support must be contacted to provided a temporary password. The user then will change the temporary password to the new permanent one needed to base 64 encode and update the configuration in the ETS Source format with newly encoded username and password.

Instruction steps:

• Contact ETS Tech Support

• ETS Tech Support will provide a new temporary password

• Go to the sign-in page, https://portal.ets.org, to reset the temporary password using the username, XXXXXXXXXXX (note the exact spelling) t – ignore if the password reset screen continues to spin (give it few minutes then close the browser).

• Go to Base64 Encode and Decode - Online to encode our newly updated reset password. make sure the formula is Client ID: Client Secret ( XXXXXXXXXXX :password) to encode and don’t forget to include the : (colon)between the userid and password

• Once the credentials are reset, follow the instructions in Slate setup integration guide, starting with the userid & password section.

For help, contact [email protected], if you wish to speak with a customer service representative, call 855-242-6478, or 609-310-3252, Monday–Friday, from 8:30 AM – 5:00 PM ET.