Uploadable - A simple gem, with custom options to upload a csv to a model
How to use?
- How to make a model uploadable
use keyword uploadable and mandatory_fields & optional_fields
for setting up the fields which the gem should read and upload to model
any other field would be ignored
class Car < ActiveRecord::Base uploadable :mandatory_fields => [:company, :model], :optional_fields => [:price, :category] validates_presence_of :company, :model validates_numericality_of :price, :greater_than => 100000 validates_inclusion_of :category, :in => %w(two three four) end
- Using csv partial upload : upload_from_csv
You can use function upload_from_csv which will upload records without errors
[ #<Car id: nil, company: nil, model: "800", price: 250000, category: "four", created_at: nil, updated_at: nil>, #<Car id: 27, company: "Honda", model: "City", price: 8000000, category: "four", created_at: "2012-07-01 10:32:04", updated_at: "2012-07-01 10:32:04"> ]
Using transactional upload : upload_from_csv!
if any record contains error, it wouldn't upload, else would upload all returns you the array of objects (uploaded or unuploaded)
Note: You can use errors method and iterate over the list of objects to collect errors