Completed

Need list management database for millions of contacts REPOST

Read through the end please.

I've got tens of millions of contacts in my marketing database. I need a better way to manage them. I've been using Access and Excel but it's simply too cumbersome. I tried a few database programs but they proved insufficient for the size. (One could not handle import of even 20,000 contacts at a time!)

need a solution, whether custom, off the shelf, server based (I have a VPS with hostgator), or desktop (I have Win Vista, 7 and 8.1). I need to be able to:

1. Import csv files

2. Easily choose fields to assign to data

3. De-duplicate

4. Perform filter/sort/lookups (as I do in Excel or Access)

5. Easily export files

Let me know your proposed solution.

UPDATE: I have posted this previously and awarded the project but the vendors were unable to complete. The most recent vendor setup MySQL db for me on my VPS, instructed me to install MySQL workbench on my desktop, and upload my files. I learned some mysql functions only to discover the process was much more complicated than he had suggested, and also failed to import any file which contained records with an apostrophe. This meant that proper names such as "Joe's Crab Shack" caused the entire import to fail. (As would city names, such as "O'Fallon").

I have tens of millions of records. I'm not going to go through and manually remove records. Please only bid if you know EXACTLY how to provide a working solution.

I am happy to provide a sample of the records so you can review. If you do not request a sample, I will not consider you for the project.

Kĩ năng: Big Data Sales, Xử lí dữ liệu, Quản trị cơ sở dữ liệu, Phát triển cơ sở dữ liệu, Lập trình cơ sở dữ liệu

Xem nhiều hơn: project management names, marketing names list, i need an access database, import administration, db import export, custom list in excel, access vendor database, database vendor, shack, records management , need contacts it, my contacts, filter sort, fallon, database import filter, update mysql using csv, setup database excel, excel filter list, import csv data mysql, export excel data mysql

Về Bên Thuê:
( 57 nhận xét ) Nashville, Canada

ID dự án: #6201243

Được trao cho:

Attractionnet

Hi. This can only be done with a custom program, like the ones i write. It will be a desktop app, working under windows 7 or xp. You will be able to import the contacts, assign fields to the data, make any corrections Thêm

$111 USD trong 3 ngày
(5 Đánh Giá)
1.7

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

royzafar

Dear Sir/Madam, I offer the best deal of available services according to your budget with 24/7 customer support. The projects, I bid, I am doing myself. It is not that I am going to outsource the projects I win! So Thêm

$277 USD trong 15 ngày
(0 Nhận xét)
0.0
Gongzhiq

how are you? i think my product can help you i have ETL Solution based on java and it supports all functions you want hope to work with you. Thank you

$555 USD trong 3 ngày
(0 Nhận xét)
0.0
mukapu

Hi, I understand your problem dealing with huge list of records. MySQL as a storage is good, but it is not easy for a non technical person to use the workbench to query and work with. I'll need the following informa Thêm

$500 USD trong 3 ngày
(0 Nhận xét)
0.0