Find Jobs
Hire Freelancers

Contact Database and management to produce Mail Merge

£250-750 GBP

Closed
Posted over 11 years ago

£250-750 GBP

Paid on delivery
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.
Project ID: 2659228

About the project

14 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average £620 GBP for this job
User Avatar
********************************************.. YOUR SEARCH ENDS HERE .. ********************************************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and getting started. I've been working in simple and extensive Website Coding (PHP, MYSQL, .NET, C#, ASP, DRUPAL, JOOMLA, DOTNETNUKE, PERL JAVASCRIPT, CSS, HTML & A LOT MORE!), Website Designing and Graphic Design for ***over 10 years now. After working as a ***top sales and marketing representative for Sears, I began to independently pursue my career. I have experience in do-it-yourself CMS, Logos with flare and flash design to name a few. I went to college for business and marketing so ***I know what it takes to sell. Get it done professionally and get it done right! Thank you, Timothy
£1,000 GBP in 8 days
4.7 (33 reviews)
7.2
7.2
User Avatar
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.0 (5 reviews)
6.6
6.6
User Avatar
Hi, I can do that
£400 GBP in 7 days
5.0 (50 reviews)
5.8
5.8
User Avatar
I'm an expert programmer. Please see your PMB.
£400 GBP in 14 days
5.0 (4 reviews)
3.7
3.7
User Avatar
Your application is a great use case for Python with Django framework. More details in PM.
£1,000 GBP in 10 days
5.0 (1 review)
1.0
1.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
please checl my pm
£250 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please refer your PMB
£250 GBP in 20 days
0.0 (0 reviews)
0.6
0.6
User Avatar
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 operations. The deliverables may include an executable or an automated script to facilitate future development.
£375 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
£1,000 GBP in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
2.0
2.0
User Avatar
Hello, I have gone through your requirements and understood everything. Allow me to do this project.
£800 GBP in 25 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NEW ZEALAND
Wellington, New Zealand
4.8
22
Payment method verified
Member since Aug 30, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.