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

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.