timecapsule

Gem for importing and exporting ActiveRecord data as CSV files. Great for creating seed data from data entered through your app's UI or the console.

Add it to your Gemfile

gem 'timecapsule'

Or install it to your system:

$ gem install timecapsule

For Rails <3.0 use:

$ gem install --version '= 1.0.0' timecapsule

As a Rake Task

• Export all models as individual CSV files. If your database is huge, this could take a while.

$ rake timecapsule:all

• Export a model from your app to a CSV file. User model as an example.

$ rake timecapsule:users

• To view all models that timecapsule can export:

$ rake -T

For Rails Console

• Export a model from your app to a csv file via rails console.

Timecapsule.export_model(User)

• Import a model from the csv file:

Timecapsule.import_model(User)

• To specify a different import or export directory, besides the default db/seed_data, open the automatically generated config/timecapsule.yml file and change the export directory.
• To import all the csv files in your import directory call the import method:

Timecapsule.import

• If the order of import matters for your models, you can specify the order at export time:

Timecapsule.export_model(User, 1)
Timecapsule.export_model(Post, 2)

• Remember that if you want to maintain relationships between import/export you must reset the primary key sequence (id) for each of the tables for your models. Or drop and re-create your database.

Copyright (c) 2011-present MIT

Authors: Renée Hendricksen, Kerri Miller, Risa Batta