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? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
DamnBigMan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
2007-Feb-20 15:37 UTC
Re: How to Get data from Web Page to Database.
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" <amrutkar.mano...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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?--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
DamnBigMan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
2007-Feb-20 15:57 UTC
Re: How to Get data from Web Page to Database.
This one might be helpful as well http://rails.raaum.org/activerecord.html On Feb 20, 8:37 am, "DamnBig...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org" <DamnBig...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> 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" <amrutkar.mano...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > 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?--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Feb 20, 9:51 am, "manohar amrutkar" <amrutkar.mano...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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. http://www.regdeveloper.co.uk/2006/07/03/ruby_rails_part1/ http://www.regdeveloper.co.uk/2006/07/17/ruby_rails_part2/ -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Feb 20, 2:51 pm, "manohar amrutkar" <amrutkar.mano...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Jodi wrote:> > > On Feb 20, 9:51 am, "manohar amrutkar" <amrutkar.mano...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > 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 __ 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. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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" <amrutkar.mano...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi, > > I want to get the details from a table which is displayed on aWeb > page into the Database. > > How to read thatWebpage ? 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?--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---