SugarCRM

SugarCRM: Delete Custom Field

Posted on

You have to check for following things. 1) Remove custom field entry in table "fields_meta_data" 2) Remove field from module_name_cstm table 2) Remove file from custom/extension/modules/<Yourmodule>/Ext/Vardefs/sugarfield_<Field name>.php 3) Remove field from all the view if you have added any.   Do quick repair & rebuild.   Reference: https://community.sugarcrm.com/thread/26711  

SugarCRM

SugarCRM: MySQL Query Update Contacts

Posted on

Query 1 Adds Vendedor = 1 To All Contacts that are Joined to a Manufacturer     UPDATE contacts INNER JOIN a26_proveedor_contacts_c ON contacts.id = a26_proveedor_contacts_c.a26_proveedor_contactscontacts_idb INNER JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c SET contacts_cstm.vendedor_c = 1   Query 2 Adds Cerrado = 1 To All Contacts that are Joined to a Lead that's Closed.   […]

SugarCRM

SugarCRM: IMAP Setting

Posted on

Requirements: - Mail server needs on SugarCRM needs-- Inbound Email cannot function without the IMAP c-client libraries enabled/compiled with the PHP module. Please contact your administrator to resolve this issue.

MySQL

MySQL: Assign Opportunities to User based on Parent Account

Posted on

Query to Select List:   SELECT * FROM opportunities LEFT JOIN accounts_opportunities ON accounts_opportunities.opportunity_id = opportunities.id LEFT JOIN accounts ON accounts_opportunities.account_id = accounts.id WHERE accounts.assigned_user_id = '7077c616-4f2c-f966-d9b6-5581807bae86';     UPDATE Query: UPDATE opportunities x LEFT JOIN accounts_opportunities y ON y.opportunity_id = x.id LEFT JOIN accounts z ON y.account_id = z.id SET x.assigned_user_id = '7077c616-4f2c-f966-d9b6-5581807bae86' WHERE […]

MySQL

MySQL: Assigned Calls to User based on Parent Account or Lead

Posted on

Select List of Calls to Update: SELECT * FROM calls LEFT JOIN accounts ON calls.parent_id = accounts.id LEFT JOIN leads ON calls.parent_id = leads.id WHERE ( accounts.assigned_user_id = '7077c616-4f2c-f966-d9b6-5581807bae86' OR leads.assigned_user_id = '7077c616-4f2c-f966-d9b6-5581807bae86' ) ;   Update Query: UPDATE calls x LEFT JOIN accounts y ON x.parent_id = y.id LEFT JOIN leads z ON x.parent_id […]

SugarCRM

SugarCRM: Security Suite for Custom Modules

Posted on

On regular modules, when adding a Record to a Security Group, a line is created on the 'securitygroups_records' database. When doing this on a custom module, there is no line created on this table but really created on each particular customs table (For example, securitygroups_a01_sercios_c or securitygroups_a1_competencia_c) and the conclusion is that the records are […]

SugarCRM

SugarCRM: Manually Remove Relationships

Posted on

http://forums.sugarcrm.com/f3/how-remove-custom-relationship-37781/ When you create a new relationship through Admin -> Studio -> <Module Name> -> Relationships, Sugar create several files at custom folders: Left Side Hand Relationship (module from which you created the relationship): custom/Extension/modules/<ModuleName>/Ext/Vardefs/<relationship_name>.php custom/Extension/modules/<ModuleName>/Ext/Layoutdefs/<relationship_name>.php custom/Extension/modules/<ModuleName>/Ext/Language/<relationship_name>.php Right Side Hand Relationship: custom/Extension/modules/<ModuleName>/Ext/Vardefs/<relationship_name>.php custom/Extension/modules/<ModuleName>/Ext/Language/<relationship_name>.php Relationship itself: custom/metadata/<relationship_name>Meta.php Table Dictionary: custom/Extension/application/Ext/TableDictionary/<relationship_name>.php After removing all these files you […]

SugarCRM

GOOGLE: Google Maps iframe based on Variables

Posted on

OFFICIAL EMBED GUIDE https://developers.google.com/maps/documentation/embed/guide OFFICIAL WEB SERVICE COMMANDS https://developers.google.com/maps/documentation/webservices/   ZOOM Level: Not all applicable to Embeds https://developers.google.com/maps/documentation/staticmaps/?csw=1#Zoomlevels   ACCOUNTS https://www.google.com/maps/embed/v1/search?key=APIKEY&q=%20{name}%20+%20{a01_pais_accounts_name}%20+%20{a01_estados_accounts_name}%20 LEADS https://www.google.com/maps/embed/v1/search?key=APIKEY&zoom=6&q={a01_pais_leads_name},{account_name} Note that the fields shown between {} are custom fields I have created on my installation to serve my particular interest, you muy add the variables you want to be pulled from […]

SugarCRM

SugarCRM: Studio not updating column Width

Posted on

I decided to upgrade my server from Ubuntu 12.04 to 14.04 (switched the server) and suddenly I could not edit the variables column widths from the Studio Web Interface. I read some blogs which said some possible problems on the compatibility of Sugar CRM and PHP5.5. I did a test downloading and installing a new […]

SugarCRM

SugarCRM: Agregar numero de cotizacion

Posted on

http://www.sugarcrm.com/forums/f6/how-create-autogenerated-field-63662/ Hi , Try this 1) create one Text field name 'opp_code_c' keep it in all views through studio in Opportunity modules 2) in custom/modules/Opportunities/logic_hooks.php (see attachment) (add lines on existing file do not overwrite) 3) in custom/modules/Opportunities/add_code_hook.php (see attachmehcnt) 4) Then go to admin-> repair->quick repair and rebuild Archivos de soporte en el Dropbox, \Dropbox\ops\Sistemas\Scripts\Add Code […]