I want an SQL table filled with data from this
website: [url removed, login to view]
This should be very simple if you know what
you're doing. It's very simple page scraping
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.
FIELDS: id, quote (html special chars), category
(or multiple CSV if quote is found in more than
one category), author id
FIELDS: id, name (full), bio line (e.x. 1894-1963,
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!
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!
31 pekerja bebas membida secara purata $123 untuk pekerjaan ini
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.