Importing Avant Stamp Scores

Importing Avant Stamp Scores

Where are the scores stored? Avant Stamp scores are stored in the same tables as all other test scores: STDNT_TEST and STDNT_TEST_COMP.

Where can I see the sores? Avant Stamp scores may be viewed on the same page as all other test scores: Main Menu > Records and Enrollment > Transfer Credit Evaluation > Test Results.

Avant Stamp scores will be stored under one or more of the following Test IDs:

TEST ID

Test Description

STAMP_CHIN    

Avant STAMP - Chinese (Simple)

STAMP_CHIT    

Avant STAMP - Chinese Traditnl

STAMP_FREN    

Avant STAMP - French

STAMP_GERM    

Avant STAMP - German

STAMP_HEBRW    

Avant STAMP - Hebrew

STAMP_HINDI    

Avant STAMP - Hindi

STAMP_ITALN    

Avant STAMP - Italian

STAMP_JAPAN    

Avant STAMP - Japanese

STAMP_KOREA    

Avant STAMP - Korean

STAMP_RUSSN

Avant STAMP - Russian

STAMP_SPAN

Avant STAMP - Spanish

 

Issue:

How do I import Avant Stamp scores into myWSU?

Solution:

Avant Stamp scores must be retrieved manually from Avant's website. Work is underway at Avant to develop a more automated mechanism for retrieving test scores, but that tool is not yet available. Nick Gossett (nick.gossett@avantassessment.com) may be contacted with questions about retrieving test scores.

Use a web browser to navigate to: https://app.avantassessment.com

Enter the Test Code: Washington-State-University-Results

Enter the Password:

The Summary dashboard will appear for Washington State University. By default, information is displayed for the last six months.

Click the download icon and select the "Test Taker Data" option.

Select to Save File to a directory on your local machine.

Use FileZilla (or similar tool) to upload the file to Oracle's SFTP server. Previous files have been uploaded here: /interface/i_wsun/WSUNCPRD/transfers/AA/

Run File Parser (Main Menu > Set Up SACR > System Administration > Utilities > File Parser > Run File Parser) with the following parameters:

  • File Mapping: AVANT_STAMP

  • File Path (depending on where the file was uploaded): /interface/i_wsun/WSUNCPRD/transfers/AA/TestInstanceReport.csv

Related articles