Implement Updater for New Region / COAR / Central Oregon

[Battler45]

George,

We have the data feed for a new region that needs to be integrated -- central Oregon. Please add this region to the sierrainteractive-4 database.

This region is powered by Rappatoni, the same as SIRA and NKAR, and so integration for this region should be similar to those other regions. Here is the information to access the feed:

http://rets172lax.raprets.com:6103/CentralOregon/COAR/Login.aspx

Agent ID = Sierra

Password = B3nd0r

User/Header = Sierra/1.72

I've attached a document they provided which contains some information about the available fields.

This region is more of a priority than converting the MLBOR region, and so if you could put the MLBOR region on hold while you complete this, that would be good.

Please let me know if you have any questions.

Thanks.

Posted by Molchanov George(unfuddle username: george)

[Battler45]

George,

Here are my comments on COAR RESID data:

• RESIELMS --> "ElementarySchool" field

• RESINEW --> When "Yes" set ConstructionStatus field to "New Construction"

• PropertySubttype1 --> ListTypeDescrip

• Style --> Area or Subarea

• ShowAddressToPublic --> Make sure you are setting address to "000 Confidential Ave." when this value is 0

• RESISTYL --> Style

• APN --> ParcelNumber

• PublishToInternet --> Make sure you exclude listings where value is set to 0

FeaturesBasement

• RESIFOUN --> "Foundation:" exclude value, "See Remarks"

FeaturesConstruction

• RESIBULD --> "Builder:"

• RESILEVL --> "Num Stories / Levels:" (exclude value "See Remarks")

FeaturesEnergy

• RESIHTCO --> "Heating / Cooling:"

FeaturesHOA

• RESIHOA --> "Home Owners' Assoc. (HOA):"

• RESIHOAD --> "HOA Dues:" (format as currency)

• RESIPER --> "HOA Dues Paid:"

FeaturesInterior

• RESINC1 --> "Included:"

FeaturesLot

• RESICOMM --> "Lot / Community Features:" Also, when "Horse Property" is present in value, set Equestrian flag to True

• RESILOTD --> "Lot Dimensions:"

• RESIVIEW --> "View:" Also, set ViewScenic bit field to True when value is present

FeaturesUtilities

• RESIELEC --> "Electric Provider:"

Please try to apply these same ideas to other list types and let me know if you have any questions.

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

[Battler45]

Ben,

Below is list of fields which I'm using for features:

1. FeaturesCommunity

   • RETS field: LANDCOMM/MULTCOMM/RESICOMM. Header: Community Features.

2. FeaturesConstruction

   • RETS field: BUSICONS/COMMCONS/FARMCONS/MULTCONS/RESICONS. Header: Construction Type.

3. FeaturesEnergy

   • RETS field: COMMHTCO/FARMHTCO/MULTHTCO/RESIHTCO. Header: Heat / Cool.

4. FeaturesExterior

   • RETS field: FARMEXTE/MULTEXTE/RESIEXTE. Header: Exterior Features.

5. FeaturesFoundation

   • RETS field: BUSIFOUN/COMMFOUN/FARMFOUN/MULTFOUN/RESIFOUN. Header: Foundation.

6. FeaturesInterior

   • RETS field: FARMINTE/MULTINTE. Header: Interior Features.
   • RETS field: FARMFIRE/MULTFIRE/RESIFIRE. Header: Fireplace(s).
   • RETS field: COMMFLOR/FARMFLOR/MULTFLOR/RESIFLOR. Header: Floors.

7. FeaturesGarage

   • RETS field: FARMGARA/RESIGARA. Header: Garage. Also NumParkingSpaces can be filled from own field COMMNOPS (for COMM class) or being based on Garage value.

8. FeaturesHOA

   • RETS field: LANDHOA/RESIHOA. If its value is "yes" then FeaturesHoa can be filled from RETS field LANDHOAD/RESIHOAD with header HOA Amount. Question: for RESI class we also have access to the RETS field HOA Per [RESIPER]. It is free text field with some kind of period description (values from sample listings: "month", "year", "yearly", "Month for Road Maintainance"). Do we need to use this field?

9. FeaturesLot

   • RETS field: FARMTOPO. Header: Topography.

10. FeaturesLotAccess

    • RETS field: LANDROAD. Header: Road.

11. FeaturesRoof

    • RETS field: COMMROOF/FARMROOF/MULTROOF/RESIROOF. Header: Roof

12. FeaturesUtilities

    • RETS field: BUSIEXIS/COMMEXIS/FARMEXIS/LANDEXIS/MULTEXIS/RESIEXIS. Header: Water.
    • RETS field: BUSISEWR/COMMSEWR/LANDSEWR/MULTSEWR/RESISEWR. Header: Sewer.

For Rooms field we can use RETS field FARMROOM/RESIROOM (only FARM and RESI classes) which contains data as plain list of available rooms ("Living Room,Kitchen,Utility,Dining Area", "Living Room,Kitchen,Utility"). Do we need to transform this somehow?

Thanks Posted by Molchanov George(unfuddle username: george)

[Battler45]

Ben,

All additions are implemented. Updater is ready.

Thanks Posted by Molchanov George(unfuddle username: george)

[Battler45]

Ben,

I noticed that ListType 11 has name "BusinessOpportunities" (BusOp) in code but appropriate step is named "ImportCommercialOperations". Is it correct type/step for COAR class 1 (1.Contains data for Business Opportunity searches. [BUSI])?

Thanks Posted by Molchanov George(unfuddle username: george)

[Battler45]

George,

RE: #8

Yes, I believe ImportCommercialOperations is corect updater step -- list type 11 would be the correct ListType for this class.

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

[Battler45]

Ben,

Could you please give me some instructions for MLSRegions database's entry for this region (i.e. RegionName, CommonName, Abbreviation etc)?

Thanks

Posted by Molchanov George(unfuddle username: george)

[Battler45]

Ben,

We also have not access to the agent and office phones. In data for listing we are getting agent's name and office's name but neither AgentId (as link to the AGENT resource) not phone. Office phone is missed both in listing's data and in available fields of OFFICE recourse.

Thanks Posted by Molchanov George(unfuddle username: george)

[Battler45]

George,

RE: #5

I apologize, but I have not had time yet to review the data for this region. Regarding "CrossStreetAddress" if there is not a separate "Directions" field in the feed, please add this to the "Directions" field using the format: "Cross Street: White Buck" (for example).

2 - I will check with our contact at COAR to see if Listing Date is available. Until then, please use the date on which the listing is added to our system as the DateListed value for these classes.

3 - I will review the data and let you know. Also, please check out: http://www.coar.com/ This is the "official" site of the board, and they have a number of values listed under "Property Type" -- from your description, it sounds like these may be all of the different values from PropertySubtype1 -- is that correct? If so, please use PropertySubtype1 as ListTypeDescrip value for classes where this is different than the PropertyType value.

So, for example, for PropertyType Land you would use PropertySubtype1 as ListTypeDescrip because it contains distinct values:

• Lots / Land to 1 acre
• Commercial Land
• Lots 1 acre or more

But, for Income/Investment (Commercial), you would leave ListTypeDescrip blank because there are no separate values for this class.

4 - I will review the data, but are you sure these are the possible values for Style? If so, please map these to the Area or Subarea field (whichever is not already being used).

According to the client, the Bend area is divided into 4 areas -- SW, NW, SE, NE -- and people commonly search by these values. So, we will build these into our search form as a way to allow people to search by area. (Please do also include "Other" value.)

5 - Please exclude "See Remarks" value.

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