Automate the daily import of MLS data from an idx file, and clean/normalise data

Completado Publicado Feb 27, 2007 Pagado a la entrega
Completado Pagado a la entrega

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.

Administración de bases de datos Ingeniería MySQL PHP Arquitectura de software Verificación de software SQL Interfaz de usuario / AI

Nº del proyecto: #2859589

Sobre el proyecto

4 propuestas Proyecto remoto Activo Mar 5, 2007

Adjudicado a:

gbryanmiller

See private message.

$127.5 USD en 14 días
(1 comentario)
4.4

4 freelancers están ofertando un promedio de $627 por este trabajo

ghumber

See private message.

$425 USD en 14 días
(108 comentarios)
5.9
pieby2

See private message.

$425 USD en 14 días
(25 comentarios)
4.9
biplitvw

See private message.

$1530 USD en 14 días
(0 comentarios)
0.0