(TMK) Training Videos – Vimeo Links

(TMK) Training Videos – Vimeo Links

In case you are unable to view the training on Youtube, hopefully Vimeo works better.   TMK Essentials (Part 1) The Basics 18 Minutes     TMK Essentials (Part 2) Searching 19 minutes       TMK Essentials (Part 3) Search results 23 Minutes       TMK Essentials (Part 4) Create a CMA 8 Minutes       TMK Essentials (Part 5) Downloading Spreadsheets / Custom Formats 13 Minutes       TMK Essentials (Part 6) Mapping 19 Minutes
(mls) Copy and Pasting data from REsearch to other applications

(mls) Copy and Pasting data from REsearch to other applications

How to use the Copy action button.   View the data you would like to copy. Ex: Search results, MLS Mid report, Market Statistics, etc.   Locate the Copy button toward the bottom center of your report   Choose your preference of Page/Checked/Not Checked   A new tab will open within your browser.   Within this “clean” tab you will Select All then Copy the data to your computer’s clip board.   Open your application that you would like to paste the data into. Ex: Outlook, Word, Email such as gmail, aol, hotmail, etc.   Place your cursor where you … Continued
(MLS/TMK) Searching by owner’s Zip code

(MLS/TMK) Searching by owner’s Zip code

First we must clarify the request. Searching by the properties’ Zip code vs. Searching by the owner’s taxbill Zip code   Searching by the properties’ Zip code: On the search page scroll into the TMK Detail section. Keep scrolling until you see the Address section Here you will find the Zip code search field Enter the target zip code Enter any other parameters or Search Now       Searching by the owner’s taxbill Zip code: Click Add Fields Scroll through the alphabetical list, locate Taxbill Zip Code Enter your target zip code Click Close Enter any other parameters or … Continued
(MLS) Welcome New Agent – HIS contact information

(MLS) Welcome New Agent – HIS contact information

Please click to the next guide: (MLS) Welcome New Agent – Initial login Aloha, and welcome to Hawaii Information Service (HIS) and REsearch, your new MLS system! Important websites: Hawaiiinformation.com – This is where you will access REsearch. Alohaliving.com – This is our public facing site where everyone (your clients) can view Active and Contingent listings. Phone information for HIS: Toll Free: 1-800-628-3121 (Neighbor islands only) Direct: 599-4224 (Oahu) Extension List: 1 – Tech/Cust Support 2 – Membership 3 – Accounting 4 – Sales 5 – IDX, RETS, VOW 6 – TMK data discrepancies Toll Free Fax: 1-888-628-3121 (Neighbor islands only) Direct … Continued
Excel – Downloaded street numbers are displaying as dates

Excel – Downloaded street numbers are displaying as dates

*We are currently working on a fix on our back end that will hopefully resolve this issue.   This is an issue with Excel, not our data. Excel is automatically converting certain street numbers and displaying them as dates. Ex: 11-2598 = NOV-98 This is also an issue when manually entering in the data directly into Excel. For data that has been directly downloaded from REsearch, here is a formula you may use to convert the cell back to the numbers you are looking for: =text(a1,”mm-yyyy”) Ex:   It is a little bit of a process, hopefully our proposed fix … Continued
(mls) Training Video – zipForms, Roster Download & Downloading

(mls) Training Video – zipForms, Roster Download & Downloading

Webinar 12/22/2016 Trainer: John Friedman This webinar will be covering the new REsearch 6 system and will cover zipForms, a third-party application used to manage the Hawaii Association of Realtors (HAR) forms, as well as how to work with the REsearch 6 roster, which includes the names and company affiliations of every HIS member. NOTE: You must be a member of a local board such as HIR, KBR or WHAR in order to access HAR forms in zipForms.
(mls) Training Video – Farming & Labels

(mls) Training Video – Farming & Labels

        Instructor Andrea Peace recorded Aug. 8, 2016. Learn how to use the extensive public records data in REsearch to farm specific territories, create mailing labels for direct marketing, and prepare spreadsheets for additional marketing tasks.
(MLS) Alohaliving.com/rentals – Initial login or Forgot password

(MLS) Alohaliving.com/rentals – Initial login or Forgot password

