Matrix Search Guide

Table of Contents

How can I see listings for neighbor island properties? 

How do I find a Building Name?

How do I search for a Broker or Sunday Open?

How far back does the MLS Data go? 

How to Search for Pet-Friendly Units

Performing an MLS Open House Search by List Office ID in Matrix

Setting up Portal Notification Settings 

Speed Bar

Troubleshooting CSV File Import Issues when Exporting MLS Search Results

Videos

How to Create and Manage Custom Displays

How can I see listings for neighbor island properties?

Listings in Matrix include neighbor island properties entered by HICMLS members.

Listings marketed in the HICMLS by members of the neighbor island Boards are identified as "Reciprocal Listing" - this information is disclosed in the Agent Remarks.

When doing searches in Matrix, you can use the division number for that island:

1- Oahu
2- Maui
3- Big Island
4- Kauai

Listing Agent provides Listing data and not extracted from other MLS providers.

Contact information for other MLS in Hawaii:

Kauai and Big Island

Hawaii Information Services (aka HIS)

808-599-4224

alohaliving.com

Maui

Realtors Association of Maui (aka RAM)

808-873-8585

[e-mail]

Notes:

• All subscribers to an MLS in Hawaii (RAM, HIS, HiCentral) are part of a reciprocal agreement.

How do I find a Building Name?

Matrix will only return results for spelling that matches exactly what the system has. 

There can be more than one building, or it could be spelled differently in the MLS. 

** It is best to use the "Auto-Fill" feature to find a Building Name in Matrix. **

Use the following steps for best results:

1. Select "Auto-Fill."

2. In the "Building Name" search, type an asterisk (*) before AND after a keyword. This will tell Matrix to find any building with those letters combined anywhere in the name.

3. Click "Run Search" and "Fill" from the correct building. 

(back to top)

How do I search for a Broker or Sunday Open?

Follow the steps below:

1. Login to Matrix

2. Move your mouse over "Search"

3. Select "More..."

4. Scroll down until you see "Openhouse," then click "Quick"

5. Select "Broker," Or "Public," under Open House Type

6. Enter the other data you would like to search and press the results button at the bottom.

(back to top)

How far back does the MLS Data go?

This comprises multiple conversions from the various MLS systems that HBR has utilized in the past.

Our Matrix MLS data goes back to around 1992.

How to Search for Pet-Friendly Units

1. Go to Matrix > Search > Residential > Quick

2. At the bottom of the page, click "Add/Remove" next to "Additional Fields"

3. Under "Available Fields" highlight "Disclosures"

4. Click "Add ->" and it should appear under "Selected Fields"

5. Click "Back"

6. Highlight "Pet on Property" and/or "Pets Allowed (Verify)" from the Disclosures field

(back to top)

Performing an MLS Open House Search by List Office ID in Matrix

Step-by-Step Guide: 

1. Open Matrix and navigate to the "Search". You can ignore the drop-down options and just click "Search". 

2. Click on "Open House" and select "Quick" from the menu. 

3. Choose desired open house types or leave it blank. 

4.  If you have additional search criteria, such as location, price range, or property features, specify them in the fields provided on the search criteria page.

5. Enter the List Office ID in the designated field. For Example, enter "HBRS" in the List Office ID field to search for open houses listed by the Honolulu Board of Realtors. 

6. Click the "Results" button to execute the search. 

7. To return to the search page and modify criteria, click "Criteria"

Following these steps, you can quickly search for open houses linked to a specific office using the List Office ID feature in Matrix. This allows you to efficiently explore relevant open house listings and streamline your search process within the MLS system. 

(back to top)

Speed Bar

The Speed Bar is a multipurpose searching tool that will allow you to run a search from any screen in Matrix. 

There are two types of Speed Bar inputs:

• Speed Bar Shorthand: A series of simple codes you enter into the Speed Bar. Matrix translates your entries into search criteria and runs the corresponding search. 
• Speed Bar Shortcuts: Any search that you've saved as a speed bar shortcut. Enter its name in the Speed Bar and Matrix runs that saved search. 

Shorthand codes:

Status:

• a - Active
• es - In Escrow Showing
• en - In Escrow Not Showing
• s - Sold
• t - Temporarily Withdrawn
• w - Withdrawn
• x - Expired
• cs - Coming Soon

