From: James Gray <james@...>
Date: 2009-08-18T08:27:06+09:00
Subject: Re: CSV import to hash to compare with database

On Aug 17, 2009, at 11:56 AM, John Mcleod wrote:

> Mr. Gray,

You can stick with James.  I'm not that old yet.  ;)

> Thank you for the quick reply.

Sure.  Happy to help.

> Could you please point me to a good 'FasterCSV' resource with some
> examples?

The documentation is pretty thorough:

http://fastercsv.rubyforge.org/

and the tests show usage:

http://fastercsv.rubyforge.org/svn/trunk/test/

If your needs are simple though, maybe this code is all you need:

   FCSV.foreach( path, :headers           => true,
                       :header_converters => :symbol ) do |row|
     YourARModelClass.create!(row.to_hash)
   end

Hopefully that at least gets you started.

James Edward Gray II