Contact Database and management to produce Mail Merge

Closed

Description

We have built a business database in the form of many csv files covering the United Kingdom. This contact information is important and needs to be housed properly so it can be accessed and worked with. We need a database and intuitive front-end to manage the data to improve it's quality, add and update fields, merge duplicates and create groups of contacts based on multiple search terms that we can add to a group.

Typical problems arise such as duplicates, being able to merge and build better single entries are key. The data needs to be searchable with multiple terms being added to the 'basket' to produce an export list for Mail Merge. Ability to browse files easily but require an edit button submission so data cannot be accidentally changed.

Data fields:

Company Name

Address

Address 2

Address 3

Town

County

Postcode

Region

Country

Contact Full Name

Contact Job Title

Email Address

Phone Number

Fax Number

SIC Code

NAICS Code

Business Category

Web Address

Business registration Number

VAT Number

Notes section

We need to be able to upload the .csv files and tell the program which column relates to which field. Almost all files are laid out the same, but we'd like to ensure no data is corrupted in upload.

Ability to upload data where an address field may have a comma without corrupting the upload.

Export lists for mail merge and check boxes for what is to be included/excluded from export.

Smart export of data as some fields with short addresses may have county and region as the same eg: 'Durham' and 'Durham'. If we export this to map it on Google, the record will read the name twice. Suggestions sought..

Duplicates, compare entries and merge fields, add new or drop. Aim is to have one contact with good information not several with partial even if one contact includes several names, emails and phone numbers.

UK Counties are often shortened, need to replace Bucks. with Buckinghamshire, Lincs. with Lincolnshire Herts. with Hertfordshire etc.

Search and sortable for export by creating groups based on partial name/keywords (recyc rather than recycling and recyclers), SIC code and more. Need to create campaigns by searching and selecting multiple category fields and adding them to a group that we can name. One entry can belong to multiple groups.

For example, a plastics recycling facility may get grouped by us as part of a campaign under 'machinery', 'recycling', 'Waste handlers', three groups we can create and export as separate groups.

Skills: C Programming, HTML5, MySQL, PHP, Python

See more: where to get data entry job, what is database programming, what is database entry, what is a data entry form in a database, web programming uk, web based c# database programming, uk mail, uk email database, uk email address database, uk business email list, uk business email database, searching in c programming, region 13, programming job uk, programming job address, php program to upload files, php programming notes, notes php programming, n.c. machinery, mail merge google, it programming uk, google map submission, google mail merge, email database uk, email address management

Project ID: #2659228

14 freelancers are bidding on average £620 for this job

USAGraphicPR0

********************************************.. YOUR SEARCH ENDS HERE .. ********************************************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and get More

£1000 GBP in 8 days
(33 Reviews)
7.2
noahsombrero

I am a mature developer with wide ranging experience. I can write a php script that will parse this data for you and enter it with refinements in your datatabase. And I can do it right. Parser scripts my specialty.

£500 GBP in 4 days
(5 Reviews)
6.6
waelfree

Hi, I can do that

£400 GBP in 7 days
(50 Reviews)
5.8
jitendraparmar07

Ready to start right now.Please check your PMB.

£400 GBP in 5 days
(10 Reviews)
4.6
yeki

I'm an expert programmer. Please see your PMB.

£400 GBP in 14 days
(4 Reviews)
3.7
carlopires

Your application is a great use case for Python with Django framework. More details in PM.

£1000 GBP in 10 days
(1 Review)
1.0
JKTQ6g12v

Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o

£750 GBP in 1 day
(0 Reviews)
0.0
CodeL

I have experience with databases and csv files and I can deliver a project free of errors at the specified time.

£500 GBP in 14 days
(0 Reviews)
2.0
webdweb

Hello, I have gone through your requirements and understood everything. Allow me to do this project.

£800 GBP in 25 days
(0 Reviews)
0.0
mango953

If you are willing to work with FileMaker Pro I can help. Please watch a couple of Power Point 2010 slide presentations of solutions designed by me.

£1000 GBP in 20 days
(0 Reviews)
0.0
jakebrown5

Hi! Your project sounds well-matched to my interests. Depending on the software platforms used, I can draw upon prior experience in SQL and/or Python to write code to sort through your data and perform the necessary op More

£375 GBP in 7 days
(0 Reviews)
0.0
kod5r

please checl my pm

£250 GBP in 7 days
(0 Reviews)
0.0
pavy1413

Please refer your PMB

£250 GBP in 20 days
(0 Reviews)
0.6
nisar386

I can only see the lenghtiness in this project and nothing else. I have a good experience in developing such kinds of applications. I will make this in C#

£300 GBP in 20 days
(0 Reviews)
0.0
smartdb

I can provide you with very flexible spreadsheet like UI with change logging and even Undoing. Using a RAD toolkit (sdb.net.in).

£1000 GBP in 7 days
(0 Reviews)
0.0