Best of 2010: Epicom Engineers’ Favorite Projects Of The Year

sugarcrmdevelopers —  December 29, 2010

Editors Note: Epicom is one of our largest North American partners, and their engineers are always pushing the limits of what SugarCRM can do. With permission from them, we’ve re-posted this entry from their company blog, which talks about some of their favorite projects of the past year. Look forward to more content from Epicom and other SugarCRM partners and community members in the new year on the Sugar Developer Blog.

From all of us here at SugarCRM, we wish everyone a safe and happy holiday season.

Epicom’s Software Engineers have been busy this past year working on several new projects. Each week the team creates various new features, custom modules, or other solutions for our clients where the end result is a product built for their specifically for their business. We asked them to share some of their favorite and most requested work in 2010. Below are just a few of the creative solutions Epicom’s Engineering Team have completed or will complete for clients this year. To learn more about any of the projects below, contact us at or CLICK HERE to contact an engineer directly.

1. Target Lists Automation For Campaigns

  • Problem: Client had hundreds of leads coming into the CRM each day and had to attach each lead to its specific campaign or lead source.
  • Requirement: The client needed the solution to be automated, implemented quickly, and at a low cost.
  • Solution: Allowed the user to add a query to the target list for defining which people should be added. We then added a field to the target list module to store the query and a checkbox to mark that this target list should be updated automatically. Finally, we created a scheduled job that runs every10 minutes executing those queries and updating the target lists.
  • End Result: A quick and easy way of keeping target lists in sync. An added bonus was that you can write very complex queries that you cannot generate using Sugar Reports.  For example: Create a target list consisting of everyone that has signed up for Conference X, Conference Y, but not Conference Z. The client has created a dozen or so of these automated target lists that are highly targeted with very specific conditions which would be extremely difficult and time consuming to keep updated manually.

2. Relationship Attributes Module

  • SugarCRM out-of-the-box gives the ability to identify contacts with certain accounts, but doesn’t allow users to attach any attributes to those relationships.
  • A custom module was built with a many-to-one relationship to accounts and with contacts.
  • The relationship attributes module can allow clients to describe employment history, education, and family member associations.
  • The new module is not displayed in the navigation and the new attributes instead appear within each contact and account’s detail view.
  • The end result offers users a customization that has the look and feel of the rest of the system and hides the complexity of the code.

3. Tagged Objects

  • Problem: Client had several new leads coming in a day and needed a way to go through those lists and tag which ones they want to follow up with.
  • Requirement: Needed the ability to tag objects (leads, contacts, accounts, or other custom objects).
  • Solution: Created a Tag module and Tagged module to hold the tags and to mark which objects are tagged with which tags. Then created a button on the list views that allows you to tag whichever records you have checked.
  • End Result: The client can now tag nearly any object w/ any tag they like. They can then use those tags in search, reports and the auto target lists.

4. Custom Portal

  • Epicom build a custom portal to better meet the client’s needs. The client required the portal, but Sugar Enterprise was not an option for their business.
  • The custom portal integrates with Sugar Community Edition as well as Sugar Professional.

5. Quickbooks Integration

  • Epicom is just beginning a client project to integrate Quickbooks information into SugarCRM.
  • In this project, Sugar will be customized to integrate Quickbooks with modules related to sales and employees, but has the ability to integrate with any module a client needs.

6. Calendar And Meeting Scheduler

  • Epicom customized the calendar module to give the client better transparency when scheduling meetings.
  • The end result allowed the client to see each user’s calendar and availability. When scheduling a meeting, the action would not be allowed if the user’s calendar showed them to be busy. This eliminates meeting overlaps as well as  meeting room reservation conflicts.