Import/Export outlook-Sqlserver A set of routines and asp pages to import or export contacts and companies to and from outlook into or from tables in sqlserver The main idea is to: Grab outlook contacts from a machine with an asp page store them in a temporary database in sql server, manipulate the data to try to recognize if some contacts are not already in the database sometimes misspelled, offer the user some possibility to correct the data, create the new contacts in sqlserver tables There should be about 5 asp pages and about 5-10 sqlserver routines Most of the routines needed have to do with 'similarities'. A simple example is given below The pages to create should be interactive and allow a user to progress in the recognition in a user friendly way For example, there should be a page where the user might select one or several of the following options Company name similar/matches exactly/indifferent to an existing name Address similar/matches exactly/indifferent an exitsing address City similar/matches exactly/indifferent an existing city Country similar/matches exactly/indifferent an existing country Based on these options, we build an asp page showing on one side the new companies to enter, on the other side companies that are 'likely' to be the same as the one entered, and we let the user conclude: accept the match, search more or make a new entry we need a separate recognition for companies and for contacts Export is a simple asp page that grabs contacts from sqlserver tables and write them in the user outlook pst We will provide a step by step guideline, but we should expect some groping to get a user friendly page Example of a routine that can be used for similarity search DECLARE AT-S nvarchar(50) DECLARE AT-S1 nvarchar(50) DECLARE AT-S2 nvarchar(50) SET AT-S='credit Lyonnais' SET AT-S1='%Credit%' SET AT-S2='%Lyonnais%' select [login to view URL], CASE WHEN soundex([login to view URL])= Soundex (AT-S) THEN 1 ELSE 0 END as Sound , CASE WHEN (CName like '%Credit%' or CName like '%Lyonnais%') then 1 ELSE 0 END as Lik from C where soundex([login to view URL]) =Soundex (AT-S) or CName like AT-S1 Or CName like AT-S2
## 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).
## Platform
plain asp and Tsql windows