Rebuild the corrupted legacy data.

Hello Guys,
        Yesterday i phase one problem regarding positioning with legacy database. For my rails application i have used the awesome_nested_set to manage nesting/threading. Case is to rearrange the position and for that i have used pretty nice method called 'rebuild!'.

Assume i have model called 'Post' and have nesting per Category .

# id: integer
# category_id: integer
# lft :integer
# parent_id :integer
# position :integer
# rgt :integer
class Post < ActiveRecord::Base
  acts_as_nested_set :scope => :category
end

In the legacy database, having 3 categories called 'Alpha', 'Beta', 'Gama'. In which category Alpha's data mess out.
To over come this problem invoke command on console.
> script/console
> category = Category.find_by_name('Alpha')
> category.posts.rebuild!

Now cross check the data and it results as per need. Hope this post is helpful to you guys. Cheers!!

Integrate Bcms Blog along with BrowserCMS

Hello Guys,

        Want to integrate bcms_blog along with browser CMS via ruby? then simply follow the below steps.

http://modules.browsercms.org/modules/3-bcms-blog

Install gem called

gem install bcms_blog 

Specify configuration in environment.rb as

config.gem 'bcms_blog', :version=>'1.1.1'

Modify routes.rb

map.routes_for_bcms_blog

map.routes_for_browser_cms

No go to the your directory from command prompt and execute below commands.

script/generate browser_cms 

rake db:migrate

Now login to cms web page & go to Content Library Menu and on left side panel you'll see the Blog section and under that 3 sub sections.

 a. Blog

 b. Blog Comment

 c. Blog Post

Now creating and publishing blog follow procedure listed below:

1. Go to Blog section & create it.

2. Create category for blog section from Categorization -> Category Type..

3. Add blog post from Blog Post section.

4. Now publish all and on front end you'll see successfully created blog.

5. If you get any error like 

     ERROR: undefined method `_blog_post_path' for #<#:..> 

    Then

      include Cms::BlogHelper in ApplicationHelper

    And

     add  below method under Cms::BlogHelper

     def self.included(controller_class)
        Rails.logger.info "~~ BlogHelper included in #{ controller_class.inspect.to_s }"
     end 

6. Now on posted blog you have option for Comment.. and user's added comment only visible if they moderate it and publish.

Hope you guys, enjoy my blog.. and it's helpful .. For more information see https://github.com/browsermedia/bcms_blog/blob/master/doc/release_notes.txt

Assign class or function to Dom element on the fly

Hello Guys,

        Want to assign the class to dom element on the fly? then simply use javascript function which listed below.

demo.html

Lets assume we have anchor tag on it's click we have to apply css class.

<a id="anchor" href="" target='_blank' class='active' onclick="javascript:open_url(this.id, 'google.com');"> Open this link in new window or tab </a>

// javascript  function

<script type='javascript'>

  function open_url(id, url){

   // verify dom has 'active' class or not
   if ($('#' + id).hasClass('active')) {
     if(url != ''){

    // it's open url in new window
     window.open(url);
   }
  }
}

</script>

Preventing Recursive Method Calls in Salesforce

Hello Guys,

        Yesterday i was playing with salesforce custom object. I had task to update the object once particular field get updated /inserted (for same object). 

Eg. I have Student__c is custom object on salesforce.

Structure of Student__c object is like:

Id, Name__c, Score_in_maths__c, Score_in_science__c, Total_score__c

So when trying to update any score value required to update Total_score__c  accordingly.  To fulfill  this i have added trigger on Student__c (after update) but it results as recursive loop.

To overcome above issue just followed the steps mention in http://blog.jeffdouglas.com/2009/10/02/preventing-recursive-future-method-calls-in-salesforce/. And it works for me.

Free feel to leave comment or ask queries. :)

Generate chart using axlsx gem

Hello Rubies,

        I have generated the graph via axlsx gem of ruby. Follow the easy steps to generate 3D stacked bar graph.

Install axlsx gem via

   gem install axlsx

Lets, generate graph.rb file and than run ruby graph.rb

require "rubygems"

require "axlsx"

 p = Axlsx::Package.new
 wb = p.workbook

 wb.styles do |s|

    wb.add_worksheet(:name => "Bar graph demo") do |sheet|

        sheet.add_row ["A Simple Bar Chart"]

        sheet.add_chart(Axlsx::Bar3DChart, :start_at => "A1", :end_at => "F27", :grouping => :stacked, :show_legend => false, :shape => :box, :barDir => :col) do |chart|
         chart.valAxis.title = "Volumes"
         chart.catAxis.title = "Periods"
         chart.add_series :data => [1,2,3], :labels => ['Mar', 'Apr','May'], :colors => ['92D050', '92D050', '92D050']
         chart.add_series :data => [4,2,6], :labels => ['Mar', 'Apr', 'May'], :colors => ['FFFF00', 'FFFF00','FFFF00']

       end

   end  

end

file = File.open('/home/Desktop/graph.xlsx', 'w')
p.serialize(file)

Lets invoke ruby graph.rb on console and get the stacked bar chart.

Axlsx to support line break (\n)

Hello Rubies,
      Yesterday when i was playing with axlsx gem find something interesting. Requirement is need to allow line break in content. And current axlsx gem does not support that feature. So add this patch to your existing gem or either point directly to git repository b'coze that patch is unpublished as for now.

Add this line to axlsx1.2.3/lib/axlsx/workbook/worksheet/worksheet.rb

Remove line #500  

str.gsub(/[[:cntrl:]]/,'')

and Replace with

  if RUBY_VERSION == "1.8.7"
    nasty_control_char_matcher = Regexp.new("[\x01\x02\x03\x04\x05\x06\x07\x08\x1F\v\xE2]")
  else
    nasty_control_char_matcher = Regexp.new("[\x01\x02\x03\x04\x05\x06\x07\x08\x1F\v\u2028]")
  end

  str.gsub(nasty_control_char_matcher,'')

or

gem 'axlsx', '1.2.3', :git => 'git://github.com/randym/axlsx.git'

Hope this post is useful to you folks :).

jumping of browser window when using cursor keys

Hello Guys,

           There is wired problem when using auto completer on page and try to use arrow key for navigation.. it simply jump the browser window.

To over come this problem just add the patch in controls.js

replace line 212 to 214 with

    if(this.index > 0) {this.index--;}

    else {

      this.index = this.entryCount-1;

      this.update.scrollTop = this.update.scrollHeight;

    }

    selection = this.getEntry(this.index);

    selection_top = selection.offsetTop;

    if(selection_top < this.update.scrollTop){

    this.update.scrollTop = this.update.scrollTop-selection.offsetHeight;

    }

replace line 217 to 220 with

    if(this.index < this.entryCount-1) {this.index++;}

    else {

      this.index = 0;

      this.update.scrollTop = 0;

    }

    selection = this.getEntry(this.index);

    selection_bottom = selection.offsetTop+selection.offsetHeight;

    if(selection_bottom > this.update.scrollTop+this.update.offsetHeight){

      this.update.scrollTop = this.update.scrollTop+selection.offsetHeight;

    }

  

add line after 297

  this.update.scrollTop = 0;

In short by replacing two functions markPrevious() & markNext() will fix our problem.