Author Archives: Matthew Poer

PHP 5.2 and 5.3 Differences and Work-Arounds

By Matthew Poer | Published: May 14, 2012

Something I’ve been frustrated with as a developer is the subtle differences in PHP versions 5.2 and 5.3. One of our service providers hasn’t been able to upgrade to 5.3 yet, but all of my code that I write on my machine (using 5.3) has to run on their servers. While this isn’t often a [...]

Posted in PHP | Leave a comment

SugarCRM System CleanUp

By Matthew Poer | Published: May 7, 2012

Spring is here, and maybe it’s time for your annual SugarCRM System Clean-up. Sugar’s database system is good, but don’t things just feel better when there isn’t ten-year-old data lurking around? Here are some scripts I use when I’m pruning a database to drop off deleted data or old data.

Posted in PHP, SugarCRM | Tagged , , , , , | Leave a comment

SugarCRM Labels Hierarchy

By Matthew Poer | Published: May 1, 2012

Labels can seem very straight forward when you’re working within Studio, but when you dive into code you’ll likely find that the system labels for a particular module or for dropdown definitions are strewn throughout several places in the system. Let’s examine the different places for label data and the hierarchy the system uses to [...]

Posted in SugarCRM | Leave a comment

Hiding Subpanels, thru Configuration and thru Code

By Matthew Poer | Published: April 25, 2012
Display Module Tabs and Subpanels

SugarCRM’s subpanels are pretty configurable. Especially in later editions, a single reference to a subpanel can be overridden via Studio very easily. But what if you want to all-out hide a subpanel? Studio doesn’t offer this ability. Enter the Display Module Tabs and Subpanels menu, accessible from the Admin page under the Developer Tools section: [...]

Posted in SugarCRM | Leave a comment

Longer SugarCRM Sessions

By Matthew Poer | Published: April 20, 2012
SugarCRM Logo

In most server-setups, we find that the SugarCRM Session only lasts about half an hour. This is something I’ve gotten complaints about — users wanting longer sessions to ease the work day. I had spent time looking through the session-management code to find an answer and just wasn’t getting anywhere. I back-burned it until I [...]

Posted in SugarCRM | Tagged , , | Leave a comment

Debian Squeeze Apache2 and GoDaddy SSL Certifications (https)

By Matthew Poer | Published: April 13, 2012

I recently set up my first ssl-certification for Apache for our SugarCRM server. The process wasn’t as difficult as I expected, as Debian has some built in tools to make it relatively easy.

Posted in Uncategorized | Leave a comment

PHP and Microsoft SQL Server

By Matthew Poer | Published: March 16, 2012

There are several methods of getting a PHP-enabled web server talking to your Microsoft SQL Server database. Depending on your requirements and available PHP versions, extensions, though, it can be a tedious process. Effectiveness of a particular solution may vary based on versions of SQL Server and PHP. There are options, though, and I’ll detail [...]

Posted in PHP, Web Customization | Leave a comment

Creating Saleslogix IDs in PHP

By Matthew Poer | Published: March 7, 2012

One of the fundamental aspects of working with any particular database-driven system is to understand how to properly create new records, and the most crucial aspect of that, as any amateur or pro DBA knows, is using proper table IDs. The Saleslogix ID system is 12 characters long, compromised of a leading-letter code to identify [...]

Posted in SalesLogix | Leave a comment

Welcome to the Code Sprint

By Matthew Poer | Published: February 21, 2012

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

Sugar Logic Rollups

By Matthew Poer | Published: February 13, 2012

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

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