Hey, What way is the best to do imports of CSV files?
If you mean CSV to DB records, you should use fixtures.
On terminal window. rake db:fixtures:load FIXTURES=table_name RAILS_ENV=development
Change 'table_name' and RAILS_ENV=~ as you like. This will import CSV as DB records.
Thank's Masuda, but what im looking for is a solution where the user can upload a CSV file an update the DB records that way.
Goro Kuroita wrote:
If you mean CSV to DB records, you should use fixtures.
On terminal window. rake db:fixtures:load FIXTURES=table_name RAILS_ENV=development
Change 'table_name' and RAILS_ENV=~ as you like. This will import CSV as DB records.
Poppycock. Fixtures are so broken that they're worth avoiding completely (I wish they'd be removed from Rails). For prepopulating the DB, use the DB's native CSV import or something like seed_fu. For dynamic CSV import in the application, fastercsv might be useful.
Best,
Why do you say that fixtures are broken?
Milan Dobrota wrote:
Why do you say that fixtures are broken?
The short answer is that they're unsuited to their intended purpose (populating the test DB). They're better than nothing, but are an inferior alternative to other solutions now available. I'll get into the long answer if you really want, or just search the list archives.
Best,
