Κλειστη

Finish Scraper - open to bidding

Αυτό το πρότζεκτ έλαβε 15 προσφορές από ταλαντούχους freelancers με μέση τιμή προσφοράς $127 USD.

Λάβετε δωρεάν αναφορές για ένα πρότζεκτ σαν αυτό
Εργασία Εργοδότη
Προϋπολογισμός Εργασίας
$30 - $250 USD
Σύνολο Προσφορών
15
Περιγραφή Εργασίας

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 "/"

Ψάχνετε τρόπους για να κερδίσετε μερικά χρήματα;

  • Ορίστε τον προϋπολογισμό σας και το χρονικό πλαίσιο
  • Περιγράψτε την πρότασή σας
  • Πληρωθείτε για τη δουλειά σας

Προσλάβετε Freelancers που ήδη έχουν υποβάλει προσφορά σε αυτή την εργασία

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online