Peruttu

Create Prospects Database from My Data

I have 170 files of miscellaneous leads that I have acquired over time. I have uploaded one very small one as a sample. I would like them loaded into a single custom database.

I started with an MS Access template for Contacts Database, and added fields to make it ‘look’ like it should. First step is to add the database fields, finish the entry forms (for new tabs), and make sure the database is working correctly.

Each of the source data files has a different format. It’s very important to me that no data is lost. At a minimum, each record should have a first name and some contact information (e-mail, phone, or mail address.) The name fields may be any combination of the following and more:

- Firstname. Lastname. Fullname. – all 3 as separate fields

- Firstname Middleinitial Lastname – we need to extract the first name

- Lastname, Firstname – the first name needs to be extracted and the full name re-written as Firstname Lastname with no comma

- Companyname – I don’t want “The Acosta Group” to be firstname=“The”

- Any combination of the above, even within the same file

All through the data, some may be in ALL CAPITALS, some in all lower case – everything should be standardized as Title Case. So, MARY or mary is entered as Mary.

Phone numbers should look like phone numbers (650) 555-1212 for US, +33 6 5544 3333 for international. I would like the Time Zone filled in for US phone numbers. There is a time zone lookup table in a number of the source files.

Many of the files have no header line, so they will take a little inspection to figure out the appropriate columns.

The source data files are in .txt, .csv, and .xls formats, with the columns in different order, some with more data, some with less. So, each file will require some handwork to get all the data uploaded to the database.

As each file is loaded into the database, I want to mark each contact record with the File Name and Date of the file, so I have a source for the information. The File Name and Date are shown in the Additional Info tab in the database.

Once all the data is loaded, duplicates should be eliminated if there are phone numbers, e-mail or mailing addresses that are identical.

I would like the ability to either upload a new data file as I get it, or a low-cost agreement with you to upload each new file. For example, if I buy 50,000 new leads, you'll convert/upload them for $5 or something. Or I need some utility to make this easy.

Finally, I would like to be able to extract records from the database easily. E-mail only, including e-mail, phone number only, including phone number, dated this year only, US only, foreign only, with mailing address, etc.

The 170 data files total 331 MB of data. So the resulting database will also be quite large - the freelancer will need to have a site where we can FTP the files. So, the starting point is working out how to get you the data files.

Hopefully this is all pretty quick and easy for someone with the appropriate skills and tools. Please provide bid, time frame, relevant experience, and why I should choose you.

Best regards and happy bidding,

Don

Taidot: tiedonsyöttö, tietojenkäsittely

Näytä lisää: prospects database, xls header, working from one freelancer, working from, working for first data, where we get freelancer, where to get a case as a freelancer, where can i get freelancer, total tools, the international freelancer, the freelancer phone number, the best skills in freelancer, template low cost, starting freelancer, starting as a freelancer, sample data entry forms, processing of data, order the single site freelancer, order freelancer, one tabs

Tietoa työnantajasta:
( 3 arvostelua ) Pacifica, United States

Projektin tunnus: #53560

41 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

arvindtechno

Sir, Ready to start [login to view URL] the PMB.Regards.

$100 USD 4 päivässä
(142 arvostelua)
7.0
LK1811

Clearly understood. Please be assured of 100% accurate work as per your requirements. I will do it by writing a program. Thanks, Krishan

$110 USD 5 päivässä
(74 arvostelua)
6.8
bsoist

Please see PMB for details.

$300 USD 7 päivässä
(9 arvostelua)
5.0
kasoft

We will do this for you in a professional manner. Regards, Biro Carol

$120 USD 4 päivässä
(1 arvostelu)
3.0
amanullahs

Your requirements can be executed as a project in MS Access. Please see PM for further details

$220 USD 4 päivässä
(1 arvostelu)
1.8
vnb400

kindly refer my PMB, thanks

$110 USD 5 päivässä
(2 arvostelua)
1.6
sampath650

I have a lot of experience in this kind of work. Please give me a chance.

$100 USD 5 päivässä
(1 arvostelu)
1.0
nextbyte

We can provide professional data manipulation ( advanced filters, imports, exports ) easy to use both as a desktop application ( delphi ) or web based ( php ) at your choice. Why should you choose us ? Because we a Lisää

$300 USD 2 päivässä
(0 arvostelua)
0.0
dhedley

I have extensive experience with databases, especially Access.

$300 USD 5 päivässä
(0 arvostelua)
0.0
rkmoriyani

Hi, Yes, we can move the data after required clean-up/re-format. Rgds, Rajesh

$300 USD 15 päivässä
(0 arvostelua)
0.0
standardinfotech

Hi, We will complete your project as per your requirements with high quality and prompt. thanks [login to view URL] Google Talk: standardinfotechnologies Skype: standardinfotechnologies Yahoo Mesen Lisää

$190 USD 10 päivässä
(0 arvostelua)
0.0
kamranshahzad

I will do this job in described time

$300 USD 5 päivässä
(0 arvostelua)
0.0
amitdixit

I am an expert at this , presently working with a leadin db vendor. You wont find anyone better than me ;-)

$100 USD 2 päivässä
(0 arvostelua)
0.0
hartken

Hello, I can begin work immediately. I require half upfront submitted through Paypal, and half upon project completion. I can have it ready in one day.

$100 USD 1 päivässä
(0 arvostelua)
0.0
pankajsingh1982

Our team can provide you best quality and Ontime [login to view URL] are new at this place but have much experienced [login to view URL] have done these types of projects can provide you details if you wana conitinue with us.

$150 USD 3 päivässä
(0 arvostelua)
0.0
Datatek

We are a delhi based ITE service pprovider company. We have experts who deals with these kind of database. We provide 99.99% accuracy. We can provide you 20 seats at a time. For more information visit us at http://www. Lisää

$300 USD 5 päivässä
(0 arvostelua)
0.0
omee

Onclick Corporation have proffesionals that can take care of your requirments. We will dedicate one proffesional on your project.

$250 USD 3 päivässä
(0 arvostelua)
3.4
davevs

see private mail please

$100 USD 2 päivässä
(0 arvostelua)
0.0
flexicode

I just finished reading the details of the project. This has got to be done by somebody who has great eye for the finest of details to prevent the slightest possibility of data loss. Understanding this I can say that i Lisää

$150 USD 7 päivässä
(0 arvostelua)
0.0
jheteam

Dearest Don, I already have this program written and I use it daily. I use MS Excel to store my leads and I have a VBA program to extract and provide me wit 10 leads per day. I can tweak it as I need to. I'd be hap Lisää

$250 USD 2 päivässä
(0 arvostelua)
0.0