Below are the instructions you need for the one-time setup of your export file in MetroList.
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 the Multi-Family Custom Export for use in the MetroList Rapattoni 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.
Follow the instructions below to complete the one-time setup for Spark in the MetroList Rapattoni MLS 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 Multi-Family export setup. Click here to see the instructions for the SFR/Condo setup in MetroList.
Click on 'Admin' and then on 'Custom Export Setup'.
Then click on 'Create Export'.
Enter 'Spark-Multi' in the 'Name' field.
Verify that 'Excel' is the 'File Format', 'Yes' is checked for 'Include Field Names' and 'No' is selected for 'Include Pictures'.
IMPORTANT: Click the tab at the top that says 'Residential Income'.
Click on each of the following categories in the left window ('Available Residential Income Fields') individually and click 'Add' after each one. Once you are done, the categories will appear on the right side of the window ('Selected Fields'). The list is long but this is a one-time setup that you won't have to do again. *Note: If there are two of the same field move both of them over to the right.
Address - City
Address - State
Address - Street Complete
Address - Unit
Address - Zip Code
Last Price Change Date
Lot Size - Sq Ft
Original Listing Price
Special Listing Cond
Unit 1 Apx Sq Ft
Unit 1 Bedrooms
Unit 1 Full Baths
Unit 1 Half Baths
Unit 1 Rent
Unit 2 Apx Sq Ft
Unit 2 Bedrooms
Unit 2 Full Baths
Unit 2 Half Baths
Unit 2 Rent
Unit 3 Apx Sq Ft
Unit 3 Bedrooms
Unit 3 Full Baths
Unit 3 Half Baths
Unit 3 Rent
Unit 4 Apx Sq Ft
Unit 4 Bedrooms
Unit 4 Full Baths
Unit 4 Half Baths
Unit 4 Rent
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.
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-Multi' option and then click 'Submit'.
When the download is ready you will see a file link. Click the link and save the file by whichever file name and into whichever folder you prefer.
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).