HOW TO EXPORT DATA FROM YOUR MLS
- Navica
STEPS TO EXPORT DATA FROM YOUR MLS
1. Create the Custom Export by adding the required fields.
Before you can export data, you must first setup the Export format.
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.
When you create your export format, it must be setup exactly as shown in this section for the Focus 1st
application to understand the format.
Once you've logged into the Navica system,
using the menu on the left side of the screen,
select the RESOURCES drop down option.
Then select the CUSTOM EXPORTS option.
Once you select the CUSTOM EXPORTS option,
the EXISTING CUSTOM EXPORT screen will be displayed as shown below.
Now select NEW EXPORT button,
located at the top right of the screen to create a new custom export.
Once you've selected the NEW EXPORT button,
the EXPORT SETTING SETUP(1) screen will be shown.
Select the RESIDENTIAL option and then
press the NEXT STEP button.
You will see the EXPORT SETTING STEP(2)
screen as shown below.
In Step(2), you will need to define the fields for the new Export format (also referred to as Export
Definition).
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 FIELDS TO CHOOSE FROM table (on the left),
and add it to the CURRENT SELECTED FIELDS table (on the right)
by pressing the >> 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,
press the NEXT STEP button to go to the
EXPORT SETTING STEP(3) screen.
- Place the name “Focus1st" as the FILE EXPORT NAME as shown
above.
- Select "Yes" for the INCLUDE HEADER ROW option.
- Select "Tab" for the COLUMN DELIMITER option.
Once you've provided the Name and selected the options above press the COMPLETE button.
You are now ready to do your MLS search and export your results.
2. 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 "Closed", "Withdrawn", and "Expired" dates to be two years
back.
When searching for all status activity for the last two years,
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.
When searching for all status activity for the last two years, 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.
3. Export your results
To export the results,
first select the All box located just above the search results.
This will allow you to export all your search results.
Next select the Export button which is located just above in the
menu bar (see graphic above).
Once you've selected the Export button you will see a screen
similar to that shown below which is showing all the Existing Custom Exports .
