Exporting Data from OH, Firelands MLS - Rapattoni

If this is your first time exporting data, you must first setup an export format.  To see instructions on setting up an export format select this link…


In selecting data from Rapatoni, be sure to select the options below:

Make sure that all the status options are selected and select the starting date (note the staring date of 01/01/2010 assumes the current year is 2011 or 2012).  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. 

Once you’ve selected the search criteria, you may export the results immediately or press the  button to see the results as shown below.  To download the results, make sure you select all the data be checking the  box, and then select the  button as shown below. 

When you select the  button, the “Export Options’ dialog shown below is displayed.  Select the “Focus1st” option and then push the  button. 

Next you will see the screen shown below.  Data is being downloaded into a file for you. 

When the download has completed you will see a file link as shown below.  Select the link and you will be asked if you want to save the file.   

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 and location. 

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 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 the tutorials located at http://www.focus1st.com.

Using ‘Custom Export Setup’ 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 application to understand the format.  

Once you’ve logged into the Rapatoni system, use the  drop down button and select the ‘Custom Export Setup’ button as you see above.  Once you select the ‘Custom Export Setup’, the ‘Listing Information Export’ screen will be displayed. 

If you defined any previous export formats they will be shown.  To define your new export format, press the ‘Create Export’ button as shown above.  When you press this button, you will see the “Create Listing Information Export Layout” screen as shown below.

First place the name “Focus1st” as the “Name” as shown above.  Make sure that Excel is the File Format; select “Yes” for the “Include Field Names” option and select “No” for the “Include Pictures” option.  (Note: The value of the “Display Order” can be left alone or set to ‘1’).  Once you’ve provided the Name and selected the options above press the  button.  You will now see the ‘Revise Listing Information Export Layout’ screen as shown below.

Then you will need to select fields from the “Available Residential Fields” section and move them over to the “Selected Fields” section.  To pick the fields, select a field from the left table (shown as “Available Residential Fields” and press the  key.  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 add the “Selected Fields” table with the fields shown below:

·      Address

·      Address - City

·      Total Bathrooms

·      Bedrooms

·      Square Footage

·      List Price

·      Listing Date

·      Selling Date

·      Selling Price

·      Status Desc

·      DOM

·      Listing Number

·      Lot Size – Acres

·      Original Price

·      Style Desc

·      Subdivision Name

·      Year Built

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 your results.

To see how to export data now, select this link…