Đã Đó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ê:
( 4 nhận xét ) houston, United States

Mã Dự Án: #15194760

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

liveexperts123

please ignore the bid amount we will discuss the price later in the chat after we have discussed the project thoroughly Relevant Skills and Experience: . Proposed Milestones: 555 - . Hi RVParijat! Please drop a message Thêm

$555 USD trong 3 ngày
(0 Đánh Giá)
0.0
hann4n

Hi, I understand you need an intelligent Database import system where Records are mapped automatically. Having a 2 year experience with MS SQL and .NET I am confident that I can provide you a [Cont..] Relevant Skills Thêm

$600 USD trong 10 ngày
(0 Đánh Giá)
0.0
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
(0 Đánh Giá)
0.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
(0 Đánh Giá)
0.0
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
(0 Đánh Giá)
0.0
joydipkanjilal

Hello, I'm a MVP (2007 - 2012), software architect with around 20 years of experience. Please communicate further on this to take this ahead. Joydip Relevant Skills and Experience C#, OOAD, Software Architecture, SO Thêm

$833 USD trong 10 ngày
(0 Đánh Giá)
0.0
aphoticzone

SQL Server / Microsoft Business Intelligence Solution Architect and Full Stack Developer. Relevant Skills and Experience 10.5 years of experience in IT Industry with Microsoft Technologies. 1 year 4 months’ part time Thêm

$555 USD trong 10 ngày
(0 Đánh Giá)
0.0
$777 USD trong 10 ngày
(0 Đánh Giá)
0.0
kamran211

Hello! I am bidding here because I noticed that you are looking for someone who could help you develop a software that will help you import the data in MS SQL intelligently by comparing the text chars Relevant Skills Thêm

$600 USD trong 7 ngày
(0 Đánh Giá)
0.0
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
(0 Đánh Giá)
0.0
drishinfotech

Having extensive experience of VB&C#.net and MS-SQL, we would gladly join you to create an import utility that will figure out the persons & companies names to avoid data redundancy while bulk import. Relevant Skills Thêm

$750 USD trong 10 ngày
(0 Đánh Giá)
0.0
ludiac

Hi, we have reviewed the description and have understood the problem with import. We can write the utility using C# to do the matching and replacing/adding names etc. Relevant Skills and Experience We have expertise i Thêm

$594 USD trong 10 ngày
(0 Đánh Giá)
0.0
$555 USD trong 15 ngày
(0 Đánh Giá)
0.0
AliSafder

Ideally, it will be google like search after importing the contacts. We can match entries before inserting into the database and then while search whole data can be displayed as per need. Relevant Skills and Experien Thêm

$250 USD trong 10 ngày
(0 Đánh Giá)
0.0
IMExpertEngineer

Hi, I think match should not be automatic because it can wrong match if both names are similar but with one letter difference and in fact we should do in some other ways Relevant Skills and Experience sql server Pro Thêm

$555 USD trong 10 ngày
(0 Đánh Giá)
0.0
$740 USD trong 10 ngày
(0 Đánh Giá)
0.0
leomcl

This task you need is called "pre-processing data" in data mining world. We need implement to you an string algorithm to avoid duplicates verifying similarities. Relevant Skills and Experience I started to work with V Thêm

$777 USD trong 10 ngày
(0 Đánh Giá)
0.0
$750 USD trong 10 ngày
(0 Đánh Giá)
0.0
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
(0 Đánh Giá)
0.0
dmitryIk

Hello, I'm a python developer and I think I can solve the type of problem you have. I can achieve this using string comparison algorithms, so I can judge if the company and the user are in the list already. Also, i Thêm

$677 USD trong 4 ngày
(0 Đánh Giá)
0.0