Please read & understand our job in its entirety before responding. Do not respond as a robot.
We have a contacts management system built using MS SQL Server. Several occassions
we have to import bulk data into it from CSV or similar type files.
The names of persons & companies are generally misspelled or are written in different ways that makes a successful import very challenging due to finding a suitable match.
It results in multiple/duplicate entries for persons & companies. There is a SQL table for each of them. We have tried to use MS SQL Full text search and that is inadequate.
Need you to provide a smart import utility that will figure out the persons & companies names
& find a match under different scenarioes like misspellings or different versions of the names. If a match is not found, then a new record(s) will be added.
More like Google or Bing search of a name.
The smarts may need to be used at query submission as well as with results of query. If you have a better mousetrap, suggest it. We shall share the database
schema with shortlisted candidates & let them requote if necessary. We need you to supply this utility with VB or C#, with full source code & any dependencies.
The source will have to be provided to us every other day on progressive basis.
Please respond only if you are serious.
Do not provide any irrelevent info, we shall provide you an opportunity later to do a sales presentation about the rest of your capabilities.
Ask any questions, so that you are clear with the scope of work.
There should be a way to add a single entry like using the mobile apps, which imports contacts from a business card. Some way, other than just linking the fields (which is ok for bulk import), to import single contacts , let us say from an e-mail message.
55 freelancer đang chào giá trung bình $622 cho công việc này
I am an expert in delivering custom scripts and tools Relevant Skills and Experience willing to discuss further details about the project Proposed Milestones $444 USD - milestone
Hi I am very,very interested in your project I have 6 years of development experience such this projects. Relevant Skills and Experience I have already done such this project Proposed Milestones $333 USD - milestone
Hi, here need to make vba modules to provide all recognitions of names, I can do that via Ms Access fe , SQL be. Relevant Skills and Experience Access, vba, sql,ado Proposed Milestones $555 USD - dwfault