First, import Up to 20 Comps from Your MLS, then
 let XpertCMA do a day's work (in a few seconds) of Quality Sorting, Adjusting, Color Coding, and Displaying
them on a Single Screen for Your Input.
 

 
 
 

MLS Data Import

 
 
How It Works XpertCMA is already configured to import data from most MLS systems, though XpertCMA will provide accurate results whether the comp data is imported or entered manually. If the number of comps is limited, it may be just as efficient to enter the comp data, since none of the subjective factor data is in the MLS anyway.

Almost all MLS have an option to "export" or "download" and save data from a search of comps to the user’s personal PC. Most agents are not aware that this feature is in place and have not used it previously.

XpertCMA can be configured to import search data exported from almost any MLS in a few minutes. It is just a matter of matching the field names.  We prefer to do it for you, but you could do it yourself from the MLS Control menu.

MLSs Configured As of Today >> If your MLS is on this list, indicate in the Comments on the Order Form, and you will receive the set-up files with instructions to configure to your MLS output format.
State - Major City - MLS Name
AL
Baldwin County
AR

VOYAGER Little Rock
AZ
ARMLS of Phoenix Metro Area
Lake Havasu
White Mountain, - MLS
Sedona - Rappatoni (Lightning file)
AR
VOYAGER Little Rock
CA
SANDICORE MLS San Diego
SacramentoMLS
BAREIS MLS Vallejo
Freemont
SCMLS Orange County CA
REIL MLS in San Francisco Bay Area
LA/Hollywood - SCMLS & TEMPO
East Bay SF,Delta Board-Anitock-FNIS-Paragon
Pasadena ITech MLS
Riverside MLS
Stockton MLS
Redland IRMMLS
Palm Springs MLS
LakeCounty No CA ParagonMLS
Vallejo
CANADA
Totonto TREB MLS
Alberta MLXchange
CO
Ft. Collins Area
Colo Springs, Pikes Peak Assoc. MLS
Boulder- IRES MLS
Durango
Denver
Loveland
Sterling - IRES MLS
CT
Hartford MLS
New Haven MLS
Norwich ARIS MLS
Norwalk ConsolidatedFNIS MLS
DC (Washington DC)
MRIS
DE
TREND MLS - Pennsylvania, Deleware, New Jersey, Maryland
FL
Daytona Beach
Jacksonville
INTEREALTY MLS - Orlando
Key West
Gainsville
Miami MLS
Naples Sunshine MLS
Orlando
Pensacola LIST-IT MLS
Winter Haven MLX Exchange MLS
Sarasota MLS
Tampa+ MIDFloridaMLS
Talahassee - FNISParagon
New Port Richey Area MLS
West Palm Beach MLXchange
GA
Atlanta FirstMLS
HI
Kauai, Hawaii
Waipahu HI
Honolulu HI MLS
IA
Carroll, IA Rappatoni
Davenport,IA-Peoria, IL- FINISParagon
Dubuque, IA
Iowa City
Sioux City
Cedar Rapids
Waterloo/Cedar Falls
ID
MLS in Boise
Lewiston - Paragon./Voyager MLS
IN
Indianapolis
IL
Northern - Davenport,IA-Peoria, IL- FINISParagon MLS
ChicagoConnectMLS
Southwestern SIR MLS (Southwestern Ill Regional)
KS
Olathe
Salina MLS
LA
Schreveport
Lake Charles
MD
TREND MLS
MRIS serving DC, MD,VA, PA & WV
MA
Boston - MLSPin
Worcester
MI
Ann Arbor
Detroit - RealCompMLS
Ishpemming
Grand Rapids
Jacksonville
MN
Minneapolis/St. Paul - NorthStar MLS
Brainerd
Fairbault MLS
SE Minnesota MLS
Southern MN - RASM
MO
MLS Springfield
MARIS MLS St. Louis
Hattiesburg FLEXMLS
MT
Billings MLXchange
Great Falls - Voyager
Missoula
NC
RISCO Voyager/Paragon MLS - NW, NC
Maggie Valley
Charlotte NC, Carolina MLS
Ashville. NC INNOVIA MLS
Jacksonville, NC MLS
Wilmington, NC
ND
Bismark, ARIS
Wilmington
NE
Omaha Rappatoni MLS
Lincoln MLS
NJ
TREND MLS - Pennsylvania, Deleware, New Jersey, Maryland
AVON by the SEA
Central
Newark GSMLS
Monmouth County MLS
NM
Farmington Voyager
Santa Fe MLS
NV
Las Vegas, Nevada MLExchange
Reno MLS
NY
White Plains, WestchesterMLS
Long Island Stratus MLS
OH
Northern Ohio NORMLS (Cleveland Area)
SE Ohio (Orwell area)
Sandusky Area-Rappatoni
Youngstown MLS
OR
MCLS in Mid Columbia River Gorge
RMLS Portland
PA
TREND MLS - Pennsylvania, Deleware, New Jersey, Maryland
MRIS serving DC, MD,VA, PA & WV
RI
Statewide MLS
SD
RASE MLS Sioux Falls area
TN
Brentwood - RealtracMLS
Oakridge
Knoxville
Bristol Paragon System
Bristol Tenn-Virginia MLS system
TX
Austin TEMPO
Dallas/Ft.Worth NTREIS
Midland Navica MLS
San Antonio and Southern Texas SABOR MLS
Houston TEMPO MLS
UT
WFRMLS
VA
Lynchburg MLS Area
Central VA Regional TEMPO
MRIS serving DC, MD,VA, PA & WV
Bristol Paragon System
Bristol Tenn-Virginia MLS system
VT
Innovia by Marketlinx
WA
MCLS in Mid Columbia River Gorge
Redmond MLS
Tri-City (Kennewick, Pasco, Richland) Voyager MLS
NWMLS Seattle/Tacoma/Olympia
Spokane - ParagonMLS
Port Townsen - OSL MLS
WI
Realtors Assoc of NW Wisconsin
Green Bay MLS
WV
Parkersburg, WV
MRIS serving DC, MD,VA, PA & WV
WY
Cheyenne
Casper
 
If Your MLS is Not On The List NOTE: XpertCMA will provide accurate results whether the comp data is imported or entered manually. If the number of comps is limited, it may be just as efficient to enter the comp data, since none of the subjective factor data is in the MLS anyway.

We can easily configure for any MLS that has a method for it's users to export search files in almost any format. This includes Sandicor, FMLS, NRMLS, Voyager, Paragon, FNIS, MRIS, NETRIS, RMLS, Risco, Fidelity, TREND, TEMPO, REIL, MLXchange, IRES and almost all custom or local systems. We just need to match your field names with XpertCMA, a 5 minute job. Here is what we need to be emailed as an attachment:

This entire procedure should not take more that a few minutes of your time and will save you many hours in the future. Almost all MLS have an option to export and save the data from a search of comps to the user’s personal PC. Most agents are not aware that this feature is in place and have not used it previously.

The common procedure is to perform a normal search for 5-10 comps, either active or sold. Rather that printing, emailing or viewing in various formats one of the options should be to “export” or “save” the data as a text file.. The format options are usually (1) tab-delimited (a .txt file), (2) comma-separated (a .csv file), (3) pipe-delimited (a .cmf file) or (4) Excel (a .xls file). None of these files would normally mean anything to the user and if viewed would not make much sense, however, the file would contain all of the property data for each comp in a readable format by the computer in the right programs.

Most agents have been able to find the “export” option, save the file on their PC, and email it to us. If the file is of the right format we can match your MLS fields with XpertCMA and send you a small file to install to configure your MLS. This is a one time procedure. From that point, you can do a search of up to 20 comps, import them into XpertCMA. The program will immediately analyze all comps, adjust for differences, color code the adjustments and quality sort the comps. The result is awesome.

If you are not able to “export” the file, your MLS should be able to show you the procedure to export an ASCII file from a search. The file you want is for your personal use, not XpertCMA. There is no intellectual property issue. You could use the file in Excel for your own purpose or in XpertCMA which is on your personal PC also. If you have a choice of fields to export, choose “all fields” rather than creating a custom list or ask us which to add to a custom list if no other alternative.

 

These steps were given to us by users
to help other users

Note: The local MLS can choose different options and the steps can vary.

IRES

MLXchange

Boulder- IRES MLS
Step-by-step procedure for exporting searches from the IRES MLS.

1. Perform a normal search for comparables in IRES MLS
2. Select the best comps (max: 20) from your search results
3. Select the "!Export" button
4. From the pulldown menu in the popup window, choose: "Export56Fields"
5. Select "Export"
6. Select "Save"
7. Enter a name for your export file (if desired), then select the "Save" button. Save the file where you can find it later. 
Las Vegas, Nevada MLXchange
Step-by-step procedure for exporting searches from the MLS.
1. select from 1-20 potential comps as usual. To export the data:
2. choose tab, grid format, include column headers
3. save where you can find the file later (rename the file if desired)

Rappatoni

TREND

Omaha - Rappatoni MLS
Instructions to Export search results are on the Exporting Listings menu on the MLS.
1. Search and select 1-20 comps to export.
2. Export (all fields) as a comma-separated (.csv) file
3. Save (rename if desired) on your PC where you can find it to import.

Wilmington, Dover
Here are the step-by-step instructions to download from the TREND MLS:

1.    Define search criteria
2.    Perform Search
3.    Tag comps to be used
4.    Export Tagged (button)
5.    Report Type: "Realty Tools Export"
6.    Create Report (button)
7.    File Download
8.    Save to: 

TREND MLS - New Jersey-Trenton, Camden

Here are the step-by-step instructions to download from the TREND MLS:

1.    Define search criteria
2.    Perform Search
3.    Tag comps to be used
4.    Export Tagged (button)
5.    Report Type: "Realty Tools Export"
6.    Create Report (button)
7.    File Download
8.    Save to: 

 

REIL

