Completed

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:

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

Project ID: #21615205

Awarded to:

gangabass

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

19 freelancers are bidding on average $115 for this job

mantislin

Hi there, This is Lin, i did more than 380+ scraping project, please view my profile page here https://www.freelancer.com/u/mantislin.html then you will know. Can we discuss more details about your project? then i ca More

$115 USD in 3 days
(289 Reviews)
7.6
mananraja

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
(131 Reviews)
6.2
smsaurabhv

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
(64 Reviews)
5.4
raminde

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
(6 Reviews)
4.8
prakash2813

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)
5.0
Guptapuru304

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
(7 Reviews)
4.2
yashashahj1397

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
(7 Reviews)
4.0
phantom1222

"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)
4.1
irfankhokhar1986

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
(6 Reviews)
2.7
topexpert713

Hi, Nice to meet you! I have read your requirements carefully and I am very interesting for your project. I am confident of this project as I'm a professional Scraping expert with over 5 years of experience. It seems More

$140 USD in 7 days
(3 Reviews)
2.0
bmetz333

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
(2 Reviews)
2.2
lukasschenk

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)
0.0
Oshan96

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)
0.0
kozachenkodr

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

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)
0.0
CreditStar

raccoon [login to view URL] Credit is my motto. I am expert web scraping. I can do your job with BS4 ,Perl script,Scrapy Seleinum framework of python. And You can know my skill as u see my profile. I can do any project in your de More

$200 USD in 3 days
(0 Reviews)
0.0
aarchilance

raccoon Hi , this link contains scrapping results: [login to view URL] Thanks

$35 USD in 1 day
(0 Reviews)
0.0
octacer

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)
0.0