Home  | Login  | Registration  | Current Coverage  | Tutorials  | 1004MC Demo  | CSV Creation and Export Instruction for SAYOR MLS REQUIRED FIELDS IN CORRECT ORDER The following fields must be in your final CSV file and in the order indicated. STEP 1. Login into your MLS account and navigate to the "Admin" button and then to "Custom Export Setup" as indicated below. STEP 2. Click on the "Create Export" button. STEP 3. Name your Export Rule, and then select "Custom" from the only pull down box available. Match the settings below and make sure that the "Field Separator" is only a comma. (Setting should match the setup below.) STEP 4. Click on the "Save" button. STEP 5. Locate the required fields in the "Available Residential Fields" window, highlight them one at at time and "Add" them so that they appear in the "Selected Fields" window in the correct order. Make sure to include only the 18 fields that match the list above. STEP 6. Click on the "Save" button. Your Export is ready to use! The following is a demonstration of running a map search for another market area and MLS, but the research scenario is the same. STEP 1. Select your area. Any search is possible, but it must be for a period of 1 year. STEP 2. As stated above, research for all records for a period of one year from the effective date of the report. The effective date of this demo is "4/23/11" STEP 3. Click on the "Exports" button. STEP 4. Select the Export that you created from the pull down box and then click on the "Submit" button. STEP 5. Click on the file created by the MLS system. Save the .CSV file to your computer The file in the image "128944_RESI_58BF.csv". STEP 6. Login and Navigate to the SAYOR MLS Analytics Page. Launch a new browser to login and locateSAYOR MLS Analytics Page Browse for the .CSV file and click upload. Make sure that the effective date of the data matches your research parameters.