Guess emails using database
$30-250 USD
Pagado a la entrega
This job can be done with EXCEL / ACCESS. Eventually you can propose some others options.
We have a database of names + email (tab DB1). It's only example on the file attached. I have 20000 emails in the real file.
We have another database only with names (tab DB2). Also several thousands of names to update.
We want an algorythm to rebuild the email in 2nd database, using data from 1st.
Algo should work like this:
1. Read the lines from DB2 tab without emails and look for the matching based on Company name
2. Exclude domains from a specific list of emails provider (yahoo, hotmail, orange, gmail ... ). This domains are listed in TAB3 but possible to add more.
3. Check the format of the email based on the EMAIL TYPE tab (12 formats) and exclude the emails not matching with one of the format including information from 1ST NAME and the NAME. If the email doesn't match with a format, don't use it.
4. Count the number of format by domain and keep only the one with the more recurrences.
5. Generate emails using the 1ST NAME and the NAME from DB2 tab based on format.
Then restart the process with lines still without email with this 1st step
1. Read the lines from DB2 tab without emails and look for the matching based on telephone
Then restart the process with lines still without email with this 1st step
1. Read the lines from DB2 tab without emails and look for the matching based on Address
PS: password for the zip file is freelancer
Nº del proyecto: #13346791
Sobre el proyecto
Adjudicado a:
Hello there, my name is Daniel and I would love to help you out with your project. I have a lot of experience developing algorithms for data processing so I know I can be a very valuable asset for your project. I have Más
28 freelancers están ofertando un promedio de $176 por este trabajo
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Más
Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and wit Más
Hi, I'm a professional Ms Access and VBA developer with strong background in developing and implementing information systems with databases from scratch. I have read your project description and I'll be glad to assist Más
Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and Más
Hello, Check our profile we have 100 % completion rate with on time delivery . We have expert developers here and they are fast so you will have guaranteed delivery on time . We also worked on penalty for late deliver Más
Sir, this can be done using Excel macro. We can connect any database in Excel using ODBC and even pull out data from websheets. I am confident about this project. But I am new in freelancer. If your company is a verifi Más
View online portfolio at http://www.jeannettecooley.com. Reviewed project specifications and can complete the project within the three days allocated.
As i'm experienced in DB design and developing, and as i worked before for more than 5 years in access and VBA , it's my pleasure to bid on your project. and i guarantee that you will like my final work.