Click here to watch our video walkthrough   If you have MLS access within REsearch, you already have an active account within our rental system. You just need to activate it.   Head over to: Alohaliving.com/rentals Locate and hover over “Login”     From the Login drop down, select “Login to an existing account”     Click on the “Forgot your password?” link     Enter your REsearch user name and click “RESET PASSWORD”     The reset process will be sent to your email address associated with your REsearch account. You will now be able to enter rental listings!   … Continued
(MLS/TMK) Using the PDF function

(MLS/TMK) Using the PDF function

While viewing the data you would like to PDF, look for the PDF button located toward the bottom of the page. My example is going to PDF a TMK Full report generated by clicking on a taxkey. You may PDF reports, search results, basket, etc.     Make your selection of Page, Checked, Not Checked or Customer Format         Depending on your browser, these next steps will vary: Your browser will either open the document within the browser itself or download the file to your local computer.   Chrome might open the PDF document within Chrome itself. … Continued
Downloaded Excel spreadsheets do not open as expected

Downloaded Excel spreadsheets do not open as expected

We have recently been receiving reports that spreadsheets downloaded from REsearch are not opening properly on some user’s computers. If you are experiencing an issue similar to this screen shot, please follow the directions below: Please follow this guide to disable the Protected View which seems to be the culprit. Please click here to view a demonstration video   1. File 2. Options 3. Trust Center 4. Trust Center Options 5. Protected View 6. Uncheck “Enable Protected View for files originating from the Internet” Done. please try opening the file again.       If the spreadsheet does open as … Continued
Kauai Workshop

Kauai Workshop

Aloha KBR Members!   Zipforms MLS Connect: Locating and using the MLS Connect feature within Zipforms –   Create a new or edit an existing transaction Click on the Property Tab Click on the zipFomr/MLS-Connect button Enter the subject MLS number Click Find – Verify the information Click Import         Cloud CMA – Link to our Cloud CMA guide Link to our Cloud CMA – Buyer Tour guide (this is what was covered in the presentation)       Using a blank listing form to assist with searching –    Listing Menu ➧ Listing Form ➧ PDF – … Continued
(MLS) Agent Prospect Notification Schedule TOO MANY EMAILS!

(MLS) Agent Prospect Notification Schedule TOO MANY EMAILS!

If you feel you are now receiving too many emails from the REsearch’s prospecting tool, there are a couple of things we can look at.     If the matches for a particular prospect are at a high volume, you may want to consider narrowing down that prospect’s search. Ex: There are a couple of agents within REsearch who have prospects that are being sent every Residential listing that is released, regardless of island, price, etc. This was likely created in error but the system does not know that and is sending an email to both that prospect and the … Continued
(mls) Virtual Open House Guide

(mls) Virtual Open House Guide

What is a Virtual Open house? HIS defines a Virtual Open House as a Scheduled, Live, Agent-led presentation over various applications on the internet. What is the difference between a Virtual Open House and a Virtual Tour? Virtual Tours are on-demand, unbranded, unattended presentations. Virtual Open Houses are scheduled, agent-led, with no restrictions on branding. What is the difference between an Open House and a Virtual Open House? Open houses traditionally allow the public physical access to the subject property. Virtual Open Houses do not allow the public to physically be at the subject property. How do I host a … Continued
Facebook, Social Media – Sharing listings (alohaliving.com)

Facebook, Social Media – Sharing listings (alohaliving.com)

Sharing listings to social media sites can be done from our Alohaliving public website. Here is a quick walkthough: Open up alohaliving.com Locate the MLS number search – enter your listing number and run the search Click on the listing to view it Copy the URL of the listing Paste the URL into your Facebook post        
(MLS) How to enter a listing using Classic Forms

(MLS) How to enter a listing using Classic Forms

Classic Vs. Wizard Classic Forms will simply display the listing entry form. You will choose between saving the listing to your HOLD status or Preview/Release to Active when finished. Wizard Forms include steps; Listing entry, Next step Photos, Next step Addenda, Tours, Next step Save / Release. The “Classic” method of entering a new listing: On the Main Menu, expand the Listings category Select New Listing On the Main Page choose between Classic Forms All Fields or Required Fields.   Enter the subject Taxkey, Create New Listing   Fill out your listing information Click Save to create a listing in … Continued
HIR New Member Training (3/10/2017)

