Below are the instructions you need for the one-time setup of your export file in SABOR.
If, for any reason, you have trouble with the file setup below or with the data going into Spark, contact us here for assistance.
One-Time Custom Export Setup for use in SABOR Connect system
MLS export files that are uploaded to Spark must be in a specific format in order to provide both accurate data and all possible fields.
You can either watch the above video or follow the instructions below to complete the one-time setup for Spark in the SABOR Connect MLS system. Contact us here if you have problems with the file setup and we'll be glad to help.
Once in the Connect MLS system, hover over Reports and click on 'Custom Reports'.
Then you'll click 'Add New Report'.
Verify that for 'Class' you select the type of search you are setting this export up for. You will want to create one for each different type of search you do (e.g. Single Residential, Condo, Residential Rental, and Multi-Family). You will repeat this process for each different search type.
In the 'Report Name' box type 'Spark SFR' (or Spark Condo, or Spark Rental, or Spark Multi-Family or whatever you want to call this export).
In the lower left column of fields left-click the very top field.
Then scroll down to the bottom of that list.
Hold down the 'Shift' key on your keyboard and then left-click the very bottom field. This will select every field in the entire list.
Release the 'Shift' key.
Click the right arrow button that is between the two lists (has this symbol on it '->'). This will move all of those fields from the left column to the right column.
**IMPORTANT: Now click the ‘Names’ field up at the top and then select the checkbox at the very top of the list titled ‘Long Name’.
Click the 'Save' button at the bottom.
Be sure and do this process for changing the 'Property Type' field at the top for each different type of search you typically use (e.g. attached, detached, two to four unit, etc).
How to Export your Data
Verify that the search you are exporting includes the sales/listings/rentals you want to put into the grid(s) of your appraisal report.
Once you are in the results screen of your search click the 'Export' button which is a picture of a folder with a down arrow on it.
Verify that the listings you want to import are selected and verify that the 'All selected listings' is chosen then click 'Next' (or 'All Listings' if you want to import all of them).
Click the drop-down box on the 'All fields in this report' line and choose 'Spark' (or whatever you named the export you set up above) then click 'Next'.
In the 'File format' verify that 'Tab-delimited text' is chosen then click 'Continue'.
Save the file as whatever name and to whatever folder you prefer (depending on browser settings you may not be given the option to choose the name and location). Do not open or view the file at this time.
Now load Spark by going to app.sparkforappraisers.com and follow the steps.
Note: Spark can input a maximum of 30 properties for each grid (sales grid/listing grid/rental grid) and a maximum of 10,000 for your 1004MC files (Competing and/or Neighborhood File).