Simple Scraping Script (& Operation)
$30-250 USD
Paid on delivery
I want an SQL table filled with data from this
website: [login to view URL]
This should be very simple if you know what
you're doing. It's very simple page scraping
and parsing.
I do not have the time to run the script, so
I want you to bid on writing the code and then
operating the code. YOUR DELIVERABLES WILL BE
(1) THE SQL DATABASE TABLES (IN THE FORM OF SQL
INSERT STATEMENTS FOR EASILY IMPORT INTO A NEW
DATABASE), AND (2) THE SCRIPT YOU WROTE TO
DOWNLOAD THE DATA.
In my opinion, it makes sense for the SQL tables
to look like this; but I'm open to suggestions.
TABLE: QUOTES
FIELDS: id, quote (html special chars), category
(or multiple CSV if quote is found in more than
one category), author id
TABLE: AUTHORS
FIELDS: id, name (full), bio line (e.x. 1894-1963,
British Author)
I only took a quick look at it, so that makes
sense to me. But you may have better ideas when
you take a closer look at everything.
Thanks for bidding -- I'm looking forward to
working with you!
Also, if you do this job well, I will have more
code for you to write this year.
Take care of yourself!
Will
I may not have been clear enough when I mention the deliverables above. The SQL should literally be the entire database of quotes from the site, and the schema, in a text file for easy importation into a new database.
So, I'm looking for the database tables already filled with the scraped data. Thanks again!
Project ID: #368370
About the project
Awarded to:
29 freelancers are bidding on average $126 for this job
I am experienced in data extraction. Because of the large number of webpages that needs to be downloaded over a few days, it is going to take a few days for me to complete.
This can certainly be done using VB. Please allow some days for communication, timeline difference, etc. I am ready to start IMMEDIATELY. Please refer to PM.
I've developed countless amounts of spiders used for data extraction. I'm sending you a PM with a few samples and more info