HIR New Member Training (3/10/2017)

Aloha! – Here are the topics we hopefully covered during the training session: Dashboard – Setting up your filters, showing exactly what you would like to see. Filters can be set on each of the Dashboard tabs Links to further help guides: Filtering — Customization Subdivision List – a list of subdivision names with corresponding taxkeys Expand the Market category Click Subdivisions List you may also include Parcel Details for more detailed information       Search for Listings Link to our Searching with Taxkeys help guide Link to searching with multiple “find” fields help guide (Street name, Subdivisions, Projects names, etc.) Link … Continued
(mls) Listing Status guide

(mls) Listing Status guide

This information has been taken directly from the Rules and Regulations, Article II Definitions and Usage “Status” means the listing’s status with regard to pending escrow or purchase agreement, availability for showing, and expiration of the listing record on the service’s system. The following statuses have the meanings given to them here:     A/Active The property is available for immediate showing, and there is no pending escrow or purchase agreement. The listing will automatically expire according to the expiration date in the system. T/Temporarily Withdrawn There is no pending escrow or purchase agreement on the property, but the property is … Continued
Flood Zones – Flood Hazard Assessment tool (FHAT)

Flood Zones – Flood Hazard Assessment tool (FHAT)

There are a few tools you can use to obtain Flood Zone data.   Here is a link to the National Flood Insurance Program: http://gis.hawaiinfip.org/fhat/ (this is likely the go-to resource)   We have also placed a link out to the FHAT website directly on the listing form for your convenience. A new window will open to the FHAT site.                 REsearch’s maps include a Flood Zone layer in order to obtain flood zone information:     The TMK Full / DPP section also includes Flood Zone information for Oahu properties:
Contacts – Printing / Exporting / Downloading from REsearch

Contacts – Printing / Exporting / Downloading from REsearch

REsearch has the ability to generate spreadsheets and CSV files from most of the data in the system. This includes all contacts you may have entered.   Step 1. Locating Search My Contacts Expand the Search category, Select Search My Contacts   Step 2. Entering the search parameters You may enter specific search parameters into the search fields or In order to search ALL your contacts please use the wildcard in one of the name fields.     *At this point you may simply run the search and view the search results. You may then print, email, etc.   Step … Continued
New Prospect – creating a new contact and prospect search

New Prospect – creating a new contact and prospect search

In order to create a new Prospect you will first need to create a new Contact. On the Contact Details section fill out as much information as needed. The most important fields are First and Last Name and Email address. You will not be able to create a Prospect Search without an Email address. Click Save Contact when finished. When the page refreshes, you are ready to enter in your prospect search. Click here for more instructions: Turning a contact into a prospect
Renewing a prospect – renewing the expiration date of a prospect search

Renewing a prospect – renewing the expiration date of a prospect search

REsearch 6 makes is really easy to renew a prospect search. Initially and after renewal, a prospect search will stay active for 180 days. A prospect search needs to be renewed before the 181st day or it will be removed as inactive. Reminder emails are sent to the agent’s email address at set intervals. After the first 145 days an initial reminder email is sent. At 170 days the final reminder is sent. Finally once the 180 days are up a prospect removal notification is sent. You may renew a prospect search at any time, unlike REsearch 5.1.
(mls) Photos – Deleting a broken photo

(mls) Photos – Deleting a broken photo

Here is the step by step process on deleting and re-uploading images within REsearch 6.0. Deleting the broken image Step 1. Expand the Listings category and select Manage Photos Step 2. Enter in the MLS number Step 3. Read the agreement text and check mark I Agree (if you approve). Click Continue when ready.      Step 4. Locate the file to be removed. Remove all images that do not display properly in this preview section. Click the Delete button. Step 5. Click the Save All button to save the changes you made.     Once the file is removed … Continued
(MLS) Listing Status – Preview (bullet points)

(MLS) Listing Status – Preview (bullet points)

