I need a web scraper written for the .xlsx file in the following directory:
[login to view URL]
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.
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 located in Column B
origin_state --> data located in Column C
ship_date --> data located in Column A, change to the YYYY-MM-DD format
destination_city --> data located in Column D
destination_state --> data located in Column E
receive_date --> leave blank
trailer_type --> data located in Column F
load_size --> data located in Column G
weight --> data located in Column O, add three zeros to the end of the
data if there are only 2 numbers (ie. 48 = 48000)
length --> data located in Column N
width --> leave blank
height --> leave blank
trip_miles --> data located in Column H
pay_rate --> data located in Column M
contact_phone --> leave blank
contact_name --> add data from Columns J & K
tarp_required --> leave blank
comment --> data located in Column L
load_number --> leave blank
commodity --> data located in Column I
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 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.
14 freelancere byder i gennemsnit $165 på dette job
Hello, ###raccoon I'm a python developer with a lot of experience in web scraping. I will do it using python requests module and it can be run on any OS, Please contact me over chat to discuss more. Best regards.