Ruby Gem for SugarCRM: Ruby on Rails Integration

Posted on April 4, 2011

Having gone over the basics in a previous article, we will now cover how you can get a basic Rails 3 app (using the SugarCRM Ruby gem) up and running. (The SugarCRM Ruby gem relies on ~~ActiveSupport >= 3, and therefore isn’t compatible with Rails 2.~~ ActiveSupport >= 2.3.9, but is optimized for Rails/ActiveSupport 3.)

Note: the Rails app we create in this article has been posted on GitHub at https://github.com/davidsulc/dev_zone_basic_rails_app, and where possible each step links to the specific commit its related to. Feel free to fork and experiment!

Getting started

First, let’s create a new Rails app (see commit):

  
  
    
    rails new rails_demo --skip-active-record

You’ll note we won’t be using ActiveRecord, since we’ll be dealing with records in SugarCRM and not in a local database.

We’ll be using the sugarcrm ruby gem for this Rails app, so let’s add it to the Gemfile (see commit):

  
  
    
    gem 'sugarcrm', :git => 'git://github.com/chicks/sugarcrm.git'

In this case, we’re using the git repository so every time we update our bundle (with, e.g., bundle update sugarcrm ), we’ll be able to use the new features/bug fixes that have been added to the gem. We could also simply use gem 'sugarcrm' , but then we’d only gain access to new functionality as new gem versions get released.

Next step, install the bundle, so all the gems we need (in particular the sugarcrm gem we just specified) get added to our app (see commit):

  
  
    
    bundle install

Configuring the connection to SugarCRM

Now that we have our environment up to speed, let’s move on to configuring our app to connect to SugarCRM. Type rails g in the console to see all the rails generators that are available to you. You’ll notice that there’s a ‘SugarCRM’ section which displays the generators made available to rails by the sugarcrm gem. Let’s use one to generate the configuration for connecting to the SugarCRM server (see commit):

  
  
    
    rails g sugarcrm:config

The generator will create 2 new files: config/initializers/sugarcrm.rb and config/sugarcrm.yml. You can safely ignore the former, but you need to fill in all relevant information in the latter: the URL where you SugarCRM server is, your username and password, etc. This information will be required for each Rails environment (i.e., development, test, production), just like in the typical database.yml. (If you’ve been following along so far, but don’t have a SugarCRM server handy to test your app with, I highly recommend SugarCRM’s no-fuss stack installers.)

Before we move on, let’s make sure the connection between our app and SugarCRM is working correctly. Open the rails console with rails console and try this:

  
  
    
    SugarCRM::User.first.user_name # => 'admin'

If you can’t figure out what the line above means, you might want to check out our introduction to the sugarcrm gem.

Creating a model

And now, on to the actual Rails app itself. We’re going to create a simple portal that will allow us to manage SugarCRM accounts. For simplicity, and to avoid cluttering the example, the only attribute we’ll work with is the account’s "website" attribute.

First of all, let’s create a rails model in app/models/account.rb (see commit):

  
  
    
    class Account < SugarCRM::Account
    end

You'll notice that it inherits from SugarCRM::Account instead of the usual ActiveRecord::Base . Other than that, this model doesn't do much: all the heavy lifting is passed onto the gem.

Let's check the magic is actually taking place: fire up the rails console and try

  
  
    
    Account.first.name # => should output a company name

Now, edit the account model (app/models/account.rb) again to add the following below the class definition (see commit):

  
  
    SugarCRM::Account.class_eval do
  def self.model_name
    ActiveModel::Name.new(Account)
  end
end

This makes the SugarCRM::Account class return the model name we’re using in our rails app.

Using a scaffold

Now let’s generate an accounts scaffold (see commit):

  
  
    
    rails g scaffold account name:string website:string --orm ''

(We need to specifiy an ORM since we’re not using Active Record, except we don’t want one. Specifying '' (i.e., a blank string) will allow the scaffold to be generated without using an ORM: don’t worry when rails complains about not finding that ORM…)

Trying it out

Let’s launch the server ( rails server ) to see what we have after a few minutes of work. As you’ll see by navigating to http://localhost:3000/accounts we already have a basic account portal that’s fully functional!

Gem documentation can be found at https://github.com/chicks/sugarcrm, and questions/problems regarding the gem should be reported there also for quicker resolution. Besides the introduction to the gem, there is also an article on more advanced gem use.

Would you like to see more Elixir content like this? Sign up to my mailing list so I can gauge how much interest there is in this type of content.