REsearch 6 includes a new listing status: Preview Here is a link to the bulletin that was initially sent out giving an overview of what a Preview listing is: https://hawaiiinformation.wordpress.com/2015/09/30/new-preview-listing-status-in-research-6/   Definition of P/Preview: There is a valid listing contract between the seller and the listing broker, and there is no pending escrow or purchase agreement. The property is not yet ready for marketing to the public. The property may not be available for showing.   The bullet points: Will be viewable and searchable by other participants of the MLS Will display in the Dashboard Listing Activity   Will not … Continued
Summary format – Adding a Highest, Lowest, Average, Median, Mode report to your search results

Summary format – Adding a Highest, Lowest, Average, Median, Mode report to your search results

The Summary format can be added to your search results. When used the Summary format will be appended to the bottom of the search results page. It will provide you with a report of all prices. Example Summary of Sold listings: # = Number of listings being summarized Median = The halfway/middle number. Not a calculated overall average. If the amount of values being calculated are even, the median is generated by taking the average of the two middle values. Mode = The most often repeated value. (SP to LP = Sales Price to List price)   Add the Summary … Continued
Cloud CMA – creating a Cloud CMA report from search results

Cloud CMA – creating a Cloud CMA report from search results

Run a search within REsearch and view your search results. Click on the More button   In order to create a report with all search results select Cloud CMA – Page.   A new window opens to cloudcma.com All MLS numbers are auto populated in the “exactly what you want” box     You may also place check marks on listings in order to be selective on the search results.
(MLS) Default Format – saving My Default Format

(MLS) Default Format – saving My Default Format

1. Within Search for Listings open the Format drop down 2. Make your selections on the format/formats you would like to be used by default. (you will likely not be using the same check marks as my example. This is just showing that you can place as many check marks as you wish)     2a. [optional] You may also change your PER PAGE and other options. (please note, the higher the per page is set the longer the results will take to display. This is especially noticeable when using the Full formats and/or multiple formats are selected)   4. … Continued
(MLS) How to release a listing to Active or Preview status

(MLS) How to release a listing to Active or Preview status

Listings can be created and directly released to Preview or Active (or saved to Hold). Hold listings can be released to Preview or Active Preview listings may be released to Active It is not possible to go backwards, Active listing may not go back to Preview or Hold. Preview listings may not go back to Hold.   Step 1a – Proceed to create a new listing and fill out the listing form as you normally would. Step 1b – If a listing already exists and is on Hold, click on Release Listing   1b You may either use Update Listing or … Continued
Print, Copy, E-mail, PDF; Action buttons Page/Checked/Not Checked – 6.0 Vs 5.1

Print, Copy, E-mail, PDF; Action buttons Page/Checked/Not Checked – 6.0 Vs 5.1

The process and options when using the Action buttons in REsearch 6 is very similar to REsearch 5.1 Users are still presented with the choice of working with the entire page or with only their selected results. The difference is the individual buttons have been moved out of the single Action Menu.
Bathrooms – decoding MLS one liner’s details

Bathrooms – decoding MLS one liner’s details

When viewing the MLS one line of data the type and count of the Bathrooms have been condensed to help fit more data on the single line. We could not go with the assumed .5 or .25 for half and quarter baths as this would cause problems when there are more than one.   Our example listing is as follows: This translates to:     When quickly looking at our MLS one line example we know this listing’s details are: 100 interior sqft 5 Bedrooms 7 Full or 3/4 Baths 3 Half or Quarter Baths   If you are logged … Continued
(MLS) Virtual Tours – Attaching new / updating / deleting

(MLS) Virtual Tours – Attaching new / updating / deleting

Here are the steps to take within REsearch once you have the a link to your virtual tour   1. In the Main Menu click on Listings or expand Listings and click on Listings Menu       2. Within the Listings Menu locate the Manage Photos & More category Click on Tours     3. Enter your MLS number or click Select Listing and then select your MLS number Click Continue   4. Review the entry page. Click on I Agree after reading the tour agreement Type in or paste your tour URL Click Update when finished     … Continued
How to I find out average Days on Market in REsearch?

How to I find out average Days on Market in REsearch?

