SugarCRM useful links

By admin, February 20, 2018

When working for a Canadian IT company, mostly focused on CRM integration with other systems such as ERPs and dashboard tools, I’ve selected a huge amount of links, some really useful and some tips and tricks.

Having them here is specially interesting once some companies I have been sent to have very restrict network access depending on the system or network you are.

I will start with a familiar example: a link for the tutorial of building a custom dashlet for the Brazilian World Cup. It is quite old but already built over the SugarCRM 7.x framework

https://developer.sugarcrm.com/2015/06/22/creating-a-hello-world-dashlet-for-sugar-7/#more-10819

DEV – Updating behavior of fields
Take the reference
clients\base\fields\email
Customize and put in the target. E.g. Leads
custom\modules\Leads\clients\base\fields\email
—–
For other issues, do the same thing, but taking from

custom\modules\Leads\clients\base\views\list\list.php

 

DEV SUGAR – Make invisible modules visible in Studio – Examle: email

Create blank studio.php file in below directory

custom/modules/Emails/metadata/studio.php

SugarCRM Problems with packages
http://support.sugarcrm.com/Knowledge_Base/Module_Loader/Manually_Removing_Module_Loader_Packages/
Importing / Exporting from MSSQL Server
https://stackoverflow.com/questions/1515969/exporting-data-in-sql-server-as-insert-into
SugarCRM automation Code
https://github.com/sugarcrm/BuildingBlocks/tree/master/packages
 
SugarCRM Package examples
https://github.com/sugarcrm/examples
SugarCRM Repair via Command line
https://github.com/sugarcrm/uncon/tree/2015/sugar_repair
SugarCRM composer.json
Add to the root of the instance the composer.phar available in the sugarCRM developers github space
SugarCRM Vardefs install manifest
http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.9/Architecture/Extensions/Vardefs/
SugarCRM null field name issue
https://community.sugarcrm.com/thread/18197
SuiteCRM 
Compatibility Matrix
https://suitecrm.com/wiki/index.php/Compatibility_Matrix
INSTALL
https://suitecrm.com/wiki/index.php/Installation
Sugar
https://developer.sugarcrm.com/2016/11/15/security-changes-coming-in-sugar-7-8/
SugarCON 2017 Sugarpath
https://community.sugarcrm.com/docs/DOC-4376-sugarcon-2017-sessions
SugarCRM 7 Custom Dashlets
https://wallencreeksoftware.blogspot.ca/2018/01/use-rows-columns-reports-in-dashlets.html
Sugar CRM upgrading custom BWC modules to sidecar
http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.7/Architecture/Backward_Compatibility/Converting_Legacy_Modules_To_Sidecar/
1 Creating dashboards and dashlets
https://community.sugarcrm.com/community/partner-corner/blog/2016/09/16/7-tips-working-with-sugars-dashboard-and-dashlets
2 – Creating custom reports
http://www.bhea.com/blog/sugarcrm-reports-and-dashboards-an-overview/
3 – Customizing existing reports
 – http://support.sugarcrm.com/Documentation/Sugar_Versions/7.9/Ent/Application_Guide/Reports/Advanced_Reports/
4 – Sorting sales stage
http://support.sugarcrm.com/Knowledge_Base/Opportunities_Forecasts/Understanding_Sugar_Sales_Stages/
5 – Canadian Dollar (money, currency) as default
http://support.sugarcrm.com/Documentation/Sugar_Versions/7.7/Ult/Administration_Guide/System/#Currencies
https://www.fastcomet.com/tutorials/sugarcrm/managing-currencies
 6 – Instead of searching for a Javascript in order to make SugarCRM 7 fields required or ReadOnly after some update, just follow the steps under
http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.9/Architecture/Extensions/Dependencies/