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

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.

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 --> data located in column (G), change 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 --> data located in column (E)

load_size --> if data in column (F) contains "Truckload" add the text "Full",

if data in column (F) contains "LTL" add the text "Partial"

weight --> leave blank

length --> data located in column (J)

width --> data located in column (K)

height --> data located in column (L)

trip_miles --> leave blank

pay_rate --> data located in column (I), if no data leave blank

contact_phone --> data located in column (N)

contact_name --> leave blank

tarp_required --> leave blank

comment --> data located in column (O), also add data located in columns (J),(K),(L)

with the first letter of the column headers before the data (ie L40-0, W8-0, H8-6)

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:


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.

Fähigkeiten: Perl, Web Scraping, Linux

Mehr darüber 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

Über den Arbeitgeber:
( 68 Bewertungen ) Chillicothe, United States

Projekt-ID: #20762523

Vergeben an:


Thank you for your invitation! I can provide you a simple Perl script that will use WWW::Mechanize and other modules to download and parse Excel file.

$88 USD in 1 Tag
(480 Bewertungen)

4 Freelancer bieten im Durchschnitt $131 für diesen Job


Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. I have done a lot of jobs with python. python scrap, pysql, python tkinter GUI etc Here is on of my scr Mehr

$155 USD in 3 Tagen
(47 Bewertungen)

Hi Dear I read your requirements carefully. I have rich experience with Python Django, Flask, selenium, Web Scrapy, software architecture and so on. You can see my good reviews for python projects. Please touch me. I w Mehr

$140 USD in 7 Tagen
(8 Bewertungen)

Dear Client, I have read your requirement in detail. We can start work immediately, and I can give you perfect result. Thanks, Regards.

$140 USD in 7 Tagen
(1 Bewertung)