Is there any form to migrate an Excel table(which becomes from Access)to Rails? I have the models with scaffolds, but I would like to have all the data with only a migration.
John Smith wrote:
Is there any form to migrate an Excel table(which becomes from Access)to Rails? I have the models with scaffolds, but I would like to have all the data with only a migration.
i don't know about any 'direct' way to do that. but it should be rather easy to export csv and write a small controller/action in rails to import it. maybe you can even do something from script/console
If you’re using CSV to import the date I recommend using fastercsv: https://rubyforge.org/projects/fastercsv/
you could export the spreadsheet data with my gem ‘roo’ ( http://roo.rubyforge.org/) and then load these yaml files into your database as it is described here: http://www.urbanpuddle.com/articles/2007/10/19/load-fixed-data-into-your-rails-app
-Thomas