Đã Đóng

Intelligent MS SQL data import utility

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.

Kỹ năng: .NET, Lập trình C#, Microsoft SQL Server, Visual Basic

Xem thêm: MS SQL data, read flat file ms sql data base net, import sql data xml ajax, import ms excel ms sql, import csv ms sql asp script, copy data command stored procedure ms sql, connecting ms sql flex frame work, asp ms sql data, sql 2005 import data csv existing table, import sql data quickbooks, import sql data quickbook, sql server data import quickbook, import excel sheet sql data base, sql ssis import data

Về Bên Thuê:
( 7 nhận xét ) HOUSTON, United States

Mã Dự Án: #15194760

57 freelancer đang chào giá trung bình $620 cho công việc này

amusto

Hi, I already worked in the past on a import module to load data customer into Microsoft CRM that is based on MS SQL Server. The import procedure was based checking Name, Address, Phone, Email. Relevant Skills and Ex Thêm

$1052 USD trong 30 ngày
(82 Đánh Giá)
7.3
srinichal

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

$444 USD trong 10 ngày
(108 Đánh Giá)
7.1
$740 USD trong 10 ngày
(228 Đánh Giá)
7.3
masterlancer999

Hi, I am a Chinese Developer HuangLong. I read your job posting and I am very interested. Because I have a great skills in mssql manipulating using c#. Relevant Skills and Experience c#, mssql, .net Proposed Mileston Thêm

$555 USD trong 10 ngày
(39 Đánh Giá)
6.9
schoudhary1553

Hello Sir, I am the expert freelancer here and deliver the project as per your expection. so please give me chance to work on this roject Relevant Skills and Experience I have more than 5 years of experience in NET, Thêm

$750 USD trong 10 ngày
(85 Đánh Giá)
6.8
amitorada

Hi, we, Cears Infotech have provided many enterprise level solutions like ERP, CRM, HRMS , Payroll, POS, Online flight booking engine, HRMS, Ecommerce , Businss product and many more. Relevant Skills and Experience C Thêm

$1052 USD trong 20 ngày
(56 Đánh Giá)
6.5
mpalgeo

Hi. I will use SSIS fuzzy logic to find the match during import. About the existing duplication i will find them and change them or in case the are many changes to be done find a workaround. Relevant Skills and Experi Thêm

$700 USD trong 10 ngày
(55 Đánh Giá)
5.8
wsh2

Greetings.. {smile} Typically we like to use MsEXCEL as a front-end to do data imports. MsEXCEL provides a good user interface and the ability to do automated and ad hoc data corrections / updates. Relevant Skills an Thêm

$888 USD trong 10 ngày
(29 Đánh Giá)
5.9
lurdsubas

Hello sir, I have understood your requirements. The utility app will use a "repository" to correct all name spellings, then match the records to eliminate duplicates and merge contacts where necessary Relevant Skills Thêm

$1300 USD trong 20 ngày
(20 Đánh Giá)
6.0
developer0106

Hi, I am experienced .NET full stack developer and I have already worked with find duplicate or similar names based on number of characters are getting match and based on match result we can consider. Relevant Skills Thêm

$611 USD trong 8 ngày
(72 Đánh Giá)
6.2
aanvikm

Hello Sir, I am an expert SQL and .net developer and I can help you with this project. I guess if I can get the DB structure and a small set of sample data, I should be able to suggest most suitable way to import the d Thêm

$666 USD trong 10 ngày
(36 Đánh Giá)
5.7
$555 USD trong 10 ngày
(81 Đánh Giá)
6.3
qprotex

Hello, My name is Miguel Febres and you can locate my resume and certifications in the following links: [url removed, login to view] [url removed, login to view] In my 10+ years of e Thêm

$555 USD trong 10 ngày
(19 Đánh Giá)
5.7
juniadsarfraz

Designed and Developed many web and mobile apps. Contact me I am interested. Relevant Skills and Experience 4+ years of professional experience. Proposed Milestones $360 USD - .

$360 USD trong 10 ngày
(11 Đánh Giá)
5.3
beautiXiao

Hi, sir.I am a C# and .NET expert and read your post carefully. You are looking for someone who can provide a smart import utility that will figure out the persons & companies names. Relevant Skills and Experience C# Thêm

$555 USD trong 10 ngày
(14 Đánh Giá)
5.5
TanzeelAhmed

I REVIEWED YOUR PROJECT DETAILS & WOULD LIKE TO OFFER YOU MY SERVICE OF DOING FIRST TASK FOR FREE Relevant Skills and Experience I am Senior Software developer, having 7+ years experience with team of additional 2 dev Thêm

$500 USD trong 7 ngày
(20 Đánh Giá)
5.4
khp31

Sr. Software Professional having 8+ years experience. Relevant Skills and Experience Angular CLI, Angular 4, Angular 2, Angular Js, C# .Net, MVC , PHP, VB .Net, HTML, CSS, Bootstrap, Typescript, Javascript, Jquery, AS Thêm

$777 USD trong 10 ngày
(26 Đánh Giá)
5.1
bestit4u

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

$333 USD trong 5 ngày
(16 Đánh Giá)
5.1
jagdishbhatt38

I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). Relevant Skills and Experience I am having m Thêm

$700 USD trong 10 ngày
(24 Đánh Giá)
5.2
zu02

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

$555 USD trong 10 ngày
(22 Đánh Giá)
5.3