Step-by-Step MLS Setup Instructions for the system
Wait!
The below instructions will walk you through setting up (a Stratus system) so that it will be able to "talk" to Spark. If you don't need help with the export setup and just want to know how to export data from your MLS then skip down to the "How to Export Your Properties" section below.
We are more than happy to complete these instructions for you so don't hesitate to contact us for help.
You can also click here to schedule a time for us to do this setup, walk you through using Spark, and completely customize Spark for you as well (or any combination of those).
Creating the Spark Custom Export in
NOTE: The below instructions will set up your MLS to work with Spark for
In this MLS there are no other setups needed for different property types.
Instructions for the MLS Export Setup
First, start a search by clicking on Search on the left.
On the next screen select all three of Residential, Condo/Coop/HOA, and Rental (this is the only time we'll do a search with all three selected).
Perform a search using any parameters just so we can get into the results of that search (doesn't matter what you search for).
Once you are in the results of a search, click on the Customize icon toward the top (same row as the one that shows the number of results).
Select Create New.
Click on the Add a Column drop-down to start adding fields. The fields you choose will start to populate the window. Following is a complete list of the exact fields you need to include. This list is long but once it is set up you will never have to do it again. IMPORTANT: ALL fields listed below are required. DO NOT ADD EXTRA FIELDS & DO NOT LEAVE ANY OUT.
# Families
# Fireplaces
# Floors In Building
# Floors In Unit
1st Floor
2nd Floor
3rd Floor
Address
Air Conditioning
Amenities
Approx Int Square Footage
Basement Description
Basement/Subfloor
Baths Full
Baths Half
Bedrooms
Block
Broker Remarks
Building Features
Class
Class Description
Concessions Paid By Seller
Contract Date
County
Days On Market
Detached/Attached
Development
District
Driveway
Exp Date
Exterior Features
Green Features
Heating
Heating Fuel
Heating Type
Included
Interior Features
Last Status Change
Listing Date
Listing Price
Location Description
Location Features
Lot
Lot Description
Lot Square Footage
ML #
Model Name
Mortgage Type
Num Assigned Parking Spaces
Num Cars Garage Parking
Num of Levels
Num of 1 Bedrooms
Num of 2 Bedrooms
Num of 3 Bedrooms
Num of 4 Bedrooms
Number of Parking Spaces
Original Price
Other Structures
Owner Financing
Parcel Id
Parking ***IMPORTANT: THERE ARE TWO - ONLY CHOOSE THE FIRST ONE
Parking Spaces
Pool Care
Pool Description
Price Change Input Date/Time
Public Remarks
Rented Date
Rented Price
REO
Rooms
School District Name OR School District # (**USE ONLY THE ONE YOU PREFER)
Section
Sewer Description
Sold Price
State
Style ***IMPORTANT: IF THERE ARE TWO - ONLY CHOOSE THE SECOND ONE
Taxes
Title Date
Town
Type of Dwelling
Type Ownership
Unit #
Unit on Floor #
View
Water Description
Water Frontage
Waterfront Features
Withdrawn / Release Date
Year Built
Zip
Once the list is complete, click Save.
Type in Spark to name the export and then click Save again. Now you're done with the one-time setup of creating the custom export for Spark!
How to Export Properties from
Verify that the search you are exporting includes the properties you want to load into Spark (and into your appraisal report).
On the results page of your search, click Download toward the top right.
Verify List Rows is selected and all properties that you want are included in the For: field.
On the Column Set drop-down select Spark.
Verify that Include column names as first row is checked and then click Download.
Once it says it's ready, click on Download again.
Save the file by whichever file name and into whichever folder you prefer (depending on your browser settings you may not be given the option to choose the file name/location and that's okay, it probably just went into your Downloads folder - you can contact us for help with changing your browser settings).
IMPORTANT FOR MULTI-FAMILY: Spark will work with multi-family forms, however, your MLS does not allow exporting of all of the necessary multi-family data. As a result, Spark will load in as much as it can but some fields will have no information. If and when your MLS provides data for the rest of the fields, we will update accordingly. NOTE: Be sure to choose a multi-family form in Spark!
Instructions for Condo Property Export Setup
Click on Admin and then on Custom Export Setup.
Click on Create Export.
Enter Spark Condo in the Name field.
Verify the following:
Excel is the File Format
Yes is checked for Include Field Names
No is selected for Include Pictures.
Click Save.
Click on ALL of the fields listed below in the left window of your MLS and click Add after each individual one. Once you are done, the fields will appear on the right side of the window. This list is long but once it is set up you will never have to do it again. IMPORTANT: ALL fields listed below are required. DO NOT ADD EXTRA FIELDS & DO NOT LEAVE ANY OUT.
Acres
Address - City
Address - State
Address - Unit
Now that the list is complete, click Save and you are done!
NOTE: If you want the instructions for property types other than Condos, then when you're ready, click here and change the drop-down to the property type you want instructions for.
How to Export Your Condo Properties from
Verify that the search you are exporting includes the properties you want to load into Spark (and into your appraisal report).
Once you are in the results of a search check the box toward the top to select all the results.
Then click the Exports button toward the top.
Select the Spark Condo option and then click Submit.
When the download is ready you will see a file link. Click the link to save the file.
Save the file by whichever file name and into whichever folder you prefer (depending on your browser settings you may not be given the option to choose the file name/location and that's okay, it probably just went into your Downloads folder - you can contact us for help with changing your browser settings).
Click on ALL of the fields listed below in the left window of your MLS and click Add after each individual one. Once you are done, the fields will appear on the right side of the window. This list is long but once it is set up you will never have to do it again. IMPORTANT: ALL fields listed below are required. DO NOT ADD EXTRA FIELDS & DO NOT LEAVE ANY OUT.
Acres
Address - City
Address - State
Address - Unit
Now that the list is complete, click Save and you are done!
NOTE: If you want the instructions for other property types other than Rentals, then when you're ready, click here and change the drop-down to the property type you want instructions for.
How to Export Your Rental Properties from
Verify that the search you are exporting includes the properties you want to load into Spark (and into your appraisal report).
Once you are in the results of a search check the box toward the top to select all the results.
Then click the Exports button toward the top.
Select the Spark Rental option and then click Submit.
When the download is ready you will see a file link. Click the link to save the file.
Save the file by whichever file name and into whichever folder you prefer (depending on your browser settings you may not be given the option to choose the file name/location and that's okay, it probably just went into your Downloads folder - you can contact us for help with changing your browser settings).
Instructions for Multi-Family Property Export Setup
Click on Admin and then on Custom Export Setup.
Click on Create Export.
Enter Spark Multifamily in the Name field.
Verify the following:
Excel is the File Format
Yes is checked for Include Field Names
No is selected for Include Pictures.
Click Save.
IMPORTANT: Click the tab at the top that says Multi Unit 2-4.
Click on ALL of the fields listed below in the left window of your MLS and click Add after each individual one. Once you are done, the fields will appear on the right side of the window. This list is long but once it is set up you will never have to do it again. IMPORTANT: ALL fields listed below are required. DO NOT ADD EXTRA FIELDS & DO NOT LEAVE ANY OUT.
# of Units
Acres
Now that the list is complete, click Save and you are done!
NOTE: If you want the instructions for other property types other than Multi-Family, then when you're ready, click here and change the drop-down to the property type you want instructions for.
How to Export Your Multi-Family Properties from
Verify that the search you are exporting includes the properties you want to load into Spark (and into your appraisal report).
Once you are in the results of a search check the box toward the top to select all the results.
Then click the Exports button toward the top.
Select the Spark Multifamily option and then click Submit.
When the download is ready you will see a file link. Click the link to save the file.
Save the file by whichever file name and into whichever folder you prefer (depending on your browser settings you may not be given the option to choose the file name/location and that's okay, it probably just went into your Downloads folder - you can contact us for help with changing your browser settings).
