Data Parsing Scape Data from Website

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