From: John Mcleod <john.mcleod@...>
Date: 2010-02-05T04:15:00+09:00
Subject: Finding duplicate records before creating using FasterCSV

Hello all,
I have a user that will be importing csv files occasionally.  I have,
with a great amount of help (thanks James), set up an app. that will
read a csv and save to database.
I need to check for duplicate records before writing to database.

I'm thinking about putting a conditional to check for the duplicates via
column name.

- In controller -

Irb.transaction do
        FasterCSV.parse(file,
                        :headers => true,
                        :header_converters => lambda { |h| h.tr(" ",
"_").delete("^a-zA-Z0-9_")},
                        :converters => :all ) do |row|
                     # I'm thinking conditional looping thru the Model
here. #
                         Irb.create!( {"reconciled" => 0,
                                       "non_related" => 0
}.merge(row.to_hash))
                          rowcount += 1
                        end
      end

Thank you for any help.

JohnM
-- 
Posted via http://www.ruby-forum.com/.