Exporting Data from SCWMLS – South Central Wisconsin

Using Customize to setup the Export Format

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 exactly as shown in this section for the application to understand the format.

Once you are in the search spreadsheet screen, use the button to customize the spreadsheet. Once you’ve pressed the graphic you will see a dialog box as shown below.

Start from the default spreadsheet by pressing the button. Once you’ve reset the spreadsheet definition to the default, you will select and add fields as shown in the dialog box below.

First select the name “List Date” from the “Available” table (on the left) and add it into the “Selected” table (table on the right) by using the button. You will see the item move to the table on the right.

Do this for each of the options as shown in the graphic above.

Note: Be sure that you include all the fields shown below into the Spreadsheet. Including additional fields for your personal usage is acceptable as well.

Fields to be included are:

· MLS#

· Status

· Address

· Unit #

· Bedrooms

· # Full Baths

· Total Finished SqFt

· Closing Date

· County

· Expiration Date

· List Date

· List Price

· Off Market Date

· Sold Price

· Subdivsion

· Days on Market

· Estimated Age

· Style

Once you have completed the task above, save the results by pressing the button. You are now ready to do your MLS search and export results.

Note this change will need to be done for the Condo spreadsheet as well.

SCW MLS

In selecting data from SCW MLS, be sure to select the options below:

Make sure that all the status options are selected. This option will make sure that all the data that is needed to create the appropriate graphs, is collected. Additonally, select the “Off Market Date” to be 1/1/2006.

This assumes it is 2008 and you are only looking for the last two years of data.

You should also make your normal selection choice by selecting other options that you would normally select in doing a CMA. As mentioned earlier, looking at activity in specific subdivisions is a good starting point.

Once you’ve selected the search criteria, press the button to see the results as shown below. Now you are ready to export the results. To export the results, select the button.

When you select the export button, the area is displayed on the right side of the screen. Select the “Spreadsheet Comma Delim” option. Once you do that, you will see a screen similar to the screen below.

You are now ready to save your file. Use the button to create your File. Notice that you may position your cursor in the “Name” field and rename the file to be created. The first time you use this button you may see the following message. If so, please make sure to run the system checker, to allow you to create the file.

Note: You will only need to run the Sytem Checker once.

The System Checker can be found on your logon screen as shown below.

The file will now be created. When the file is created you will see the following message.

Note if you get an error while exporting the file, you may need to "Set the Export File Path". Press this link to see instructions on how to Set the Export File Path.

Once you have saved your exported file, you are ready to run the application.

When you run the application you will need to find the exported data file, so be aware of where the file has been placed. It may make sense to move the file to a location that is easier to access.

For instructions on how to run the application, be sure to see http://www.focus1st.com and take a look at the tutorial section.