REIL MLS in San Francisco Bay Area
Step-by-step procedure for exporting searches from the MLS.
1.  Sign on to the MLS program, Listrak
2.  Push the top button on the left menu, Search the MLS
3.  Make certain DRE number and password are correct, push OK
4.  Set up search criteria for comparative analysis search
5.  Search for sold properties
6.  Name and save search under a new name, ie 123MainComps033004
7.  Select 20 or less comparative properties for the analysis
8.  Select: Tools/Import Export
9.  Select To Delimited Format
10.Select OK
11.Select To Delimited Format, Field Names on First Row, Text qualifier " is OK
12.Select OK
13.Name and save the file to a directory folder so you can find it again.  IE. C:/Properties/123 Main Street.  Name file:IE, 123MainSearch033004
14.Select OK when program indicates file was saved successfully
15.Push Cancel on Import Export Menu Box
16. Close down Listrak
17.Open Xpert CMA - Residential
18. Select new CMA
19. Locate the file and Import comps according to Xpert CMA directions

FNIS Paragon

FNIS Voyager

East Bay SF,-Delta Board-Anitock-FNIS-Paragon MLS
When in Paragon, click on “Preferences.”
Under Spreadsheets click on “MLS Listing Summary Spreadsheet”

A new window will open listing the available fields on the left, then another box on the right showing what fields have been chosen. To select all of the fields, click in the small blank box at the upper left corner. Then hit “add.” This will move all the fields from the left box into the right box. While all those fields are still highlighted, uncheck the boxes, “use short label” and “use short value, if available.” The click “save & close”

To do a CMA—Run your comps and select them. Choose “MLS Listing Summary Spreadsheet” as your view. Then export.

Dubuque, IA - Paragon
To export the file from Paragon:
1. Click on Search /Property, enter your primary criteria, then Search. It will be spreadsheet form.
2. On the top choose the comma delimited.
3. Click anywhere on the screen and Clk Ctrl A, to select all. Then click Ctrl C to copy, Click on Windows R to start notepad, Clk Ctrl V to paste it on notepad.
4. Save it where you want and when you open your CMA you can import your comparables from wherever you saved it.

MLS in Boise - Paragon III
Step-by-step procedure for exporting searches from the Paragon 3 MLS:

1. Determine properties to use in "spreadsheet form"
2. Go to views/reports button and highlight "specialty views" and pick "Excel"
3. In the Excel spreadsheet click on the green X (Excel) This pulls up Microsoft Excel
4. Save as Text (Tab-Delimited) to desktop
5. Import into Xpert CMA Residential
6. If doesn't import, copy and paste into "My Documents" and import from there.

Santa Fe MLS - Paragon
Step-by-step procedure for exporting and saving the searches from your MLS:

Use the Desktop, data download system (not the other) 
The sequence:

Preferences on menu bar
Export Property Setup in pull down
Select All Fields to include
In center check file path: C:\Programs\Paragon MLS\Save Docs\
Check off delimited; tab as form
Check off EITHER append or overwrite existing file
Include field headers, CLICK APPLY, OK
GO TO THE SEARCH WINDOW AND CREATE THE SEARCH SETTINGS, NARROW THE CHOICES AND CLICK “EXPORT DATA”
Export, rename if desired and save file where you can locate it later

San Antonio and Southern Texas SABOR MLS
Step-by-step procedure for exporting searches from the new Paragon MLS:

  1. Log into Paragon

  2. Search for Criteria

  3. Select Comparables You Want to Use

  4. Click on View Reports

  5. From Click on View Reports scroll to “Export” and click on Spread Sheet Comma Delim

  6. At bottom of the report click on “Select All”

  7. Rename: Comma Delim to a file name you will want to use such as JohnDoe

  8. Click on Create File (Active X)

  9. The following will appear “Successfully created export file: JohnDoe.txt

  10. Click on Ok and the file will be saved to your DESKTOP (by default)

  11. Log Off Paragon

 

VOYAGER Little Rock
Step-by-step procedure for exporting searches from the MLS.

  1. Open Voyager>tools>options>field preferences for spreadsheet: (no pictures), remarks, sq. ft., bedrooms, baths, garage, age.>apply>ok

  1. After search: search results-spreadsheet screen>select all (bottom of screen)>file>save as>(name, then to desktop)

  1. Open Xpert CMA and import file from desktop, continue.

  2. Durango FINIS Voyager 2

    Do a normal search of 1-20 active or sold comps.

    1. Choose Tools  for a dropdown menu.
    2. Choose export, Export Setup.

    3.
    "Select all" fields.
    4. Under File Options "Browse" and select a location for the export to go to you PC. 

    5. Select tab-delimited

    6.
    Check the box that says "Include File Headers"...
    7. Then click apply and you're all done.  hopefully you can find the file when importing into XpertCMA

    Cheyenne

    1. Open Voyager

    2. do a search

    3. select about 6 listings

    4. go to preferences

    5. field preferences…Add All

    6. under view tab…go to Excel

    7. under Microsoft Office Spreadsheet, go to the green X

    8. this will bring up the listings in a spread sheet form

    9. go to file:  save as:  make up a file name, save as text(tab delimited)

    10.  save on desk top

    11. email this as an file attachment.