Scrape some products from a website into a sql database.
Website URL[
[login to view URL]][1]
[[login to view URL]][2]
## Deliverables
Data to collect
<[login to view URL]>
Put products into sql tables.
**One is a category table
**Category Name CategoryId ParentId
Juki Parent 1 0
Model List 2 1
Item List 3 1
LockstitchMachine 4 2
Etc.
**Then a products table.
**ProductId: [DLN-9010][3]
ShortDescription: Direct-drive, High-speed, Needle-feed, Lockstitch Machine with Automatic Thread Trimmer
MovieUrl [[login to view URL]][4] (If possible download to my server)
LongDescription:Follow Hyperling and collect the html into this field <[login to view URL]>
**Then a Category Members Table
**If DLN-9010 is a LockstitchMachine Machine
In the above example LockstitchMachine is cat #4
Then the table would look like this
ProductID CategoryID
[DLN-9010][3], 4
Products may be in more than one category.
Next scrape these like above.
<[login to view URL]>
**Next created a pdf table from these urls**
<[login to view URL]>
<[login to view URL]>
<[login to view URL]>
EXAMPLE
[DLN-9010][3] WOULD HAVE TWO MANUALS OUT OF THE THREE URLS
CATALOG PDF URL:
<[login to view URL]>[][5]
MANUAL PDF URL:
HANDBOOK PDF URL:
<[login to view URL]>
PDFS WILL NEED TO BE DOWNLOADED AS WELL
## Platform
windows 2003
windows 2000