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
I am an Engineering Graduate from JAWAHARLAL NEHRU TECHNOLOGICAL
UNIVERSITY Andhra Pradesh, India.
Furthermore, I am genuinely interested to become an asset of your esteemed organisation.
Why You should hire me? Because, this project fits under my expertise.
And i am looking to work with you for 12- 15 hours a day, to produced an accurate n neat work on time.
And iam gonna charge as per your terms.
THERE IS NO LIMIT TO HOW MUCH ONE CAN GROW HERE.
LOOKING FOR ALL YOUR FUTURE PROJECTS.
I already worked with same kind of projects, with INFORMATION PACKAGING COMPANY, AUS.
This really fits under my expertise.
Desperate to start rite from 2day.
Hi, Please try me I promise I'll give you 200% satisfaction in this work.I Work with my pc the whole day since I was in school.I know harwares , softwares and lots
i am well versed with Access data base, after going thru the details of the project, i found that it is kind of data processing, not exactly data entry, some minor typing for modifications once data is transferred to data base, still it is hard to make real estimate for the price, as i dont know how much data in each files is present, and how much modifications will have to be made, but yes my rough estimate on lower side is 300$
I can do it quickly with help of some tools, I did it many times, however since the total file is quite big please compress in .zip divided into 4-5 files maybe 30files/zip file, I have a ftp site and DSL connection. I also need to build up my first portfolio :) Thanks - Donny
Just finished a similar project. I would be glad to do this for you. It can be written in visual basic so that you can later customize your imports with very little effort (drop down combos/file tree) or help from anyone else. Can be done to your satisfaction.
Thank you, Gary