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?
DamnBigMan
(DamnBigMan@gmail.com)
February 20, 2007, 3:37pm
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
DamnBigMan
(DamnBigMan@gmail.com)
February 20, 2007, 3:57pm
3
Jodi1
(Jodi)
February 20, 2007, 4:01pm
4
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
glenn1
(glenn)
February 21, 2007, 10:11am
5
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
alex10
(alex)
February 21, 2007, 9:02pm
7
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.