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,
41 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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.