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

I need a web scraper written for the .xlsm file in the following directory:

[login to view URL]

The latest .xlsm 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 .xlsm 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

if the date is old, use the current days date changed 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 --> data located in column (M), if column contains (blank), leave blank

length --> leave blank

width --> leave blank

height --> leave blank

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.

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:
( 74 reviews ) Chillicothe, United States

Project ID: #21615205

Awarded to:


Thank you for your invitation! I know about "raccoon" and I can provide you a Perl script that will work exactly like you want.

$88 USD in 1 day
(522 Reviews)

16 freelancers are bidding on average $113 for this job


Hi there, This is Lin, i did more than 380+ scraping project, please view my profile page here then you will know. Can we discuss more details about your project? then i ca More

$115 USD in 3 days
(310 Reviews)

hi, raccoon 1) I have read your project and can make you this script. 2) I will make this script in PYTHON. 3) The script will do all the steps defined in the description. I would love to talk further in chat.

$75 USD in 1 day
(149 Reviews)

We can help u create the scrapper also can provide u with tool to manage/oraganize ur data more efficiently Have over 10 years of experience in data mining/ Web scrapping/ Scraping Bots/ Chrome/Opera Extensions I h More

$155 USD in 7 days
(9 Reviews)

Hi, I have gone through your requirement to scrape lots of websites. I am EXPERT in building scraping tools /scripts. Hence, I can SURELY work on your project. I am having 4 YEARS of EXPERIENCE in developing PHP-PYTHON More

$100 USD in 3 days
(88 Reviews)

Hello. "raccoon" I have checked all of things and very confident in your job. I suggest python or php script to make your job success. So it can be run on server or local by using cron or scheduler program. Please More

$100 USD in 7 days
(11 Reviews)

Hi there, I am java developer with 7+ years of experience in web and desktop app development. I do not have any knowledge in Perl, but I can make a automated scraper app in Java which will run on Ubuntu Linux 24/7. I h More

$200 USD in 2 days
(11 Reviews)

hi i saw you your post regarding web scraping.i have done many similar tasks like this i can make a scraper for you maybe i can add a feature like scraping particular data from website and save into excel or csv or in More

$80 USD in 7 days
(17 Reviews)

raccoon Hi! I'm senior python developer, working for 3 years now. I am expert in python automation using selenium for chrome and web scraping which I have done for sites like amazon, facebook, ebay etc. I can complet More

$100 USD in 3 days
(12 Reviews)

"raccoon" Hello, How are you? I'm very interested in your job post.I believe my skills would be ideal for your project. I have rich experience with Web Scraping and I can help you perfectly. I am Python Expert and More

$133 USD in 2 days
(5 Reviews)

Hi, Greeting of day. I m Expert Professional Full stack developer Having 8+ Years Experience ***You will just see my reviews..!!!

$30 USD in 3 days
(8 Reviews)

I'm WEB Scraping Expert and I'm ready to start right now. Please check following urls. I've done that project perfectly. [login to view URL] https://do More

$140 USD in 7 days
(3 Reviews)

Hi Sir, Its Hisham. I am Software Engg. with more than 3 years of market experience. I have developed many web and cloud based solutions for my clients. I have been developing solutions ASP .NET since start of my caree More

$140 USD in 7 days
(0 Reviews)

downloading the file is trivial. than parsing the xlsm file with perl should be easy task. i can complete this in a day

$35 USD in 1 day
(0 Reviews)

Raccoon We are a well experienced web scraping/data mining team and will deliver a PYTHON script that will give the pipe delimited output file. Thank you! Feel free to contact me so we can discuss more about the requir More

$166 USD in 2 days
(0 Reviews)

raccoon, Hi, I would like to complete this script in python, In one day. I have around 5 years of working experience on web scrapping tools, like nutch and scrapy, If you want to see demo please put a message.

$150 USD in 1 day
(0 Reviews)