Magic Support Articles

Data Review and Clean Up - Part 1

Title: Data Review and Clean Up – Part 1
Submitted by: Rapattoni Magic Software Support
Issue: What reports and utilities can help me review and clean up my Magic data?

Rapattoni Magic contains many reports, utilities and tables that can assist your association with data review and clean up. For example, you can check for everything from inconsistent status relationships between agents, brokers and offices, to discrepancies between records in the Magic and NRDS database. Data integrity is essential to ensuring accurate billing and consistent rosters, reports and merges. It is suggested that these reports, utilities and tables be utilized on a quarterly basis.

Data Verification Report

This report looks for active members in inactive offices, active members in an active office but with an inactive responsible member, and active offices with no active members.

Membership

Member Reports

Data Verification Report

Data Verification Report

Find/Correct Illegal Data Utility

This utility locates illegal characters that can cause errors with your rosters and mail merges. It also looks for incorrectly formatted email addresses, such as johnbrown@aol or johnbrown&aol.com, etc. If you would like Magic to fix the illegal characters, select the Correct and Report option. The utility will not fix email addresses, but will give you a list of addresses with bad formatting so that you can contact the member and make the necessary corrections.

System Setup

Utilities

Find/Correct Illegal Data

Find/Correct Illegal Data Utility

NRDS Implementation Utilities

These utilities find records with blank or duplicate NRDS IDs and License IDs.

System Setup

NRDS Implementation Utilities

Member Data Analysis

Office Data Analysis

Click “Compute Duplicate/Blank Totals” for both Member Data Analysis and Office Data Analysis.

Member Data Analysis

Then, click “Continue.”

Compute Duplicate/Blank Totals

Then, click “Exit.”

Display Statistics

Finally, click “Print Report.”

Member Data Analysis

NRDS Verification Utility

This utility compares your association’s records at NRDS to the member and office records in your Magic database. It is important that you research and fix any member or office records that are inactive or terminated in your database but active in NRDS.

Step 1: Request the file from NRDS. NRDS will email the file to the key office contact that NRDS has on file. Go to the NRDS site (www.realtor.org) and log on. Click on the “NRDS” link and then on “POE connect to NRDS.”

  1. Log on using your association NRDS Login and password.
  2. Click on “Batch Refresh.” Do NOT use Batch Download.
  3. Select the following criteria:
    1. Select File Type: Fixed Length
    2. Select Refresh Format: E-Mail the File
  4. Click “Refresh Now.”
Magic 7 users and State Associations ONLY: After receiving the ZIP file, please contact Rapattoni Magic Support for assistance. Magic 8 and 9 users should follow these instructions:

Step 2: Save the ZIP file to the r:\rap\nar\nrdsin\archive folder. (Change r:\ to your Rapattoni drive letter, as applicable.)

Data Exchange Retrieve Transmittals

Click the Utilities tab, and then click the NRDS Verification button.

NRDS Verification Utility

Member Type, Billing Type and Office Type Clean Up

It is a good idea to clean up old, unused billing types, member types and office types. Membership staff can be confused when selecting member, billing and office types for current, active records if these tables are full of old, unused options. You can generate printouts of these tables, and then run the Change Member Billing Type and Change Office Type utilities in order to fix any member and office records that have been assigned old, invalid billing types and office types. Once this is done, a Rapattoni Magic support representative can delete the now unused member, billing and office types.

Membership

Setup

Setup Table Printouts

Member Type Printout

Billing Type Printout

Office Type Printout

Use these reports to determine which types are no longer used. For example, let’s say that you no longer use billing type AF3, but there are 200 old, inactive member records assigned to the AF3 billing type. Rapattoni would not be able to delete billing type AF3 from your system until you have moved these records to your current affiliate billing type. You can quickly and easily change AF3 to AFF by running the Change Member Billing Type utility. Keep in mind that assigning inactive records to a billing type will not affect your membership counts.

For members, select Membership > Utilities > Member > Change Member Billing Type.

For offices, select Membership > Utilities > Office > Change Office Type.

Once you have cleaned up all old records assigned to invalid billing, member and office types, contact Rapattoni and ask us to remove these old types from your system.

Membership Counts Reports

The Membership Counts Reports should be run on a monthly basis so your association can track changes in membership trends. This report will also help you to see if members have been assigned to incorrect billing types. From the Billing Type field, press F5 to zoom and make sure that all billing types are selected.

Membership

Member Reports

Membership Counts Report

Membership Counts Report

Utilizing these reports, tables and utilities will ensure that your data is as clean and up-to-date as possible. Your reports, merges and billings will run smoother and more efficiently.

Help is available for all of the programs listed above. Simply press the F1 key on your keyboard for detailed information about the program you are using.

If you need additional assistance, please contact Rapattoni Magic Support via email at This email address is being protected from spambots. You need JavaScript enabled to view it. or call our help desk at (866) 730-7115.