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 | Leave a 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

Creating SugarCRM Fields through Code

SugarCRM’s Studio tool is great for administrators to point-and-click their way into field creation, but there are alternative methods. Creating fields in code has the advantage of gaining 100% control of the field, which can be especially helpful if you desired, for instance, multiple Flex Relate fields. You also gain the ability to keep the field under version control. Read More »

Posted in SugarCRM | Leave a comment

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