Skip to main content

Posts

Showing posts from 2014

Rails Selecting Dropdown display the records selected dropdown value with partial file data?

Rails Selecting Dropdown display the records selected dropdown value with partial file data? #In Controllers user_controller.rb def select_user_location  @user_location = User.select("distinct location") end #In Routes get "user/select_user_location" => "user# select_user_location" In Views   Select Loaction: <span class="select_class"> <%= select_tag 'location', options_for_select([["Select Location",'']]+@user_location), :data => { :remote => true, :url => url_for(:controller => "user", :action => "select_user_location")}%></span> <div id="user_select_location"> </div> _select_user_location.html.erb  <div class="location_data"> <%@user_location.each do |x|%> <p><%=x.inspect%></p> <%end%>  </div> select_user_location.js.erb $("#user_select_location").html(...

Kola Gem In rails Getting facebook User Details

graph_api = Koala::Facebook::API.new("xxxxxxxx")  user_details = graph_api.get_object("me")  facebook_id = user_detail["id"]  facebook_email  =  user_detail["email"]  first_name = user_detail["first_name"]  last_name = user_detail["last_name"]  full_name = user_detail["name"]  gender = user_details["gender"] location = user_details["location"]["name"] ========================================================================= ========================================================= =================================================== The O/p of the above data will be like these "id"=>"10000216852162", "education"=>[{"school"=>{"id"=>"269058053195606", "name"=>"CBHS"}, "type"=>"High School", "year"=>{"id"=>"113125125403208...

Angular Js Examples codes

<!DOCTYPE html> <html> <head> <script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.2.15/angular.min.js"></script> </head> <body> <!--Example 1 -->  <div ng-app="" ng-controller="personController">  First Name: <input type="text" ng-model="firstName"><br>  Last Name: <input type="text" ng-model="lastName"><br>  <br> Full Name: {{firstName + " " + lastName}} </div> <script> function personController ($scope) {     $scope.firstName = "";     $scope.lastName = ""; } </script> <!--Example 2 --> <div ng-app=""> first expression {{5*6}} </div> <!--Example 3 --> <div data-ng-app="" data-ng-init="firstName='John'"> <p>The name is <span data-ng-bind="firstName"></span></p> <!--Example...

Rails 3, Devise, Omniauth, and Google

Getting authentication through Google in a Rails application is a breeze with the right tools. To get a simple, no-frills authentication system up and running in a Rails 3 application, all you really need is Devise, Omniauth, and a Google API account. Step 1: Signing up for Google API access Before being able to wire up authentication in your rails app, you will need to set up a Google App. First, get your API key at:  https://code.google.com/apis/console If you don’t already have a Google account, you will need to set one up, after that create a project and give it any name you like. Once you create a project, click on “API Access” and provide details for your OAuth Client. For development purposes, the Home Page URL can be “localhost”. After all of the details have been set, you will then get access to the screen with all of the information you will for your Rails app. For now, locate the section that contains your Client ID and Client Secret, you will need these later ...

Omniauth Linked in Ruby On Rails

def get_linkedin_user_data      omniauth = request.env["omniauth.auth"]      dat=omniauth.extra.raw_info      linked_app_key = "xxxxxxx"      linkedin_secret_key = "yyyyyyy"      client = LinkedIn::Client.new(linked_app_key,linkedin_secret_key)      client.authorize_from_access(omniauth['credentials']['token'],omniauth['credentials']['secret'])      connections=client.connections(:fields => ["id", "first-name", "last-name","picture-url"])      uid=omniauth['uid']      token=omniauth["credentials"]["token"]      secret=omniauth["credentials"]["secret"]   #linked user data     omniauth = request.env["omniauth.auth"]      data             = omniauth.info      user_name...

Kola Gem Implementaion In Ruby On Rails

Facebook omniauth with kola gem Implementation on Rails 3 1)Gem file add these lines gem 'koala' 2)Facebook User Details getting  token = request.env['omniauth.auth']["credentials"]["token"]    # omniauth = request.env["omniauth.auth"]    # token = omniauth['credentials']['token']  @graph = Koala::Facebook::API.new(token)  #Get The User Details of user  fb_profile = @graph.get_object("me")  #Get The Fb user freinds list  friends = @graph.get_connections("me", "friends")  firend_ids = friends.map{ |friend| friend["id"]}   image_url = @graph.get_picture(@fb_id)   image = open(image_url)       full_name = fb_profile["name"]       sub_name = fb_profile["first_name"]       if fb.include?("location")         location = fb_profile["location"]["name"]       elsif fb.include?("...

Ezpservices Integration In Ruby on Rails(Cafe Press)

Ezprints  Integration In rails 1)Posting Order to Ezprints and get the shipping values require 'net/https' require 'rexml/document' def shipping_options_ezp_services       @order = Order.where(:id => 5).first       @total_orders = Order.all       xml = "<?xml version='1.0' encoding='UTF-8'?>       <orders partnerid='45678' version='1'>       <ordersession>       <order>       <orderid>#{@order.id}</orderid>       <shippingaddress>       <firstname>#{@order.first_name}</firstname>       <address1>#{@order.address1}</address1>       <city>#{@order.city}</city>       <state>#{@order.stat...

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 ...

