Cookie Overflow at CSV import

rubyonrails-talk
1

Hi

I have a form for importing a csv file. With every entry in my CSV I do a delayed background call from a webservice and the result is then saved to my database. This is working great!

Now I tried a CSV file with over 400 rows. After clicking import in my form it takes some time and then I get the following error message: 'ActionDispatch::Cookies::CookieOverflow'. But nevertheless 300 of the 400 jobs are already created in my delayed_jobs table.

The code below is copied from other threads, so I don't really know where I save something in cookies. I guess it is at 'file.tempfile' in the controller, but I am not sure.

How can I avoid that error? I found something about using session_store instead of cookie_store, but I don't know how to do that.

I have the following in my controller:

    file = params[:file]     CSV.new(file.tempfile, {:headers => false, :col_sep => ";"}).each do |row|         @list << row[1]       end     end

and this in my view:

<%=form_tag '/importcsv/csv_import', :multipart => true do%>   <%= file_field_tag "file" %><br/>   <%= submit_tag("Import") %> <% end %>

Cheers, Sebastian

2

Sebastian,

In order to use session store you have to do the following things,

To create a migration file: rake db:sessions:create

To create session table: * For development mode: rake db:migrate * For production mode: rake db:migrate RAILS_ENV=production

Then un-comment the following line in config/environment.rb config.action_controller.session_store = :active_record_store

restart the app.. thats it..

Saravanan K

3

Saravanan,

I am on rails 3. I don't know if it is because of that, but I had to un-comment the line in 'config/initializers/session_store.rb' instead of 'config/environment.rb'. And the line you send me is deprecated (my server told me), so I used this instead: Savon::Application.config.session_store :active_record_store

Thank you so much it worked like a charm!

Sebastian