Completed

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

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 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 "Starting city" column (column D)

origin_state --> data located in the "Starting State" column (column E)

ship_date --> data located in the "Pickup Date" (column G), changed to the YYYY-MM-DD format

destination_city --> data located in the "Destination City" column (column I)

destination_state --> data located in the "Destination State" column (column J)

receive_date --> data located in the "Delivery Date" column (column L)

trailer_type --> data located in the "Type of Equipment" column (column A)

load_size --> data text "Full"

weight --> data located in the "Weight" column (column O)

length --> leave blank

width --> leave blank

height --> leave blank

trip_miles --> leave blank

pay_rate --> data located in the "Rate" column (column Q)

contact_phone --> leave blank

contact_name --> leave blank

tarp_required --> leave blank

comment --> data located in the "Special Information" column (column R), do not include the text starting with "P/U" and "Del:"

IE: REF#: NM75383 P/U: 09/27 19:00- Del: 09/30@06:00 1PICK-1DROP Equip: FTL 53FT VR / 1663 miles - 40K LBS ... P/U: 09/27 19:00- Del: 09/30@06:00 is not needed in that "comment" column

load_number --> data located in the "Order" column (column C)

commodity --> data located in the "Commodity" column (column B)

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: https www facebook com program beats, ah ok let me tell https www freelancer com projects graphic design need logo designed 10402492 html, https www freelancer com contest i need some graphic design 350466 html, https www freelancer com contest need a logo 437267 1 html, https www freelancer com deposit paypal milestone_amount 40&amount 40&currency 1&id 10771123&descr initial 20milestone&username, https www freelancer com hire website design h1 find a web designerbdesigner 2bfreelance, https www freelancer com projects cplusplus programming need assistance executing the o, https www freelancer com projects graphic design web design 10084111 proposals, https www freelancer com projects website design web site design 9390166, https www freelancer com r com 2fprojects 2fsql 2fanswering couple written questions about html, https www freelancer com&username quanlitysource&bidderid 9959874&refaction create_milestone, https www freelancer com web developer, https www google com eg url sa t&rct j&q &esrc s&source web&cd 1&cad rja&uact 8&ved 0ahukewin2 t0ycfmahxhpbokhy8gdcwqfggdmaa&url, . https://www.freelancer.com/projects/Mobile-Phone/Need-messaging-app-fro-IOS/#placebid, . https://www.freelancer.com/projects/Mobile-Phone/Need-messaging-app-fro-IOS, https://www.freelancer.com/contest/I-need-a-logo-designed-742331.html, write a web scraping program to display top 250 movies rated in imdb com

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

Project ID: #31645492

Awarded to:

gangabass

Thank you for the invitation! I can provide you a Perl script (WWW::Mechanize, Text::CSV_XS etc) in less than a day. Roman

$100 USD in 1 day
(595 Reviews)
7.9

7 freelancers are bidding on average $186 for this job

freelancerIrvan

Hey RACCOON :) Hello, There I am a talented python web scraper and automain specialist. I just think I almost understood your workflow. but it will be great if you let me know more detail in chat. I ensure I can handle More

$200 USD in 7 days
(2 Reviews)
3.7
PershinAlexey

✔️ Senior Expert in Web scraping with Python selenium, BS4 module... ✔️ Hi, Thanks for the opportunity to bid on your project. I read your job description carefully. Also, I am an expert in Python with 5 years of exper More

$150 USD in 2 days
(3 Reviews)
3.5
frequencyso

**raccoon** Hey there, I read all your requirements thoroughly and I'm confident I can create a script to fulfill all your needs. I understand exactly what you're trying to do: Scrape the excel spreadsheet 'DirectFrei More

$250 USD in 7 days
(1 Review)
2.0
Work12345x

Hi, I am a very talented software programmer with 12+ years of development experience (4+ years professional work experience). I am a results-oriented professional and possess experience using cutting-edge development More

$200 USD in 4 days
(2 Reviews)
1.2
MalikVykov

raccoon ^ Hi! ^ I read your job description. I'm a scraping expert, so I can deliver you perfect results you want. Let's discuss via chat. Malik.

$250 USD in 7 days
(1 Review)
1.4
(1 Review)
0.0