Rails Date Formats

Rails Date Formats % a - The abbreviated weekday name ( '' Sun '' ) % A - The full weekday name ( '' Sunday '' ) % b - The abbreviated month name ( '' Jan '' ) % B - The full month name ( '' January '' ) % c - The preferred local date and time representation % d - Day of the month ( 01 .. 31 ) % H - Hour of the day , 24 - hour clock ( 00 .. 23 ) % I - Hour of the day , 12 - hour clock ( 01 .. 12 ) % j - Day of the year ( 001 .. 366 ) % m - Month of the year ( 01 .. 12 ) % M - Minute of the hour ( 00 .. 59 ) % p - Meridian indicator ( '' AM '' or '' PM '' ) % S - Second of the minute ( 00 .. 60 ) % U - Week number of the current year , starting with the first Sunday as the first day of the first week ( 00 .. 53 ) % W - Week number of the...

Rails generate Csv or xls files

def get_all_users     csv = ""     csv1="Id,Email"     csv2 = ""     csv << "#{csv1}\n"     csv << "#{csv2}"     @user = User.find(:all)     @user.each do |x|        csv2 << "#{x.id}"        csv2 << ",\"#{x.email}\""        csv2 << "\n"      end    csv << csv2    send_data csv, :type => 'text/xls; charset=utf-8; header=present', :disposition => "attachment;filename=xyz.xls" (or) send_data csv, :type => 'text/csv; charset=utf-8; header=present', :disposition => "attachment;filename=xyz.csv" end In Views <p><%=link_to "hello",:controller => "user" ,:action => "get_all_users"%></p>

MYSQL DATAT TYPES EXPLANATION?

MYSQL DATAT TYPES EXPLANATION? What is data type 1. A data type specifies a particular type of data, such as integer, floating-point, Boolean etc. 2. A data type also specifies the possible values for that type, the operations that can be performed on that type and the way the values of that type are stored. MySQL data types MySQL supports a number of SQL standard data types in various categories. MySQL has Numeric Types, the DATETIME, DATE, and TIMESTAMP Types and String Types. Data types are discussed on this page are based on MySQL community server 5.6 MySQL Numeric Types MySQL supports all standard SQL numeric data types which include INTEGER, SMALLINT, DECIMAL, and NUMERIC. It also supports the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). The keyword INT is a synonym for INTEGER, and the keywords DEC and FIXED are synonyms for DECIMAL. DOUBLE is a synonym for DOUBLE PRECISION (a nonstandard extension). REAL is a synonym for DOUBLE PRECISION (a nonstandar...