How to Get data from Web Page to Database.

Hi,

I want to get the details from a table which is displayed on a Web
page into the Database.

How to read that Web page ? I mean if there is table Student details
like Roll no., name etc.

And I want to read that table & store it into my database in table
My_Student. How to do this?

If you want to do this with rails it would be easier to design your
tables using ActiveRecord.

http://api.rubyonrails.com/

This might also give you an idea of how to start

http://www.onlamp.com/pub/a/onlamp/2005/01/20/rails.html

This one might be helpful as well

http://rails.raaum.org/activerecord.html

Manohar - if I understand your question, you want to webscrape and put
the data in db?

if so this article explores different means to that end:
http://www.rubyrailways.com/data-extraction-for-web-20-screen-scraping-in-rubyrails

Jodi

This might be of assistance:

http://www.igvita.com/blog/2007/02/04/ruby-screen-scraper-in-60-seconds/

Glenn

Jodi wrote:

Hi,

I want to get the details from a table which is displayed on a Web
page into the Database.

How to read that Web page ? I mean if there is table Student details
like Roll no., name etc.

You could also check out scRUBYt!, a web scraping framework based on Hpricot and WWW::Mechanize:

http://scrubyt.org

Cheers,
Peter

It can be easily done with SWExplorerAutomation from http://webiussoft.com
SWEA Visual Data Extractors allow to define the table structure and
return data in DataTable object. The SWEA API can be used from .Net
or from Ruby using RubyCLR.