How to Get data from Web Page to Database

#1

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?

#2

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

On Feb 20, 7:51 am, “manohar amrutkar” removed_email_address@domain.invalid

#3

manohar amrutkar 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.

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

Use the CRUD scaffolding feature of Ruby on Rails to store, update.
delete database records.

#4

This one might be helpful as well

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

On Feb 20, 8:37 am, “removed_email_address@domain.invalid” removed_email_address@domain.invalid

#5

On Feb 20, 9:51 am, “manohar amrutkar” removed_email_address@domain.invalid
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.

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

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

#6

On Feb 20, 2:51 pm, “manohar amrutkar” removed_email_address@domain.invalid
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.

This might be of assistance:

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

Glenn

#7

Jodi wrote:

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

__
http://www.rubyrailways.com :: Ruby and Web2.0 blog
http://scrubyt.org :: Ruby web scraping framework
http://rubykitchensink.ca/ :: The indexed archive of all things Ruby.

#8

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.

On Feb 20, 9:51 am, “manohar amrutkar” removed_email_address@domain.invalid