IMPORTANT: As of April 10, 2018, MFRMLS updated their system so it no longer allows exporting of fields that tell Spark the number of beds, baths, and rent amount in individual units. Spark will still work with Multi-Family but it will not be able to load the number of beds, baths, and rent amount.
Below are the instructions you need for the one-time setup of your export file in MFRMLS.
If, for any reason, you have trouble with the file setup below or with the data going into Spark, contact us here for assistance.
Creating a Multi-Family Export for use in the MFRMLS Matrix 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 MFRMLS Matrix system. Contact us here if you have problems with the file setup and we'll be glad to help.
These are the instructions for the custom export setup for Multi-Family. Click here to switch back to the SFR/Condo/Manufactured setup.
Hover your mouse over 'My Matrix' and select 'Settings'.
Click on 'Custom Exports' then click on 'Add Export'.
Name the export 'Spark-Multi'.
- IMPORTANT: Verify toward the bottom that 'Label' and 'Comma' are chosen. No need to enter a description.
Click on each of the following categories individually and click 'Add' after each one. Once you are done, the categories will appear on the right side of the window. The list is long but once this is set up in your MLS you'll never have to do it again.
Attached Garage Y/N
Condo Fee Schedule
Green Energy Features
Green Energy Generation
Green Water Features
Heating and Fuel
HOA Payment Schedule
Legal Subdivision Name
Lot Size Square Footage
Original List Price
Pool Private Y/N
Price Change Timestamp
Seller Paid Buyer Costs
Special Sale Provision(s)
Status Change Timestamp
Total Monthly Rent
Total Units on Property
Water Frontage Y/N
Water View Y/N
Once the list is complete, click 'Save' and you are done.
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.
On the results page of your search choose the listings/sales/rentals you want included (using the check box to the left) or click 'All' if you want all of them.
Click 'Export' which is on the bottom row of buttons.
Verify the custom export you made is selected in the drop-down which should be 'Spark-Multi' then click 'Export'.
Save the file by whichever file name and into whichever folder you prefer (depending on browser settings you may not be given the option to choose the file name/location - if this happens that means your browser most likely saved the file into the 'Downloads' folder on your computer).
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).