Address Validation through XML Web Service and Address Range Lookup

PURPOSE Given an ASP that accepts a user’s address, call an external XML web-service to return a validated address. Then determine whether the validated address falls within one of many address ranges. GENERAL REQUIREMENTS This project is logically broken into three components: (1) Creation of an address range database table (2) Validation and cleansing of a web-based address (3) Determination of whether address falls into an address range derived in (1)

## Deliverables

SPECIFIC REQUIREMENTS (1) Creation of an address range database table Given a set of spreadsheets containing address ranges, create a SQL Server 2000 table of the address ranges. Then, create source code and run a one-time process to validate and cleanse the beginning and ending address within each range using the XML web-service explained in the next section (2). Retain the original address ranges while storing the newly validated/cleansed versions in the same table in sister fields. NOTE: An example address range could be: 1201-1299 New York AV, Washington, DC, 20005 (ODD). The spreadsheet will contain a parsed range including: from, to, address, city, state, zip, street side(s). (In this case, only the odd side of the street fits into the range; however, a range could be noted as either ODD, EVEN or BOTH.) (2) Web-based, real-time address validation and cleansing Leverage an XML web service to validate and cleanse in real-time an address provided by a user from an ASP. The ASP contains a form in general consisting of: address 1, address 2, city, state, and zip. Call the service to determine whether the address is valid; if so, move on; if not, on a resulting ASP, provide the user with a cleansed address and request that he/she verify that this is the right address; or, provide the user with a message that the address is not usable/verifiable if the web service states so. In general, the user cannot move on without providing a valid address. However, if the web service is down (not available or fails to respond within a given period of time), make note of that in the user’s profile (table in SQL Server DB where address is stored) and move on without attempting to determine whether the address falls within an address range. In this case, the user is not forced to provide a valid address other than that they provide validated and required fields, etc. (3) Determination of whether address falls into an address range derived in (1) Through character string matching determine whether the cleansed address falls within any address ranged derived in the first (1) section. The character string matching should occur in the following order: Street, City, State, Zip, Street Number, Odd/Even/Both TASK (1) PROVIDED BY US: (a) Spreadsheets containing address ranges; (b) SQL Server 2000 database; and (c) Access to XML web service DELIVERABLES: (a) Modified SQL Server 2000 table containing validated and cleansed address ranges; and (b) Source code (Newly created VB6 Project) that validates and cleanses addresses. TASK (2) PROVIDED BY US: (a) User address ASP; (b) SQL Server 2000 database; and (c) Access to XML web service DELIVERABLES: (a) Modified ASP; (b) Modified SQL Server database; (c) Modified VB6 source code TASK (3) PROVIDED BY US: (a) User address ASP; (b) SQL Server 2000 database; and (c) Access to XML web service DELIVERABLES: (a) Modified ASP; (b) Modified SQL Server database; (c) Modified VB6 source code Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.

## Platform

BACKGROUND INFORMATION We have a web-based application that is developed using ASP, VB6 COM Components, and SQL Server 2000. 95% of the VB (ASP and VB6) resides in either of two COM components (web and data) creating a standard three-tiered system. NOTE: The web service to which we’ll likely subscribe is ([url removed, login to view]). We’ll expect that you’ll be able to interact with this third-party vendor as necessary for technical assistance to complete the project. However, we’ll interact with you regularly to help you through this project.

## Deadline information

TASK (1) must be completed by 8/30/2002 TASK (2) must be completed by 9/10/2002 TASK (3) must be completed by 9/15/2002

ASP PHP XML

Project ID: #2864344

About the project