I need a web scraper written for the following url:
[login to view URL]
All information needed is available on the main page. The number of rows will vary.
The output should be a pipe (|) delimited file with the following column mappings:
origin_city --> data is located in the "Pick(s)" column before the comma
origin_state --> data is located in the "Pick(s)" column after the comma
ship_date --> data is located in the "Ship Dates(s)" column, change to the YYYY-MM-DD format, if multiple dates are listed use the first date changed to YYYY-MM-DD format
destination_city --> data is located in the "Drop(s)" column before the comma, if there are multiple cities listed, use the last one listed
destination_state --> data is located in the "Drop(s)" column after the comma, if there are multiple states listed , use the last one listed
receive_date --> leave blank
trailer_type --> data is located in the "Equip" column
load_size --> add text "Full"
weight --> data is located in the "Approx Wgt" column, if data is "Cap" leave blank
length --> leave blank
width --> leave blank
height --> leave blank
trip_miles --> data is located in the "Miles" column
pay_rate --> leave blank
contact_phone --> leave blank
contact_name --> leave blank
tarp_required --> leave blank
comment --> data is located in the "Misc" column
load_number --> leave blank
commodity --> data is located in the "Commodity" column
The first line of the output should contain all of the column headers.
Any field that contains 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:
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 specify 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.
First I know about "raccoon". I can provide you a Perl script (using WWW::Mechanize, HTML::TreeBuilder::LibXML etc) that will parse above website into pipe separated file. Thanks. Roman