Exporting Data from Can, Whistler, British Columbia - Matrix

Using the “Custom Export” 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 Buying Pattern application to understand the format.   To create your export format, select the following menu items: My MatrixgSettingsgCustom Exports. 

Press the “Add Export” button to create your Export Format.  You will see a screen similar to that shown below. 

First place the name “Focus 1st” as the “Export Name as shown above.  Then you will need to define the fields to be in the new Export format (also referred to as Export Definition).  To define the fields, select a field from the left table (shown as “Available Items” and press the “Add->” key.  You will see the item move to the table on the right. 

 

Do this for each of the options as shown in the list below. 

Additionally, make sure to select under the “Include Column Names:” option the “Name” option button, and make sure to select under the “Separation:” option the “Tab” button. 

 

Note: Be sure that you create the column report with the items shown below. 

 

Address Unit

Area

Bathrooms

Bedrooms

Built

Date Listed

Date Modified

Date Sold

DOM

Expiry

MLS® No.

Price

Size

Sold Price

Status

Statusdate

Streetsuffix

Streetname

Streetdir

Streetnumber

Type

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. 

Matrix MLS

In selecting data from the Matrix 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.  

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. 

You will also want to make sure that you select data for the previous two years.  You can limit the amount of data selected by selecting the sold date and allowing for only data for the previous two years (such as 1/1/2008+ assuming this is 2010).  

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, select the “Export” button as shown below. 

When you select the export button, the dialog shown below is displayed.  Select the “Focus 1st” option and push the “Export” button.  

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. 

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