Magic Resource Center Article

Magic Resource Center Article

Title:

NRDS to Magic Verification and Comparison Report

Submitted by:

Rapattoni Magic Software Support

Updated:

March 1, 2007

Version:

Rapattoni Magic 7, 8, 9

Issue:

How do I run a report that will compare my membership data to the data at NRDS?

As many of you know, NAR plans to run all membership counts, by local association, directly from the NRDS system on April 1, 2007. These will be the counts used to assess any delinquencies.

With this in mind, now would be a great time to run the NRDS Verification Report to compare your data to the data on NRDS. After running the report, it is important to research any members or offices that are inactive in your database but active in NRDS. This will help you avoid getting charged for members or offices from whom you have never collected dues.

Below are step-by-step instructions for Magic 7 and 8 users, for both local and state boards.

Step 1: Request the file from NRDS. NRDS will e-mail the file to the key office contact that NRDS has on file.

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

Note: NRDS will e-mail the refresh data as an attachment to your Local AOR staff e-mail address that is on file with them.

Magic 7 Users and State Associations ONLY: (Note: If you are a Magic 8 or 9 user skip to Step 3.)

Step 2: Unzip the file from NRDS. Once you have received the ZIP file from NRDS, you need to unzip the file.

  1. Delete all files except the files ending in .m00 and .o00.
  2. Rename the two files with your NRDS ID followed by yesterday’s date. For example – 4850FULL.m00 would become 48500215.m00.
  3. Zip the two files together and name the ZIP file using your NRDS ID followed by yesterday’s date and end in .z00. For example – 48500215.z00.

Both Magic 7 and 8 Users:

Step 3: Save the new file. Rapattoni Magic 7 and 8 users must save the ZIP file to your r:\rap\NAR\NRDSIN\ARCHIVE folder. (Change r:\ to your Rapattoni drive letter, as appropriate.)

Local Associations:

nrdsbatch1
                  nrdsbatch1

  1. Click on the Utilities tab then select the NRDS Verification button. Your window will look like this:

nrdsbatch1

  1. Fill in the following data:
    1. Sender: NRDSIN (Create if absent.)
    2. Association: Select whichever is appropriate.
    3. NRDS vs. Assn: Check Active Only
    4. Assn vs. NRDS: Check Active Only
    5. Compare: Check Office, Member and Check Member License
    6. Directory Path: r:\rap\transfer\ (Change r:\ to your appropriate mapped Rapattoni drive letter and make sure to include the final backslash after transfer.)
    7. File Name: Magic 8 or 9 users will use the file name that was e-mailed to them by NRDS, such as 4850FULL.ZIP. Magic 7 users will use the file name of the re-zipped file, such as 48500215.z00.
  2. Click on Create Report.

 NOTE:  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 comparing what you have in your database. This is showing you what NRDS has on file, and in what ways it does not match what you have in your database.

NRDS vs. Association (Offices)

The data on the left side is from the NRDS file and it’s comparing what you have in your database. This is showing you what NRDS has on file, and in what ways it does not match what you have in your database.

Association vs. NRDS (Members)

The data on the left side is from your database and it’s comparing what is 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 comparing what is 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.

If you need assistance running this report, or interpreting any items on the report, please feel free to contact our AMS Support department.
MRC Links
© 2008 Rapattoni Corporation. All rights reserved.