Automate the daily import of MLS data from an idx file, and clean/normalise data
$500-5000 USD
Πληρώθηκε κατά την παράδοση
I have access to a daily idx file containing MLS data([url removed, login to view]). I need to automatically import this data each day into an existing database (based on Open-Realty). The fields are listed below under "deliverables". This data is for internal use only.
Some fields have incorrect data, but using rules I will provide they can be cleaned. For example, in the "commission" field, some records have "3", meaning 3%, while other records have "0.03", which also means 3%.
Some fields we need to combine, e.g. "housing association fees" are a dollar amount, and then "frequency" has "monthly" or "annually". If it's annual, we need to divide by 12 so all our records have monthly fees.
Ideally, these rules will be in an admin screen, formatted like a dictionary. For instance, under "Commission" we might have
3 -> 0.03
.3 -> 0.03
6 -> 0.03 (usually "6" refers to the total commission, whereas this field represents only the buyer's agent commission)
2 -> 0.02
.2 -> 0.02
25 -> 0.025
etc. This list means "when you find X, insert Y into the field", and I could change or add conversions as new data entry errors show up.
Finally, a few fields are calculated based on other fields and formulas. Ideally I could edit these formulas, as in Excel, e.g. for a price per bedroom field, there might be a line that says
PricePerRoom = Price/Beds
For each record, the PricePerRoom field is calculated based on that record's Price and Beds. Later I might want to add baths, like
PricePerRoom = Price/(Beds + Baths)
I realise this might be tricky and I don't want to spend a ton of money, so if I have to edit SQL statements that's acceptable.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
4) Coder to sign non-disclosure agreement and non-compete agreement, which prohibits coder from reselling to Buyer's competitor the same code developed for Buyer.
Here is the list of fields. Some of the fields will require no cleaning. Many of them will require just a few rules, like converting acres to sqft. And then a few of them, like "commission" will require lots of rules.
List Price
House Rating
Street Rating
Cost Index
Priority
Days On Market
Address
City
State
Zip Code
Remarks
Showing Instructions
Property Type
Year Built
Number of Units
Buildings
Levels
Living Area Sqft
Lot Size Sqft
Bedrooms
Bathrooms
Number of Rooms
Basement
Laundry
Garage Capacity
Carport Capacity
Uncovered Parking Spaces
RV Parking
Swimming Pool
Spa or Hot Tub
View
Roof Material
Siding
Flooring
Fireplace
Heating
Cooling
Alarm System
Water Source
Sewer
Electric Company
Gas Company
Garbage Pickup
Recycling Company
Refrigerator
Oven
Range
Dishwasher
Disposal
Zoning
Historic District
Waterfront Property
Golf Property
Horse Property
Gated Community
Assessor Parcel Number
Map Area
Map Grid
Latitude
Longitude
Elementary School
Middle School
High School
Annual Rent
Annual Expenses
Gross Rents Multiplier
Capitalization Rate
Monthly HOA
Seller Carryback
Carryback Term
Carryback Rate
List Date
Listing Source
MLS Number
HUD Number
Probate Number
Lock Box Combination
Occupant
Occupant Name
Occupant Phone
Sales Office Commission
Listing Office
Listing Agent Name
Agent Phone 1
Agent Phone 2
Agent Phone 3
Agent Phone 4
Agent Fax
## Platform
It needs to run on our server, which I believe supports linux and windows.
Ταυτότητα Εργασίας: #2859589