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               => 'gmail.com',
   :authentication       => :login,
   :user_name            => 'xyz@gmail.com',
   :password             => 'xxxxx',
   :enable_starttls_auto => true
 }


#for yahoo mail

Implementing Roo gem in Rails 3

Roo gem allows us to access the contents of Open-office spreadsheets (.ods)
Excel spreadsheets (.xls)Google (online) spreadsheetsExcel’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 controllerrequire ‘roo’
Create a new method where you will fetch the data from excel sheet and save it in your database.def fetch_excel_data ex = Excel.new(“#{Rails.r…

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 end …