Property Type:

• sf - Single-Family
• cnd - Condo/Townhouse
• rnt - Rental
• Ind - Vacant Land
• mul - Multi-Family
• bus - Business
• com - Commerical

Speed Bar Shorthand Examples:

• Status: a for active; s for solds
• Listing Type: sf for Single Family, and for Condo
• Neighborhood: waikiki for the neighborhood of Waikiki
• Street Name: king for King Street
• Street Number and Name: 3058 King for 3058 King
• MLS Numbers: 202112345 21201235
• TMK Area: TMK 145 for TMK Area 145
• List Price (In Thousands): $500-550 or $500+ or $500-
• Bedrooms and Bathrooms: 4+ (beds) 3+ (baths) for 4 or more bedrooms and 3 or more bathrooms
• Open House: oh 08/08/2021 or oh 0 (0 means today)
• Agent Search: ag smith or ag less smith (last name or first name last name)

Combining Shorthand Codes

• a waikiki - Active listings in Waikiki
• a waikiki $800+ - Active listings in Waikiki at $800,000 or more
• a waikiki sd 0-7 $800+ - Active listings in Waikiki over the past 7 days at $800,000 or more
• a waikiki sd 01/01/2013-01/05/2013 $800+ - Active listings in Waikiki with a status date between the given date range at $800,000 or more

Shorthand Tips

• Keep it simple
• Case doesn't matter
• Combine your Shorthand codes in any order (except for bedrooms and bathrooms)
• Put spaces in between Shorthand codes, not commas
• Check the criteria on the results page to ensure it searched for what you are asked for

Setting up Portal Notification Settings

1. At the top right corner of Matrix, click the drop-down menu by your name.

2. Choose "Settings" 

3. Click on "Portal Notification Settings" 

4. Select the options for each status. Choose from "Notify me ASAP via Email," "Notify me ASAP via Text," or "Notify me via Daily Summary Email."

Note: To use the texting feature, enter your Mobile Phone Number and choose your Cellular Provider from the drop-down menu.  Matrix will send a 4 to 5-digit code to verify your mobile #.

5. When done, press the "Save" button at the bottom.

Troubleshooting CSV File Import Issues when Exporting MLS Search Results

When exporting MLS search results to a CSV file and attempting to open it in Excel, you may encounter formatting or data parsing issues. This knowledge-based article provides two possible fixes to help resolve these problems and ensure a successful import of CSV files into Excel.

Fix 1: Using Get and Transform
Excel's Get and Transform feature allows for better control and flexibility in handling CSV files. By following these steps, you can import and transform the CSV file:

1. Open a new Excel workbook.

2. Go to the "Data" tab and click on "Get Data" in the "Get & Transform Data" section.

3. Select "From Text/CSV" and locate the exported MLS CSV file.

4. In the "Text Import Wizard" window, choose the appropriate file origin and delimiter settings.

5. Preview and adjust the data columns if necessary.

6. Click "Load" to import the data into Excel with better control over the formatting and parsing.

Fix 2: Enabling Legacy Text Wizard
The Legacy Text Wizard is a feature in Excel that provides additional options for importing and formatting CSV files. By enabling this feature, you can overcome formatting issues during the import process. Follow these steps to enable the Legacy Text Wizard:

1. Open Excel and click on "File" in the top-left corner.

2. Go to "Options" and select "Advanced" from the left-hand menu.

3. Scroll down to the "General" section and check the box for "Show Legacy Data Import Wizard."

4. Click "OK" to save the changes.

 
Video Tutorial: To further assist you, our MLS Solutions Manager prepared a video tutorial that provides a detailed walkthrough of both methods mentioned above. The tutorial allows you to choose the approach that best suits your needs. You can access the video tutorial by clicking on the following link: Import Text CSV Excel Video Tutorial.

Conclusion: By following either the Get and Transform method or enabling the Legacy Text Wizard feature in Excel, you can overcome CSV file import issues when exporting MLS search results. We hope that this knowledge-based article has provided you with the necessary steps to import and handle CSV files in Excel successfully.

If you continue to experience any difficulties or have further questions, please don't hesitate to contact our support team for assistance.

(back to top)