Tools and Reports Modules for SugarCRM CE

Over the past couple of years I have worked with SugarCRM. During that time I’ve tried to overcome the lack of Reports and Tools in the Community Edition (CE) by incorporating my own custom reports and tools for marketing professionals to be able to use thru SugarCRM custom modules. These reports and tool were eventually compiled into a SugarCRM package which is now available for download thru the Sugar Forge web site.

SugarCRM Tools and Reports by JJWDesign: A collection of field developed and tested tools and reports. They we’re developed with SugarCRM CE and used for the daily maintenance and … Continue reading Tools and Reports Modules for SugarCRM CE

SugarCRM Account Re-assign Logic Hook

This SugarCRM Logic Hook was used to overcome a common issue with SugarCRM. SugarCRM CE doesn’t automatically reassign an Account’s related contacts when the Account is reassigned. This often creates visibility/usability issues due to the lack of permissions (roles). The logic hook below reassigns the Accounts related contacts and opportunities saving you the time of doing it manually as well as preventing multiple contact issues. This logic hook also manages a reassigning mapping to general store users based on status set. … Continue reading SugarCRM Account Re-assign Logic Hook

SugarCRM Leads Logic Hook

This SugarCRM logic hook was used to automatically assign leads to users based on status. This mapping was required to help users reassign leads to users such as the “Dead Targets User”. See the logic hook below for the mapping details. In order for this Logic Hook to function the Usernames must exist. … Continue reading SugarCRM Leads Logic Hook

SugarCRM Users Logic Hooks

Custom Logic Hooks are a great way of adding functionality to SugarCRM. The logic hook below was used to establish a default role for new users. This was required for the automatic LDAP Users functionality that is built into SugarCRM. This logic hook was used with SugarCRM CE 5.2 in a production environment.

<?php
// custom/modules/Users/logic_hooks.php

// Do not store anything in this file that is not part of the array or the hook version. This file will
// be automatically rebuilt in the future.
$hook_version = 1;
$hook_array = Array();
// position, file, function
$hook_array['after_login'] = Array();
$hook_array['after_login'][] = Array(1, ‘SugarFeed old feed entry remover’, … Continue reading SugarCRM Users Logic Hooks

SugarCRM Backup Scheme

This SugarCRM backup scheme (tested on v5.2) was developed with help from several online tutorials. The concept is to generate daily and weekly file backups of the SugarCRM file structure, excluding the upload directory which contained too many email attachments (mostly spam) at the time. These shell scripts assume your SugarCRM install is located at /var/www/html, make the necessary changes to the paths. Also, remember to setup the actual CRON for these shell scripts.

SugarCRM Backup
Place two files into directory /usr/local/bin

#!/bin/bash
# crmfbweekly:
# consists of three lines: one to find the modified files, and then two to tar and gzip them
find … Continue reading SugarCRM Backup Scheme