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

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

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
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
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.
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
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
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 :
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
If running SalesLogix on a Win64 bit machine with IIS7, go to the Classic Application Pool.
Choose Advanced Settings
Change the Enable 32 Bit from False to True
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
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
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