The short answer: use the Summary format. Link to our Summary format guide Agents my use the method below to have REsearch automatically calculate various formulas on search results. 1. Within the format drop down please use MLS and Summary formats 2. Enter your search parameters. Our example will be looking for Active, Residential, on Kauai (4-5-4-5) 3. Run the search and scroll to the bottom of the search results. The summary format will be placed at the end of the search results. The Summary format can be used with all statuses If running a search of Sold listings the … Continued
Prospect search expiration – 180 days

Prospect search expiration – 180 days

Your prospect searches need to be renewed once within every 180 days. HIS will send auto reminder emails to your agent email address at designated days that include easy one click renewal links. Reminders are sent on: day 145 – The following prospect(s) has been in the system for 145 days. They will automatically be dropped from the system in 35 days unless you renew it by clicking on the link(s) provided or updating the prospect’s search in REsearch. day 170 – The following prospect(s) has been in the system for 170 days. They will automatically be dropped from the system in … Continued
(MLS) How to copy / relist a listing – New MLS number (DOM reset)

(MLS) How to copy / relist a listing – New MLS number (DOM reset)

In situations where you would like to relist a property and would like to copy the Exhibit A from a previous listing, please use the Copy function. Examples of when Copy listing may be useful: – You are relisting an expired or withdrawn listing. – You are in the process of getting a DOM reset (more info on a DOM reset). Step 1. Locate and have your previous MLS number handy. Step 2. Enter the Listings Menu. In the main menu either click directly on Listings or expand the section and click on Listings Menu. Step 3. Within the Listings … Continued
MLS Quick / MLS Book – usage, printing, etc.

MLS Quick / MLS Book – usage, printing, etc.

MLS Quick – Four per page and MLS Book – Two per page These formats are designed to fit on a standard letter sized printout while in Customer Format. Before you print, simply select Customer Format. Please do not mix the MLS Quick or Book format with other formats. The system will allow mixing but the printing cannot follow the intended format when used with other formats.
(MLS) Deleting unwanted listings

(MLS) Deleting unwanted listings

Please note, only your listings that are still in HOLD status are eligible for deletion. Once a listings goes into Active or Preview, they are only allowed to be withdrawn. Deleting a listing will completely remove it from the system. You will no longer be able to search for and view any part of the listing. How to delete a listing: From the Main Menu click directly on Listings or expand the section and click on Listings Menu.   2. Within the Listings Menu, locate and click on Delete   3. Enter the MLS number or click Select Listing to see … Continued
Seller would like to withhold a listing from the MLS

Seller would like to withhold a listing from the MLS

In cases where you seller would like to withhold the listing from the system, we do need a form filled out and sent back for our files. Here is a link to our Certificate to withhold from MLS form (PDF) Please fill out the form and send it back to us. Fax: Direct Oahu: 536-6499 Outer Island: 1-888-628-3121 Email: membership@hiinfo.com support@hiinfo.com Mail: Hawaii Information Service 680 Iwilei Road #670 Honolulu, HI 96817.
(MLS) How to change my email address, phone number, contact information

(MLS) How to change my email address, phone number, contact information

Agents are able to change their profile information within My Profile. Expand the REtools section Click on Update my Profile 3. Within the My Profile page, make any updates to your information. 4. Make sure you save your changes In order to change the phone number seen on listings please also select the correct preferred phone number
(MLS) My listing expired, how do I change the status back to active?

(MLS) My listing expired, how do I change the status back to active?

When a listing expires the process to get it back to active is to do a Back on Market. On the main menu click directly on Listings or expand the section and click on Listings Menu Within the Listings Menu locate and click on Back on Market   Use the Find tool or enter the expired MLS number. Click continue when ready.   Enter the new expiration date and click Update when ready. Success! This process keeps the original MLS number and will continue the Days on Market for the listing If the goal is to reset the Days on … Continued
Viewing my Prospects’ auto email history

Viewing my Prospects’ auto email history

REsearch keeps a history of emails sent to any prospects you have entered into the system. In order to view historic emails please follow this guide. Click on Contacts Locate the Prospect you would like to work on. Click on their name. In the main section click to the History Tab Click on the Subject line of the message you would like to view. You can now review what has been sent. You may also click the Resend button to resend the message.
(TMK) Guide collection

