Completed

Need an updated web spider scraping program written for the following username JLM8203

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

[login to view URL]

The latest .xls 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 .xls extension.

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

origin_city --> data located in column "A"

origin_state --> data located in column "B"

ship_date --> the date from column "E" changed to the YYYY-MM-DD format

destination_city --> data located in column "C"

destination_state --> data located in column "D"

receive_date --> leave blank

trailer_type --> the abbreviation located in column "F"

load_size --> add text "FULL"

weight --> data located in column "K"

length --> data located in column "J"

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 --> leave blank

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 '[login to view URL]' and the output file should be

called '[login to view URL]'

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.

Skills: Perl, Web Scraping, Linux

See more: write web spider, web spider development, need end web designer, web spider source, web spider crawling website robot vbnet, need adult web designer right, web spider collect data, email scraping program, need magento web designer, build program written, game dont need flash web, need create web community, web spider free mysql, web spider source code, web scraping program, need program written, daily updated web scraping, need program written website, i need a developer to help develop a web based software program i will provide full project details once you place a placeholder

About the Employer:
( 74 reviews ) Chillicothe, United States

Project ID: #25450579

Awarded to:

gangabass

I can provide you Perl script that will work with above website using WWW::Mechanize and other modules. Thanks. Roman

$88 USD in 1 day
(522 Reviews)
7.6

3 freelancers are bidding on average $148 for this job

AHMEDAMER232

raccoon Dear Hiring Manager! I'm very confident of your project. I can complete your project in 1 day. 1. My scraping works and experience I have 9 years of experience in web scraping and scraped so many many websit More

$200 USD in 1 day
(27 Reviews)
4.1
nemanjadj20

Hello? I have worked on Python/Flask app, Scrap and other projects to what you are looking for, and I am confident I can exceed your expectations. Thank you for your time. I have attached samples of work very simila More

$155 USD in 3 days
(1 Review)
2.7