Importing Data to Create a Rank Order List

In addition to entering a rank order list rank by rank or 10 ranks at a time, you can import Rank Order data into the R3 system. The R3 system provides the option of entering a rank order list by reading the information directly from data produced by another software program. This is accomplished by copying and pasting data from the existing system into R3. Whether entered directly or copied from an existing system, the data MUST be in Comma Seperated Variable (CSV) format. The applicant's rank number and AAMC ID are the first two elements, with one rank per line. It is suggested that you also list the applicant's name for your convenience, but the program does not require you to do so. Lists created from ERAS are automatically in the required format.

Import Data Record Format

The R3 system examines the text file and locates the FIRST TWO SETS OF NUMERIC CHARACTERS on each line. The R3 system ONLY uses the AAMC ID to identify a ranked applicant. Other information (e.g., name, medical school name, etc.) may be included, but will be ignored. Your text file must comply with the following format:

1. Each choice (combination of rank number and applicant code) must be on a separate line or record in the file. All ranks must be in sequential order starting with 1. If ranks are not in sequential order, they will be ordered in the sequence they occur in the file.
2. The FIRST set of NUMERIC characters on each line must be the rank number for that choice. Rank numbers can be from one to three digits.
3. There must be a comma (,) between the rank number and the AAMC ID of the applicant.
4. The SECOND set of NUMERIC characters on each line must be the applicant's eight-digit AAMC ID for that rank.
5. If there are any other characters on a line they must follow and be separated from the AAMC ID by at least one comma.

Examples of correct line formats for ranking Wendy Lee (AAMC ID 11191766) as rank number 1 and ranking Maria Senabre (AAMC ID 11191800) as rank number 2 are as follows:

Correct

1, 11191766, "Wendy Lee"
2, 11191800, "Maria Senabre"
or
1, 11191766
2, 11191800

Examples of incorrect line formats for ranking the same applicants are shown below, along with an explanation of the format problem:

Incorrect

To Import Data to Add Applicants to a Rank Orer List

1. On the Maintain Rank Order List screen, click the Import ROL link in the Options column.
2. Enter data directly into the File Contents input area, OR Copy and Paste the rank order list data into the File Contents input area. These functions can be found in the application's or browsers EDIT menu.
3. Click the SUBMIT button to view the list to be imported. If any AAMC IDs entered are invalid, a list of those IDs that are not in the NRMP database will be displayed. You can then cancel the import to make corrections to the file by clicking the CANCEL button. You could use the Search Applicants option in R3 to find the correct AAMC IDs for these applicants and correct your file.
4. Click the Import button to add the applicants to the rank order list.

Updated 09/28/2006