Exporting Data from CAN, Ontario, Barrie – Fusion

Using the Grid Manager 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 as shown in this section for the Focus 1st application to understand the format.  

Once you are showing some search results, press the grid Manager graphic  (as show above) to access the grid Manager.  Once you’ve pressed the graphic you will see a dialog box as shown below. 

Press the “Create New Grid” to setup the Export Format needed.  When you press this link, you will see a screen as shown below.

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

Do this for each of the options as shown below.  Note: Be sure that you create the column with all of the items shown below. 

·      Address (Address)

·      Finished Area (SqFt.) (FinArea-F)

·      No. of Bedrooms (#Bd)

·      No. of Baths (#Bt)

·      Listing Date (LDt)

·      List Price (List$)

·      MLS # (MLS#)

·      Sub-Area (SA)

·      Sale Price (SPrice$)

·      Sale Date (SDt)

·      Status (PH=No Photo) (Status)

·      Status Change Date (StChgDt)

·      Age Number (Age)

·      DOM (DOM)

·      ADOM (ADOM)

·      Expirey Date (XDt)

·      Style of Dwelling (Style)

·      Area (SqFt.) (Area-SF)


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. 


In selecting data from Fusion, 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. 

To avoid downloading unnecessary data you may select only sold, withdrawn and expired date after a more recent date.  “01/01/2013” would be a good date if you are looking at doing your search in 2015 (since only the last two years are used).  However, be aware that if you place a date in the “expired date” field, the full results are not downloaded.  Thus, make sure you leave the expired data field empty.  We recommend that you make use of the “Status Change Date” and set that to “1/1/2013” for the best results.  The graphic below shows a search limited to that date for both closed and withdrawn properties. 

Once you’ve selected the search criteria, press the “Results” button to see the results as shown below.  Now you are ready to download the results.  To download the results, select the Tools Option button, then select the “Export Data” option as shown below. 

When you select the download option, the dialog shown below is displayed.  Select the “All Records” option and the “Comma Delimited” Data Export Format, and the “Focus 1st” Export Grid Format.  Also, be sure to “include column headers” as shown below.  Then press the  button. 

Next you will see the screen shown below.  Select the “Focus 1st” Export Grid Format (by using the drop down box) and check the “Include Column Headers” as shown below.  Then press the  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.

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

Once you have saved your exported file, you are ready to run the Focus 1st 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 http://www.focus1st.com and take a look at the tutorial section.