Exporting Data from NTRESIS – Dallas, TX

Using the ‘Custom Search Report’ 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 define the export format, use the “Custom Search/Report” menu as shown above.  Select the Residential option.  Once you’ve selected the ‘Residential’ option, you will see a dialog box as shown below

Select the ‘Custom Report’ button to define the export format.  Once you select this button you will see a dialog box as show below.

First place the name “Focus 1st” as the “Report Name” as shown above.  Then you will need to define the fields to be in the new Report.  To define the fields, select a field from the left table (shown as “Available Fields”).  When you press the field 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 create the column report as shown above.  The item should be listed in the following order:

 

·         Status

·         MLS Number

·         # Bedrooms

·         Total Baths

·         City

·         Days On Market

·         Expire Date

·         List Price

·         Listing Date

·         MLS #

·         Off Market Date

·         Sales Price

·         Sold Date

·         SqFt

·         Street Direction

·         Street Name

·         Street type

·         Street/Box Number

·         Street Suffix

·         Subdivision

·         Year Built

·         Zip code

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

NTRESIS

In selecting data from NTRESIS be sure to select the two options below:

Make sure that all the status options are selected.  Then place a more recent data in the “Status Date” entry field.  The data “01/01/2007” is a good date for 2008 (since only the last two years are used.   These options 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 or neighborhoods is a good starting point. 

Once you’ve selected the search criteria, you may download your results. 

You may also decide to view your search results first of you’d like.  If you do view your search results first, be aware there may be a limit on the number that are shown (99 entries) and that you may not see all the entries. 

To download your results press the  button, located on the left in the “MY SIDEBAR” area.  Once you press the  button, you will see the download screen as shown below. 

Select the “Focus1st” download format you’ve defined and press the  button.   Once the download starts, you will be asked if you want to save the file.  Select the ‘Save’ option and then select a filename. 

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 Neighborhood Buying Patterns 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 Neighborhood Buying Pattern application, be sure to see the Neighborhood Buying Pattern manual (installed on your desktop when you installed the application)