Đã hoàn thành

Clean up addresses

I have 30,000 addresses in a MSSQL 2005 database.

I will give you a username and password to my database to do the work.

All information is to be kept confidential.

They are currently in the format:

billing1

billing2

billing3

billing4

billing5

shipping1

shipping2

shipping3

shipping4

shipping5

I want these moved to a new table in the format

Name

Company

Address1

Address2

City

State

Zip

Phone

Fax

isbillingaddress

Removing the duplicate shipping addresses.

In addition to cleaning my data, I want you to provide me with a script and/or program that will perform this task in the future.

The data originally came from QuickBooks and is quite mangled.

Examples:

999-999-9999/8888

Would mean

Phone 999-999-9999

Fax 999-999-8888

This might be found in billing4, billing5, etc.

New York, NY 12345 999-999-9999/8888

New York, NY 12345 999-999-9999

999-999-8888

New York, NY 12345

999-999-9999

999-999-8888

And more variations.

## 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

Windows XP or ColdFusion or PHP. If you use another platform, suggest it and I will consider it.

Kỹ năng: Kĩ thuật, MySQL, PHP, Kiến trúc phần mềm, Kiểm tra phần mềm, SQL, Web Hosting, Quản lý website, Thử nghiệm trang web

Xem thêm: ny new hire, ny and company, give me a username and password, code 999, install quickbooks, data clean-up, suggest name software company, data coldfusion, windows phone mssql, suggest company name company, data cleaning software, clean installation, software company suggest name, database shipping company, cleaning php code, suggest software company name, database cleaning company, php database cleaning script, script perform web request, program shipping company, data clean script, shipping company database, addresses form, clean server, clean data

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

Mã Dự Án: #3886328

Đã trao cho:

vladmik

See private message.

$38.25 USD trong 11 ngày
(120 Đánh Giá)
6.9

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

abstractvision

See private message.

$102 USD trong 11 ngày
(141 Đánh Giá)
6.1
riazsl

See private message.

$85 USD trong 11 ngày
(38 Đánh Giá)
5.7
iowacompute

See private message.

$85 USD trong 11 ngày
(71 Đánh Giá)
5.4
pieby2

See private message.

$85 USD trong 11 ngày
(25 Đánh Giá)
4.9
flashzeuseu

See private message.

$42.5 USD trong 11 ngày
(26 Đánh Giá)
4.7
fusion35

See private message.

$34 USD trong 11 ngày
(19 Đánh Giá)
4.4
hgffhghf

See private message.

$41.65 USD trong 11 ngày
(37 Đánh Giá)
4.3
cubetick

See private message.

$68 USD trong 11 ngày
(16 Đánh Giá)
4.2
advantageit

See private message.

$42.5 USD trong 11 ngày
(4 Đánh Giá)
4.0
ussvw

See private message.

$127.5 USD trong 11 ngày
(8 Đánh Giá)
3.1
tactom

See private message.

$212.5 USD trong 11 ngày
(1 Đánh Giá)
0.0
kashifzeeshan

See private message.

$850 USD trong 11 ngày
(0 Đánh Giá)
0.0
xelossan

See private message.

$63.75 USD trong 11 ngày
(0 Đánh Giá)
0.0
coolguan

See private message.

$85 USD trong 11 ngày
(0 Đánh Giá)
0.0
nathalieluchoang

See private message.

$42.5 USD trong 11 ngày
(0 Đánh Giá)
0.0
aeoninfotech

See private message.

$42.5 USD trong 11 ngày
(0 Đánh Giá)
0.0