search

Battler45 / SierraMigrationToGitHub

Migration from unfuddle to GitHub
0 stars 0 forks source link

Integrate OABR / Omaha, Nebraska Data Feed #176

Open Battler45 opened 4 years ago

Battler45 commented 4 years ago

George,

We have a new data feed to integrate for Omaha, NB. This should probably go into the sierrainteractive-3 database since it is geographically relatively close to Denver, CO.

User ID: 966113 Password: 32si5

http://oabrmls.rets.fnismls.com/rets/fnisrets.aspx/OABRMLS/login?rets-version=rets/1.5

I've attached the documentation which the board sent for use in setting up the data fields. For comparison purposes, you can also see the way the data is structured and labeled in some of our competitors' sites: http://www.housesinomaha.com/listing/21202997-17402-island-cir-bennington-ne-68007/ (scroll down to view data through the overlay).

Please let me know if you have any questions.

Thanks.

Posted by Molchanov George(unfuddle username: george)

Battler45 commented 4 years ago

[Included for reference]

The MLS Data for OABR was refreshed on 4/11/2012 with the changes indicated in the following attachment/ Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

George,

I believe the mappings are:

Please import list types 1, 4, 5, 8.

Also, in the data you sent, there are a lot of listings with status like Sold, Expired, Leased/Rented, Cancelled, Pending. For now, we only want Active status listings. Please ignore listings with all other statuses.

Also, there is some explanation of data in the attached document provided by the board.

Thanks.

Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

George,

That's a good question. Eventually I do think we will need to include this new field as a separate field in the database. Can you review the metadata for this region and let me know the size of this field -- will it be a field of data type text or will it have a fixed length (such as 256 or 512 characters)?

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I can not connect to specified RETS server. Remote server returned an error 401 (Unathorized). Could you please confirm credentials?

Thanks Posted by Molchanov George(unfuddle username: george)

Battler45 commented 4 years ago

Ben,

I reviewed document about changes on OABR data feed and found one interesting thing. They have added new field "Syndication Remarks" which is intended to be a public remarks field for all third-party syndication data feeds such as ListHub (broker tool that uploads listings to Zillow, Trulia, etc.). But it is not a replacement for basic Public Remarks. Do we need to use this field? And if yes I think we need new database field to store this value.

Please let me know your thoughts Thanks Posted by Peskoe Ben(unfuddle username: bpeskoe)

Battler45 commented 4 years ago

Ben,

I've checked new RETS meta data and found

  1. New field "Syndication Remarks" is available only for residential type of listings

  2. Max length of this field is 4000.

Thanks Posted by Molchanov George(unfuddle username: george)

Battler45 commented 4 years ago

Please place further comments into Basecamp, here:

https://basecamp.com/1767592/projects/359327-121-integrate-oabr

Battler45 commented 4 years ago

George,

Okay, for now please proceed without it. We will revisit this at a later date. (I'd rather not add another long Varchar(4000) field to the MLS table, especially one that would only be used in rare cases like this, and not during the actual search -- we will think this through at a later date.)

Thanks. Posted by Peskoe Ben(unfuddle username: bpeskoe)