Ditutup

Write some Software

Basically, I have a list of people and I need an automated process to find their location. I have an Access Database (that can be easily converted to Excel) which has tens of thousands of contacts., all of whom I know have LinkedIn Profiles. Most of these contacts have the person's city, but about 30,000 do not. I need a process to automatically fill in these missing locations. I have quite a bit of data on each person including First, Last, Title and company.

I need a formula, macro or Power Query or Microsoft Power BI to search the person's first and last name and either title or company in order to make sure it's the right person on Google (or another search engine), and return the city in the database. For instance, if Power Query searched their first, last and title and "linkedin", the first result should be their linkedin profile, and their location will be listed in that search result. I need it to scrape this location data and return it to the sheet.

I need this to be:

1. Powerful enough to go through tens of thousands of entries and not get flagged by Google (or however it searches the web) as a bot

2. Repeatable on any similar list in the future

I'm not sure if this is possible to do this or not, so please do not accept this job if you don't already know how to do this. I don't want to waste anyone's time!

Keahlian Excel, Microsoft Access, SQL

Lihat lebih lanjut: software write content for the latest keyword, write some software - outlook add-in for integration into connectwise, software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, lisp water profile excel sheet, software book writer satish jain profile, software write protection, free software write book, software write book, write magnetic online dating profile, software write protect software, software write technical manual

Tentang Pemberi kerja:
( 4 ulasan ) San Diego, United States

ID Proyek: #11736135

24 freelancer menawar pada rata-rata $469 untuk pekerjaan ini

fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Lagi

$526 USD dalam 10 hari
(70 Ulasan)
6.9
BDtW

Hello, Thank you for posting your project here and for the clear description. I scrape data from the web and I use Selenium with Python or VB.NET for building the scrapers. Your project seems interesting enough Lagi

$255 USD dalam 6 hari
(27 Ulasan)
4.5
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ Lagi

$250 USD dalam 7 hari
(15 Ulasan)
3.7
royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Lagi

$250 USD dalam 6 hari
(15 Ulasan)
3.9
$250 USD dalam 7 hari
(2 Ulasan)
2.9
$750 USD dalam 20 hari
(1 Ulasan)
3.0
$333 USD dalam 10 hari
(1 Ulasan)
1.7
$555 USD dalam 10 hari
(1 Ulasan)
1.9
$250 USD dalam 10 hari
(1 Ulasan)
0.6
jakubaksamit

Hi there, I'm working in one of the biggest companies in the world as Reporting Specialist doing exactly the same job you are looking for. I have macro already created for this kind of stuff. Done this many times Lagi

$555 USD dalam 5 hari
(0 Ulasan)
0.0
HawkHouseInt

Hello. Our company exists since 2014 and at the moment we are aimed on expansion abroad. We have already implemented more than 70 projects in Russia and CIS. And we are ready to take new projects and execute them on ti Lagi

$777 USD dalam 12 hari
(0 Ulasan)
0.0
HKhayat

Hi... Although I am a new freelancer, I have ab advanced practical experience in design and develop Access databases, including queries, forms and reports. My offer is a free week to test the project and informe me o Lagi

$250 USD dalam 1 hari
(0 Ulasan)
0.0
gasolanki

A proposal has not yet been provided

$277 USD dalam 5 hari
(0 Ulasan)
0.0
extreamcode

Hi, I can assist you with this project. Here is a sampling of the few of my work contained at my portfolio: [url removed, login to view] Please reply back so we can discuss. Regards, DT

$555 USD dalam 10 hari
(0 Ulasan)
3.8
AleenaIlyas

Hello I have read what you exactly need. However, I would like to ask you a few questions. I do work in a smart way and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detaile Lagi

$555 USD dalam 10 hari
(0 Ulasan)
0.0
proavinash

Please provide the data so that i can pursue the work

$500 USD dalam 10 hari
(0 Ulasan)
0.0
jurivtorov

A proposal has not yet been provided

$555 USD dalam 10 hari
(0 Ulasan)
0.0
MECHATRONS

Hello,We are a team of developers and do all work related to computer science( Software Engineering ),. We have experience in , JAVA,C# ,My SQL , website Design( wordpress ,PHP), Excel, ( vb ,(macro)), Research( biolog Lagi

$333 USD dalam 6 hari
(0 Ulasan)
0.0
nanangwibisono

i'm very familiar with macro excel, vba, visual basic, access database, and other spreadsheet data manipulation with fastest solution

$250 USD dalam 5 hari
(0 Ulasan)
0.0
thomaspaquin

I'll be completely honest, I've never done this before. But, I will say, you've got me hooked on this problem. if you don't select me for the job, I'm going to solve it anyway :) Hope you have a good weekend! Let me Lagi

$600 USD dalam 5 hari
(0 Ulasan)
0.0