Author Archives: David

Code on GitHub

I have started putting my public code onto GitHub. To get the latest copies of code, please use this link: https://github.com/opensourceame I will be documenting the process manager classes soon…


Read More

Stash classes online

I’ve made my Stash classes (a lightweight ORM / DBAL of sorts) available for download. The simplest way to explain how they work is through some example code:


Read More

Updated logger

I’ve added a zTemplate plugin to my Flexible Logger. This makes logging more flexible than ever as you can render logs in any format the template ranging from CSV to XHTML. The variables for each log entry are date, level and message. Here’s an example of using the zTemplate plugin to create a load of…


Read More

Logger and docs updated

I’ve done some updates to my Flexible Logger, including: XML plugin can output date and level info embedded as attributes instead of tags HTML plugin accepts an option cssClasses to specify classes for table, rows and cells improved buffering for all plugins I have also made the API docs available online using APIGen, my new…


Read More

Quickly format tables for SugarCRM

If you are hand-coding tables for SugarCRM then you can skip the tedious addition of attributes to table elements by using my sugarTables.js script to quickly format a table in a SugarCRM style. The script requires PrototypeJS. For example, creating a table like this:

renders a table looking like this: The makeSugarList() method works…


Read More

CETeams-1.0.7d-p6

I have updated my patched version of CETeams 1.0.7d to version 6 which includes changes to make the module work with Sugar 6.1.6. You can download the zip file of the source below: CETeams-1.0.7d-p6…


Read More

Sugar SubPanels and SubQueries

Sugar allows you to specify a where clause in a subpanel This is useful if you want to show only certain records in the subpanel, or to filter the subpanel results, as detailed in my blog entry Filtering Sugar Subpanels. While it’s a useful feature, it does have a problem – subqueries. If you specify…


Read More

Filtering Sugar SubPanels

Sugar doesn’t have a means of filtering subpanels built into it. This is a serious drawback if you have subpanels with a lot of data in them. However, it’s possible to create your own filter with a little work. I’ll explain my solution here. First, here’s a screenshot of a notes subpanel for a client…


Read More

Analyse Sugar Queries

Database performance can have a huge affect on the performance of a web application, especially one as large and complex as SugarCRM. Tuning your database to deal with Sugar’s many queries can have a huge impact on its performance. But how do you find out what exactly Sugar is doing, and which queries are causing…


Read More

CE Teams 1.0.7d patch 5

I’ve done another update to the CE Teams code to better support Sugar 6.1. This patch fixes an issue with the User Management page showing as a blank and updates the Unified Search code. If you’re using CE Teams with SugarCRM 6.1 this is the patch to use. Download Here…


Read More