HOW TO EXPORT DATA FROM YOUR MLS

- Rapattoni

STEPS TO EXPORT DATA FROM YOUR MLS

Create a Custom Export by adding the required fields.

Create your MLS search.

Export the results.

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 Rapattoni system, use the Admin drop down button and select the Custom Export Setup option.

Be aware that in some MLS's the Custom Export Setup function may not be available. If this is the case, you will need to contact your MLS and request for the Custom Export Setup function to be activated for your account.

Once you've selected the Custom Export Setup option, the Listing Information Export screen will be shown.

If you defined any previous export formats they will be shown. To define your new export format, press the Create Export button located at the top of the screen. When you press this button, you will see the Create Listing Information Export Layout screen as show below.

Place the name “Focus1st" as the Name as shown above.

Make sure that Excel is the File Format.

Select "Yes" for the Include Field Names option.

Select "No" for the Include Pictures option.

Note: the value of the Display Order can be left alone or set to '1'.

Once you've provide the Name and selected the options above press the Save button. You will now see the Revise Listing Information Export Layout screen as shown below.

Next, 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 AVAILABLE RESIDENTIAL FIELDS table (on the left), and add it to the SELECTED FIELDS table (on the right) by pressing the ADD -> 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 by pressing the SAVE button (located near the top of the screen).

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.

3. Export your results

To export results you must first CHECK the properties you want to export. We recommend that you just check them all, to export all the properties. To check all the properties at the top of the search screen, select the box located at the tab at the top of the screen next to the Residential label. You will see all the properties check boxes checked (located on the left side of the results screen).

You are now ready to export your results. To export the results, while on your search results screen, select the EXPORT button.

When you select the EXPORT button, you will see a screen (see below) with a drop down menu.

Select the Custom Export that you named "Focus1st".

Then select the Submit button and you will see the "Export File" created.

The export file will be downloaded into your "Downloads" folder. In most cases the name of the file will be automatic by your MLS. It may make sense to move the file to a location that is easier to find.

Select the "Realty Tools without Photos" Listing Export Options.

After you select the Submit button, the dialog shown below will be displayed.

Select the link and you will be shown a "File Download" dialog box which will enable you Save the file. Notice that the file is a "ZIP" file. Select the OPEN and you will see the following dialog box. From this dialog box you can just "DRAG" the file to the location of your choice.

When you run the Focus 1st software, you will need to find the exported data file.

For a short video on how to do your search, and export your results to downloaded into the Focus1st Pricing software, select this link.

For more instructions on how to run the Focus 1st software, be sure to check out our Youtube channel by selecting this link: