Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 5th, 2012  |  syntax: None  |  size: 1.49 KB  |  hits: 8  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Rails Import CSV - All Values 'Nil'
  2. def import_csv
  3.     @list = List.find(params[:list_id])
  4.     @lists = List.all
  5.  
  6. respond_to do |format|
  7. @csv=params[:file]
  8. @n=0
  9. CSV.parse(@csv).each do | row |
  10.   @user_new = User.new
  11.   @user_new.first_name = row[0]
  12.   @user_new.last_name = row[1]
  13.   @user_new.email = row[2]
  14.   @user_new.address = row[3]
  15.   @user_new.city = row[4]
  16.   @user_new.state = row[5]
  17.   @user_new.zipcode = row[6]
  18.   @user_new.country = row[7]
  19.   @user_new.notes = row[8]
  20.   @user_new.birthday = row[9]
  21.   @user_new.home_number = row[10]
  22.   @user_new.mobile_number = row[11]
  23.   @user_new.list_id = @list.id
  24.   @user_new.save
  25.  
  26.   @n=@n+1
  27.   GC.start if @n%50==0
  28.   flash[:notice] = "CSV Imported Successfully, with  #{@n} records"                                
  29. end
  30.  
  31.   format.html { redirect_to lists_url }
  32.   format.json { head :no_content }
  33. end
  34.  
  35.   end
  36.        
  37. <%= form_for(:list, :url => list_import_csv_path(@list), :method => :get, :html => {:multipart => true}) do |f| %>
  38.  <table>
  39.     <tr>
  40.         <td><label for="dump_file">Select a CSV File :</label></td>
  41.         <td ><%= file_field_tag :file %></td>
  42.     </tr>
  43.     <tr>
  44.         <td colspan='2'><%= submit_tag 'Submit' %></td>
  45.     </tr>
  46. </table>
  47. <% end %>
  48.        
  49. <%= form_tag @list, :action => 'import', :multipart => true do |f| %>
  50.  
  51. <label class="control-label" for="fileInput" style="width: 160px">Select file: </label>
  52. <%= file_field_tag 'file', :accept => 'text/html', :size => 60%>
  53.  
  54. <div class="form-actions">
  55. <%= submit_tag 'SUbmit', :class=>"btn" %>
  56. </div>
  57. <% end %>