Completed

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:

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: 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

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

Project ID: #20762523

Awarded to:

gangabass

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 day
(473 Reviews)
7.4

6 freelancers are bidding on average $136 for this job

polarjin2017

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 More

$155 USD in 3 days
(46 Reviews)
6.4
albertpopov46

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 More

$140 USD in 7 days
(4 Reviews)
3.5
kotalentsu

Hi there, I am a very good software programmer that you need or required as I have read your job description carefully and I am very interested in your work. I am a web developer. I have worked on web scraping, react More

$140 USD in 7 days
(5 Reviews)
3.2
Jinyi711

"raccoon"Hi, How are you? I have read your description carefully . I can fix it with perl and cron. cron is used to run unattended every 15 minutes. I am confident I can full fill your requirement. So I provide my skil More

$150 USD in 3 days
(2 Reviews)
1.4
artem127

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 days
(0 Reviews)
0.0