Exporting Data from Virtual Office – Denver, CO

Using the List Manager to setup the List Format

Before you can export data, you must first setup the List 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.

Press the List Manager graphic (as show above) to access the List Manager. Once you’ve pressed the graphic you will see a dialog box as shown below.

To start, press the “Restore Defaults” link to setup the List Format needed. When you press this link, you will many of the items shown above displayed. Continue to add items from the left table to the right table by using the and the keys.

Do this for each of the options as shown in the graphic above.

Note: Be sure that you create the column report exactly as shown below. Start your selection by using the “Restore to Default” button.

Tag

Ref

MLS No

Address

City

Area

BR

BA

SqFt

Price

St

Ty

Sub Area

Off Market Date

Orig List Date

List Price

Sold Date

TOTAL DOM

NET PRICE

Finish SQFT Tot

TOTAL Square

Year

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.

Virtual Office MLS

In selecting data from the Virtual Office MLS, be sure to select all the possible ‘Status” options. This 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 data after a more recent date. “01/01/2007” would be a good date if you are looking doing your search in 2008 (since only the last two years are used).

Once you’ve selected the search criteria, and are in the List View you are ready to download the results. To download the results, select the ‘Export to PDA’ button (located at the top of the window) as shown below.

When you select the download button, the dialog shown below is displayed. You will be asked if you would like to include remarks. Remarks are not needed so press the “No” button (Note including the remarks is fine, but increases the file size).

The download will now start. Once the download starts, you will be asked if to name the export file that is being created. Select a name that will help you remember the data you saved. Choose filename and then press the “Save” button.

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 the dialog box similar to what you see below.

Now that 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).