- Status Closed
- Percent Complete
- Task Type IMPORTANT
- Category RMLS
-
Assigned To
Jean Harris (jean)
- Operating System All
- Severity High
- Priority Immediate
- Reported Version 1.5
- Due in Version Undecided
- Due Date Undecided
- Votes 0
- Private No
Attached to Project: Programming
Opened by Jean Harris (jean) - 2014-04-30
Last edited by Jean Harris (jean) - 2014-10-31
Opened by Jean Harris (jean) - 2014-04-30
Last edited by Jean Harris (jean) - 2014-10-31
FS#57 - 2. Realtor.com data feed & rmls-update.cgi
This has the highest priority.
Our existing data feeds have URLs that point to listings on USA-mls.com, for the Realtor.com feed, I would like the URLS for the listings and website to point to RMLS.
Our existing data feeds have URLs that point to listings on USA-mls.com, for the Realtor.com feed, I would like the URLS for the listings and website to point to RMLS.
Wednesday, 30 April 2014, 21:47 GMT
1. Office ID - Missing
2. Office Phone number - Missing
3. Office Name – I see “Property Management company Name” but I don’t think this would be the brokers name? Please confirm.
4. Agent Identifier – typically we received a numeric or alpha “ID” in the data to make an agent “active” in our system.
5. Full and Half Bath info if possible. We can work with a “Total Bath” field though (I do see this in the data) but Full and Half bath info preferred.
6. School info – such as Elementary, Middle and High School fields.
7. Total Floors (1 story, 2 story etc.)
8. Other important features do not appear to be in the data such as: Pool, Fireplace, Air Conditioning, Attic, RV/Boat Parking, Basement, etc. These are all searchable criteria that consumers can search for. If the listings from your feed do not have this info, the listings would not come up in their specified search.
The only required fields are items 1-4. We cannot move forward without this info. Please let me know if they can be added and if you could also let me know if you’d be able to have items 5-8 added as well.
Wednesday, 30 April 2014, 21:52 GMT
<properties>
- <property>
- <location>
<display-address>yes</display-address>
<longitude />
<latitude />
<city-name>Harrisville</city-name>
<geocode-type>approximate</geocode-type>
<county>Alcona County</county>
<zipcode>48740</zipcode>
<street-address>2074 Spruce Trailways Rd</street-address>
<state-code>MI</state-code>
</location>
<status>for sale</status>
<listing-type>resale</listing-type>
- <property-manager>
- <property-management-company-name>
- <![CDATA[ Home Hunter Realty
]]>
</property-management-company-name>
</property-manager>
- <details>
<living-area-square-feet>1500</living-area-square-feet>
<provider-listingid>9937342</provider-listingid>
<property-type>single-family home</property-type>
<num-bathrooms>1</num-bathrooms>
<num-bedrooms>2</num-bedrooms>
<year-built>1968</year-built>
<price>289000.00</price>
- <description>
- <![CDATA[ Situated on 100' of sugar sand beach is this truly custom brick ranch home. Highlighted by beamed wood ceilings in the living room, family room, and large dining area, plus extra large picture windows to better View Lake Huron. The oversized garage and 12x12 shed afford loads of room for toys and cars. Call agent now to see this Quality home.
]]>
</description>
- <lot-size>
- <![CDATA[ 100x190
]]>
</lot-size>
</details>
- <landing-page>
<lp-url>http://usa-mls.com/properties/detail/listing/9937342</lp-url>
</landing-page>
- <detailed-characteristics>
<furnished>no</furnished>
</detailed-characteristics>
<timestamp>2014-01-24 03:30:03</timestamp>
- <site>
<site-url>http://usa-mls.com/</site-url>
<site-name>USA-mls.com</site-name>
</site>
- <agent>
- <agent-email>
- <![CDATA[ fkeerl@yahoo.com
]]>
</agent-email>
- <agent-name>
- <![CDATA[ Fred Keerl
]]>
</agent-name>
- <agent-phone>
- <![CDATA[ 1-877-691-6900
]]>
</agent-phone>
</agent>
- <pictures>
- <picture>
<picture-url>http://usa-mls.com/propimg/37342-425-13-0008.jpg</picture-url>
<picture-seq-number>1</picture-seq-number>
</picture>
- <picture>
<picture-url>http://usa-mls.com/propimg/37342-425-13-0008a.jpg</picture-url>
<picture-seq-number>2</picture-seq-number>
</picture>
- <picture>
<picture-url>http://usa-mls.com/propimg/37342-425-13-0008b.jpg</picture-url>
<picture-seq-number>3</picture-seq-number>
</picture>
- <picture>
<picture-url>http://usa-mls.com/propimg/37342-425-13-0008c.jpg</picture-url>
<picture-seq-number>4</picture-seq-number>
</picture>
- <picture>
<picture-url>http://usa-mls.com/propimg/37342-425-13-0008d.jpg</picture-url>
<picture-seq-number>5</picture-seq-number>
</picture>
- <picture>
<picture-url>http://usa-mls.com/propimg/37342-425-13-0008e.jpg</picture-url>
<picture-seq-number>6</picture-seq-number>
</picture>
- <picture>
<picture-url>http://usa-mls.com/propimg/37342-425-13-0008f.jpg</picture-url>
<picture-seq-number>7</picture-seq-number>
</picture>
- <picture>
<picture-url>http://usa-mls.com/propimg/37342-425-13-0008g.jpg</picture-url>
<picture-seq-number>8</picture-seq-number>
</picture>
</pictures>
</property>
Wednesday, 30 April 2014, 21:54 GMT
Change this:
- <site>
<site-url>http://usa-mls.com/</site-url>
<site-name>USA-mls.com</site-name>
</site>
To this:
- <site>
<site-url>http://www.realestate-mls.com/</site-url>
<site-name>RMLS multi-list</site-name>
</site>
Wednesday, 30 April 2014, 22:03 GMT
Change this:
- <property-manager>
- <property-management-company-name>
- <![CDATA[ Home Hunter Realty
]]>
</property-management-company-name>
</property-manager>
To this:
<brokerage>
<brokerage-name>
- <![CDATA[ Home Hunter Realty
]]>
</brokerage-name>
<brokerage-id>add 3 digit member number
</brokerage-id>
<brokerage-phone>add company phone number
</brokerage-phone>
</brokerage>
Wednesday, 30 April 2014, 22:09 GMT
Wednesday, 30 April 2014, 22:28 GMT
- <landing-page>
<lp-url>http://usa-mls.com/properties/detail/listing/9937342</lp-url>
</landing-page>
To this:
- <landing-page>
<lp-url>http://www.realestate-mls.com/detail.cgi?viewonlyno=425-13-0008</lp-url>
</landing-page>
This can be done by stripping out the RMLS number and appending it to the constant "detail.cgi" URL.
Not sure how the photo URLs can be included in the feed. I suppose we could keep those referencing the USA-mls if there is no other way.
Monday, 05 May 2014, 00:09 GMT
You can view it here: http://usa-mls.com/public_feeds/realtorcom.xml
I've modified the rmls export so that it includes the realtor paths as a part of the data. It's not available yet, but it should come in with the run tonight. This will allow us to include the photos straight from rmls rather than point them to usa-mls.
For the "agent-code", I've used the brokerage code and the first three letters of the realtor name as an example.
All URL's should now be pointed to RMLS.
Wednesday, 07 May 2014, 20:17 GMT
<picture-url>
http://realestate-mls.com///graphics/122672-732-13-0016.jpg
</picture-url>
Wednesday, 07 May 2014, 20:18 GMT
<schools>
<school-district>
<district-name>
Add the School District Name here...
</district-name>
</school-district>
</schools>
Friday, 09 May 2014, 03:34 GMT
I hadn't re-created the example feed since the first run, so the feed didn't have the paths in it, I've re-created the feed and it should now contain valid links.
Friday, 16 May 2014, 20:27 GMT
Can you change the Listing ID to the RMLS Listing Number.
<provider-listingid>
99122672
</provider-listingid>
After this change, we should be ready to send back to Realtor.com for confirmation. Could you create a test data file of at least 20 records. Thanks.
Monday, 19 May 2014, 05:25 GMT
Friday, 23 May 2014, 00:47 GMT
I edited 3 listings and selected to "Upload to" "Realtor.com". Should this now be working and adding those 3 listings to the data feed file, replacing the test file you created with all of the records being uploaded.
I'm wondering if we were to "implement" rmls-update.cgi right now, would the realtor.com data feed portion of the program work.
Friday, 23 May 2014, 04:48 GMT
Tuesday, 27 May 2014, 01:47 GMT
Sunday, 29 June 2014, 22:38 GMT
When we go live with the "rmls-update" I would like to have Realtor.com and USA-mls.com checked for every existing Residential listing. Can you do this?
Since the majority of agents will most likely want their listings uploaded. Those that don't can "uncheck" the boxes.
Monday, 30 June 2014, 02:56 GMT
I will need to put together a small script to "check" those listings, it shouldn't be to terribly difficult though.
Friday, 29 August 2014, 13:46 GMT
"checkbox" I accept the Terms and Conditions
Submit
Thursday, 11 September 2014, 19:32 GMT
I'm emailing the Terms and Conditions file to you now. (see comment above)
We do not want to "check" the Realtor.com box for every listing (which I had thought we might do before). The Terms and Conditions box needs to be checked for every listing now before being made "active" and only those that check the Terms and Conditions can upload to Realtor.com.
Thursday, 11 September 2014, 19:45 GMT
Numeric percentage required for the following three fields:
a "%" should appear after each of these input boxes
Enter the Co-op Fee*: - the value entered here should be some number between 0-9 where decimals are allowed, such as 3.5
Enter the Buyer's Agent Fee*: - the value entered here should be some number between 0.5-9 where decimals are allowed, a "0" is not allowed
Enter the Referral Fee*: - the value entered here should be some number between 0-99 where decimals are allowed, such as 20
Thursday, 11 September 2014, 19:52 GMT
In order to insure that the agent codes are unique (because there could be two people in the office with the same first name), let's add the last two digits of the Agent's Phone Number field.
Thursday, 11 September 2014, 20:05 GMT
Tuesday, 16 September 2014, 04:55 GMT
Tuesday, 16 September 2014, 05:14 GMT
Wednesday, 17 September 2014, 21:17 GMT
I don't see that the "Submit Listing" button is "inactive" until the Terms and Conditions checkbox is checked.\
Do you have to "load" something?
Within the Terms and Conditions pop-up box, please make the font "verdana" (I think, the same as rest of the site) instead of "times roman".
Also, remove the larger font for the headings. Please just Bold the headings, leaving the text the same size as the rest of the text.
Thursday, 09 October 2014, 23:27 GMT
Location: \\paz02dsd981\mls\rmlsmultilist
Login: rmlsmultilist
Password: E9UdfvPl
They wanted to know if we could send a new updated file so their mapper can do further testing.
Monday, 13 October 2014, 04:29 GMT
Is there any additional details they provided?
Monday, 13 October 2014, 05:01 GMT
http://solutioncenter.realtor.com/ControlPanel/Login.aspx#iid=rdc_hdr_realtors_agentloginn
Could it be http://solutioncenter.realtor.com ?
If this isn't it, I'll have to get more information tomorrow.
Monday, 13 October 2014, 06:17 GMT
Referral Fee - TBD "Percent" is allowed and it shouldn't be. It should be caught by the error checking.
Referral Fee - TBD "Dollars" works as it should (the error checking catches it as an error).
Referral Fee - 0 "Percent" and 0 "Dollars" should both be allowed, along with numbers over 99.
One the Display side, please display just one decimal point for "percent" and two decimal points for "dollars".
Monday, 13 October 2014, 06:24 GMT
On Fri, Oct 10, 2014 at 5:27 PM, DeSantiago, Bertha <Bertha.DeSantiago@realtor.com> wrote:
Hi Jean,
I spoke to our mapper and she said preferably we’d like to look and map at the data after your members have entered a few listings. Could you drop new data on Monday after listings have been entered and let me know?
Thanks,
Bertha DeSantiago
(805)557-2094
bertha.deSantiago@realtor.com
Monday, 13 October 2014, 19:03 GMT
Hi Jean,
I just spoke with my data department and they had provided me the internet link. Below is the info for you:
FTP://transfer.realselect.com/
Login: rmlsmultilist
Password: E9UdfvPl
Thanks,
Bertha DeSantiago
(805)557-2094
bertha.deSantiago@realtor.com
Tuesday, 14 October 2014, 07:44 GMT
Wednesday, 15 October 2014, 00:20 GMT
But, the Buyer's Agent and Referral Fee display two decimal places for the Percent, can you have these display just one decimal place.
Thanks.
Wednesday, 15 October 2014, 13:40 GMT
Could you let me know when that will occur, so I can her know.
Friday, 17 October 2014, 16:20 GMT
Referral Fee - 0 "Percent" and 0 "Dollars" should both be allowed, along with numbers over 99.
A correction needs to be made on the error-checking. 0 "Dollars" isn't being allowed, it should be. (0 "Percent" is)