Magic Support Articles

NRDS to Cloud AMS Verification and Comparison Report

The NRDS Verification Utility is used to compare your membership data to the data at NRDS. After running the report, be sure to update any members or offices on NRDS that show as inactive in your database but active at NRDS. This will help you avoid getting charged for inactive members or offices that didn’t pay dues.

Step 1: Request a Batch Refresh from NRDS. NRDS will email the file to the key office contact that NRDS has on file.

  1. Go to the NRDS site (https://www.realtor.org/)
  2. Log on using your association NRDS Login and Password
  3. Click the NRDS link and then POE connect to NRDS
  4. Click Batch Refresh – do NOT use Batch Download
  5. Select the following criteria:
    • Select File Type: Fixed Length
    • Select Refresh Format: E-Mail the File
  6. Click Refresh Now

Note: NRDS will email the refresh data as an attachment to your Local AOR staff email address that is on file in their system.

 

Step 2: Save the file. When you receive the file from NRDS, save it to the directory shown in the Directory Path field of the NRDS Verification Utility (this is usually the R:\RAP\NAR\ NRDSIN\ARCHIVE folder, but your association’s setup may be different).

Step 3: Go to the NRDS Verification Utility in Data Exchange.

  1. Click the Utilities tab, and then select the NRDS Verification button. The NRDS Verification Utility opens.

Enter the following data:
Sender: NRDSIN
Association: Select your association

  1. Select the Bill Types you wish to compare:
    • NRDS vs. Assn: Zoom to select statuses you wish to compare *Note: Active will only show if you have members that are active at NRDS and not active in your local database
    • Assn vs. NRDS: Same as above
  2. Compare: Check the options for Office, Member, and Check Member License
  3. Directory Path: This is usually set to R:\RAP\NAR\NRDSIN\ARCHIVE; if a different path displays, be sure to save the file that you received from NRDS to that folder
  4. File Name: Use the file name provided by NRDS, such as 4850FULL.ZIP

 

This report shows you inconsistencies between your data and the data at NRDS.

This report compares the data in four ways, as follows:

NRDS vs. Association (Members) – The data on the left side is from the NRDS file and it’s compared to the comparable records in your database. This is showing you what NRDS has on file, and in what ways it does not match the records in your database.

NRDS vs. Association (Offices) – The data on the left side is from the NRDS file and it’s compared to the records in your database. This is showing you what NRDS has on file, and in what ways it does not match the records in your database.

Association vs. NRDS (Members) – The data on the left side is from your database and it’s compared to the data on file at NRDS. In some instances, this report may be larger due to the fact that you may have numerous member types that you do not report to NRDS. This is normal.

Association vs. NRDS (Offices) – The data on the left side is from your database and it’s compared to the data on file at NRDS. In some instances, this report may be larger due to the fact that you may have numerous office types that you do not report to NRDS. This is normal.