SugarCRM Scores Another Banner Year in 2011

http://www.sugarcrm.com/crm/press-releases/2012/sugarcrm-scores-another-banner-year-2011

Analyst Views:

-  Peter Goldmacher quoted in MarketWatch on downgrading Salesforce.com to underperform from neutral: “Cowen analyst Peter Goldmacher said the company’s ‘normalized billings growth is slowing faster than expected. Competition is catching up,’ citing such rivals as Oracle Corp, Microsoft Corp and SugarCRM.”

-  In the JMP Securities Software Finance Quarterly – Q3 2011, JMP Managing Director, Kevin McClelland,cites four areas where SugarCRM is innovating v. Salesforce.com: “1) Open Source vs Proprietary – Advantage? Lower cost than SFDC. 2) Channel-centric vs direct sales focused – Advantage? Lower cost ofsales than SFDC. 3) Hosting agnostic vs SFDC-hosted – Advantage? SugarCRM can leverage the hosters (e.g. Rackspace) as a channel and has lower capital costs. 4) Focus on emerging markets and mid-markets vs upmarket focus of SFDC – Advantage? Hit ‘em where they ain’t, grow with your customer base.”

Recognition: Product and Strategy Leadership

 -  Sugar Ultimate was selected as a 2011 Product of the Year Award winner by Customer Interaction Solutions. Sugar Ultimate supports complex global applications including mobile CRM and social CRM and was recognized for demonstrating excellence, devotion to quality and providing ROI to the companies that use it.

-  SugarCRM was featured as one of Paul Greenberg’s CRM Watchlist 2012 Winners – The Generalists. Greenberg wrote, “This year, (SugarCRM) won easily, guaranteed winner, no judgment necessary and I was tougher by FAR than last year all in all.  SugarCRM is a company that has a lot to be proud of. What they did in one year is remarkable and only bodes well for their impact in 2012. But at the same time, 2012 is the year that SugarCRM needs to transition to the enterprise. They can do it with the help of IBM, but not on the backs of IBM. Can they do it? Hey, they won this year, didn’t they?”

 

 

Posted in Uncategorized | Tagged , , , , , , , | Leave a comment

Welcome to the Code Sprint

This week I’m attending the SugarCRM Code Sprint at Sugar’s office in Raleigh, NC. Here’s the very-nerdy welcome…

Posted in Uncategorized | Leave a comment

Crystal Reports Dynamic Parameters for SalesLogix (and all)

In Crystal Report Xi one can set up Dynamic Parameter; however there are three limitations to doing so. First there is limit to the number records that can be returned. Second dynamic parameters do not include filters. Lastly, sometimes users want an “All” or “None” feature.

1) Add a registry value to exceed the 1000 record limit
Create a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV
Then add a string value “MaxRowsetRecords” and set the value to the maximum number of records you would like for your report.

(Counts all parameters..not just each level)

2) Add a dynamic filter w/ ‘…All” as an additional item.

You can set up a command to do this.

In your Database expert there is the Add Command option just above your DB source.

Double click the Add command and put the following code

SELECT FIELD (your vendor field that you want to select from here) FROM table (the table your vendor field is in) UNION SELECT ‘…All’

Now in your dynamic parameter, reference this Command item instead of field In your Selection Formula use your standard Parameter references

Posted in Lan Customization, SalesLogix, SugarCRM, Web Customization | Tagged , , , | Leave a comment

Sugar Logic Rollups

SugarCRM 6.3 introduces a neat new feature of Sugar Logic, the field-calculating excel-style syntax’d scripting language available inside of Studio. The new rollup feature allows a certain field to gather information from specific fields in related modules. The values can be counted, averaged, summed or Read More »

Posted in SugarCRM | Leave a comment

Call to undefined method LoggerManager::getloggerrepository()

While upgrading an older SugarCRM System from 5.2.0 to 5.5.1, I encountered errors regarding a missing method getloggerrepository(). Searching the SugarCRM forums I quickly found a resolution by modifying some core logger-related files. The fix was simple enough, commenting out a few lines. Follow the instructions provided by SugarCRM Forum Member westphal here in his thread resolved: undefined LoggerManager::getloggerrepository().

I resolved the issue by commenting the following 5 lines in include/logging.php:

if (! isset($simple_log) || $simple_log == false) {
$config = new LoggerPropertyConfigurator();
$config->configure('log4php.properties');
}

From what I can tell, the issue is partly SugarCRM bug in 5.2.0 and/or 5.5.1, and also caused by the outdated version of the Zucker Reports module installed on the system. westphal noted his system had ZuckerReports as well as other modules that used similar methods for interacting with the SugarCRM Logging tools.

It’s worth noting that attempting to simply uninstall Zucker won’t solve the problem, because Module Loader will fail due to the same Logger references that trip up Repair & Rebuild.

After applying westphal’s fix, removing Zucker, and a Repair & Rebuild, the system was stable at 5.5.1 and I was able to continue my upgrade.

Posted in SugarCRM | Leave a comment

Logic Hook Field-Change Detection, $bean->$field vs $bean->fetched_row[$field]

SugarCRM Logic Hooks are a powerful way of interacting with data or other systems on specific system actions, usually retrieving or saving a record. A common customization challenge we face is saving a record and performing an action if a particular field has changed. For example, if a phone number field changes for a contact, we want to merge the updated contact record with another system via an API. Let’s look at how to detect changes. Read More »

Posted in SugarCRM | 1 Comment

Differences in Saleslogix Web and LAN Experiences

A great question and conversation popped up recently on the LinkedIn message board for the Sage Saleslogix group. Ron from Profiling Solutions weighs in with other Sage community members to help shed light on the differences between using Saleslogix Web versus Saleslogix LAN client.

LinkedIn Discussion (note that you must be logged in to LinkedIn and join the Sage Saleslogix group to read and participate). Read More »

Posted in Lan Customization, SalesLogix, Web Customization | Leave a comment

SalesLogix Advanced Analytics : Unable to Open Tibco Spotfire Professional Client During Install

Following the Sage SalesLogix Advanced Analytics Installation Guide, I was stymied in logging into the Professional Client during the step: Testing the custom authentication.

What was happening during Configuring the Spotfire Server for Sage SalesLogix?

In this step one sets up:

Authentication Tab

Data Source Templates tab

User Directory Tab

Impersonation Tab

Login Behavior tab

All of these set up values are pretty easy except for the Authentication Tab.  This requires typing the connection string.

The name pair value consists  of :  

  • custom.db.connection
  • jdbc:jtds:sqlserver://<database server>:<port>/<Sage SalesLogix Database name>

This should be fairly simple

jdbc:jtds:sqlserver://SQLServername/SQLInstance:1433/SalesLogixEval

In turns out that the jdbc connection does NOT recognize the SQLInstance name.  The perils of using SQLExpress with a SQL Instance.

jdbc:jtds:sqlserver://SQLServername:1433/SalesLogixEval

 

 

 

Posted in Advanced Analytics, SalesLogix, Web Customization | Tagged , , | Leave a comment

SugarCRM Module Bare-bone Manifest File

For our ongoing projects, sometimes we need to upload customizations to key files that don’t necessarily invoice creating new modules or fields. They’re just code changes. I’ve been using and re-using this manifest.php for such situations for a few months now and it seems to work nicely.

When I need it, I copy the file from an old module and paste it into my current directory. Read More »

Posted in SugarCRM | Leave a comment

Sage President\

Profiling Solutions, Inc
174 Carroll Street
Atlanta, GA 30312
Sales: 1 (866) 515-9959
Office Phone: (404) 525-8003
Office Fax: (404) 525-8005
info@profilingsolutions.com