Завершено

Need a web spider scraping program written for the following username WING8224BG

I need a web scraper written for the .xlsx file in the following directory:

[url removed, login to view]

The latest .xlsx file within that directory will need to be downloaded.

The name of the file is subject to change daily and will need to be identified by the latest .xlsx extension.

The output should be a pipe (|) delimited file with the following column mappings:

origin_city --> data located in column "C", data starts on the row below the column header "Pick City"

origin_state --> data located in column "D", data starts on the row below the column header "State"

ship_date --> the date from column "A" changed to the YYYY-MM-DD format, data starts on the row below the column header "Date"

destination_city --> data located in column "E", data starts on the row below the column header "Drop City"

destination_state --> data located in column "F", data starts on the row below the column header "State"

receive_date --> leave blank

trailer_type --> data located in column "G", data starts on the row below the column header "Equip"

load_size --> put the text "Full"

weight --> data located in column "I", data starts on the row below the column header "Weight"

length --> leave blank

width --> leave blank

height --> leave blank

trip_miles --> leave blank

pay_rate --> leave blank

contact_phone --> leave blank

contact_name --> leave blank

tarp_required --> leave blank

comment --> data located in column "H", data starts on the row below the column header "Comments"

load_number --> leave blank

commodity --> leave blank

The first line of the output should contain all of the column headers.

Any field that contain no data should be left blank.

Please do not use words like "null" or "blank" in blank columns.

Below is a sample output of the first 5 columns using sample data:

origin_city|origin_state|ship_date|destination_city|destination_state|

chicago|IL|2017-03-15|new york|NY|

kansas city|MO|2017-03-15|houston|TX|

The deliverable will be a Perl .pl file that must run on

Ubuntu Linux and must use Modern::Perl. The Perl .pl file

should be called '[url removed, login to view]' and the output file should be

called '[url removed, login to view]'

It will be scheduled in cron to run unattended every 15 minutes.

Please specific what language/OS/modules you plan to use.

Also, please include the word "raccoon" in your bid so I know that

you read this description.

Квалификация: Linux, Perl, Веб-скрейпинг

Показать больше crawl a website for pages, website crawler python, best open source web crawler, free web crawler for mac, octoparse, web crawler tool free, seo crawler tool, online web crawler spider, i need a developer to help develop a web based software program i will provide full project details once you place a placeholder, need web program, need program written website, need program written, web scraping program, software experience need web designer, web spider crawling website robot vbnet, web spider source, need web site, web spider development, clickbank need web site, write web spider

О работодателе:
( 55 отзыв(-а, -ов) ) Chillicothe, United States

ID проекта: #16307104

Поручен:

gangabass

I can create same scraper as I did before: Perl + WWW::Mechanize etc (with same output). Thanks. Roman

$88 USD за 1 день
(372 отзывов(-а))
7.0

5 фрилансеров(-а) в среднем готовы выполнить эту работу за $164

Webxpert4u

Hello, I am ready to create tool to extract data from given directory, [login to view URL] Lets chat. Python Tool- [login to view URL] Больше

$250 USD за 4 дней(-я)
(92 отзывов(-а))
6.9
akthar0025

Hello Sir I read your requirements and understand very-well and ready to start work from now. Let's discuss more about project in chat. Thank you My main skills include: • Data Entry • Data management • web scra Больше

$30 USD за 3 дней(-я)
(2 отзывов(-а))
1.6
ChanakyaNaag

raccoon Hey there! I have read your description and would love to work on this project. The sites i have developed a bot for include Linkedin, Tinder, Facebook, Gmail, Okcupid, Outlook and many more. I us Больше

$200 USD за 2 дней(-я)
(1 отзыв)
1.0
whitehorsetechn

Greeting, I have understood your Need a web spider scraping program written for the following username WING8224BG task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more t Больше

$250 USD за 3 дней(-я)
(0 отзывов(-а))
0.0