Need an updated web spider scraping program written for the following username ZMAC4151 -- 3
Budget: $30 – $250 USD
I need an updated web scraper written for the .xlsx file in the following directory:
https://www.directfreight.com/emails/UV3Y712XQ2M31PJG/
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 the "Origin City" column
origin_state --> data located in the "Origin State" column
ship_date --> data located in the "Ship Date" column, change to the YYYY-MM-DD format
destination_city --> data located in the "Destination City" column
destination_state --> data located in the "Destination State" column
receive_date --> leave blank
trailer_type --> data located in the "Trailer Type" column
load_size --> data located in the "Loads Size" column if data is "Truckload" add the text "Full", if data is "LTL" add the text "Partial"
weight --> data located in the "Weight" column
length --> data located in the "Length" column, the "-" and data after the "-" is not needed
width --> data located in the "Width" column, the "-" and data after the "-" is not needed
height --> data located in the "Height" column, the "-" and data after the "-" is not needed
trip_miles --> leave blank
pay_rate --> data located in the "Pay Rate" column, if there is no data, leave blank
contact_phone --> data located in the "Phone Number" column
contact_name --> leave blank
tarp_required --> leave blank
comment --> data located in the "Comments" column
load_number --> leave blank
commodity --> leave blank
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:
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 'ZMAC4151.pl' and the output file should be
called 'ZMAC4151.pipeSV'
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.
https://www.directfreight.com/emails/UV3Y712XQ2M31PJG/
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 the "Origin City" column
origin_state --> data located in the "Origin State" column
ship_date --> data located in the "Ship Date" column, change to the YYYY-MM-DD format
destination_city --> data located in the "Destination City" column
destination_state --> data located in the "Destination State" column
receive_date --> leave blank
trailer_type --> data located in the "Trailer Type" column
load_size --> data located in the "Loads Size" column if data is "Truckload" add the text "Full", if data is "LTL" add the text "Partial"
weight --> data located in the "Weight" column
length --> data located in the "Length" column, the "-" and data after the "-" is not needed
width --> data located in the "Width" column, the "-" and data after the "-" is not needed
height --> data located in the "Height" column, the "-" and data after the "-" is not needed
trip_miles --> leave blank
pay_rate --> data located in the "Pay Rate" column, if there is no data, leave blank
contact_phone --> data located in the "Phone Number" column
contact_name --> leave blank
tarp_required --> leave blank
comment --> data located in the "Comments" column
load_number --> leave blank
commodity --> leave blank
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:
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 'ZMAC4151.pl' and the output file should be
called 'ZMAC4151.pipeSV'
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.