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