Open Battler45 opened 4 years ago
Ben,
I started the implementation of this importer and I found one significant difference between its RETS datasource and RETS datasources for NKAR and SIRA regions. For NKAR and SIRA regions we have access to the HISTORY resource which we are using to select sub-sets of data with condition by date of records' change. We need to use HISTORY resource because of the Rappatoni doesn't give an opportunity to use date in query. With COAR region we have not an access to the HISTORY resource. If it is unsoluble limitation we will need to use other method of data's requesting - get appropriate dates for all active records (there is about 4500 active listings for all classes) and then select records with using of this date. I think it will be some slower.
Could you please let me know should I implement this new method or we can have an access to HISTORY resource?
We have access to the next property classes. Please review these if my mapping to the property types is correct:
Contains data for Business Opportunity searches. [BUSI] -> BusinessOpportunities
Contains data for Income/Investment searches. [COMM] -> Commercial
ResidentialProperty [FARM] -> Farm
LotsAndLand [LAND] -> Land
ResidentialProperty [MULT] -> MultiFamily
ResidentialProperty [RESI] -> Residential.
Attached are RETS metadata and sample datesheets for all available types.
Thanks
Posted by Molchanov George(unfuddle username: george)
Ben,
Below is list of fields which I'm using for features:
FeaturesCommunity
FeaturesConstruction
FeaturesEnergy
FeaturesExterior
FeaturesFoundation
FeaturesInterior
FeaturesGarage
FeaturesHOA
FeaturesLot
FeaturesLotAccess
FeaturesRoof
FeaturesUtilities
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)
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
RESIBULD --> "Builder:"
RESILEVL --> "Num Stories / Levels:" (exclude value "See Remarks")
RESIHOA --> "Home Owners' Assoc. (HOA):"
RESIHOAD --> "HOA Dues:" (format as currency)
RESIPER --> "HOA Dues Paid:"
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
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)
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)
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)