Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Ruby Programming Language

making entire spread sheet as active record


hi
I want to make entire spread sheet as active record model in ruby on
rails so that i can build applications on top of that .can any one
know how to do this ?
katthi wrote:
> hi
> I want to make entire spread sheet as active record model in ruby on
> rails so that i can build applications on top of that .can any one
> know how to do this ?

Your best bet is to export the spreadsheet to a CSV, and import that CSV
into an SQLite database.  You can then use the SQLite database as Rails'
database.  For more information than that, you'd best ask on the Rails list.

--
Alex

On 5/29/07, Alex Young <a@blackkettle.org> wrote:

> katthi wrote:
> > hi
> > I want to make entire spread sheet as active record model in ruby on
> > rails so that i can build applications on top of that .can any one
> > know how to do this ?
> Your best bet is to export the spreadsheet to a CSV, and import that CSV
> into an SQLite database.  You can then use the SQLite database as Rails'
> database.  For more information than that, you'd best ask on the Rails list.

With Ruport, one of our users did something like this:

        Table("my.csv", :records => true) do |s,r|
          YourModel.create(r.to_hash)
        end

Of course, YMMV and that's a bit of a hack.  Since this has come up a
couple times, i wouldn't mind adding a more general tool either as a
Ruport plugin or in ruport-util, but I've not had a need for it, so
I'd not be the one to write it :)

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc