HOW TO EXPORT DATA FROM YOUR MLS
Mesquite, NV - Realty Pro MLS
3 STEPS TO SETUP YOUR EXPORT FORMAT
1. Create your MLS search
In selecting data, make sure that ALL status options are selected.
Selecting all status activity will ensure that all the data needed to create the graphs is collected.
Additionally, you will need to select the "Status Date" or "List Date" to be 24 months back.
When searching for all status activity for the last 24 months,
your search results should be in the 50 to 100 comparable properties range (this is a rough guideline).
If you have slightly less than 50 that works, or a little above 100 is fine as well.
You should also make your normal selection choice by selecting other options that you would normally select in doing a CMA.
For example, options you would normally use when doing a CMA,
could include a map search (using a polygon), subdivision or neighborhood,
city, zip code, lot size (<.5 acre, 1-5 acres, etc. ), on water. Looking at activity in specific subdivisions is also good starting point.
For your initial search you want to focus on location (location, location) and add in unique features (only if necesssary). To view a
short tutorial on how to do an effective search to use in your Focus 1st Pricing, select this
link.
Once you've selected the search criteria, press the SEARCH button
to see the results as shown below.
***Before you can export data, you must first setup the Export format.
This is a ONE-TIME action that you will need to do.
The format must be setup as shown below for the Focus 1st software to
understand the format.
When searching for all status activity for the last 24 months, your search results should be in the 50 to 100 comparable properties range (this is a rough guideline). If you have slightly less than 50 that works, or a little above 100 is fine as well.
2. Create the Custom Export by adding the required fields.
NOTE: This is a one-time action that you will need to do.
Once you have created your export format you will not need to do this again and you can skip this section.
Once you are on the results screen showing your SEARCH results,
select the Change View dropdown option.
Then from the dropdown menu,
select the Manage/Create Views option as shown below.
Next select the Create New Custom View link (as shown below),
Once you've made that selection, you will see the dialog box as
shown below.
To help identify the Custom Export,
we recommend that you set the View Name to "Focus1st".
To do that, select the text in the View Name area
at the top of the dialog box, and type in "Focus1st".
Next, move all the necessary fields over to the View Fields/Columns area.
Doing the following will ensure the Custom Export includes the required fields for the software to provide accurate results.
- Select the field names (see table below) to be selected from the
Available Fields/Columns table (on the
right).
and add it to the View Fields/Columns table (on the left) by
pressing the Arrow button.
- You will see the field selected move to the table on the right.
Do this for each of the field names shown below.
Once you have added all the fields from the table above,
save the Custom Export (View Name) by pressing the Save Changes button.
Note, when you save the changes you will see the following messages.
These message are routine and don't affect the export process.
Press the Continue button to continue.
Press the OK button to continue.
3. Export your results
To export the results, while on your search results screen,
select the Export button.
When you select the Export, you will see a screen
(see below) with drop down menus.
Select the Custom View that you named "Focus1st Export".
Be sure to keep the other dropdown options as the default.
That is the Format should be
ASCII Text Tab Delimited.
You may decide to change the name of the file by placing your file name in the
Save File As: area.
NOTE: Be aware that you are only able to export 100 data points.
You may need modify your search so that you limit your search result to less than 100 data points.
Then select the Export Data button again and you will see the "Export File" created.
The export file will be downloaded into your "Downloads" folder.
ATTENTION MAC USERS: Do NOT open the export file while in your MLS.
If you do, the NUMBERS program will corrupt it rendering it un-stable by the Focus 1st software.
Only open the export file when in the Focus 1st software after clicking on "Start Here".
When you run the Focus 1st software,
you will need to find the exported data file, in the "Downloads" folder.
It may make sense to move the file to a location that is easier to find.
For a short video on how to do your search, and export your results to downloaded into the
Focus1st Pricing software, select this
link.
NOTE: Be aware that you are only able to export 100 data points. You may need modify your search so that you limit your search result to less than 100 data points.
