Hey John, Last week I wrote this code to allow you to easily create models/ records using FasterCSV... it doesn't directly answer your question, but it might help or at least give you some ideas: http://pastie.org/676681
If it looks this would be useful to you or others I can post it on github; I also have a test suite for it. - pat On Oct 29, 12:52 pm, John Mcleod <[email protected]> wrote: > Hello all, > I was wondering how to update an existing table column when reading in a > CSV? I'm using FasterCSV and my controller method is this... > > - Import Controller - > def process_csv > > # set file name > file = params[:import][:file] > rowcount = 0 > > Import.transaction do > FasterCSV.parse(file, > :headers => true, > :header_converters => :symbol ) do |row| > Import.create!(row.to_hash) > rowcount += 1 > end > end > # if successful then display, then redirect to index page > flash[:notice] = "Successfully added #{rowcount} project(s)." > redirect_to :action => :index > > rescue => exception > file_name = params[:import]['file'].original_filename > file_parts = params[:import]['file'].original_filename.split('.') > ext = file_parts[1] > > if ext != 'csv' > error = "CSV file is required" > else > error = ERB::Util.h(exception.to_s) # get the error and HTML > escape it > end > # If an exception in thrown, the transaction rolls back and we end > up in this > # rescue block > > flash[:error] = "Error adding projects to Import table. (#{error}). > Please try again. " > > redirect_to :action => :new > end > > As I read the CSV file, I wish to update a column in the model, mainly > "ProjectType" as the record is being created. > > The CSV file does not have this information and there's no possibility > that it'll ever have it. > > Thank you for any help. > > JohnM > -- > Posted viahttp://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
