Find Jobs
Hire Freelancers

Write a script that downloads two CSV files from a webpage and loads them into a SQL database

$10-30 USD

Cancelled
Posted about 7 years ago

$10-30 USD

Paid on delivery
I need a shell script that downloads from the following page: [login to view URL] The following files: [login to view URL] [login to view URL] And then loads the files into a database using the following commands: For [login to view URL] : mariadb dispos_db -e "load data local infile '$file ' replace into table filings fields terminated by '\t' lines terminated by '\n' ignore 1 lines (rundate, cdi, cas, fda, ins, cad, crt, cst, dst, bam, curr_off, curr_off_lit, curr_l_d, nda, cnc, rea, def_nam, def_spn, def_rac, def_sex, def_dob, def_stnum, def_stnam, def_cty, def_st, def_zip, aty_nam, aty_spn, aty_coc, aty_coc_lit, def_birthplace, def_uscitizen);" For [login to view URL] mariadb dispos_db -e "load data local infile '$file' ignore into table dispos fields terminated by '\t' lines terminated by '\n' ignore 1 lines (rundate, cdi, cas, fda, ins, cad, crt, cst, dst, bam, curr_off, curr_off_lit, curr_l_d, nda, cnc, rea, def_nam, def_spn, def_rac, def_sex, def_dob, def_stnum, def_stnam, def_cty, def_st, def_zip, aty_nam, aty_spn, aty_coc, aty_coc_lit , dispdt, disposition, sentence, comp_nam, comp_agency, off_rpt_num);"
Project ID: 13849642

About the project

9 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
9 freelancers are bidding on average $44 USD for this job
User Avatar
Hi sir, This is kimi and I am scraping expert, I have did too many scraping projects, please check my profile page then you will know. https://www.freelancer.com/u/mantislin.html Can you tell me more details? then I will provide example data/script for you. Thanks, Kimi
$38 USD in 1 day
5.0 (143 reviews)
6.9
6.9
User Avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$100 USD in 3 days
5.0 (2 reviews)
2.5
2.5
User Avatar
Dear Client, Your job posting catches my attention and I submit the proposal as a desired candidate. I'm a full time freelancer experienced in Lead Generation, Virtual Assistant, PDF conversation, Social Media Marketing, Data entry, Web research,MS excel, MS word, MS Powerpoint Presenation, Google docs, Adobe Photoshop. My typing speed is 45 wpm. I'm reliable, highly organized, dedicated, detail-oriented and have positive attitude. I can offer affordable, fair rate and high quality of work. My goal is to complete any task on time and to develop a long term relationship with my clients. Waiting for your reply soon. Thanks, Emamul Hassan
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, We are a globalized software services organization specialized in providing Web, Mobile, ECommerce and Social media frameworks using cutting edge and emerging technology. We have worked on many web application projects including WordPress, Prestashop and Magento based e-commerce websites for our clients in the past. We have professionals experienced in back-end technologies including node.js, PHP, J2EE etc as well as front-end technologies including HTML, Javascript, AJAX, Dojo, bootstrap etc. We've done a number of web scraping projects for our clients. We have scraped many directory websites including yellowpages, yelp and e-commerce websites including amazon, walmart etc and many more. We can deliver the data very quickly. We use proxies with IP rotation to avoid being detected as bots. We use python with wget, phantomjs, casperjs, slimerjs, scrapy, urllib and other tools to fetch webpages and parsers like HtmlXPathSelector, regular expressions etc to extract information from the html. We have the right skill set to do this job effectively and within time and would like to discuss more about this opportunity. Looking forward to hear from you. Thanks, Rajdeep Agrawal
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Assalamualaikum. i can do this job properly. I have more experience with this task. Please check my another profile. I am very much Familiar with this work. Recently i have done a project like this. I will do this with fast and 100% accuracy. And plz see my profile. I hope i will get a chance to work with you. Just message me for mores details. Thank you
$25 USD in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
Hi, I'm very familiar with Linux shell scripting, and am responsible to develop scripts to back the database, load log entries to database in format of txt files. let me help you.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Houston, United States
5.0
11
Payment method verified
Member since Feb 14, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.