2013-09-30

My Implementation is Failing Because I Use SugarCRM

Larry Augustine, CEO of SugarCRM, shared his thoughts with Forbes about Why Your CRM Implementation is Quietly Failing, (http://www.forbes.com/sites/danwoods/2013/09/30/why-your-crm-implementation-is-quietly-failing/)

Larry's main message in this interview is that CRM needs to expand beyond Sales Dept's to every part of the organization that interfaces with the Customer.  (Certainly good for bottom lines of SaaS companies like SugarCRM who license their software per user per month.)  I agree this approach is a great way to have the entire organization be customer focused by enabling them with information they need to competently interact with each customer in a meaningful way.

A little bitter sweet for me as I would as Larry Augustine what about if my CRM implementation is failing BECAUSE I use SugarCRM.

While every system has it quirks, bug and missing features, SugarCRM certainly has some VERY notable holes that have been around for quite some time and they have no plans when these 'Feature Requests' might be fixed.

Duplicate Detection

A great way to look stupid in front of a customer is to be using a partial and incomplete duplicate record.  Any company who uses any type of CRM fights the battle with duplicate records and must maintain system and processes to battle them.  In SugarCRM the tool you use to search for duplicate is grossly under-powered.  You can't even OR a bunch of potential identifying clauses together.  The search tool ANDs every entry.  Therefore, to run a decent search, because you can't OR a bunch of data overlapping clauses into one query, you MUST run ONE query for each data point you want to search on for potential conflict.  Talk about inefficient.  What decade are we in Larry?  This is the question I get from the person who we assign to perform this ridiculously inefficient search, everyday, multiple times for every new lead.
http://www.sugarcrm.com/support/bugs.html#issue_47265

Workflow can't make Entity Associations: Lead to Campaign

Anyone it Marketing knows you need to justify and define your spend base on the results of your campaigns.  One main goal of any campaign is to generate leads.  Associating a Lead with a Campaign is a must have operation.  ERRRR, hard stop.  SugarCRM won't let you write a Workflow rule or Mass Update rule to associate a Lead with a Campaign.  So I can't write a Workflow Rule that say, Upon Save of New Lead, set Lead.Campaign = Campaign X, when during a  specific 'Campaign' season.  Workflow lets me write all sorts of great rules, but traversing the Lead to Campaign relationship is not in it list of doable actions.  What!!! The Mass Update feature has the same issue.  Therefore, Lead involvement in a Campaign can only be set manually.  (Insert cost for unnecessary manual lead data management here.)
http://www.sugarcrm.com/support/bugs.html#issue_48521

I can't imaging how any modern day CRM system can be successful without these features.  We continue to stammer along as a SugarCRM customer without them.  I don't think we'll be buying licenses for the rest of the users in the company.

Looking to Buy or Sell Durham Region

If you are looking to buy or sell your home in Durham Region, Ian Gibson, ReMax REALTOR is your guy.

I have used him twice, to both buy and sell my home in Whitby Shores.  You can read my full testimonial about his services here: https://plus.google.com/110037488713756862005/about?hl=en  His service was great and I would recommend him to anyone.

Ian's Real Estate Listings:





2013-09-12

Crystal Reports - The database DLL crdb_baan.dll could not be loaded.

Error Message

Failed to load database information. Details: The database DLL 'crdb_baan.dll' could not be loaded.








Crystal Reports
Failed to load database information.
Details: The database DLL 'crdb_baan.dll' could not be loaded.

Fix

The Crystal Report you are using requires the Crystal Baan Connector to be installed and configured.

2013-09-09

Portage Design - New Look

A new website look by and for the team over at Portage Design.  This web design features a heavily customized WordPress theme, is a fully mobile ready design complete with image rotator, tonnes of new features.  Have a look and let them know what you think.

2013-09-05

Ubuntu Apt Repository for Old Releases

For all you Ubuntu hard-core users looking for support for you old production installs that have fallen of the LTS support:

http://www.warpconduit.net/2011/07/31/apt-repository-for-old-ubuntu-releases/

2013-09-03

HP ProtectTools - Load/Mount Personal Secure Drive (TPM Drive)

Initially after configuring the Personal Secure Drive (TPM Drive) as part of the Embedded Security features part of HP ProtectTools that came with my Win7 laptop, there was a handy icon on the desktop to load this new PSD/TPM drive.  Shortly thereafter I deleted this icon.

I quickly realized that without this icon, I didn't know how to manually load the PSD and I had configured it not to load on start-up.  (It has to be loaded of course before it appears under My Computer as a usable drive letter).  Tracing my steps and opening the HP Protect Tool Security Manager, as well as the HP Protect Tools Administrative Console, I found no mention of any screens related to the PSD feature. (Seems once you have configured the drive via the Wizard, this interface all but forgets about this feature.) I had already place some files in the Personal Secure Drive so I was determined to get these back.

A little bit of search and I did eventually find my answer.  

From the Taskbar Icon Tray, click on the HP ProtectTool Security Manager icon, and select Embedded Security > Personal Secure Drive > Load