Exporting Data from CA, Los Angeles – CLAW

In selecting data from Matrix, 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 make sure that all Listings are selected by using drop down arrow on the left side of the window as shown below.  Once you have all Listings selected, select the “Export” button located at the top right of the window, as shown below. 

Once you select the “Export” button, you will see dialog box similar to that shown below.  You can now choose from several export formats to export your results.  For the CLAW MLS, using the exact same data you will need to export two (2) files using two different formats.  You will then be required to read in both of these files in the exact order as stated below. 

To export the first file, use the “System default *” file format.  You may want to name your file to represent the search that you did.  In the example below we have named the file based on the zip code.  We’ve also appended the number “-1” to the end of the file to make sure that we remember that this is the first exported file associated with this dataset (the “System default *” formatted file).   

Next to export the second file, use the “Appraisers” file format.  You may want to name use the same file name as you did previously when you exported your first file to represent the search that you did.  In the example below we have named the file based on the zip code.  We’ve also appended the number “-2” to the end of the file to make sure that we remember that this is the second exported file associated with this dataset (the “Appraisers” formatted file).   

 

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 files, you are ready to run the application.  When you run your application, you will be asked to read in your export file.  Read in the first file that you exported.  That is the file you exported using the “System Default *” file format.  Once you read in this file, you will be asked to read in the second file.  That file must be the file with the same dataset that was exported using the “Appraisers” file format.    

When you run the application you will need to point to the exported data files, so make sure that you’ve placed the files 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.