[Rails] Re: updating model while reading CSV

Sorry... forgot to mention the way it works is:
- the first row of the CSV is taken as a list of column names
- the remaining csv rows are data for new models
- if your model contains a column/attribute matching one of the csv
column names, it will be loaded
- each new record is yielded to a block provided.

On Oct 30, 9:45 am, Pat Shaughnessy <p...@patshaughnessy.net> wrote:
> 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 <rails-mailing-l...@andreas-s.net>
> 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 rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---