Exporting Data from CAN, BC, South Okanagan SOREB – Interface Express

In selecting data from Interface Express, be sure to select the options below:

·      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. 

·      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.  

·      It is also recommended that you include data from the last two year to enable you to see the recent patterns. 

Once you’ve selected the search criteria, press the ‘Search’ button to see the results as shown below.  Now you are ready to download the results.  To download the results, first select the “Custom Grid View” using the drop down arrow in the “View As” option as shown below. 

 

Once you select the “Custom Grid View” you will see the interface changes.  You may need to add some additional column so that all the columns listed below are shown.  To add columns select the “down arrow” on the “column” field located at the right end of the grid.  After you modify the result to include all the columns necessary, you can save the column format.  Be sure that the following columns are all part of your results. 

·      Address

·      Price

·      Area

·      Sub Area

·      Status

·      MLS #

·      Age

·      BR

·      Bth

·      Price Sold

·      Date Sold

·      Date Chnged

·      Date Expired

·      Date Listed

·      Lot SqFt

·      Price Orig

·      SqFt Fin

·      SqFt Unfin

·      Stories

·      Yr Blt

 

Next you will want to be sure that all your search results have been selected.  To do so select the “Select All” box which will then select all your search results. 

Once you have all your search results selected you are ready to export your data.  To export your data, use the “Select Action” drop down arrow and select the “Export Grid” format as shown below.  

The download will now start.  Once the download starts, you will be asked if you want to save the file.  Select the save option and then choose a file name. 

Be sure to remember where you save your file.  This is the exported file that will be used to create your graphs.

You will see dialog boxes similar to what you see below.

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

When you run the application you will need to point to the exported data file, so make sure that you’ve placed the file in an easy to find place.

For instructions on how to run the application, be sure to see the tutorials located at http://www.focus1st.com.