>> Back to NSBS Home


Case Study 6: Extract Product Catalog Data From B2B Website
 
A small business needs to be able to extract an entire product catalog from a business to business websites and save it to an Access Database. It requires that the database is periodically updated with the latest inventory numbers from each warehouse. The information to extract consists of product description, detailed description, factory number, UPC number, price, MSRP, product category and inventory numbers. Images of each product also need to be downloaded to a local directory.
 

 

Newbie Scripts were developed to read input data from an Excel file, login to the B2B website and navigate to each product catalog page. The data was extract one product at a time.
 

Images of each product were downloaded to a user specified local directory.
 

The extracted data is saved to an Access Database.
 
Copyright © 2007 Newbie. All Rights Reserved • ©2007 Microsoft Corporation. Windows Vista is a registered trademark of Microsoft Corporation.