(TMK) Guide collection

*under construction* Browser Configuration Best Browser Configuration – Trouble shooting issues on your computer   Terms, Abbreviations, definitions Tenure – Type of Ownership held by the current owner TMK Sale Instrument Codes – Deed, Lease, Sub-Lease, etc. PITT Codes – Tax classification Building Zoning Codes – Allowed use DPP Zoning – CZC/LUO explained Building Details, LLLA – Lower Level Living Area   Understanding Search Results Formats – The difference between the TMK Format choices Where does the data come from? Property Basics – Property basics sections broken down Sales – BOC documents Building Details – Bldg Full format, Sketch, Additions, etc. Loans – obtained from … Continued
(TMK) Create a CMA

(TMK) Create a CMA

1. From the Main Menu select Create a CMA   2. A. Enter in your subject property’s taxkey. B. Enter your desired date range C. Enter in the Personalized information   3. Click Search Now to see your results. Example CMA report:   4. Feel free to add other search parameters to narrow down the search such as beds, bath, etc.   Tips:  – Personalize is not required and can be left blank. – When entering in your subject taxkey please note the auto filled information box. If you are using a residential property the system will automatically take the … Continued
(MLS/TMK) Customize the search page – search fields

(MLS/TMK) Customize the search page – search fields

  REsearch allows you to choose which search fields are displayed when using the search. Feel free to move, add, and remove any field you desire. This is the main button you will be looking for:   +Video+ Customizing your search fields (the basics):     +Video+ How to reset your search page, roll back any changes +Video+ Customizing your search categories     **Please click the Show/Hide Field Groups drop down in order to view which color corresponds to which type of search field you will be adding. Knowing which type of search field you are adding is very … Continued
Customizing the search page – Field group categories (color decoding)

Customizing the search page – Field group categories (color decoding)

When customizing your search screen you will notice each field has been color coded. You my view the key for these colors by clicking the Show/Hide Field Groups drop down. You may remove check marks in order to hide entire groups to make locating fields easier.     Pink, Orange and Gray represent MLS data   Everything else is TMK (public record) data It is important to know which type of search field you are using in order to get the expected results. It is especially important when searching for TMK data. For example: When “accidentally” using an MLS field … Continued
(TMK) TMK Essentials – Training videos and links

(TMK) TMK Essentials – Training videos and links

Welcome to TMK Essentials Within this page you will find links to videos we have created as well as links to specific guides. The section headers are links to the videos. Links within each section will open the specific guides. You may also click on the time stamps next to various sections to jump to that part of the video Comments on the Youtube videos have been disabled. Please feel free to leave comments at the bottom of this guide. Click here for the full playlist If you are experiencing issues viewing the videos on Youtube, we have also uploaded … Continued
Settings – Map Layout

Settings – Map Layout

Within settings you do have the ability to place the map in one of four quadrants:   Locate Settings in the Main Menu and click on it     Within the Settings menu locate and select Map Layout     The Map Layout selection will show. Simply click on your preferred layout and click Save Changes when finished.
(MLS/TMK) Customize REsearch Email – Create/Edit my email signature

(MLS/TMK) Customize REsearch Email – Create/Edit my email signature

When sending emails from REsearch you do have the ability of creating an automatic signature as well as a couple of other options.   The Customize REsearch Email tool is located within Settings. At the bottom of the Main Menu locate and click on Settings. Within the Settings Menu click on Customize REsearch Email.     3. Click the Edit button on the particular section you would like to work on.   4. Enter/Edit your information, feel free to stylize using the tools provided. Use the hover help to identify each tool’s purpose. A = Insert Agent Head Shot we … Continued
(TMK) Why is the owner information missing? – Customer Format

(TMK) Why is the owner information missing? – Customer Format

A common issue we come across on shared accounts is “missing owner information.” REsearch includes the ability to hide owner information and sales data. Customer Format, when selected, hides owner information and sales data. Customer Format is located in two locations.   Search Results: When viewing search results click on any action button. Within the button’s bubble, customer format can be checked / unchecked     Options (Before running the search): Click the Format drop down Within the Format window, click to the Options tab Select / Unselect Customer Format       If you have just logged on and … Continued