Skip to main content

Posts

Showing posts from August, 2014

Steps for exception notifier Ruby -1.9.2 and Rails 2.3.8 For Exception Notifier in rails

Steps for exception notifier 1)ruby script/generate mailer notifier 2) ruby script/plugin install git://github.com/rails/exception_notification.git -r "2-3-stable" 3)lib/notifier.rb to change the ->  @@sender_address = %("Exception Notifier" <xxx@gmail.com>) -> For yahoo only we need to change these line 4)Add these line to  config/environments/development.rb and config/environments/production.rb config.action_mailer.default_url_options = { :host => 'local host:3000' } config.action_mailer.delivery_method = :smtp config.action_mailer.perform_deliveries = true #for gmail  ActionMailer::Base.smtp_settings = {    :address              => "smtp.gmail.com",    :port                 => "587",    :domain             ...

Implementing Roo gem in Rails 3

Roo gem allows us to access the contents of Open-office spreadsheets (.ods) Excel spreadsheets (.xls) Google (online) spreadsheets Excel’s new file format .xlsx Following is a basic example to demonstrate how to read the datas from an excel sheet and save to your database.Suppose you have an excel sheet named student_details.xls which contain the student details such as “Name”,”Phone”,”Address”.We have to save them in our database but it will take a huge time if we insert them manually.Here we can user “ roo ” gem to fetch the datas from excel sheet and save to database in a fly. Step – 1 Add the gem in your gem file gem ‘roo’ Then run the ‘ bundle install ‘ Step – 2 Place your excel sheet in the rails application such as in public folder. Step – 3 Now its time to change your controller like below. Add the following line in your controller require ‘roo’ Create a new method where you will fetch the data from excel sheet and save it in your database....

Ruby roo gem uploading excels

Right so I've checked out Roo. Great gem and all and have a really basic application that doesn't have no models. And basic controller, class and view and I can't seem to get a spreadsheet to upload as I am getting OLE2 signature is invalid error. I have the following basic setup Controller class SpreadsheetServiceController < ApplicationController def new end def create parser = SpreadsheetTagService.new(params[:spreadsheet][:file]) respond_to do |format| format.all {render :json => 'Done'} end end end SpreadsheetTagService class SpreadsheetTagService include Roo def initialize(uploaded_file) @tmp_destination = "#{Rails.root}/tmp/tag-import.xls" @file_path = save_file_to_tmp(uploaded_file) @file = File.new(@file_path) read_file(@file) end private def save_file_to_tmp(uploaded_file) FileUtils.mv(uploaded_file.tempfile.path, @tmp_destination ) @tmp_destination ...