Annulé

Finish Web Scraper

Current LinkedIn_Scraper scrapes employee info from [url removed, login to view] and outputs in file.

Source code and scraper attached.

To run scraper, run as administrator then:

1. In website box put:

[url removed, login to view]

2. In Folder box select your output folder destination

3. In ID put: 1st Constitution Bank

4. Click "Scrap"

A csv file is put in your output folder when scrape completed

Next stage needed:

1 Job Titles

Find matches in column "designation" of output file with column A of file [url removed, login to view] attached.

If match found, put text in Column B of [url removed, login to view] into col H of output file

If 2 matches found, put 2nd match in col I of output file

If 3 matches found, put 3rd match in col J of output file

If 4 matches found, put 4th match in col K of output file

If no match found put text "Officer" in col H of output file

2 Departents for Search All

Find matches in column "designation" of output file with column A of file [url removed, login to view] attached.

If match found, put text in Column C of Columns [url removed, login to view] into col L of output file

If 2 matches found, put 2nd match in col M of output file

If 3 matches found, put 3rd match in col N of output file

If 4 matches found, put 4th match in col O of output file

If no match found leave empty

3 Departments

Find matches in column "designation" of output file with column A of file [url removed, login to view] attached.

If match found, put text in Column C of Columns [url removed, login to view] into col P of output file

If 2 matches found, put 2nd match in col Q of output file

If 3 matches found, put 3rd match in col R of output file

If 4 matches found, put 4th match in col S of output file

If no match found leave empty

Exception:

If match found with designation and column A of [url removed, login to view] AND match found with designation and

column A of [url removed, login to view] then ignore match

4 Sector

Find matches in column "designation" of output file with column A of file [url removed, login to view] attached.

If match found, put text in Column B of Columns [url removed, login to view] into col T of output file

If 2 matches found, put 2nd match in col U of output file

If 3 matches found, put 3rd match in col V of output file

If 4 matches found, put 4th match in col W of output file

If 5 matches found, put 5th match in col X of output file

If 6 matches found, put 6th match in col Y of output file

If 7 matches found, put 7th match in col Z of output file

If 8 matches found, put 8th match in col AA of output file

If 9 matches found, put 9th match in col AB of output file

If 10 matches found, put 10th match in col AC of output file

If no match found leave empty

5 Job Title Grouping

In column AD of output file put text found in columns H, I , J, K separated by "/"

eg: text/text/text/text

If any of columns I, J, K are empty do not include and do not display the "/"

If column I matches column H do not display

If column J matches column H or I do not display

If column K matches column H, I or J do not display

If col I matches col A in [url removed, login to view] and any of col J, K or L matches col B in [url removed, login to view] then display col B from [url removed, login to view] in col T of output file

6 Department Grouping

In column AE of output file put text found in columns P, Q, R, S separated by "/"

eg: text/text/text/text

If any of columns L, M, N, O are empty do not include and do not display the "/"

If column M matches column L do not display

If column N matches column L or M do not display

If column O matches column L, M or N do not display

7 Search All Grouping

In column AF of output file put text found in columns L, M, N, O, T, U, V, W, X, Y, Z, AA, AB, AC, AD, AE separated by "/"

eg: text/text/text/text

If any of columns T, U, V, W, X, Y, Z, AA, AB, AC, AD, AE are empty do not include and do not display the "/"

8 Inserting into excel

Go to worksheet "contacts" of file banking_market(3).xls (this excel file will be already open)
In column A search for ID given in scraper search
If same last name exists in excel file and scraped data delete that contact from the excel file

(with one exception: if column "Management" is not empty for the excel contact then keep the excel contact and delete the
contact with same last name from scraped data)

Scroll down to 2nd last contact of that bank
Insert the correct amount of rows
Copy and paste First Name and Last Name from scraped data into excel columns First Name and Last Name
Copy and paste col AD of scraped results into column Job Title of excel file
Copy and paste Col AE of scraped results into column Department of excel file
Copy and paste col AF of scraped results into column Search All of Excel file
For column Email in excel file, copy the format for 2nd last contact for all inserted rows
For columns Bank, Bank Type, Address 1 - 3, City Suburb, State, Postcode, Country, Region, Telephone copy the same as for 2nd last contact
Do not save the excel file - leave open

