ASP/XML data import to SQL database

Ολοκληρωμένο Αναρτήθηκε Jan 12, 2005 Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

NWMLS Web Service for importing property listings

The client requires an ASP.NET application developed that connects to the Northwest Multiple Listing Service (MLS) XML web service, parses all information and photos for properties and homes for sale in the office's geographic location, and imports this data into SQL Server database.

NWMLS provides XML web services for querying and retrieving property information.

• The Query service provides access to the various data sets.

• The Discovery web service provides information to the user about what they have access to.

The attached documentation ([url removed, login to view]) on the web services, including various XSD files, will shed light on connecting to and querying the service.

We do not want to have a live or constant connection to the MLS web service, but a nightly import of all data for their office, so there is no dependency or slowdown in website performance.

The web pages for searching listings, displaying results and displaying properties already exist, and the SQL Server tables that the information is stored in also already exist and will not change. We simply need to populate the existing tables from the importer that queries the web service.

Additional information provided in required deliverables.

## 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:

a) ASPX importer application installed by the Seller in ready-to-run condition on in client's account on ASP.NET server at ISP ([url removed, login to view])

ASP.NET application must connect to the Northwest Multiple Listing Service (MLS) XML web service, parse all information and photos for properties and homes for sale in the office's geographic location, and import this data into SQL Server database.

ASP.NET application must be able to be run manually by visiting a URL (i.e. <[url removed, login to view]>). This way we can either schedule that URL to be visited on a nightly basis - and/or we can manually visit the URL to initiate the import process when needed.

Import application must provide confirmation page when import process is completed. As well as confirmation email detailing the number of properties imported. In the case of a failed import - error page must be displayed and no confirmation email sent.

Data import must run error free before overwriting existing data, this way data accessed by website is always active and not corrupted by a failed import.

Certain varialbes in the importer application must be accessible and easily modified. These variables include: web service connection username/password, geographic location parameters (as well as the ability to add additional geographic areas to import), and SQL Server location.

Property photos (of which there will be multiple per listing) will also need to be imported via FTP access - instructions provided by NWMLS are provided for this as well. Property Photo importing will need to also delete photos for properties that are no longer listed in database. This will keep the photos current as well as keep the local server from getting overloaded with outdated image files. URLs for large and thumbnail property photos on local server will need to be added to database so website can display photos based on URL in database.

b) Installation and configuration of any server side directory structure requirements for script or photo import handling. Documentation of these directory structure requirements must also be provided (if applicable).

c) Documentation for configuring script variables - such as additional or different geographic location, username and password, data base location, etc.

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).

## Platform

Application must run on ASP.NET server (hosted by [url removed, login to view]).

Application must querry and interact with XML data web service (provided by Northwest Multiple Listing Service)

Application must import querried data into MS SQL database (also hosted by [url removed, login to view]).

ASP PHP XML

Ταυτότητα Εργασίας: #3515119

Σχετικά με την εργασία

6 προτάσεις Απομακρυσμένη εργασία Ενεργό Jan 31, 2005

Ανατέθηκε στον:

jonathanswartz

See private message.

$552.5 USD σε 1 μέρα
(1 Κριτική)
3.5

6 freelancers κάνουν προσφορές κατά μέσο όρο $307 για αυτή τη δουλειά

silkroutesl

See private message.

$425 USD σε 1 μέρα
(128 Αξιολογήσεις)
6.6
sergeyyuriev

See private message.

$212.5 USD σε 1 μέρα
(47 Αξιολογήσεις)
6.3
laacgroup

See private message.

$160.65 USD σε 1 μέρα
(21 Αξιολογήσεις)
4.6
mlog

See private message.

$365.5 USD σε 1 μέρα
(7 Αξιολογήσεις)
3.8
vw1369691vw

See private message.

$127.5 USD σε 1 μέρα
(6 Αξιολογήσεις)
3.5