Compétences : .NET, Web Scraping

Voir plus : lead scraper web design, screen scraper web page betting, scraper web app, macro scraper web, web data scrap csv software, web data scrap csv, scraper web free vba, web scraper web crawler, web scraper web control, scraper web, java screen scraper web page, google scraper web sites, net scraper web page, screen scraper web crawler, export parts site scraper web, screen scraper web page excel, scraper web access, refreshing web page click buttpn, vba web button click, landing page click bank, set product click bank shopping cart, click bank thank page example, need website post click bank, web page click button access, shopping carts work click bank

Concernant l'employeur :
( 56 commentaires ) ddndfgnfgn, Ukraine

N° du projet : #12663265

13 freelance ont fait une offre moyenne de 165 $ pour ce travail

mantislin

Dear sir, I am scraping expert, I have did too many scraping projects, please check my reviews then you will know. Can you tell me more details? then I will provide example data/script for you. Thanks, Plus

142 $ USD en 3 jours
(145 Commentaires)
7.0
ATLASFSD

A proposal has not yet been provided

155 $ USD en 3 jours
(18 Commentaires)
4.7
cyborgsysz

** We have worked on lots of web scrapping projects, we have expertise in following technologies. Microsoft Technologies (Windows Azure,.Net, C#,VB.Net, ASP.net, Win Forms Applications, MS SQL Server,) Android App Plus

225 $ USD en 3 jours
(3 Commentaires)
4.4
Angel521

Hi. 99.99999% Completion Rate!!! I am a new freelancer but i am expert programing. I am an expert of web scrapping. I have done these works for several years and get good reviews as you can see on my skills. "Corre Plus

333 $ USD en 3 jours
(4 Commentaires)
4.4
adilhussain0411

Hello, My name is Mehnaz Bashir, and i have gone through job description and i am sure i can complete your task with 100% Good quality and within Deadlines. Sincerely hope that I will get a good chance to make this w Plus

40 $ USD en 3 jours
(3 Commentaires)
3.5
smithangshu

Hello, I am an expert in C#.NET, VB .NET , C# and VB Desktop application, MSSQL, MySQL etc and still learning new things everyday. I am acquiring experience since last 5 years. Successfully did several high value proje Plus

250 $ USD en 3 jours
(2 Commentaires)
2.9
sachinandure

Hello, I am a web developer having 8 years of experience working on Microsoft technologies. I am available to work fulltime(40hr/wk). I can work on web as well as desktop applications in C#/vb.net. I am able to comm Plus

155 $ USD en 6 jours
(2 Commentaires)
2.2
masterlancer999

Hi I am very experienced in web scraping tool development using C# I have completed many web scraping tools Please message me Regards

222 $ USD en 2 jours
(1 Commentaire)
0.0
mandavcon

HI I am glad to offer you my services as a Sr. software developer. I am working in the software industry for last 6 years. During my career I have worked with few very good companies in this industry and learn and Plus

155 $ USD en 3 jours
(0 Commentaires)
0.0
177 $ USD en 2 jours
(0 Commentaires)
0.0
35 $ USD en 3 jours
(0 Commentaires)
0.0
arkdotnetec12

Dear Sir, WE ARE SPECIALIZED IN .NET AND WEB SCRAPING We are dynamic and energetic group of professionals. We value our customers and are committed to delivering high quality results that make our customers feel conf Plus

100 $ USD en 3 jours
(0 Commentaires)
0.0
BellalHossain333

"Rate and duration will be fixed on discussion" Greetings, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several pro Plus

222 $ USD en 3 jours
(0 Commentaires)
0.0
Besst

HELLO------ Your request looks feasible and interesting for development for us... We have just started working with Freelancer. However, we have a good experience with a few Clients in the UK, USA, Australia, Isr Plus

155 $ USD en 3 jours
(0 Commentaires)
0.0